Back to 'vw_rbac' Return to auth Go to 'account_access'
This table holds information on all available accounts.
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| id | int | unsigned | PRI | NO | auto_increment | Identifier | |
| username | varchar(32) | UNI | NO | '' | |||
| salt | binary(32) | NO | |||||
| verifier | binary(32) | NO | |||||
| session_key_auth | binary(40) | YES | NULL | ||||
| session_key_bnet | varbinary(64) | YES | NULL | ||||
| totp_secret | varbinary(128) | YES | NULL | ||||
| varchar(255) | NO | '' | |||||
| reg_mail | varchar(255) | NO | '' | ||||
| joindate | timestamp | NO | CURRENT_TIMESTAMP | DEFAULT_GENERATED | |||
| last_ip | varchar(15) | NO | 127.0.0.1 | ||||
| last_attempt_ip | varchar(15) | NO | 127.0.0.1 | ||||
| failed_logins | int | unsigned | NO | 0 | |||
| locked | tinyint | unsigned | NO | 0 | |||
| lock_country | varchar(2) | NO | 00 | ||||
| last_login | timestamp | YES | NULL | ||||
| online | tinyint | unsigned | NO | 0 | |||
| expansion | tinyint | unsigned | NO | 2 | |||
| mutetime | bigint | signed | NO | 0 | |||
| mutereason | varchar(255) | NO | '' | ||||
| muteby | varchar(50) | NO | '' | ||||
| locale | tinyint | unsigned | NO | 0 | |||
| os | varchar(3) | NO | '' | ||||
| timezone_offset | smallint | signed | NO | 0 | |||
| recruiter | int | unsigned | NO | 0 |
The unique account ID.
The account name.
auth components (see TrinityCore#25157)
Key generated after successful auth.
- not used on 3.3.5. -
The authenticator key.
Key can be generated through the Google Authenticator API, a 3rd-party TOTP generator, or manually specified.
Implementation link on Wikipedia for the Google Authenticator API
The e-mail address associated with this account.
The registration e-mail address associated with this account.
The Unix timestamp when the account was created.
The last IP used by the person who logged in the account.
The last IP used by the person who tried to log into the account.
The number of failed logins attempted on the account.
Controlls if the account has been locked to it's last IP. This can be controlled with the .account lock command.
The .ban account command does not lock it.
A country code from IP2Location
worldserver.conf IPLocationFile needs to point to the table fom the service above for this feature to be enabled.
The Unix timestamp when the account was last logged into.
Signifies if the account is currently logged in and online.
Integer 0 – 2 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.)
| Value | Expansion |
|---|---|
| 0 | Vanilla |
| 1 | The Burning Crusade (TBC) |
| 2 | Wrath of the Lich King (WotLK) |
The Unix timestamp, when the account will be unmuted.
To see when mute will be expired you can use this query:
SELECT FROM_UNIXTIME(`mutetime`) FROM `account`;
The reason for the mute.
The character name with the rights to the .mute command that give the mute.
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:
| ID | Name |
|---|---|
| 0 | English |
| 1 | Korean |
| 2 | French |
| 3 | German |
| 4 | Chinese |
| 5 | Taiwanese |
| 6 | Spanish (EU) |
| 7 | Spanish (Latin America) |
| 8 | Russian |
Stores information about client's OS. Used by Warden system.
WinMacOffset to UTC in minutes.
The account id of another account. Used for recuit-a-friend system.