Account
From UDB
|
Back to realm database list of tables.
The `account` table
This table holds information on all available accounts.
Structure
| Field | Type | Null | Key | Default | Extra |
| id | bigint(20) unsigned | NO | PRI | auto_increment | |
| username | varchar(32) | NO | UNI | ||
| sha_pass_hash | varchar(40) | NO | |||
| gmlevel | tinyint(3) unsigned | NO | MUL | 0 | |
| sessionkey | longtext | YES | |||
| v | longtext | YES | |||
| s | longtext | YES | |||
| varchar(255) | NO | ||||
| joindate | timestamp | NO | CURRENT_TIMESTAMP | ||
| tempbanned | int(10) unsigned | NO | 0 | ||
| last_ip | varchar(30) | NO | 127.0.0.1 | ||
| failed_logins | int(11) unsigned | NO | 0 | ||
| locked | tinyint(3) unsigned | NO | 0 | ||
| last_login | timestamp | NO | 0000-00-00 00:00:00 | ||
| online | tinyint(4) | NO | 0 | ||
| expansion | tinyint(3) unsigned | NO | 0 | ||
| mutetime | bigint(40) unsigned | NO | 0 | ||
| locale | tinyint(3) unsigned | NO | 0 |
Description of the fields
id
The unique account ID.
username
The account user name.
sha_pass_hash
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>)));
gmlevel
The account security level. Different levels have access to different commands. The individual level required for a command is defined in the command table.
sessionkey
v
s
The e-mail address associated with this account.
joindate
The date when the account was created.
tempbanned
Boolean 0 or 1 controlling if the account is temporarily banned or not.
last_ip
The last IP used by the person who logged in the account.
failed_logins
The number of failed logins attempted on the account.
locked
Boolean 0 or 1 controlling if the account has been locked or not.
last_login
The date when the account was last logged into.
online
Boolean 0 or 1 controlling if the account is currently logged in and online.
expansion
Boolean 0 or 1 controlling if the client logged in on the account has regular WoW or WoW:TBC installed. The world server will block access to accounts with 0 in this field in the TBC areas in-game.
mutetime
The time, in Unix time, when the account will be unmuted.
locale
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
