From a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 Mon Sep 17 00:00:00 2001 From: FrancescoBorzi Date: Mon, 25 Feb 2019 19:24:20 +0100 Subject: Import DB wiki from TC 335 --- docs/account_tutorial.md | 158 +++++++++++++++++++++++++++++++++++++++++++---- 1 file changed, 145 insertions(+), 13 deletions(-) (limited to 'docs/account_tutorial.md') 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** + + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field

Type

Attributes

Key

Null

Default

Extra

Comment

accountId

int(10)

unsigned

PRI

NO

0

Unique

Account Identifier

tut0

int(10)

unsigned

 

NO

0

 

 

tut1

int(10)

unsigned

 

NO

0

 

 

tut2

int(10)

unsigned

 

NO

0

 

 

tut3

int(10)

unsigned

 

NO

0

 

 

tut4

int(10)

unsigned

 

NO

0

 

 

tut5

int(10)

unsigned

 

NO

0

 

 

tut6

int(10)

unsigned

 

NO

0

 

 

tut7

int(10)

unsigned

 

NO

0

 

 

+ +**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. -- cgit