SA-MP Forums Archive
Password Salting! - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Password Salting! (/showthread.php?tid=496520)



Password Salting! - iBeast - 22.02.2014

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 ?


Re : Password Salting! - S4t3K - 22.02.2014

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)


Re: Password Salting! - Vince - 22.02.2014

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')))