<?
# time zone setting for php5 only
if(substr(phpversion(),0,1)>=5){
	date_default_timezone_set("Asia/Hong_Kong");
}

if (isset($_GET['cfimg']))  session_start();
else include_once("./include.php");
if($_SERVER["HTTP_HOST"]!="wkcda.devprj.com"){
	
	if($_SERVER["QUERY_STRING"]!=""){
		$query_string="?".$_SERVER["QUERY_STRING"];
	}
	if($_SERVER["HTTPS"]=="off" || $_SERVER["HTTP_HOST"]!="www.wkcda.hk"){
		$url="https://www.wkcda.hk".$_SERVER["PHP_SELF"].$query_string;
		header("Location: ".$url);
		exit;
	}
	
}

if($_REQUEST['istext'] == "1" || $_GET['istext']== "1"){
	$istext="&istext=1";
	$_GET['istext']=$_REQUEST['istext'];
}

$langpath = array('','en','tc','sc');
include_once('./include/mp3captchaform.php');

$langid = $_GET['langid'];
if($langid == "" and $_GET['cfimg']=="" and !$issubmit and $_GET['cfsnd']=="" and $_GET["fclang"]==""){
	$langid = 1;
	header("Location: ".$_SERVER["PHP_SELF"]."?langid=".$langid);
	exit;
}

if($_GET['pop'] == '1' or $_POST['pop'] == '1'){
	$pop = '1';
}

# online registration quota
$lesson_quota=array(); // initial variable type, don't do any amendment

# online registration quota defination
# if quota over the defined value, then the lesson will show full quota and disable the checkbox
# usage:
# $lesson_quota - variable name
# [1] - 1 is the database ID number
#
# example:
# $lesson_quota[1] = 100; // assign 100 quota for lesson 1
# $lesson_quota[2] = 100; // assign 100 quota for lesson 2 
# $lesson_quota[4] = 100; // assign 100 quota for lesson 4 
$lesson_quota[1]=5;
$lesson_quota[2]=5;


//--- captcha: http://scripts.titude.nl/demo/captcha/ ---//
$mp3captcha= new mp3captcha();
$mp3captcha->url = $_SERVER['SCRIPT_NAME'];
$mp3captcha->langswitch();
if (isset($langFRegCheckword[$_SESSION['langid']]))  $mp3captcha->getCaptchaText($langFRegCheckword[$_SESSION['langid']]);
if (isset($_GET['cfsnd'])) {
  $mp3captcha->mp3stitch($_SESSION["captcha"]);
} else if (isset($_GET['cfimg'])) {
  $mp3captcha->backgrounds = array("mp3CaptchaBg2.jpg");
  $mp3captcha->image();
}
$map_text[1] = 'Map';
$map_text[2] = '地圖';
$map_text[3] = '地图';
$img_title[1] = 'Online Registration';
$img_title[2] = '網上登記';
$img_title[3] = '网上登记';
$errmsg = "";
$errname = "";
$erremail = "";
$errtel = "";
$errchkword = "";
$errchoice = "";

$name = getDymVal("name", "");
$email = getDymVal("email", "");
$telephone = getDymVal("telephone", "");
$choice = getDymVal("choice", "");
$chkword = getDymVal("captcha_code", "");
$agree = getDymVal("agree", "");
$issubmit = getDymVal("issubmit", "");


