From 7f72fa2f8ec59727953eff35da39e11e0c37a3c5 Mon Sep 17 00:00:00 2001 From: Shauren Date: Tue, 27 Sep 2022 16:16:18 +0200 Subject: DB/Halls of Reflection: Added spawn groups for bosses (cherry picked from commit d6b54905139623cf0e8271e07fb0ec14e23f60d6) --- .../master/2022_09_30_34_world_2022_09_27_00_world.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 sql/updates/world/master/2022_09_30_34_world_2022_09_27_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2022_09_30_34_world_2022_09_27_00_world.sql b/sql/updates/world/master/2022_09_30_34_world_2022_09_27_00_world.sql new file mode 100644 index 00000000000..ce09a6f9d8e --- /dev/null +++ b/sql/updates/world/master/2022_09_30_34_world_2022_09_27_00_world.sql @@ -0,0 +1,14 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 284 AND 285; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES +(284,'Halls of Reflection - Falric',4), +(285,'Halls of Reflection - Marwyn',4); + +DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 284 AND 285; +INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES +(668,0,23,284,1), +(668,1,23,285,1); + +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 284 AND 285; +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES +(284,0,202308), +(285,0,202294); -- cgit v1.2.3