DB/Misc: corrected gossip data of Auctioneer in Stormwind

Closes https://github.com/TrinityCore/TrinityCore/issues/14557

1 files changed, 8 insertions, 0 deletions

diff --git a/sql/updates/world/2015_04_17_00_world.sql b/sql/updates/world/2015_04_17_00_world.sql
new file mode 100644
index 00000000000..8429938aa21
--- /dev/null
+++ b/sql/updates/world/2015_04_17_00_world.sql
@@ -0,0 +1,8 @@
+DELETE FROM `gossip_menu` WHERE `entry`=12941;
+INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES
+(12941,18205);
+
+DELETE FROM `gossip_menu_option` WHERE `menu_id`=12941 AND `id`=1;
+UPDATE `gossip_menu_option` SET `option_id`=13, `npc_option_npcflag`=2097152 WHERE `menu_id`=12941 AND `id`=0;
+UPDATE `npc_text` SET `BroadcastTextID0`=52634 WHERE `ID`=18205;
+UPDATE `creature_template` SET `npcflag` = `npcflag`|0x200000 WHERE `entry`=8719;