if ($issubmit) {

  $updid = -1;
  if (strlen(trim($name)) <= 0)  $errname = $langFRegErrNameReq[$_SESSION['langid']];
  //if (strlen(trim($telephone)) <= 0 && strlen(trim($email)) <= 0)  $errtel = $langFRegErrTelReq[$_SESSION['langid']];
  if ((strlen(trim($telephone)) < 8))  $errtel = $langFRegErrTelReq[$_SESSION['langid']];
  
  //if (strlen(trim($email)) <= 0 && strlen(trim($telephone)) <= 0)  $erremail = $langFRegErrEmailReq[$_SESSION['langid']];
  if (strlen(trim($email)) <= 0)  $erremail = $langFRegErrEmailReq[$_SESSION['langid']];
  else {
    if (!isValidEmail($email) && strlen(trim($email)) > 0)  $erremail = $langFRegErrEmailFmt[$_SESSION['langid']];
  }//end-if
  if (strlen(trim($choice)) <= 0)  $errchoice = $langFRegErrChoiceReq[$_SESSION['langid']];

  if (strlen(trim($chkword)) <= 0)  $errchkword = $langFRegErrChkWordReq[$_SESSION['langid']];
  else {
    if (!empty($_SESSION['captcha_mp3']) && $_SESSION['captcha_mp3'] != strtolower($chkword))
      $errchkword = $langFRegErrChkWordWrong[$_SESSION['langid']];
  }
  if (!$mp3captcha->post())  $errchkword = $langFRegErrChkWordReq[$_SESSION['langid']];

  $regid = -1;
  $indbins = 0;
  
  if (strlen($errname) <= 0 && strlen($erremail) <= 0 && strlen($errtel) <= 0  && strlen($errchoice) <= 0 && strlen($errchkword) <= 0 && $serialNumPrefix[$choice]!="") {
	
	# check existing record
	$frdb = new fregdbhandle();
	$frdb->db_connect();
	$squery = "SELECT count(*) as total_record ".
			  "FROM registration WHERE".
			  " name='".mysql_real_escape_string($name)."'".
			  " and email='".mysql_real_escape_string($email)."'".
			  " and telephone='".mysql_real_escape_string($telephone)."'";
	$sql_array = $frdb->select($squery);
	$frdb->db_close();
	
	//print_r($sql_array);
	//exit;
	if(is_array($sql_array) and count($sql_array)>0 and $sql_array[0]["total_record"]>0 ){
		
		if ($_SESSION['langid'] == $langtc){
			$errchoice = "這組姓名、電話號碼和電郵地址已經登記。";
			
		}else if ($_SESSION['langid'] == $langsc){
			$errchoice = "这组姓名、电话号码和电邮地址已经登记。";
			
		}else{
			$errchoice = "The same name, telephone number and email address have been registered before.";
		}
	}else{
	
		$indbins = 1;
		$fridb = new fregdbhandle();
		$fridb->db_connect();
		$indbins = 1;
		$iq = "INSERT INTO registration(name, email, telephone, choice, createdate, create_ip) VALUES (".
				"'".mysql_real_escape_string($name)."', ".
				"'".mysql_real_escape_string($email)."', ".
				"'".mysql_real_escape_string($telephone)."', ".
				"'".mysql_real_escape_string($choice)."', SYSDATE(), '".mysql_escape_string($_SERVER['REMOTE_ADDR'])."')";
		$rsin = $fridb->execute($iq);
		$regid = $fridb->insert_id();
		$snum = $serialNumPrefix[$choice].$serialNumDelimiter.str_pad($regid, $serialNumMinLength, $serialNumPadding, STR_PAD_LEFT);
		# get forum setting
		$frdb = new fregdbhandle();
		$frdb->db_connect();
		$squery = "select * from wkcda_pe3_forum_setting order by forum_id";
		$sql_array = $frdb->select($squery);
		if(is_array($sql_array) and count($sql_array)>0){
			foreach($sql_array as $index => $fields){
				$database_forum_quota[$fields["forum_id"]]=$fields;
			}
		}
		$frdb->db_close();

		$forum_character_array=split("-",$snum);
		$forum_character=$forum_character_array[0];

		$temp_array=array_keys($serialNumPrefix,$forum_character);
		$forum_id=$temp_array[0];
		
		# get normal / waiting status
		$frdb = new fregdbhandle();
		$frdb->db_connect();
		# retrieve serial number related to which forum
		$squery = "select count(*) as total from registration where (id<'".$regid."' and serialnum like '%".$forum_character."%') or (join_status='' and id='".$regid."')";
		//echo $squery;
		$sql_array = $frdb->select($squery);
		$exist_forum_total=$sql_array[0]["total"];
		
		$uq = "UPDATE registration SET serialnum = '".$snum."', join_status='".mysql_real_escape_string((($exist_forum_total>=$database_forum_quota[$forum_id]["quota_limit_alert"])?"Waiting":"Normal"))."' WHERE id = ".$regid;
		$rsupd = $fridb->execute($uq);
		$fridb->db_close();
		
		include_once("../wq/include/smtp.class.php");
		$mail=new smtp_class;
		
		# email setting
		$__config["mailsetting"]=array(); // do not modify
		$__config["mailsetting"]["fromname"]	= "Webmaster";
		$__config["mailsetting"]["fromemail"]	= "";
		$__config["mailsetting"]["Host"]		= "127.0.0.1";  // SMTP server. 
		$__config["mailsetting"]["Port"]		= 25;  // SMTP port. Default: 25; 
		$__config["mailsetting"]["Timeout"]		= 10;  // SMTP connection timeout. Default: 10; 
		$__config["mailsetting"]["Timezone"]	= "+0800";  // Time Zone. Default: "+0000"; 
		$__config["mailsetting"]["Priority"]	= 3;  // Email priority Default: 3 (1=High,3=Medium or 5=Low); 
		$__config["mailsetting"]["CharSet"]		= "utf-8";  // Character set. 
		$__config["mailsetting"]["WordWrap"]	= 0;  // characters per line. 0 for umlimit characterc per line 
		$__config["mailsetting"]["IsHTML"]		= true;  // HTML email. Default: false (true or false); 
		$__config["mailsetting"]["MailerDebug"]	= true;  // Display SMTP error. Default: false (true or false); 
		$__config["mailsetting"]["AuthLogin"]	= false;  // using SMTP authorization. Default: false (true or false); 
		$__config["mailsetting"]["AuthUser"]	= "login";  // SMTP username 
		$__config["mailsetting"]["AuthPass"]	= "password";  // SMTP password
		
		# email setting initialize
		$mail->Host			= $__config["mailsetting"]["Host"];  // SMTP server. 
		$mail->Port			= $__config["mailsetting"]["Port"];  // SMTP port. Default: 25; 
		$mail->Timeout		= $__config["mailsetting"]["Timeout"];  // SMTP connection timeout. Default: 10; 
		$mail->Timezone		= $__config["mailsetting"]["Timezone"];  // Time Zone. Default: "+0000"; 
		$mail->Priority		= $__config["mailsetting"]["Priority"];  // Email priority Default: 3 (1=High,3=Medium or 5=Low); 
		$mail->CharSet		= $__config["mailsetting"]["CharSet"];  // Character set. 
		$mail->WordWrap		= $__config["mailsetting"]["WordWrap"];  // characters per line. 0 for umlimit characterc per line 
		$mail->IsHTML		= $__config["mailsetting"]["IsHTML"];  // HTML email. Default: false (true or false); 
		$mail->MailerDebug	= $__config["mailsetting"]["MailerDebug"];  // Display SMTP error. Default: false (true or false); 
		$mail->AuthLogin	= $__config["mailsetting"]["AuthLogin"];  // using SMTP authorization. Default: false (true or false); 
		$mail->AuthUser		= $__config["mailsetting"]["AuthUser"];  // SMTP username 
		$mail->AuthPass		= $__config["mailsetting"]["AuthPass"];  // SMTP password
		
		# send activation email to user
		# email address and content start here
		
		//print_r($charset_array);
		# get language pack
		
		//$from_email="alan.ngai@westcomzivo.com";
		$from_email="no_reply@wkcda.hk";
		
		//$to_email="wkcda.test@gmail.com"; # client test email
		$to_email="rsvp_wkcd@golinharris.com"; # client production email
		//$to_email="alan.ngai@westcomzivo.com"; # our test email
		
		//$mail->From("wkcda.test@gmail.com"); # client test email
		//$mail->From("rsvp_wkcd@golinharris.com"); # client production email
		$mail->From($from_email,$from_email); # our test email
		$mail->Subject=html_entity_decode("Register Notification",ENT_QUOTES,"UTF-8");
		
		# if email not valid then continue
		//if(!$function->check_email($email_sql_row["remail"])){
			//continue;
		//}


		# random key generation
		# get_access_key(10) - function name (key length)
		
		# get the email template
		$email_template='';
		$email_template.='<head/><table>';
		$email_template.='	<tr>';
		$email_template.='		<td nowrap>Name of registrant</td>';
		$email_template.='		<td nowrap>&nbsp;</td>';
		$email_template.='		<td nowrap>'.html_entity_decode($name,ENT_QUOTES,"UTF-8").'</td>';
		$email_template.='	</tr>';
		$email_template.='	<tr>';
		$email_template.='		<td nowrap>Tel</td>';
		$email_template.='		<td nowrap>&nbsp;</td>';
		$email_template.='		<td nowrap>'.html_entity_decode($telephone,ENT_QUOTES,"UTF-8").'</td>';
		$email_template.='	</tr>';
		$email_template.='	<tr>';
		$email_template.='		<td nowrap>Email</td>';
		$email_template.='		<td nowrap>&nbsp;</td>';
		$email_template.='		<td nowrap>'.html_entity_decode($email,ENT_QUOTES,"UTF-8").'</td>';
		$email_template.='	</tr>';
		$email_template.='	<tr>';
		$email_template.='		<td nowrap>IP</td>';
		$email_template.='		<td nowrap>&nbsp;</td>';
		$email_template.='		<td nowrap>'.html_entity_decode($_SERVER['REMOTE_ADDR'],ENT_QUOTES,"UTF-8").'</td>';
		$email_template.='	</tr>';
		$email_template.='	<tr>';
		$email_template.='		<td nowrap>Ref No</td>';
		$email_template.='		<td nowrap>&nbsp;</td>';
		$email_template.='		<td nowrap>'.html_entity_decode($snum,ENT_QUOTES,"UTF-8").'</td>';
		$email_template.='	</tr>';
		$email_template.='	<tr>';
		$email_template.='		<td nowrap>Submit Date/Time</td>';
		$email_template.='		<td nowrap>&nbsp;</td>';
		$email_template.='		<td nowrap>'.date("Y-m-d H:i:s").'</td>';
		$email_template.='	</tr>';
		$email_template.='	<tr>';
		$email_template.='		<td nowrap>Status</td>';//	(Normal/Waiting)
		$email_template.='		<td nowrap>&nbsp;</td>';
		$email_template.='		<td nowrap>'.(($exist_forum_total>=$database_forum_quota[$forum_id]["quota_limit_alert"])?"Waiting":"Normal").'</td>';
		$email_template.='	</tr>';
		$email_template.='<table>';

		$mail->To=array();
		$mail->AddTo($to_email,$to_email);
		//$mail->AddBcc("alan.ngai@westcomzivo.com","alan.ngai@westcomzivo.com");
		$mail->Body=$email_template;
		if($mail->Send()){
			//echo "email sent";
		}
				
		
	}
  }//end-if-strlen-err=0

  if ($regid > 0) {
	header("Location: ./forumregsuccess.php?id=".$regid."&langid=".$langid."&pop=".$pop.$istext);
	exit;
  } else {
	if ($indbins)  $errmsg = $langFRegErrDb[$_SESSION['langid']];
  }
}//end-if-$issubmit

