From d8b24ce7783f17afd8ea2165c9d07ec22e6176de Mon Sep 17 00:00:00 2001 From: Jinnaix Date: Sun, 15 Mar 2020 22:56:42 +0100 Subject: DB/Formation: Link some boss in Molten Core to their adds Closes #24306 --- sql/updates/world/3.3.5/2020_03_15_07_world.sql | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) create mode 100644 sql/updates/world/3.3.5/2020_03_15_07_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/3.3.5/2020_03_15_07_world.sql b/sql/updates/world/3.3.5/2020_03_15_07_world.sql new file mode 100644 index 00000000000..566c0563e9d --- /dev/null +++ b/sql/updates/world/3.3.5/2020_03_15_07_world.sql @@ -0,0 +1,21 @@ +-- Molten Core Creature Formations +-- Golemagg 11988 and his 2 Corer Rager 11672 +DELETE FROM `creature_formations` WHERE `memberGUID` IN (56685,56699,56684); +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(56684, 56685, 0, 0, 3, 0, 0), +(56684, 56699, 0, 0, 3, 0, 0), +(56684, 56684, 0, 0, 3, 0, 0); +-- Sulfuron Harbinger 12098 and 4 Flamewaker Priests +DELETE FROM `creature_formations` WHERE `memberGUID` IN (56677,56682,56679,56678,56681); +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(56677, 56677, 0, 0, 3, 0, 0), +(56677, 56682, 0, 0, 3, 0, 0), +(56677, 56679, 0, 0, 3, 0, 0), +(56677, 56678, 0, 0, 3, 0, 0), +(56677, 56681, 0, 0, 3, 0, 0); +-- Gehennas 12259 and 2 Flamewaker 11661 +DELETE FROM `creature_formations` WHERE `memberGUID` IN (56737,56739,56738); +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(56737, 56737, 0, 0, 3, 0, 0), +(56737, 56739, 0, 0, 3, 0, 0), +(56737, 56738, 0, 0, 3, 0, 0); -- cgit v1.2.3