Back-to:Auth

Table: account

This table holds information on all available accounts.

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
id	int(10)	unsigned	PRI	NO		Auto increment	Identifier
username	varchar(32)		UNI	NO	"
sha_pass_hash	varchar(40)			NO	"
sessionkey	varchar(80)			NO	"
v	varchar(64)			NO	"
s	varchar(64)			NO	"
token_key	varchar(100)			NO	''
email	varchar(255)			NO	"
reg_mail	varchar(255)			NO	''
joindate	timestamp	signed		NO	CURRENT_TIMESTAMP
last_ip	varchar(15)			NO	127.0.0.1
failed_logins	int(10)	unsigned		NO	0
locked	tinyint(3)	unsigned		NO	0
last_login	timestamp	signed		NO	0000-00-00 00:00:00
online	tinyint(3)	signed		NO	0
expansion	tinyint(3)	unsigned		NO	2
mutetime	bigint(20)	signed		NO	0
mutereason	varchar(255)	signed		NO	"
muteby	varchar(50)	signed		NO	"
locale	tinyint(3)	unsigned		NO	0
os	varchar(3)	signed		NO	"
recruiter	int(10)	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(&lt;pass&gt;)));

sessionkey

field-no-description|5

v

field-no-description|6

s

field-no-description|7

token_key

The authenticatorkey.

You could generate the key e.g. with the Google Authenticator API.

Implementationlink on Wikipedia for the Google Authenticator API

http://en.wikipedia.org/wiki/Google_Authenticator#Implementations

email

The e-mail address associated with this account.

reg_mail

The registration e-mail address associated with this account.

joindate

The date when the account was created.

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. This can be controlled with the ".account lock" GM command. If locked (1), the user can only log in with their last_ip. If unlocked (0), a user can log in from any IP, and their last_ip will be updated if it is different. ".Ban account" does not lock it.

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

Integer 0, 1 or 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.)

0 = Classic
1 = The Burning Crusade (TBC)
2 = Wrath of the Lich King (WotLK)

mutetime

The time, in Unix time, when the account will be unmuted. To see when mute will be expired you can use this query:

SELECT FROM_UNIXTIME(`mutetime`);

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 IDs

os

Stores information about client's OS. Used by Warden system.

Win
Mac

recruiter

The account ID of another account. Used for recuit-a-friend system. See account.id

TrinityCore : account