diff options
| author | Jinnaix <Jinnaix@users.noreply.github.com> | 2020-03-15 22:56:42 +0100 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2020-03-15 22:56:42 +0100 |
| commit | d8b24ce7783f17afd8ea2165c9d07ec22e6176de (patch) | |
| tree | ec2c7c2354a28c0c39a057f9d630eedd0c82cdbf | |
| parent | de923fedc931cec6e95cb210c776669a45c19e5e (diff) | |
DB/Formation: Link some boss in Molten Core to their adds
Closes #24306
| -rw-r--r-- | sql/updates/world/3.3.5/2020_03_15_07_world.sql | 21 |
1 files changed, 21 insertions, 0 deletions
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); |