<?
include "settings.php";

if (isset($btnExtraInfo)):
	if (!isset($AreaID)):
		$Areas="";
	else:
		$Areas=implode(",",$AreaID);	
	endif;
	$dbQueryCheck="select * from mm_extrainfo where SubscriberID=$SubscriberID and isPrivate='0'";
	$dbResultCheck=mysql_query($dbQueryCheck,$db->dbLinkID);
	if (mysql_num_rows($dbResultCheck)==0):
		$dbQueryRecord="insert into mm_extrainfo (";
		$dbQueryRecord.="SubscriberID, ";
		$dbQueryRecord.="Salute, ";
		$dbQueryRecord.="FirstName, ";
		$dbQueryRecord.="LastName, ";
		$dbQueryRecord.="Address, ";
		$dbQueryRecord.="City, ";
		$dbQueryRecord.="StateID, ";
		$dbQueryRecord.="CountryID, ";
		$dbQueryRecord.="Phone, ";
		$dbQueryRecord.="Fax, ";
		$dbQueryRecord.="GalleryID, ";
		$dbQueryRecord.="isPrivate, ";
		$dbQueryRecord.="AreaIDs) ";
		$dbQueryRecord.="values (";
		$dbQueryRecord.="$SubscriberID, ";
		$dbQueryRecord.="'$Salute', ";
		$dbQueryRecord.="'$FirstName', ";
		$dbQueryRecord.="'$LastName', ";
		$dbQueryRecord.="'$Address', ";
		$dbQueryRecord.="'$City', ";
		$dbQueryRecord.="$StateID, ";
		$dbQueryRecord.="$CountryID, ";
		$dbQueryRecord.="'$Phone', ";
		$dbQueryRecord.="'$Fax', ";
		$dbQueryRecord.="0, ";
		$dbQueryRecord.="'0', ";
		$dbQueryRecord.="'$Areas') ";
	else:
		$dbQueryRecord="update mm_extrainfo set ";
		$dbQueryRecord.="Salute='$Salute', ";
		$dbQueryRecord.="FirstName='$FirstName', ";
		$dbQueryRecord.="LastName='$LastName', ";
		$dbQueryRecord.="City='$City', ";
		$dbQueryRecord.="Address='$Address', ";		
		$dbQueryRecord.="StateID=$StateID, ";
		$dbQueryRecord.="CountryID=$CountryID, ";
		$dbQueryRecord.="Phone='$Phone', ";
		$dbQueryRecord.="Fax='$Fax', ";
		$dbQueryRecord.="AreaIDs='$Areas' ";
		$dbQueryRecord.="where SubscriberID=$SubscriberID";
	endif;
	$db->ConnectRW();
	@mysql_query($dbQueryRecord);
	
	$Template="htmls/ThankU1.inc_html";
	$PageTitle="Subscription to ".$dbObject->Name;
	include "htmls/DisplayTemplate.inc_html";
	exit;
endif;


