Gossip_menu_option
Back to world database list of tables.
This table holds infos about menu options a gossip NPC can have. Examples of options : "Train me!", "I want to unlearn my talents", …
| Field | Type | Attributes | Key | Null | Default |
| 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 | |
| option_broadcast_text | int(11) | unsigned | NO | 0 | |
| 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 | |
| action_script_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 | |
| box_broadcast_text | int(11) | unsigned | NO | 0 | |
| condition_id | mediumint(8) | unsigned | NO | 0 |
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
| Value | ICON Name | description |
|---|---|---|
| 0 | GOSSIP_ICON_CHAT | white chat bubble |
| 1 | GOSSIP_ICON_VENDOR | brown bag |
| 2 | GOSSIP_ICON_TAXI | flight |
| 3 | GOSSIP_ICON_TRAINER | book |
| 4 | GOSSIP_ICON_INTERACT_1 | interaction wheel |
| 5 | GOSSIP_ICON_INTERACT_2 | interaction wheel |
| 6 | GOSSIP_ICON_MONEY_BAG | brown bag with yellow dot |
| 7 | GOSSIP_ICON_TALK | white chat bubble with black dots |
| 8 | GOSSIP_ICON_TABARD | tabard |
| 9 | GOSSIP_ICON_BATTLE | two swords |
| 10 | GOSSIP_ICON_DOT | yellow dot |
This is the text that you want displayed for this option. Examples would be "Train Me!" "Get off my lawn", "Learn Dual Spec".
This is the broadcast_text id for the text you want to be displayed in this option. Leave as 0 to give precedence to option_text
| option_id | Option name | npc_option_npcflag |
|---|---|---|
| 0 | GOSSIP_OPTION_NONE | 0 |
| 1 | GOSSIP_OPTION_GOSSIP | 1 |
| 2 | GOSSIP_OPTION_QUESTGIVER | 2 |
| 3 | GOSSIP_OPTION_VENDOR | 128 |
| 4 | GOSSIP_OPTION_TAXIVENDOR | 8192 |
| 5 | GOSSIP_OPTION_TRAINER | 16 |
| 6 | GOSSIP_OPTION_SPIRITHEALER | 16384 |
| 7 | GOSSIP_OPTION_SPIRITGUIDE | 32768 |
| 8 | GOSSIP_OPTION_INNKEEPER | 65536 |
| 9 | GOSSIP_OPTION_BANKER | 131072 |
| 10 | GOSSIP_OPTION_PETITIONER | 262144 |
| 11 | GOSSIP_OPTION_TABARDDESIGNER | 524288 |
| 12 | GOSSIP_OPTION_BATTLEFIELD | 1048576 |
| 13 | GOSSIP_OPTION_AUCTIONEER | 2097152 |
| 14 | GOSSIP_OPTION_STABLEPET | 4194304 |
| 15 | GOSSIP_OPTION_ARMORER | 4096 |
| 16 | GOSSIP_OPTION_UNLEARNTALENTS | 16* |
| 17 | GOSSIP_OPTION_UNLEARNPETTALENTS | 16* |
| 18 | GOSSIP_OPTION_LEARNDUALSPEC | 16* |
* bonus option for GOSSIP_OPTION_TRAINER NOTE: For NPC you must be combinate option_id and npc_option_npcflag, you also need the npc_flag in creature_template
This is the npcflag that the NPC must have to have this option display. See option_id
| Type | classic | tbc | wotlk |
|---|---|---|---|
| UNIT_NPC_FLAG_GOSSIP | 1 | 1 | 1 |
| UNIT_NPC_FLAG_QUESTGIVER | 2 | 2 | 2 |
| UNIT_NPC_FLAG_VENDOR | 4 | 128 | 128 |
| UNIT_NPC_FLAG_FLIGHTMASTER | 8 | 8192 | 8192 |
| UNIT_NPC_FLAG_TRAINER | 16 | 16 | 16 |
| UNIT_NPC_FLAG_SPIRITHEALER | 32 | 16384 | 16384 |
| UNIT_NPC_FLAG_SPIRITGUIDE | 64 | 32768 | 32768 |
| UNIT_NPC_FLAG_INNKEEPER | 128 | 65536 | 65536 |
| UNIT_NPC_FLAG_BANKER | 256 | 131072 | 131072 |
| UNIT_NPC_FLAG_PETITIONER | 512 | 262144 | 262144 |
| UNIT_NPC_FLAG_TABARDDESIGNER | 1024 | 524288 | 524288 |
| UNIT_NPC_FLAG_BATTLEMASTER | 2048 | 1048576 | 1048576 |
| UNIT_NPC_FLAG_AUCTIONEER | 4096 | 2097152 | 2097152 |
| UNIT_NPC_FLAG_STABLEMASTER | 8192 | 4194304 | 4194304 |
| UNIT_NPC_FLAG_REPAIR | 16384 | 4096 | 4096 |
If you want to create a sub-menu, this is the ID to link to create that sub-menu.
This sub-menu will be displayed when you click on the current menu.
NOTE: If you want gossip window to close when selecting this gossip option use -1 for this value.
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 `dbscripts_on_gossip` 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…
Money asked (in copper).
Confirmation text before activating the gossip.
Broadcast Text ID for the confirmation text before activating the gossip. Leave as 0 to give precedence to box_text
If set the option will only be displayed if the condition linked to condition_id fits