$squery = "SELECT *,  ".
          "DATE_FORMAT(startdate, '%e %M %Y (%W)') dissdate, ".
          "DATE_FORMAT(deadline, '%e %M %Y (%W)') disddate, ".
          "DATE_FORMAT(startdate, '%Y') sdyy, DATE_FORMAT(startdate, '%c') sdmm, DATE_FORMAT(startdate, '%e') sddd, ".
          "DATE_FORMAT(startdate, '%w') sddw, DATE_FORMAT(startdate, '%l') sdhh, DATE_FORMAT(startdate, '%i') sdii, ".
          "DATE_FORMAT(startdate, '%p') sdap, ".
          "DATE_FORMAT(enddate, '%Y') edyy, DATE_FORMAT(enddate, '%c') edmm, DATE_FORMAT(enddate, '%e') eddd, ".
          "DATE_FORMAT(enddate, '%w') eddw, DATE_FORMAT(enddate, '%l') edhh, DATE_FORMAT(enddate, '%i') edii, ".
          "DATE_FORMAT(deadline, '%Y') ddyy, DATE_FORMAT(deadline, '%c') ddmm, DATE_FORMAT(deadline, '%e') dddd, ".
          "DATE_FORMAT(deadline, '%w') dddw, DATE_FORMAT(deadline, '%l') ddhh, DATE_FORMAT(deadline, '%i') ddii, ".
          "DATE_FORMAT(deadline, '%p') ddap ".
          "FROM forum WHERE ispublic = 1";
