...
This field contains the encrypted password. The encryption is SHA1 and is in the following format: username:password. The SQL to create the password (or to compare with the current hash) is:
...
| Language | Code |
|---|---|
| SQL | SELECT |
...
| SHA1(CONCAT(UPPER(`username`), |
...
| ':', |
...
| UPPER(<pass>))); | |
| PHP | sha1(strtoupper($username).':'.strtoupper($password)); |
sessionkey
field-no-description|5
...
- 0 = Classic
- 1 = The Burning Crusade (TBC)
- 2 = Wrath of the Lich King (WotLK)
- 3 = Cataclysm
- 4 = Mist of Pandaria (MOP)
- 5 = Warlords of Draenor (WOD)
- 6 = Legion
mutetime
The time, in Unix time, when the account will be unmuted. To see when mute will be expired you can use this query:
...