Sha1 Problem.

[Killzon32]

I can log into account manager but not any of my account's.
I am using sha1 I don't understand what is wrong.
encryptionType = "SHA1"
I have been using sha1 for along time.

Can anyone help me?

 

[Lessaire]

[COLOR=#000000][COLOR=#0000BB]UPDATE [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#DD0000]accounts[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]SET [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#DD0000]password[/COLOR][COLOR=#007700]` = 'Very_big_security_risk';[/COLOR][COLOR=#007700] [/COLOR][/COLOR]

If, and only if, that was directed at my tutorial, you need to examine it more closely, and should have replied there. If not, nevermind this post.

 

[Lessaire]

bump

Why are you bumping this? Your problem is solved. If you didn't look at my tutorial and make the OTHER appropriate changes to the table, that's merely your own fault.

CHAR( 40 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL

i.e edit the structure from VARCHAR(255) to CHAR(40)

but you said

UPDATE `accounts` SET `password` = sha1(`password`);

which may have destroyed your data because properly formed, but stupidly performed directly on live data, MySQL code would be

UPDATE `accounts` SET password=SHA1(password) ;
ALTER TABLE `accounts` CHANGE `password` `password` CHAR( 40 ) CHARACTER SET utf8 COLLATE utf8_swedish_ci NOT NULL ;

without the ` characters inside the SHA1 function. If MySQL hashed "`" + "password"+ "`" you are screwed. If you made a database backup, import it and then execute the code in my tutorial. If you did NOT make a backup, reset all passwords to a predetermined hash of your choosing and then talk to your players individually and give them the password and have them change it immediately.