here "; /////////////////// F U N C T I O N S ////////////////////// function get_iv() { $size = mcrypt_get_iv_size(MCRYPT_RIJNDAEL_256, MCRYPT_MODE_CBC); srand((float) microtime() * 1000000); $result_iv = mcrypt_create_iv($size, MCRYPT_RAND); return $result_iv; }///////end function check_iv function retrieve_record($CL_id) { global $mcrypt_key; $tempCLprov=$_SESSION['userCLprov']; if($tempCLprov=="BC"){$clients_db = "clients";} else if($tempCLprov=="AB"){$clients_db = "clients_ab";} else if($tempCLprov=="SK"){$clients_db = "clients_sk";} else if($tempCLprov=="MB"){$clients_db = "clients_mb";} else if($tempCLprov=="ON"){$clients_db = "clients_on";} else if($tempCLprov=="QC"){$clients_db = "clients_qc";} else if($tempCLprov=="NB"){$clients_db = "clients_nb";} else if($tempCLprov=="NS"){$clients_db = "clients_ns";} else if($tempCLprov=="PE"){$clients_db = "clients_pe";} else if($tempCLprov=="NL"){$clients_db = "clients_nl";} else if($tempCLprov=="YK"){$clients_db = "clients_yk";} else if($tempCLprov=="NW"){$clients_db = "clients_nw";} else if($tempCLprov=="NV"){$clients_db = "clients_nv";} else {$clients_db = "clients";} $requery="SELECT * FROM $clients_db WHERE CL_id='$CL_id'"; $reresult=mysql_query($requery); if(!$reresult) error_message(sql_error()); $retrieved=mysql_fetch_array($reresult); $reCL_id = $retrieved['CL_id']; $reuserCLpassword = $retrieved['userCLpassword']; $reCLfname = $retrieved['CLfname']; $reCLlname = $retrieved['CLlname']; $reCLemail = $retrieved['CLemail']; $reCLphone = $retrieved['CLphone']; $reCLaddress1 = $retrieved['CLaddress1']; $reCLaddress2 = $retrieved['CLaddress2']; $reCLcity = $retrieved['CLcity']; $reCLprov = $retrieved['CLprov']; $reCLpostal = $retrieved['CLpostal']; echo "
Username: " . $reCL_id; echo "
Email: " . $reCLemail; echo "
Phone: " . $reCLphone; echo "
Address: " . $reCLaddress1; echo " " . $reCLaddresss2; echo " " . $reCLcity; echo " " . $reCLprov; echo " " . $reCLpostal; echo "
"; $reCL_iv = $retrieved['CL_iv']; $reCLthird_co1 = $retrieved['CLthird_co1']; $reCLclaim_no1 = $retrieved['CLclaim_no1']; $rethirdptyemail1 = $retrieved['thirdptyemail1']; $reCLthird_co2 = $retrieved['CLthird_co2']; $reCLclaim_no2 = $retrieved['CLclaim_no2']; $rethirdptyemail2 = $retrieved['thirdptyemail2']; $reCLthird_co3 = $retrieved['CLthird_co3']; $reCLclaim_no3 = $retrieved['CLclaim_no3']; $rethirdptyemail3 = $retrieved['thirdptyemail3']; $reCLthird_co4 = $retrieved['CLthird_co4']; $reCLclaim_no4 = $retrieved['CLclaim_no4']; $rethirdptyemail4 = $retrieved['thirdptyemail4']; $reCLthird_co5 = $retrieved['CLthird_co5']; $reCLclaim_no5 = $retrieved['CLclaim_no5']; $rethirdptyemail5 = $retrieved['thirdptyemail5']; $mcrypt_module = mcrypt_module_open('rijndael-256', '', 'cbc', ''); $re_mcrypt_iv=base64_decode($reCL_iv); mcrypt_generic_init($mcrypt_module, $mcrypt_key, $re_mcrypt_iv); if(!empty($reCLclaim_no1)) { echo "
Payor 1: " . $reCLthird_co1; mcrypt_generic_init($mcrypt_module, $mcrypt_key, $re_mcrypt_iv); $reCLclaim_no1=mdecrypt_generic($mcrypt_module, base64_decode($reCLclaim_no1)); $reCLclaim_no1=rtrim($reCLclaim_no1, "\0"); echo "
Case # " . $reCLclaim_no1 . "
"; mcrypt_generic_deinit($mcrypt_module); } if(!empty($reCLclaim_no2)) { echo "
Payor 2: " . $reCLthird_co2; mcrypt_generic_init($mcrypt_module, $mcrypt_key, $re_mcrypt_iv); $reCLclaim_no2=mdecrypt_generic($mcrypt_module, base64_decode($reCLclaim_no2)); $reCLclaim_no2=rtrim($reCLclaim_no2, "\0"); echo "
Case # " . $reCLclaim_no2 . "
"; mcrypt_generic_deinit($mcrypt_module); } if(!empty($reCLclaim_no3)) { echo "
Payor 3: " . $reCLthird_co3; mcrypt_generic_init($mcrypt_module, $mcrypt_key, $re_mcrypt_iv); $reCLclaim_no3=mdecrypt_generic($mcrypt_module, base64_decode($reCLclaim_no3)); $reCLclaim_no3=rtrim($reCLclaim_no3, "\0"); echo "
Case # " . $reCLclaim_no3 . "
"; mcrypt_generic_deinit($mcrypt_module); } if(!empty($reCLclaim_no4)) { echo "
Payor 4: " . $reCLthird_co4; mcrypt_generic_init($mcrypt_module, $mcrypt_key, $re_mcrypt_iv); $reCLclaim_no4=mdecrypt_generic($mcrypt_module, base64_decode($reCLclaim_no4)); $reCLclaim_no4=rtrim($reCLclaim_no4, "\0"); echo "
Case # " . $reCLclaim_no4 . "
"; mcrypt_generic_deinit($mcrypt_module); } if(!empty($reCLclaim_no5)) { echo "
Payor 5: " . $reCLthird_co5; mcrypt_generic_init($mcrypt_module, $mcrypt_key, $re_mcrypt_iv); $reCLclaim_no5=mdecrypt_generic($mcrypt_module, base64_decode($reCLclaim_no5)); $reCLclaim_no5=rtrim($reCLclaim_no5, "\0"); echo "
Case # " . $reCLclaim_no5 . "
"; mcrypt_generic_deinit($mcrypt_module); } }/////end of retrieve record function CL_in_use($inuse_id) { $link_id = db_connect(); if(!link_id) die(sql_error()); $query = "SELECT CL_id FROM clients WHERE CL_id = '$inuse_id'"; $result = mysql_query($query); $query = "SELECT CL_id FROM clients_ab WHERE CL_id = '$inuse_id'"; $result1 = mysql_query($query); $query = "SELECT CL_id FROM clients_sk WHERE CL_id = '$inuse_id'"; $result2 = mysql_query($query); $query = "SELECT CL_id FROM clients_mb WHERE CL_id = '$inuse_id'"; $result3 = mysql_query($query); $query = "SELECT CL_id FROM clients_on WHERE CL_id = '$inuse_id'"; $result4 = mysql_query($query); $query = "SELECT CL_id FROM clients_qc WHERE CL_id = '$inuse_id'"; $result5 = mysql_query($query); $query = "SELECT CL_id FROM clients_nb WHERE CL_id = '$inuse_id'"; $result6 = mysql_query($query); $query = "SELECT CL_id FROM clients_ns WHERE CL_id = '$inuse_id'"; $result7 = mysql_query($query); $query = "SELECT CL_id FROM clients_pe WHERE CL_id = '$inuse_id'"; $result8 = mysql_query($query); $query = "SELECT CL_id FROM clients_nl WHERE CL_id = '$inuse_id'"; $result9 = mysql_query($query); $query = "SELECT CL_id FROM clients_yk WHERE CL_id = '$inuse_id'"; $result10 = mysql_query($query); $query = "SELECT CL_id FROM clients_nw WHERE CL_id = '$inuse_id'"; $result11 = mysql_query($query); $query = "SELECT CL_id FROM clients_nv WHERE CL_id = '$inuse_id'"; $result12 = mysql_query($query); if(mysql_num_rows($result)) {$return_var = 1;} else if(mysql_num_rows($result1)) {$return_var = 1;} else if(mysql_num_rows($result2)) {$return_var = 1;} else if(mysql_num_rows($result3)) {$return_var = 1;} else if(mysql_num_rows($result4)) {$return_var = 1;} else if(mysql_num_rows($result5)) {$return_var = 1;} else if(mysql_num_rows($result6)) {$return_var = 1;} else if(mysql_num_rows($result7)) {$return_var = 1;} else if(mysql_num_rows($result8)) {$return_var = 1;} else if(mysql_num_rows($result9)) {$return_var = 1;} else if(mysql_num_rows($result10)) {$return_var = 1;} else if(mysql_num_rows($result11)) {$return_var = 1;} else if(mysql_num_rows($result12)) {$return_var = 1;} else {$return_var =0;} return $return_var; } function register_CL_form() { global $PHP_SELF; ?>
Create your client account!
Please note that you must have cookies enabled to use this service...
"; echo "
"; echo "
"; echo "
"; ?>
Desired ID
Desired Password
Retype Password
Password Hint
Enter a hint for your password that you understand but no one else would understand:
First Name
Last Name
Sex
M
F
Date of Birth
email
Use this email address:
Re-enter email:
email me
2 days before
3 days before
each appointment, as a reminder.
do not remind me of appointments but send me special announcements!
email only changes!
phone number
Address 1
Address 2
City
Prov.
BC
AB
SK
MB
ON
QC
NL
NS
NB
PEI
YK
NWT
NV
Postal Code
bill sessions to
"; echo $_SESSION['third_co1']; third_co_list3(); } else { //echo "
Charge client
"; third_co_list(); } ?>
claim/ins. number
third party email 1
If there is more than one company or institution paying for various services, fill in the spaces below.
If you are paying for services yourself, you don't need to fill in a claim/case number and you don't need to fill in your email address again. Please fill in the payors in order, if possible. For example, you may want to fill in your provincial health plan first if you plan on booking physiotherapy appointments. You can always add third party payors later, if you want.
then bill
None"; third_co_list(); ?>
claim/ins. number 2
third party email 2
or bill
None"; third_co_list(); ?>
claim/ins. number 3
third party email 3
or bill
None"; third_co_list(); ?>
claim/ins. number 4
third party email 4
or bill
None"; third_co_list(); ?>
claim/ins. number 5
third party email 5
Visa/MasterCard
card expiry date
end omit */ ?>
I have read the
Terms of Use
and agree to them
tempCLclaim_no1 is " . $tempCLclaim_no1 . "
"; } else {$query .= ",NULL,''";} if($tempCLthird_co2 != 'none') { $query .= ",'$tempCLthird_co2'"; } else {$query .= ",''";} if(!empty($tempCLclaim_no2)) { mcrypt_generic_init($mcrypt_module, $mcrypt_key, $mcrypt_iv); $tempCLclaim_no2=base64_encode(mcrypt_generic($mcrypt_module, $tempCLclaim_no2)); $query .= ",'$tempCLclaim_no2', '$tempthirdptyemail2'"; mcrypt_generic_deinit($mcrypt_module); // echo "tempCLclaim_no2 is " . $tempCLclaim_no2 . "
"; } else {$query .= ",NULL,''";} if($tempCLthird_co3 != 'none') { $query .= ",'$tempCLthird_co3'"; } else {$query .= ",''";} if(!empty($tempCLclaim_no3)) { mcrypt_generic_init($mcrypt_module, $mcrypt_key, $mcrypt_iv); $tempCLclaim_no3=base64_encode(mcrypt_generic($mcrypt_module, $tempCLclaim_no3)); $query .= ",'$tempCLclaim_no3', '$tempthirdptyemail3'"; mcrypt_generic_deinit($mcrypt_module); //echo "tempCLclaim_no3 is " . $tempCLclaim_no3 . "
"; } else {$query .= ",NULL,''";} if($tempCLthird_co4 != 'none') { $query .= ",'$tempCLthird_co4'"; } else {$query .= ",''";} if(!empty($tempCLclaim_no4)) { mcrypt_generic_init($mcrypt_module, $mcrypt_key, $mcrypt_iv); $tempCLclaim_no4=base64_encode(mcrypt_generic($mcrypt_module, $tempCLclaim_no4)); $query .= ",'$tempCLclaim_no4', '$tempthirdptyemail4'"; mcrypt_generic_deinit($mcrypt_module); //echo "tempCLclaim_no4 is " . $tempCLclaim_no4 . "
"; } else {$query .= ",NULL,''";} if($tempCLthird_co5 != 'none') { $query .= ",'$tempCLthird_co5'"; } else {$query .= ",''";} if(!empty($tempCLclaim_no5)) { mcrypt_generic_init($mcrypt_module, $mcrypt_key, $mcrypt_iv); $tempCLclaim_no5=base64_encode(mcrypt_generic($mcrypt_module, $tempCLclaim_no5)); $query .= ",'$tempCLclaim_no5', '$tempthirdptyemail5'"; mcrypt_generic_deinit($mcrypt_module); //echo "tempCLclaim_no5 is " . $tempCLclaim_no5 . "
"; } else {$query .= ",NULL,''";} if(!empty($tempDateOfBirth)) { mcrypt_generic_init($mcrypt_module, $mcrypt_key, $mcrypt_iv); $tempDateOfBirth=base64_encode(mcrypt_generic($mcrypt_module, $tempDateOfBirth)); $query .= ",'$tempDateOfBirth'"; mcrypt_generic_deinit($mcrypt_module); //echo "tempDateOfBirth is " . $tempDateOfBirth . "
"; } else {$query .= ",NULL";} $query .= ",NULL)";////end of query //echo $query; //'$CLcredit_card','$CLexpiry_date', /*$quert= $tempCLfname . " " . $CLlname . " userid = " . $tempCL_id . " password = " . $tempuserCLpassword; $quert .= "\nemail= " . $tempCLemail . " ph. " . $tempCLphone . "\n" . "address= " . $tempCLaddress1 . " "; $quert .= $tempCLaddress2 . " " . $tempCLcity . " " . $tempCLprov . " "; $quert .= $tempCLpostal . "\n3rd pty= " . $tempCLthird_co . " ref no= " . $tempCLclaim_no . " 3rd email= " . $tempthirdptyemail;*/ $result=mysql_query($query); if(!$result) error_message(sql_error()); if($result) { //session_register("userCLid"); $_SESSION['userCLid'] = $_POST['CL_id']; $_SESSION['userCLprov'] = $tempCLprov; $query2="INSERT INTO $hinttab (hint_id, user_id, user_type, hint) VALUES (NULL,'$tempCL_id',2,'$password_hint')"; $result2=mysql_query($query2); //if(!$result2) error_message(sql_error()); /////EMAIL NEW USER INFO////// $newuser_mail_body = "A new user named "; $newuser_mail_body .= $_POST['CL_id']; $newuser_mail_body .= " has registered as a client."; $newuser_mail_address = "admin@zappointments.com"; $newuser_mail_subject = "New Client Registered"; $newuser_mail_added = "From: admin@zappointments.com\r\n"; $newuser_mail_added .= "Reply-to: admin@zappointments.com"; mail($newuser_mail_address, $newuser_mail_subject, $newuser_mail_body, $newuser_mail_added); ?>
has been registered, thanks!
If you want to check for available appointments, click "; echo "
"; echo "here
"; echo ""; if(!empty($_POST['navProid'])) { echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; }///end of if not empty navProid } else { echo "
If you want to check for available appointments, click "; echo "
"; echo "here
"; echo "
"; if(!empty($_POST['navProid'])) { echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; }///end of if not empty navProid } retrieve_record($tempCL_id); } } /////OMITTED THE DISPLAY INFO below//// ?>