accounts
This table contains the information about the player accounts.
Structure
| Field | Type | Default | Comment |
|---|---|---|---|
| id | int(10) | Auto Num | |
| acc_name | varchar(32) | ||
| encrypted_password | varchar(42) | ||
| banned | int(10) | ||
| lastlogin | timestamp | 0000-00-00 00:00:00 | |
| lastip | varchar(16) | ||
| varchar(64) | |||
| flags | tinyint(3) | 0 | |
| forceLanguage | varchar(5) | enUS | |
| muted | int(30) | 0 | |
| banreason | varchar(255) | NULL | |
| joindate | timestamp | CURRENT_TIMESTAMP |
id
The unique account id.
acc_name
The account name
encrypted_password
If you would switch from cleartext password to encrypted passwords, execute the following sql script:
UPDATE accounts SET encrypted_password = SHA(CONCAT(UPPER(login),":",UPPER(password)));
banned
0 = not banned (default)
if it is not 0 it is unixtime,
lastlogin
The timestamp the account logged in the last time.
lastip
The ip address of the last login.
The email address of the account.
flags
The client flags:
0 - Classic WoW
8 - The Burning Crusade
16 - Wrath of the Lich King
24 - Wrath of the Lich King & The Burning Crusade
32 - Cataclysm
64 - Mists of Pandaria (untested)
128 - Warlords of Draenor (untested)
256 - Legion (untested)
forceLanguage
The lanuguage code:
frFR = french
deDE = german
ruRU = russian
muted
0 = not muted (default)
If it is not 0 it is unixtime.
banreason
The reason for banning this account.
joindate
Timestamp on account creation.