-- Add missing Battered Chest ID: 106318, one from Mangos DB, with pooling in Durotar
SET @POOLID := XXXXX; -- 11 required
SET @OGUID := XXXXX; -- 25 required
DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+24;
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `PhaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
(@OGUID+0, 106318, 1, 14, 366, 1, 1, -1039.701416015625, -4589.80859375, 25.82188606262207031, 0.209439441561698913, 0, 0, 0.104528427124023437, 0.994521915912628173, 360, 255, 0, 42083), -- Kolkar Crag
(@OGUID+1, 106318, 1, 14, 366, 1, 1, -973.9110107421875, -4427.43603515625, 30.01559829711914062, 4.642575740814208984, 0, 0, -0.731353759765625, 0.681998312473297119, 360, 255, 0, 41812), -- Kolkar Crag
(@OGUID+2, 106318, 1, 14, 368, 1, 1, -1128.2391357421875, -5508.416015625, 6.319083213806152343, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 360, 255, 0, 41812), -- Echo Isles
(@OGUID+3, 106318, 1, 14, 368, 1, 1, -709.20294189453125, -5577.171875, 26.84698677062988281, 1.867502212524414062, 0, 0, 0.803856849670410156, 0.594822824001312255, 360, 255, 0, 41812), -- Echo Isles
(@OGUID+4, 106318, 1, 14, 370, 1, 1, 960.04644775390625, -4777.72705078125, 22.26800155639648437, 2.024578809738159179, 0, 0, 0.848047256469726562, 0.529920578002929687, 360, 255, 0, 41812), -- Drygulch Ravine
(@OGUID+5, 106318, 1, 14, 370, 1, 1, 1027.068603515625, -4821.189453125, 15.20469379425048828, 2.478367090225219726, 0, 0, 0.94551849365234375, 0.325568377971649169, 360, 255, 1, 41812), -- Drygulch Ravine
(@OGUID+6, 106318, 1, 14, 371, 1, 1, 811.54296875, -4806.70947265625, 11.03552532196044921, 0.733038187026977539, 0, 0, 0.358367919921875, 0.933580458164215087, 360, 255, 0, 41812), -- Drygulch Ravine
(@OGUID+7, 106318, 1, 14, 410, 1, 1, 877.26470947265625, -4738.90380859375, 30.01175689697265625, 4.101525306701660156, 0, 0, -0.88701057434082031, 0.461749136447906494, 360, 255, 1, 41812), -- Dustwind Cave
(@OGUID+8, 106318, 1, 14, 371, 1, 1, 908.54669189453125, -4754.279296875, 18.70039176940917968, 2.321286916732788085, 0, 0, 0.917059898376464843, 0.398749500513076782, 360, 255, 0, 41812), -- Dustwind Cave
(@OGUID+9, 106318, 1, 14, 372, 1, 1, -238.197052001953125, -5109.99609375, 41.3467559814453125, 2.949595451354980468, 0, 0, 0.995395660400390625, 0.095851235091686248, 360, 255, 1, 41812), -- Tiragarde Keep
(@OGUID+10, 106318, 1, 14, 372, 1, 1, -264.111328125, -5131.67236328125, 24.34155082702636718, 2.321286916732788085, 0, 0, 0.917059898376464843, 0.398749500513076782, 360, 255, 0, 41812), -- Tiragarde Keep
(@OGUID+11, 106318, 1, 14, 373, 1, 1, -63.7776679992675781, -5372.091796875, -17.813446044921875, 3.892086982727050781, 0, 0, -0.93041706085205078, 0.366502493619918823, 360, 255, 0, 41812), -- Scuttle Coast
(@OGUID+12, 106318, 1, 14, 373, 1, 1, 208.7660064697265625, -5234.958984375, -8.56636810302734375, 5.969027042388916015, 0, 0, -0.1564340591430664, 0.987688362598419189, 360, 255, 0, 41812), -- Scuttle Coast
(@OGUID+13, 106318, 1, 14, 373, 1, 1, 28.78168487548828125, -5349.08056640625, -14.7248620986938476, 3.94444584846496582, 0, 0, -0.92050457000732421, 0.3907318115234375, 360, 255, 0, 41812), -- Scuttle Coast
(@OGUID+14, 106318, 1, 14, 373, 1, 1, -327.538848876953125, -5266.5263671875, -8.39003658294677734, 0.750490784645080566, 0, 0, 0.3665008544921875, 0.93041771650314331, 360, 255, 0, 41812), -- Scuttle Coast
(@OGUID+15, 106318, 1, 14, 373, 1, 1, 6.732748031616210937, -5228.02099609375, -13.3655195236206054, 1.308995485305786132, 0, 0, 0.608760833740234375, 0.793353796005249023, 360, 255, 0, 41812), -- Scuttle Coast
(@OGUID+16, 106318, 1, 14, 373, 1, 1, 323.34527587890625, -5261.724609375, -17.6113548278808593, 0.15707901120185852, 0, 0, 0.078458786010742187, 0.996917366981506347, 360, 255, 1, 41812), -- Scuttle Coast
(@OGUID+17, 106318, 1, 14, 410, 1, 1, 896.12188720703125, -4646.70263671875, 18.36391639709472656, 2.199114561080932617, 0, 0, 0.8910064697265625, 0.453990638256072998, 360, 255, 0, 41812), -- Razorwind Canyon
(@OGUID+18, 106318, 1, 14, 410, 1, 1, 633.84722900390625, -4487.70068359375, 11.84936237335205078, 0.680676698684692382, 0, 0, 0.333806037902832031, 0.942641794681549072, 360, 255, 0, 41812), -- Razorwind Canyon
(@OGUID+19, 106318, 1, 14, 816, 1, 1, 19.87717056274414062, -4274.1025390625, 72.57794952392578125, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 360, 255, 0, 41812); -- Razormane Grounds
(@OGUID+20, 106318, 1, 14, 816, 1, 1, 51.57964324951171875, -4479.0810546875, 50.4658203125, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 360, 255, 0, 41812), -- Razormane Grounds
(@OGUID+21, 106318, 1, 14, 817, 1, 1, 1546.701416015625, -4750.49853515625, 14.49754810333251953, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 360, 255, 0, 41812), -- Skull Rock
(@OGUID+22, 106318, 1, 14, 817, 1, 1, 1488.4793701171875, -4752.35791015625, 21.02687454223632812, 1.343901276588439941, 0, 0, 0.622513771057128906, 0.78260880708694458, 360, 255, 0, 41812), -- Skull Rock
(@OGUID+23, 106318, 1, 14, 0, 1, 1, 555.00738525390625, -4266.4765625, 16.51405715942382812, 4.241150379180908203, 0, 0, -0.85264015197753906, 0.522498607635498046, 360, 255, 1, 41812), -- Durotar 2
-- From Mangos DB
(@OGUID+24, 106318, 1, 14, 817, 1, 1, 1485.68, -4739.94, -4.47406, 0.104719, 0, 0, 0.0523357, 0.99863, 360, 255, 0, 41812); -- Skull Rock

-- Update existing spawns to match new ones.
UPDATE `gameobject` SET `spawntimesecs`=360, `animprogress`=225, `state`=1 WHERE `guid` IN
(12500,85755,85753,12637,85769,85748,85758,12503,12603,85815,85760,85744,12547,85739,12600,85742,12611,
85741,12546,85829,12396,85754,85743,12552,85750,12499,85749,85740,12548,85757,85881,85768,12504);

DELETE FROM `pool_template` WHERE `entry` BETWEEN @POOLID AND @POOLID+10;
INSERT INTO `pool_template` (`entry`,`max_limit`,`description`) VALUES
(@POOLID,1,'Battered Chest (106318), Durotar, Chest Pool Skull Rock'),
(@POOLID+1,1,'Battered Chest (106318), Durotar, Chest Pool Drygulch Ravine'),
(@POOLID+2,1,'Battered Chest (106318), Durotar, Chest Pool Dustwind Cave'),
(@POOLID+3,1,'Battered Chest (106318), Durotar, Chest Pool Razorwind Canyon'),
(@POOLID+4,1,'Battered Chest (106318), Durotar, Chest Pool Thunder Ridge'),
(@POOLID+5,1,'Battered Chest (106318), Durotar, Chest Pool Scuttle Coast'),
(@POOLID+6,1,'Battered Chest (106318), Durotar, Chest Pool Tiragarde Keep'),
(@POOLID+7,1,'Battered Chest (106318), Durotar, Chest Pool Echo Isles'),
(@POOLID+8,1,'Battered Chest (106318), Durotar, Chest Pool Kolkar Crag'),
(@POOLID+9,1,'Battered Chest (106318), Durotar, Chest Pool Razormane Grounds North'),
(@POOLID+10,1,'Battered Chest (106318), Durotar, Chest Pool Razormane Grounds South');

DELETE FROM `pool_members` WHERE `poolSpawnId` BETWEEN @POOLID AND @POOLID+10;
INSERT INTO `pool_members` (`type`,`spawnId`,`poolSpawnId`,`chance`,`description`) Values
(1,12548,@POOLID,0,'Battered Chest (106318), Skull Rock'),
(1,85757,@POOLID,0,'Battered Chest (106318), Skull Rock'),
(1,85881,@POOLID,0,'Battered Chest (106318), Skull Rock'),
(1,85768,@POOLID,0,'Battered Chest (106318), Skull Rock'),
(1,@OGUID+21,@POOLID,0,'Battered Chest (106318), Skull Rock'),
(1,@OGUID+22,@POOLID,0,'Battered Chest (106318), Skull Rock'),
(1,@OGUID+24,@POOLID,0,'Battered Chest (106318), Skull Rock'),
-- May break into 2
(1,12603,@POOLID+1,0,'Battered Chest (106318), Drygulch Ravine'),
(1,85815,@POOLID+1,0,'Battered Chest (106318), Drygulch Ravine'),
(1,85760,@POOLID+1,0,'Battered Chest (106318), Drygulch Ravine'),
(1,85744,@POOLID+1,0,'Battered Chest (106318), Drygulch Ravine'),
(1,12547,@POOLID+1,0,'Battered Chest (106318), Drygulch Ravine'),
(1,@OGUID+4,@POOLID+1,0,'Battered Chest (106318), Drygulch Ravine'),
(1,@OGUID+5,@POOLID+1,0,'Battered Chest (106318), Drygulch Ravine'),
(1,@OGUID+6,@POOLID+1,0,'Battered Chest (106318), Drygulch Ravine'),

(1,85739,@POOLID+2,0,'Battered Chest (106318), Dustwind Cave'),
(1,12600,@POOLID+2,0,'Battered Chest (106318), Dustwind Cave'),
(1,@OGUID+7,@POOLID+2,0,'Battered Chest (106318), Dustwind Cave'),
(1,@OGUID+8,@POOLID+2,0,'Battered Chest (106318), Dustwind Cave'),

(1,85829,@POOLID+3,0,'Battered Chest (106318), Razorwind Canyon'),
(1,12396,@POOLID+3,0,'Battered Chest (106318), Razorwind Canyon'),
(1,@OGUID+17,@POOLID+3,0,'Battered Chest (106318), Razorwind Canyon'),
(1,@OGUID+18,@POOLID+3,0,'Battered Chest (106318), Razorwind Canyon'),

(1,85769,@POOLID+4,0,'Battered Chest (106318), Thunder Ridge'),
(1,85748,@POOLID+4,0,'Battered Chest (106318), Thunder Ridge'),
(1,85758,@POOLID+4,0,'Battered Chest (106318), Thunder Ridge'),
(1,12503,@POOLID+4,0,'Battered Chest (106318), Thunder Ridge'),
-- May break into 2
(1,85741,@POOLID+5,0,'Battered Chest (106318), Scuttle Coast'),
(1,12546,@POOLID+5,0,'Battered Chest (106318), Scuttle Coast'),
(1,@OGUID+11,@POOLID+5,0,'Battered Chest (106318), Scuttle Coast'),
(1,@OGUID+12,@POOLID+5,0,'Battered Chest (106318), Scuttle Coast'),
(1,@OGUID+13,@POOLID+5,0,'Battered Chest (106318), Scuttle Coast'),
(1,@OGUID+14,@POOLID+5,0,'Battered Chest (106318), Scuttle Coast'),
(1,@OGUID+15,@POOLID+5,0,'Battered Chest (106318), Scuttle Coast'),
(1,@OGUID+16,@POOLID+5,0,'Battered Chest (106318), Scuttle Coast'),

(1,85742,@POOLID+6,0,'Battered Chest (106318), Tiragarde Keep'),
(1,12611,@POOLID+6,0,'Battered Chest (106318), Tiragarde Keep'),
(1,@OGUID+9,@POOLID+6,0,'Battered Chest (106318), Tiragarde Keep'),
(1,@OGUID+10,@POOLID+6,0,'Battered Chest (106318), Tiragarde Keep'),

(1,85755,@POOLID+7,0,'Battered Chest (106318), Echo Isles'),
(1,85753,@POOLID+7,0,'Battered Chest (106318), Echo Isles'),
(1,12637,@POOLID+7,0,'Battered Chest (106318), Echo Isles'),
(1,@OGUID+2,@POOLID+7,0,'Battered Chest (106318), Echo Isles'),
(1,@OGUID+3,@POOLID+7,0,'Battered Chest (106318), Echo Isles'),

(1,12500,@POOLID+8,0,'Battered Chest (106318), Kolkar Crag'),
(1,@OGUID,@POOLID+8,0,'Battered Chest (106318), Kolkar Crag'),
(1,@OGUID+1,@POOLID+8,0,'Battered Chest (106318), Kolkar Crag'),
(1,12504,@POOLID+8,0,'Battered Chest (106318), Durotar'),

(1,85754,@POOLID+9,0,'Battered Chest (106318), Razormane Grounds North'),
(1,85743,@POOLID+9,0,'Battered Chest (106318), Razormane Grounds North'),
(1,12552,@POOLID+9,0,'Battered Chest (106318), Razormane Grounds North'),
(1,85754,@POOLID+9,0,'Battered Chest (106318), Razormane Grounds North'),
(1,@OGUID+23,@POOLID+9,0,'Battered Chest (106318), Razormane Grounds North'),

(1,85750,@POOLID+10,0,'Battered Chest (106318), Razormane Grounds South'),
(1,12499,@POOLID+10,0,'Battered Chest (106318), Razormane Grounds South'),
(1,85749,@POOLID+10,0,'Battered Chest (106318), Razormane Grounds South'),
(1,85740,@POOLID+10,0,'Battered Chest (106318), Razormane Grounds South'),
(1,@OGUID+19,@POOLID+10,0,'Battered Chest (106318), Razormane Grounds South'),
(1,@OGUID+20,@POOLID+10,0,'Battered Chest (106318), Razormane Grounds South');