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.

Lost Login Info  -   Enter E-mail Address



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 ?>