password change

[vixio_dv]

anyone have password script with email checking?
like this :

Devastation PvP Tables

[MentaL]

[Romulan]

Very easy to create a such php scrit like this one... Basic php skills...

[rbb138]

lol, thats my site xD

As he said you just need basic php and mysql query skills, i do however think somebody released one on this forum somewhere but it didnt have email checking.
http://forum.ragezone.com/f452/chang...script-679347/

just add into that file an input for email, lines to turn that into a variable and then put into the one of the mysql querys that searches their username
& email = '$email'
google is ur friend, use it to understand the php terms.

[vixio_dv]

lol, thats my site xD

ok now i got working.. with command

pear install DB

---------- Post added at 11:58 AM ---------- Previous post was at 10:34 AM ----------

ok. now i confused add email check. but this like Q & A, help.

---------- Post added at 12:41 PM ---------- Previous post was at 11:58 AM ----------

i add this

$GetAccountInfo = Mysql_Query("SELECT * FROM users WHERE name = '$UserName'");
$GetAccountNum = Mysql_Num_Rows($GetAccountInfo);
IF ($GetAccountNum == 1) {
    $GetAccountArray = Mysql_Fetch_Array($GetAccountInfo);
    $GetPassword = $GetAccountArray['passwd'];
    $GetEmail = $GetAccountArray['email'];
    $GetPassword = addslashes($GetPassword);
    $GetEmail = addslashes($GetEmail);
    $rs = mysql_query("SELECT fn_varbintohexsubstring (1,'$GetPassword',1,0) AS result");
    $rs2 = mysql_query("SELECT fn_varbintohexsubstring (1,'$GetEmail',1,0) AS result2");
    $GetResult = Mysql_Fetch_Array($rs);
    $GetResultEmail = Mysql_Fetch_Array($rs2);
    $CheckPassword = $GetResult['result'];
    $CheckEmail = $GetResultEmail['result2'];
    IF ($Myemail == $CheckEmail) {
    IF ($EncryptOldPassword == $CheckPassword) {
        Mysql_Query("CALL changePasswd ($GetAccountInfo->quoteSmart'$UserName', $EncryptNewPassword)");
        Mysql_Query("CALL changePasswd2 ($GetAccountInfo->quoteSmart'$UserName', $EncryptNewPassword)");
        echo "<font color=green>Password for Account: <font color=red>$UserName</font> has been changed to: <font color=red>$NewPassword</font></font><br>";
}
    ELSE {
        echo "<font color=red>Account Information is Incorrect! </font><br><a href='index.php'>Go Back to Form</a><br><br>";
    }
}
    ELSE {
        echo "<font color=red>Email is Incorrect! </font><br><a href='index.php'>Go Back to Form</a><br><br>";
    }
} 

but not work always saying incorect email

[rbb138]

the email does not need to go through fn_varbintohexsubstring

it can be pulled straight out.

[vixio_dv]

ok, thanks very much. now i got working with email checking.