Ha ha! I don't think I've got the patience to work out a hash manually.
Use this query, replacing
name with the Account Name:
Code:
UPDATE `tblloginserveraccounts` SET `AccountPassword` = SHA(`AccountPassword`) WHERE `AccountName` = 'name'
If, for some reason, your passwords were already hashed..you'll need to re-enter them again. That query will "re-hash"
an existing hashed password and make them unusable again.
If you want to play around with the security hash function, use this query:
Code:
SELECT SHA('text');