MD5 Passwords

[uDe]

Hello,

 

May I ask how to change players password from SQL? My server is using MD5 password.

[Brian]

You can also search by their login ID:

UPDATE `login` SET `user_pass` = MD5('NEW_PASSWORD') WHERE `userid`='THEIR_LOGIN_ID';

[Patskie]

Can make everything with encrypted data using MD5()

UPDATE `login` SET `user_pass` = MD5('"+<NEW PASSWORD>+"') WHERE `account_id` = '"+getcharid(3)+"'";

[Winz]

*Adding:

 

If this is an in-game NPC script, then make sure that this script will not be excecuted more than one time.

 

Have a nice day!

[uDe]

Can make everything with encrypted data using MD5()

UPDATE `login` SET `user_pass` = MD5('"+<NEW PASSWORD>+"') WHERE `account_id` = '"+getcharid(3)+"'";

 

Thank you.

You can also search by their login ID:

UPDATE `login` SET `user_pass` = MD5('NEW_PASSWORD') WHERE `userid`='THEIR_LOGIN_ID';

 

I'm using this, easy to update from sql..

 

Thank you to both of you..

[Darkpurple]

*Adding:

 

If this is an in-game NPC script, then make sure that this script will not be excecuted more than one time.

 

Have a nice day!

what does it mean，sir？

[Brian]

Well technically, you could use an in-game NPC to change your login password as many times as you want. It would all work fine, and your password would be whatever you set it to the last time you used the NPC.

Maybe Winz was thinking of this query trunk/sql-files/tools/convert_passwords.sql that converts all passwords to MD5 hashes:

UPDATE `login` SET `user_pass`=MD5(`user_pass`);

^ do NOT execute that more than once, or else you would be converting MD5-passwords to hashes of MD5 hashes.