account
This table holds information on all available accounts.
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| id | int | unsigned | PRI | NO | auto_increment | Identifier | |
| username | varchar(64) | 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(4) | NO | '' | ||||
| timezone_offset | smallint | signed | NO | 0 | |||
| recruiter | int | unsigned | NO | 0 | |||
Description of fields
id
The unique account ID.
username
The account name.
salt
verifier
auth components (see TrinityCore#25157)
session_key_auth
Key generated after successful auth.
session_key_bnet
- not used on 3.3.5. -
totp_secret
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
email
The e-mail address associated with this account.
reg_mail
The registration e-mail address associated with this account.
joindate
The Unix timestamp when the account was created.
last_ip
The last IP used by the person who logged in the account.
last_attempt_ip
The last IP used by the person who tried to log into the account.
failed_logins
The number of failed logins attempted on the account.
locked
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.
- 0: the user can log in from any IP, and their last_ip will be updated if it is different
- 1: the user can only log in with their last_ip.
lock_country
A country code from IP2Location
worldserver.conf IPLocationFile needs to point to the table fom the service above for this feature to be enabled.
last_login
The Unix timestamp when the account was last logged into.
online
Signifies if the account is currently logged in and online.
- 0: offline
- 1: online
expansion
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) |
mutetime
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`;
mutereason
The reason for the mute.
muteby
The character name with the rights to the .mute command that give the mute.
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:
| ID | Name |
|---|---|
| 0 | English |
| 1 | Korean |
| 2 | French |
| 3 | German |
| 4 | Chinese |
| 5 | Taiwanese |
| 6 | Spanish (EU) |
| 7 | Spanish (Latin America) |
| 8 | Russian |
os
Stores information about client's OS. Used by Warden system.
WinMac
timezone_offset
Offset to UTC in minutes.
recruiter
The account id of another account. Used for recuit-a-friend system.