alert('Verification Code Error!');"; echo ""; exit(); } $meetingroom=& $_POST; while (list($key, $value) = each($meetingroom)) { $meetingroom[$key]=trim($value); } $meetingroom['purpose']=intval($meetingroom['purpose']); $meetingroom['lang']=intval($meetingroom['lang']); for($i=1;$i<=$n;$i++){ $meetingroom['usedate'.$i]=$meetingroom['year'.$i]."|".$meetingroom['month'.$i]."|".$meetingroom['date'.$i]."|".$meetingroom['hours'.$i]."|".$meetingroom['minutes'.$i]."|".$meetingroom['houre'.$i]."|".$meetingroom['minutee'.$i]; if($meetingroom['year'.$i]=="2008"&&$meetingroom['month'.$i]=="1"&&$meetingroom['date'.$i]=="1"){ $meetingroom['usedate'.$i]=""; } } $sql_check="select * from meetingroom order by id desc limit 1"; $query_check=mysql_query($sql_check,$conn) or die("error".mysql_error()); $num_check=mysql_num_rows($query_check); $result_check=mysql_fetch_assoc($query_check); $check_flag=0; if($num_check==0){ $check_flag=1; }else{ foreach($result_check as $key=>$value){ if(addslashes($result_check[$key])!=$meetingroom[$key]&&$key!='id'&&$key!='regdate'&&$key!='insdate'){ $check_flag=1; break; } } } if($check_flag==0){ echo ""; echo ""; exit(); }else{ $sql_add = "insert into meetingroom (mbscid,company_c,company_e,company_p,company_o,personnum,contact_person,contact_tel,contact_mobile,contact_fax,contact_email,usedate1,usedate2,usedate3,usedate4,usedate5,usedate6,usedate7,usedate8,usedate9,usedate10,purpose,other,following,lang,regdate) values('{$meetingroom['mbscid']}','{$meetingroom['company_c']}','{$meetingroom['company_e']}','{$meetingroom['company_p']}','{$meetingroom['company_o']}','{$meetingroom['personnum']}','{$meetingroom['contact_person']}','{$meetingroom['contact_tel']}','{$meetingroom['contact_mobile']}','{$meetingroom['contact_fax']}','{$meetingroom['contact_email']}','{$meetingroom['usedate1']}','{$meetingroom['usedate2']}','{$meetingroom['usedate3']}','{$meetingroom['usedate4']}','{$meetingroom['usedate5']}','{$meetingroom['usedate6']}','{$meetingroom['usedate7']}','{$meetingroom['usedate8']}','{$meetingroom['usedate9']}','{$meetingroom['usedate10']}',{$meetingroom['purpose']},'{$meetingroom['other']}',0,{$meetingroom['lang']},now())"; $query_add=mysql_query($sql_add,$conn) or die("error".mysql_error()); $sql_log = "insert into formlog (formbel) values(2)"; $query_log=mysql_query($sql_log,$conn) or die("error".mysql_error()); ini_set("SMTP","smtp.macau.ctm.net"); $send_email = $meetingroom['contact_email']; $send_subject = "=?utf-8?B?".base64_encode('Form application alert')."?="; $send_headers = "MIME-Version: 1.0\r\n"; $send_headers .= "Content-type: text/html; charset=utf-8\r\n"; $send_headers .= "From: ".$send_email; //$send_to="lei@microchina.com"; $send_to="mbsc@ipim.gov.mo,fmak@ipim.gov.mo,chan@ipim.gov.mo,twh@ipim.gov.mo"; $send_html="Note:

There is a new application form( Meeting Room Reservation Form - English ) has been submitted, please check it in time!

".date("Y-m-d H:i"); if(mail($send_to, $send_subject, $send_html, $send_headers)) { } else { echo "Email Error!"; } ini_restore("SMTP"); ini_set("SMTP","smtp.macau.ctm.net"); $send_email2 = "mbsc@ipim.gov.mo"; $send_subject2 = "=?utf-8?B?".base64_encode('MBSC Auto-reply')."?="; $send_headers2 = "MIME-Version: 1.0\r\n"; $send_headers2 .= "Content-type: text/html; charset=utf-8\r\n"; $send_headers2 .= "From: ".$send_email2; //$send_to2="lei@microchina.com"; $send_to2=$meetingroom['contact_email']; $send_html2=" Dear Mr./ Ms. ".$meetingroom['contact_person']."

Thank you for using the service of Macao Business Support Centre (MBSC). Your application (Meeting Room Reservation Form) requested on ".date("Y-m-d H:i")." has already been received and will be processed.

For more information, please do not hesitate to contact our Centre (Tel:+853 28728212, Fax:+853 28727123 or email: mbsc@ipim.gov.mo). "; if(mail($send_to2, $send_subject2, $send_html2, $send_headers2)) { } else { echo "Email Error!"; } ini_restore("SMTP"); echo "


Success！"; echo "Back"; exit(); } } ?>

Meeting Room Reservation Form    
 
MBSC ID No.: *
Company/Organization: *
Chinese (if applicable) :
Portuguese (if applicable) :
Other languages (if applicable) :
No. of person: *
 
Contact information:
Contact person: *
Tel: * Mobile:
Fax: * E-mail: *
 
Please select the dates of usage:
Requested date of usage: Y M D* Requested time: Fr.: : to: : *
Purpose: Meeting Interview Others *
Verification Code:
Note: * = Required field
 
Remarks:
  • All activities must be business related, admission and any direct sales which involving payment of exchange are not allowed;
  • Confirmation will be notified by MBSC after the reservation is verified. Please make your arrangements known to the centre as soon as possible after the notification is received;
  • User is responsible for restoring function rooms to condition noted on arrival. He/She is liable for any damage caused to used areas;
  • We reserved the right to refuse any further usage of the facilities if the actual content of the activity does not tally with the issues stated in the request form. Under no circumstances will the centre accept any legal responsibility for the content neither of the presentations nor of any views held and expressed by any of the speakers. The centre reserves the ultimate right in using the facilities and equipment of the center.
I understand that the above requested arrangements will not be guaranteed.
 
Additional Information would be required by MBSC if necessary.