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