|
NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. |
Description of the 'gossip_menu_option' table for MaNGOSZero
This table holds infos about menu options a gossip NPC can have. Examples of options: "Train me!" or "I want to unlearn my talents".
Table Notes
This table uses the 'MyISAM' DB Engine
The Field definitions follow:
| Field Name | Field Type | Nullable | Key | Default Value | Attributes | Notes |
|---|---|---|---|---|---|---|
| menu_id | smallint(6) unsigned | NO | PRI | '0' | Gossip menu ID [See gossip_menu.entry]. | |
| id | smallint(6) unsigned | NO | PRI | '0' | Menu item ID. | |
| option_icon | mediumint(8) unsigned | NO | '0' | Icon type for the menu item. | ||
| option_text | text | YES | NULL | Menu item text displayed. | ||
| option_id | tinyint(3) unsigned | NO | '0' | Gossip option ID. | ||
| npc_option_npcflag | int(10) unsigned | NO | '0' | NPC flag required [See creature_template.NpcFlags]. | ||
| action_menu_id | mediumint(8) | NO | '0' | Gossip ID for the action [See gossip_menu.entry]. | ||
| action_poi_id | mediumint(8) unsigned | NO | '0' | POI ID [See points_of_interest.entry]. | ||
| action_script_id | mediumint(8) unsigned | NO | '0' | DB script ID [See dbscripts_on_gossip.id]. | ||
| box_coded | tinyint(3) unsigned | NO | '0' | Flag for text entering into the pop-up box. | ||
| box_money | int(11) unsigned | NO | '0' | Sum of money requested by pop-up box. | ||
| box_text | text | YES | NULL | Text for the pop-up box. | ||
| condition_id | mediumint(8) unsigned | NO | '0' | Condition ID [See conditions.condition_entry]. |
Description of the fields
menu_id smallint(6) unsigned
ID of the gossip (gossip_menu.entry), to which this menu item is tied.
id smallint(6) unsigned
ID of this menu item.
Some gossips may contain several variants of the player reply. The variants are numberred by this ID.
Menu items are numbered sequentially starting from 0.
option_icon mediumint(8) unsigned
Icon type displayed at the beginning of the menu option text.See enum GossipOptionIcon in GossipDef.h.
| Icon type | Value | Outlook |
|---|---|---|
| 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 crossed swords |
| GOSSIP_ICON_DOT | 10 | yellow dot |
option_text text
Text displayed for the menu item. Should be English only, find localizations in the locales_gossip_menu_option table.
option_id tinyint(3) unsigned
ID of the option of the gossip menu item, see enum Gossip_Option in GossipDef.h.
| Gossip option | Value | NPC flag required (value) |
|---|---|---|
| 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_UNLEARNPETSKILLS | 17 | UNIT_NPC_FLAG_TRAINER (16) (bonus option for GOSSIP_OPTION_TRAINER) |
Note:
In order for gossip_menu_option entries to work, the npcflag of the "creature_template" table table entry needs to be set appropriately.
npc_option_npcflag int(10) unsigned
NPC flag [See creature_template.NpcFlags] which the NPC should have set to allow this menu item be displayed. The values are from enum NPCFlags in Unit.h.
| NPC flag | Value (hex) | Value (dec) |
|---|---|---|
| UNIT_NPC_FLAG_GOSSIP | 0x00000001 | 1 |
| UNIT_NPC_FLAG_QUESTGIVER | 0x00000002 | 2 |
| UNIT_NPC_FLAG_VENDOR | 0x00000004 | 4 |
| UNIT_NPC_FLAG_FLIGHTMASTER | 0x00000008 | 8 |
| UNIT_NPC_FLAG_TRAINER | 0x00000010 | 16 |
| UNIT_NPC_FLAG_SPIRITHEALER | 0x00000020 | 32 |
| UNIT_NPC_FLAG_SPIRITGUIDE | 0x00000040 | 64 |
| UNIT_NPC_FLAG_INNKEEPER | 0x00000080 | 128 |
| UNIT_NPC_FLAG_BANKER | 0x00000100 | 256 |
| UNIT_NPC_FLAG_PETITIONER | 0x00000200 | 512 |
| UNIT_NPC_FLAG_TABARDDESIGNER | 0x00000400 | 1024 |
| UNIT_NPC_FLAG_BATTLEMASTER | 0x00000800 | 2048 |
| UNIT_NPC_FLAG_AUCTIONEER | 0x00001000 | 4096 |
| UNIT_NPC_FLAG_STABLEMASTER | 0x00002000 | 8192 |
| UNIT_NPC_FLAG_REPAIR | 0x00004000 | 16384 |
action_menu_id mediumint(8)
Gossip ID for the action [See gossip_menu.entry].
The scheme allows to create chains of gossips. Typical situation is a long story NPC tells to the player, requesting menu item as a confirmation after each brief part
Note:
If you want the gossip_menu_option to close the gossip window, set this field to -1.
action_poi_id mediumint(8) unsigned
ID of the POI [See points_of_interest.entry] which should be displayed as an action.
action_script_id mediumint(8) unsigned
ID of DB script [See db_scripts.id] with a type of 2 which should be executed as an action.
box_coded tinyint(3) unsigned
Setting this flag (to 1) allows to player enter any text into the pop-up box.
box_money int(11) unsigned
Money (in coppers) requested by pop-up box as an action.
box_text text
The text names the pop-up box requesting a special input from player.
condition_id mediumint(8) unsigned
ID of the conditions [See conditions.condition_entry] which must be fulfilled by the player in order to get this gossip menu option. If condition is not fulfilled, the option will be hidden (i.e. not present).
auto-generated by the getMaNGOS.eu MAGNET dbdocs module
Edited by Antz
Recommended Comments
There are no comments to display.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now