= '$nowdate') AND (day <= '$laterdate') AND (client_id='$CLid' AND bill_to='$gotco') order by day, time"; } else { $clientQ="SELECT * from $appts_db WHERE (day > '$nowdate') AND (day < '$laterdate') AND client_id='$CLid' order by day, time";} $clientR=mysql_query($clientQ); if(mysql_num_rows($clientR)) {echo "
Upcoming appointments
";} while($clientA=mysql_fetch_array($clientR)) { $day=$clientA['day']; $uday=strtotime($day); if($uday < $plus3w) {$beginmark=0;} else if($uday < $plus6w) {$beginmark=1;} else if($uday < $plus9w) {$beginmark=2;} else {$beginmark=3;} list($xyear, $xmonth, $xday)=explode( "-",$day); if($xmonth=='01') $xmonth='Jan'; else if($xmonth=='02') $xmonth='Feb'; else if($xmonth=='03') $xmonth='Mar'; else if($xmonth=='04') $xmonth='Apr'; else if($xmonth=='05') $xmonth='May'; else if($xmonth=='06') $xmonth='Jun'; else if($xmonth=='07') $xmonth='Jul'; else if($xmonth=='08') $xmonth='Aug'; else if($xmonth=='09') $xmonth='Sep'; else if($xmonth=='10') $xmonth='Oct'; else if($xmonth=='11') $xmonth='Nov'; else if($xmonth=='12') $xmonth='Dec'; $time=$clientA['time']; $location=$clientA['location']; list($xtime1, $xtime2, $xtime3)=explode( ":",$time); $Agent_id=$clientA['Agent_id']; echo $xmonth; echo " "; echo $xday; echo ", "; echo $xyear; echo " at "; if($xtime1 > 12) {$xtime1 -= 12;} echo $xtime1; echo ":"; echo $xtime2; echo ""; echo "find this appointment
"; } echo "
"; } function selectProv($var_name_prov) { echo ""; } function login_CL_for_third_form() { global $PHP_SELF, $logout_script, $registerCL_script, $register3_script, $third_login; echo ""; echo ""; echo "Which client?"; echo""; ?>
Please note that you must have cookies enabled to use this service...
"; echo ""; echo ""; echo ""; echo ""; echo ""; ?>

For which client?

First name
Last name
Claim No.
Province
Login as a client
Please note that you must have cookies enabled to use this service...
"; echo ""; echo ""; echo ""; echo ""; echo ""; ?>

Log in as a client?

Username
Password
Province
Login your client
Please note that you must have cookies enabled to use this service...
"; echo ""; echo ""; echo ""; ?>

Log in your client?

Username
Province
To look for your appointments in other provinces, click on the province from the list below

"; echo "
BC"; echo " "; echo "AB"; echo " "; echo "SK"; echo " "; echo "MB"; echo " "; echo "ON"; echo " "; echo "QC"; echo " "; echo "NB"; echo " "; echo "NS"; echo " "; echo "PE"; echo " "; echo "NL"; echo " "; echo "YK"; echo " "; echo "NWT"; echo " "; echo "NU

"; } ////////////////sessionstart session_start(); ?> "; echo "authorization failed"; $_SESSION['userCLid1']=""; echo "
You must enter a valid name and claim number combination.
"; echo "Click on the following link to try again.
\n"; echo "Log in!
\n"; } else { echo ""; $_SESSION['userCLid1']=$_SESSION['userCLid'];///userCLid is right here/// $_SESSION['userCLprov']=$_POST['userCLprov']; $CL_id=$_SESSION['userCLid']; lastaccess($CL_id); echo "A client has been logged in! " . "Click " . "here " . "to log out.
"; echo "
If you wish to update the client's registration, click " . "here."; echo "
If you wish to look for services, click " . "here."; if(!empty($_POST['navProid'])) { echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "

"; }///end of if not empty navProid $CL1=$_SESSION['userCLid']; show_all_appts($CL1); } break; case "login_self": $_SESSION['userCLid']=auth_client($_POST['userCLname'], $_POST['userCLpassword'], $_POST['userCLprov']); if(!$_SESSION['userCLid']) {echo "authorization failed"; $_SESSION['userCLid1']="";} else { $_SESSION['userCLid1']=$_SESSION['userCLid']; $_SESSION['userCLprov']=$_POST['userCLprov']; $CL_id=$_SESSION['userCLid']; lastaccess($CL_id); echo ""; echo "You have been logged in as a client! " . "Click " . "here " . "to log out.
"; echo "
If you wish to update your registration, click " . "here."; echo "
If you wish to look for services, click " . "here."; echo "
To change your password, click " . "here."; if(!empty($_POST['navProid'])) { echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "

"; }///end of if not empty navProid $CL1=$_SESSION['userCLid']; show_all_appts($CL1); } break; case "login_Proself": $_SESSION['userCLid']=auth_client_pro($_POST['userCLname'], $_POST['userCLprov']); if(!$_SESSION['userCLid']) {echo "authorization failed"; $_SESSION['userCLid1']="";} else { $_SESSION['userCLid1']=$_SESSION['userCLid']; $_SESSION['userCLprov']=$_POST['userCLprov']; $CL_id=$_SESSION['userCLid']; lastaccess($CL_id); echo ""; echo "You have logged in your client! " . "Click " . "here " . "to log out.
"; echo "
If you wish to update the client's registration, click " . "here."; echo "
If you wish to go back to your appointments, click " . "here."; $CL1=$_SESSION['userCLid']; show_all_appts($CL1); } break; default: if(!empty($_SESSION['userCLid'])) { if(!empty($_SESSION['user3id1'])) { echo ""; echo "A client and a third party payor are both logged in! " . "Click " . "here " . "to log both out.
"; echo "
If you wish to update the client's registration, click " . "here."; echo "
If you wish to update the third party's registration, click " . "here."; echo "
If you wish to look for services and appointments, click " . "here."; if(!empty($_POST['navProid'])) { echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "

"; }///end of if not empty navProid $CL1=$_SESSION['userCLid']; show_all_appts($CL1); } else if(!empty($_SESSION['userProid'])) { echo ""; echo "A client and a service provider are both logged in! " . "Click " . "here" . " to log both out.
"; echo "
If you wish to update the client's registration, click " . "here."; echo "
If you wish to update the service provider's registration, click " . "here."; echo "
If you wish to check the service provider's appointments, click " . "here."; $CL1=$_SESSION['userCLid']; show_all_appts($CL1); } else { echo ""; echo "You are logged in as a client! " . "Click " . "here " . "to log out.
"; echo "
If you wish to update your registration, click " . "here."; echo "
If you wish to check your appointments, click " . "here."; echo "
To change your password, click " . "here."; if(!empty($_POST['navProid'])) { echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "

"; }///end of if not empty navProid $CL1=$_SESSION['userCLid']; show_all_appts($CL1); } } else { echo ""; { if(!empty($_SESSION['user3id1'])) { echo "

If you want to register a client, click "; echo "here

"; login_CL_for_third_form(); } else if(!empty($_SESSION['userProid'])) {echo "

You are logged in as a service provider

"; login_CL_Proform(); echo "if you are a third party payor please log in here"; } else { login_CL_form(); echo "if you forgot your password, click here
"; echo "if you are a third party payor please log in here"; } } } break; } echo "

If this screen is not updated, click here.

"; otherprovlinks(); echo "

Appointment booking method Patent Pending

"; echo "

"; echo ""; echo ""; ?>