$value) { $_REQUEST[$key] = removeQuotes($value); } $email = $_REQUEST['email']; if(strlen($email) == 0) { $errorstring .= "You must specify an email address
"; } $success_message = ""; if(strlen($errorstring) == 0) { $query = "SELECT * FROM orderCustomersNNEW where lcase(email)=lcase('$email') limit 1"; $result = mysql_query($query); if($row= mysql_fetch_assoc($result)) { extract($row); if($password=='') { $rand_password=rand(6,999999); //$update_query1="update customers set password='$rand_password' where email='$email'"; // mysql_query($update_query1); $update_query2="update orderCustomersNNEW set password='$rand_password' where email='$email'"; mysql_query($update_query2); $password=$rand_password; } $output = "Dear $firstName $lastName: Thank you for being a valued customer of Solanova. We recently received a request to resend your password for your online account to this email address. We have provided that information below: Password: $password You may sign into your online account at http://www.solanova.com/login-to-your-account.html at any time to change your password. If you did not request to have this password sent to you or if you need assistance, please contact our Customer Care Department at 1-800-200-0456. Thank you again for choosing Solanova for your health needs. This email was sent by: Solanova LLC 7110 Redwood Blvd. , Suite A Novato, CA 94945 1800-200-0456 www.Solanova.com"; mail($email, "Lost Password Request", $output, "From:customercare@solanova.com"); $success_message = "

Your password has been sent to your email address

"; } else { $query = "SELECT * FROM customers where lcase(email)=lcase('$email') limit 1"; $result = mysql_query($query); if($row= mysql_fetch_assoc($result)) { extract($row); if($password=='') { $rand_password=rand(6,999999); $update_query1="update customers set password='$rand_password' where email='$email'"; mysql_query($update_query1); //$update_query2="update orderCustomersNNEW set password='$rand_password' where email='$email'"; // mysql_query($update_query2); $password=$rand_password; } $output = "Dear $firstName $lastName: Thank you for being a valued customer of Solanova. We recently received a request to resend your password for your online account to this email address. We have provided that information below: Password: $password You may sign into your online account at http://www.solanova.com/login-to-your-account.html at any time to change your password. If you did not request to have this password sent to you or if you need assistance, please contact our Customer Care Department at 1-800-200-0456. Thank you again for choosing Solanova for your health needs. This email was sent by: Solanova LLC 7110 Redwood Blvd. , Suite A Novato, CA 94945 1800-200-0456 www.Solanova.com"; mail($email, "Lost Password Request", $output, "From:customercare@solanova.com"); $success_message = "

Your password has been sent to your email address

"; } else { $errorstring = "Email address not found on file"; } } } } include_header("solanova :: Forgot Password", "@import url('stylesheets/account-settings-edit.css');", ""); ?>

Welcome

Forgot Your Password?

Please enter the email associated with your account and we will email your password to this address.

0) { echo "$errorstring"; } if(strlen($success_message) > 0) { echo $success_message; } else { ?>