WKCDA - Index

=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.=''; $email_template.=' '; $email_template.=' '; $email_template.=' '; $email_template.=' '; $email_template.=' '; $email_template.=' '; $email_template.=' '; $email_template.=' '; $email_template.=' '; $email_template.=' '; $email_template.=' '; $email_template.=' '; $email_template.=' '; $email_template.=' '; $email_template.=' '; $email_template.=' '; $email_template.=' '; $email_template.=' '; $email_template.=' '; $email_template.=' '; $email_template.=' '; $email_template.=' '; $email_template.=' '; $email_template.=' '; $email_template.=' '; $email_template.=' '; $email_template.=' '; $email_template.=' '; $email_template.=' '; $email_template.=' '; $email_template.=' '; $email_template.=' ';// (Normal/Waiting) $email_template.=' '; $email_template.=' '; $email_template.=' '; $email_template.='

Name of registrant		'.html_entity_decode($name,ENT_QUOTES,"UTF-8").'
Tel		'.html_entity_decode($telephone,ENT_QUOTES,"UTF-8").'
Email		'.html_entity_decode($email,ENT_QUOTES,"UTF-8").'
IP		'.html_entity_decode($_SERVER['REMOTE_ADDR'],ENT_QUOTES,"UTF-8").'
Ref No		'.html_entity_decode($snum,ENT_QUOTES,"UTF-8").'
Submit Date/Time		'.date("Y-m-d H:i:s").'
Status		'.(($exist_forum_total>=$database_forum_quota[$forum_id]["quota_limit_alert"])?"Waiting":"Normal").'

'; $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(); ?> WKCDA - Index

"1"){ print '列印此頁'; } }elseif ($_SESSION['langid'] == $langsc){ if ($_GET['print'] <> "1"){ print '列印此页'; } }else{ if ($_GET['print'] <> "1"){ print 'Print this Page'; } } ?>