$frdb = new fregdbhandle();
$frdb->db_connect();
$fmrs = $frdb->select($squery);
$frdb->db_close();

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
    <title>WKCDA - Index</title>
	<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
    <script type="text/javascript" src="/pe3/filemanager/system//js/template1.js" charset="utf-8"></script>
	<script type="text/javascript" src="/pe3/filemanager/system//js/menu.js" charset="utf-8"></script>
    <script type="text/javascript">
		
        var last_revision_date = '';
        <?
        if ($_GET['pop'] == '1' or $_POST['pop'] == '1'){
          echo 'pop = true;'."\n"; 
        }else{
          echo 'pop = false;'."\n"; 
        }
        
        ?>
	    var url = location.href;
	    if (url.indexOf("?print=1")==-1 && url.indexOf("&print=1")==-1) {
	    	    ShowHeader();
	    } else {
	    	    ShowPrintHeader();
	    }
	</script>
    <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
      <meta http-equiv="expires" content="0">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="pragma" content="no-cache, no-store, must-revalidate">
    <link media="screen" type="text/css" rel="stylesheet" href="/pe3/filemanager/template/common/css/index.css"/>
    
    <script src="/pe3/filemanager/template/common/js/jquery-1.4.2.min.js+jq_control.js.pagespeed.jc.v7RJ1YxBmv.js"></script><script>eval(mod_pagespeed_$NXfZoZaIh);</script>
    <script>eval(mod_pagespeed_vRPDnm8X9O);</script>
    <script type="text/javascript" language="JavaScript">
