Skip to content
Schmoozerd edited this page Apr 14, 2013 · 1 revision

Back to world database list of tables.

The `gossip_menu_option` table

This table holds infos about menu options a gossip NPC can have. Examples of options : "Train me!", "I want to unlearn my talents", …

Structure

Field Type Attributes Key Null Default
menu_id smallint(6) unsigned PRI NO 0
id smallint(6) unsigned PRI NO 0
option_icon smallint(6) unsigned PRI NO 0
option_text text signed YES NULL
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 signed YES NULL
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
condition_id mediumint(8) unsigned NO 0

Description of the fields

menu_id

Gossip entry from Gossip_menu.entry this option is associated with.

id

The id associated with this gossip_menu_option. Must be unique for a given menu_id

option_icon

Value ICON Name description
0 GOSSIP_ICON_CHAT white chat bubble
1 GOSSIP_ICON_VENDOR brown bag
2 GOSSIP_ICON_TAXI flight
3 GOSSIP_ICON_TRAINER book
4 GOSSIP_ICON_INTERACT_1 interaction wheel
5 GOSSIP_ICON_INTERACT_2 interaction wheel
6 GOSSIP_ICON_MONEY_BAG brown bag with yellow dot
7 GOSSIP_ICON_TALK white chat bubble with black dots
8 GOSSIP_ICON_TABARD tabard
9 GOSSIP_ICON_BATTLE two swords
10 GOSSIP_ICON_DOT yellow dot

option_text

This is is the text that you want displayed for this option. Examples would be "Train Me!" "Get off my lawn", "Learn Dual Spec".

option_id

option_id Option name npc_option_npcflag
0 GOSSIP_OPTION_NONE 0
1 GOSSIP_OPTION_GOSSIP 1
2 GOSSIP_OPTION_QUESTGIVER 2
3 GOSSIP_OPTION_VENDOR 128
4 GOSSIP_OPTION_TAXIVENDOR 8192
5 GOSSIP_OPTION_TRAINER 16
6 GOSSIP_OPTION_SPIRITHEALER 16384
7 GOSSIP_OPTION_SPIRITGUIDE 32768
8 GOSSIP_OPTION_INNKEEPER 65536
9 GOSSIP_OPTION_BANKER 131072
10 GOSSIP_OPTION_PETITIONER 262144
11 GOSSIP_OPTION_TABARDDESIGNER 524288
12 GOSSIP_OPTION_BATTLEFIELD 1048576
13 GOSSIP_OPTION_AUCTIONEER 2097152
14 GOSSIP_OPTION_STABLEPET 4194304
15 GOSSIP_OPTION_ARMORER 4096
16 GOSSIP_OPTION_UNLEARNTALENTS 16*
17 GOSSIP_OPTION_UNLEARNPETTALENTS 16*
18 GOSSIP_OPTION_LEARNDUALSPEC 16*

*   bonus option for GOSSIP_OPTION_TRAINER NOTE: For NPC you must be combinate option_id and npc_option_npcflag, you also need the npc_flag in creature_template

npc_option_npcflag

This is the npcflag that the NPC must have to have this option display. See option_id

action_menu_id

If you want to create a sub-menu, this is the ID to link to create that sub-menu.
This sub-menu will be displayed when you click on the current menu.

action_poi_id

If you want a POI (point of interest) to display on the minimap, this is the `entry` from `points_of_interest`

action_script_id

The ID from the `gossip_scripts` table if this gossip option has a script.

box_coded

If you want a box to display where you have to enter a code, this is the field you use. I have no clue how it works, will have to look at the code…

box_money

Money asked (in copper).

box_text

Confirmation text before activating the gossip.

condition_id

condition_id

Clone this wiki locally