aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoroffl <offl@users.noreply.github.com>2021-01-04 19:59:37 +0200
committerShauren <shauren.trinity@gmail.com>2022-03-05 21:46:19 +0100
commitbb9b2f1367af00a99b714dd6936d8b15c6b6d804 (patch)
treeed03d4749db41c6bb16879f409630d2c2c191ffe
parent4efc88664b948560d63abdb1ff5ce4816b3936e5 (diff)
DB/Creature: Restore incorrectly removed movement states
Ref 6d3c01732d27daa4507bd93dc8109b0a955b1dc8 (cherry picked from commit 6bbf734f404969b29a5dca03612a08ad58fbf7bf)
-rw-r--r--sql/updates/world/master/2022_03_05_44_world_2021_01_04_15_world.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_05_44_world_2021_01_04_15_world.sql b/sql/updates/world/master/2022_03_05_44_world_2021_01_04_15_world.sql
new file mode 100644
index 00000000000..9f87a241311
--- /dev/null
+++ b/sql/updates/world/master/2022_03_05_44_world_2021_01_04_15_world.sql
@@ -0,0 +1,8 @@
+--
+DELETE FROM `creature_template_movement` WHERE `CreatureId` IN (16972,17035,17053,20069,20142);
+INSERT INTO `creature_template_movement` (`CreatureId`,`Ground`,`Swim`,`Flight`,`Rooted`,`Chase`,`Random`) VALUES
+(16972,1,0,0,0,0,0),
+(17035,1,0,0,0,0,0),
+(17053,1,0,0,0,0,0),
+(20069,1,0,0,0,0,0),
+(20142,1,0,0,0,0,0);