...
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
...
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
...