//--- *** start show/hide layer *** ---//
<!-- Copyright 2006,2007 Bontrager Connection, LLC
// http://bontragerconnection.com/ and http://www.willmaster.com/
// Version: July 28, 2007

var cX = 0; var cY = 0; var rX = 0; var rY = 0;
function UpdateCursorPosition(e){ cX = e.pageX; cY = e.pageY;}
function UpdateCursorPositionDocAll(e){ cX = event.clientX; cY = event.clientY;}
if(document.all) { document.onmousemove = UpdateCursorPositionDocAll; }
else { document.onmousemove = UpdateCursorPosition; }
function AssignPosition(d) {
if(self.pageYOffset) {
	rX = self.pageXOffset;
	rY = self.pageYOffset;
	}
else if(document.documentElement && document.documentElement.scrollTop) {
	rX = document.documentElement.scrollLeft;
	rY = document.documentElement.scrollTop;
	}
else if(document.body) {
	rX = document.body.scrollLeft;
	rY = document.body.scrollTop;
	}
if(document.all) {
	cX += rX; 
	cY += rY;
	}
d.style.left = (cX+10) + "px";
d.style.top = (cY+10) + "px";
}
function HideContent(d) {
if(d.length < 1) { return; }
document.getElementById(d).style.display = "none";
}
function ShowContent(d) {
if(d.length < 1) { return; }
var dd = document.getElementById(d);
AssignPosition(dd);
dd.style.display = "block";
}
function ReverseContentDisplay(d) {
if(d.length < 1) { return; }
var dd = document.getElementById(d);
AssignPosition(dd);
if(dd.style.display == "none") { dd.style.display = "block"; }
else { dd.style.display = "none"; }
}
//--- *** end show/hide layer *** ---//

