Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Sign In
Not a member yet? Click here to register.

Admin password recovery

Thanks douwe_yntema. Another user told me that I could accomplish the same thing by deleting the user_admin_salt and user_admin_password from the table using phpmyadmin and then resetting it when logging into the site.
The solution wil also for you. The encryption is set to md5.
I'm having the same problem and am afraid to use this suggestion as the database shows that the password in my version of the php-fusion (7.02.07) is using sha256 as the user_algo. Can anyone confirm this fix would work for me?

Quote

Here is the code for php page:
call it page.php , upload to the root dir, and direct your browser to yoursite.com/page.php

CodeDownload  
<?php
require_once 'maincore.php';

$pass = 'yourpass';
$passadm = 'youradminpass';

dbquery("UPDATE ".DB_USERS." SET user_admin_password = md5(md5('$passadm')),user_admin_algo='md5', user_algo='md5',user_password=md5(md5('$pass')) WHERE user_id = '1' LIMIT 1;");

echo 'Done';
?>


This code will reset your password to specified.

Remove this file after use! And make a DB backup at first.
- by PolarFox


Thank you SO MUCH for this! I have tried so many old "Sure fire fixes" that didn't work that I was about to give up hope. This is the first mention I found of the DOUBLE MD-5 hashing, which the other fixes I tried didn't have, which was surely why they failed. Just to let everyone know this still works; I'm using v 7.02.07 and writing this December 11, 2017.

Quote

PolarFox wrote:

Here is the code for php page:
call it page.php , upload to the root dir, and direct your browser to yoursite.com/page.php

CodeDownload  
<?php
require_once 'maincore.php';

$pass = 'yourpass';
$passadm = 'youradminpass';

dbquery("UPDATE ".DB_USERS." SET user_admin_password = md5(md5('$passadm')),user_admin_algo='md5', user_algo='md5',user_password=md5(md5('$pass')) WHERE user_id = '1' LIMIT 1;");

echo 'Done';
?>


This code will reset your password to specified.

Remove this file after use! And make a DB backup at first.

Thanks!!! I reset my admin password!!!
Thx i try that. :)
Here is the code for php page:
call it page.php , upload to the root dir, and direct your browser to yoursite.com/page.php

CodeDownload  
<?php
require_once 'maincore.php';

$pass = 'yourpass';
$passadm = 'youradminpass';

dbquery("UPDATE ".DB_USERS." SET user_admin_password = md5(md5('$passadm')),user_admin_algo='md5', user_algo='md5',user_password=md5(md5('$pass')) WHERE user_id = '1' LIMIT 1;");

echo 'Done';
?>


This code will reset your password to specified.

Remove this file after use! And make a DB backup at first.
okay im totaly lost. i have no ide how to do that. :(
You said

Quote

ik got php my admin how do i change it there?
it's the code for PMA.

Prefix you can find in your config.php .

Quote

PolarFox wrote:

Try to use
change: YOURPREFIX_users and YOURPASSWORD

Quote

---

UPDATE YOURPREFIX_users SET user_admin_password = md5(md5('YOURPASSWORD')),user_admin_algo='md5', user_algo='md5',user_password=md5(md5('YOURPASSWORD')) WHERE user_id = '1' LIMIT 1;

After that, you password will be YOURPASSWORD



sorry how do i use that?
is this the hole code? or?
And what shut i change this into YOURPREFIX_users
Try to use
change: YOURPREFIX_users and YOURPASSWORD

Quote

---

UPDATE YOURPREFIX_users SET user_admin_password = md5(md5('YOURPASSWORD'wink),user_admin_algo='md5', user_algo='md5',user_password=md5(md5('YOURPASSWORD'wink) WHERE user_id = '1' LIMIT 1;

After that, you password will be YOURPASSWORD
It doset work. now i can not log in at all.. plzz help

Merged on Sep 21 2011 at 10:22:20:
and now i can not get a new password... what do i do?

Merged on Sep 21 2011 at 10:29:14:
ik got php my admin how do i change it there?

Quote

Neoman wrote:
i didn't o anything to PF . i just copied the code to a page in my root and opened it . that is it !

Yes, we know. We were being lazy and didn't look through the whole code. Php-Fusion 7 requires a double md5 hashed password. I still don't understand why WEC didn't just use md5(md5(...))
i didn't o anything to PF . i just copied the code to a page in my root and opened it . that is it !

Quote

SiteMaster wrote:
DOH he is duoble md5 it

first time
CodeDownload  

$pass = MD5('mynewpass'); // <-- Enter new user password 'mynewpass'
$pass_admin = MD5('mynewadminpass'); // <-- Enter new admin password 'mynewadminpass'



second time
CodeDownload  

$result = dbquery("UPDATE ".DB_USERS." SET user_password = MD5('".$pass."') WHERE  user_id = '1' LIMIT 1");
$result2 = dbquery("UPDATE ".DB_USERS." SET user_admin_password = MD5('".$pass_admin."') WHERE  user_id = '1' LIMIT 1");


Oh, my bad - didn't look in the dbupdate...
DOH he is duoble md5 it

first time
CodeDownload  

$pass = MD5('mynewpass'); // <-- Enter new user password 'mynewpass'
$pass_admin = MD5('mynewadminpass'); // <-- Enter new admin password 'mynewadminpass'



second time
CodeDownload  

$result = dbquery("UPDATE ".DB_USERS." SET user_password = MD5('".$pass."') WHERE  user_id = '1' LIMIT 1");
$result2 = dbquery("UPDATE ".DB_USERS." SET user_admin_password = MD5('".$pass_admin."') WHERE  user_id = '1' LIMIT 1");

Quote

SiteMaster wrote:

Quote

googlebot wrote:

Quote

Neoman wrote:
WEC , thanks , it worked

How?? In WEC's code, the passwords are only md5 hashed once. PHP-Fusion 7 uses double md5 hashing.


yes someone please tell us how this works

is 2x md5 not like this ?
example
md5 string: 1
md5 hash: c4ca4238a0b923820dcc509a6f75849b
md5 string: c4ca4238a0b923820dcc509a6f75849b
md5 hash: 28c8edde3d61a0411511d3b1866f0636

That is how it should have happened. But either Neoman didn't try it, or he modded v7 to only use one md5 hash (doubt it).

Quote

googlebot wrote:

Quote

Neoman wrote:
WEC , thanks , it worked

How?? In WEC's code, the passwords are only md5 hashed once. PHP-Fusion 7 uses double md5 hashing.


yes someone please tell us how this works

is 2x md5 not like this ?
example
md5 string: 1
md5 hash: c4ca4238a0b923820dcc509a6f75849b
md5 string: c4ca4238a0b923820dcc509a6f75849b
md5 hash: 28c8edde3d61a0411511d3b1866f0636

Quote

Neoman wrote:
WEC , thanks , it worked

How?? In WEC's code, the passwords are only md5 hashed once. PHP-Fusion 7 uses double md5 hashing.
thanks guys ,
WEC , thanks , it worked
Thread Information
Author
Replies
24 posts
Views
16,270 times
Last Post
Last updated on 2 years ago
You can view all discussion threads in this forum.
You cannot set up a bounty in this discussion thread.
You can start a new discussion thread in this forum.
You cannot reply in this discussion thread.
You cannot start on a poll in this forum.
You cannot upload attachments in this forum.
You can download attachments in this forum.
You cannot up or down-vote on the post in this discussion thread.