DB/Instance/The Arcatraz: Respawn Defender Corpse & Warder Corpse

1 files changed, 234 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2020_11_01_02_world.sql b/sql/updates/world/3.3.5/2020_11_01_02_world.sql
new file mode 100644
index 00000000000..2b943868153
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_11_01_02_world.sql
@@ -0,0 +1,234 @@
+--
+SET @CGUID := 147035; -- 72
+SET @POOL := 1516; -- 43
+
+DELETE FROM `pool_template` WHERE `entry` BETWEEN 576 AND 598;
+DELETE FROM `pool_members` WHERE `type` = 2 AND `poolSpawnId` = 598;
+DELETE FROM `pool_members` WHERE `type` = 0 AND `spawnId` IN
+(SELECT `guid` FROM `creature` WHERE `id` IN (21303,21304));
+
+DELETE FROM `creature` WHERE `id` IN (21303,21304);
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+00 AND @CGUID+71 AND `id` IN (21303,21304);
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES
+(@CGUID+00,21303,552,0,0,3,1,0,1,197.955,-86.8133,-10.0174,5.8294,86400,0,0,20283,0,0,0,0,0,"",14007),
+(@CGUID+01,21303,552,0,0,3,1,0,1,206.342,-98.2784,-10.0262,2.6529,86400,0,0,19626,0,0,0,0,0,"",14007),
+(@CGUID+02,21303,552,0,0,3,1,0,1,213.626,-161.424,-10.0346,2.74017,86400,0,0,19626,0,0,0,0,0,"",14007),
+(@CGUID+03,21303,552,0,0,3,1,0,1,210.114,-161.992,-10.0359,6.12611,86400,0,0,19626,0,0,0,0,0,"",14007),
+(@CGUID+04,21303,552,0,0,3,1,0,1,226.184,-162.096,-10.0352,0.349066,86400,0,0,19626,0,0,0,0,0,"",14545),
+(@CGUID+05,21303,552,0,0,3,1,0,1,264.271,-191.28,-10.0219,5.61996,86400,0,0,20283,0,0,0,0,0,"",14007),
+(@CGUID+06,21303,552,0,0,3,1,0,1,275.086,-192.666,-10.0268,3.01942,86400,0,0,19626,0,0,0,0,0,"",14007),
+(@CGUID+07,21303,552,0,0,3,1,0,1,245.982,-194.617,-10.0217,0.872665,86400,0,0,20283,0,0,0,0,0,"",0),
+(@CGUID+08,21303,552,0,0,3,1,0,1,232.754,-198.125,-10.023,5.61996,86400,0,0,20283,0,0,0,0,0,"",0),
+(@CGUID+09,21303,552,0,0,3,1,0,1,261.949,-49.208,22.4534,2.63545,86400,0,0,19626,0,0,0,0,0,"",14007),
+(@CGUID+10,21303,552,0,0,3,1,0,1,270.819,-45.4794,22.4534,4.46804,86400,0,0,20283,0,0,0,0,0,"",14007),
+(@CGUID+11,21303,552,0,0,3,1,0,1,263.595,-43.7782,22.4562,2.58309,86400,0,0,20283,0,0,0,0,0,"",14545),
+(@CGUID+12,21303,552,0,0,3,1,0,1,272.501,-40.1927,22.509,2.9147,86400,0,0,20283,0,0,0,0,0,"",0),
+(@CGUID+13,21303,552,0,0,3,1,0,1,270.767,-66.623,22.4534,5.74213,86400,0,0,19626,0,0,0,0,0,"",14545),
+(@CGUID+14,21303,552,0,0,3,1,0,1,262.56,-65.5981,22.4534,1.50098,86400,0,0,20283,0,0,0,0,0,"",14007),
+(@CGUID+15,21303,552,0,0,3,1,0,1,273.438,-64.07,22.4534,22.4534,86400,0,0,20283,0,0,0,0,0,"",0),
+(@CGUID+16,21303,552,0,0,3,1,0,1,311.119,-5.50369,22.5245,1.5708,86400,0,0,19626,0,0,0,0,0,"",14007),
+(@CGUID+17,21303,552,0,0,3,1,0,1,312.929,-7.19062,22.5245,4.03171,86400,0,0,19626,0,0,0,0,0,"",14007),
+(@CGUID+18,21303,552,0,0,3,1,0,1,291.632,70.5809,22.5269,2.00713,86400,0,0,20283,0,0,0,0,0,"",14007),
+(@CGUID+19,21303,552,0,0,3,1,0,1,293.885,70.9368,22.5262,1.55334,86400,0,0,20283,0,0,0,0,0,"",14007),
+(@CGUID+20,21303,552,0,0,3,1,0,1,285.416,127.127,22.2951,4.69494,86400,0,0,20283,0,0,0,0,0,"",14545),
+(@CGUID+21,21303,552,0,0,3,1,0,1,283.728,130.245,22.3065,0.575959,86400,0,0,20283,0,0,0,0,0,"",14007),
+(@CGUID+22,21303,552,0,0,3,1,0,1,291.801,158.914,22.3234,5.96903,86400,0,0,20283,0,0,0,0,0,"",14007),
+(@CGUID+23,21303,552,0,0,3,1,0,1,298.848,151.748,22.3105,5.70723,86400,0,0,20283,0,0,0,0,0,"",14545),
+(@CGUID+24,21303,552,0,0,3,1,0,1,306.976,141.112,22.2286,3.0285,86400,0,0,20283,0,0,0,0,0,"",0),
+(@CGUID+25,21303,552,0,0,3,1,0,1,311.196,125.847,22.337,1.64061,86400,0,0,19626,0,0,0,0,0,"",14007),
+(@CGUID+26,21303,552,0,0,3,1,0,1,279.572998,134.337875,22.223705,4.94015,86400,0,0,20283,0,0,0,0,0,"",0), -- not sniffed
+(@CGUID+27,21303,552,0,0,3,1,0,1,255.173,137.844,22.3725,5.49779,86400,0,0,20283,0,0,0,0,0,"",14545),
+(@CGUID+28,21303,552,0,0,3,1,0,1,253.689,139.868,22.4121,2.30383,86400,0,0,20283,0,0,0,0,0,"",14007),
+(@CGUID+29,21303,552,0,0,3,1,0,1,253.951,155.001,22.3807,4.93928,86400,0,0,19626,0,0,0,0,0,"",14007),
+(@CGUID+30,21303,552,0,0,3,1,0,1,257.344,155.568,22.3321,4.71239,86400,0,0,19626,0,0,0,0,0,"",14007),
+(@CGUID+31,21303,552,0,0,3,1,0,1,393.459,15.9235,48.296,0.436332,86400,0,0,20283,0,0,0,0,0,"",14545),
+(@CGUID+32,21303,552,0,0,3,1,0,1,395.076,27.5835,48.296,4.41568,86400,0,0,19626,0,0,0,0,0,"",14545),
+(@CGUID+33,21303,552,0,0,3,1,0,1,392.063,24.8857,48.296,6.16101,86400,0,0,20283,0,0,0,0,0,"",14007),
+(@CGUID+34,21303,552,0,0,3,1,0,1,397.071,25.3331,48.296,0.523599,86400,0,0,19626,0,0,0,0,0,"",14007),
+(@CGUID+35,21303,552,0,0,3,1,0,1,392.004,18.3857,48.296,1.48353,86400,0,0,20283,0,0,0,0,0,"",0),
+(@CGUID+36,21304,552,0,0,3,1,0,1,197.955,-86.8133,-10.0174,5.8294,86400,0,0,20283,0,0,0,0,0,"",14007),
+(@CGUID+37,21304,552,0,0,3,1,0,1,206.342,-98.2784,-10.0262,2.6529,86400,0,0,19626,0,0,0,0,0,"",14007),
+(@CGUID+38,21304,552,0,0,3,1,0,1,213.626,-161.424,-10.0346,2.74017,86400,0,0,19626,0,0,0,0,0,"",14007),
+(@CGUID+39,21304,552,0,0,3,1,0,1,210.114,-161.992,-10.0359,6.12611,86400,0,0,19626,0,0,0,0,0,"",14007),
+(@CGUID+40,21304,552,0,0,3,1,0,1,226.184,-162.096,-10.0352,0.349066,86400,0,0,19626,0,0,0,0,0,"",14545),
+(@CGUID+41,21304,552,0,0,3,1,0,1,264.271,-191.28,-10.0219,5.61996,86400,0,0,20283,0,0,0,0,0,"",14007),
+(@CGUID+42,21304,552,0,0,3,1,0,1,275.086,-192.666,-10.0268,3.01942,86400,0,0,19626,0,0,0,0,0,"",14007),
+(@CGUID+43,21304,552,0,0,3,1,0,1,245.982,-194.617,-10.0217,0.872665,86400,0,0,20283,0,0,0,0,0,"",0),
+(@CGUID+44,21304,552,0,0,3,1,0,1,232.754,-198.125,-10.023,5.61996,86400,0,0,20283,0,0,0,0,0,"",0),
+(@CGUID+45,21304,552,0,0,3,1,0,1,261.949,-49.208,22.4534,2.63545,86400,0,0,19626,0,0,0,0,0,"",14007),
+(@CGUID+46,21304,552,0,0,3,1,0,1,270.819,-45.4794,22.4534,4.46804,86400,0,0,20283,0,0,0,0,0,"",14007),
+(@CGUID+47,21304,552,0,0,3,1,0,1,263.595,-43.7782,22.4562,2.58309,86400,0,0,20283,0,0,0,0,0,"",14545),
+(@CGUID+48,21304,552,0,0,3,1,0,1,272.501,-40.1927,22.509,2.9147,86400,0,0,20283,0,0,0,0,0,"",0),
+(@CGUID+49,21304,552,0,0,3,1,0,1,270.767,-66.623,22.4534,5.74213,86400,0,0,19626,0,0,0,0,0,"",14545),
+(@CGUID+50,21304,552,0,0,3,1,0,1,262.56,-65.5981,22.4534,1.50098,86400,0,0,20283,0,0,0,0,0,"",14007),
+(@CGUID+51,21304,552,0,0,3,1,0,1,273.438,-64.07,22.4534,22.4534,86400,0,0,20283,0,0,0,0,0,"",0),
+(@CGUID+52,21304,552,0,0,3,1,0,1,311.119,-5.50369,22.5245,1.5708,86400,0,0,19626,0,0,0,0,0,"",14007),
+(@CGUID+53,21304,552,0,0,3,1,0,1,312.929,-7.19062,22.5245,4.03171,86400,0,0,19626,0,0,0,0,0,"",14007),
+(@CGUID+54,21304,552,0,0,3,1,0,1,291.632,70.5809,22.5269,2.00713,86400,0,0,20283,0,0,0,0,0,"",14007),
+(@CGUID+55,21304,552,0,0,3,1,0,1,293.885,70.9368,22.5262,1.55334,86400,0,0,20283,0,0,0,0,0,"",14007),
+(@CGUID+56,21304,552,0,0,3,1,0,1,285.416,127.127,22.2951,4.69494,86400,0,0,20283,0,0,0,0,0,"",14545),
+(@CGUID+57,21304,552,0,0,3,1,0,1,283.728,130.245,22.3065,0.575959,86400,0,0,20283,0,0,0,0,0,"",14007),
+(@CGUID+58,21304,552,0,0,3,1,0,1,291.801,158.914,22.3234,5.96903,86400,0,0,20283,0,0,0,0,0,"",14007),
+(@CGUID+59,21304,552,0,0,3,1,0,1,298.848,151.748,22.3105,5.70723,86400,0,0,20283,0,0,0,0,0,"",14545),
+(@CGUID+60,21304,552,0,0,3,1,0,1,306.976,141.112,22.2286,3.0285,86400,0,0,20283,0,0,0,0,0,"",0),
+(@CGUID+61,21304,552,0,0,3,1,0,1,311.196,125.847,22.337,1.64061,86400,0,0,19626,0,0,0,0,0,"",14007),
+(@CGUID+62,21304,552,0,0,3,1,0,1,279.572998,134.337875,22.223705,4.94015,86400,0,0,20283,0,0,0,0,0,"",0), -- not sniffed
+(@CGUID+63,21304,552,0,0,3,1,0,1,255.173,137.844,22.3725,5.49779,86400,0,0,20283,0,0,0,0,0,"",14545),
+(@CGUID+64,21304,552,0,0,3,1,0,1,253.689,139.868,22.4121,2.30383,86400,0,0,20283,0,0,0,0,0,"",14007),
+(@CGUID+65,21304,552,0,0,3,1,0,1,253.951,155.001,22.3807,4.93928,86400,0,0,19626,0,0,0,0,0,"",14007),
+(@CGUID+66,21304,552,0,0,3,1,0,1,257.344,155.568,22.3321,4.71239,86400,0,0,19626,0,0,0,0,0,"",14007),
+(@CGUID+67,21304,552,0,0,3,1,0,1,393.459,15.9235,48.296,0.436332,86400,0,0,20283,0,0,0,0,0,"",14545),
+(@CGUID+68,21304,552,0,0,3,1,0,1,395.076,27.5835,48.296,4.41568,86400,0,0,19626,0,0,0,0,0,"",14545),
+(@CGUID+69,21304,552,0,0,3,1,0,1,392.063,24.8857,48.296,6.16101,86400,0,0,20283,0,0,0,0,0,"",14007),
+(@CGUID+70,21304,552,0,0,3,1,0,1,397.071,25.3331,48.296,0.523599,86400,0,0,19626,0,0,0,0,0,"",14007),
+(@CGUID+71,21304,552,0,0,3,1,0,1,392.004,18.3857,48.296,1.48353,86400,0,0,20283,0,0,0,0,0,"",0);
+
+DELETE FROM `pool_template` WHERE `entry` BETWEEN @POOL+00 AND @POOL+42;
+INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES
+(@POOL+00, 1, "The Arcatraz - Defender Corpse / Warder Corpse"),
+(@POOL+01, 1, "The Arcatraz - Defender Corpse / Warder Corpse"),
+(@POOL+02, 1, "The Arcatraz - Defender Corpse / Warder Corpse"),
+(@POOL+03, 1, "The Arcatraz - Defender Corpse / Warder Corpse"),
+(@POOL+04, 1, "The Arcatraz - Defender Corpse / Warder Corpse"),
+(@POOL+05, 1, "The Arcatraz - Defender Corpse / Warder Corpse"),
+(@POOL+06, 1, "The Arcatraz - Defender Corpse / Warder Corpse"),
+(@POOL+07, 1, "The Arcatraz - Defender Corpse / Warder Corpse"),
+(@POOL+08, 1, "The Arcatraz - Defender Corpse / Warder Corpse"),
+(@POOL+09, 1, "The Arcatraz - Defender Corpse / Warder Corpse"),
+(@POOL+10, 1, "The Arcatraz - Defender Corpse / Warder Corpse"),
+(@POOL+11, 1, "The Arcatraz - Defender Corpse / Warder Corpse"),
+(@POOL+12, 1, "The Arcatraz - Defender Corpse / Warder Corpse"),
+(@POOL+13, 1, "The Arcatraz - Defender Corpse / Warder Corpse"),
+(@POOL+14, 1, "The Arcatraz - Defender Corpse / Warder Corpse"),
+(@POOL+15, 1, "The Arcatraz - Defender Corpse / Warder Corpse"),
+(@POOL+16, 1, "The Arcatraz - Defender Corpse / Warder Corpse"),
+(@POOL+17, 1, "The Arcatraz - Defender Corpse / Warder Corpse"),
+(@POOL+18, 1, "The Arcatraz - Defender Corpse / Warder Corpse"),
+(@POOL+19, 1, "The Arcatraz - Defender Corpse / Warder Corpse"),
+(@POOL+20, 1, "The Arcatraz - Defender Corpse / Warder Corpse"),
+(@POOL+21, 1, "The Arcatraz - Defender Corpse / Warder Corpse"),
+(@POOL+22, 1, "The Arcatraz - Defender Corpse / Warder Corpse"),
+(@POOL+23, 1, "The Arcatraz - Defender Corpse / Warder Corpse"),
+(@POOL+24, 1, "The Arcatraz - Defender Corpse / Warder Corpse"),
+(@POOL+25, 1, "The Arcatraz - Defender Corpse / Warder Corpse"),
+(@POOL+26, 1, "The Arcatraz - Defender Corpse / Warder Corpse"),
+(@POOL+27, 1, "The Arcatraz - Defender Corpse / Warder Corpse"),
+(@POOL+28, 1, "The Arcatraz - Defender Corpse / Warder Corpse"),
+(@POOL+29, 1, "The Arcatraz - Defender Corpse / Warder Corpse"),
+(@POOL+30, 1, "The Arcatraz - Defender Corpse / Warder Corpse"),
+(@POOL+31, 1, "The Arcatraz - Defender Corpse / Warder Corpse"),
+(@POOL+32, 1, "The Arcatraz - Defender Corpse / Warder Corpse"),
+(@POOL+33, 1, "The Arcatraz - Defender Corpse / Warder Corpse"),
+(@POOL+34, 1, "The Arcatraz - Defender Corpse / Warder Corpse"),
+(@POOL+35, 1, "The Arcatraz - Defender Corpse / Warder Corpse"),
+(@POOL+36, 1, "The Arcatraz - Defender Corpse & Warder Corpse - Master - Group 1"),
+(@POOL+37, 1, "The Arcatraz - Defender Corpse & Warder Corpse - Master - Group 2"),
+(@POOL+38, 1, "The Arcatraz - Defender Corpse & Warder Corpse - Master - Group 3"),
+(@POOL+39, 1, "The Arcatraz - Defender Corpse & Warder Corpse - Master - Group 4"),
+(@POOL+40, 2, "The Arcatraz - Defender Corpse & Warder Corpse - Master - Group 5"),
+(@POOL+41, 1, "The Arcatraz - Defender Corpse & Warder Corpse - Master - Group 6"),
+(@POOL+42, 2, "The Arcatraz - Defender Corpse & Warder Corpse - Master - Group 7");
+
+DELETE FROM `pool_members` WHERE `type` = 0 AND `poolSpawnId` BETWEEN @POOL+00 AND @POOL+35;
+DELETE FROM `pool_members` WHERE `type` = 2 AND `poolSpawnId` BETWEEN @POOL+36 AND @POOL+42;
+INSERT INTO `pool_members` (`type`, `spawnId`, `poolSpawnId`, `chance`, `description`) VALUES
+(0, @CGUID+00, @POOL+00, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Defender Corpse"),
+(0, @CGUID+01, @POOL+01, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Defender Corpse"),
+(0, @CGUID+02, @POOL+02, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Defender Corpse - Group 1"),
+(0, @CGUID+03, @POOL+03, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Defender Corpse - Group 1"),
+(0, @CGUID+04, @POOL+04, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Defender Corpse - Group 1"),
+(0, @CGUID+05, @POOL+05, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Defender Corpse - Group 2"),
+(0, @CGUID+06, @POOL+06, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Defender Corpse - Group 2"),
+(0, @CGUID+07, @POOL+07, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Defender Corpse - Group 2"),
+(0, @CGUID+08, @POOL+08, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Defender Corpse - Group 2"),
+(0, @CGUID+09, @POOL+09, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Defender Corpse - Group 3"),
+(0, @CGUID+10, @POOL+10, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Defender Corpse - Group 3"),
+(0, @CGUID+11, @POOL+11, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Defender Corpse - Group 3"),
+(0, @CGUID+12, @POOL+12, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Defender Corpse - Group 3"),
+(0, @CGUID+13, @POOL+13, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Defender Corpse - Group 4"),
+(0, @CGUID+14, @POOL+14, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Defender Corpse - Group 4"),
+(0, @CGUID+15, @POOL+15, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Defender Corpse - Group 4"),
+(0, @CGUID+16, @POOL+16, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Defender Corpse"),
+(0, @CGUID+17, @POOL+17, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Defender Corpse"),
+(0, @CGUID+18, @POOL+18, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Defender Corpse"),
+(0, @CGUID+19, @POOL+19, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Defender Corpse"),
+(0, @CGUID+20, @POOL+20, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Defender Corpse - Group 5"),
+(0, @CGUID+21, @POOL+21, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Defender Corpse - Group 5"),
+(0, @CGUID+22, @POOL+22, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Defender Corpse - Group 5"),
+(0, @CGUID+23, @POOL+23, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Defender Corpse - Group 5"),
+(0, @CGUID+24, @POOL+24, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Defender Corpse - Group 5"),
+(0, @CGUID+25, @POOL+25, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Defender Corpse - Group 5"),
+(0, @CGUID+26, @POOL+26, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Defender Corpse - Group 5"),
+(0, @CGUID+27, @POOL+27, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Defender Corpse - Group 6"),
+(0, @CGUID+28, @POOL+28, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Defender Corpse - Group 6"),
+(0, @CGUID+29, @POOL+29, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Defender Corpse"),
+(0, @CGUID+30, @POOL+30, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Defender Corpse"),
+(0, @CGUID+31, @POOL+31, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Defender Corpse - Group 7"),
+(0, @CGUID+32, @POOL+32, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Defender Corpse - Group 7"),
+(0, @CGUID+33, @POOL+33, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Defender Corpse - Group 7"),
+(0, @CGUID+34, @POOL+34, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Defender Corpse - Group 7"),
+(0, @CGUID+35, @POOL+35, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Defender Corpse - Group 7"),
+(0, @CGUID+36, @POOL+00, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Warder Corpse"),
+(0, @CGUID+37, @POOL+01, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Warder Corpse"),
+(0, @CGUID+38, @POOL+02, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Warder Corpse - Group 1"),
+(0, @CGUID+39, @POOL+03, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Warder Corpse - Group 1"),
+(0, @CGUID+40, @POOL+04, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Warder Corpse - Group 1"),
+(0, @CGUID+41, @POOL+05, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Warder Corpse - Group 2"),
+(0, @CGUID+42, @POOL+06, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Warder Corpse - Group 2"),
+(0, @CGUID+43, @POOL+07, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Warder Corpse - Group 2"),
+(0, @CGUID+44, @POOL+08, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Warder Corpse - Group 2"),
+(0, @CGUID+45, @POOL+09, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Warder Corpse - Group 3"),
+(0, @CGUID+46, @POOL+10, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Warder Corpse - Group 3"),
+(0, @CGUID+47, @POOL+11, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Warder Corpse - Group 3"),
+(0, @CGUID+48, @POOL+12, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Warder Corpse - Group 3"),
+(0, @CGUID+49, @POOL+13, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Warder Corpse - Group 4"),
+(0, @CGUID+50, @POOL+14, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Warder Corpse - Group 4"),
+(0, @CGUID+51, @POOL+15, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Warder Corpse - Group 4"),
+(0, @CGUID+52, @POOL+16, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Warder Corpse"),
+(0, @CGUID+53, @POOL+17, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Warder Corpse"),
+(0, @CGUID+54, @POOL+18, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Warder Corpse"),
+(0, @CGUID+55, @POOL+19, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Warder Corpse"),
+(0, @CGUID+56, @POOL+20, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Warder Corpse - Group 5"),
+(0, @CGUID+57, @POOL+21, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Warder Corpse - Group 5"),
+(0, @CGUID+58, @POOL+22, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Warder Corpse - Group 5"),
+(0, @CGUID+59, @POOL+23, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Warder Corpse - Group 5"),
+(0, @CGUID+60, @POOL+24, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Warder Corpse - Group 5"),
+(0, @CGUID+61, @POOL+25, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Warder Corpse - Group 5"),
+(0, @CGUID+62, @POOL+26, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Warder Corpse - Group 5"),
+(0, @CGUID+63, @POOL+27, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Warder Corpse - Group 6"),
+(0, @CGUID+64, @POOL+28, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Warder Corpse - Group 6"),
+(0, @CGUID+65, @POOL+29, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Warder Corpse"),
+(0, @CGUID+66, @POOL+30, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Warder Corpse"),
+(0, @CGUID+67, @POOL+31, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Warder Corpse - Group 7"),
+(0, @CGUID+68, @POOL+32, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Warder Corpse - Group 7"),
+(0, @CGUID+69, @POOL+33, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Warder Corpse - Group 7"),
+(0, @CGUID+70, @POOL+34, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Warder Corpse - Group 7"),
+(0, @CGUID+71, @POOL+35, 0, "The Arcatraz - Defender Corpse / Warder Corpse - Warder Corpse - Group 7"),
+(2, @POOL+02, @POOL+36, 0, "The Arcatraz - Defender Corpse & Warder Corpse - Master - Group 1"),
+(2, @POOL+03, @POOL+36, 0, "The Arcatraz - Defender Corpse & Warder Corpse - Master - Group 1"),
+(2, @POOL+04, @POOL+36, 0, "The Arcatraz - Defender Corpse & Warder Corpse - Master - Group 1"),
+(2, @POOL+05, @POOL+37, 0, "The Arcatraz - Defender Corpse & Warder Corpse - Master - Group 2"),
+(2, @POOL+06, @POOL+37, 0, "The Arcatraz - Defender Corpse & Warder Corpse - Master - Group 2"),
+(2, @POOL+07, @POOL+37, 0, "The Arcatraz - Defender Corpse & Warder Corpse - Master - Group 2"),
+(2, @POOL+08, @POOL+37, 0, "The Arcatraz - Defender Corpse & Warder Corpse - Master - Group 2"),
+(2, @POOL+09, @POOL+38, 0, "The Arcatraz - Defender Corpse & Warder Corpse - Master - Group 3"),
+(2, @POOL+10, @POOL+38, 0, "The Arcatraz - Defender Corpse & Warder Corpse - Master - Group 3"),
+(2, @POOL+11, @POOL+38, 0, "The Arcatraz - Defender Corpse & Warder Corpse - Master - Group 3"),
+(2, @POOL+12, @POOL+38, 0, "The Arcatraz - Defender Corpse & Warder Corpse - Master - Group 3"),
+(2, @POOL+13, @POOL+39, 0, "The Arcatraz - Defender Corpse & Warder Corpse - Master - Group 4"),
+(2, @POOL+14, @POOL+39, 0, "The Arcatraz - Defender Corpse & Warder Corpse - Master - Group 4"),
+(2, @POOL+15, @POOL+39, 0, "The Arcatraz - Defender Corpse & Warder Corpse - Master - Group 4"),
+(2, @POOL+20, @POOL+40, 0, "The Arcatraz - Defender Corpse & Warder Corpse - Master - Group 5"),
+(2, @POOL+21, @POOL+40, 0, "The Arcatraz - Defender Corpse & Warder Corpse - Master - Group 5"),
+(2, @POOL+22, @POOL+40, 0, "The Arcatraz - Defender Corpse & Warder Corpse - Master - Group 5"),
+(2, @POOL+23, @POOL+40, 0, "The Arcatraz - Defender Corpse & Warder Corpse - Master - Group 5"),
+(2, @POOL+24, @POOL+40, 0, "The Arcatraz - Defender Corpse & Warder Corpse - Master - Group 5"),
+(2, @POOL+25, @POOL+40, 0, "The Arcatraz - Defender Corpse & Warder Corpse - Master - Group 5"),
+(2, @POOL+26, @POOL+40, 0, "The Arcatraz - Defender Corpse & Warder Corpse - Master - Group 5"),
+(2, @POOL+27, @POOL+41, 0, "The Arcatraz - Defender Corpse & Warder Corpse - Master - Group 6"),
+(2, @POOL+28, @POOL+41, 0, "The Arcatraz - Defender Corpse & Warder Corpse - Master - Group 6"),
+(2, @POOL+31, @POOL+42, 0, "The Arcatraz - Defender Corpse & Warder Corpse - Master - Group 7"),
+(2, @POOL+32, @POOL+42, 0, "The Arcatraz - Defender Corpse & Warder Corpse - Master - Group 7"),
+(2, @POOL+33, @POOL+42, 0, "The Arcatraz - Defender Corpse & Warder Corpse - Master - Group 7"),
+(2, @POOL+34, @POOL+42, 0, "The Arcatraz - Defender Corpse & Warder Corpse - Master - Group 7"),
+(2, @POOL+35, @POOL+42, 0, "The Arcatraz - Defender Corpse & Warder Corpse - Master - Group 7");