The new claim number entered is encrypted as " . $tempuserCLclaimno2A;
//echo " The old claim number entered is encrypted as " . $tempuserCLclaim_no64;
$mquery="SELECT CLclaim_no1, CLclaim_no2, CLclaim_no3, CLclaim_no4, CLclaim_no5 from $clients_db WHERE CL_id='$tempuserCLid'";
$mresult=mysql_query($mquery);
$mresult_array=mysql_fetch_array($mresult);
$mCLclaim_no1=$mresult_array['CLclaim_no1'];
$mCLclaim_no1=rtrim($mCLclaim_no1, "\0");
$mCLclaim_no2=$mresult_array['CLclaim_no2'];
$mCLclaim_no2=rtrim($mCLclaim_no2, "\0");
$mCLclaim_no3=$mresult_array['CLclaim_no3'];
$mCLclaim_no3=rtrim($mCLclaim_no3, "\0");
$mCLclaim_no4=$mresult_array['CLclaim_no4'];
$mCLclaim_no4=rtrim($mCLclaim_no4, "\0");
$mCLclaim_no5=$mresult_array['CLclaim_no5'];
$mCLclaim_no5=rtrim($mCLclaim_no5, "\0");
//if(empty($mCLclaim_no1)){error_message("mCLclaim_no1 is empty!");}
/////THESE ARE ALL BASE64 ENCODED///////////////////
//echo " mCLclaim_no1 from database is " . $mCLclaim_no1;
//echo " which is ";
mcrypt_generic_init($mcrypt_module, $mcrypt_key, $mcrypt_iv);
$mCL_decrypted=mdecrypt_generic($mcrypt_module, base64_decode($mCLclaim_no1));
//mcrypt_generic_deinit($mcrypt_module);
//echo $mCL_decrypted;
//echo " mCLclaim_no2 from database is " . $mCLclaim_no2;
//echo " which is ";
mcrypt_generic_init($mcrypt_module, $mcrypt_key, $mcrypt_iv);
$mCL_decrypted=mdecrypt_generic($mcrypt_module, base64_decode($mCLclaim_no2));
//mcrypt_generic_deinit($mcrypt_module);
//echo $mCL_decrypted;
//echo " mCLclaim_no3 from database is " . $mCLclaim_no3;
//echo " which is ";
mcrypt_generic_init($mcrypt_module, $mcrypt_key, $mcrypt_iv);
$mCL_decrypted=mdecrypt_generic($mcrypt_module, base64_decode($mCLclaim_no3));
//mcrypt_generic_deinit($mcrypt_module);
//echo $mCL_decrypted;
//echo " mCLclaim_no4 from database is " . $mCLclaim_no4;
//echo " which is ";
mcrypt_generic_init($mcrypt_module, $mcrypt_key, $mcrypt_iv);
$mCL_decrypted=mdecrypt_generic($mcrypt_module, base64_decode($mCLclaim_no4));
//mcrypt_generic_deinit($mcrypt_module);
//echo $mCL_decrypted;
//echo " mCLclaim_no5 from database is " . $mCLclaim_no5;
//echo " which is ";
mcrypt_generic_init($mcrypt_module, $mcrypt_key, $mcrypt_iv);
$mCL_decrypted=mdecrypt_generic($mcrypt_module, base64_decode($mCLclaim_no5));
//mcrypt_generic_deinit($mcrypt_module);
//echo $mCL_decrypted;
$m1decoded=base64_decode($mCLclaim_no1);
mcrypt_generic_init($mcrypt_module, $mcrypt_key, $mcrypt_iv);
$rem=mdecrypt_generic($mcrypt_module, $m1decoded);
mcrypt_generic_deinit($mcrypt_module);
//echo " tempuserCLclaim_no64 is " . $tempuserCLclaim_no64;
//echo " m1decoded is " . $m1decoded;
//echo " rem is " . $rem;
if(empty($tempuserCLclaim_no64)) {error_message("old claim number is missing");}
else if($tempuserCLclaim_no64==$mCLclaim_no1){$m2query="UPDATE $clients_db SET CLclaim_no1='$tempuserCLclaimno2A' WHERE CL_id='$tempuserCLid' and CLthird_co1='$tempInsurer'";}
else if($tempuserCLclaim_no64==$mCLclaim_no2){$m2query="UPDATE $clients_db SET CLclaim_no2='$tempuserCLclaimno2A' WHERE CL_id='$tempuserCLid' and CLthird_co2='$tempInsurer'";}
else if($tempuserCLclaim_no64==$mCLclaim_no3){$m2query="UPDATE $clients_db SET CLclaim_no3='$tempuserCLclaimno2A' WHERE CL_id='$tempuserCLid' and CLthird_co3='$tempInsurer'";}
else if($tempuserCLclaim_no64==$mCLclaim_no4){$m2query="UPDATE $clients_db SET CLclaim_no4='$tempuserCLclaimno2A' WHERE CL_id='$tempuserCLid' and CLthird_co4='$tempInsurer'";}
else if($tempuserCLclaim_no64==$mCLclaim_no5){$m2query="UPDATE $clients_db SET CLclaim_no5='$tempuserCLclaimno2A' WHERE CL_id='$tempuserCLid' and CLthird_co5='$tempInsurer'";}
else {echo "SCREECH";
error_message("Your old claim/case number didn't match any of the claim/case numbers in our records");}
mcrypt_generic_init($mcrypt_module, $mcrypt_key, $mcrypt_iv);
$mCLclaim_no1=mdecrypt_generic($mcrypt_module, base64_decode($mCLclaim_no1));
mcrypt_generic_deinit($mcrypt_module);
mcrypt_module_close ($mcrypt_module);
//echo " first claim number is " . $mCLclaim_no1;
//echo " ";
//echo $m2query;
//echo " ";
$result=mysql_query($m2query);
if(!$result) {error_message(sql_error());}
$mresult2=mysql_affected_rows($link_id);
//echo " No. affected rows is " . $mresult2;
if($mresult2 > 0)
{
?>
, thanks for updating the claim number!
Failed to update claim number!";
}
echo " If you want to logout, click here.";
}
/////////////BODY///// BODY///////// BODY
switch($_POST['action'])
{
case "change_CLclaimno":
update_CL_claimno();
break;
default:
if(empty($_SESSION['userCLid'])) {echo " No client logged in. If you are a client, log in here ";}
else {echo "If you want to logout, click here.";
change_claimno_form();
echo " If you wish to update your registration, click " . "here.";
echo " If you want to check available appointments, click ";
echo "here.";
}
break;
}
echo "