aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoroffl <offl@users.noreply.github.com>2020-12-23 21:42:34 +0200
committeroffl <offl@users.noreply.github.com>2020-12-23 21:42:34 +0200
commit9cff30b37faaa195a02d5225fb12d2f6a6534bab (patch)
tree74fcf6bbbae590bfa2eb445cbc460681a0011e5f
parent9ae23ef2fdb98bd2a2bf6dee4eb35c1b44cfc427 (diff)
DB/Creature: Root Ironwork Cannon & fix model
-rw-r--r--sql/updates/world/3.3.5/2020_12_23_00_world.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_12_23_00_world.sql b/sql/updates/world/3.3.5/2020_12_23_00_world.sql
new file mode 100644
index 00000000000..0d60335e012
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_12_23_00_world.sql
@@ -0,0 +1,5 @@
+--
+UPDATE `creature` SET `modelid` = 25723 WHERE `id` = 33264;
+DELETE FROM `creature_template_movement` WHERE `CreatureId` = 33264;
+INSERT INTO `creature_template_movement` (`CreatureId`,`Ground`,`Swim`,`Flight`,`Rooted`,`Chase`,`Random`) VALUES
+(33264,1,0,0,1,0,0);