Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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:

...

LanguageCode
SQLSELECT

...

SHA1(CONCAT(UPPER(`username`),

...

':',

...

UPPER(<pass>)));
PHPsha1(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:

...