[Shadowlands]: Katy Stampwhistle

[Florix]

Title: Katy Stampwhistle
Bugtracker Link:

https://firestorm-servers.com/en/report/see_report/107950

Patch Content:

The item https://www.wowhead.com/item=156833/katys-stampwhistle can be obtained on the Legion realm, but the NPC itself does not work.

I do not have access to any sniffs to get the Blizzlike gossip ID or the correct Broadcast ID, so i added a custom ID and leave the broadcast ID empty.

Patch Content:
https://www.wowhead.com/item=156833/katys-stampwhistle
https://www.wowhead.com/npc=132969/katy-stampwhistle

Fix:
 

-- #132969/NPC - Katy Stampwhistle - Fix Toy #156833
UPDATE `creature_template` SET `gossip_menu_id`='132969' WHERE `entry`='132969';
DELETE FROM `gossip_menu` WHERE `MenuId`='132969';
INSERT INTO `gossip_menu` (`MenuId`,`TextId`,`VerifiedBuild`) VALUES 
('132969','132969','25632');
DELETE FROM `gossip_menu_option` WHERE `MenuId`='132969';
INSERT INTO `gossip_menu_option` (`MenuId`,`OptionIndex`,`OptionIcon`,`OptionText`,`OptionBroadcastTextId`,`OptionType`,`OptionNpcFlag`,`VerifiedBuild`) VALUES 
('132969','1','11','I\'d like to check my mail.','0','1','67108864','25632');
DELETE FROM `npc_text` WHERE `ID`='132969';
INSERT INTO `npc_text` (`ID`,`text0_1`,`BroadcastTextID0`,`Probability0`,`VerifiedBuild`) VALUES 
('132969','Salutions! How can i help you?','0','1','25632');