From 5830df185a13fd7e58234710f0b925a2c413177b Mon Sep 17 00:00:00 2001
From: MitchesD <majklprofik@seznam.cz>
Date: Fri, 17 Apr 2015 21:04:48 +0200
Subject: DB/Misc: corrected gossip data of Auctioneer in Stormwind

Closes https://github.com/TrinityCore/TrinityCore/issues/14557
---
 sql/updates/world/2015_04_17_00_world.sql | 8 ++++++++
 1 file changed, 8 insertions(+)
 create mode 100644 sql/updates/world/2015_04_17_00_world.sql

(limited to 'sql')

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;
-- 
cgit v1.2.3