aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoroffl <offl@users.noreply.github.com>2020-09-21 04:31:53 +0300
committerShauren <shauren.trinity@gmail.com>2022-02-27 22:58:18 +0100
commitb10b108f04d24e4856f0fa457a12a88cf3be6f53 (patch)
tree479a8240cc5df057246af4ec5b65f84d6dec8630
parent5e013a999692f312aa952054d91c397963fb0155 (diff)
DB/Creature: Change flight state CanFly to DisableGravity part 1
Updates #6148 That fish in Dalaran aquarium is finally visible (cherry picked from commit 2a7181b49406fb3a861b6306f3d2043b1bf0312d)
-rw-r--r--sql/updates/world/master/2022_02_27_32_world_2020_09_21_02_world.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_02_27_32_world_2020_09_21_02_world.sql b/sql/updates/world/master/2022_02_27_32_world_2020_09_21_02_world.sql
new file mode 100644
index 00000000000..840553f8950
--- /dev/null
+++ b/sql/updates/world/master/2022_02_27_32_world_2020_09_21_02_world.sql
@@ -0,0 +1,4 @@
+--
+UPDATE `creature_template_movement` SET `Flight` = 1 WHERE `CreatureId` IN (25964,25965,25966,26190,26276,26277,26369,27241,27244,27638,27656,27691,27852,28276,28614,29239,29332,29646,29893,30184,30330,30446,30889,30903,30991,31095,31561,31719,31768,31769,32180,32185,32186,32323,33528,33576,33733,36896,37528,37636);
+-- Not needed at all
+UPDATE `creature_template_movement` SET `Flight` = 0 WHERE `CreatureId` IN (30315,30316,30317,30318);