Skip to end of metadata
Go to start of metadata


Table: gossip_menu_option

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

Extra

Comment

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

 

 

OptionBroadcastTextIDmediumint(6)  NO   

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

 

 

box_coded

tinyint(3)

unsigned

 

NO

0

 

 

box_money

int(11)

unsigned

 

NO

0

 

 

box_text

text

signed

 

YES

NULL

 

 

BoxBroadcastTextIDmediumint(6)  NO0  
VerifiedBuildsmallint(5)  NO0  

Description of the fields

menu_id

Gossip entry from Gossip_menu.entry this option is associated with.
If this is the default gossip option for the selected NPC, verify that the NPC has this value in its creature_template.gossip_menu_id .

id

The id associated with this gossip_menu_option. Must be unique for a given menu_id starting from 0 (zero).
Value increments by 1 if there are multiple options in the same gossip_menu.

option_icon

NameIDDescription
GOSSIP_ICON_CHAT0White chat bubble
GOSSIP_ICON_VENDOR1Brown bag
GOSSIP_ICON_TAXI2Flight
GOSSIP_ICON_TRAINER3Book
GOSSIP_ICON_INTERACT_14Interaction wheel
GOSSIP_ICON_INTERACT_25Interaction wheel
GOSSIP_ICON_MONEY_BAG6Brown bag with yellow dot (gold)
GOSSIP_ICON_TALK7White chat bubble with black dots (...)
GOSSIP_ICON_TABARD8Tabard
GOSSIP_ICON_BATTLE9Two swords
GOSSIP_ICON_DOT10Yellow dot

option_text

This is is the text that you want displayed in the player selectable option. Examples would be "Please train me.", "I would like to browse your goods.", "Learn Dual Spec".
If OptionBroadCastTextID contains a valid broadcast_text.ID, it links to broadcast_text so the content from broadcast_text is displayed directly instead of the option_text field content.

OptionBroadcastTextID

The ID of the same text in broadcast_text.ID.

option_id

option_id NameValuenpcflag Name (& comment)npcflag value
GOSSIP_OPTION_NONE0UNIT_NPC_FLAG_NONE0
GOSSIP_OPTION_GOSSIP1UNIT_NPC_FLAG_GOSSIP1
GOSSIP_OPTION_QUESTGIVER2UNIT_NPC_FLAG_QUESTGIVER2
GOSSIP_OPTION_VENDOR3

UNIT_NPC_FLAG_VENDOR (Make sure there is npc_vendor data for this creature)

128
GOSSIP_OPTION_TAXIVENDOR4UNIT_NPC_FLAG_TAXIVENDOR8192
GOSSIP_OPTION_TRAINER5

UNIT_NPC_FLAG_TRAINER (Remember to set trainer_class in creature_template) 

16
GOSSIP_OPTION_SPIRITHEALER6UNIT_NPC_FLAG_SPIRITHEALER16384
GOSSIP_OPTION_SPIRITGUIDE7UNIT_NPC_FLAG_SPIRITGUIDE32768
GOSSIP_OPTION_INNKEEPER8UNIT_NPC_FLAG_INNKEEPER65536
GOSSIP_OPTION_BANKER9UNIT_NPC_FLAG_BANKER131072
GOSSIP_OPTION_PETITIONER10UNIT_NPC_FLAG_PETITIONER262144
GOSSIP_OPTION_TABARDDESIGNER11UNIT_NPC_FLAG_TABARDDESIGNER524288
GOSSIP_OPTION_BATTLEFIELD12UNIT_NPC_FLAG_BATTLEFIELDPERSON1048576
GOSSIP_OPTION_AUCTIONEER13UNIT_NPC_FLAG_AUCTIONEER2097152
GOSSIP_OPTION_STABLEPET14UNIT_NPC_FLAG_STABLE4194304
GOSSIP_OPTION_ARMORER15UNIT_NPC_FLAG_ARMORER (not used)4096
GOSSIP_OPTION_UNLEARNTALENTS16UNIT_NPC_FLAG_TRAINER (bonus option for GOSSIP_OPTION_TRAINER)16
GOSSIP_OPTION_UNLEARNPETTALENTS17UNIT_NPC_FLAG_TRAINER (bonus option for GOSSIP_OPTION_TRAINER)16
GOSSIP_OPTION_LEARNDUALSPEC18UNIT_NPC_FLAG_TRAINER (bonus option for GOSSIP_OPTION_TRAINER)16
GOSSIP_OPTION_OUTDOORPVP19Added by code (option for outdoor PvP creatures) 
GOSSIP_OPTION_MAX   

npc_option_npcflag

This is the npcflag (Creature_template.npcflag ) that the NPC must have to have this option display. See comments (after //) in previous table)

action_menu_id

If you want to create a sub-menu, this is the ID (gossip_menu.entry / gossip_menu_option.menu_id) to link to to create that sub-menu.

action_poi_id

If you want a POI (point of interest) to display on the minimap (like how a city guard places a marker when you ask directions), this is the `entry` from Points_of_interest.entry

box_coded

If you want a box to display where you have to enter a code, this is the field you use.

box_money

The amount of money the player has to pay for the selected option, appears in the confirmation box as amount of gold, silver, copper.
The DB value you insert here must be given in the number of copper, so 10 gold is entered as 100000 (10g 00s 00c).

box_text

This is the text of the window that appears that has "Yes" or "No" as clickable buttons. This is useful if you want a Yes/No confirmation window before the script executes. For example: "Are you sure you want to teleport to Dalaran?".
If BoxBroadCastTextID contains a valid broadcast_text.ID, it links to broadcast_text so the content from broadcast_text is displayed directly instead of the box_text field content.

BoxBroadcastTextID

The ID of the same text in broadcast_text.ID.

VerifiedBuild

This field is used by the TrinityDB Team to determine whether a template has been verified from WDB files.

If value is 0 then it has not been parsed yet.

If value is above 0 then it has been parsed with WDB files from that specific client build.

If value is -1 then it is just a place holder until proper data are found on WDBs.

If value is -Client Build then it was parsed with WDB files from that specific client build and manually edited later for some special necessity.