Stupid me changed the password. Heeelp?

[Leif André]

Hi.

I'm using Subdreamer Light and installed it for a friend. He wanted to change the username and password after I had installed it for him, so I opened up myphpadmin and found the user table. I changed the username and password, but now I get an error message "wrong password supplied"...

I guess a reinstall will delete everything I have done?

Any ideas on how to fix this? I am so stupid, should never do things like that :(

[Ziad]

You don't have to reinstall and delete everything!
Subdreamer passwords first go through the md5() function before being saved in the database. So all you need to do is apply that function on his password and save the result in the database.

I attached a script to this post that will display a password md5() style ;)
Just upload it to your site and enter his password and then enter the result you get into his database :)

[Leif André]

JIIIPPIAIOOOO!! :D

That worked! I you were a (beautiful) woman, I would kiss you ;) Thanks, you saved my life.

So to anyone that wants to change username and password:
1. Change the username in the table "userprivileges".
2. Upload the password.php file to the server. Enter the password you like to use and hit enter. Copy the text that appears.
3. Change the username in the table "users" and use the text from 2. and put that in the password field.

Life is good :)

[Ziad]

:)

Yup, that's to everyone that's running Subdreamer Light.
With the pro version, you can do all of that in the admin panel ;)

[silvrhand]

Yah,

I had to do this today on subdreamer light:

update users set password=MD5('whateverpass') where userid='1';

That should fix it as well.

[screamy]

You don't have to reinstall and delete everything!
Subdreamer passwords first go through the md5() function before being saved in the database. So all you need to do is apply that function on his password and save the result in the database.

I attached a script to this post that will display a password md5() style ;)
Just upload it to your site and enter his password and then enter the result you get into his database :)


i can't download the script :s

when i click the zip "screamy, you do not have permission to access this page. This could be due to one of several reasons:

1. Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
2. If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.
"
appears

[screamy]

I fixed it already.

But i had to change the username in the table USERS not (only) USERPRIVILEGES...

after that i ran the sql script silvrhand posted.

[Ziad]

You need to be a Subdreamer Pro member to download Subdreamer Pro or other scripts on this forum.