diff options
| author | offl <offl@users.noreply.github.com> | 2021-03-17 02:12:33 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-03-07 20:25:58 +0100 |
| commit | 8cb62478fa40e655218fe81d18c21a1a3961ece5 (patch) | |
| tree | e8cd9d92e2d5dbdc4992885f037de6cc5f68a32b | |
| parent | 4ef092c04ddd51e774c2c8988d6667f8f64ac68e (diff) | |
DB/Creature: Fix movement states of Air Force guards
Ref #23580
(cherry picked from commit 4b73205c72a54aeff1f9cf3d412393107de09416)
| -rw-r--r-- | sql/updates/world/master/2022_03_07_11_world_2021_03_17_02_world.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_07_11_world_2021_03_17_02_world.sql b/sql/updates/world/master/2022_03_07_11_world_2021_03_17_02_world.sql new file mode 100644 index 00000000000..9d551624e24 --- /dev/null +++ b/sql/updates/world/master/2022_03_07_11_world_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); |