Table: battlenet_accounts

This table holds information on all available battlenet accounts.

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
id	int(10)	unsigned	PRI	NO		Auto increment	Identifier
email	varchar(320)			NO
sha_pass_hash	varchar(64)			NO	''
v	varchar(256)			NO	''
s	varchar(64)			NO	''
sessionKey	varchar(128)			NO	''
joindate	timestamp			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'
lock_country	varchar(2)			NO	'00'
last_login	timestamp			NO	'0000-00-00 00:00:00'
online	tinyint(3)	unsigned		NO	'0'
locale	tinyint(3)	unsigned		NO	'0'
os	varchar(3)			NO	''

Description of the fields

id

The unique account ID.

email

field-no-description|2

sha_pass_hash

This field contains the encrypted password. The encryption is bin2hex and is in the following format: email:password. The SQL to create the password (or to compare with the current hash) is:

Language	Code

Language	Code
PHP	bin2hex(strrev(hex2bin(strtoupper(hash("sha256",strtoupper(hash("sha256", strtoupper($email)).":".strtoupper($password)))))));

v

field-no-description|4

s

field-no-description|5

sessionKey

field-no-description|6

joindate

field-no-description|7

last_ip

field-no-description|8

failed_logins

field-no-description|9

locked

field-no-description|10

lock_country

field-no-description|11

last_login

field-no-description|12