HELP Account Manager in SHA1

[weverton]

HELP
convert sha1 passwords for plain take much
repp*

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

Erro

consulta SQL:

UPDATE `accounts` SET `password` = plaintext(
`password`
)

Mensagens do MySQL : Documentação
#1305 - FUNCTION sei.plaintext does not exist

 

[Chris]

I am afraid you cannot convert SHA1 back to plaintext, at least not very easily. ;-)

 

[weverton]

;/ helppppppp

 

[Chris]

You could do something like;

UPDATE `accounts` SET `password` = CONCAT( `name`, "-", SUBSTR( LOWER( REVERSE( `name` ) ), 1, 3 ) );

Which would set the password to their account name followed by a hyphen and the last three characters (in a reverse order) of their account name in lower case (e.g. if your account name would be Chris, the new password would be Chris-sir, weverton would become weverton-not and so on).

Then all you would have to do is change your server encryption back to plain text, make sure the AAC that you're using (if any at all) also works with plain passwords and publish a news-item with the information I described in the paragraph above.

EDIT: You could (should!) also recommend people to change their passwords as quickly as possible, or create a script that asks them to change them the first time they login.

 

[weverton]

is how to read sha1 passwords plain?

 

[Chris]

You cannot.

 

[weverton]

I Reset

how do ot website and be 100% plain?

 

[Sweddy]

config.lua and config.php doing it plain instead of sha1 ;o?

 

[weverton]

I did that but when I enter I will create acc and enter the account manager's password invalid

 

[Sweddy]

Change the acc manager's account info in phpmyadmin manually to the password you want.

 

[JoSePh15_]

Znote wrote a link somewhere to convert from from sha1 to plain and vise versa, use it and change the acc manager's password back to 1/1

 

[weverton]

yes i put 1 / 1 but when I create character password invalid

 

[weverton]

help D:

 

[weverton]

bump