diff options
Diffstat (limited to 'docs/account_tutorial.md')
| -rw-r--r-- | docs/account_tutorial.md | 158 |
1 files changed, 145 insertions, 13 deletions
diff --git a/docs/account_tutorial.md b/docs/account_tutorial.md index b543bf1..6ee1bf3 100644 --- a/docs/account_tutorial.md +++ b/docs/account_tutorial.md @@ -1,13 +1,145 @@ -[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [account_tutorial](account_tutorial) - -Column | Type | Description ---- | --- | --- -AccountId | int(10) unsigned | -Tut0 | int(10) unsigned | -Tut1 | int(10) unsigned | -Tut2 | int(10) unsigned | -Tut3 | int(10) unsigned | -Tut4 | int(10) unsigned | -Tut5 | int(10) unsigned | -Tut6 | int(10) unsigned | -Tut7 | int(10) unsigned | +# account\_tutorial + +`Back-to:Characters` + +**The \`account\_tutorial\` table** + +This table is used to store the tutorial state of all the accounts. + +**Structure** + +<table> +<colgroup> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +</colgroup> +<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_tutorial-accountId">accountId</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>0</p></td> +<td><p>Unique</p></td> +<td><p>Account Identifier</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#account_tutorial-tut0-7">tut0</a></p></td> +<td><p>int(10)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#account_tutorial-tut0-7">tut1</a></p></td> +<td><p>int(10)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#account_tutorial-tut0-7">tut2</a></p></td> +<td><p>int(10)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#account_tutorial-tut0-7">tut3</a></p></td> +<td><p>int(10)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#account_tutorial-tut0-7">tut4</a></p></td> +<td><p>int(10)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#account_tutorial-tut0-7">tut5</a></p></td> +<td><p>int(10)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#account_tutorial-tut0-7">tut6</a></p></td> +<td><p>int(10)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#account_tutorial-tut0-7">tut7</a></p></td> +<td><p>int(10)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +<td><p> </p></td> +</tr> +</tbody> +</table> + +**Description of the fields** + +### guid + +Account of the player. See [account.id](account_2130004.html#account-id). + +### tut0-7 + +These values 32bits flags. So 8 x 32bits values makes 256 bits available to store 256 tutorial messages status. + +Each bit means: + +``` cpp + 0 - Not yet shown + 1 - Shown +``` + +This is used to diplay only tutorial messages the character did not see before. + +Unselecting the "Show tutorial" option in game, makes all bits to be set, so all tutX columns will contain then 11111111111111111111111111111111 binary = 4294967295 in decimal after this option is changed. |
