From 967a5868976bf2b03dbebfb67beb0022e792062c Mon Sep 17 00:00:00 2001
From: Killyana <morphone1@gmail.com>
Date: Sun, 22 Dec 2019 16:53:13 +0100
Subject: DB/Misc: Fix some cosmetics in Zul'drak

---
 sql/updates/world/3.3.5/2019_12_22_03_world.sql | 9 +++++++++
 1 file changed, 9 insertions(+)
 create mode 100644 sql/updates/world/3.3.5/2019_12_22_03_world.sql

(limited to 'sql')

diff --git a/sql/updates/world/3.3.5/2019_12_22_03_world.sql b/sql/updates/world/3.3.5/2019_12_22_03_world.sql
new file mode 100644
index 00000000000..f8a27dfea78
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_12_22_03_world.sql
@@ -0,0 +1,9 @@
+-- 
+DELETE FROM `creature_template_addon` WHERE `entry` IN (29691, 29688, 29689) ;
+INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES
+(29691,0,7,1,0, ""),
+(29688,0,0,1,233, ""),
+(29689,0,0,1,333, "");
+UPDATE `gossip_menu_option` SET `OptionType`=3, `OptionNpcFlag`=128 WHERE `MenuID` IN (9848);
+UPDATE `creature` SET `MovementType`=0, `spawndist`=0 WHERE `id`= 29468;
+UPDATE `creature` SET `position_x`=5766.979492, `position_y`=-1617.112793, `position_z`=234.942978, `orientation`=0.605617 WHERE `guid`= 97401;
-- 
cgit v1.2.3