From 4b73205c72a54aeff1f9cf3d412393107de09416 Mon Sep 17 00:00:00 2001
From: offl <offl@users.noreply.github.com>
Date: Wed, 17 Mar 2021 02:12:33 +0200
Subject: DB/Creature: Fix movement states of Air Force guards

Ref #23580
---
 sql/updates/world/3.3.5/2021_03_17_02_world.sql | 9 +++++++++
 1 file changed, 9 insertions(+)
 create mode 100644 sql/updates/world/3.3.5/2021_03_17_02_world.sql

(limited to 'sql')

diff --git a/sql/updates/world/3.3.5/2021_03_17_02_world.sql b/sql/updates/world/3.3.5/2021_03_17_02_world.sql
new file mode 100644
index 00000000000..9d551624e24
--- /dev/null
+++ b/sql/updates/world/3.3.5/2021_03_17_02_world.sql
@@ -0,0 +1,9 @@
+--
+UPDATE `creature_template_movement` SET `Ground` = 1 WHERE `CreatureId` IN (15241,15242,21976);
+DELETE FROM `creature_template_movement` WHERE `CreatureId` IN (22067,22077,22085,22089,22122);
+INSERT INTO `creature_template_movement` (`CreatureId`,`Ground`,`Swim`,`Flight`,`Rooted`,`Chase`,`Random`) VALUES
+(22067,1,0,1,0,0,0),
+(22077,1,0,1,0,0,0),
+(22085,1,0,1,0,0,0),
+(22089,1,0,1,0,0,0),
+(22122,1,0,1,0,0,0);
-- 
cgit v1.2.3