From a6ad034703e812f40e10ada377aff8888b0663f4 Mon Sep 17 00:00:00 2001 From: Shauren Date: Tue, 27 Sep 2022 23:40:04 +0200 Subject: DB/Ruins of Ahn'Qiraj: Added spawn groups for bosses (cherry picked from commit 349ba4e74a6d6f9c3202b7d9420896fb6ee06910) --- .../2022_09_30_35_world_2022_09_27_02_world.sql | 26 ++++++++++++++++++++++ 1 file changed, 26 insertions(+) create mode 100644 sql/updates/world/master/2022_09_30_35_world_2022_09_27_02_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2022_09_30_35_world_2022_09_27_02_world.sql b/sql/updates/world/master/2022_09_30_35_world_2022_09_27_02_world.sql new file mode 100644 index 00000000000..4b1ab1b4fe4 --- /dev/null +++ b/sql/updates/world/master/2022_09_30_35_world_2022_09_27_02_world.sql @@ -0,0 +1,26 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 293 AND 298; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(293,'Ruins of Ahn''Qiraj - Kurinnaxx',4), +(294,'Ruins of Ahn''Qiraj - General Rajaxx',4), +(295,'Ruins of Ahn''Qiraj - Moam',4), +(296,'Ruins of Ahn''Qiraj - Buru the Gorger',4), +(297,'Ruins of Ahn''Qiraj - Ayamiss the Hunter',4), +(298,'Ruins of Ahn''Qiraj - Ossirian the Unscarred',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 293 AND 298; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(509,0,23,293,1), +(509,1,23,294,1), +(509,2,23,295,1), +(509,4,23,296,1), +(509,5,23,297,1), +(509,6,23,298,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 293 AND 298; +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(293,0,144632), +(294,0,144603), +(295,0,144602), +(296,0,144642), +(297,0,144641), +(298,0,144601); -- cgit v1.2.3