DB/Deadmines: Migrate Deadmines linked_respawn to spawn groups

2 files changed, 47 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2022_09_19_00_world.sql b/sql/updates/world/3.3.5/2022_09_19_00_world.sql
new file mode 100644
index 00000000000..0a27d3916e1
--- /dev/null
+++ b/sql/updates/world/3.3.5/2022_09_19_00_world.sql
@@ -0,0 +1,38 @@
+DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN 130 AND 136;
+INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES
+(130,'Deadmines - Edwin VanCleef',4),
+(131,'Deadmines - Captain Greenskin',4),
+(132,'Deadmines - Cookie',4),
+(133,'Deadmines - Mr. Smite',4),
+(134,'Deadmines - Gilnid',4),
+(135,'Deadmines - Sneed',4),
+(136,'Deadmines - Rhahk''Zor',4);
+
+DELETE FROM `instance_spawn_groups` WHERE `spawnGroupId` BETWEEN 130 AND 136;
+INSERT INTO `instance_spawn_groups` (`instanceMapId`,`bossStateId`,`bossStates`,`spawnGroupId`,`flags`) VALUES
+(36,5,23,130,1),
+(36,4,23,131,1),
+(36,6,23,132,1),
+(36,3,23,133,1),
+(36,2,23,134,1),
+(36,1,23,135,1),
+(36,0,23,136,1);
+
+DELETE FROM `spawn_group` WHERE `groupId` BETWEEN 130 AND 136;
+INSERT INTO `spawn_group` SELECT 130, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=79336 AND `linkType` IN (0,3);
+INSERT INTO `spawn_group` SELECT 131, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=79333 AND `linkType` IN (0,3);
+INSERT INTO `spawn_group` SELECT 132, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=79344 AND `linkType` IN (0,3);
+INSERT INTO `spawn_group` SELECT 133, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=79337 AND `linkType` IN (0,3);
+INSERT INTO `spawn_group` SELECT 134, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=79206 AND `linkType` IN (0,3);
+INSERT INTO `spawn_group` SELECT 135, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=79223 AND `linkType` IN (0,3);
+INSERT INTO `spawn_group` SELECT 136, 0, `guid` FROM `linked_respawn` WHERE `linkedGuid`=79168 AND `linkType` IN (0,3);
+INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES
+(130,0,79336),
+(131,0,79333),
+(132,0,79344),
+(133,0,79337),
+(134,0,79206),
+(135,0,79223),
+(136,0,79168);
+
+DELETE FROM `linked_respawn` WHERE `linkedGuid` IN (79336,79333,79344,79337,79206,79223,79168);
diff --git a/src/server/scripts/EasternKingdoms/Deadmines/instance_deadmines.cpp b/src/server/scripts/EasternKingdoms/Deadmines/instance_deadmines.cpp
index 868e8494403..03b3373179e 100644
--- a/src/server/scripts/EasternKingdoms/Deadmines/instance_deadmines.cpp
+++ b/src/server/scripts/EasternKingdoms/Deadmines/instance_deadmines.cpp
@@ -240,6 +240,15 @@ class instance_deadmines : public InstanceMapScript
                         case NPC_GILNID:
                             SetBossState(BOSS_GILNID, DONE);
                             break;
+                        case NPC_MR_SMITE:
+                            SetBossState(BOSS_MR_SMITE, DONE);
+                            break;
+                        case NPC_GREENSKIN:
+                            SetBossState(BOSS_GREENSKIN, DONE);
+                            break;
+                        case NPC_COOKIE:
+                            SetBossState(BOSS_COOKIE, DONE);
+                            break;
                         default:
                             break;
                     }