From 006befabfc0fccb4ed23add362f44caac0ba0820 Mon Sep 17 00:00:00 2001
From: Killyana <morphone1@gmail.com>
Date: Tue, 18 Sep 2018 22:02:48 +0200
Subject: DB/Creature: Fix some root for some npcs

Closes #22447

(cherry picked from commit 010b872e5fa07d187718690170b92b1aa746aaa5)
---
 sql/updates/world/master/2021_11_09_04_world_2018_09_18_03_world.sql | 3 +++
 1 file changed, 3 insertions(+)
 create mode 100644 sql/updates/world/master/2021_11_09_04_world_2018_09_18_03_world.sql

(limited to 'sql')

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);
-- 
cgit v1.2.3