Character tutorial
Материал из YTDB DataBase
(Различия между версиями)
NeatElves (Обсуждение | вклад) |
NeatElves (Обсуждение | вклад) |
||
| (4 промежуточные версии не показаны) | |||
| Строка 2: | Строка 2: | ||
| __TOC__ | | __TOC__ | ||
|} | |} | ||
| - | + | [[Category: Mangos characters database tables]] | |
| + | К описанию таблиц [[Charactersdb_struct|базы данных characters]]. | ||
| Строка 14: | Строка 15: | ||
|'''Field''' | |'''Field''' | ||
|'''Type''' | |'''Type''' | ||
| + | |'''Attributes''' | ||
|'''Null''' | |'''Null''' | ||
|'''Key''' | |'''Key''' | ||
|'''Default''' | |'''Default''' | ||
|'''Extra''' | |'''Extra''' | ||
| + | |'''Comments''' | ||
|- | |- | ||
|[[#account|account]] | |[[#account|account]] | ||
| - | |bigint(20) unsigned | + | |bigint(20) |
| + | |unsigned | ||
|NO | |NO | ||
|PRI | |PRI | ||
| - | |||
| | | | ||
| + | |auto_increment | ||
| + | |Account Identifier | ||
|- | |- | ||
|[[#tut0-7|tut0]] | |[[#tut0-7|tut0]] | ||
| - | |int(11) unsigned | + | |int(11) |
| + | |unsigned | ||
|NO | |NO | ||
| | | | ||
|0 | |0 | ||
| + | | | ||
| | | | ||
|- | |- | ||
|[[#tut0-7|tut1]] | |[[#tut0-7|tut1]] | ||
| - | |int(11) unsigned | + | |int(11) |
| + | |unsigned | ||
|NO | |NO | ||
| | | | ||
|0 | |0 | ||
| + | | | ||
| | | | ||
|- | |- | ||
|[[#tut0-7|tut2]] | |[[#tut0-7|tut2]] | ||
| - | |int(11) unsigned | + | |int(11) |
| + | |unsigned | ||
|NO | |NO | ||
| | | | ||
|0 | |0 | ||
| + | | | ||
| | | | ||
|- | |- | ||
|[[#tut0-7|tut3]] | |[[#tut0-7|tut3]] | ||
| - | |int(11) unsigned | + | |int(11) |
| + | |unsigned | ||
|NO | |NO | ||
| | | | ||
|0 | |0 | ||
| + | | | ||
| | | | ||
|- | |- | ||
|[[#tut0-7|tut4]] | |[[#tut0-7|tut4]] | ||
| - | |int(11) unsigned | + | |int(11) |
| + | |unsigned | ||
|NO | |NO | ||
| | | | ||
|0 | |0 | ||
| + | | | ||
| | | | ||
|- | |- | ||
|[[#tut0-7|tut5]] | |[[#tut0-7|tut5]] | ||
| - | |int(11) unsigned | + | |int(11) |
| + | |unsigned | ||
|NO | |NO | ||
| | | | ||
|0 | |0 | ||
| + | | | ||
| | | | ||
|- | |- | ||
|[[#tut0-7|tut6]] | |[[#tut0-7|tut6]] | ||
| - | |int(11) unsigned | + | |int(11) |
| + | |unsigned | ||
|NO | |NO | ||
| | | | ||
|0 | |0 | ||
| + | | | ||
| | | | ||
|- | |- | ||
|[[#tut0-7|tut7]] | |[[#tut0-7|tut7]] | ||
| - | |int(11) unsigned | + | |int(11) |
| + | |unsigned | ||
|NO | |NO | ||
| | | | ||
|0 | |0 | ||
| + | | | ||
| | | | ||
|} | |} | ||
| Строка 86: | Строка 107: | ||
<big>'''Описание полей'''</big> | <big>'''Описание полей'''</big> | ||
====account==== | ====account==== | ||
| - | + | Идентификатор аккаунта игрока. Смотри [[account#id|account.id]]. | |
====tut0-7==== | ====tut0-7==== | ||
| Строка 99: | Строка 120: | ||
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. | 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. | ||
| - | |||
| - | |||
Текущая версия на 11:59, 13 февраля 2011
|
К описанию таблиц базы данных characters.
Таблица `character_tutorial`
Таблица содержит информацию о всплывающих подсказках в игре для каждого персонажа.
Структура
| Field | Type | Attributes | Null | Key | Default | Extra | Comments |
| account | bigint(20) | unsigned | NO | PRI | auto_increment | Account Identifier | |
| tut0 | int(11) | unsigned | NO | 0 | |||
| tut1 | int(11) | unsigned | NO | 0 | |||
| tut2 | int(11) | unsigned | NO | 0 | |||
| tut3 | int(11) | unsigned | NO | 0 | |||
| tut4 | int(11) | unsigned | NO | 0 | |||
| tut5 | int(11) | unsigned | NO | 0 | |||
| tut6 | int(11) | unsigned | NO | 0 | |||
| tut7 | int(11) | unsigned | NO | 0 |
Описание полей
account
Идентификатор аккаунта игрока. Смотри 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:
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.