if (isset($btnSubscribeConfirm)):

	$dbQueryExtrainfo="select * from mm_extrainfo where SubscriberID=$SubscriberID";
	$dbResultExtrainfo=mysql_query($dbQueryExtrainfo,$db->dbLinkID);
	if (mysql_num_rows($dbResultExtrainfo)==0):
		$Salute="";
		$FirstName="";
		$LastName="";
		$Address="";
		$City="";
		$StateID=0;
		$CountryID=0;
		$Phone="";
		$Fax="";
		$AreaID="";
	else:
		$dbObjectExtrainfo=mysql_fetch_object($dbResultExtrainfo);
		$Salute=$dbObjectExtrainfo->Salute;
		$FirstName=$dbObjectExtrainfo->FirstName;
		$LastName=$dbObjectExtrainfo->LastName;
		$Address=$dbObjectExtrainfo->Address;
		$City=$dbObjectExtrainfo->City;
		$StateID=$dbObjectExtrainfo->StateID;
		$CountryID=$dbObjectExtrainfo->CountryID;
		$Phone=$dbObjectExtrainfo->Phone;
		$Fax=$dbObjectExtrainfo->Fax;
		$AreaID=$dbObjectExtrainfo->AreaIDs;
	endif;

	$dbQueryGal="select gallery.isShowGeneralArea from gallery where gallery.GalleryID=$ID";
	$dbResultGal=mysql_query($dbQueryGal,$db->dbLinkID);
	$dbObjectGal=mysql_fetch_object($dbResultGal);
	$isShowGeneralArea=$dbObjectGal->isShowGeneralArea;
		
	if ($isShowGeneralArea==1):
			$dbQueryArea="select AreaName, AreaID from area order by AreaName";			
	else:
			$dbQueryArea="select AreaName, AreaID from area where GalleryID=$ID order by AreaName";
	endif;	

	$dbResultArea=mysql_query($dbQueryArea,$db->dbLinkID);
	
	$dbQueryCountry="select CountryName, CountryID from country order by CountryName";
	$dbResultCountry=mysql_query($dbQueryCountry,$db->dbLinkID);		
	
	$dbQueryState="select StateName, StateID from state order by StateName";		
	$dbResultState=mysql_query($dbQueryState,$db->dbLinkID);
	
	$Template="htmls/ThankU.inc_html";
	$PageTitle="Subscription to ".$dbObject->Name;
	include "htmls/DisplayTemplate.inc_html";

	//$MailMessage = str_replace("\n","<br>",$dbObject->DefaultAutoResponse);	
	//$MailMessage = $dbObject->DefaultAutoResponse;	
	//$Message = implode('',file('includes/Mail.inc_txt')); 
	//eval("\$Message=\"$Message\";");
	$Message = implode('',file('includes/AutoResponse.inc_txt')); 
	eval("\$Message=\"$Message\";");	
	$To=$SubscriberEmail;
	$Subject= "Subscription confirmation from Tai Gallery / Textile Arts";
	$Header="From: $dbObject->DefaultEmail\nReturn-Path: postman@asianart.com\n";
	mail($To,$Subject,$Message,$Header);
	
	if (isset($AASubscribe)):
		$dbQueryAA="select * from gallery where Name='Asianart.com'";
		$dbResultAA=mysql_query($dbQueryAA,$db->dbLinkID);
		$dbObjectAA=mysql_fetch_object($dbResultAA);	
		$MailMessage = $dbObjectAA->DefaultAutoResponse;	
		$ID=$dbObjectAA->GalleryID;
		$GalleryName=$dbObjectAA->Name;
		$Message = implode('',file('includes/Mail.inc_txt')); 
		
		eval("\$Message=\"$Message\";");
		$To=$SubscriberEmail;
		$Subject= "Subscription confirmation from Asianart.com";
		$Header="From: $dbObjectAA->DefaultEmail\n";
		mail($To,$Subject,$Message,$Header);
	endif;
	exit;
endif;




if (!isset($btnSubscribe)):
	$Template="htmls/Subscribe.inc_html";
	$PageTitle="Subscription to ".$dbObject->Name;
	include "htmls/DisplayTemplate.inc_html";
