[iBeast]

Ok, so I did a mistake while scripting my Gamemode and did not encrypt user passwords.
And I have got around 30000 users registered in my MySQL DB.
now I cant afford to make those registered users lose stats.
is there a way I can salt passwords of already registered players ?

[S4t3K]

Do it manually lol

Multiple queries aren't available yet in pawn I think.

If you want a MD5 Generator, search on ****** (have one on my personal website, isn't very hard to find)

[Vince]

Should be. Execute these queries through phpMyAdmin or another client. To generate random salts you can use something like:

PHP код:

UPDATE testtable SET salt = SHA1(CONCAT(UUID_SHORT(), 'keystring')) 


Replacing keystring with a random sequence of characters of your choice. I've done this because UUID_SHORT(), while unique, is predictable.

Next, update the actual passwords.

PHP код:

UPDATE testtable SET pass = SHA1(CONCAT(salt, SHA1(pass))) 


You can use any combination of functions to generate the password, just make sure you remember it because you will need it in your script.

PHP код:

SELECT * FROM testtable WHERE user = '%s' AND pass = SHA1(CONCAT(salt, SHA1('%s')))