battlenet_accounts
Table: battlenet_accounts
This table holds information on all available battlenet accounts.
Structure
Field | Type | Attributes | Key | Null | Default | Extra | Comment |
int(10) | unsigned | PRI | NO | Auto increment | Identifier | ||
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.
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 |
---|---|
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