aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2018-09-18 22:02:48 +0200
committerShauren <shauren.trinity@gmail.com>2021-11-09 23:08:36 +0100
commit006befabfc0fccb4ed23add362f44caac0ba0820 (patch)
tree29dcac2882ba23e04179205e691587cabd2f5fa4
parent4e3d73649518fe02992dab26fad03d602a972e11 (diff)
DB/Creature: Fix some root for some npcs
Closes #22447 (cherry picked from commit 010b872e5fa07d187718690170b92b1aa746aaa5)
-rw-r--r--sql/updates/world/master/2021_11_09_04_world_2018_09_18_03_world.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_11_09_04_world_2018_09_18_03_world.sql b/sql/updates/world/master/2021_11_09_04_world_2018_09_18_03_world.sql
new file mode 100644
index 00000000000..d71ed725e4e
--- /dev/null
+++ b/sql/updates/world/master/2021_11_09_04_world_2018_09_18_03_world.sql
@@ -0,0 +1,3 @@
+--
+UPDATE `creature_template_movement` SET `Ground`=1, `Swim`=0, `Flight`=0, `Rooted`=1 WHERE `CreatureId`=29747;
+UPDATE `creature_template_movement` SET `Rooted`=0 WHERE `CreatureId` IN (14697, 18695, 30475, 31424);