Change from Sha1 To Plain

[zayat]

Hello OtLanders, First of all I need an explanation about how to change from sha1 to plain. Because with sha1 I can't get on the players accounts, and I need to do that to see if they have a donation castle doll for example to give them the doll.
Thanks in advance.

 

[Gall]

SHA1 is used for exactly that thing that is causing your problem - making somebody who access database unable to steal accounts. I doubt that you will be able to change to plain password without resetting all passwords(and therefore risking mass hacks).

Yet if you want to check if they have addon doll by searching database in Player_depotitems and Player_items tables itemtypes for itemid of castle doll. If you had given them manually then thats its only way. If they had received them through script check it for storage id used and check player_storage tables for that storage id. If you don't know how to search for them check some tutorials for basics of using your type od database(mysql/sqlite). You will recive characters id which you can compare to nicks in player table.

 

[zayat]

I wanna go for the risk of getting hacked and I still wanna change to PLAIN.

 

[Gall]

No, seriously, I wouldn't change to plain before trying to check things in your database - as you can check player accounts passes in database you can easily use that second solution. ALSO unless you remove SHA1 usage from Znote AAC(and i guess you are still using it as you've asked how to remove this in other thread) you won't be able to use it for plain passwords. If you could manage to do that, you wouldn't be asking for solution in first place.

But, I will tell you how can you check if player did used addon doll or have it if you will post me yours addon doll script. That way you wont have to log in on player to check it.

 

[zayat]

ALSO unless you remove SHA1 usage from Znote AAC

That's what I need to do!

- - - Updated - - -

Bump