aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/3.3.5/2018_08_22_04_world.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_08_22_04_world.sql b/sql/updates/world/3.3.5/2018_08_22_04_world.sql
new file mode 100644
index 00000000000..8d8119aec6b
--- /dev/null
+++ b/sql/updates/world/3.3.5/2018_08_22_04_world.sql
@@ -0,0 +1,4 @@
+--
+UPDATE `creature` SET `MovementType`=0, `spawndist`=0 WHERE `id` IN (27401,27403);
+DELETE FROM `creature_template_addon` WHERE `entry`=27401;
+INSERT `creature_template_addon` (`entry`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (27401,0,0,0,1,233 , '');