DB/Gameobject Add missing Battered Chest ID: 106318 to Mulgore with pooling

closes #30301 by malcrom

1 files changed, 91 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2024_10_20_03_world.sql b/sql/updates/world/3.3.5/2024_10_20_03_world.sql
new file mode 100644
index 00000000000..309a5d3c4b6
--- /dev/null
+++ b/sql/updates/world/3.3.5/2024_10_20_03_world.sql
@@ -0,0 +1,91 @@
+-- Add 24 missing Battered Chest ID: 106318 with pooling in Mulgore
+SET @OGUID := 21965; -- 24 required
+SET @POOLID := 788; -- 9 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, 106318, 1, 215, 215, 1, 1, -631.74151611328125, 111.4527664184570312, 17.11371040344238281, 1.082102894783020019, 0, 0, 0.51503753662109375, 0.857167601585388183, 360, 255, 1, 46902), -- Mulgore North
+(@OGUID+1, 106318, 1, 215, 215, 1, 1, -546.70684814453125, 72.729278564453125, 52.28420257568359375, 0.802850961685180664, 0, 0, 0.390730857849121093, 0.920504987239837646, 360, 255, 1, 44171), -- Mulgore North
+(@OGUID+2, 106318, 1, 215, 215, 1, 1, -657.78033447265625, 193.8148956298828125, 46.80418014526367187, 0.506144583225250244, 0, 0, 0.250379562377929687, 0.968147754669189453, 360, 255, 1, 44171), -- Mulgore North
+(@OGUID+3, 106318, 1, 215, 820, 1, 1, -824.10137939453125, -780.58660888671875, -2.71320295333862304, 4.276057243347167968, 0, 0, -0.84339141845703125, 0.537299633026123046, 360, 255, 1, 44171), -- The Golden Plains
+(@OGUID+4, 106318, 1, 215, 819, 1, 1, -591.3314208984375, -681.55999755859375, 27.44317245483398437, 5.427974700927734375, 0, 0, -0.41469287872314453, 0.909961462020874023, 360, 255, 1, 46368), -- Windfiry Ridge "Near The Golden Plains"
+(@OGUID+5, 106318, 1, 215, 819, 1, 1, -665.03692626953125, -787.12469482421875, 43.61326980590820312, 1.431168079376220703, 0, 0, 0.656058311462402343, 0.754710197448730468, 360, 255, 1, 44171), -- Windfiry Ridge "Near The Golden Plains"
+(@OGUID+6, 106318, 1, 215, 0, 1, 1, -1075.2293701171875, 542.53753662109375, 49.8483428955078125, 4.031712055206298828, 0, 0, -0.90258502960205078, 0.430511653423309326, 360, 255, 1, 44171), -- Mulgore West
+(@OGUID+7, 106318, 1, 215, 215, 1, 1, -998.08270263671875, 589.4744873046875, 81.93946075439453125, 2.530723094940185546, 0, 0, 0.953716278076171875, 0.300707906484603881, 360, 255, 1, 44171), -- Mulgore West
+(@OGUID+8, 106318, 1, 215, 404, 1, 1, -1893.6497802734375, 353.875457763671875, 107.3605728149414062, 5.672322273254394531, 0, 0, -0.3007049560546875, 0.953717231750488281, 360, 255, 1, 44171), -- Bael'dun Digsite
+(@OGUID+9, 106318, 1, 215, 360, 1, 1, -1681.0875244140625, -1218.5963134765625, 127.4188613891601562, 0.453785061836242675, 0, 0, 0.224950790405273437, 0.974370121955871582, 360, 255, 1, 46368), -- Venture Company Mine
+(@OGUID+10, 106318, 1, 215, 360, 1, 1, -1585.0709228515625, -1151.2315673828125, 104.118377685546875, 0.122172988951206207, 0, 0, 0.061048507690429687, 0.998134791851043701, 360, 255, 1, 44171), -- Venture Company Mine
+(@OGUID+11, 106318, 1, 215, 360, 1, 1, -1672.001708984375, -1324.0699462890625, 132.7880859375, 1.343901276588439941, 0, 0, 0.622513771057128906, 0.78260880708694458, 360, 255, 1, 44171), -- Venture Company Mine
+(@OGUID+12, 106318, 1, 215, 360, 1, 1, -1921.726806640625, -1027.15087890625, 43.96306610107421875, 1.204277276992797851, 0, 0, 0.56640625, 0.824126183986663818, 360, 255, 1, 46902), -- Venture Company Mine "Outside"
+(@OGUID+13, 106318, 1, 215, 360, 1, 1, -1889.326416015625, -1096.98095703125, 90.32932281494140625, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 360, 255, 1, 44171), -- Venture Company Mine "Outside"
+(@OGUID+14, 106318, 1, 215, 818, 1, 1, -2388.364990234375, 444.8865966796875, 75.9410400390625, 1.151916384696960449, 0, 0, 0.544638633728027343, 0.838670849800109863, 360, 255, 1, 44171), -- Palemane Rock
+(@OGUID+15, 106318, 1, 215, 818, 1, 1, -2402.0634765625, 233.6727142333984375, 49.24333953857421875, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 360, 255, 1, 44171), -- Palemane Rock
+(@OGUID+16, 106318, 1, 215, 818, 1, 1, -2445.70751953125, 438.708526611328125, 61.7602691650390625, 0.541050612926483154, 0, 0, 0.267237663269042968, 0.96363067626953125, 360, 255, 1, 44171), -- Palemane Rock
+(@OGUID+17, 106318, 1, 215, 818, 1, 1, -2358.603271484375, 379.66888427734375, 64.85495758056640625, 3.43830275535583496, 0, 0, -0.98901557922363281, 0.147811368107795715, 360, 255, 1, 44171), -- Palemane Rock
+(@OGUID+18, 106318, 1, 215, 215, 1, 1, -2782.115478515625, -707.653564453125, 6.424570083618164062, 2.687806606292724609, 0, 0, 0.974370002746582031, 0.224951311945915222, 360, 255, 1, 46902), -- Palemane Camp
+(@OGUID+19, 106318, 1, 215, 821, 1, 1, -2716.833740234375, -1188.42822265625, 16.78433990478515625, 5.078907966613769531, 0, 0, -0.56640625, 0.824126183986663818, 360, 255, 1, 46902), -- The Rolling Plains
+(@OGUID+20, 106318, 1, 215, 821, 1, 1, -2643.494873046875, -1320.986328125, 12.12032413482666015, 0.907570242881774902, 0, 0, 0.438370704650878906, 0.898794233798980712, 360, 255, 1, 44171), -- The Rolling Plains
+(@OGUID+21, 106318, 1, 215, 821, 1, 1, -2625.284423828125, -1390.2613525390625, 24.50350379943847656, 5.724681377410888671, 0, 0, -0.27563667297363281, 0.961261868476867675, 360, 255, 1, 44171), -- The Rolling Plains
+(@OGUID+22, 106318, 1, 215, 224, 1, 1, -1931.8563232421875, -715.7557373046875, 3.48775792121887207, 6.073746204376220703, 0, 0, -0.10452842712402343, 0.994521915912628173, 360, 255, 1, 44171), -- Ravaged Caravan
+(@OGUID+23, 106318, 1, 215, 224, 1, 1, -1912.48876953125, -712.5831298828125, 3.573940992355346679, 0.174532130360603332, 0, 0, 0.087155342102050781, 0.996194720268249511, 360, 255, 1, 44171); -- Ravaged Caravan
+
+-- Update existing spawns to match new ones.
+UPDATE `gameobject` SET `spawntimesecs`=360, `animprogress`=225, `state`=1 WHERE `guid` IN
+(18442,18443,18444,18445,18446,18447,18448,18449,18450,18451,18452,18453,18454,18455,85767,85772,85882,85883);
+
+DELETE FROM `pool_template` WHERE `entry` BETWEEN @POOLID AND @POOLID+8;
+INSERT INTO `pool_template` (`entry`,`max_limit`,`description`) VALUES
+(@POOLID,1,'Battered Chest (106318), Mulgore, Chest Pool Mulgore North'),
+(@POOLID+1,1,'Battered Chest (106318), Mulgore, Chest Pool Golden Plains'),
+(@POOLID+2,1,'Battered Chest (106318), Mulgore, Chest Pool Mulgore West'),
+(@POOLID+3,1,'Battered Chest (106318), Mulgore, Chest Pool Bael''dun Digsite'),
+(@POOLID+4,1,'Battered Chest (106318), Mulgore, Chest Pool Venture Company Mine'),
+(@POOLID+5,1,'Battered Chest (106318), Mulgore, Chest Pool Palemane Rock'),
+(@POOLID+6,1,'Battered Chest (106318), Mulgore, Chest Pool Palemane Camp'),
+(@POOLID+7,1,'Battered Chest (106318), Mulgore, Chest Pool The Rolling Plains'),
+(@POOLID+8,1,'Battered Chest (106318), Mulgore, Chest Pool Venture North and Ravaged Caravan');
+
+DELETE FROM `pool_members` WHERE `poolSpawnId` BETWEEN @POOLID AND @POOLID+8;
+INSERT INTO `pool_members` (`type`,`spawnId`,`poolSpawnId`,`chance`,`description`) VALUES
+(1,18442,@POOLID,0,'Battered Chest (106318), Mulgore North'),
+(1,@OGUID,@POOLID,0,'Battered Chest (106318), Mulgore North'),
+(1,@OGUID+1,@POOLID,0,'Battered Chest (106318), Mulgore North'),
+(1,@OGUID+2,@POOLID,0,'Battered Chest (106318), Mulgore North'),
+(1,18443,@POOLID+1,0,'Battered Chest (106318), Golden Plains'),
+(1,@OGUID+3,@POOLID+1,0,'Battered Chest (106318), Golden Plains'),
+(1,@OGUID+4,@POOLID+1,0,'Battered Chest (106318), Windfiry Ridge'),
+(1,@OGUID+5,@POOLID+1,0,'Battered Chest (106318), Windfiry Ridge'),
+(1,18451,@POOLID+2,0,'Battered Chest (106318), Mulgore West'),
+(1,85772,@POOLID+2,0,'Battered Chest (106318), Mulgore West'),
+(1,@OGUID+6,@POOLID+2,0,'Battered Chest (106318), Mulgore West'),
+(1,@OGUID+7,@POOLID+2,0,'Battered Chest (106318), Mulgore West'),
+(1,18446,@POOLID+3,0,'Battered Chest (106318), Bael''dun Digsite'),
+(1,@OGUID+8,@POOLID+3,0,'Battered Chest (106318), Bael''dun Digsite'),
+(1,18454,@POOLID+3,0,'Battered Chest (106318), Mulgore'),
+(1,85883,@POOLID+3,0,'Battered Chest (106318), Mulgore'),
+(1,18445,@POOLID+4,0,'Battered Chest (106318), Venture Company Mine'),
+(1,18453,@POOLID+4,0,'Battered Chest (106318), Venture Company Mine'),
+(1,@OGUID+9,@POOLID+4,0,'Battered Chest (106318), Venture Company Mine'),
+(1,@OGUID+10,@POOLID+4,0,'Battered Chest (106318), Venture Company Mine'),
+(1,@OGUID+11,@POOLID+4,0,'Battered Chest (106318), Venture Company Mine'),
+(1,@OGUID+12,@POOLID+4,0,'Battered Chest (106318), Venture Company Mine'),
+(1,@OGUID+13,@POOLID+4,0,'Battered Chest (106318), Venture Company Mine'),
+(1,18447,@POOLID+5,0,'Battered Chest (106318), Palemane Rock'),
+(1,18448,@POOLID+5,0,'Battered Chest (106318), Palemane Rock'),
+(1,@OGUID+14,@POOLID+5,0,'Battered Chest (106318), Palemane Rock'),
+(1,@OGUID+15,@POOLID+5,0,'Battered Chest (106318), Palemane Rock'),
+(1,@OGUID+16,@POOLID+5,0,'Battered Chest (106318), Palemane Rock'),
+(1,@OGUID+17,@POOLID+5,0,'Battered Chest (106318), Palemane Rock'),
+(1,18444,@POOLID+6,0,'Battered Chest (106318), Palemane Camp'),
+(1,18449,@POOLID+6,0,'Battered Chest (106318), Palemane Camp'),
+(1,85767,@POOLID+6,0,'Battered Chest (106318), Palemane Camp'),
+(1,@OGUID+18,@POOLID+6,0,'Battered Chest (106318), Palemane Camp'),
+(1,18455,@POOLID+7,0,'Battered Chest (106318), The Rolling Plains'),
+(1,@OGUID+19,@POOLID+7,0,'Battered Chest (106318), The Rolling Plains'),
+(1,@OGUID+20,@POOLID+7,0,'Battered Chest (106318), The Rolling Plains'),
+(1,@OGUID+21,@POOLID+7,0,'Battered Chest (106318), The Rolling Plains'),
+(1,18450,@POOLID+8,0,'Battered Chest (106318), Mulgore Venture North'),
+(1,85882,@POOLID+8,0,'Battered Chest (106318), Mulgore Venture North'),
+(1,18452,@POOLID+8,0,'Battered Chest (106318), Ravaged Caravan'),
+(1,@OGUID+22,@POOLID+8,0,'Battered Chest (106318), Ravaged Caravan'),
+(1,@OGUID+23,@POOLID+8,0,'Battered Chest (106318), Ravaged Caravan');