battlenet_accounts

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
id	int	unsigned	PRI	NO		auto_increment	Identifier
email	varchar(320)			NO
srp_version	tinyint	signed		NO	1
salt	binary(32)			NO
verifier	blob			NO
joindate	timestamp			NO	CURRENT_TIMESTAMP	DEFAULT_GENERATED
last_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
locale	tinyint	unsigned		NO	0
os	varchar(4)			NO	''
LastCharacterUndelete	int	unsigned		NO	0
LoginTicket	varchar(64)			YES	NULL
LoginTicketExpiry	int	unsigned		YES	NULL

Description of fields

id

The unique account ID.  

email

The e-mail address associated with this account.  

srp_version

- no description -  

salt

- no description -  

verifier

- no description -  

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.  

lock_country

- no description -  

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.  

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  

LastCharacterUndelete

- no description -  

LoginTicket

- no description -  

LoginTicketExpiry

- no description -