This "Lost Login Information" service will work only if
your e-mail address is the same address that is listed in the Witness Search Directory.
if ($_REQUEST['sendit'] == "yes"){
if (isset($_REQUEST['EMAIL'])){
/* make connection to database */
$dbtable = "listings";
// Connect to the database server
$dbcnx = @mysql_connect("$DBHost",
"$DBUser", "$DBPass");
if (!$dbcnx) {
echo( "Unable to connect to the " .
"database server at this time.
" );
exit();
}
// Select the database **** Edit Database Name ****
if (! @mysql_select_db("$DBname") ) {
echo( "Unable to locate the DataBase at this time.
" );
exit();
}
$query = "SELECT * FROM $dbtable WHERE EMAIL='".mysql_real_escape_string($_REQUEST['EMAIL'])."'";
$result = mysql_query($query) OR
DIE("Error retrieving records.");
$result = mysql_fetch_array($result);
$PASSWORD = $result["password"];
$USERNAME = $result["usr_id"];
$first = $result["first_name"];
$last = $result["last_name"];
//echo"
$query
";
if ($result)
{
// Create temporary password
$newpass = rand(123456, 987654);
$updatequery = "UPDATE listings SET temp_pass='$newpass' WHERE EMAIL='".mysql_real_escape_string($_REQUEST['EMAIL'])."'";
//print $updatequery;
$updateresult = mysql_query($updatequery);
// Send email including temporary password
$msubject = "Login Information For Your Expert Witness Search Listing";
$mbody = "Dear $first $last,\n";
$mbody .= "\n";
$mbody .= "We have received your password reset request. Please log-in using the information below:\n";
$mbody .= "\n";
$mbody .= "Username:\t $USERNAME\n";
$mbody .= "Temporary Password:\t $newpass\n";
$mbody .= "\n";
$mbody .= "Thank you for your membership with WitnessSearch.com. \n";
$mbody.="\n";
$mbody.="To login, modify your listing, and set a new password, go to the below web address: \n";
$mbody.="\n";
$mbody.="http://www.witnesssearch.com/Expert_Login.html\n";
$mbody.="\n";
$mbody.="Best Regards,\n";
$mbody.="\n";
$mbody.="$Site_Name\n";
$mbody.="WitnessSearch.com\n";
$mheader = "From: $Site_Name <$Site_Email>\n";
$mheader .= "Reply-To: $Site_Email\n";
mail($_REQUEST['EMAIL'], $msubject, $mbody, $mheader);
print "Your Password Information has been e-mailed to you at ".$_REQUEST['EMAIL'].".
";
}
else
{
//echo"
$query
";
print "".$_REQUEST['EMAIL']." is not in the database!
";
}
}
}
else
{
}
//
if ($connection) {
//Include Site Wide Footer File
//$ShowBottomLargeMenu = "Yes";
include("$DOCUMENT_ROOT$site_style_path/inc/footer.inc.php");
}//End if Connection
?>