diff options
| author | offl <offl@users.noreply.github.com> | 2021-03-17 02:12:33 +0200 |
|---|---|---|
| committer | offl <offl@users.noreply.github.com> | 2021-03-17 02:12:33 +0200 |
| commit | 4b73205c72a54aeff1f9cf3d412393107de09416 (patch) | |
| tree | cf638d201125d409217fc4f050481fa169566fee | |
| parent | 96e1fd54eb63edb1e186a9bb0dd178250d28ea6c (diff) | |
DB/Creature: Fix movement states of Air Force guards
Ref #23580
| -rw-r--r-- | sql/updates/world/3.3.5/2021_03_17_02_world.sql | 9 |
1 files changed, 9 insertions, 0 deletions
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); |