From 8a9f80909387615fb7e22a0f8a042c3ad7a10cfc Mon Sep 17 00:00:00 2001 From: Ovahlord Date: Sat, 16 May 2020 21:22:30 +0200 Subject: DB/Creatures: corrected several movement template flight values for creatures all accross Northrend. No more raining Gargoyles, Frost Wyrms, Birds and other flying things --- sql/updates/world/3.3.5/2020_05_16_00_world.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sql/updates/world/3.3.5/2020_05_16_00_world.sql (limited to 'sql') 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); -- cgit v1.2.3