Back to world database list of tables.
The `gossip_menu_option` table
table-no-description
Structure
Field |
Type |
Attributes |
Key |
Null |
Default |
Extra |
Comment |
smallint(6) |
unsigned |
PRI |
NO |
0 |
|
|
|
smallint(6) |
unsigned |
PRI |
NO |
0 |
|
|
|
smallint(6) |
unsigned |
PRI |
NO |
0 |
|
|
|
text |
signed |
|
YES |
NULL |
|
|
|
tinyint(3) |
unsigned |
|
NO |
0 |
|
|
|
int(10) |
unsigned |
|
NO |
0 |
|
|
|
mediumint(8) |
unsigned |
|
NO |
0 |
|
|
|
mediumint(8) |
unsigned |
|
NO |
0 |
|
|
|
mediumint(8) |
unsigned |
|
NO |
0 |
|
|
|
tinyint(3) |
unsigned |
|
NO |
0 |
|
|
|
int(11) |
unsigned |
|
NO |
0 |
|
|
|
text |
signed |
|
YES |
NULL |
|
|
|
tinyint(3) |
unsigned |
|
NO |
0 |
|
|
|
mediumint(8) |
unsigned |
|
NO |
0 |
|
|
|
mediumint(8) |
unsigned |
|
NO |
0 |
|
|
|
tinyint(3) |
unsigned |
|
NO |
0 |
|
|
|
mediumint(8) |
unsigned |
|
NO |
0 |
|
|
|
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
GOSSIP_ICON_CHAT = 0, //white chat bubble
GOSSIP_ICON_VENDOR = 1, //brown bag
GOSSIP_ICON_TAXI = 2, //flight
GOSSIP_ICON_TRAINER = 3, //book
GOSSIP_ICON_INTERACT_1 = 4, //interaction wheel
GOSSIP_ICON_INTERACT_2 = 5, //interaction wheel
GOSSIP_ICON_MONEY_BAG = 6, //brown bag with yellow dot
GOSSIP_ICON_TALK = 7, //white chat bubble with black dots
GOSSIP_ICON_TABARD = 8, //tabard
GOSSIP_ICON_BATTLE = 9, //two swords
GOSSIP_ICON_DOT = 10, //yellow dot
GOSSIP_ICON_MAX
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
GOSSIP_OPTION_NONE = 0, //UNIT_NPC_FLAG_NONE (0)
GOSSIP_OPTION_GOSSIP = 1, //UNIT_NPC_FLAG_GOSSIP (1)
GOSSIP_OPTION_QUESTGIVER = 2, //UNIT_NPC_FLAG_QUESTGIVER (2)
GOSSIP_OPTION_VENDOR = 3, //UNIT_NPC_FLAG_VENDOR (128)
GOSSIP_OPTION_TAXIVENDOR = 4, //UNIT_NPC_FLAG_TAXIVENDOR (8192)
GOSSIP_OPTION_TRAINER = 5, //UNIT_NPC_FLAG_TRAINER (16)
GOSSIP_OPTION_SPIRITHEALER = 6, //UNIT_NPC_FLAG_SPIRITHEALER (16384)
GOSSIP_OPTION_SPIRITGUIDE = 7, //UNIT_NPC_FLAG_SPIRITGUIDE (32768)
GOSSIP_OPTION_INNKEEPER = 8, //UNIT_NPC_FLAG_INNKEEPER (65536)
GOSSIP_OPTION_BANKER = 9, //UNIT_NPC_FLAG_BANKER (131072)
GOSSIP_OPTION_PETITIONER = 10, //UNIT_NPC_FLAG_PETITIONER (262144)
GOSSIP_OPTION_TABARDDESIGNER = 11, //UNIT_NPC_FLAG_TABARDDESIGNER (524288)
GOSSIP_OPTION_BATTLEFIELD = 12, //UNIT_NPC_FLAG_BATTLEFIELDPERSON (1048576)
GOSSIP_OPTION_AUCTIONEER = 13, //UNIT_NPC_FLAG_AUCTIONEER (2097152)
GOSSIP_OPTION_STABLEPET = 14, //UNIT_NPC_FLAG_STABLE (4194304)
GOSSIP_OPTION_ARMORER = 15, //UNIT_NPC_FLAG_ARMORER (4096)
GOSSIP_OPTION_UNLEARNTALENTS = 16, //UNIT_NPC_FLAG_TRAINER (16) (bonus option for GOSSIP_OPTION_TRAINER)
GOSSIP_OPTION_UNLEARNPETTALENTS = 17, //UNIT_NPC_FLAG_TRAINER (16) (bonus option for GOSSIP_OPTION_TRAINER)
GOSSIP_OPTION_LEARNDUALSPEC = 18, //UNIT_NPC_FLAG_TRAINER (16) (bonus option for GOSSIP_OPTION_TRAINER)
GOSSIP_OPTION_OUTDOORPVP = 19, //added by code (option for outdoor pvp creatures)
GOSSIP_OPTION_MAX
npc_option_npcflag
This is the npcflag that the NPC must have to have this option display. Someone (for the love of all that is holy) post a list here.
action_menu_id
If you want to create a sub-menu, this is the 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, 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
see above
box_text
see above
cond_1
If this menu option has conditions associated with it before it will be displayed (CONDITION_TEAM / CONDITION_QUEST / etc. – the same conditions used for the loot conditions, you would stick that condition ID here.
cond_1_value_1
The value here is based on the condition you picked above. Again, someone really needs to copy / paste (or better yet link the loot conditions here so they only have to be updated in one place.)
cond_1_value_2
field-no-description|15
cond_2
field-no-description|16
cond_2_value_1
field-no-description|17
cond_2_value_2
field-no-description|18