NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. |
Description of the 'account' table.
This table holds information on all available accounts.
Table Notes
This table uses the 'InnoDB' DB Engine
The Field definitions follow:
Field Name | Field Type | Nullable | Key | Default Value | Attributes | Notes |
---|---|---|---|---|---|---|
id | int(11) unsigned | NO | PRI | NULL | 'auto_increment' | The unique account ID. |
username | varchar(32) | NO | UNI | '''' | The account user name. | |
sha_pass_hash | varchar(40) | NO | '''' | This field contains the encrypted SHA1 password. | ||
gmlevel | tinyint(3) unsigned | NO | MUL | '0' | The account security level. | |
sessionkey | longtext | YES | 'NULL' | The Session Key. | ||
v | longtext | YES | 'NULL' | The validated Hash Value. | ||
s | longtext | YES | 'NULL' | Password 'Salt' Value. | ||
text | YES | 'NULL' | The e-mail address associated with this account. | |||
joindate | timestamp | NO | 'current_timestamp()' | The date when the account was created. | ||
last_ip | varchar(30) | NO | ''0.0.0.0'' | The last IP used by the person who last logged into the account. | ||
failed_logins | int(11) unsigned | NO | '0' | The number of failed logins attempted on the account. | ||
locked | tinyint(3) unsigned | NO | '0' | Indicates whether the account has been locked or not. | ||
last_login | timestamp | NO | 'current_timestamp()' | The date when the account was last logged into. | ||
active_realm_id | int(11) unsigned | NO | '0' | The last Active realm_Id the account was used on. | ||
expansion | tinyint(3) unsigned | NO | '0' | The field controls to which expansion's content a user has access. | ||
mutetime | bigint(40) unsigned | NO | '0' | The time, in Unix time, when the account will be unmuted. | ||
locale | tinyint(3) unsigned | NO | '0' | The locale used by the client logged into this account. | ||
os | varchar(3) | YES | '''' | The Operating System of the connected client | ||
playerBot | bit(1) | NO | 'b'0'' | Determines whether the account is a User or a PlayerBot |
Description of the fields
id int(11) unsigned
The unique account ID.
username varchar(32)
The account user name.
sha_pass_hash varchar(40)
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 tinyint(3) unsigned
The account security level. Different levels have access to different commands. The individual level required for a command is defined in the Mangos command table. Valid values are:
Value | Description |
---|---|
0 | Player |
1 | Moderator |
2 | Gamemaster |
3 | Administrator |
4 | Access control within the world server console only |
sessionkey longtext
The SessionKey - this is the validated result of the login negotiation. This allows disconnected clients to reconnection to their previous session.
v longtext
The validated Hash Value, this is created by using the 'Salt' value [See account.s] applied to the username/password SHA1 hash (See account.sha_pass_hash).
s longtext
Password 'Salt' Value. Initially a randomly generated value, which when applied against the SHA1 hash of the username / password combo [See account.sha_pass_hash] produces the validation hash (See account.v).
email text
The e-mail address associated with this account.
joindate timestamp
The date when the account was created.
last_ip varchar(30)
The last IP used by the person who last logged into the account.
failed_logins int(11) unsigned
The number of failed logins attempted on the account. Monitoring this field may help spotting users who try to gain access to accounts which are not their own, or who have forgotten their passwords.
locked tinyint(3) unsigned
Boolean 0 or 1 controlling if the account has been locked or not.
last_login timestamp
The date when the account was last logged into.
active_realm_id int(11) unsigned
This Field contains the RealmId of the last realm that the account was used on.
expansion tinyint(3) unsigned
The field controls to which expansion's content a user has access. By default this is set to 0, allowing access to vanilla WoW content. In mangos-zero, other values can be ignored, since there is no expansion.
Value | Expansion |
---|---|
0 | World of Warcraft * |
1 | Burning Crusade |
2 | Wrath of the Lich King |
3 | Cataclysm |
4 | Mists of Pandaria |
5 | Warlords of Draenor |
6 | Legion |
7 | Battle for Azeroth |
mutetime bigint(40) unsigned
The time, in Unix time, when the account will be unmuted.
SELECT `username`, FROM_UNIXTIME(`mutetime`) FROM `account`;
locale tinyint(3) unsigned
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.
Value | Language |
---|---|
0 | English |
1 | Korean |
2 | French |
3 | German |
4 | Chinese |
5 | Taiwanese |
6 | Spanish Spain |
7 | Spanish Latin America |
8 | Russian |
os varchar(3)
The Operating System of the connected client. This is used by the Warden Module
playerBot bit(1)
Determines whether the account is a User or a PlayerBot.
Value | Account Type |
---|---|
0 | Normal User |
1 | Playerbot account |
auto-generated by the getMaNGOS.eu MAGNET dbdocs module
Edited by Antz
Recommended Comments
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now