DB/SwampOfSorrows: Added Hallows End spawns

3 files changed, 571 insertions, 0 deletions

diff --git a/sql/updates/world/master/2023_11_08_18_world_swamp_of_sorrows_bogpaddle.sql b/sql/updates/world/master/2023_11_08_18_world_swamp_of_sorrows_bogpaddle.sql
new file mode 100644
index 00000000000..9bfd69b322e
--- /dev/null
+++ b/sql/updates/world/master/2023_11_08_18_world_swamp_of_sorrows_bogpaddle.sql
@@ -0,0 +1,263 @@
+SET @OGUID := 3005202;
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=51886 WHERE `entry`=208139; -- Candy Bucket
+
+UPDATE `gameobject_template_addon` SET `faction`=35 WHERE `entry`=208139; -- Candy Bucket
+
+-- Quests
+DELETE FROM `quest_offer_reward` WHERE `ID`=28967;
+INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES
+(28967, 0, 0, 0, 0, 0, 0, 0, 0, 'Candy buckets like this are located in inns throughout the realms. Go ahead... take some!', 51886); -- Candy Bucket
+
+DELETE FROM `gameobject_queststarter` WHERE `id`=208139;
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(208139, 28967, 51886);
+
+UPDATE `gameobject_questender` SET `VerifiedBuild`=51886 WHERE (`id`=208139 AND `quest`=28967);
+
+DELETE FROM `game_event_gameobject_quest` WHERE `id`=208139;
+
+-- Old gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 231280 AND 231485;
+DELETE FROM `gameobject` WHERE `guid`=232007;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 231280 AND 231485;
+DELETE FROM `game_event_gameobject` WHERE `guid`=232007;
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+114;
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
+(@OGUID+0, 180405, 0, 8, 5458, '0', 0, 0, -9746.126953125, -3888.64404296875, 27.67670631408691406, 1.85004889965057373, 0, 0, 0.798635482788085937, 0.60181504487991333, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+1, 180405, 0, 8, 5458, '0', 0, 0, -9778.8798828125, -3877.255126953125, 24.39068031311035156, 5.044002056121826171, 0, 0, -0.58070278167724609, 0.814115643501281738, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+2, 180405, 0, 8, 5458, '0', 0, 0, -9736.7236328125, -3934.845458984375, 21.78411865234375, 3.752462387084960937, 0, 0, -0.95371627807617187, 0.300707906484603881, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+3, 180405, 0, 8, 5458, '0', 0, 0, -9801.064453125, -3852.36279296875, 27.83259773254394531, 3.560472726821899414, 0, 0, -0.97814750671386718, 0.207912087440490722, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+4, 180405, 0, 8, 5458, '0', 0, 0, -9815.8486328125, -3897.157958984375, 21.8435821533203125, 3.194002151489257812, 0, 0, -0.99965667724609375, 0.026201646775007247, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+5, 180405, 0, 8, 5458, '0', 0, 0, -9829.203125, -3880.98779296875, 27.59727668762207031, 5.113816738128662109, 0, 0, -0.55193614959716796, 0.833886384963989257, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+6, 180405, 0, 8, 5458, '0', 0, 0, -9759.8994140625, -3982.772705078125, 28.77989768981933593, 0.383971005678176879, 0, 0, 0.190808296203613281, 0.981627285480499267, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+7, 180406, 0, 8, 5458, '0', 0, 0, -9779.0625, -3883.241455078125, 24.38010597229003906, 5.166176319122314453, 0, 0, -0.52991867065429687, 0.84804844856262207, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+8, 180406, 0, 8, 5458, '0', 0, 0, -9770.3212890625, -3943.720458984375, 28.016387939453125, 1.623155713081359863, 0, 0, 0.725374221801757812, 0.688354730606079101, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+9, 180406, 0, 8, 5458, '0', 0, 0, -9801, -3898.751708984375, 21.68892860412597656, 2.932138919830322265, 0, 0, 0.994521141052246093, 0.104535527527332305, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+10, 180406, 0, 8, 5458, '0', 0, 0, -9723.216796875, -3975.807373046875, 28.69442176818847656, 2.024578809738159179, 0, 0, 0.848047256469726562, 0.529920578002929687, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+11, 180406, 0, 8, 5458, '0', 0, 0, -9828.7705078125, -3897.213623046875, 27.67819595336914062, 4.97418975830078125, 0, 0, -0.60876083374023437, 0.793353796005249023, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+12, 180407, 0, 8, 5458, '0', 0, 0, -9737.796875, -3903.829833984375, 22.64487648010253906, 4.223697185516357421, 0, 0, -0.85716724395751953, 0.515038192272186279, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+13, 180407, 0, 8, 5458, '0', 0, 0, -9720.8388671875, -3897.585205078125, 34.18621826171875, 1.815141916275024414, 0, 0, 0.788010597229003906, 0.615661680698394775, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+14, 180407, 0, 8, 5458, '0', 0, 0, -9781.2412109375, -3853.288330078125, 27.71799659729003906, 3.630291461944580078, 0, 0, -0.97029495239257812, 0.241925001144409179, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+15, 180407, 0, 8, 5458, '0', 0, 0, -9772.875, -3924.947998046875, 21.60287094116210937, 2.530723094940185546, 0, 0, 0.953716278076171875, 0.300707906484603881, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+16, 180407, 0, 8, 5458, '0', 0, 0, -9768.6650390625, -3972.210205078125, 27.52300453186035156, 2.530723094940185546, 0, 0, 0.953716278076171875, 0.300707906484603881, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+17, 180407, 0, 8, 5458, '0', 0, 0, -9743.421875, -3982.0556640625, 28.63459968566894531, 0.349065244197845458, 0, 0, 0.173647880554199218, 0.984807789325714111, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+18, 180411, 0, 8, 5458, '0', 0, 0, -9823.9658203125, -3889.920166015625, 25.9282073974609375, 5.829400539398193359, 0, 0, -0.22495079040527343, 0.974370121955871582, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+19, 180415, 0, 8, 5458, '0', 0, 0, -9745.9775390625, -3892.298583984375, 23.05868339538574218, 0.174532130360603332, 0, 0, 0.087155342102050781, 0.996194720268249511, 120, 255, 1, 51886), -- CandleBlack01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+20, 180415, 0, 8, 5458, '0', 0, 0, -9747.123046875, -3896.473876953125, 23.15369415283203125, 2.548179388046264648, 0, 0, 0.956304550170898437, 0.292372345924377441, 120, 255, 1, 51886), -- CandleBlack01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+21, 180415, 0, 8, 5458, '0', 0, 0, -9736.31640625, -3898.904541015625, 23.59190177917480468, 2.827429771423339843, 0, 0, 0.987688064575195312, 0.156436234712600708, 120, 255, 1, 51886), -- CandleBlack01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+22, 180415, 0, 8, 5458, '0', 0, 0, -9736.111328125, -3899.076416015625, 23.66608428955078125, 1.151916384696960449, 0, 0, 0.544638633728027343, 0.838670849800109863, 120, 255, 1, 51886), -- CandleBlack01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+23, 180415, 0, 8, 5458, '0', 0, 0, -9746.06640625, -3892.62158203125, 22.85357475280761718, 2.007128477096557617, 0, 0, 0.84339141845703125, 0.537299633026123046, 120, 255, 1, 51886), -- CandleBlack01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+24, 180415, 0, 8, 5458, '0', 0, 0, -9735.6337890625, -3901.1181640625, 23.62952804565429687, 1.082102894783020019, 0, 0, 0.51503753662109375, 0.857167601585388183, 120, 255, 1, 51886), -- CandleBlack01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+25, 180415, 0, 8, 5458, '0', 0, 0, -9780.71875, -3882.552001953125, 21.59832382202148437, 1.762782454490661621, 0, 0, 0.771624565124511718, 0.636078238487243652, 120, 255, 1, 51886), -- CandleBlack01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+26, 180415, 0, 8, 5458, '0', 0, 0, -9740.75390625, -3905.251708984375, 24.53799819946289062, 1.186823248863220214, 0, 0, 0.559192657470703125, 0.829037725925445556, 120, 255, 1, 51886), -- CandleBlack01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+27, 180415, 0, 8, 5458, '0', 0, 0, -9781, -3883.944580078125, 21.71990394592285156, 4.555310726165771484, 0, 0, -0.76040554046630859, 0.649448513984680175, 120, 255, 1, 51886), -- CandleBlack01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+28, 180415, 0, 8, 5458, '0', 0, 0, -9780.345703125, -3883.576416015625, 21.69286155700683593, 5.654868602752685546, 0, 0, -0.30901622772216796, 0.95105677843093872, 120, 255, 1, 51886), -- CandleBlack01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+29, 180415, 0, 8, 5458, '0', 0, 0, -9783.919921875, -3863.59375, 21.76359176635742187, 2.740161895751953125, 0, 0, 0.979924201965332031, 0.199370384216308593, 120, 255, 1, 51886), -- CandleBlack01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+30, 180415, 0, 8, 5458, '0', 0, 0, -9784.26953125, -3863.619873046875, 21.80497169494628906, 5.375615119934082031, 0, 0, -0.4383707046508789, 0.898794233798980712, 120, 255, 1, 51886), -- CandleBlack01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+31, 180415, 0, 8, 5458, '0', 0, 0, -9789.78125, -3914.967041015625, 22.21663856506347656, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 120, 255, 1, 51886), -- CandleBlack01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+32, 180415, 0, 8, 5458, '0', 0, 0, -9790.6181640625, -3909.182373046875, 23.399505615234375, 5.777040958404541015, 0, 0, -0.25037956237792968, 0.968147754669189453, 120, 255, 1, 51886), -- CandleBlack01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+33, 180415, 0, 8, 5458, '0', 0, 0, -9790.34765625, -3909.27783203125, 23.44681930541992187, 4.555310726165771484, 0, 0, -0.76040554046630859, 0.649448513984680175, 120, 255, 1, 51886), -- CandleBlack01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+34, 180415, 0, 8, 5458, '0', 0, 0, -9790.0224609375, -3909.3681640625, 23.36617469787597656, 5.619962215423583984, 0, 0, -0.32556724548339843, 0.945518851280212402, 120, 255, 1, 51886), -- CandleBlack01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+35, 180415, 0, 8, 5458, '0', 0, 0, -9781.388671875, -3882.798583984375, 21.63618087768554687, 2.67034769058227539, 0, 0, 0.972369194030761718, 0.233448356389999389, 120, 255, 1, 51886), -- CandleBlack01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+36, 180415, 0, 8, 5458, '0', 0, 0, -9781.5107421875, -3883.4150390625, 21.69519805908203125, 3.543023586273193359, 0, 0, -0.97992420196533203, 0.199370384216308593, 120, 255, 1, 51886), -- CandleBlack01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+37, 180415, 0, 8, 5458, '0', 0, 0, -9790.876953125, -3909.083251953125, 23.305633544921875, 5.89921426773071289, 0, 0, -0.19080829620361328, 0.981627285480499267, 120, 255, 1, 51886), -- CandleBlack01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+38, 180415, 0, 8, 5458, '0', 0, 0, -9744.55078125, -3936.741455078125, 22.93662643432617187, 1.675513744354248046, 0, 0, 0.743144035339355468, 0.669131457805633544, 120, 255, 1, 51886), -- CandleBlack01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+39, 180415, 0, 8, 5458, '0', 0, 0, -9784.0849609375, -3863.93408203125, 21.67277336120605468, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+40, 180415, 0, 8, 5458, '0', 0, 0, -9789.95703125, -3914.78125, 22.10446739196777343, 5.427974700927734375, 0, 0, -0.41469287872314453, 0.909961462020874023, 120, 255, 1, 51886), -- CandleBlack01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+41, 180415, 0, 8, 5458, '0', 0, 0, -9789.6875, -3909.46533203125, 23.25378227233886718, 2.007128477096557617, 0, 0, 0.84339141845703125, 0.537299633026123046, 120, 255, 1, 51886), -- CandleBlack01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+42, 180415, 0, 8, 5458, '0', 0, 0, -9789.392578125, -3909.579833984375, 23.09548377990722656, 4.293513298034667968, 0, 0, -0.8386697769165039, 0.544640243053436279, 120, 255, 1, 51886), -- CandleBlack01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+43, 180415, 0, 8, 5458, '0', 0, 0, -9744.1181640625, -3936.48779296875, 22.92554283142089843, 1.221729278564453125, 0, 0, 0.573575973510742187, 0.819152355194091796, 120, 255, 1, 51886), -- CandleBlack01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+44, 180415, 0, 8, 5458, '0', 0, 0, -9790.0712890625, -3915.08154296875, 22.26119422912597656, 5.113816738128662109, 0, 0, -0.55193614959716796, 0.833886384963989257, 120, 255, 1, 51886), -- CandleBlack01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+45, 180425, 0, 8, 5458, '0', 0, 0, -9746.9306640625, -3896.119873046875, 23.23897743225097656, 5.829400539398193359, 0, 0, -0.22495079040527343, 0.974370121955871582, 120, 255, 1, 51886), -- SkullCandle01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+46, 180425, 0, 8, 5458, '0', 0, 0, -9768.3388671875, -3900.44970703125, 23.56763648986816406, 4.380776405334472656, 0, 0, -0.81411552429199218, 0.580702960491180419, 120, 255, 1, 51886), -- SkullCandle01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+47, 180425, 0, 8, 5458, '0', 0, 0, -9741.154296875, -3905.38720703125, 24.76087760925292968, 1.727874636650085449, 0, 0, 0.760405540466308593, 0.649448513984680175, 120, 255, 1, 51886), -- SkullCandle01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+48, 180425, 0, 8, 5458, '0', 0, 0, -9744.548828125, -3936.423583984375, 23.00011634826660156, 2.426007747650146484, 0, 0, 0.936672210693359375, 0.350207358598709106, 120, 255, 1, 51886), -- SkullCandle01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+49, 180425, 0, 8, 5458, '0', 0, 0, -9745.4736328125, -3959.947998046875, 23.41820907592773437, 3.194002151489257812, 0, 0, -0.99965667724609375, 0.026201646775007247, 120, 255, 1, 51886), -- SkullCandle01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+50, 180426, 0, 8, 5458, '0', 0, 0, -9739.1181640625, -3893.720458984375, 30.44158554077148437, 0.314158439636230468, 0, 0, 0.156434059143066406, 0.987688362598419189, 120, 255, 1, 51886), -- Bat01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+51, 180426, 0, 8, 5458, '0', 0, 0, -9757.1943359375, -3907.041748046875, 31.45549964904785156, 3.665196180343627929, 0, 0, -0.96592521667480468, 0.258821308612823486, 120, 255, 1, 51886), -- Bat01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+52, 180426, 0, 8, 5458, '0', 0, 0, -9764.888671875, -3914.05908203125, 32.32550811767578125, 3.036838293075561523, 0, 0, 0.998628616333007812, 0.052353221923112869, 120, 255, 1, 51886), -- Bat01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+53, 180426, 0, 8, 5458, '0', 0, 0, -9746.0693359375, -3930.10595703125, 32.73180007934570312, 5.305802345275878906, 0, 0, -0.46947097778320312, 0.882947921752929687, 120, 255, 1, 51886), -- Bat01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+54, 180426, 0, 8, 5458, '0', 0, 0, -9790.7470703125, -3883.546875, 29.13756370544433593, 1.256635904312133789, 0, 0, 0.587784767150878906, 0.809017360210418701, 120, 255, 1, 51886), -- Bat01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+55, 180427, 0, 8, 5458, '0', 0, 0, -9775.90625, -3900.760498046875, 26.19120216369628906, 1.256635904312133789, 0, 0, 0.587784767150878906, 0.809017360210418701, 120, 255, 1, 51886), -- Bat02 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+56, 180427, 0, 8, 5458, '0', 0, 0, -9753.091796875, -3908.435791015625, 34.17998886108398437, 0.942476630210876464, 0, 0, 0.453989982604980468, 0.891006767749786376, 120, 255, 1, 51886), -- Bat02 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+57, 180427, 0, 8, 5458, '0', 0, 0, -9759.1298828125, -3909.06591796875, 32.19264602661132812, 1.518436193466186523, 0, 0, 0.6883544921875, 0.725374460220336914, 120, 255, 1, 51886), -- Bat02 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+58, 180427, 0, 8, 5458, '0', 0, 0, -9771.09375, -3908.03125, 21.66600990295410156, 1.692969322204589843, 0, 0, 0.748955726623535156, 0.662620067596435546, 120, 255, 1, 51886), -- Bat02 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+59, 180471, 0, 8, 5458, '0', 0, 0, -9752.8349609375, -3897.177001953125, 25.63694953918457031, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+60, 180471, 0, 8, 5458, '0', 0, 0, -9736.0673828125, -3883.782958984375, 24.3715667724609375, 5.759587764739990234, 0, 0, -0.25881862640380859, 0.965925931930541992, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+61, 180471, 0, 8, 5458, '0', 0, 0, -9747.5048828125, -3881.51904296875, 26.52299690246582031, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+62, 180471, 0, 8, 5458, '0', 0, 0, -9736.4794921875, -3896.657958984375, 24.93480873107910156, 4.48549652099609375, 0, 0, -0.7826080322265625, 0.622514784336090087, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+63, 180471, 0, 8, 5458, '0', 0, 0, -9743.296875, -3883.388916015625, 25.02009963989257812, 5.794494152069091796, 0, 0, -0.24192142486572265, 0.970295846462249755, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+64, 180471, 0, 8, 5458, '0', 0, 0, -9747.767578125, -3891.255126953125, 26.44188117980957031, 1.658061861991882324, 0, 0, 0.737277030944824218, 0.67559051513671875, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+65, 180471, 0, 8, 5458, '0', 0, 0, -9771.3701171875, -3863.0244140625, 25.61910438537597656, 3.22885894775390625, 0, 0, -0.99904823303222656, 0.043619260191917419, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+66, 180471, 0, 8, 5458, '0', 0, 0, -9746.67578125, -3915.1181640625, 26.341766357421875, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+67, 180471, 0, 8, 5458, '0', 0, 0, -9736.2080078125, -3901.892333984375, 25.10577583312988281, 4.48549652099609375, 0, 0, -0.7826080322265625, 0.622514784336090087, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+68, 180471, 0, 8, 5458, '0', 0, 0, -9776.3544921875, -3868.984375, 26.47265052795410156, 4.660029888153076171, 0, 0, -0.72537422180175781, 0.688354730606079101, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+69, 180471, 0, 8, 5458, '0', 0, 0, -9770.6044921875, -3897.107666015625, 26.48838996887207031, 6.248279094696044921, 0, 0, -0.01745223999023437, 0.999847710132598876, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+70, 180471, 0, 8, 5458, '0', 0, 0, -9776.96875, -3891.579833984375, 26.57023811340332031, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+71, 180471, 0, 8, 5458, '0', 0, 0, -9747.23828125, -3869.9462890625, 26.53369331359863281, 1.640606880187988281, 0, 0, 0.731352806091308593, 0.6819993257522583, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+72, 180471, 0, 8, 5458, '0', 0, 0, -9745.357421875, -3919.755126953125, 26.637451171875, 5.427974700927734375, 0, 0, -0.41469287872314453, 0.909961462020874023, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+73, 180471, 0, 8, 5458, '0', 0, 0, -9762.5107421875, -3863.404541015625, 26.35652351379394531, 3.106652259826660156, 0, 0, 0.999847412109375, 0.017469281330704689, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+74, 180471, 0, 8, 5458, '0', 0, 0, -9763.4775390625, -3897.1875, 26.43466377258300781, 6.195919513702392578, 0, 0, -0.04361915588378906, 0.999048233032226562, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+75, 180471, 0, 8, 5458, '0', 0, 0, -9754.642578125, -3863.897705078125, 26.54823493957519531, 3.194002151489257812, 0, 0, -0.99965667724609375, 0.026201646775007247, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+76, 180471, 0, 8, 5458, '0', 0, 0, -9746.55078125, -3913.942626953125, 26.560272216796875, 4.555310726165771484, 0, 0, -0.76040554046630859, 0.649448513984680175, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+77, 180471, 0, 8, 5458, '0', 0, 0, -9746.576171875, -3943.288330078125, 26.50214195251464843, 4.555310726165771484, 0, 0, -0.76040554046630859, 0.649448513984680175, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+78, 180471, 0, 8, 5458, '0', 0, 0, -9787.8125, -3914.322998046875, 24.08747482299804687, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+79, 180471, 0, 8, 5458, '0', 0, 0, -9770.201171875, -3930.76904296875, 23.38775062561035156, 2.181660413742065429, 0, 0, 0.887010574340820312, 0.461749136447906494, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+80, 180471, 0, 8, 5458, '0', 0, 0, -9802.31640625, -3870.03466796875, 27.01796340942382812, 1.692969322204589843, 0, 0, 0.748955726623535156, 0.662620067596435546, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+81, 180471, 0, 8, 5458, '0', 0, 0, -9770.7880859375, -3926.208251953125, 23.55050277709960937, 2.338739633560180664, 0, 0, 0.920504570007324218, 0.3907318115234375, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+82, 180471, 0, 8, 5458, '0', 0, 0, -9745, -3940.15283203125, 26.17565345764160156, 3.78736734390258789, 0, 0, -0.94832324981689453, 0.317305892705917358, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+83, 180471, 0, 8, 5458, '0', 0, 0, -9773.9150390625, -3923.213623046875, 23.15941429138183593, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+84, 180471, 0, 8, 5458, '0', 0, 0, -9743.9423828125, -3939.045166015625, 26.35261154174804687, 3.94444584846496582, 0, 0, -0.92050457000732421, 0.3907318115234375, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+85, 180471, 0, 8, 5458, '0', 0, 0, -9746.3232421875, -3947.651123046875, 26.66068649291992187, 5.253442287445068359, 0, 0, -0.49242305755615234, 0.870355963706970214, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+86, 180471, 0, 8, 5458, '0', 0, 0, -9804.4638671875, -3876.28125, 26.41395950317382812, 0.890116631984710693, 0, 0, 0.430510520935058593, 0.902585566043853759, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+87, 180471, 0, 8, 5458, '0', 0, 0, -9802.638671875, -3873.239501953125, 26.74565505981445312, 1.378809213638305664, 0, 0, 0.636077880859375, 0.771624863147735595, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+88, 180471, 0, 8, 5458, '0', 0, 0, -9791.87890625, -3910.98095703125, 24.24026107788085937, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+89, 180471, 0, 8, 5458, '0', 0, 0, -9792.98828125, -3857.19091796875, 30.52347755432128906, 3.22885894775390625, 0, 0, -0.99904823303222656, 0.043619260191917419, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+90, 180471, 0, 8, 5458, '0', 0, 0, -9790.44140625, -3857.3212890625, 30.55438613891601562, 3.211419343948364257, 0, 0, -0.9993906021118164, 0.034906134009361267, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+91, 180471, 0, 8, 5458, '0', 0, 0, -9791.7470703125, -3857.234375, 30.53296279907226562, 3.281238555908203125, 0, 0, -0.99756336212158203, 0.069766148924827575, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+92, 180471, 0, 8, 5458, '0', 0, 0, -9746.748046875, -3946.54345703125, 26.71694374084472656, 5.201082706451416015, 0, 0, -0.51503753662109375, 0.857167601585388183, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+93, 180471, 0, 8, 5458, '0', 0, 0, -9776.86328125, -3919.689208984375, 23.32061576843261718, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+94, 180471, 0, 8, 5458, '0', 0, 0, -9806.26953125, -3877.803955078125, 26.72670364379882812, 0.558503925800323486, 0, 0, 0.275636672973632812, 0.961261868476867675, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+95, 180471, 0, 8, 5458, '0', 0, 0, -9751.2607421875, -3976.557373046875, 30.40369987487792968, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+96, 180471, 0, 8, 5458, '0', 0, 0, -9748.4580078125, -3976.619873046875, 30.69185829162597656, 6.161012649536132812, 0, 0, -0.06104850769042968, 0.998134791851043701, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+97, 180471, 0, 8, 5458, '0', 0, 0, -9750.2412109375, -3976.579833984375, 30.56848907470703125, 6.248279094696044921, 0, 0, -0.01745223999023437, 0.999847710132598876, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+98, 180471, 0, 8, 5458, '0', 0, 0, -9823.560546875, -3890.3994140625, 30.47779273986816406, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+99, 180471, 0, 8, 5458, '0', 0, 0, -9823.6220703125, -3888.920166015625, 30.74230384826660156, 4.817109584808349609, 0, 0, -0.66913032531738281, 0.74314504861831665, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+100, 180471, 0, 8, 5458, '0', 0, 0, -9749.3544921875, -3976.6181640625, 30.39021492004394531, 6.248279094696044921, 0, 0, -0.01745223999023437, 0.999847710132598876, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+101, 180471, 0, 8, 5458, '0', 0, 0, -9823.5419921875, -3887.3681640625, 30.21129417419433593, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+102, 180471, 0, 8, 5458, '0', 0, 0, -9752.390625, -3976.59033203125, 30.79532241821289062, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+103, 180472, 0, 8, 5458, '0', 0, 0, -9777.4150390625, -3880.052001953125, 28.00757408142089843, 3.263772249221801757, 0, 0, -0.99813461303710937, 0.061051756143569946, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+104, 180523, 0, 8, 5458, '0', 0, 0, -9780.47265625, -3867.829833984375, 21.82470321655273437, 4.171337604522705078, 0, 0, -0.87035560607910156, 0.492423713207244873, 120, 255, 1, 51886), -- Apple Bob (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+105, 207941, 0, 8, 5458, '0', 0, 0, -9763.03515625, -3880.130126953125, 34.73355865478515625, 4.520402908325195312, 0, 0, -0.77162456512451171, 0.636078238487243652, 120, 255, 1, 51886), -- G_WitchHat_01 scale 2.0 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+106, 207941, 0, 8, 5458, '0', 0, 0, -9738.640625, -3914.779541015625, 33.50423431396484375, 5.061456203460693359, 0, 0, -0.57357597351074218, 0.819152355194091796, 120, 255, 1, 51886), -- G_WitchHat_01 scale 2.0 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+107, 207941, 0, 8, 5458, '0', 0, 0, -9738.1826171875, -3944.65625, 33.48528289794921875, 5.061456203460693359, 0, 0, -0.57357597351074218, 0.819152355194091796, 120, 255, 1, 51886), -- G_WitchHat_01 scale 2.0 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+108, 207941, 0, 8, 5458, '0', 0, 0, -9810.3857421875, -3870.814208984375, 33.63306427001953125, 1.221729278564453125, 0, 0, 0.573575973510742187, 0.819152355194091796, 120, 255, 1, 51886), -- G_WitchHat_01 scale 2.0 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+109, 208069, 0, 8, 5458, '0', 0, 0, -9781.4755859375, -3920.208251953125, 24.84844779968261718, 2.949595451354980468, 0, 0, 0.995395660400390625, 0.095851235091686248, 120, 255, 1, 51886), -- G_Pumpkin_02 Scale 0.5 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+110, 208069, 0, 8, 5458, '0', 0, 0, -9813.7275390625, -3900.7119140625, 25.2358245849609375, 2.652894020080566406, 0, 0, 0.970294952392578125, 0.241925001144409179, 120, 255, 1, 51886), -- G_Pumpkin_02 Scale 0.5 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+111, 208072, 0, 8, 5458, '0', 0, 0, -9747.294921875, -3910.744873046875, 24.81595420837402343, 4.206246376037597656, 0, 0, -0.86162853240966796, 0.50753939151763916, 120, 255, 1, 51886), -- G_Pumpkin_03 Scale 0.5 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+112, 208072, 0, 8, 5458, '0', 0, 0, -9811.8193359375, -3898.842041015625, 22.88781929016113281, 3.24634718894958496, 0, 0, -0.99862861633300781, 0.052353221923112869, 120, 255, 1, 51886), -- G_Pumpkin_03 Scale 0.5 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+113, 208078, 0, 8, 5458, '0', 0, 0, -9807.1943359375, -3881.354248046875, 24.64743232727050781, 0.802850961685180664, 0, 0, 0.390730857849121093, 0.920504987239837646, 120, 255, 1, 51886), -- G_Pumpkin_01 scale 0.5 (Area: Bogpaddle - Difficulty: 0) CreateObject1
+(@OGUID+114, 208139, 0, 8, 5458, '0', 0, 0, -9771.267578125, -3878.373291015625, 21.8904876708984375, 5.270895957946777343, 0, 0, -0.48480892181396484, 0.87462007999420166, 120, 255, 1, 51886); -- Candy Bucket (Area: Bogpaddle - Difficulty: 0) CreateObject1
+
+-- Event spawns
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+114;
+INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES
+(12, @OGUID+0),
+(12, @OGUID+1),
+(12, @OGUID+2),
+(12, @OGUID+3),
+(12, @OGUID+4),
+(12, @OGUID+5),
+(12, @OGUID+6),
+(12, @OGUID+7),
+(12, @OGUID+8),
+(12, @OGUID+9),
+(12, @OGUID+10),
+(12, @OGUID+11),
+(12, @OGUID+12),
+(12, @OGUID+13),
+(12, @OGUID+14),
+(12, @OGUID+15),
+(12, @OGUID+16),
+(12, @OGUID+17),
+(12, @OGUID+18),
+(12, @OGUID+19),
+(12, @OGUID+20),
+(12, @OGUID+21),
+(12, @OGUID+22),
+(12, @OGUID+23),
+(12, @OGUID+24),
+(12, @OGUID+25),
+(12, @OGUID+26),
+(12, @OGUID+27),
+(12, @OGUID+28),
+(12, @OGUID+29),
+(12, @OGUID+30),
+(12, @OGUID+31),
+(12, @OGUID+32),
+(12, @OGUID+33),
+(12, @OGUID+34),
+(12, @OGUID+35),
+(12, @OGUID+36),
+(12, @OGUID+37),
+(12, @OGUID+38),
+(12, @OGUID+39),
+(12, @OGUID+40),
+(12, @OGUID+41),
+(12, @OGUID+42),
+(12, @OGUID+43),
+(12, @OGUID+44),
+(12, @OGUID+45),
+(12, @OGUID+46),
+(12, @OGUID+47),
+(12, @OGUID+48),
+(12, @OGUID+49),
+(12, @OGUID+50),
+(12, @OGUID+51),
+(12, @OGUID+52),
+(12, @OGUID+53),
+(12, @OGUID+54),
+(12, @OGUID+55),
+(12, @OGUID+56),
+(12, @OGUID+57),
+(12, @OGUID+58),
+(12, @OGUID+59),
+(12, @OGUID+60),
+(12, @OGUID+61),
+(12, @OGUID+62),
+(12, @OGUID+63),
+(12, @OGUID+64),
+(12, @OGUID+65),
+(12, @OGUID+66),
+(12, @OGUID+67),
+(12, @OGUID+68),
+(12, @OGUID+69),
+(12, @OGUID+70),
+(12, @OGUID+71),
+(12, @OGUID+72),
+(12, @OGUID+73),
+(12, @OGUID+74),
+(12, @OGUID+75),
+(12, @OGUID+76),
+(12, @OGUID+77),
+(12, @OGUID+78),
+(12, @OGUID+79),
+(12, @OGUID+80),
+(12, @OGUID+81),
+(12, @OGUID+82),
+(12, @OGUID+83),
+(12, @OGUID+84),
+(12, @OGUID+85),
+(12, @OGUID+86),
+(12, @OGUID+87),
+(12, @OGUID+88),
+(12, @OGUID+89),
+(12, @OGUID+90),
+(12, @OGUID+91),
+(12, @OGUID+92),
+(12, @OGUID+93),
+(12, @OGUID+94),
+(12, @OGUID+95),
+(12, @OGUID+96),
+(12, @OGUID+97),
+(12, @OGUID+98),
+(12, @OGUID+99),
+(12, @OGUID+100),
+(12, @OGUID+101),
+(12, @OGUID+102),
+(12, @OGUID+103),
+(12, @OGUID+104),
+(12, @OGUID+105),
+(12, @OGUID+106),
+(12, @OGUID+107),
+(12, @OGUID+108),
+(12, @OGUID+109),
+(12, @OGUID+110),
+(12, @OGUID+111),
+(12, @OGUID+112),
+(12, @OGUID+113),
+(12, @OGUID+114);
diff --git a/sql/updates/world/master/2023_11_08_19_world_swamp_of_sorrows_stonard.sql b/sql/updates/world/master/2023_11_08_19_world_swamp_of_sorrows_stonard.sql
new file mode 100644
index 00000000000..c4223a67b1c
--- /dev/null
+++ b/sql/updates/world/master/2023_11_08_19_world_swamp_of_sorrows_stonard.sql
@@ -0,0 +1,127 @@
+SET @OGUID := 3005317;
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=51886 WHERE `entry`=190086; -- Candy Bucket
+
+UPDATE `gameobject_template_addon` SET `faction`=1735 WHERE `entry`=190086; -- Candy Bucket
+
+-- Quests
+UPDATE `quest_offer_reward` SET `VerifiedBuild`=51886 WHERE `ID`=12384;
+
+DELETE FROM `gameobject_queststarter` WHERE `id`=190086;
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(190086, 12384, 51886);
+
+UPDATE `gameobject_questender` SET `VerifiedBuild`=51886 WHERE (`id`=190086 AND `quest`=12384);
+
+DELETE FROM `game_event_gameobject_quest` WHERE `id`=190086;
+
+-- Old gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 231486 AND 231533;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 231486 AND 231533;
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+48;
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
+(@OGUID+0, 180405, 0, 8, 75, '0', 0, 0, -10512.34375, -3324.96435546875, 32.1783599853515625, 5.585053920745849609, 0, 0, -0.34202003479003906, 0.939692676067352294, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+1, 180405, 0, 8, 75, '0', 0, 0, -10517.529296875, -3279.880126953125, 31.834075927734375, 5.393068790435791015, 0, 0, -0.43051052093505859, 0.902585566043853759, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+2, 180405, 0, 8, 75, '0', 0, 0, -10486.455078125, -3351.788330078125, 30.66631507873535156, 5.585053920745849609, 0, 0, -0.34202003479003906, 0.939692676067352294, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+3, 180405, 0, 8, 75, '0', 0, 0, -10522.4658203125, -3230.960205078125, 31.16094970703125, 4.031712055206298828, 0, 0, -0.90258502960205078, 0.430511653423309326, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+4, 180405, 0, 8, 75, '0', 0, 0, -10462.55859375, -3282.9658203125, 21.40717124938964843, 2.687806606292724609, 0, 0, 0.974370002746582031, 0.224951311945915222, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+5, 180405, 0, 8, 75, '0', 0, 0, -10465.6298828125, -3252.197998046875, 20.17817878723144531, 2.321286916732788085, 0, 0, 0.917059898376464843, 0.398749500513076782, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+6, 180405, 0, 8, 75, '0', 0, 0, -10433.7568359375, -3348.90283203125, 31.07970809936523437, 1.867502212524414062, 0, 0, 0.803856849670410156, 0.594822824001312255, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+7, 180405, 0, 8, 75, '0', 0, 0, -10421.859375, -3308.52783203125, 29.73744392395019531, 0.052358884364366531, 0, 0, 0.02617645263671875, 0.999657332897186279, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+8, 180405, 0, 8, 75, '0', 0, 0, -10485.748046875, -3222.26220703125, 30.33372688293457031, 3.647741317749023437, 0, 0, -0.96814727783203125, 0.250381410121917724, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+9, 180405, 0, 8, 75, '0', 0, 0, -10385.015625, -3288.48095703125, 29.66286849975585937, 1.169368624687194824, 0, 0, 0.551936149597167968, 0.833886384963989257, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+10, 180405, 0, 8, 75, '0', 0, 0, -10404.8837890625, -3236.03125, 30.81977081298828125, 3.560472726821899414, 0, 0, -0.97814750671386718, 0.207912087440490722, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+11, 180405, 0, 8, 75, '0', 0, 0, -10374.4658203125, -3254.368896484375, 30.94644546508789062, 2.44346022605895996, 0, 0, 0.939692497253417968, 0.34202045202255249, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+12, 180405, 0, 8, 75, '0', 0, 0, -10457.607421875, -3220.041748046875, 31.43501091003417968, 3.560472726821899414, 0, 0, -0.97814750671386718, 0.207912087440490722, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+13, 180406, 0, 8, 75, '0', 0, 0, -10513.875, -3298.7275390625, 31.11186790466308593, 6.195919513702392578, 0, 0, -0.04361915588378906, 0.999048233032226562, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+14, 180406, 0, 8, 75, '0', 0, 0, -10528.9658203125, -3249.163330078125, 31.63860702514648437, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+15, 180406, 0, 8, 75, '0', 0, 0, -10469.1669921875, -3357.68408203125, 29.60588645935058593, 6.09120035171508789, 0, 0, -0.09584522247314453, 0.995396256446838378, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+16, 180406, 0, 8, 75, '0', 0, 0, -10468.876953125, -3269.330322265625, 20.23038291931152343, 1.431168079376220703, 0, 0, 0.656058311462402343, 0.754710197448730468, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+17, 180406, 0, 8, 75, '0', 0, 0, -10429.763671875, -3311.928955078125, 30.76557159423828125, 1.623155713081359863, 0, 0, 0.725374221801757812, 0.688354730606079101, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+18, 180406, 0, 8, 75, '0', 0, 0, -10441.1162109375, -3296.786376953125, 20.17795753479003906, 3.281238555908203125, 0, 0, -0.99756336212158203, 0.069766148924827575, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+19, 180406, 0, 8, 75, '0', 0, 0, -10466.9111328125, -3220.6181640625, 31.09997940063476562, 3.508116960525512695, 0, 0, -0.98325443267822265, 0.182238012552261352, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+20, 180406, 0, 8, 75, '0', 0, 0, -10411.8564453125, -3293.00341796875, 31.35503578186035156, 0.366517573595046997, 0, 0, 0.182234764099121093, 0.98325502872467041, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+21, 180406, 0, 8, 75, '0', 0, 0, -10379.3134765625, -3246.541259765625, 30.73549079895019531, 2.478367090225219726, 0, 0, 0.94551849365234375, 0.325568377971649169, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+22, 180406, 0, 8, 75, '0', 0, 0, -10438.638671875, -3223.4375, 29.63300895690917968, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+23, 180407, 0, 8, 75, '0', 0, 0, -10517.201171875, -3317.177001953125, 32.1123046875, 5.585053920745849609, 0, 0, -0.34202003479003906, 0.939692676067352294, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+24, 180407, 0, 8, 75, '0', 0, 0, -10501.6201171875, -3340.876708984375, 31.24357414245605468, 5.602506637573242187, 0, 0, -0.33380699157714843, 0.942641437053680419, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+25, 180407, 0, 8, 75, '0', 0, 0, -10528.9111328125, -3267.069580078125, 30.935089111328125, 5.393068790435791015, 0, 0, -0.43051052093505859, 0.902585566043853759, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+26, 180407, 0, 8, 75, '0', 0, 0, -10447.12890625, -3291.98095703125, 20.17795753479003906, 2.478367090225219726, 0, 0, 0.94551849365234375, 0.325568377971649169, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+27, 180407, 0, 8, 75, '0', 0, 0, -10471, -3266.65966796875, 39.08349990844726562, 2.146752834320068359, 0, 0, 0.878816604614257812, 0.477159708738327026, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+28, 180407, 0, 8, 75, '0', 0, 0, -10503.658203125, -3229.2119140625, 32.10165023803710937, 3.52557229995727539, 0, 0, -0.98162651062011718, 0.190812408924102783, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+29, 180407, 0, 8, 75, '0', 0, 0, -10430.2099609375, -3330.421875, 31.20537948608398437, 1.884953022003173828, 0, 0, 0.809016227722167968, 0.587786316871643066, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+30, 180407, 0, 8, 75, '0', 0, 0, -10466.9267578125, -3254.326416015625, 37.950286865234375, 1.553341388702392578, 0, 0, 0.700908660888671875, 0.713251054286956787, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+31, 180407, 0, 8, 75, '0', 0, 0, -10450.330078125, -3357.475830078125, 30.34543228149414062, 0.314158439636230468, 0, 0, 0.156434059143066406, 0.987688362598419189, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+32, 180407, 0, 8, 75, '0', 0, 0, -10378.4150390625, -3272.807373046875, 29.77926063537597656, 1.692969322204589843, 0, 0, 0.748955726623535156, 0.662620067596435546, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+33, 180407, 0, 8, 75, '0', 0, 0, -10402.66015625, -3292.799560546875, 31.17360496520996093, 0.471238493919372558, 0, 0, 0.233445167541503906, 0.972369968891143798, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+34, 180407, 0, 8, 75, '0', 0, 0, -10422.951171875, -3233.322998046875, 29.34179306030273437, 3.054326534271240234, 0, 0, 0.999048233032226562, 0.043619260191917419, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+35, 180407, 0, 8, 75, '0', 0, 0, -10387.8232421875, -3230.072998046875, 30.69463729858398437, 3.211419343948364257, 0, 0, -0.9993906021118164, 0.034906134009361267, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+36, 180471, 0, 8, 75, '0', 0, 0, -10498.173828125, -3248.6962890625, 25.97489738464355468, 2.932138919830322265, 0, 0, 0.994521141052246093, 0.104535527527332305, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+37, 180471, 0, 8, 75, '0', 0, 0, -10464.138671875, -3261.282958984375, 32.42881393432617187, 2.932138919830322265, 0, 0, 0.994521141052246093, 0.104535527527332305, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+38, 180471, 0, 8, 75, '0', 0, 0, -10500.6318359375, -3256.1650390625, 25.85620307922363281, 2.932138919830322265, 0, 0, 0.994521141052246093, 0.104535527527332305, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+39, 180472, 0, 8, 75, '0', 0, 0, -10505.6845703125, -3267.780029296875, 31.80616188049316406, 4.118979454040527343, 0, 0, -0.88294696807861328, 0.469472706317901611, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+40, 180472, 0, 8, 75, '0', 0, 0, -10484.7939453125, -3243.1875, 31.84264564514160156, 1.134462952613830566, 0, 0, 0.537299156188964843, 0.843391716480255126, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+41, 180472, 0, 8, 75, '0', 0, 0, -10500.6005859375, -3240.2744140625, 31.85183334350585937, 2.024578809738159179, 0, 0, 0.848047256469726562, 0.529920578002929687, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+42, 180472, 0, 8, 75, '0', 0, 0, -10490.8486328125, -3249.921875, 27.1444244384765625, 2.932138919830322265, 0, 0, 0.994521141052246093, 0.104535527527332305, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+43, 180472, 0, 8, 75, '0', 0, 0, -10489.8779296875, -3270.822509765625, 31.76886749267578125, 5.183629035949707031, 0, 0, -0.52249813079833984, 0.852640450000762939, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+44, 180472, 0, 8, 75, '0', 0, 0, -10502.4658203125, -3252.82470703125, 27.37425804138183593, 2.932138919830322265, 0, 0, 0.994521141052246093, 0.104535527527332305, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+45, 180472, 0, 8, 75, '0', 0, 0, -10511.1416015625, -3252.487060546875, 31.79152107238769531, 2.967041015625, 0, 0, 0.996193885803222656, 0.087165042757987976, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+46, 180472, 0, 8, 75, '0', 0, 0, -10466.6806640625, -3260.913330078125, 28.62903594970703125, 2.932138919830322265, 0, 0, 0.994521141052246093, 0.104535527527332305, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+47, 180523, 0, 8, 75, '0', 0, 0, -10489.84765625, -3249.76904296875, 21.44113731384277343, 2.932138919830322265, 0, 0, 0.994521141052246093, 0.104535527527332305, 120, 255, 1, 51886), -- Apple Bob (Area: Stonard - Difficulty: 0) CreateObject1
+(@OGUID+48, 190086, 0, 8, 75, '0', 0, 0, -10487.7158203125, -3256.979736328125, 21.02933502197265625, 1.274088263511657714, 0, 0, 0.594821929931640625, 0.80385744571685791, 120, 255, 1, 51886); -- Candy Bucket (Area: Stonard - Difficulty: 0) CreateObject1
+
+-- Event spawns
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+48;
+INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES
+(12, @OGUID+0),
+(12, @OGUID+1),
+(12, @OGUID+2),
+(12, @OGUID+3),
+(12, @OGUID+4),
+(12, @OGUID+5),
+(12, @OGUID+6),
+(12, @OGUID+7),
+(12, @OGUID+8),
+(12, @OGUID+9),
+(12, @OGUID+10),
+(12, @OGUID+11),
+(12, @OGUID+12),
+(12, @OGUID+13),
+(12, @OGUID+14),
+(12, @OGUID+15),
+(12, @OGUID+16),
+(12, @OGUID+17),
+(12, @OGUID+18),
+(12, @OGUID+19),
+(12, @OGUID+20),
+(12, @OGUID+21),
+(12, @OGUID+22),
+(12, @OGUID+23),
+(12, @OGUID+24),
+(12, @OGUID+25),
+(12, @OGUID+26),
+(12, @OGUID+27),
+(12, @OGUID+28),
+(12, @OGUID+29),
+(12, @OGUID+30),
+(12, @OGUID+31),
+(12, @OGUID+32),
+(12, @OGUID+33),
+(12, @OGUID+34),
+(12, @OGUID+35),
+(12, @OGUID+36),
+(12, @OGUID+37),
+(12, @OGUID+38),
+(12, @OGUID+39),
+(12, @OGUID+40),
+(12, @OGUID+41),
+(12, @OGUID+42),
+(12, @OGUID+43),
+(12, @OGUID+44),
+(12, @OGUID+45),
+(12, @OGUID+46),
+(12, @OGUID+47),
+(12, @OGUID+48);
diff --git a/sql/updates/world/master/2023_11_08_20_world_swamp_of_sorrows_the_harborage.sql b/sql/updates/world/master/2023_11_08_20_world_swamp_of_sorrows_the_harborage.sql
new file mode 100644
index 00000000000..225193f81a0
--- /dev/null
+++ b/sql/updates/world/master/2023_11_08_20_world_swamp_of_sorrows_the_harborage.sql
@@ -0,0 +1,181 @@
+SET @OGUID := 3005366;
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=51886 WHERE `entry`=208126; -- Candy Bucket
+
+UPDATE `gameobject_template_addon` SET `faction`=1732 WHERE `entry`=208126; -- Candy Bucket
+
+-- Quests
+UPDATE `quest_template` SET `Expansion`=9, `VerifiedBuild`=51886 WHERE `ID`=28968; -- Candy Bucket
+
+DELETE FROM `quest_offer_reward` WHERE `ID`=28968;
+INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES
+(28968, 0, 0, 0, 0, 0, 0, 0, 0, 'Candy buckets like this are located in inns throughout the realms. Go ahead... take some!', 51886); -- Candy Bucket
+
+DELETE FROM `gameobject_queststarter` WHERE `id`=208126;
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(208126, 28968, 51886);
+
+UPDATE `gameobject_questender` SET `VerifiedBuild`=51886 WHERE (`id`=208126 AND `quest`=28968);
+
+DELETE FROM `game_event_gameobject_quest` WHERE `id`=208126;
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+75;
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
+(@OGUID+0, 180405, 0, 8, 657, '0', 0, 0, -10136.9580078125, -2834.171875, 22.67504310607910156, 5.811946868896484375, 0, 0, -0.2334451675415039, 0.972369968891143798, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+1, 180405, 0, 8, 657, '0', 0, 0, -10101.3134765625, -2832.55908203125, 22.49126243591308593, 4.084071159362792968, 0, 0, -0.8910064697265625, 0.453990638256072998, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+2, 180405, 0, 8, 657, '0', 0, 0, -10121.298828125, -2782.260498046875, 22.88033485412597656, 0.401424884796142578, 0, 0, 0.199367523193359375, 0.979924798011779785, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+3, 180406, 0, 8, 657, '0', 0, 0, -10133.111328125, -2846.725830078125, 22.50278663635253906, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+4, 180406, 0, 8, 657, '0', 0, 0, -10112.8173828125, -2784.354248046875, 22.50556755065917968, 6.021387100219726562, 0, 0, -0.13052558898925781, 0.991444945335388183, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+5, 180407, 0, 8, 657, '0', 0, 0, -10116.892578125, -2857.6650390625, 23.27706336975097656, 3.595378875732421875, 0, 0, -0.97437000274658203, 0.224951311945915222, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+6, 180407, 0, 8, 657, '0', 0, 0, -10087.501953125, -2802.751708984375, 22.53332710266113281, 5.148722648620605468, 0, 0, -0.53729915618896484, 0.843391716480255126, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+7, 180411, 0, 8, 657, '0', 0, 0, -10109.732421875, -2766.598876953125, 29.88904571533203125, 0.209439441561698913, 0, 0, 0.104528427124023437, 0.994521915912628173, 120, 255, 1, 51886), -- G_Ghost_01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+8, 180415, 0, 8, 657, '0', 0, 0, -10109.0888671875, -2850.100830078125, 23.79323959350585937, 1.082102894783020019, 0, 0, 0.51503753662109375, 0.857167601585388183, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+9, 180415, 0, 8, 657, '0', 0, 0, -10097.7255859375, -2831.163330078125, 23.53732109069824218, 3.176533222198486328, 0, 0, -0.999847412109375, 0.017469281330704689, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+10, 180415, 0, 8, 657, '0', 0, 0, -10097.388671875, -2831.229248046875, 23.74900436401367187, 1.151916384696960449, 0, 0, 0.544638633728027343, 0.838670849800109863, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+11, 180415, 0, 8, 657, '0', 0, 0, -10097.580078125, -2830.954833984375, 23.71291923522949218, 1.85004889965057373, 0, 0, 0.798635482788085937, 0.60181504487991333, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+12, 180415, 0, 8, 657, '0', 0, 0, -10100.408203125, -2788.557373046875, 21.75434684753417968, 4.206246376037597656, 0, 0, -0.86162853240966796, 0.50753939151763916, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+13, 180415, 0, 8, 657, '0', 0, 0, -10102.201171875, -2789.984375, 21.71258926391601562, 2.460912704467773437, 0, 0, 0.942641258239746093, 0.333807557821273803, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+14, 180415, 0, 8, 657, '0', 0, 0, -10100.771484375, -2789.47216796875, 21.81911659240722656, 5.986480236053466796, 0, 0, -0.14780902862548828, 0.989015936851501464, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+15, 180415, 0, 8, 657, '0', 0, 0, -10102.498046875, -2787.7431640625, 21.75321006774902343, 0.558503925800323486, 0, 0, 0.275636672973632812, 0.961261868476867675, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+16, 180415, 0, 8, 657, '0', 0, 0, -10102.982421875, -2788.48095703125, 21.75267982482910156, 2.862335443496704101, 0, 0, 0.990267753601074218, 0.139175355434417724, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+17, 180415, 0, 8, 657, '0', 0, 0, -10101.59375, -2789.885498046875, 21.7334136962890625, 3.281238555908203125, 0, 0, -0.99756336212158203, 0.069766148924827575, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+18, 180415, 0, 8, 657, '0', 0, 0, -10100.607421875, -2787.763916015625, 21.81746864318847656, 1.431168079376220703, 0, 0, 0.656058311462402343, 0.754710197448730468, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+19, 180415, 0, 8, 657, '0', 0, 0, -10101.466796875, -2787.005126953125, 21.71280670166015625, 2.879789113998413085, 0, 0, 0.991444587707519531, 0.130528271198272705, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+20, 180415, 0, 8, 657, '0', 0, 0, -10102.6494140625, -2789.413330078125, 21.72059440612792968, 2.879789113998413085, 0, 0, 0.991444587707519531, 0.130528271198272705, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+21, 180415, 0, 8, 657, '0', 0, 0, -10086.810546875, -2799.382080078125, 22.99431037902832031, 1.919861555099487304, 0, 0, 0.819151878356933593, 0.573576688766479492, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+22, 180425, 0, 8, 657, '0', 0, 0, -10109.31640625, -2849.8994140625, 23.81608200073242187, 3.351046562194824218, 0, 0, -0.99452114105224609, 0.104535527527332305, 120, 255, 1, 51886), -- SkullCandle01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+23, 180425, 0, 8, 657, '0', 0, 0, -10098.3662109375, -2831.682373046875, 23.8425750732421875, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 51886), -- SkullCandle01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+24, 180425, 0, 8, 657, '0', 0, 0, -10087.1845703125, -2798.375, 23.42401504516601562, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 51886), -- SkullCandle01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+25, 180426, 0, 8, 657, '0', 0, 0, -10110.92578125, -2808.62841796875, 33.30676651000976562, 2.338739633560180664, 0, 0, 0.920504570007324218, 0.3907318115234375, 120, 255, 1, 51886), -- Bat01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+26, 180426, 0, 8, 657, '0', 0, 0, -10109.3681640625, -2800.197998046875, 31.19693946838378906, 1.937312245368957519, 0, 0, 0.824125289916992187, 0.566407561302185058, 120, 255, 1, 51886), -- Bat01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+27, 180426, 0, 8, 657, '0', 0, 0, -10111.6650390625, -2803.71875, 35.837158203125, 3.630291461944580078, 0, 0, -0.97029495239257812, 0.241925001144409179, 120, 255, 1, 51886), -- Bat01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+28, 180426, 0, 8, 657, '0', 0, 0, -10113.857421875, -2803.335205078125, 33.0313873291015625, 4.555310726165771484, 0, 0, -0.76040554046630859, 0.649448513984680175, 120, 255, 1, 51886), -- Bat01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+29, 180427, 0, 8, 657, '0', 0, 0, -10124.771484375, -2808.12158203125, 34.41792678833007812, 5.515241622924804687, 0, 0, -0.37460613250732421, 0.927184045314788818, 120, 255, 1, 51886), -- Bat02 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+30, 180427, 0, 8, 657, '0', 0, 0, -10117.8212890625, -2807.532958984375, 32.78430938720703125, 2.024578809738159179, 0, 0, 0.848047256469726562, 0.529920578002929687, 120, 255, 1, 51886), -- Bat02 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+31, 180427, 0, 8, 657, '0', 0, 0, -10118.8505859375, -2810.09716796875, 35.89923477172851562, 0.855210542678833007, 0, 0, 0.414692878723144531, 0.909961462020874023, 120, 255, 1, 51886), -- Bat02 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+32, 180427, 0, 8, 657, '0', 0, 0, -10116.328125, -2812.770751953125, 35.95736312866210937, 1.361356139183044433, 0, 0, 0.629320144653320312, 0.77714616060256958, 120, 255, 1, 51886), -- Bat02 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+33, 180471, 0, 8, 657, '0', 0, 0, -10131.513671875, -2841.802001953125, 30.00135040283203125, 5.061456203460693359, 0, 0, -0.57357597351074218, 0.819152355194091796, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+34, 180471, 0, 8, 657, '0', 0, 0, -10132.970703125, -2837.71875, 30.24015235900878906, 5.009094715118408203, 0, 0, -0.59482288360595703, 0.80385679006576538, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+35, 180471, 0, 8, 657, '0', 0, 0, -10131.14453125, -2842.98779296875, 30.29724884033203125, 4.939284324645996093, 0, 0, -0.6225137710571289, 0.78260880708694458, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+36, 180471, 0, 8, 657, '0', 0, 0, -10131.72265625, -2841.217041015625, 29.42953872680664062, 5.113816738128662109, 0, 0, -0.55193614959716796, 0.833886384963989257, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+37, 180471, 0, 8, 657, '0', 0, 0, -10133.3408203125, -2836.513916015625, 29.74357032775878906, 5.009094715118408203, 0, 0, -0.59482288360595703, 0.80385679006576538, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+38, 180471, 0, 8, 657, '0', 0, 0, -10132.4951171875, -2838.87158203125, 29.37542343139648437, 5.009094715118408203, 0, 0, -0.59482288360595703, 0.80385679006576538, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+39, 180471, 0, 8, 657, '0', 0, 0, -10133.1650390625, -2837.09033203125, 30.18184852600097656, 5.009094715118408203, 0, 0, -0.59482288360595703, 0.80385679006576538, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+40, 180471, 0, 8, 657, '0', 0, 0, -10131.3193359375, -2842.470458984375, 30.32689857482910156, 5.061456203460693359, 0, 0, -0.57357597351074218, 0.819152355194091796, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+41, 180471, 0, 8, 657, '0', 0, 0, -10130.98828125, -2843.53125, 29.89521026611328125, 5.044002056121826171, 0, 0, -0.58070278167724609, 0.814115643501281738, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+42, 180471, 0, 8, 657, '0', 0, 0, -10132.7548828125, -2838.35595703125, 29.91961097717285156, 5.009094715118408203, 0, 0, -0.59482288360595703, 0.80385679006576538, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+43, 180471, 0, 8, 657, '0', 0, 0, -10130.845703125, -2844.09716796875, 29.30780410766601562, 5.044002056121826171, 0, 0, -0.58070278167724609, 0.814115643501281738, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+44, 180471, 0, 8, 657, '0', 0, 0, -10096.359375, -2826.491455078125, 25.39999008178710937, 4.328419685363769531, 0, 0, -0.82903671264648437, 0.559194147586822509, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+45, 180471, 0, 8, 657, '0', 0, 0, -10127.654296875, -2806.03466796875, 24.47814369201660156, 1.396261811256408691, 0, 0, 0.642786979675292968, 0.766044974327087402, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+46, 180471, 0, 8, 657, '0', 0, 0, -10095.8681640625, -2825.32470703125, 25.55677986145019531, 4.328419685363769531, 0, 0, -0.82903671264648437, 0.559194147586822509, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+47, 180471, 0, 8, 657, '0', 0, 0, -10133.5068359375, -2835.960205078125, 29.11954498291015625, 5.009094715118408203, 0, 0, -0.59482288360595703, 0.80385679006576538, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+48, 180471, 0, 8, 657, '0', 0, 0, -10095.236328125, -2824.06591796875, 25.34663581848144531, 4.241150379180908203, 0, 0, -0.85264015197753906, 0.522498607635498046, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+49, 180471, 0, 8, 657, '0', 0, 0, -10081.0830078125, -2809.4150390625, 28.86713409423828125, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+50, 180471, 0, 8, 657, '0', 0, 0, -10080.5849609375, -2807.34033203125, 28.87833023071289062, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+51, 180471, 0, 8, 657, '0', 0, 0, -10083.4345703125, -2811.494873046875, 27.36970329284667968, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+52, 180471, 0, 8, 657, '0', 0, 0, -10118.72265625, -2779.038330078125, 27.88197898864746093, 6.09120035171508789, 0, 0, -0.09584522247314453, 0.995396256446838378, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+53, 180471, 0, 8, 657, '0', 0, 0, -10082.56640625, -2810.41845703125, 28.24536514282226562, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+54, 180471, 0, 8, 657, '0', 0, 0, -10114.4111328125, -2780.2431640625, 28.54372596740722656, 6.073746204376220703, 0, 0, -0.10452842712402343, 0.994521915912628173, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+55, 180471, 0, 8, 657, '0', 0, 0, -10080.6884765625, -2808.36279296875, 29.28839874267578125, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+56, 180471, 0, 8, 657, '0', 0, 0, -10081.5244140625, -2805.703125, 28.20991134643554687, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+57, 180471, 0, 8, 657, '0', 0, 0, -10113.609375, -2780.46875, 27.73597145080566406, 6.003933906555175781, 0, 0, -0.13917255401611328, 0.990268170833587646, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+58, 180471, 0, 8, 657, '0', 0, 0, -10117.8994140625, -2779.28466796875, 28.65893173217773437, 6.003933906555175781, 0, 0, -0.13917255401611328, 0.990268170833587646, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+59, 180471, 0, 8, 657, '0', 0, 0, -10127.529296875, -2804.86279296875, 25.04659652709960937, 1.396261811256408691, 0, 0, 0.642786979675292968, 0.766044974327087402, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+60, 180471, 0, 8, 657, '0', 0, 0, -10112.794921875, -2780.708251953125, 26.91255760192871093, 5.026549339294433593, 0, 0, -0.5877847671508789, 0.809017360210418701, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+61, 180471, 0, 8, 657, '0', 0, 0, -10127.453125, -2804.30029296875, 25.28714942932128906, 1.396261811256408691, 0, 0, 0.642786979675292968, 0.766044974327087402, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+62, 180471, 0, 8, 657, '0', 0, 0, -10119.61328125, -2778.755126953125, 27.03598976135253906, 6.03883981704711914, 0, 0, -0.12186908721923828, 0.9925462007522583, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+63, 180471, 0, 8, 657, '0', 0, 0, -10127.5693359375, -2805.475830078125, 24.74974441528320312, 1.396261811256408691, 0, 0, 0.642786979675292968, 0.766044974327087402, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+64, 180471, 0, 8, 657, '0', 0, 0, -10081.7412109375, -2804.59716796875, 27.47439956665039062, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+65, 180472, 0, 8, 657, '0', 0, 0, -10132.4384765625, -2840.100830078125, 30.09854888916015625, 3.543023586273193359, 0, 0, -0.97992420196533203, 0.199370384216308593, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+66, 180472, 0, 8, 657, '0', 0, 0, -10126.8369140625, -2801.13720703125, 26.61779975891113281, 5.777040958404541015, 0, 0, -0.25037956237792968, 0.968147754669189453, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+67, 180523, 0, 8, 657, '0', 0, 0, -10074.67578125, -2812.694580078125, 24.3650054931640625, 3.630291461944580078, 0, 0, -0.97029495239257812, 0.241925001144409179, 120, 255, 1, 51886), -- Apple Bob (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+68, 185436, 0, 8, 657, '0', 0, 0, -10111.408203125, -2853.57470703125, 23.3415679931640625, 2.652894020080566406, 0, 0, 0.970294952392578125, 0.241925001144409179, 120, 255, 1, 51886), -- Sitting Skeleton 03 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+69, 185438, 0, 8, 657, '0', 0, 0, -10114.1474609375, -2856.921875, 23.42585182189941406, 3.543023586273193359, 0, 0, -0.97992420196533203, 0.199370384216308593, 120, 255, 1, 51886), -- Sitting Skeleton 04 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+70, 208069, 0, 8, 657, '0', 0, 0, -10108.2744140625, -2849.017333984375, 23.70523834228515625, 4.415683269500732421, 0, 0, -0.80385684967041015, 0.594822824001312255, 120, 255, 1, 51886), -- G_Pumpkin_02 Scale 0.5 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+71, 208069, 0, 8, 657, '0', 0, 0, -10090.265625, -2824.23095703125, 24.54078292846679687, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 51886), -- G_Pumpkin_02 Scale 0.5 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+72, 208072, 0, 8, 657, '0', 0, 0, -10107.017578125, -2847.829833984375, 23.70223617553710937, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, 51886), -- G_Pumpkin_03 Scale 0.5 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+73, 208078, 0, 8, 657, '0', 0, 0, -10107.9658203125, -2850.2587890625, 24.49096107482910156, 4.991643905639648437, 0, 0, -0.60181427001953125, 0.798636078834533691, 120, 255, 1, 51886), -- G_Pumpkin_01 scale 0.5 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+74, 208078, 0, 8, 657, '0', 0, 0, -10121.060546875, -2810.092041015625, 22.4989471435546875, 1.832594871520996093, 0, 0, 0.793353080749511718, 0.608761727809906005, 120, 255, 1, 51886), -- G_Pumpkin_01 scale 0.5 (Area: The Harborage - Difficulty: 0) CreateObject1
+(@OGUID+75, 208126, 0, 8, 657, '0', 0, 0, -10077.390625, -2806.921875, 24.0789031982421875, 4.782202720642089843, 0, 0, -0.68199825286865234, 0.731353819370269775, 120, 255, 1, 51886); -- Candy Bucket (Area: The Harborage - Difficulty: 0) CreateObject1
+
+-- Event spawns
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+75;
+INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES
+(12, @OGUID+0),
+(12, @OGUID+1),
+(12, @OGUID+2),
+(12, @OGUID+3),
+(12, @OGUID+4),
+(12, @OGUID+5),
+(12, @OGUID+6),
+(12, @OGUID+7),
+(12, @OGUID+8),
+(12, @OGUID+9),
+(12, @OGUID+10),
+(12, @OGUID+11),
+(12, @OGUID+12),
+(12, @OGUID+13),
+(12, @OGUID+14),
+(12, @OGUID+15),
+(12, @OGUID+16),
+(12, @OGUID+17),
+(12, @OGUID+18),
+(12, @OGUID+19),
+(12, @OGUID+20),
+(12, @OGUID+21),
+(12, @OGUID+22),
+(12, @OGUID+23),
+(12, @OGUID+24),
+(12, @OGUID+25),
+(12, @OGUID+26),
+(12, @OGUID+27),
+(12, @OGUID+28),
+(12, @OGUID+29),
+(12, @OGUID+30),
+(12, @OGUID+31),
+(12, @OGUID+32),
+(12, @OGUID+33),
+(12, @OGUID+34),
+(12, @OGUID+35),
+(12, @OGUID+36),
+(12, @OGUID+37),
+(12, @OGUID+38),
+(12, @OGUID+39),
+(12, @OGUID+40),
+(12, @OGUID+41),
+(12, @OGUID+42),
+(12, @OGUID+43),
+(12, @OGUID+44),
+(12, @OGUID+45),
+(12, @OGUID+46),
+(12, @OGUID+47),
+(12, @OGUID+48),
+(12, @OGUID+49),
+(12, @OGUID+50),
+(12, @OGUID+51),
+(12, @OGUID+52),
+(12, @OGUID+53),
+(12, @OGUID+54),
+(12, @OGUID+55),
+(12, @OGUID+56),
+(12, @OGUID+57),
+(12, @OGUID+58),
+(12, @OGUID+59),
+(12, @OGUID+60),
+(12, @OGUID+61),
+(12, @OGUID+62),
+(12, @OGUID+63),
+(12, @OGUID+64),
+(12, @OGUID+65),
+(12, @OGUID+66),
+(12, @OGUID+67),
+(12, @OGUID+68),
+(12, @OGUID+69),
+(12, @OGUID+70),
+(12, @OGUID+71),
+(12, @OGUID+72),
+(12, @OGUID+73),
+(12, @OGUID+74),
+(12, @OGUID+75);