DB/Halls of Reflection: Added spawn groups for bosses

(cherry picked from commit d6b54905139623cf0e8271e07fb0ec14e23f60d6)

1 files changed, 14 insertions, 0 deletions

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);