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
Gossip entry from Gossip_menu.entry this option is associated with.
The id associated with this gossip_menu_option. Must be unique for a given menu_id
GOSSIP_ICON_CHAT = 0, //white chat bubble
GOSSIP_ICON_VENDOR = 1, //brown bag |
This is is the text that you want displayed for this option. Examples would be "Train Me!" "Get off my lawn", "Learn Dual Spec".
GOSSIP_OPTION_NONE = 0, //UNIT_NPC_FLAG_NONE (0) |
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.
If you want to create a sub-menu, this is the ID to link to to create that sub-menu.
If you want a POI (point of interest) to display on the minimap, this is the `entry` from `points_of_interest`
The ID from the `gossip_scripts` table if this gossip option has a script.
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...
see above
see above
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.
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.)
field-no-description|15
field-no-description|16
field-no-description|17
field-no-description|18