Find my client code
if ($in->postArgs["action"]=="submitForm") {
$result = $sql->dbQuery("
SELECT clientCode
FROM user
WHERE
email='".$in->postArgs["email"]."' AND
firstName='".$in->postArgs["firstName"]."' AND
lastName='".$in->postArgs["lastName"]."' AND
clientCode IS NOT NULL
");
if (!$result) { # if errors occur at the database
echo "
Error: Can't reach database engine
Please try again later. This is probably due to maintenance on the server.
";
} else {
if ($sql->numRows==1) {
$message="Dear ".ucfirst(stripslashes($in->postArgs["firstName"]))." ".ucfirst(stripslashes($in->postArgs["lastName"])).",\n\nSomeone (probably you) requested the client code for e-mail address ".strtolower(stripslashes($in->postArgs["email"])).".\n\nYour E-file Online client code is: ".$sql->getResult(0, "clientCode")."\n\nThank you for choosing E-file Online.\n\nBest regards,\nE-file Online Inc.\n";
$mailok = mail(strtolower(stripslashes($in->postArgs["email"])), "Lost clientcode - www.e-file-online.com", $message,"From: customerservice@E-file-Online.Com\nX-Mailer: E-file-Online.Com Mailer");
if ($mailok) {
?>
E-mail sent.
We sent an e-mail message to echo strtolower(stripslashes($in->postArgs["email"])); ?> with further instructions for finding your clientcode.
} else {
?>
E-mail could not be sent.
Unfortunately we were unable to send an e-mail message to echo strtolower(stripslashes($in->postArgs["email"])); ?>. Please try again later.