DB/SpawnGroup: Spawn group data for VoA and Gundrak

(cherry picked from commit 178b530ab6f2a77b980d9c4c4d8df6d3bfffff98)

2 files changed, 160 insertions, 0 deletions

diff --git a/sql/updates/world/master/2021_06_16_07_world_2018_01_24_01_world.sql b/sql/updates/world/master/2021_06_16_07_world_2018_01_24_01_world.sql
new file mode 100644
index 00000000000..cf77e551c19
--- /dev/null
+++ b/sql/updates/world/master/2021_06_16_07_world_2018_01_24_01_world.sql
@@ -0,0 +1,47 @@
+-- SpawnGroupMapper auto-generated SQL for map 624 (Vault of Archavon)
+
+-- Constant setter section - adjust this
+-- spawn_group_template (4 entries)
+SET @FIRSTGROUPID := 28;
+-- Boss state associations
+SET @ARCHAVON := 0; -- boss state that controls group "Archavon"
+SET @EMALON := 1; -- boss state that controls group "Emalon"
+SET @KORALON := 2; -- boss state that controls group "Koralon"
+SET @TORAVON := 3; -- boss state that controls group "Toravon"
+
+-- DB modification section - you shouldn't need to touch this
+-- Insert spawn group templates
+DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN @FIRSTGROUPID+0 AND @FIRSTGROUPID+3;
+INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES
+    (@FIRSTGROUPID+0, "Vault of Archavon - Archavon", 0x04),
+    (@FIRSTGROUPID+1, "Vault of Archavon - Emalon", 0x04),
+    (@FIRSTGROUPID+2, "Vault of Archavon - Koralon", 0x04),
+    (@FIRSTGROUPID+3, "Vault of Archavon - Toravon", 0x04);
+
+-- Insert spawn group data
+DELETE FROM `spawn_group` WHERE `groupId` BETWEEN @FIRSTGROUPID+0 AND @FIRSTGROUPID+3;
+INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES
+    (@FIRSTGROUPID+2, 0, 202596),
+    (@FIRSTGROUPID+2, 0, 202598),
+    (@FIRSTGROUPID+3, 0, 202600),
+    (@FIRSTGROUPID+0, 0, 202589),
+    (@FIRSTGROUPID+0, 0, 202591),
+    (@FIRSTGROUPID+1, 0, 202593),
+    (@FIRSTGROUPID+1, 0, 202595),
+    (@FIRSTGROUPID+2, 0, 202597),
+    (@FIRSTGROUPID+3, 0, 202606),
+    (@FIRSTGROUPID+0, 0, 202588),
+    (@FIRSTGROUPID+0, 0, 202590),
+    (@FIRSTGROUPID+1, 0, 202594),
+    (@FIRSTGROUPID+3, 0, 202605);
+
+-- Link information for instance script
+DELETE FROM `instance_spawn_groups` WHERE `instanceMapId` = 624;
+INSERT INTO `instance_spawn_groups` (`instanceMapId`, `bossStateId`, `bossStates`, `spawnGroupId`, `flags`) VALUES
+    (624,@ARCHAVON,0x17,@FIRSTGROUPID+0,0x1), -- Spawn Archavon if state is not DONE
+    (624,@EMALON,0x17,@FIRSTGROUPID+1,0x1), -- Spawn Emalon if state is not DONE
+    (624,@KORALON,0x17,@FIRSTGROUPID+2,0x1), -- Spawn Koralon if state is not DONE
+    (624,@TORAVON,0x17,@FIRSTGROUPID+3,0x1); -- Spawn Toravon if state is not DONE
+
+-- Remove legacy linked_respawn entries
+DELETE lr FROM `linked_respawn` lr INNER JOIN `spawn_group` sg ON sg.`groupId` BETWEEN @FIRSTGROUPID+0 AND @FIRSTGROUPID+3 AND sg.`spawnType` = (lr.linkType >> 1) AND sg.`spawnId`=lr.`guid`;
diff --git a/sql/updates/world/master/2021_06_16_08_world_2018_01_24_02_world.sql b/sql/updates/world/master/2021_06_16_08_world_2018_01_24_02_world.sql
new file mode 100644
index 00000000000..294df6dbb94
--- /dev/null
+++ b/sql/updates/world/master/2021_06_16_08_world_2018_01_24_02_world.sql
@@ -0,0 +1,113 @@
+-- SpawnGroupMapper auto-generated SQL for map 604 (Gundrak)
+
+-- Constant setter section - adjust this
+-- spawn_group_template (5 entries)
+SET @FIRSTGROUPID := 32;
+-- Boss state associations
+SET @SLADRAN := 0; -- boss state that controls group "Slad'ran"
+SET @DRAKKARICOLOSSUS := 1; -- boss state that controls group "Drakkari Colossus"
+SET @MOORABI := 2; -- boss state that controls group "Moorabi"
+SET @GALDARAH := 3; -- boss state that controls group "Gal'darah"
+SET @ECKTHEFEROCIOUS := 4; -- boss state that controls group "Eck the Ferocious"
+
+-- DB modification section - you shouldn't need to touch this
+-- Insert spawn group templates
+DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN @FIRSTGROUPID+0 AND @FIRSTGROUPID+4;
+INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES
+    (@FIRSTGROUPID+0, "Gundrak - Slad'ran", 0x04),
+    (@FIRSTGROUPID+1, "Gundrak - Drakkari Colossus", 0x04),
+    (@FIRSTGROUPID+2, "Gundrak - Moorabi", 0x04),
+    (@FIRSTGROUPID+3, "Gundrak - Gal'darah", 0x04),
+    (@FIRSTGROUPID+4, "Gundrak - Eck the Ferocious", 0x04);
+
+-- Insert spawn group data
+DELETE FROM `spawn_group` WHERE `groupId` BETWEEN @FIRSTGROUPID+0 AND @FIRSTGROUPID+4;
+INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES
+    (@FIRSTGROUPID+0, 0, 127019),
+    (@FIRSTGROUPID+2, 0, 127051),
+    (@FIRSTGROUPID+2, 0, 127067),
+    (@FIRSTGROUPID+0, 0, 127020),
+    (@FIRSTGROUPID+2, 0, 127052),
+    (@FIRSTGROUPID+2, 0, 127068),
+    (@FIRSTGROUPID+0, 0, 127021),
+    (@FIRSTGROUPID+2, 0, 127053),
+    (@FIRSTGROUPID+2, 0, 127069),
+    (@FIRSTGROUPID+0, 0, 127006),
+    (@FIRSTGROUPID+0, 0, 127022),
+    (@FIRSTGROUPID+2, 0, 127054),
+    (@FIRSTGROUPID+2, 0, 127070),
+    (@FIRSTGROUPID+0, 0, 127007),
+    (@FIRSTGROUPID+0, 0, 127023),
+    (@FIRSTGROUPID+2, 0, 127055),
+    (@FIRSTGROUPID+1, 0, 127071),
+    (@FIRSTGROUPID+0, 0, 127008),
+    (@FIRSTGROUPID+0, 0, 127024),
+    (@FIRSTGROUPID+2, 0, 127056),
+    (@FIRSTGROUPID+1, 0, 127072),
+    (@FIRSTGROUPID+0, 0, 127009),
+    (@FIRSTGROUPID+0, 0, 127025),
+    (@FIRSTGROUPID+2, 0, 127057),
+    (@FIRSTGROUPID+1, 0, 127073),
+    (@FIRSTGROUPID+4, 0, 127201),
+    (@FIRSTGROUPID+0, 0, 127010),
+    (@FIRSTGROUPID+0, 0, 127026),
+    (@FIRSTGROUPID+0, 0, 127042),
+    (@FIRSTGROUPID+0, 0, 127058),
+    (@FIRSTGROUPID+1, 0, 127074),
+    (@FIRSTGROUPID+4, 0, 127202),
+    (@FIRSTGROUPID+0, 0, 127011),
+    (@FIRSTGROUPID+0, 0, 127027),
+    (@FIRSTGROUPID+2, 0, 127043),
+    (@FIRSTGROUPID+2, 0, 127059),
+    (@FIRSTGROUPID+1, 0, 127075),
+    (@FIRSTGROUPID+4, 0, 127203),
+    (@FIRSTGROUPID+0, 0, 127012),
+    (@FIRSTGROUPID+0, 0, 127028),
+    (@FIRSTGROUPID+3, 0, 127044),
+    (@FIRSTGROUPID+2, 0, 127060),
+    (@FIRSTGROUPID+1, 0, 127076),
+    (@FIRSTGROUPID+4, 0, 127204),
+    (@FIRSTGROUPID+0, 0, 127013),
+    (@FIRSTGROUPID+0, 0, 127029),
+    (@FIRSTGROUPID+0, 0, 127045),
+    (@FIRSTGROUPID+2, 0, 127061),
+    (@FIRSTGROUPID+1, 0, 127077),
+    (@FIRSTGROUPID+4, 0, 127205),
+    (@FIRSTGROUPID+0, 0, 127014),
+    (@FIRSTGROUPID+1, 0, 127046),
+    (@FIRSTGROUPID+2, 0, 127062),
+    (@FIRSTGROUPID+1, 0, 127078),
+    (@FIRSTGROUPID+3, 0, 127110),
+    (@FIRSTGROUPID+4, 0, 127206),
+    (@FIRSTGROUPID+0, 0, 127015),
+    (@FIRSTGROUPID+2, 0, 127047),
+    (@FIRSTGROUPID+2, 0, 127063),
+    (@FIRSTGROUPID+1, 0, 127079),
+    (@FIRSTGROUPID+3, 0, 127111),
+    (@FIRSTGROUPID+3, 0, 127207),
+    (@FIRSTGROUPID+0, 0, 127016),
+    (@FIRSTGROUPID+2, 0, 127048),
+    (@FIRSTGROUPID+2, 0, 127064),
+    (@FIRSTGROUPID+1, 0, 127080),
+    (@FIRSTGROUPID+3, 0, 127112),
+    (@FIRSTGROUPID+0, 0, 127017),
+    (@FIRSTGROUPID+2, 0, 127049),
+    (@FIRSTGROUPID+2, 0, 127065),
+    (@FIRSTGROUPID+1, 0, 127081),
+    (@FIRSTGROUPID+2, 0, 127113),
+    (@FIRSTGROUPID+0, 0, 127018),
+    (@FIRSTGROUPID+2, 0, 127050),
+    (@FIRSTGROUPID+2, 0, 127066),
+    (@FIRSTGROUPID+1, 0, 127082);
+
+-- Link information for instance script
+DELETE FROM `instance_spawn_groups` WHERE `instanceMapId` = 604;
+INSERT INTO `instance_spawn_groups` (`instanceMapId`, `bossStateId`, `bossStates`, `spawnGroupId`, `flags`) VALUES
+    (604,@SLADRAN,0x17,@FIRSTGROUPID+0,0x1), -- Spawn Slad'ran if state is not DONE
+    (604,@DRAKKARICOLOSSUS,0x17,@FIRSTGROUPID+1,0x1), -- Spawn Drakkari Colossus if state is not DONE
+    (604,@MOORABI,0x17,@FIRSTGROUPID+2,0x1), -- Spawn Moorabi if state is not DONE
+    (604,@GALDARAH,0x17,@FIRSTGROUPID+3,0x1), -- Spawn Gal'darah if state is not DONE
+    (604,@ECKTHEFEROCIOUS,0x17,@FIRSTGROUPID+4,0x1); -- Spawn Eck the Ferocious if state is not DONE
+
+-- Remove legacy linked_respawn entries
+DELETE lr FROM `linked_respawn` lr INNER JOIN `spawn_group` sg ON sg.`groupId` BETWEEN @FIRSTGROUPID+0 AND @FIRSTGROUPID+4 AND sg.`spawnType` = (lr.linkType >> 1) AND sg.`spawnId`=lr.`guid`;