/*************************************************\
| Customer Event Mod                               |
|                                                 |
| BCS Engineering                                 |
| Copyright (c) 2005 BCS Engineering,             |
| Carrie L. Saunders   |
| All rights reserved.                            |
| See http://www.bcsengineering.com/license.shtml |
| for full license                                |
| For X-cart versions 4.0.X                       |
\*************************************************/


NOTE:  You should always make a back-up copy of your files and/or database before installing any modification.


INSTALLATION:

1. Log into your Admin interface and copy and paste the SQL queries in patch.sql into the Patch/Upgrade sql utility.
  (You can put them all in at once)


2. Upload the files into their appropriate directories.


3. Add to skin1/admin/menu.tpl:
	{* BCSE Begin *}
	<A href="{$catalogs.admin}/customer_event.php" class="VertMenuItems">Customer Event Manager</A><BR>
	{* BCSE End *}

Before:
{/capture}


4. Add to skin1/common_templates.tpl:
	{* BCSE Begin *}
	{elseif $main eq "customer_event"}
	{include file="admin/main/customer_event.tpl"}
	{* BCSE End *}

After first {if}{include} pair


5. Add to skin1/customer/main/register.tpl:
	{* BCSE Begin *}
	{include file="main/register_events.tpl"}
	{* BCSE End *}

Before:
	<TR>
	<TD colspan="3" align="center">
	<BR><BR>
	{if $newbie eq "Y"}
	{$lng.txt_you_are_agree} <A href="help.php?section=conditions" target="_blank"><FONT class="Text">{$lng.lbl_terms_n_conditions}</FONT></A>.
	{/if}
	</TD>
	</TR>


6. Add to include/register.php

  A)
	# BCSE Begin
	$per_login=array_pop(func_query_first("select value from events_config where name='per_login'"));
	$user_events=func_query("select eventid,customer_events.login,event_description,event_time from customer_events left join $sql_tbl[customers] using (login) where $sql_tbl[customers].login='$login' order by eventid");
	$letter_array=array("A","B","C","D","E");
	$smarty->assign("letter_array",$letter_array);
	$smarty->assign("per_login",$per_login);
	$smarty->assign("user_events",$user_events);
	# BCSE End

After:
	x_session_register("profile_modified_data");
	x_session_register("profile_modified_add_field");

  B)
	# BCSE Begin
	if(!empty($events)){
		$days_array=array($ADay,$BDay,$CDay,$DDay,$EDay);
		$months_array=array($AMonth,$BMonth,$CMonth,$DMonth,$EMonth);
		foreach($events as $key=>$eventid){
			if($eventid){
				if($event_input[$key]){
				$event_time=mktime(0,0,0,$months_array[$key],$days_array[$key],"1990");
				$result=db_query("update customer_events set event_description='$event_input[$key]',event_day='$days_array[$key]',event_month='$months_array[$key]',event_time='$event_time' where eventid='$eventid'");
				}else	$result=db_query("delete from customer_events where eventid='$eventid'");
			}elseif($event_input[$key]){
			$event_time=mktime(0,0,0,$months_array[$key],$days_array[$key],"1990");
			$result=db_query("insert into customer_events (login,event_month,event_day,event_description,event_time) values ('$login','$months_array[$key]','$days_array[$key]','$event_input[$key]','$event_time')");
			}
		}
	}	
	# BCSE End

Before:
	db_query("DELETE FROM $sql_tbl[register_field_values] WHERE login = '$login'");
	if($additional_values) {

  C)
	# BCSE Begin
	if(!empty($events)){
		$days_array=array($ADay,$BDay,$CDay,$DDay,$EDay);
		$months_array=array($AMonth,$BMonth,$CMonth,$DMonth,$EMonth);
		foreach($events as $event=>$value){
			if($event_input[$event]){
				$event_time=mktime(0,0,0,$months_array[$event],$days_array[$event],"1990");
				$result=db_query("insert into customer_events (login,event_month,event_day,event_description,event_time) values ('$uname','$months_array[$event]','$days_array[$event]','$event_input[$event]','$event_time')");
			}
		}
	}
	# BCSE End

Before:
	$new_user_flag = true;

	if(!empty($active_modules['SnS_connector']) && $usertype == 'C') 
		func_generate_sns_action("Register");