";
echo "";
echo "Change service provider password";
echo"";
?>
here.";*/
////////////////////////////////////////////////FUNCTIONS
function change_Pro_password_form() {
global $PHP_SELF;
?>
Change your password!
";
//echo "userPropasswd2A is " . $_POST['userPropasswd2A'] . " ";
//echo "userPropasswd2B is " . $_POST['userPropasswd2B'] . " ";
if(empty($_SESSION['userProid'])) error_message("Sorry, you're no longer logged in. Please refresh the page and log in using the link at the top.");
if(empty($_SESSION['userProprov'])) error_message("Sorry, you're no longer logged in. Please refresh the page and log in using the link at the top.");
if(empty($_POST['userPropasswd'])) error_message("Enter your old password.");
if(ereg("[^a-zA-Z0-9]", $_POST['userPropasswd'])) error_message("Only numbers and letters allowed in passwords");
if(empty($_POST['userPropasswd2A'])) error_message("Enter your new password.");
if(ereg("[^a-zA-Z0-9]", $_POST['userPropasswd2A'])) error_message("Only numbers and letters allowed in passwords");
if(empty($_POST['userPropasswd2B'])) error_message("Retype your new password.");
if(ereg("[^a-zA-Z0-9]", $_POST['userPropasswd2B'])) error_message("Only numbers and letters allowed in passwords");
if($_POST['userPropasswd2A'] != $_POST['userPropasswd2B']) {error_message("Passwords don't match!");}
if(empty($_POST['password_hint'])) error_message("Enter a hint for your password.");
if(ereg("[^a-zA-Z0-9\ \.'-]", $_POST['password_hint'])) error_message("Only numbers, letters, dashes and spaces allowed in password hint");
$link_id = db_connect(); ///line 122
//UPDATE the Provider password
$tempuserProid=$_SESSION['userProid'];
$tempuserPropasswd2A=$_POST['userPropasswd2A'];
$tempuserPropasswd=$_POST['userPropasswd'];
$password_hint=$_POST['password_hint'];
if(empty($_SESSION['userProprov'])){error_message("Enter your province");}
else if($_SESSION['userProprov']=="BC"){$servProdb="service_providers";}
else if($_SESSION['userProprov']=="AB"){$servProdb="service_providers_ab"; }
else if($_SESSION['userProprov']=="SK"){$servProdb="service_providers_sk"; }
else if($_SESSION['userProprov']=="MB"){$servProdb="service_providers_mb"; }
else if($_SESSION['userProprov']=="ON"){$servProdb="service_providers_on"; }
else if($_SESSION['userProprov']=="QC"){$servProdb="service_providers_qc"; }
else if($_SESSION['userProprov']=="NS"){$servProdb="service_providers_ns"; }
else if($_SESSION['userProprov']=="NB"){$servProdb="service_providers_nb"; }
else if($_SESSION['userProprov']=="PE"){$servProdb="service_providers_pe"; }
else if($_SESSION['userProprov']=="NL"){$servProdb="service_providers_nl"; }
else if($_SESSION['userProprov']=="YK"){$servProdb="service_providers_yk"; }
else if($_SESSION['userProprov']=="NW"){$servProdb="service_providers_nw"; }
else if($_SESSION['userProprov']=="NV"){$servProdb="service_providers_nv"; }
///get other provinces
$query_get_provs="SELECT Proprov, ProprovA, ProprovB from $servProdb WHERE Pro_id = '$tempuserProid' AND userPropassword = password('$tempuserPropasswd')";
$result_get_provs=mysql_query($query_get_provs);
if(mysql_num_rows($result_get_provs) < 1){error_message("Unable to retrieve provinces");}
$arrayProvs=mysql_fetch_row($result_get_provs);
$Pro_up=0;
while (list(,$eaProv)=each($arrayProvs))
{
if($eaProv=="BC"){$servProdb="service_providers";$hinttab="hints";}
else if($eaProv=="AB"){$servProdb="service_providers_ab";$hinttab="hints_ab";}
else if($eaProv=="SK"){$servProdb="service_providers_sk";$hinttab="hints_sk";}
else if($eaProv=="MB"){$servProdb="service_providers_mb";$hinttab="hints_mb";}
else if($eaProv=="ON"){$servProdb="service_providers_on";$hinttab="hints_on";}
else if($eaProv=="QC"){$servProdb="service_providers_qc";$hinttab="hints_qc";}
else if($eaProv=="NS"){$servProdb="service_providers_ns";$hinttab="hints_ns";}
else if($eaProv=="NB"){$servProdb="service_providers_nb";$hinttab="hints_nb";}
else if($eaProv=="PE"){$servProdb="service_providers_pe";$hinttab="hints_pe";}
else if($eaProv=="NL"){$servProdb="service_providers_nl";$hinttab="hints_nl";}
else if($eaProv=="YK"){$servProdb="service_providers_yk";$hinttab="hints_yk";}
else if($eaProv=="NW"){$servProdb="service_providers_nw";$hinttab="hints_nw";}
else if($eaProv=="NV"){$servProdb="service_providers_nv";$hinttab="hints_nv";}
$query="UPDATE $servProdb SET userPropassword = password('$tempuserPropasswd2A')
WHERE Pro_id = '$tempuserProid' AND userPropassword = password('$tempuserPropasswd')";
$result=mysql_query($query);
if(!$result) {error_message(sql_error());}
$result2=mysql_affected_rows($link_id);
if($result2 > 0) $Pro_up++;
$hintQ="UPDATE $hinttab SET hint='$password_hint' WHERE user_id='$tempuserProid' and user_type=1";
$hintR=mysql_query($hintQ);
if(!$hintR) error_message("Failed to record hint");
}
if($Pro_up > 0)
{
?>
, thanks for updating your password!
If you want to logout, click here.";
}
/////OMITTED THE DISPLAY INFO below////
?>No service provider logged in. If you are a service provider, log in here ";}
else {echo "If you want to logout, click here.";
change_Pro_password_form();
echo " If you wish to update your registration, click " . "here.";
echo " If you want to check available appointments, click ";
echo "here.";
}
break;
}
?>