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
Ya know that cool icon that gets displayed next to menu items .. this is what decides what icon goes there.
You can find a cool list of the available icons in the core. Someone should be cool and post them here...
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
If this is a default option (QUEST_GIVER / TRAINER / etc..) this is the option_id from the core. Again, it would be cool if someone posted a list here – NOT IT! 
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
field-no-description|13
cond_1_value_1
field-no-description|14
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