-- Add 5 missing Battered Chest ID: 106318 with pooling in Tirisfal Glades
SET @OGUID := XXXXX; -- 6 required
SET @POOLID := XXXXX; -- 6 required
DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+5;
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, 0, 85, 0, 1, 1, 3026.86474609375, 373.430328369140625, -1.28391504287719726, 3.263772249221801757, 0, 0, -0.99813461303710937, 0.061051756143569946, 360, 255, 1, 46902), -- North Coast
(@OGUID+1, 106318, 0, 85, 157, 1, 1, 2762.719482421875, 788.5009765625, 114.366912841796875, 1.954769015312194824, 0, 0, 0.829037666320800781, 0.559192776679992675, 360, 255, 1, 40203), -- Agamand Mills
(@OGUID+2, 106318, 0, 85, 157, 1, 1, 3053.3974609375, 694.55792236328125, 66.45069122314453125, 2.391098499298095703, 0, 0, 0.930417060852050781, 0.366502493619918823, 360, 255, 1, 44833), -- Agamand Family Crypt
(@OGUID+3, 106318, 0, 85, 156, 1, 1, 2342.98876953125, 1319.2288818359375, 34.01108551025390625, 4.555310726165771484, 0, 0, -0.76040554046630859, 0.649448513984680175, 360, 255, 1, 46779), -- Soliden Farmstead
(@OGUID+4, 106318, 0, 0, 0, 1, 1, 2914.103515625, 377.418182373046875, 31.48216438293457031, 3.577930212020874023, 0, 0, -0.97629547119140625, 0.216442063450813293, 360, 255, 1, 56857), -- Garren Mill
-- Mangos DB
(@OGUID+5, 106318, 0, 85, 0, 1, 1, 3058.99, 2.03689, -1.59202, 3.71755, 0, 0, -0.958819, 0.284016, 360, 255, 1, 46779); -- North Coast