Cheapgamer: Created page with "{| align="right" | TOC |} Category: SkyFire World database tables {{Back-to:World}} '''The `gossip_menu_option` table''' {{table-no-description}} ..."

2012-07-06T18:52:50Z

Created page with "{| align="right" | __TOC__ |} Category: SkyFire World database tables {{Back-to:World}} <big>'''The `gossip_menu_option` table'''</big> {{table-no-description}} <big>..."

New page

{| align="right"
| __TOC__
|}
[[Category: SkyFire World database tables]]
{{Back-to:World}}

<big>'''The `gossip_menu_option` table'''</big>

{{table-no-description}}

<big>'''Structure'''</big>
{| border="1"
|'''Field'''
|'''Type'''
|'''Attributes'''
|'''Key'''
|'''Null'''
|'''Default'''
|'''Extra'''
|'''Comment'''
|-
|[[#menu_id|menu_id]]
|smallint(6)
|unsigned
|PRI
|NO
|0
|
|
|-
|[[#id|id]]
|smallint(6)
|unsigned
|PRI
|NO
|0
|
|
|-
|[[#option_icon|option_icon]]
|smallint(6)
|unsigned
|PRI
|NO
|0
|
|
|-
|[[#option_text|option_text]]
|text
|signed
|
|YES
|NULL
|
|
|-
|[[#option_id|option_id]]
|tinyint(3)
|unsigned
|
|NO
|0
|
|
|-
|[[#npc_option_npcflag|npc_option_npcflag]]
|int(10)
|unsigned
|
|NO
|0
|
|
|-
|[[#action_menu_id|action_menu_id]]
|mediumint(8)
|unsigned
|
|NO
|0
|
|
|-
|[[#action_poi_id|action_poi_id]]
|mediumint(8)
|unsigned
|
|NO
|0
|
|
|-
|[[#box_coded|box_coded]]
|tinyint(3)
|unsigned
|
|NO
|0
|
|
|-
|[[#box_money|box_money]]
|int(11)
|unsigned
|
|NO
|0
|
|
|-
|[[#box_text|box_text]]
|text
|signed
|
|YES
|NULL
|
|
|}

<big>'''Description of the fields'''</big>

====menu_id====
Gossip entry from [[Gossip_menu_SF#entry|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

====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) (Make sure there is npc_vendor data for this creature)
GOSSIP_OPTION_TAXIVENDOR = 4, //UNIT_NPC_FLAG_TAXIVENDOR (8192)
GOSSIP_OPTION_TRAINER = 5, //UNIT_NPC_FLAG_TRAINER (16) (Remember to set trainer_class in creature_template)
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) (not used)
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([[Creature_template_SF#npcflag]]) that the NPC must have to have this option display. See comments (after //) in previous table)

====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 (like how a city guard places a marker when you ask directions), this is the `entry` from [[Points_of_interest_SSF#entry]].

====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====
This is the text of the window that appears that has "Yes" or "No" as clickable buttons. This is useful if you want a Yes/No confirmation window before the script executes. For example: "Are you sure you want to teleport to Dalaran?".

Gossip menu option SF - Revision history

Cheapgamer: Created page with "{| align="right" | __TOC__ |} Category: SkyFire World database tables {{Back-to:World}} '''The `gossip_menu_option` table''' {{table-no-description}} ..."

Cheapgamer: Created page with "{| align="right" | TOC |} Category: SkyFire World database tables {{Back-to:World}} '''The `gossip_menu_option` table''' {{table-no-description}} ..."