var p=0; //print setting

<?
$curmainTopicNo = 3;
if (strpos($_SERVER["PHP_SELF"], 'eventcal.php') !== false)  $curmainTopicNo = 2;
?>
mainTopicNo=;
subTopic='';
var selectedSection=mainTopicNo;
var selectedSubSection=subTopic;
var revisionDate='3/9/2009'; //Date Format: MM/DD/YYYY

//-->
</script>
</head>


<?
	$pageTitle = array('','Event Information','活動資料','活动资料');
	$pageTitle = array('','Online Registration','網上登記','网上登记');
	if($_GET['istext'] == "1"){
		
?>
		<h1></h1>
<?
	}else{
?>
		<h1 class="img_title fullwidth"><img alt="<?$img_title[$_SESSION['langid']]?>" title="<?$img_title[$_SESSION['langid']]?>" class="img_text" src="/pe3/filemanager/template//images/topic_online.gif"/></h1>
<?
	}
?>

<div class="old_style">
<?

if ($_SESSION['langid'] == $langtc){
	$javascript_error["name"]["valid"]="請輸入正確的姓名";
	$javascript_error["telphone"]["valid"]="請輸入正確的電話號碼";
}elseif ($_SESSION['langid'] == $langsc){
	$javascript_error["name"]["valid"]="请输入正确的姓名";
	$javascript_error["telphone"]["valid"]="请输入正确的电话号码";
}else{
	$javascript_error["name"]["valid"]="Please input valid name";
	$javascript_error["telphone"]["valid"]="Please input valid telephone number";
}
?>
<script language="Javascript">function gosubmit(form){error=false;errorMessage="";if(document.getElementById("name").value.length<2||!document.getElementById("name").value.match(/^([\u4E00-\u9FA5]|[\uFE30-\uFFA0]|[\s\-\_\.\']|[a-zA-Z0-9])*$/gi)){errorMessage+="<? echo $javascript_error["name"]["valid"]; ?>\n";error=true;}if(document.getElementById("telephone").value.length<8||!document.getElementById("telephone").value.match(/^([\s\-\+\(\)\.]|[a-zA-Z0-9])*$/gi)){errorMessage+="<? echo $javascript_error["telphone"]["valid"]; ?>\n";error=true;}if(error){alert(errorMessage);return false;}else{var curchk="";obj=form.forum;for(i=0;i<obj.length;i++){if(obj[i].checked){curchk+=obj[i].value;break;}}document.getElementById("choice").value=curchk;document.getElementById("issubmit").value=1;return true;}}function poplocation(locid,langid){window.open('venue_map.html?loc='+locid+'&lang='+langid,'_blank','width=600,height=480');}function isenable(){if(!document.getElementById('agree').checked)document.getElementById('btnsubmit').disabled=true;else document.getElementById('btnsubmit').disabled=false;}</script>
<?
if ($_SESSION['langid'] == $langtc){
	if ($_GET['print'] <> "1"){
		print '<span style="float:right;"><a href="javascript:printPage();">列印此頁</a></span>';
	}
}elseif ($_SESSION['langid'] == $langsc){
	if ($_GET['print'] <> "1"){
		print '<span style="float:right;"><a href="javascript:printPage();">列印此页</a></span>';
	}
}else{
	if ($_GET['print'] <> "1"){
		print '<span style="float:right;"><a href="javascript:printPage();">Print this Page</a></span>';
	}
}
?>