diff options
| author | Jinnaix <Jinnaix@users.noreply.github.com> | 2020-03-15 22:56:42 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-12-23 21:12:00 +0100 |
| commit | 588647431f8250aa14b48f4fcd90fcff5844d7b7 (patch) | |
| tree | 8147931d92b4630d6fd0c2bfd24c6ad117daf5c3 | |
| parent | c397d49a224ef8d2b991011d81d8e6df21a156a0 (diff) | |
DB/Formation: Link some boss in Molten Core to their adds
Closes #24306
(cherry picked from commit d8b24ce7783f17afd8ea2165c9d07ec22e6176de)
| -rw-r--r-- | sql/updates/world/master/2021_12_23_11_world_2020_03_15_07_world.sql | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_12_23_11_world_2020_03_15_07_world.sql b/sql/updates/world/master/2021_12_23_11_world_2020_03_15_07_world.sql new file mode 100644 index 00000000000..566c0563e9d --- /dev/null +++ b/sql/updates/world/master/2021_12_23_11_world_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); |