Password recovery for admin area

[aftab_shah76]

i forgot my admin password i am using 2.0.1 scrip please any body help me to recover my password.

[James]

http://www.phplinkdirectory.com/forum/showthread.php?t=30052&highlight=reset+admin+password

[Robertp]

I'm having the same problem and the search results threads are not helpful. I have version 2.1 and I didn't lose my password, it stopped working. While editing listings the Admin timed out, I was able to login again, but later could not. Tried everything I could think of . . .

One thread had this


on the same screen click on browse above, there u can see your "Login"

1. save the following as a file, fill the username, and the new password
2. upload it and call it from the browser

Done! ur new password is set!

Code:
<?php require_once 'init.php'; session_start(); $username = "old_username"; $password = "new_password"; $ret = $db->Execute("UPDATE `{$tables['user']['name']}` SET `PASSWORD` = ".$db->qstr(encrypt_password($password))." WHERE WHERE `LOGIN` = ".$db->qstr($username).""); if($ret === false) { echo "Error : " . $db->ErrorMsg()."<br>"; } else { echo "done"; }?>

hope this helps.

Regards
M

So what do I name the file/save it as? Where do I upload it to? How do I get the browser to call to it? I tried naming it pass.php and uploading it to the root and adding it to the path, just get site not found as my reward. I've also tried changing the password in mysql browse php_user as described, I get the same wrong user or pass message or a smarty error depending on things I've tried. How about a few more details on fixing this problem, please.

[James]

upload that file again and pm me the url please

it has to be in the ssame folder as index and submit.php

[Robertp]

Content visible to registered users only.


James: You fixed it! Thank you! That was incredibly helpful. Robert [bt]