else:
	$isAlreadySubscribed=0;
	$isAlreadySubscribedAA=0;
	
	include "functions/functions.custom.php";
	$db->connectRW();
	$SubscribedDate=date("Y-m-d");
	$EAdd=trim($SubscriberEmail);
	if (EmailValidate($EAdd)==1):
		$Message = $InvalidEmailAddress;
		$Template="htmls/DisplayMessage.inc_html";
		$PageTitle="Subscription to ".$dbObject->Name;
		include "htmls/DisplayTemplate.inc_html";		
		exit;
	endif;
				
	$dbQueryCheck="select SubscriberID from mm_subscriber where SubscriberEmail='$EAdd'";
	$dbResultCheck=mysql_query($dbQueryCheck,$db->dbLinkID);
	if (mysql_num_rows($dbResultCheck)==0):
		$Password=GeneratePassowrd(8);
		$dbQuery="insert into mm_subscriber (";
		$dbQuery.="SubscriberEmail, ";
		$dbQuery.="Password, ";
		$dbQuery.="isNew) ";
		$dbQuery.="values (";
		$dbQuery.="'$EAdd', ";
		$dbQuery.="'$Password', ";
		$dbQuery.="'1') ";
		@mysql_query($dbQuery);
		$SubscriberID=mysql_insert_id();
	else:
		$dbObjectCheck=mysql_fetch_object($dbResultCheck);
		$SubscriberID=$dbObjectCheck->SubscriberID;
	endif;

	$dbQueryCheck="select SubscriberID from mm_subscription where SubscriberID=$SubscriberID and GalleryID=$ID and isPrivate='0'";
	$dbResultCheck=mysql_query($dbQueryCheck,$db->dbLinkID);
	if (mysql_num_rows($dbResultCheck)==0):
		$dbQuery1="insert into mm_subscription (";
		$dbQuery1.="SubscriberID, ";
		$dbQuery1.="GalleryID, ";
		$dbQuery1.="isPrivate, ";
		$dbQuery1.="SubscribedDate) ";
		$dbQuery1.="values (";
		$dbQuery1.="$SubscriberID, ";
		$dbQuery1.="$ID, ";
		$dbQuery1.="'0', ";
		$dbQuery1.="'$SubscribedDate') ";
		@mysql_query($dbQuery1);
		$SubscriptionID=mysql_insert_id();
	
		$dbQuery2="insert into mm_subscription_log (";
		$dbQuery2.="SubscriptionID, ";
		$dbQuery2.="SubscribedDate, ";
		$dbQuery2.="Host, ";
		$dbQuery2.="IP, ";
		$dbQuery2.="SubscriberID, ";
		$dbQuery2.="isPrivate, ";
		$dbQuery2.="GalleryID, ";
		$dbQuery2.="Referer) ";
		$dbQuery2.="values (";
		$dbQuery2.="$SubscriptionID, ";
		$dbQuery2.="'$SubscribedDate', ";
		$dbQuery2.="'$HTTP_HOST', ";
		$dbQuery2.="'$REMOTE_ADDR', ";						
		$dbQuery2.="$SubscriberID, ";
		$dbQuery2.="'0', ";
		$dbQuery2.="$ID, ";
		$dbQuery2.="'$HTTP_REFERER') ";
		@mysql_query($dbQuery2);
	else:
		$isAlreadySubscribed=1;
	endif;
			
	//AA.com subscription check
	if (isset($AASubscribe)):
		$dbQueryAA="select GalleryID from gallery where Name='Asianart.com'";
		$dbResultAA=mysql_query($dbQueryAA,$db->dbLinkID);
		$dbObjectAA=mysql_fetch_object($dbResultAA);
		$dbQueryCheck="select SubscriberID from mm_subscription where SubscriberID=$SubscriberID and GalleryID=$dbObjectAA->GalleryID and isPrivate='0'";
		$dbResultCheck=mysql_query($dbQueryCheck,$db->dbLinkID);
		if (mysql_num_rows($dbResultCheck)==0):
			$dbQuery1="insert into mm_subscription (";
			$dbQuery1.="SubscriberID, ";
			$dbQuery1.="GalleryID, ";
			$dbQuery1.="isPrivate, ";
			$dbQuery1.="SubscribedDate) ";
			$dbQuery1.="values (";
			$dbQuery1.="$SubscriberID, ";
			$dbQuery1.="$dbObjectAA->GalleryID, ";
			$dbQuery1.="'0', ";
			$dbQuery1.="'$SubscribedDate') ";
			@mysql_query($dbQuery1);
			$SubscriptionID=mysql_insert_id();
	
			$dbQuery2="insert into mm_subscription_log (";
			$dbQuery2.="SubscriptionID, ";
			$dbQuery2.="SubscribedDate, ";
			$dbQuery2.="Host, ";
			$dbQuery2.="IP, ";
			$dbQuery2.="Referer) ";
			$dbQuery2.="values (";
			$dbQuery2.="$SubscriptionID, ";
			$dbQuery2.="'$SubscribedDate', ";
			$dbQuery2.="'$HTTP_HOST', ";
			$dbQuery2.="'$REMOTE_ADDR', ";						
			$dbQuery2.="'$HTTP_REFERER') ";
			@mysql_query($dbQuery2);
		else:
			$isAlreadySubscribedAA=1;
		endif;			
	endif;
	if ($isAlreadySubscribed==1):
		$Message=$DuplicateSubscribe;
		$Template="htmls/DisplayMessage.inc_html";
		$PageTitle="Subscription to ".$dbObject->Name;
		include "htmls/DisplayTemplate.inc_html";		
		exit;
	endif;
	$Template="htmls/SubscribeConfirm.inc_html";
	$PageTitle="Subscription to ".$dbObject->Name;
	include "htmls/DisplayTemplate.inc_html";		
endif;
?>