Gossip menu option

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

(Различия между версиями)

Версия 14:56, 14 марта 2010

Вернуться к списку таблиц world database.

Таблица `gossip_menu_option`

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

Structure

Field	Type	Null	Key	Default	Extra
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
data2	int(10) 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

action_poi_id

action_script_id

box_coded

box_money

box_text

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), меню появится только тогда, когда все 3 условия у игрока будут выполнены одновременно.

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_ZONEID	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

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_ZONEID
- condition_value1: Zone ID
- condition_value2: Always 0

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

@@ Строка 255: / Строка 255: @@
 | 16 || CONDITION_NOITEM ||
 |}
+===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_ZONEID
+** condition_value1: Zone ID
+** condition_value2: Always 0
+* 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