diff options
Diffstat (limited to 'docs/account.md')
| -rw-r--r-- | docs/account.md | 461 |
1 files changed, 436 insertions, 25 deletions
diff --git a/docs/account.md b/docs/account.md index 0e3473a..bc85ceb 100644 --- a/docs/account.md +++ b/docs/account.md @@ -1,25 +1,436 @@ -[Database Structure](Database-Structure) > [Auth-Database](Auth-Database) > [account](account) - -Column | Type | Description ---- | --- | --- -Id | int(10) unsigned | -Username | varchar(32) | -Sha_pass_hash | varchar(40) | -Sessionkey | varchar(80) | -V | varchar(64) | -S | varchar(64) | -Email | varchar(254) | -Joindate | timestamp | -Last_ip | varchar(15) | -Failed_logins | int(10) unsigned | -Locked | tinyint(3) unsigned | -Last_login | timestamp | -totaltime | int(10) unsigned [0] | total time played on all characters -Online | tinyint(3) unsigned | -Expansion | tinyint(3) unsigned | -Mutetime | bigint(20) | -Mutereason | varchar(255) | -Muteby | varchar(50) | -Locale | tinyint(3) unsigned | -Os | varchar(3) | -Recruiter | int(10) unsigned | +# account + +# Table: account** +** + +This table holds information on all available accounts. + +## Structure + +<table> +<tbody> +<tr class="odd"> +<td><p><strong>Field</strong></p></td> +<td><p><strong>Type</strong></p></td> +<td><p><strong>Attributes</strong></p></td> +<td><p><strong>Key</strong></p></td> +<td><p><strong>Null</strong></p></td> +<td><p><strong>Default</strong></p></td> +<td><p><strong>Extra</strong></p></td> +<td><p><strong>Comment</strong></p></td> +</tr> +<tr class="even"> +<td><p><a href="#account-id">id</a></p></td> +<td><p>int(10)</p></td> +<td><p>unsigned</p></td> +<td><p>PRI</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p>Auto increment</p></td> +<td><p>Identifier</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#account-username">username</a></p></td> +<td><p>varchar(32)</p></td> +<td><p><br /> +</p></td> +<td><p>UNI</p></td> +<td><p>NO</p></td> +<td><p>"</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="#account-sha_pass_hash">sha_pass_hash</a></p></td> +<td><p>varchar(40)</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +<td><p>NO</p></td> +<td><p>"</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#account-sessionkey">sessionkey</a></p></td> +<td><p>varchar(80)</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +<td><p>NO</p></td> +<td><p>"</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="#account-v">v</a></p></td> +<td><p>varchar(64)</p></td> +<td><br /> +</td> +<td><p><br /> +</p></td> +<td><p>NO</p></td> +<td><p>"</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#account-s">s</a></p></td> +<td><p>varchar(64)</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +<td><p>NO</p></td> +<td><p>"</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><a href="#account-token_key">token_key</a></td> +<td>varchar(100)</td> +<td><br /> +</td> +<td><br /> +</td> +<td>NO</td> +<td>''</td> +<td><br /> +</td> +<td><br /> +</td> +</tr> +<tr class="odd"> +<td><p><a href="#account-email">email</a></p></td> +<td><p>varchar(255)</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +<td><p>NO</p></td> +<td><p>"</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><a href="#account-reg_mail">reg_mail</a></td> +<td>varchar(255)</td> +<td><br /> +</td> +<td><br /> +</td> +<td>NO</td> +<td>''</td> +<td><br /> +</td> +<td><br /> +</td> +</tr> +<tr class="odd"> +<td><p><a href="#account-joindate">joindate</a></p></td> +<td><p>timestamp</p></td> +<td><p>signed</p></td> +<td><p><br /> +</p></td> +<td><p>NO</p></td> +<td><p>CURRENT_TIMESTAMP</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="#account-last_ip">last_ip</a></p></td> +<td><p>varchar(15)</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +<td><p>NO</p></td> +<td><p>127.0.0.1</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#account-failed_logins">failed_logins</a></p></td> +<td><p>int(10)</p></td> +<td><p>unsigned</p></td> +<td><p><br /> +</p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="#account-locked">locked</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p><br /> +</p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#account-last_login">last_login</a></p></td> +<td><p>timestamp</p></td> +<td><p>signed</p></td> +<td><p><br /> +</p></td> +<td><p>NO</p></td> +<td><p>0000-00-00 00:00:00</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="#account-online">online</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>signed</p></td> +<td><p><br /> +</p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#account-expansion">expansion</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p><br /> +</p></td> +<td><p>NO</p></td> +<td><p>2</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="#account-mutetime">mutetime</a></p></td> +<td><p>bigint(20)</p></td> +<td><p>signed</p></td> +<td><p><br /> +</p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><a href="#account-mutereason">mutereason</a></td> +<td>varchar(255)</td> +<td>signed</td> +<td><br /> +</td> +<td>NO</td> +<td><p>"</p></td> +<td><br /> +</td> +<td><br /> +</td> +</tr> +<tr class="even"> +<td><a href="#account-muteby">muteby</a></td> +<td>varchar(50)</td> +<td>signed</td> +<td><br /> +</td> +<td>NO</td> +<td><p>"</p></td> +<td><br /> +</td> +<td><br /> +</td> +</tr> +<tr class="odd"> +<td><p><a href="#account-locale">locale</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p><br /> +</p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="#account-os">os</a></p></td> +<td><p>varchar(3)</p></td> +<td><p>signed</p></td> +<td><p><br /> +</p></td> +<td><p>NO</p></td> +<td><p>"</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#account-recruiter">recruiter</a></p></td> +<td><p>int(10)</p></td> +<td><p>unsigned</p></td> +<td><p><br /> +</p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +</tbody> +</table> + +## Description of the fields + +### id + +The unique account ID. + +### username + +The account user name. + +### sha\_pass\_hash + +This field contains the encrypted password. The encryption is SHA1 and is in the following format: username:password. The SQL to create the password (or to compare with the current hash) is: + +| Language | Code | +|----------|---------------------------------------------------------------------| +| SQL | SELECT SHA1(CONCAT(UPPER(\`username\`), ':', UPPER(<pass>))); | +| PHP | sha1(strtoupper($username).':'.strtoupper($password)); | + +### sessionkey + +`field-no-description|5` + +### v + +`field-no-description|6` + +### s + +`field-no-description|7` + +### **token\_key** + +The authenticator key. + +Key can be generated through the Google Authenticator API, a 3rd-party TOTP generator, or manually specified (must be a Base32-compliant expression that is 16 characters). + +Implementation link on Wikipedia for the Google Authenticator API + +<http://en.wikipedia.org/wiki/Google_Authenticator#Implementations> + +### email + +The e-mail address associated with this account. + +### reg\_mail + +The registration e-mail address associated with this account. + +### joindate + +The date when the account was created. + +### last\_ip + +The last IP used by the person who logged in the account. + +### failed\_logins + +The number of failed logins attempted on the account. + +### locked + +Boolean 0 or 1 controlling if the account has been locked or not. This can be controlled with the ".account lock" GM command. If locked (1), the user can only log in with their [last\_ip](#account-last_ip). If unlocked (0), a user can log in from any IP, and their last\_ip will be updated if it is different. ".Ban account" does not lock it. + +### last\_login + +The date when the account was last logged into. + +### online + +Boolean 0 or 1 controlling if the account is currently logged in and online. + +### expansion + +Integer 0, 1 or 2 controlling if the client logged in on the account has any expansions. (for example if client is TBC, but expansion is set to 0, it will not be able to enter outlands and etc.) + +- 0 = Classic +- 1 = The Burning Crusade (TBC) +- 2 = Wrath of the Lich King (WotLK) +- 3 = Cataclysm +- 4 = Mist of Pandaria (MOP) +- 5 = Warlords of Draenor (WOD) +- 6 = Legion + +### mutetime + +The time, in Unix time, when the account will be unmuted. To see when mute will be expired you can use this query: + +``` cpp +SELECT FROM_UNIXTIME(`mutetime`); +``` + +### mutereason + +The reason for the mute. + +### muteby + +The character name with the rights to the .mute command that give the mute. + +### locale + +The locale used by the client logged into this account. If multiple locale data has been configured and added to the world servers, the world servers will return the proper locale strings to the client. See [localization IDs](Localization_lang) + +### os + +Stores information about client's OS. Used by Warden system. + +- Win +- Mac + +### recruiter + +The account ID of another account. Used for recuit-a-friend system. See [account.id](#account-id) + +## Attachments: + +{width="8" height="8"} [Vbd5vtN.png](attachments/2130004/2131663.png) (image/png) + |