$cmd=$_GET['cmd'];
$send_flag = "N";
if (!$link):
$error_flag = "Y";
$error_message = "Oops! Our online database is currently down. This is because hosting company is taking daily backups or server is under maintenance.";
else:
$error_flag = "N";
if ($cmd == "send"):
$gfaq_name = trim($_POST["gfaq_name"]);
if ( $gfaq_name == "" ) {
$error_flag="Y";
$error_message="Please enter your GameFAQ name!";
}
else {
$db_gfaq_name = addslashes($gfaq_name);
$sql = "select member_id, username, email from member where gfaq_name = '$db_gfaq_name'";
$result = mysqli_query($link, $sql );
$row = mysqli_fetch_assoc($result);
if ( $row['username'] == "" ) {
$error_flag="Y";
$error_message="GameFAQ's name '" . $gfaq_name . "' is not registered for an account! Please check you have spelled the name correctly.
In case you do not have an account yet, please sign up.";
}
else {
$temp_password = '';
$keyspace = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
$length = 11;
$max = strlen($keyspace) - 1;
for ($i = 1; $i < $length; $i++) {
$temp_password = $temp_password . $keyspace[rand(0, $max)];
}
$db_member_id = $row['member_id'];
$db_temporary_password = addslashes(crypt($temp_password, $temp_password));
$sql = "update member set temporary_password = '$db_temporary_password', expire_time = DATE_ADD(NOW(),INTERVAL 1 DAY) where member_id = $db_member_id";
$result = mysqli_query($link, $sql );
if ( ! $result ) {
$error_flag="Y";
$error_message = "Failed due ". mysqli_error($link);
} else
{
$mailheaders = "From: support@opsc.dark-arisen.com\n";
$mailheaders .= "Cc: \n";
$mailheaders .= "Bcc: \n";
$mailheaders .= "Reply-To: support@opsc.dark-arisen.com\n";
$mailheaders .= "X-Mailer: PHP3 Mail Function on Apache/BSD\n";
$mailsubject = "Official Pawn Sharing Club Forgot Password";
$msg = "Dear " . $gfaq_name . ",\n\n";
$msg .= "You requested that your password be reset!\n\n";
$msg .= "Please use the following temporary credentials when you login to http://$instance_name \n\n";
$msg .= "Username: " . $row['username'] . "\n";
$msg .= "Password: " . $temp_password . "\n\n";
$msg .= "To change your password, log in with the above details, click Settings and change your password.\n\n";
$msg .= "In case you did not sent the reset password request, please ignore this message.\n\n";
$msg .= "Thanks,\n";
$msg .= "OPSC Support";
if (mail($row['email'], $mailsubject, $msg, $mailheaders)):
$success_message = "Login credentials have been successfully sent.";
$send_flag = "Y";
else:
$error_flag="Y";
$error_message = "Failed to send login credentials. Please contact paasky at GameFAQs.";
endif;
}
}
}
endif;
endif;?>