Gossip menu option
Материал из YTDB DataBase
(Различия между версиями)
NeatElves (Обсуждение | вклад) |
NeatElves (Обсуждение | вклад) |
||
Строка 14: | Строка 14: | ||
|'''Field''' | |'''Field''' | ||
|'''Type''' | |'''Type''' | ||
+ | |'''Attributes''' | ||
|'''Null''' | |'''Null''' | ||
|'''Key''' | |'''Key''' | ||
|'''Default''' | |'''Default''' | ||
- | |''' | + | |'''Comments''' |
|- | |- | ||
|[[#menu_id|menu_id]] | |[[#menu_id|menu_id]] | ||
- | |SMALLINT(6) | + | |SMALLINT(6) |
+ | |unsigned | ||
|NO | |NO | ||
|PRI | |PRI | ||
Строка 27: | Строка 29: | ||
|- | |- | ||
|[[#id|id]] | |[[#id|id]] | ||
- | |SMALLINT(6) | + | |SMALLINT(6) |
+ | |unsigned | ||
|NO | |NO | ||
|PRI | |PRI | ||
Строка 34: | Строка 37: | ||
|- | |- | ||
|[[#option_icon|option_icon]] | |[[#option_icon|option_icon]] | ||
- | |MEDIUMINT(8) | + | |MEDIUMINT(8) |
+ | |unsigned | ||
|NO | |NO | ||
| | | | ||
Строка 42: | Строка 46: | ||
|[[#option_text|option_text]] | |[[#option_text|option_text]] | ||
|TEXT | |TEXT | ||
+ | | | ||
|YES | |YES | ||
| | | | ||
Строка 48: | Строка 53: | ||
|- | |- | ||
|[[#option_id|option_id]] | |[[#option_id|option_id]] | ||
- | |TINYINT(3) | + | |TINYINT(3) |
+ | |unsigned | ||
|NO | |NO | ||
| | | | ||
Строка 55: | Строка 61: | ||
|- | |- | ||
|[[#npc_option_npcflag|npc_option_npcflag]] | |[[#npc_option_npcflag|npc_option_npcflag]] | ||
- | |INT(10) | + | |INT(10) |
+ | |unsigned | ||
|NO | |NO | ||
| | | | ||
Строка 62: | Строка 69: | ||
|- | |- | ||
|[[#action_menu_id|action_menu_id]] | |[[#action_menu_id|action_menu_id]] | ||
- | |MEDIUMINT(8) | + | |MEDIUMINT(8) |
+ | |unsigned | ||
|NO | |NO | ||
| | | | ||
Строка 69: | Строка 77: | ||
|- | |- | ||
|[[#action_poi_id|action_poi_id]] | |[[#action_poi_id|action_poi_id]] | ||
- | |MEDIUMINT(8) | + | |MEDIUMINT(8) |
+ | |unsigned | ||
|NO | |NO | ||
| | | | ||
Строка 76: | Строка 85: | ||
|- | |- | ||
|[[#action_script_id|action_script_id]] | |[[#action_script_id|action_script_id]] | ||
- | |MEDIUMINT(8) | + | |MEDIUMINT(8) |
+ | |unsigned | ||
|NO | |NO | ||
| | | | ||
Строка 83: | Строка 93: | ||
|- | |- | ||
|[[#box_coded|box_coded]] | |[[#box_coded|box_coded]] | ||
- | |TINYINT(3) | + | |TINYINT(3) |
+ | |unsigned | ||
|NO | |NO | ||
| | | | ||
Строка 90: | Строка 101: | ||
|- | |- | ||
|[[#box_money|box_money]] | |[[#box_money|box_money]] | ||
- | |INT(11) | + | |INT(11) |
- | | | + | |unsigned |
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
- | + | ||
|NO | |NO | ||
| | | | ||
Строка 105: | Строка 110: | ||
|[[#box_text|box_text]] | |[[#box_text|box_text]] | ||
|TEXT | |TEXT | ||
+ | | | ||
|YES | |YES | ||
| | | | ||
Строка 110: | Строка 116: | ||
| | | | ||
|- | |- | ||
- | |[[# | + | |[[#cond_1-3|cond_1]] |
- | |TINYINT(3) | + | |TINYINT(3) |
+ | |unsigned | ||
|NO | |NO | ||
| | | | ||
Строка 118: | Строка 125: | ||
|- | |- | ||
|[[#cond_x_val_x|cond_1_val_1]] | |[[#cond_x_val_x|cond_1_val_1]] | ||
- | |MEDIUMINT(8) | + | |MEDIUMINT(8) |
+ | |unsigned | ||
|NO | |NO | ||
| | | | ||
Строка 125: | Строка 133: | ||
|- | |- | ||
|[[#cond_x_val_x|cond_1_val_2]] | |[[#cond_x_val_x|cond_1_val_2]] | ||
- | |MEDIUMINT(8) | + | |MEDIUMINT(8) |
+ | |unsigned | ||
|NO | |NO | ||
| | | | ||
Строка 131: | Строка 140: | ||
| | | | ||
|- | |- | ||
- | |[[# | + | |[[#cond_1-3|cond_2]] |
- | |TINYINT(3) | + | |TINYINT(3) |
+ | |unsigned | ||
|NO | |NO | ||
| | | | ||
Строка 139: | Строка 149: | ||
|- | |- | ||
|[[#cond_x_val_x|cond_2_val_1]] | |[[#cond_x_val_x|cond_2_val_1]] | ||
- | |MEDIUMINT(8) | + | |MEDIUMINT(8) |
+ | |unsigned | ||
|NO | |NO | ||
| | | | ||
Строка 146: | Строка 157: | ||
|- | |- | ||
|[[#cond_x_val_x|cond_2_val_2]] | |[[#cond_x_val_x|cond_2_val_2]] | ||
- | |MEDIUMINT(8) | + | |MEDIUMINT(8) |
+ | |unsigned | ||
|NO | |NO | ||
| | | | ||
Строка 152: | Строка 164: | ||
| | | | ||
|- | |- | ||
- | |[[# | + | |[[#cond_1-3|cond_3]] |
- | |TINYINT(3) | + | |TINYINT(3) |
+ | |unsigned | ||
|NO | |NO | ||
| | | | ||
Строка 160: | Строка 173: | ||
|- | |- | ||
|[[#cond_x_val_x|cond_3_val_1]] | |[[#cond_x_val_x|cond_3_val_1]] | ||
- | |MEDIUMINT(8) | + | |MEDIUMINT(8) |
+ | |unsigned | ||
|NO | |NO | ||
| | | | ||
Строка 167: | Строка 181: | ||
|- | |- | ||
|[[#cond_x_val_x|cond_3_val_2]] | |[[#cond_x_val_x|cond_3_val_2]] | ||
- | |MEDIUMINT(8) | + | |MEDIUMINT(8) |
+ | |unsigned | ||
|NO | |NO | ||
| | | | ||
Строка 202: | Строка 217: | ||
====box_text==== | ====box_text==== | ||
- | ==== | + | ====cond_1-3==== |
- | + | ||
====cond_x_val_x==== | ====cond_x_val_x==== | ||
Условия для срабатывания опций меню. См. [[Condition#condition|Condition.condition]] | Условия для срабатывания опций меню. См. [[Condition#condition|Condition.condition]] |
Версия 18:10, 17 августа 2010
|
К описанию таблиц базы данных mangos.
Таблица `gossip_menu_option`
Эта таблица используется для описания опций gossip меню.
Структура
Field | Type | Attributes | Null | Key | Default | Comments |
menu_id | SMALLINT(6) | unsigned | NO | PRI | 0 | |
id | SMALLINT(6) | unsigned | NO | PRI | 0 | |
option_icon | MEDIUMINT(8) | unsigned | NO | 0 | ||
option_text | TEXT | YES | ||||
option_id | TINYINT(3) | unsigned | NO | 0 | ||
npc_option_npcflag | INT(10) | unsigned | NO | 0 | ||
action_menu_id | MEDIUMINT(8) | unsigned | NO | 0 | ||
action_poi_id | MEDIUMINT(8) | unsigned | NO | 0 | ||
action_script_id | MEDIUMINT(8) | unsigned | NO | 0 | ||
box_coded | TINYINT(3) | unsigned | NO | 0 | ||
box_money | INT(11) | unsigned | NO | 0 | ||
box_text | TEXT | YES | ||||
cond_1 | TINYINT(3) | unsigned | NO | 0 | ||
cond_1_val_1 | MEDIUMINT(8) | unsigned | NO | 0 | ||
cond_1_val_2 | MEDIUMINT(8) | unsigned | NO | 0 | ||
cond_2 | TINYINT(3) | unsigned | NO | 0 | ||
cond_2_val_1 | MEDIUMINT(8) | unsigned | NO | 0 | ||
cond_2_val_2 | MEDIUMINT(8) | unsigned | NO | 0 | ||
cond_3 | TINYINT(3) | unsigned | NO | 0 | ||
cond_3_val_1 | MEDIUMINT(8) | unsigned | NO | 0 | ||
cond_3_val_2 | MEDIUMINT(8) | unsigned | NO | 0 |
Описание полей
menu_id
ID меню из gossip_menu.entry
id
option_icon
option_text
option_id
npc_option_npcflag
action_menu_id
Меню, которое будет вызвано при клике на данный пункт меню См. gossip_menu.entry
action_poi_id
action_script_id
Идентификатор Gossip-скрипта. См gossip_scripts.id Скрипт будет вызван при клике на данный пункт меню.
box_coded
box_money
box_text
cond_1-3
cond_x_val_x
Условия для срабатывания опций меню. См. Condition.condition