Gossip menu

Материал из YTDB DataBase

(Различия между версиями)
Перейти к: навигация, поиск
(→condition_value)
(→entry)
 
(32 промежуточные версии не показаны)
Строка 2: Строка 2:
| __TOC__
| __TOC__
|}
|}
-
Вернуться к списку таблиц [[mangosdb_struct|world database]].
+
[[Category: Mangos world database tables]]
 +
К описанию таблиц [[mangosdb_struct|базы данных mangos]].
<big>'''Таблица `gossip_menu`'''</big>
<big>'''Таблица `gossip_menu`'''</big>
-
Эта таблица используется для описания опций gossip меню.
+
Эта таблица используется для описания gossip меню.
-
<big>'''Structure'''</big>
+
 
 +
 
 +
<big>'''Структура'''</big>
{| border="1"
{| border="1"
|'''Field'''
|'''Field'''
|'''Type'''
|'''Type'''
 +
|'''Attributes'''
|'''Null'''
|'''Null'''
|'''Key'''
|'''Key'''
|'''Default'''
|'''Default'''
-
|'''Extra'''
+
|'''Comments'''
|-
|-
|[[#entry|entry]]
|[[#entry|entry]]
-
|SMALLINT(6) UNSIGNED
+
|smallint(6)
 +
|unsigned
|NO
|NO
|PRI
|PRI
Строка 26: Строка 31:
|-
|-
|[[#text_id|text_id]]
|[[#text_id|text_id]]
-
|MEDIUMINT(8) UNSIGNED
+
|mediumint(8)
 +
|unsigned
|NO
|NO
-
|
+
|PRI
|0
|0
|
|
|-
|-
-
|[[#cond_1|cond_1]]
+
|[[#script_id|script_id]]
-
|TINYINT(3) UNSIGNED
+
|mediumint(8)
 +
|unsigned
|NO
|NO
-
|
+
|PRI
|0
|0
-
|
+
|script in `dbscripts_on_gossip` - will be executed on GossipHello
|-
|-
-
|[[#cond_1_val_1|cond_1_val_1]]
+
|[[#condition_id|condition_id]]
-
|MEDIUMINT(8) UNSIGNED
+
|mediumint(8)
-
|NO
+
|unsigned
-
|
+
-
|0
+
-
|
+
-
|-
+
-
|[[#cond_1_val_2|cond_1_val_2]]
+
-
|MEDIUMINT(8) UNSIGNED
+
-
|NO
+
-
|
+
-
|0
+
-
|
+
-
|-
+
-
|[[#cond_2|cond_2]]
+
-
|TINYINT(3) UNSIGNED
+
-
|NO
+
-
|
+
-
|0
+
-
|
+
-
|-
+
-
|[[#cond_2_val_1|cond_2_val_1]]
+
-
|MEDIUMINT(8) UNSIGNED
+
-
|NO
+
-
|
+
-
|0
+
-
|
+
-
|-
+
-
|[[#cond_2_val_2|cond_2_val_2]]
+
-
|MEDIUMINT(8) UNSIGNED
+
-
|NO
+
-
|
+
-
|0
+
-
|
+
-
|-
+
-
|[[#cond_3|cond_3]]
+
-
|TINYINT(3) UNSIGNED
+
-
|NO
+
-
|
+
-
|0
+
-
|
+
-
|-
+
-
|[[#cond_3_val_1|cond_3_val_1]]
+
-
|MEDIUMINT(8) UNSIGNED
+
-
|NO
+
-
|
+
-
|0
+
-
|
+
-
|-
+
-
|[[#cond_3_val_2|cond_3_val_2]]
+
-
|MEDIUMINT(8) UNSIGNED
+
|NO
|NO
|
|
Строка 97: Строка 56:
-
<big>'''Значения полей'''</big>
+
<big>'''Описание полей'''</big>
====entry====  
====entry====  
-
ID меню.
+
Идентификатор меню:<br>
 +
См. [[creature_template#gossip_menu_id|creature_template.gossip_menu_id]].<br>
 +
См. [[gameobject_template#data0-23|gameobject_template.data0-23]].
 +
 
====text_id====
====text_id====
-
ID текста меню. См. [[Npc_text#ID|npc_text.ID]]
+
Идентификатор текста меню. См. [[Npc_text#ID|npc_text.ID]].
-
====cond_1====
+
-
 
+
-
====cond_1_val_1====
+
-
 
+
-
====cond_1_val_2====
+
-
 
+
-
====cond_2====
+
-
 
+
-
====cond_2_val_1====
+
-
 
+
-
====cond_2_val_2====
+
-
 
+
-
====cond_3====
+
-
 
+
-
====cond_3_val_1====
+
-
 
+
-
====cond_3_val_2====
+
-
===condition===
+
-
Условие(cond_x), которое должно быть выполнено, чтобы появился текст меню. Если заполнены все 3 варианта(cond_1-3), текст меню появится только тогда, когда они все у игрока будут выполнены. Если условий нет - текст будет виден всегда(аналог таблица Npc_gossip).
+
-
{| border=1 cellpadding=3 cellspacing=0
+
-
! Value !! Condition !! Comments
+
-
|-
+
-
| 0 || CONDITION_NONE || Regular drop
+
-
|-
+
-
| 1 || CONDITION_AURA || Player looting must have an aura active
+
-
|-
+
-
| 2 || CONDITION_ITEM || Player must have a number of items in his/her inventory
+
-
|-
+
-
| 3 || CONDITION_ITEM_EQUIPPED || Player must have an item equipped
+
-
|-
+
-
| 4 || CONDITION_AREAID || Player must be in a certain zone
+
-
|-
+
-
| 5 || CONDITION_REPUTATION_RANK || Player must have a certain reputation rank with a certain faction
+
-
|-
+
-
| 6 || CONDITION_TEAM || Player must be part of the specified team (Alliance or Horde)
+
-
|-
+
-
| 7 || CONDITION_SKILL || Player must have a certain skill value
+
-
|-
+
-
| 8 || CONDITION_QUESTREWARDED || Player must have completed a quest first
+
-
|-
+
-
| 9 || CONDITION_QUESTTAKEN || Players must have the quest in the quest log and not completed yet
+
-
|-
+
-
| 10 || CONDITION_AD_COMMISSION_AURA ||
+
-
|-
+
-
| 11 || CONDITION_NO_AURA ||  Player looting must have no aura active mentioned in condition_value1
+
-
|-
+
-
| 12 || CONDITION_ACTIVE_EVENT || The loot with that condition can be looted only while the Event (condition_value1) is active
+
-
|-
+
-
| 13 || CONDITION_AREA_FLAG ||
+
-
|-
+
-
| 14 || CONDITION_RACE_CLASS ||
+
-
|-
+
-
| 15 || CONDITION_LEVEL ||
+
-
|-
+
-
| 16 || CONDITION_NOITEM ||
+
-
|-
+
-
| 17 || CONDITION_SPELL ||
+
-
|-
+
-
| 18 || CONDITION_INSTANCE_SCRIPT || Instance script specific enum
+
-
|-
+
-
| 19 || CONDITION_QUESTAVAILABLE || For case when loot/gossip possible only if player can start quest
+
-
|}
+
-
 
+
-
===condition_value===
+
-
The values in the cond_x_val_1 and cond_x_val_2 fields depend on what condition was put in.
+
-
* CONDITION_AURA
+
-
** condition_value1: The spell ID from where the aura came from.
+
-
** condition_value2: The effect index of the spell that applied the aura (0, 1, or 2)
+
-
 
+
-
* CONDITION_ITEM
+
-
** condition_value1: Item ID
+
-
** condition_value2: Count
+
-
 
+
-
* CONDITION_ITEM_EQUIPPED
+
-
** condition_value1: Item ID
+
-
** condition_value2: Always 0
+
-
 
+
-
* CONDITION_AREAID
+
-
** condition_value1: AREA ID
+
-
** condition_value2: 0, 1 (0: in (sub)area, 1: not in (sub)area)
+
-
 
+
-
* CONDITION_REPUTATION_RANK
+
-
** condition_value1: Faction ID
+
-
** condition_value2: Minimum rank
+
-
 
+
-
* CONDITION_TEAM
+
-
** condition_value1: Player team (469 - Alliance, 67 - Horde)
+
-
** condition_value2: Always 0
+
-
 
+
-
* CONDITION_SKILL
+
-
** condition_value1: Skill ID (SkillLine.dbc)
+
-
** condition_value2: Skill value needed
+
-
 
+
-
* CONDITION_QUESTREWARDED
+
-
** condition_value1: Quest ID
+
-
** condition_value2: Always 0
+
-
 
+
-
* CONDITION_QUESTTAKEN
+
-
** condition_value1: Quest ID
+
-
** condition_value2: Always 0
+
-
 
+
-
* CONDITION_NO_AURA
+
-
** condition_value1: The spell ID of the aura which have to be not active.
+
-
** condition_value2: The effect index of the spell that applied the aura (0, 1, or 2)
+
-
 
+
-
* CONDITION_ACTIVE_EVENT
+
-
** condition_value1: Event ID
+
-
 
+
-
* CONDITION_AREA_FLAG
+
-
** condition_value1: Area flag
+
-
** condition_value2: Area flag not
+
-
 
+
-
* CONDITION_RACE_CLASS
+
-
** condition_value1: Race mask
+
-
** condition_value2: Class mask
+
-
 
+
-
* CONDITION_LEVEL
+
-
** condition_value1: Player level
+
-
** condition_value2: 0, 1 or 2 (0: equal to, 1: equal or higher than, 2: equal or less than)
+
-
 
+
-
* CONDITION_NOITEM
+
-
** condition_value1: Item ID
+
-
** condition_value2: Count
+
-
 
+
-
* CONDITION_SPELL
+
-
** condition_value1: Spell ID
+
-
** condition_value2: 0, 1 (0: has spell, 1: hasn't spell)
+
-
* CONDITION_INSTANCE_SCRIPT
+
====script_id====
-
** condition_value1: Map ID
+
Идентификатор выполняемого скрипта. См. [[dbscripts_on_gossip#id|dbscripts_on_gossip.id]].
-
** condition_value2: Always 0
+
-
* CONDITION_QUESTAVAILABLE
+
====condition_id====
-
** condition_value1: Quest ID
+
Идентификатор условия, при котором сработает(будет виден) данный пункт. См. [[conditions#condition_entry|condition_entry]].
-
** condition_value2: Always 0
+

Текущая версия на 17:48, 21 июня 2017

Содержание

К описанию таблиц базы данных mangos.


Таблица `gossip_menu`

Эта таблица используется для описания gossip меню.


Структура

Field Type Attributes Null Key Default Comments
entry smallint(6) unsigned NO PRI 0
text_id mediumint(8) unsigned NO PRI 0
script_id mediumint(8) unsigned NO PRI 0 script in `dbscripts_on_gossip` - will be executed on GossipHello
condition_id mediumint(8) unsigned NO 0


Описание полей

entry

Идентификатор меню:
См. creature_template.gossip_menu_id.
См. gameobject_template.data0-23.

text_id

Идентификатор текста меню. См. npc_text.ID.

script_id

Идентификатор выполняемого скрипта. См. dbscripts_on_gossip.id.

condition_id

Идентификатор условия, при котором сработает(будет виден) данный пункт. См. condition_entry.

Источник — «http://wiki.ytdb.ru:89/index.php/Gossip_menu»
Личные инструменты