search

The-Cataclysm-Preservation-Project / TrinityCore

Archived repository for WoW 4.3.4.15595. The project will be reworked for Cataclysm Classic as an official new branch of TrinityCore at https://github.com/TrinityCore/TrinityCore
GNU General Public License v2.0
239 stars 97 forks source link

DB/NPC: Gossip Menu Option for Guild Master NPCs #356

Open evilvampire16 opened 2 years ago

evilvampire16 commented 2 years ago

Description:

Current behaviour:

Expected behaviour:

Steps to reproduce the problem:

  1. create a character
  2. reach to the Guild Master NPC
  3. click on it and see the options

TC rev. hash/commit:

TrinityCore rev. 6645a97434db+ 2022-05-01 19:07:26 +0200 (master branch) (Win64, RelWithDebInfo, Static) (worldserver-daemon)

TDB version: 434.22011

Operating system: Windows

evilvampire16 commented 2 years ago

Adding OptionType value 11 & OptionNpcflag value 524288 on gossip_menu_option table WHERE OptionText is I want to create a guild crest. Adding OptionType value 10 & OptionNpcflag value 262144 on gossip_menu_option table WHERE OptionText is How do I form a guild? Solves the issue.

UPDATE `gossip_menu_option` SET `MenuId`=0, `OptionIndex`=8, `OptionIcon`=7, `OptionText`='How do I form a guild?', `OptionBroadcastTextId`=3413, `OptionType`=10, `OptionNpcflag`=262144, `VerifiedBuild`=0 WHERE `MenuId`=0 AND `OptionIndex`=8;
UPDATE `gossip_menu_option` SET `MenuId`=708, `OptionIndex`=0, `OptionIcon`=7, `OptionText`='How do I form a guild?', `OptionBroadcastTextId`=3413, `OptionType`=10, `OptionNpcflag`=262144, `VerifiedBuild`=15354 WHERE `MenuId`=708 AND `OptionIndex`=0;
UPDATE `gossip_menu_option` SET `MenuId`=1626, `OptionIndex`=1, `OptionIcon`=7, `OptionText`='How do I form a guild?', `OptionBroadcastTextId`=3413, `OptionType`=10, `OptionNpcflag`=262144, `VerifiedBuild`=15595 WHERE `MenuId`=1626 AND `OptionIndex`=1;
UPDATE `gossip_menu_option` SET `MenuId`=5108, `OptionIndex`=0, `OptionIcon`=7, `OptionText`='How do I form a guild?', `OptionBroadcastTextId`=3413, `OptionType`=10, `OptionNpcflag`=262144, `VerifiedBuild`=15211 WHERE `MenuId`=5108 AND `OptionIndex`=0;
UPDATE `gossip_menu_option` SET `MenuId`=5461, `OptionIndex`=1, `OptionIcon`=7, `OptionText`='How do I form a guild?', `OptionBroadcastTextId`=3413, `OptionType`=10, `OptionNpcflag`=262144, `VerifiedBuild`=15595 WHERE `MenuId`=5461 AND `OptionIndex`=1;
UPDATE `gossip_menu_option` SET `MenuId`=5462, `OptionIndex`=1, `OptionIcon`=7, `OptionText`='How do I form a guild?', `OptionBroadcastTextId`=3413, `OptionType`=10, `OptionNpcflag`=262144, `VerifiedBuild`=15595 WHERE `MenuId`=5462 AND `OptionIndex`=1;
UPDATE `gossip_menu_option` SET `MenuId`=7440, `OptionIndex`=0, `OptionIcon`=7, `OptionText`='How do I form a guild?', `OptionBroadcastTextId`=3413, `OptionType`=10, `OptionNpcflag`=262144, `VerifiedBuild`=14545 WHERE `MenuId`=7440 AND `OptionIndex`=0;
UPDATE `gossip_menu_option` SET `MenuId`=7484, `OptionIndex`=0, `OptionIcon`=7, `OptionText`='How do I form a guild?', `OptionBroadcastTextId`=3413, `OptionType`=10, `OptionNpcflag`=262144, `VerifiedBuild`=15211 WHERE `MenuId`=7484 AND `OptionIndex`=0;
UPDATE `gossip_menu_option` SET `MenuId`=9838, `OptionIndex`=1, `OptionIcon`=7, `OptionText`='How do I form a guild?', `OptionBroadcastTextId`=3413, `OptionType`=10, `OptionNpcflag`=262144, `VerifiedBuild`=14545 WHERE `MenuId`=9838 AND `OptionIndex`=1;
UPDATE `gossip_menu_option` SET `MenuId`=0, `OptionIndex`=9, `OptionIcon`=8, `OptionText`='I want to create a guild crest', `OptionBroadcastTextId`=3415, `OptionType`=11, `OptionNpcflag`=524288, `VerifiedBuild`=0 WHERE `MenuId`=0 AND `OptionIndex`=9;
UPDATE `gossip_menu_option` SET `MenuId`=708, `OptionIndex`=1, `OptionIcon`=8, `OptionText`='I want to create a guild crest.', `OptionBroadcastTextId`=3415, `OptionType`=11, `OptionNpcflag`=524288, `VerifiedBuild`=15354 WHERE `MenuId`=708 AND `OptionIndex`=1;
UPDATE `gossip_menu_option` SET `MenuId`=1626, `OptionIndex`=0, `OptionIcon`=8, `OptionText`='I want to create a guild crest.', `OptionBroadcastTextId`=3415, `OptionType`=11, `OptionNpcflag`=524288, `VerifiedBuild`=15595 WHERE `MenuId`=1626 AND `OptionIndex`=0;
UPDATE `gossip_menu_option` SET `MenuId`=5108, `OptionIndex`=1, `OptionIcon`=8, `OptionText`='I want to create a guild crest.', `OptionBroadcastTextId`=3415, `OptionType`=11, `OptionNpcflag`=524288, `VerifiedBuild`=15211 WHERE `MenuId`=5108 AND `OptionIndex`=1;
UPDATE `gossip_menu_option` SET `MenuId`=5461, `OptionIndex`=0, `OptionIcon`=8, `OptionText`='I want to create a guild crest.', `OptionBroadcastTextId`=3415, `OptionType`=11, `OptionNpcflag`=524288, `VerifiedBuild`=15595 WHERE `MenuId`=5461 AND `OptionIndex`=0;
UPDATE `gossip_menu_option` SET `MenuId`=5462, `OptionIndex`=0, `OptionIcon`=8, `OptionText`='I want to create a guild crest.', `OptionBroadcastTextId`=3415, `OptionType`=11, `OptionNpcflag`=524288, `VerifiedBuild`=15595 WHERE `MenuId`=5462 AND `OptionIndex`=0;
UPDATE `gossip_menu_option` SET `MenuId`=7440, `OptionIndex`=1, `OptionIcon`=8, `OptionText`='I want to create a guild crest.', `OptionBroadcastTextId`=3415, `OptionType`=11, `OptionNpcflag`=524288, `VerifiedBuild`=14545 WHERE `MenuId`=7440 AND `OptionIndex`=1;
UPDATE `gossip_menu_option` SET `MenuId`=7484, `OptionIndex`=1, `OptionIcon`=8, `OptionText`='I want to create a guild crest.', `OptionBroadcastTextId`=3415, `OptionType`=11, `OptionNpcflag`=524288, `VerifiedBuild`=15211 WHERE `MenuId`=7484 AND `OptionIndex`=1;
UPDATE `gossip_menu_option` SET `MenuId`=9838, `OptionIndex`=0, `OptionIcon`=8, `OptionText`='I want to create a guild crest.', `OptionBroadcastTextId`=3415, `OptionType`=11, `OptionNpcflag`=524288, `VerifiedBuild`=14545 WHERE `MenuId`=9838 AND `OptionIndex`=0;
UPDATE `gossip_menu_option` SET `MenuId`=10392, `OptionIndex`=1, `OptionIcon`=8, `OptionText`='I want to create a guild crest.', `OptionBroadcastTextId`=3415, `OptionType`=11, `OptionNpcflag`=524288, `VerifiedBuild`=14545 WHERE `MenuId`=10392 AND `OptionIndex`=1;
Ovahlord commented 2 years ago

do not use string comparisons please. please update the gossips via menu id and index.