gossip_menu_option

Table: gossip_menu_option

This table holds information 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

MenuId

int(10)

unsigned

PRI

NO

0



OptionIndex

int(10)

unsigned

PRI

NO

0



OptionIcon

tinyint(3)

unsigned


NO

0



OptionText

text



YES

NULL



OptionBroadcastTextIdint(11)unsigned
NO 0

OptionType

int(11)

unsigned


NO

0



OptionNpcFlag

bigint(20)

unsigned


NO

0



VerifiedBuildsmallint(5) signed
NO0

Description of the fields

MenuId

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 it's creature_template.gossip_menu_id .

OptionIndex

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.

OptionIcon

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
GOSSIP_ICON_CHAT_1111White chat bubble
GOSSIP_ICON_CHAT_1212White chat bubble
GOSSIP_ICON_CHAT_1313White chat bubble
GOSSIP_ICON_UNK_1414INVALID - DO NOT USE
GOSSIP_ICON_UNK_1515INVALID - DO NOT USE
GOSSIP_ICON_CHAT_1616White chat bubble
GOSSIP_ICON_CHAT_1717White chat bubble
GOSSIP_ICON_CHAT_1818White chat bubble
GOSSIP_ICON_CHAT_1919White chat bubble
GOSSIP_ICON_CHAT_2020White chat bubble
GOSSIP_ICON_CHAT_2121Transmogrifier?

OptionText

This is the text that you want to be 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.

OptionType

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_UNLEARNTALENTS (deprecated)16UNIT_NPC_FLAG_TRAINER (bonus option for GOSSIP_OPTION_TRAINER)16
GOSSIP_OPTION_UNLEARNPETTALENTS (deprecated)17UNIT_NPC_FLAG_TRAINER (bonus option for GOSSIP_OPTION_TRAINER)16
GOSSIP_OPTION_LEARNDUALSPEC (deprecated)18UNIT_NPC_FLAG_TRAINER (bonus option for GOSSIP_OPTION_TRAINER)16
GOSSIP_OPTION_OUTDOORPVP19Added by code (option for outdoor PvP creatures)
GOSSIP_OPTION_TRANSMOGRIFIER20UNIT_NPC_FLAG_TRANSMOGRIFIER
GOSSIP_OPTION_MAX


OptionNpcFlag

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

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.