Datenbank 'world'
access_requirement
achievement_criteria_data
achievement_dbc
achievement_reward
achievement_reward_locale
areatrigger_involvedrelation
areatrigger_scripts
areatrigger_tavern
areatrigger_teleport
battleground_template
battlemaster_entry
broadcast_text
broadcast_text_locale
command
conditions
creature
creature_addon
creature_classlevelstats
creature_equip_template
creature_formations
creature_loot_template
creature_model_info
creature_onkill_reputation
creature_questender
creature_questitem
creature_queststarter
creature_summon_groups
creature_template
creature_template_locale
creature_template_addon
creature_text
creature_text_locale
disables
disenchant_loot_template
event_scripts
exploration_basexp
fishing_loot_template
gameobject
gameobject_addon
gameobject_loot_template
gameobject_questender
gameobject_questitem
gameobject_queststarter
gameobject_template
gameobject_template_locale
game_event
game_event_arena_seasons
game_event_battleground_holiday
game_event_condition
game_event_creature
game_event_creature_quest
game_event_gameobject
game_event_gameobject_quest
game_event_model_equip
game_event_npcflag
game_event_npc_vendor
game_event_pool
game_event_prerequisite
game_event_quest_condition
game_event_seasonal_questrelation
game_tele
game_weather
gossip_menu
gossip_menu_option
graveyard_zone
instance_encounters
instance_template
item_enchantment_template
item_loot_template
item_set_names
item_template
lfg_dungeon_rewards
lfg_dungeon_template
linked_respawn
locales_gossip_menu_option
locales_item
locales_item_set_names
locales_npc_text
locales_page_text
locales_points_of_interest
locales_quest
mail_level_reward
mail_loot_template
milling_loot_template
npc_spellclick_spells
npc_text
npc_trainer
npc_vendor
outdoorpvp_template
page_text
pet_levelstats
pet_name_generation
pickpocketing_loot_template
playercreateinfo
playercreateinfo_action
playercreateinfo_item
playercreateinfo_skills
playercreateinfo_spell_custom
player_classlevelstats
player_factionchange_achievement
player_factionchange_items
player_factionchange_quests
player_factionchange_reputations
player_factionchange_spells
player_factionchange_titles
player_levelstats
player_xp_for_level
points_of_interest
pool_creature
pool_gameobject
pool_pool
pool_quest
pool_template
prospecting_loot_template
quest_poi
quest_offer_reward
quest_poi_points
quest_request_items
quest_template
quest_template_addon
reference_loot_template
reputation_reward_rate
reputation_spillover_template
script_waypoint
skill_discovery_template
skill_extra_item_template
skill_fishing_base_level
skill_perfect_item_template
skinning_loot_template
smart_scripts
spelldifficulty_dbc
spell_area
spell_bonus_data
spell_custom_attr
spell_dbc
spell_enchant_proc_data
spell_group
spell_group_stack_rules
spell_learn_spell
spell_linked_spell
spell_loot_template
spell_pet_auras
spell_proc
spell_proc_event
spell_ranks
spell_required
spell_scripts
spell_script_names
spell_target_position
spell_threat
transports
trinity_string
updates
updates_include
vehicle_accessory
vehicle_template_accessory
version
warden_checks
waypoints
waypoint_data
waypoint_scripts
Trinity DB, TrinityCore 2015-09-13, Tec's Ilaros WoW 3.3.5a, Datenbank 'world'

Tabelle: 'gossip_menu_option'

Table: gossip_menu_option

This table holds infos about menu options a gossipNPCcan have.
Examples of options : "Train me!", "I want to unlearn my talents",..

Structure

FieldTypeAttributesKeyNullDefaultExtraComment
menu_idsmallint(6)vorzeichenlosPRInein0
idsmallint(6)vorzeichenlosPRInein0
option_iconsmallint(6)vorzeichenlosPRInein

0

option_texttextvorzeichenbehaftetYESNULL
OptionBroadcastTextIDmediumint(6)NO
option_id

tinyint(3)

vorzeichenlosnein0
npc_option_npcflagint(10)vorzeichenlosnein0
action_menu_idmediumint(8)vorzeichenlosnein0

action_poi_idmediumint(8)vorzeichenlosnein0
box_codedtinyint(3)vorzeichenlosnein0
box_moneyint(11)

vorzeichenlos

nein0
box_texttextvorzeichenbehaftetYESNULL
BoxBroadcastTextIDmediumint(6)NO0

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

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.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.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?".


Votet bitte für uns und bringt uns so neue Spieler!
Stimme zählen für Account:
WoW Portal MPOG TOP WoW Servers NET Private Server
Gametoor Top 100 Arena Top G Top of Games Oxigen Top 100 List
Facebook YouTube
Impressum