battlenet_accounts

Back-to:Auth

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

emailvarchar(320)

NO


sha_pass_hashvarchar(64)

NO''

vvarchar(256)

NO''

svarchar(64)

NO''

sessionKeyvarchar(128)

NO''

joindatetimestamp

NOCURRENT_TIMESTAMP

last_ipvarchar(15)

NO'127.0.0.1'

failed_loginsint(10)unsigned
NO'0'

lockedtinyint(3)unsigned
NO'0'

lock_countryvarchar(2)

NO'00'

last_logintimestamp

NO '0000-00-00 00:00:00'

onlinetinyint(3)unsigned
NO'0'

locale tinyint(3)unsigned
NO'0'

osvarchar(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:

LanguageCode
PHPbin2hex(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