The new claim number entered is encrypted as " . $tempuserCLclaimno2A;
$mquery="SELECT CLthird_co1, CLclaim_no1, CLthird_co2, CLclaim_no2, CLthird_co3, CLclaim_no3, CLthird_co4, CLclaim_no4, CLthird_co5, CLclaim_no5 from $clients_db WHERE CL_id='$tempuserCLid'";
$mresult=mysql_query($mquery);
$mresult_array=mysql_fetch_array($mresult);
$mCLthird_co1=$mresult_array['CLthird_co1'];
$mCLclaim_no1=$mresult_array['CLclaim_no1'];
$mCLclaim_no1=rtrim($mCLclaim_no1, "\0");
$mCLthird_co2=$mresult_array['CLthird_co2'];
$mCLclaim_no2=$mresult_array['CLclaim_no2'];
$mCLclaim_no2=rtrim($mCLclaim_no2, "\0");
$mCLthird_co3=$mresult_array['CLthird_co3'];
$mCLclaim_no3=$mresult_array['CLclaim_no3'];
$mCLclaim_no3=rtrim($mCLclaim_no3, "\0");
$mCLthird_co4=$mresult_array['CLthird_co4'];
$mCLclaim_no4=$mresult_array['CLclaim_no4'];
$mCLclaim_no4=rtrim($mCLclaim_no4, "\0");
$mCLthird_co5=$mresult_array['CLthird_co5'];
$mCLclaim_no5=$mresult_array['CLclaim_no5'];
$mCLclaim_no5=rtrim($mCLclaim_no5, "\0");
/////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;
*/////END OMIT
if(empty($tempuserCLclaimno2A)){error_message("There's no new claim number!");}
else if($tempuserCLclaimno2A==$mCLclaim_no1) {error_message("New number is already in database");}
else if(empty($mCLclaim_no1)){$m2query="UPDATE $clients_db SET CLclaim_no1='$tempuserCLclaimno2A',CLthird_co1='$tempInsurer', third_party_email1='$temp_third_co_email' WHERE CL_id='$tempuserCLid'";echo "adding new claim number as first no.";}
else if($tempuserCLclaimno2A==$mCLclaim_no2) {error_message("New number is already in database");}
else if(empty($mCLclaim_no2)){$m2query="UPDATE $clients_db SET CLclaim_no2='$tempuserCLclaimno2A',CLthird_co2='$tempInsurer', third_party_email2='$temp_third_co_email' WHERE CL_id='$tempuserCLid'";echo "adding new claim number as second no.";}
else if($tempuserCLclaimno2A==$mCLclaim_no3) {error_message("New number is already in database");}
else if(empty($mCLclaim_no3)){$m2query="UPDATE $clients_db SET CLclaim_no3='$tempuserCLclaimno2A',CLthird_co3='$tempInsurer', third_party_email3='$temp_third_co_email' WHERE CL_id='$tempuserCLid'";echo "adding new claim number as third number";}
else if($tempuserCLclaimno2A==$mCLclaim_no4) {error_message("New number is already in database");}
else if(empty($mCLclaim_no4)){$m2query="UPDATE $clients_db SET CLclaim_no4='$tempuserCLclaimno2A',CLthird_co4='$tempInsurer', third_party_email4='$temp_third_co_email' WHERE CL_id='$tempuserCLid'";echo "adding new claim number as fourth number";}
else if($tempuserCLclaimno2A==$mCLclaim_no5) {error_message("New number is already in database");}
else if(empty($mCLclaim_no5)){$m2query="UPDATE $clients_db SET CLclaim_no5='$tempuserCLclaimno2A',CLthird_co5='$tempInsurer', third_party_email5='$temp_third_co_email' WHERE CL_id='$tempuserCLid'";echo "adding new claim number as fifth number";}
else {
error_message("Please contact the system administrator");}
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 adding the claim number!
Failed to add the claim number!";
}
echo " If you want to logout, click here.";
}
/////////////BODY///// BODY///////// BODY
switch($_POST['action'])
{
case "change_CLclaimno":
add_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.";
add_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 "