last create new file forgotpassword.php
and put this in it
<?php
session_start(); // Start Session
include("header.php");
// Convert to simple variables
$email = $_POST['email'];
if (!isset($_POST['email'])) {
}
elseif (empty($email)) {
$empty_fields_message = "Please complete all the fields in the form.";//</p>Click <a class=\"two\" href=\"javascript:history.go(-1)\">here</a> to go back";
}
else {
$email=mysql_real_escape_string($email);
$status = "OK";
$msg="";
//error_reporting(E_ERROR | E_PARSE | E_CORE_ERROR);
if (!stristr($email,"@") OR !stristr($email,".")) {
$msg="Your email address is not correct<BR>";
$status= "NOTOK";}
if($status=="OK"){ //$query="SELECT email,user FROM pp_user WHERE user.email = '$email'";
$data2 = mysql_query("SELECT * FROM pp_config");
while($info = mysql_fetch_array( $data2 ))
{
$sitename = $info['name'];
$url = $info['siteurl'];
}
$data3 = mysql_query("SELECT user FROM pp_user where email = '$email'");
while($infouser = mysql_fetch_array( $data3 ))
{
$user3 = $infouser['user'];
}
$query="SELECT email FROM pp_user WHERE email = '$email'";
$st=mysql_query($query);
$recs=mysql_num_rows($st);
$row=mysql_fetch_object($st);
$em=$row->email;// email is stored to a variable
if ($recs == 0) {
$msg2 = "<center><font face='Verdana' size='2' color=red><b>No Password</b><br> Sorry Your address is not there in our database . You can signup and login to use our site. <BR><BR><a href='register.php'>Register</a> </center>";
}
else{
function makeRandomPassword() {
$salt = "abchefghjkmnpqrstuvwxyz0123456789";
srand((double)microtime()*1000000);
$i = 0;
while ($i <= 7) {
$num = rand() % 33;
$tmp = substr($salt, $num, 1);
$pass = $pass . $tmp;
$i++;
}
return $pass;
}
$random_password = makeRandomPassword();
$db_password = md5($random_password);
mysql_query("UPDATE pp_user SET pass='$db_password' where email='$email'") or die("ERROR:".mysql_error());
$subject = "Your password at $url";
$message2 = "Hi,$user3 we have reset your password.
Your Username is: $user3
New Password: $random_password
$url
Once logged in you can change your password
Thanks!
Site admin
$sitename
This is an automated response, please do not reply!";
mail($email, $subject, $message2, "From: yoursite.com Webmaster<admin@jyoursite.com>\n");
$msg1 = "<br>Your password has been sent! Please check your email!<br />";
$msg1 ="<br><br>Click <a href='login.php'>here</a> to login<br>";
$message = "Hi, we have reset your password.<br>
New Password: $random_password <br>
Once logged in you can change your password. <br>
An e-mail has been sent to you with your new password. <br>
Thanks! <br>
Site admin<br>
$sitename";
}
}
}
$smarty->assign('message', $message);
$smarty->assign('empty_fields_message', $empty_fields_message);
$smarty->assign('msg', $msg);
$smarty->assign('msg1', $msg1);
$smarty->assign('msg2', $msg2);
$smarty->display('forgotpassword.tpl')
?>