Windows SQL Query?

[Justin123456]

Is there a SQL Query that will change "Sha1" passwords to "plain" passwords?

 

[Vendeliko]

no u do it in config.lua

 

[Deleted member 92788]

Ye as Vendeliko said, in config.lua

 

[Justin123456]

I tried that it doesn't work it still makes the passwords in "Sha1" and it also gives them a "Salt"... Idk what that mean though..

 

[Justin123456]

This is what is in my config.lua:

encryptionType = "plain"

 

[Chris]

You cannot reverse the encryption. That's the whole point of using encrypted passwords.

This is what you could do if you need to access one of your players' accounts;

1. Store their current encrypted password in a temporary text file.
2. Run the first query mentioned below this list, in your phpMyAdmin (or whatever program that you may use).
3. Login with your new password.
4. Once you're done doing whatever you were supposed to do, run the second query below this list.

If you do not do the first and last step, the player will have no way of logging in again. So those steps are vital. And you should also preferably do this at a time where no other player can login, or at a time where most people sleep or whatever.

UPDATE `accounts` SET `password` = SHA1('YOUR NEW PASSWORD HERE') WHERE `name` = 'THE ACCOUNT NAME HERE';

UPDATE `accounts` SET `password` = 'THE OLD PASSWORD HERE' WHERE `name` = 'THE ACCOUNT NAME HERE';

PS. Do not forget to substitute the "YOUR NEW PASSWORD HERE", "THE ACCOUNT NAME HERE" and "THE OLD PASSWORD HERE" placeholders with the appropriate value.

 

[Justin123456]

I don't need to access anyones account, it's just that's the only way I've found out how to fix the account manager. If you try to log on it with their account with the "Sha1" Password and the "Salt" thing then it will say "Invalid Password" However, when you change the password from "Sha1" to "Plain" It works. I can't do this to everyones account though because it's encrypted : / I've only been able to do it with a couple friends... And it's worked every time

But for those that I don't know their password, I can't do it But if you know another way how to fix the account manager for TFS 0.4 Then that'd be just as helpful

 

[Vendeliko]

SHA1 Decrypter - SHA1 Decryption, Free SHA1 Decryptor, SHA1 Cracker, SHA1 Security

 

[Justin123456]

That doesn't work

 

[Chris]

The reason that is not working for you, is that it is not actually a decrypter, but rather a database with a bunch of user-submitted hashed strings and their equivalent unhashed value. Meaning that some of the more common passwords may be decrypted, but certainly not all of them.

And as for your issue with the Accounts Manager, I did not completely understand what you meant. Do you mind trying to explain it a little bit better? Well appreciated!

 

[Justin123456]

Sure, when you log into account manager with 1/1 you can make an account and a character, however if you try to log onto the account manager on that account, it will say "Invalid Password"

 

[Chris]

What is your encryption type set to within your config.lua file? And, if you have a look within the accounts table inside your database, does the Account Manager's password seem to be encrypted?

 

[Justin123456]

The encyption type is set to "plain" but no, the account manager's password is not encrypted.

 

[Chris]

Thus that account works, but the regular account passwords are encrypted?

 

[Justin123456]

Yes, the account manager's password is not encrypted. It's just 1/1 and you can still log on it but when you make a new account it encrypts the password of the account just made