reset password
""){
#echo "requesting password: ";
$stmt = $pdodb->prepare("SELECT ID,username,password,emailis FROM girls WHERE (username=:user OR emailis=:user) LIMIT 1");
$stmt->setFetchMode(PDO::FETCH_ASSOC);
$stmt->execute(array(':user' => trim($_REQUEST["useris"])));
if ($stmt->rowCount() > 0) {
//echo 'found';
while($i2=$stmt->fetch()){
$user_id = $i2["ID"];
$emailis = $i2["emailis"];
$useris = $i2["username"];
}
$resetcode = uniqid();
$stmt2 = $pdodb->prepare("INSERT INTO passreset(mid,resetcode) VALUES(:mid,:resetcode) ON DUPLICATE KEY UPDATE resetcode=:resetcode");
$stmt2->bindParam(':mid',$user_id);
$stmt2->bindParam(':resetcode',$resetcode);
$stmt2->execute();
$subject = 'misskin.org password reset';
$body = '
user: '.$useris.'
Reset: https://www.misskin.org/reset.php?resetcode='.$resetcode.'
profile
https://www.misskin.org/'.str_replace(" ","-",$username).'
-------------------------------------------------------
';
//echo $email;
mandrill('info@misskin.org',$emailis, $subject, $body);
echo 'user found.
email: '.mask_email($emailis).'
';
}else{
echo '(user not found)
';
}
}
?>