DB/InstanceSpawn: The easy ones. Gruul's Lair, Magtheridon's Lair, Onyxia's Lair, Eye of Eternity.

4 files changed, 143 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2017_08_04_01_world.sql b/sql/updates/world/3.3.5/2017_08_04_01_world.sql
new file mode 100644
index 00000000000..239280e30ed
--- /dev/null
+++ b/sql/updates/world/3.3.5/2017_08_04_01_world.sql
@@ -0,0 +1,33 @@
+-- SpawnGroupMapper auto-generated SQL for map 249 (Onyxia's Lair)
+
+-- Constant setter section - adjust this
+-- spawn_group_template (1 entries)
+SET @FIRSTGROUPID := 10;
+-- Boss state associations
+SET @ONYXIA := 0; -- boss state that controls group "Onyxia"
+
+-- 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+0;
+INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES
+    (@FIRSTGROUPID+0, "Onyxia's Lair - Onyxia", 0x04);
+
+-- Insert spawn group data
+DELETE FROM `spawn_group` WHERE `groupId` BETWEEN @FIRSTGROUPID+0 AND @FIRSTGROUPID+0;
+INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES
+    (@FIRSTGROUPID+0, 0, 52050),
+    (@FIRSTGROUPID+0, 0, 52052),
+    (@FIRSTGROUPID+0, 0, 52047),
+    (@FIRSTGROUPID+0, 0, 52049),
+    (@FIRSTGROUPID+0, 0, 52051),
+    (@FIRSTGROUPID+0, 0, 52053),
+    (@FIRSTGROUPID+0, 0, 52048),
+    (@FIRSTGROUPID+0, 0, 47572);
+
+-- Link information for instance script
+DELETE FROM `instance_spawn_groups` WHERE `instanceMapId` = 249;
+INSERT INTO `instance_spawn_groups` (`instanceMapId`, `bossStateId`, `bossStates`, `spawnGroupId`, `flags`) VALUES
+    (249,@ONYXIA,0x17,@FIRSTGROUPID+0,0x1); -- Spawn Onyxia 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+0 AND sg.`spawnType` = (lr.linkType >> 1) AND sg.`spawnId`=lr.`guid`;
diff --git a/sql/updates/world/3.3.5/2017_08_04_02_world.sql b/sql/updates/world/3.3.5/2017_08_04_02_world.sql
new file mode 100644
index 00000000000..39e12947c9e
--- /dev/null
+++ b/sql/updates/world/3.3.5/2017_08_04_02_world.sql
@@ -0,0 +1,46 @@
+-- SpawnGroupMapper auto-generated SQL for map 565 (Gruul's Lair)
+
+-- Constant setter section - adjust this
+-- spawn_group_template (2 entries)
+SET @FIRSTGROUPID := 11;
+-- Boss state associations
+SET @HIGHKINGMAULGAR := 0; -- boss state that controls group "High King Maulgar"
+SET @GRUUL := 1; -- boss state that controls group "Gruul"
+
+-- 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+1;
+INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES
+    (@FIRSTGROUPID+0, "Gruul's Lair - High King Maulgar", 0x04),
+    (@FIRSTGROUPID+1, "Gruul's Lair - Gruul", 0x04);
+
+-- Insert spawn group data
+DELETE FROM `spawn_group` WHERE `groupId` BETWEEN @FIRSTGROUPID+0 AND @FIRSTGROUPID+1;
+INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES
+    (@FIRSTGROUPID+1, 0, 83206),
+    (@FIRSTGROUPID+0, 0, 48348),
+    (@FIRSTGROUPID+1, 0, 72432),
+    (@FIRSTGROUPID+0, 0, 81643),
+    (@FIRSTGROUPID+1, 0, 65618),
+    (@FIRSTGROUPID+1, 0, 81647),
+    (@FIRSTGROUPID+1, 0, 81649),
+    (@FIRSTGROUPID+0, 0, 81651),
+    (@FIRSTGROUPID+1, 0, 86065),
+    (@FIRSTGROUPID+0, 0, 7483),
+    (@FIRSTGROUPID+1, 0, 69871),
+    (@FIRSTGROUPID+0, 0, 81642),
+    (@FIRSTGROUPID+1, 0, 81644),
+    (@FIRSTGROUPID+0, 0, 81646),
+    (@FIRSTGROUPID+1, 0, 81648),
+    (@FIRSTGROUPID+1, 0, 81650),
+    (@FIRSTGROUPID+0, 0, 81652),
+    (@FIRSTGROUPID+0, 0, 81645);
+
+-- Link information for instance script
+DELETE FROM `instance_spawn_groups` WHERE `instanceMapId` = 565;
+INSERT INTO `instance_spawn_groups` (`instanceMapId`, `bossStateId`, `bossStates`, `spawnGroupId`, `flags`) VALUES
+    (565,@HIGHKINGMAULGAR,0x17,@FIRSTGROUPID+0,0x1), -- Spawn High King Maulgar if state is not DONE
+    (565,@GRUUL,0x17,@FIRSTGROUPID+1,0x1); -- Spawn Gruul 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+1 AND sg.`spawnType` = (lr.linkType >> 1) AND sg.`spawnId`=lr.`guid`;
diff --git a/sql/updates/world/3.3.5/2017_08_04_03_world.sql b/sql/updates/world/3.3.5/2017_08_04_03_world.sql
new file mode 100644
index 00000000000..16c53217a2f
--- /dev/null
+++ b/sql/updates/world/3.3.5/2017_08_04_03_world.sql
@@ -0,0 +1,38 @@
+-- SpawnGroupMapper auto-generated SQL for map 544 (Magtheridon's Lair)
+
+-- Constant setter section - adjust this
+-- spawn_group_template (1 entries)
+SET @FIRSTGROUPID := 13;
+-- Boss state associations
+SET @MAGTHERIDON := 0; -- boss state that controls group "Magtheridon"
+
+-- 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+0;
+INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES
+    (@FIRSTGROUPID+0, "Magtheridon's Lair - Magtheridon", 0x04);
+
+-- Insert spawn group data
+DELETE FROM `spawn_group` WHERE `groupId` BETWEEN @FIRSTGROUPID+0 AND @FIRSTGROUPID+0;
+INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES
+    (@FIRSTGROUPID+0, 0, 91247),
+    (@FIRSTGROUPID+0, 0, 90988),
+    (@FIRSTGROUPID+0, 0, 90992),
+    (@FIRSTGROUPID+0, 0, 91248),
+    (@FIRSTGROUPID+0, 0, 90985),
+    (@FIRSTGROUPID+0, 0, 90989),
+    (@FIRSTGROUPID+0, 0, 90993),
+    (@FIRSTGROUPID+0, 0, 91249),
+    (@FIRSTGROUPID+0, 0, 90986),
+    (@FIRSTGROUPID+0, 0, 90990),
+    (@FIRSTGROUPID+0, 0, 91254),
+    (@FIRSTGROUPID+0, 0, 90987),
+    (@FIRSTGROUPID+0, 0, 90991);
+
+-- Link information for instance script
+DELETE FROM `instance_spawn_groups` WHERE `instanceMapId` = 544;
+INSERT INTO `instance_spawn_groups` (`instanceMapId`, `bossStateId`, `bossStates`, `spawnGroupId`, `flags`) VALUES
+    (544,@MAGTHERIDON,0x17,@FIRSTGROUPID+0,0x1); -- Spawn Magtheridon 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+0 AND sg.`spawnType` = (lr.linkType >> 1) AND sg.`spawnId`=lr.`guid`;
diff --git a/sql/updates/world/3.3.5/2017_08_04_04_world.sql b/sql/updates/world/3.3.5/2017_08_04_04_world.sql
new file mode 100644
index 00000000000..08f4bbbb2b9
--- /dev/null
+++ b/sql/updates/world/3.3.5/2017_08_04_04_world.sql
@@ -0,0 +1,26 @@
+-- SpawnGroupMapper auto-generated SQL for map 616 (The Eye of Eternity)
+
+-- Constant setter section - adjust this
+-- spawn_group_template (1 entries)
+SET @FIRSTGROUPID := 14;
+-- Boss state associations
+SET @MALYGOS := 0; -- boss state that controls group "Malygos"
+
+-- 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+0;
+INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES
+    (@FIRSTGROUPID+0, "The Eye of Eternity - Malygos", 0x04);
+
+-- Insert spawn group data
+DELETE FROM `spawn_group` WHERE `groupId` BETWEEN @FIRSTGROUPID+0 AND @FIRSTGROUPID+0;
+INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES
+    (@FIRSTGROUPID+0, 0, 132313);
+
+-- Link information for instance script
+DELETE FROM `instance_spawn_groups` WHERE `instanceMapId` = 616;
+INSERT INTO `instance_spawn_groups` (`instanceMapId`, `bossStateId`, `bossStates`, `spawnGroupId`, `flags`) VALUES
+    (616,@MALYGOS,0x17,@FIRSTGROUPID+0,0x1); -- Spawn Malygos 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+0 AND sg.`spawnType` = (lr.linkType >> 1) AND sg.`spawnId`=lr.`guid`;