aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authoroffl <offl@users.noreply.github.com>2020-12-23 21:42:34 +0200
committerShauren <shauren.trinity@gmail.com>2022-03-05 15:18:46 +0100
commitfc450f7458fd05e0d9b4a04f19bf3adeac785328 (patch)
tree8200cb2235dde98f6a77bf5b40edcb9b13cbfaa8 /sql
parentcd6e944d1771edf60d0f24bcb04ed50e36ac8981 (diff)
DB/Creature: Root Ironwork Cannon & fix model
(cherry picked from commit 9cff30b37faaa195a02d5225fb12d2f6a6534bab)
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2022_03_05_09_world_2020_12_23_00_world.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_05_09_world_2020_12_23_00_world.sql b/sql/updates/world/master/2022_03_05_09_world_2020_12_23_00_world.sql
new file mode 100644
index 00000000000..0d60335e012
--- /dev/null
+++ b/sql/updates/world/master/2022_03_05_09_world_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);