Zurück zur 'auth' Datenbank Struktur

The `account` table

This table holds information on all available accounts.


Field Type Attributes Key Null Default Extra Comment
id int(11) unsigned PRI NO NULL Auto increment Identifier
username varchar(32) signed UNI NO
sha_pass_hash varchar(40) signed NO
sessionkey longtext signed YES NULL
v longtext signed YES NULL
s longtext signed YES NULL
email text signed YES NULL
joindate timestamp signed NO CURRENT_TIMESTAMP
last_ip varchar(30) signed NO
failed_logins int(11) unsigned NO 0
locked tinyint(3) unsigned NO 0
last_login timestamp signed NO 0000-00-00 00:00:00
online tinyint(4) signed NO 0
expansion tinyint(3) unsigned NO 2
mutetime bigint(40) unsigned NO 0
locale tinyint(3) unsigned NO 0
recruiter int(11) signed NO 0

Description of the fields

id Bearbeiten

The unique account ID.

username Bearbeiten

The account user name.

sha_pass_hash Bearbeiten

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:

SELECT SHA1(CONCAT(UPPER(`username`), ':', UPPER(<pass>)));

sessionkey Bearbeiten

Session key used for checking the session validity and handling reconnects to the authserver in case of switching realms.

v Bearbeiten

Password verifier. Part of the SRP-6 protocol implementation.

s Bearbeiten

User's salt. Part of the SRP-6 protocol implementation.

email Bearbeiten

The e-mail address associated with this account.

joindate Bearbeiten

The date when the account was created.

last_ip Bearbeiten

The last IP used by the person who logged in the account.

failed_logins Bearbeiten

The number of failed logins attempted on the account.

locked Bearbeiten

Boolean 0 or 1 controlling if the account has been locked or not.

last_login Bearbeiten

The date when the account was last logged into.

online Bearbeiten

Boolean 0 or 1 controlling if the account is currently logged in and online.

expansion Bearbeiten

Boolean 0 or 1 controlling if the client logged in on the account has any expansions. (for example if client is TBC, but expansion is set to 0, it will not be able to enter outlands and etc.)

mutetime Bearbeiten

The time, in Unix time, when the account will be unmuted. To see when mute will be expired you can use this query:


locale Bearbeiten

The locale used by the client logged into this account. If multiple locale data has been configured and added to the world servers, the world servers will return the proper locale strings to the client. See localization IDs

recruiter Bearbeiten

The account ID of the recruiter. See