DB/Creatures: corrected several movement template flight values for creatures all accross Northrend. No more raining Gargoyles, Frost Wyrms, Birds and other flying things

1 files changed, 7 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2020_05_16_00_world.sql b/sql/updates/world/3.3.5/2020_05_16_00_world.sql
new file mode 100644
index 00000000000..c48237e14bf
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_05_16_00_world.sql
@@ -0,0 +1,7 @@
+--
+UPDATE `creature_template_movement` SET `Flight`= 1 WHERE `CreatureId` IN (26174, 26483, 24440, 24747, 28246, 29460, 29808, 32630, 30575, 30482, 31137, 32767, 31702, 32189, 32201, 32492, 28170, 28004, 28378, 28086, 28085, 30988, 33550, 30275);
+
+DELETE FROM `creature_template_movement` WHERE `CreatureId` IN (29792, 29793);
+INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Flight`) VALUES
+(29792, 1, 1),
+(29793, 1, 1);