aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat
-rw-r--r--sql/updates/world/master/2022_11_11_25_world_southern_barrens_hunters_hill.sql155
-rw-r--r--sql/updates/world/master/2022_11_11_26_world_southern_barrens_desolation_hold.sql237
-rw-r--r--sql/updates/world/master/2022_11_11_27_world_southern_barrens_honors_stand.sql289
-rw-r--r--sql/updates/world/master/2022_11_11_28_world_southern_barrens_northwatch_hold.sql197
-rw-r--r--sql/updates/world/master/2022_11_11_29_world_southern_barrens_fort_triumph.sql183
5 files changed, 1061 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_11_11_25_world_southern_barrens_hunters_hill.sql b/sql/updates/world/master/2022_11_11_25_world_southern_barrens_hunters_hill.sql
new file mode 100644
index 00000000000..f077bbd0e75
--- /dev/null
+++ b/sql/updates/world/master/2022_11_11_25_world_southern_barrens_hunters_hill.sql
@@ -0,0 +1,155 @@
+SET @OGUID := 247051;
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=46366 WHERE `entry`=208167; -- Candy Bucket
+
+UPDATE `gameobject_template_addon` SET `faction`=1735 WHERE `entry`=208167; -- Candy Bucket
+
+-- Quests
+UPDATE `quest_offer_reward` SET `VerifiedBuild`=46366 WHERE `ID`=29004;
+
+DELETE FROM `gameobject_queststarter` WHERE `id`=208167;
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(208167, 29004, 46366);
+
+UPDATE `gameobject_questender` SET `VerifiedBuild`=46366 WHERE (`id`=208167 AND `quest`=29004);
+
+DELETE FROM `game_event_gameobject_quest` WHERE `id`=208167;
+
+-- Old gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 228358 AND 228468;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 228358 AND 228468;
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+62;
+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, 1, 4709, 4844, '0', 0, 0, -780.2257080078125, -1588.5052490234375, 140.046356201171875, 4.206246376037597656, 0, 0, -0.86162853240966796, 0.50753939151763916, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+1, 180405, 1, 4709, 4844, '0', 0, 0, -750.79864501953125, -1566.5885009765625, 150.9069366455078125, 2.426007747650146484, 0, 0, 0.936672210693359375, 0.350207358598709106, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+2, 180406, 1, 4709, 4844, '0', 0, 0, -782.5555419921875, -1557.8228759765625, 140.746795654296875, 6.248279094696044921, 0, 0, -0.01745223999023437, 0.999847710132598876, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+3, 180406, 1, 4709, 4844, '0', 0, 0, -752.5086669921875, -1550.1666259765625, 151.7748565673828125, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+4, 180407, 1, 4709, 4844, '0', 0, 0, -850.11285400390625, -1550.7586669921875, 140.572540283203125, 4.48549652099609375, 0, 0, -0.7826080322265625, 0.622514784336090087, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+5, 180407, 1, 4709, 4844, '0', 0, 0, -812.1944580078125, -1581.65283203125, 140.6716766357421875, 1.169368624687194824, 0, 0, 0.551936149597167968, 0.833886384963989257, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+6, 180411, 1, 4709, 4844, '0', 0, 0, -851.79168701171875, -1554.7135009765625, 145.8445587158203125, 5.759587764739990234, 0, 0, -0.25881862640380859, 0.965925931930541992, 120, 255, 1, 46366), -- G_Ghost_01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+7, 180411, 1, 4709, 4844, '0', 0, 0, -798.40972900390625, -1597.951416015625, 156.953857421875, 5.567600727081298828, 0, 0, -0.35020732879638671, 0.936672210693359375, 120, 255, 1, 46366), -- G_Ghost_01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+8, 180411, 1, 4709, 4844, '0', 0, 0, -797.06768798828125, -1598.517333984375, 159.5470428466796875, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 120, 255, 1, 46366), -- G_Ghost_01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+9, 180426, 1, 4709, 4844, '0', 0, 0, -791.15972900390625, -1568.638916015625, 140.4574737548828125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+10, 180426, 1, 4709, 4844, '0', 0, 0, -770.015625, -1564.65625, 155.4967803955078125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+11, 180426, 1, 4709, 4844, '0', 0, 0, -798.53472900390625, -1560.3541259765625, 152.3035430908203125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+12, 180426, 1, 4709, 4844, '0', 0, 0, -827.03643798828125, -1546.6129150390625, 148.2694244384765625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+13, 180427, 1, 4709, 4844, '0', 0, 0, -783.98785400390625, -1577.6475830078125, 156.5675811767578125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+14, 180427, 1, 4709, 4844, '0', 0, 0, -791.20489501953125, -1579.140625, 155.5786895751953125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+15, 180427, 1, 4709, 4844, '0', 0, 0, -819.2586669921875, -1573.6978759765625, 156.0238189697265625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+16, 180471, 1, 4709, 4844, '0', 0, 0, -848.05902099609375, -1558.2379150390625, 149.4134063720703125, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+17, 180471, 1, 4709, 4844, '0', 0, 0, -790.88018798828125, -1601.2847900390625, 163.1481781005859375, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+18, 180471, 1, 4709, 4844, '0', 0, 0, -803.732666015625, -1602.6754150390625, 162.3044281005859375, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+19, 180471, 1, 4709, 4844, '0', 0, 0, -792.7742919921875, -1601.5052490234375, 147.989990234375, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+20, 180471, 1, 4709, 4844, '0', 0, 0, -848.05902099609375, -1558.2379150390625, 150.95782470703125, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+21, 180471, 1, 4709, 4844, '0', 0, 0, -849.21875, -1551.4566650390625, 151.493255615234375, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+22, 180471, 1, 4709, 4844, '0', 0, 0, -802.72393798828125, -1602.5867919921875, 162.3044281005859375, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+23, 180471, 1, 4709, 4844, '0', 0, 0, -793.80206298828125, -1601.6302490234375, 163.02349853515625, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+24, 180471, 1, 4709, 4844, '0', 0, 0, -802.86114501953125, -1602.328125, 148.2725067138671875, 2.967041015625, 0, 0, 0.996193885803222656, 0.087165042757987976, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+25, 180471, 1, 4709, 4844, '0', 0, 0, -802.72393798828125, -1602.5867919921875, 159.049407958984375, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+26, 180471, 1, 4709, 4844, '0', 0, 0, -792.79339599609375, -1601.4930419921875, 163.0238800048828125, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+27, 180471, 1, 4709, 4844, '0', 0, 0, -793.80206298828125, -1601.6302490234375, 161.445465087890625, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+28, 180471, 1, 4709, 4844, '0', 0, 0, -849.5538330078125, -1550.3228759765625, 149.93487548828125, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+29, 180471, 1, 4709, 4844, '0', 0, 0, -791.84027099609375, -1601.4010009765625, 159.981964111328125, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+30, 180471, 1, 4709, 4844, '0', 0, 0, -803.732666015625, -1602.6754150390625, 160.6835479736328125, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+31, 180471, 1, 4709, 4844, '0', 0, 0, -847.90625, -1559.1788330078125, 147.694122314453125, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+32, 180471, 1, 4709, 4844, '0', 0, 0, -801.85418701171875, -1602.5103759765625, 160.7234649658203125, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+33, 180471, 1, 4709, 4844, '0', 0, 0, -801.85418701171875, -1602.5103759765625, 162.3044281005859375, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+34, 180471, 1, 4709, 4844, '0', 0, 0, -793.8125, -1601.576416015625, 147.989990234375, 2.967041015625, 0, 0, 0.996193885803222656, 0.087165042757987976, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+35, 180471, 1, 4709, 4844, '0', 0, 0, -803.8524169921875, -1602.435791015625, 148.587799072265625, 2.967041015625, 0, 0, 0.996193885803222656, 0.087165042757987976, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+36, 180471, 1, 4709, 4844, '0', 0, 0, -791.84027099609375, -1601.4010009765625, 163.1481781005859375, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+37, 180471, 1, 4709, 4844, '0', 0, 0, -847.90625, -1559.1788330078125, 149.340057373046875, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+38, 180471, 1, 4709, 4844, '0', 0, 0, -791.670166015625, -1601.392333984375, 147.989990234375, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+39, 180471, 1, 4709, 4844, '0', 0, 0, -791.84027099609375, -1601.4010009765625, 161.5540924072265625, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+40, 180471, 1, 4709, 4844, '0', 0, 0, -848.27777099609375, -1557.2222900390625, 150.9782867431640625, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+41, 180471, 1, 4709, 4844, '0', 0, 0, -849.701416015625, -1549.201416015625, 151.5496826171875, 4.764749526977539062, 0, 0, -0.6883544921875, 0.725374460220336914, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+42, 180471, 1, 4709, 4844, '0', 0, 0, -803.732666015625, -1602.6754150390625, 157.3748931884765625, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+43, 180471, 1, 4709, 4844, '0', 0, 0, -801.80206298828125, -1602.2864990234375, 148.2540130615234375, 2.967041015625, 0, 0, 0.996193885803222656, 0.087165042757987976, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+44, 180471, 1, 4709, 4844, '0', 0, 0, -849.5538330078125, -1550.3228759765625, 148.281951904296875, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+45, 180471, 1, 4709, 4844, '0', 0, 0, -847.90625, -1559.1788330078125, 150.95782470703125, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+46, 180471, 1, 4709, 4844, '0', 0, 0, -803.732666015625, -1602.6754150390625, 159.0322418212890625, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+47, 180471, 1, 4709, 4844, '0', 0, 0, -802.72393798828125, -1602.5867919921875, 160.7017822265625, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+48, 180471, 1, 4709, 4844, '0', 0, 0, -800.94964599609375, -1602.4288330078125, 162.3044281005859375, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+49, 180471, 1, 4709, 4844, '0', 0, 0, -800.89581298828125, -1602.173583984375, 148.2540130615234375, 2.967041015625, 0, 0, 0.996193885803222656, 0.087165042757987976, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+50, 180471, 1, 4709, 4844, '0', 0, 0, -849.5538330078125, -1550.3228759765625, 151.5496826171875, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+51, 180471, 1, 4709, 4844, '0', 0, 0, -790.60589599609375, -1601.295166015625, 148.2319488525390625, 3.159062385559082031, 0, 0, -0.99996185302734375, 0.008734640665352344, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+52, 180471, 1, 4709, 4844, '0', 0, 0, -793.80206298828125, -1601.6302490234375, 159.8182220458984375, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+53, 180472, 1, 4709, 4844, '0', 0, 0, -790.12677001953125, -1554.3680419921875, 144.8774261474609375, 4.852017402648925781, 0, 0, -0.65605831146240234, 0.754710197448730468, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+54, 180472, 1, 4709, 4844, '0', 0, 0, -809.873291015625, -1570.2882080078125, 145.366790771484375, 0.174532130360603332, 0, 0, 0.087155342102050781, 0.996194720268249511, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+55, 180472, 1, 4709, 4844, '0', 0, 0, -816.4305419921875, -1565.236083984375, 144.4644317626953125, 1.605701684951782226, 0, 0, 0.719339370727539062, 0.694658815860748291, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+56, 180472, 1, 4709, 4844, '0', 0, 0, -823.87677001953125, -1568.85595703125, 145.3766632080078125, 2.426007747650146484, 0, 0, 0.936672210693359375, 0.350207358598709106, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+57, 180472, 1, 4709, 4844, '0', 0, 0, -810.51043701171875, -1578.407958984375, 144.5326995849609375, 0.034906249493360519, 0, 0, 0.017452239990234375, 0.999847710132598876, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+58, 180523, 1, 4709, 4844, '0', 0, 0, -779.89581298828125, -1559.529541015625, 141.1320343017578125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Apple Bob (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+59, 207736, 1, 4709, 4844, '0', 0, 0, -797.34722900390625, -1601.0225830078125, 145.6876983642578125, 1.745326757431030273, 0, 0, 0.766043663024902343, 0.642788589000701904, 120, 255, 1, 46366), -- G_HangingSkeleton_01 (Scale 2) (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+60, 207941, 1, 4709, 4844, '0', 0, 0, -849.14581298828125, -1554.4010009765625, 154.8351593017578125, 4.939284324645996093, 0, 0, -0.6225137710571289, 0.78260880708694458, 120, 255, 1, 46366), -- G_WitchHat_01 scale 2.0 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+61, 208058, 1, 4709, 4844, '0', 0, 0, -797.52081298828125, -1601.9271240234375, 167.2177276611328125, 3.595378875732421875, 0, 0, -0.97437000274658203, 0.224951311945915222, 120, 255, 1, 46366), -- G_Pumpkin_01 Scale 3.0 (Area: Hunter's Hill - Difficulty: 0)
+(@OGUID+62, 208167, 1, 4709, 4844, '0', 0, 0, -788.78643798828125, -1556.1041259765625, 140.9464111328125, 0.122172988951206207, 0, 0, 0.061048507690429687, 0.998134791851043701, 120, 255, 1, 46366); -- Candy Bucket (Area: Hunter's Hill - Difficulty: 0)
+
+-- Event spawns
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+62;
+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);
diff --git a/sql/updates/world/master/2022_11_11_26_world_southern_barrens_desolation_hold.sql b/sql/updates/world/master/2022_11_11_26_world_southern_barrens_desolation_hold.sql
new file mode 100644
index 00000000000..9ad1b83f13e
--- /dev/null
+++ b/sql/updates/world/master/2022_11_11_26_world_southern_barrens_desolation_hold.sql
@@ -0,0 +1,237 @@
+SET @CGUID := 396408;
+SET @OGUID := 247114;
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=46366 WHERE `entry`=208168; -- Candy Bucket
+
+UPDATE `gameobject_template_addon` SET `faction`=1735 WHERE `entry`=208168; -- Candy Bucket
+
+-- Quests
+UPDATE `quest_offer_reward` SET `VerifiedBuild`=46366 WHERE `ID`=29005;
+
+DELETE FROM `gameobject_queststarter` WHERE `id`=208168;
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(208168, 29005, 46366);
+
+UPDATE `gameobject_questender` SET `VerifiedBuild`=46366 WHERE (`id`=208168 AND `quest`=29005);
+
+DELETE FROM `game_event_gameobject_quest` WHERE `id`=208168;
+
+-- Creature spawns
+DELETE FROM `creature` WHERE `guid`=@CGUID+0;
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+(@CGUID+0, 22816, 1, 4709, 4853, '0', 0, 0, 0, 0, -3212.687255859375, -1716.953369140625, 92.58986663818359375, 5.374788761138916015, 120, 10, 0, 188, 0, 1, 0, 0, 0, 46366); -- Black Cat (Area: Desolation Hold - Difficulty: 0) (possible waypoints or random movement)
+
+-- Old gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 228058 AND 228101;
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 228469 AND 228561;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 228058 AND 228101;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 228469 AND 228561;
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+97;
+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, 1, 4709, 4853, '0', 0, 0, -3285.270751953125, -1696.87158203125, 122.621063232421875, 4.572763919830322265, 0, 0, -0.75470924377441406, 0.656059443950653076, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+1, 180405, 1, 4709, 4853, '0', 0, 0, -3225.34033203125, -1673.079833984375, 99.55564117431640625, 5.759587764739990234, 0, 0, -0.25881862640380859, 0.965925931930541992, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+2, 180405, 1, 4709, 4853, '0', 0, 0, -3205.515625, -1730.4097900390625, 93.55985260009765625, 4.241150379180908203, 0, 0, -0.85264015197753906, 0.522498607635498046, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+3, 180405, 1, 4709, 4853, '0', 0, 0, -3277.350830078125, -1826.4757080078125, 108.2657394409179687, 0.087265998125076293, 0, 0, 0.043619155883789062, 0.999048233032226562, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+4, 180405, 1, 4709, 4853, '0', 0, 0, -3235.380126953125, -1822.875, 111.28521728515625, 0.977383077144622802, 0, 0, 0.469470977783203125, 0.882947921752929687, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+5, 180405, 1, 4709, 4853, '0', 0, 0, -3165.58154296875, -1760.1597900390625, 108.2303466796875, 0.977383077144622802, 0, 0, 0.469470977783203125, 0.882947921752929687, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+6, 180406, 1, 4709, 4853, '0', 0, 0, -3300.39404296875, -1807.3125, 106.8153762817382812, 6.003933906555175781, 0, 0, -0.13917255401611328, 0.990268170833587646, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+7, 180406, 1, 4709, 4853, '0', 0, 0, -3286.958251953125, -1824.9375, 111.0849761962890625, 6.09120035171508789, 0, 0, -0.09584522247314453, 0.995396256446838378, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+8, 180406, 1, 4709, 4853, '0', 0, 0, -3253.84033203125, -1827.5867919921875, 109.5627212524414062, 0.663223206996917724, 0, 0, 0.325567245483398437, 0.945518851280212402, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+9, 180406, 1, 4709, 4853, '0', 0, 0, -3172.810791015625, -1740.1041259765625, 105.3613967895507812, 2.251473426818847656, 0, 0, 0.902585029602050781, 0.430511653423309326, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+10, 180407, 1, 4709, 4853, '0', 0, 0, -3299.045166015625, -1687.435791015625, 123.2102432250976562, 1.169368624687194824, 0, 0, 0.551936149597167968, 0.833886384963989257, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+11, 180407, 1, 4709, 4853, '0', 0, 0, -3312.62841796875, -1762.4600830078125, 110.1776275634765625, 2.024578809738159179, 0, 0, 0.848047256469726562, 0.529920578002929687, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+12, 180407, 1, 4709, 4853, '0', 0, 0, -3234.895751953125, -1763.54345703125, 92.8831024169921875, 3.717553615570068359, 0, 0, -0.95881938934326171, 0.284016460180282592, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+13, 180407, 1, 4709, 4853, '0', 0, 0, -3293.59375, -1816.6197509765625, 107.994781494140625, 5.969027042388916015, 0, 0, -0.1564340591430664, 0.987688362598419189, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+14, 180407, 1, 4709, 4853, '0', 0, 0, -3265.182373046875, -1828.611083984375, 110.5107803344726562, 6.248279094696044921, 0, 0, -0.01745223999023437, 0.999847710132598876, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+15, 180407, 1, 4709, 4853, '0', 0, 0, -3242.694580078125, -1825.3228759765625, 112.7970428466796875, 6.248279094696044921, 0, 0, -0.01745223999023437, 0.999847710132598876, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+16, 180407, 1, 4709, 4853, '0', 0, 0, -3179.6025390625, -1771.0625, 108.2389907836914062, 6.248279094696044921, 0, 0, -0.01745223999023437, 0.999847710132598876, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+17, 180408, 1, 4709, 4853, '0', 0, 0, -3225.350830078125, -1673.125, 101.1752700805664062, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- G_WitchHat_01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+18, 180414, 1, 4709, 4853, '0', 0, 0, -3225.7431640625, -1675.34033203125, 99.38809967041015625, 4.049167633056640625, 0, 0, -0.89879322052001953, 0.438372820615768432, 120, 255, 1, 46366), -- Cauldron (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+19, 180415, 1, 4709, 4853, '0', 0, 0, -3306.885498046875, -1685.6927490234375, 126.5540771484375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+20, 180415, 1, 4709, 4853, '0', 0, 0, -3305.55029296875, -1687.53125, 124.7850723266601562, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+21, 180415, 1, 4709, 4853, '0', 0, 0, -3304.8681640625, -1686.078125, 126.5790481567382812, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+22, 180415, 1, 4709, 4853, '0', 0, 0, -3301.927001953125, -1688.6041259765625, 123.9581985473632812, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+23, 180415, 1, 4709, 4853, '0', 0, 0, -3251.529541015625, -1718.2135009765625, 94.33170318603515625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+24, 180415, 1, 4709, 4853, '0', 0, 0, -3251.404541015625, -1720.295166015625, 93.37094879150390625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+25, 180415, 1, 4709, 4853, '0', 0, 0, -3250.600830078125, -1719.109375, 93.2472991943359375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+26, 180415, 1, 4709, 4853, '0', 0, 0, -3253.302001953125, -1719.654541015625, 93.736968994140625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+27, 180415, 1, 4709, 4853, '0', 0, 0, -3250.861083984375, -1717.310791015625, 93.6382293701171875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+28, 180415, 1, 4709, 4853, '0', 0, 0, -3222.850830078125, -1675.4635009765625, 100.8471527099609375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+29, 180415, 1, 4709, 4853, '0', 0, 0, -3230.9462890625, -1667.204833984375, 101.4241867065429687, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+30, 180415, 1, 4709, 4853, '0', 0, 0, -3224.37841796875, -1676.55908203125, 100.4570999145507812, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+31, 180415, 1, 4709, 4853, '0', 0, 0, -3222.501708984375, -1677.26220703125, 101.340606689453125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+32, 180425, 1, 4709, 4853, '0', 0, 0, -3231.09033203125, -1668.1441650390625, 101.4788665771484375, 4.118979454040527343, 0, 0, -0.88294696807861328, 0.469472706317901611, 120, 255, 1, 46366), -- SkullCandle01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+33, 180426, 1, 4709, 4853, '0', 0, 0, -3291.296875, -1712.8507080078125, 133.992767333984375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+34, 180426, 1, 4709, 4853, '0', 0, 0, -3312.411376953125, -1735.7708740234375, 122.8666305541992187, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+35, 180426, 1, 4709, 4853, '0', 0, 0, -3264.741455078125, -1681.3507080078125, 131.1856231689453125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+36, 180426, 1, 4709, 4853, '0', 0, 0, -3258.257080078125, -1756.63720703125, 92.6760406494140625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+37, 180426, 1, 4709, 4853, '0', 0, 0, -3237.61279296875, -1745.001708984375, 92.21099090576171875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+38, 180426, 1, 4709, 4853, '0', 0, 0, -3223.882080078125, -1721.6041259765625, 92.36252593994140625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+39, 180426, 1, 4709, 4853, '0', 0, 0, -3228.546875, -1698.295166015625, 95.91880035400390625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+40, 180426, 1, 4709, 4853, '0', 0, 0, -3241.640625, -1741.5347900390625, 91.913604736328125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+41, 180426, 1, 4709, 4853, '0', 0, 0, -3241.385498046875, -1811.6197509765625, 111.3460235595703125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+42, 180426, 1, 4709, 4853, '0', 0, 0, -3265.614501953125, -1813.876708984375, 114.1769866943359375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+43, 180426, 1, 4709, 4853, '0', 0, 0, -3257.111083984375, -1815.2742919921875, 111.8281021118164062, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+44, 180426, 1, 4709, 4853, '0', 0, 0, -3178.078125, -1761.3211669921875, 107.1629409790039062, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+45, 180426, 1, 4709, 4853, '0', 0, 0, -3167.72216796875, -1753.920166015625, 107.0633316040039062, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+46, 180426, 1, 4709, 4853, '0', 0, 0, -3159.532958984375, -1742.923583984375, 101.4036636352539062, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+47, 180427, 1, 4709, 4853, '0', 0, 0, -3296.62158203125, -1728.8489990234375, 135.3777618408203125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+48, 180427, 1, 4709, 4853, '0', 0, 0, -3266.744873046875, -1698.1978759765625, 136.9410247802734375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+49, 180427, 1, 4709, 4853, '0', 0, 0, -3218.366455078125, -1715.9149169921875, 92.38958740234375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+50, 180427, 1, 4709, 4853, '0', 0, 0, -3239.59375, -1745.453125, 92.0661468505859375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+51, 180427, 1, 4709, 4853, '0', 0, 0, -3229.7744140625, -1717.592041015625, 121.7616806030273437, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+52, 180427, 1, 4709, 4853, '0', 0, 0, -3220.48779296875, -1710.4461669921875, 111.5846786499023437, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+53, 180427, 1, 4709, 4853, '0', 0, 0, -3241.69091796875, -1744.5364990234375, 91.9067840576171875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+54, 180427, 1, 4709, 4853, '0', 0, 0, -3260.239501953125, -1755.421875, 113.8280029296875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+55, 180427, 1, 4709, 4853, '0', 0, 0, -3259.647705078125, -1825.55908203125, 99.44490814208984375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+56, 180427, 1, 4709, 4853, '0', 0, 0, -3192.26220703125, -1790.701416015625, 92.13677978515625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+57, 180427, 1, 4709, 4853, '0', 0, 0, -3164.078125, -1768.7882080078125, 95.17014312744140625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+58, 180471, 1, 4709, 4853, '0', 0, 0, -3288.647705078125, -1679.5399169921875, 141.6427001953125, 0.715584874153137207, 0, 0, 0.350207328796386718, 0.936672210693359375, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+59, 180471, 1, 4709, 4853, '0', 0, 0, -3298.092041015625, -1684.8125, 141.9681396484375, 0.366517573595046997, 0, 0, 0.182234764099121093, 0.98325502872467041, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+60, 180471, 1, 4709, 4853, '0', 0, 0, -3293.210205078125, -1682.875, 141.5181884765625, 0.628316879272460937, 0, 0, 0.309016227722167968, 0.95105677843093872, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+61, 180471, 1, 4709, 4853, '0', 0, 0, -3290.1025390625, -1681.1180419921875, 141.4798583984375, 0.715584874153137207, 0, 0, 0.350207328796386718, 0.936672210693359375, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+62, 180471, 1, 4709, 4853, '0', 0, 0, -3287.296875, -1678.0225830078125, 141.8128662109375, 0.733038187026977539, 0, 0, 0.358367919921875, 0.933580458164215087, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+63, 180471, 1, 4709, 4853, '0', 0, 0, -3285.979248046875, -1676.4166259765625, 141.9869384765625, 0.802850961685180664, 0, 0, 0.390730857849121093, 0.920504987239837646, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+64, 180471, 1, 4709, 4853, '0', 0, 0, -3296.373291015625, -1684.1475830078125, 141.8131103515625, 0.401424884796142578, 0, 0, 0.199367523193359375, 0.979924798011779785, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+65, 180471, 1, 4709, 4853, '0', 0, 0, -3294.984375, -1683.5572509765625, 141.6768798828125, 0.436331570148468017, 0, 0, 0.216439247131347656, 0.976296067237854003, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+66, 180471, 1, 4709, 4853, '0', 0, 0, -3258.87158203125, -1724.0191650390625, 97.68093109130859375, 0.558503925800323486, 0, 0, 0.275636672973632812, 0.961261868476867675, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+67, 180471, 1, 4709, 4853, '0', 0, 0, -3259.975830078125, -1724.814208984375, 97.57424163818359375, 1.151916384696960449, 0, 0, 0.544638633728027343, 0.838670849800109863, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+68, 180471, 1, 4709, 4853, '0', 0, 0, -3261.34033203125, -1725.689208984375, 97.50745391845703125, 0.890116631984710693, 0, 0, 0.430510520935058593, 0.902585566043853759, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+69, 180471, 1, 4709, 4853, '0', 0, 0, -3311.97216796875, -1764.0833740234375, 129.41973876953125, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+70, 180471, 1, 4709, 4853, '0', 0, 0, -3255.640625, -1719.546875, 97.47737884521484375, 0.558503925800323486, 0, 0, 0.275636672973632812, 0.961261868476867675, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+71, 180471, 1, 4709, 4853, '0', 0, 0, -3257.057373046875, -1722.4114990234375, 97.66492462158203125, 0.942476630210876464, 0, 0, 0.453989982604980468, 0.891006767749786376, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+72, 180471, 1, 4709, 4853, '0', 0, 0, -3312.9462890625, -1762.203125, 129.5939483642578125, 2.146752834320068359, 0, 0, 0.878816604614257812, 0.477159708738327026, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+73, 180471, 1, 4709, 4853, '0', 0, 0, -3311.053955078125, -1765.8958740234375, 129.2496490478515625, 2.059488296508789062, 0, 0, 0.857167243957519531, 0.515038192272186279, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+74, 180471, 1, 4709, 4853, '0', 0, 0, -3256.388916015625, -1721.048583984375, 97.56262969970703125, 0.942476630210876464, 0, 0, 0.453989982604980468, 0.891006767749786376, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+75, 180471, 1, 4709, 4853, '0', 0, 0, -3223.928955078125, -1675.3992919921875, 119.5629730224609375, 5.672322273254394531, 0, 0, -0.3007049560546875, 0.953717231750488281, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+76, 180471, 1, 4709, 4853, '0', 0, 0, -3227.65625, -1672.9478759765625, 119.1805191040039062, 5.6897735595703125, 0, 0, -0.29237174987792968, 0.956304728984832763, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+77, 180471, 1, 4709, 4853, '0', 0, 0, -3232.092041015625, -1667.640625, 119.5213394165039062, 5.427974700927734375, 0, 0, -0.41469287872314453, 0.909961462020874023, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+78, 180471, 1, 4709, 4853, '0', 0, 0, -3308.90966796875, -1776.4879150390625, 129.5751495361328125, 1.710421562194824218, 0, 0, 0.754709243774414062, 0.656059443950653076, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+79, 180471, 1, 4709, 4853, '0', 0, 0, -3231.048583984375, -1669.1163330078125, 119.362060546875, 5.480334281921386718, 0, 0, -0.39073085784912109, 0.920504987239837646, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+80, 180471, 1, 4709, 4853, '0', 0, 0, -3222.2119140625, -1676.46875, 119.72918701171875, 5.619962215423583984, 0, 0, -0.32556724548339843, 0.945518851280212402, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+81, 180471, 1, 4709, 4853, '0', 0, 0, -3230.109375, -1670.5364990234375, 119.2201080322265625, 5.6897735595703125, 0, 0, -0.29237174987792968, 0.956304728984832763, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+82, 180471, 1, 4709, 4853, '0', 0, 0, -3309.265625, -1771.2569580078125, 129.1250152587890625, 1.972219824790954589, 0, 0, 0.83388519287109375, 0.55193793773651123, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+83, 180471, 1, 4709, 4853, '0', 0, 0, -3233.21533203125, -1665.8072509765625, 119.68890380859375, 5.375615119934082031, 0, 0, -0.4383707046508789, 0.898794233798980712, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+84, 180471, 1, 4709, 4853, '0', 0, 0, -3309.994873046875, -1767.7569580078125, 129.08673095703125, 2.059488296508789062, 0, 0, 0.857167243957519531, 0.515038192272186279, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+85, 180471, 1, 4709, 4853, '0', 0, 0, -3309.01904296875, -1774.654541015625, 129.4199066162109375, 1.745326757431030273, 0, 0, 0.766043663024902343, 0.642788589000701904, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+86, 180471, 1, 4709, 4853, '0', 0, 0, -3225.895751953125, -1674.1632080078125, 119.371490478515625, 5.6897735595703125, 0, 0, -0.29237174987792968, 0.956304728984832763, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+87, 180471, 1, 4709, 4853, '0', 0, 0, -3309.163330078125, -1773.1510009765625, 129.2836761474609375, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+88, 180472, 1, 4709, 4853, '0', 0, 0, -3291.5, -1681.921875, 142.7299346923828125, 5.323255538940429687, 0, 0, -0.46174812316894531, 0.887011110782623291, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+89, 180472, 1, 4709, 4853, '0', 0, 0, -3257.76904296875, -1723.3194580078125, 98.9659423828125, 5.567600727081298828, 0, 0, -0.35020732879638671, 0.936672210693359375, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+90, 180472, 1, 4709, 4853, '0', 0, 0, -3228.9375, -1671.8941650390625, 120.3505172729492187, 3.961898565292358398, 0, 0, -0.91705989837646484, 0.398749500513076782, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+91, 180472, 1, 4709, 4853, '0', 0, 0, -3309.56591796875, -1769.376708984375, 130.1752471923828125, 0.366517573595046997, 0, 0, 0.182234764099121093, 0.98325502872467041, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+92, 180523, 1, 4709, 4853, '0', 0, 0, -3217.59375, -1664.3055419921875, 100.3092422485351562, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Apple Bob (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+93, 185436, 1, 4709, 4853, '0', 0, 0, -3225.505126953125, -1675.3367919921875, 99.89443206787109375, 2.635444164276123046, 0, 0, 0.96814727783203125, 0.250381410121917724, 120, 255, 1, 46366), -- Sitting Skeleton 03 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+94, 185438, 1, 4709, 4853, '0', 0, 0, -3226.173583984375, -1675.3316650390625, 99.93881988525390625, 0.27925160527229309, 0, 0, 0.139172554016113281, 0.990268170833587646, 120, 255, 1, 46366), -- Sitting Skeleton 04 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+95, 207736, 1, 4709, 4853, '0', 0, 0, -3294.788330078125, -1676.82470703125, 122.625, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, 46366), -- G_HangingSkeleton_01 (Scale 2) (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+96, 208059, 1, 4709, 4853, '0', 0, 0, -3266.369873046875, -1715.407958984375, 108.0419235229492187, 1.186823248863220214, 0, 0, 0.559192657470703125, 0.829037725925445556, 120, 255, 1, 46366), -- G_Pumpkin_02 Scale 5.0 (Area: Desolation Hold - Difficulty: 0)
+(@OGUID+97, 208168, 1, 4709, 4853, '0', 0, 0, -3221.083251953125, -1660.970458984375, 99.90734100341796875, 5.602506637573242187, 0, 0, -0.33380699157714843, 0.942641437053680419, 120, 255, 1, 46366); -- Candy Bucket (Area: Desolation Hold - Difficulty: 0)
+
+-- Event spawns
+DELETE FROM `game_event_creature` WHERE `eventEntry`=12 AND `guid`=@CGUID+0;
+INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES
+(12, @CGUID+0);
+
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+97;
+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);
diff --git a/sql/updates/world/master/2022_11_11_27_world_southern_barrens_honors_stand.sql b/sql/updates/world/master/2022_11_11_27_world_southern_barrens_honors_stand.sql
new file mode 100644
index 00000000000..f6561db8a8e
--- /dev/null
+++ b/sql/updates/world/master/2022_11_11_27_world_southern_barrens_honors_stand.sql
@@ -0,0 +1,289 @@
+SET @CGUID := 396409;
+SET @OGUID := 247212;
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=46366 WHERE `entry`=208169; -- Candy Bucket
+
+UPDATE `gameobject_template_addon` SET `faction`=1732 WHERE `entry`=208169; -- Candy Bucket
+
+-- Quests
+DELETE FROM `quest_offer_reward` WHERE `ID`=29006;
+INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES
+(29006, 0, 0, 0, 0, 0, 0, 0, 0, 'Candy buckets like this are located in inns throughout the realms. Go ahead... take some!', 46366); -- Candy Bucket
+
+DELETE FROM `gameobject_queststarter` WHERE `id`=208169;
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(208169, 29006, 46366);
+
+UPDATE `gameobject_questender` SET `VerifiedBuild`=46366 WHERE (`id`=208169 AND `quest`=29006);
+
+DELETE FROM `game_event_gameobject_quest` WHERE `id`=208169;
+
+-- Creature spawns
+DELETE FROM `creature` WHERE `guid`=@CGUID+0;
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+(@CGUID+0, 22816, 1, 4709, 4843, '0', 0, 0, 0, 0, -449.0743408203125, -1466.06201171875, 92.0471343994140625, 0.750433623790740966, 120, 10, 0, 188, 0, 1, 0, 0, 0, 46366); -- Black Cat (Area: Honor's Stand - Difficulty: 0) (possible waypoints or random movement)
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+125;
+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, 1, 4709, 4843, '0', 0, 0, -344.352447509765625, -1540.1353759765625, 87.2408599853515625, 4.066620349884033203, 0, 0, -0.89493370056152343, 0.44619917869567871, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+1, 180405, 1, 4709, 4843, '0', 0, 0, -373.314239501953125, -1538.890625, 88.75640106201171875, 2.967041015625, 0, 0, 0.996193885803222656, 0.087165042757987976, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+2, 180405, 1, 4709, 4843, '0', 0, 0, -401.8194580078125, -1553.5052490234375, 97.94178009033203125, 4.066620349884033203, 0, 0, -0.89493370056152343, 0.44619917869567871, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+3, 180405, 1, 4709, 4843, '0', 0, 0, -484.810760498046875, -1479.90283203125, 94.94454193115234375, 1.553341388702392578, 0, 0, 0.700908660888671875, 0.713251054286956787, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+4, 180405, 1, 4709, 4843, '0', 0, 0, -477.69964599609375, -1420.2916259765625, 104.0656661987304687, 1.099556446075439453, 0, 0, 0.522498130798339843, 0.852640450000762939, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+5, 180405, 1, 4709, 4843, '0', 0, 0, -493.526031494140625, -1375.0069580078125, 103.4692306518554687, 3.769911527633666992, 0, 0, -0.95105648040771484, 0.309017121791839599, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+6, 180406, 1, 4709, 4843, '0', 0, 0, -342.44964599609375, -1501.501708984375, 88.87638092041015625, 4.188792228698730468, 0, 0, -0.86602497100830078, 0.50000077486038208, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+7, 180406, 1, 4709, 4843, '0', 0, 0, -340.954864501953125, -1515.7847900390625, 87.2365875244140625, 5.794494152069091796, 0, 0, -0.24192142486572265, 0.970295846462249755, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+8, 180406, 1, 4709, 4843, '0', 0, 0, -375.515625, -1536.142333984375, 88.71193695068359375, 3.420850038528442382, 0, 0, -0.99026775360107421, 0.139175355434417724, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+9, 180406, 1, 4709, 4843, '0', 0, 0, -424.859375, -1555.40625, 92.2329864501953125, 5.393068790435791015, 0, 0, -0.43051052093505859, 0.902585566043853759, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+10, 180406, 1, 4709, 4843, '0', 0, 0, -516.01043701171875, -1409.640625, 103.4674835205078125, 5.585053920745849609, 0, 0, -0.34202003479003906, 0.939692676067352294, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+11, 180406, 1, 4709, 4843, '0', 0, 0, -470.395843505859375, -1389.8819580078125, 103.4685592651367187, 2.617989301681518554, 0, 0, 0.965925216674804687, 0.258821308612823486, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+12, 180407, 1, 4709, 4843, '0', 0, 0, -345.463531494140625, -1503.9410400390625, 88.76609039306640625, 4.380776405334472656, 0, 0, -0.81411552429199218, 0.580702960491180419, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+13, 180407, 1, 4709, 4843, '0', 0, 0, -386.80902099609375, -1545.8367919921875, 97.9417266845703125, 3.961898565292358398, 0, 0, -0.91705989837646484, 0.398749500513076782, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+14, 180407, 1, 4709, 4843, '0', 0, 0, -428.109375, -1542.2117919921875, 92.43253326416015625, 5.078907966613769531, 0, 0, -0.56640625, 0.824126183986663818, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+15, 180407, 1, 4709, 4843, '0', 0, 0, -483.3038330078125, -1474.3663330078125, 95.17174530029296875, 2.111847877502441406, 0, 0, 0.870355606079101562, 0.492423713207244873, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+16, 180407, 1, 4709, 4843, '0', 0, 0, -492.696197509765625, -1424.501708984375, 103.4610366821289062, 0.366517573595046997, 0, 0, 0.182234764099121093, 0.98325502872467041, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+17, 180407, 1, 4709, 4843, '0', 0, 0, -468.213531494140625, -1405.888916015625, 104.0657119750976562, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+18, 180407, 1, 4709, 4843, '0', 0, 0, -514.3194580078125, -1386.25, 103.4694137573242187, 4.764749526977539062, 0, 0, -0.6883544921875, 0.725374460220336914, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+19, 180410, 1, 4709, 4843, '0', 0, 0, -381.258697509765625, -1540.9774169921875, 87.3762359619140625, 1.431168079376220703, 0, 0, 0.656058311462402343, 0.754710197448730468, 120, 255, 1, 46366), -- G_HangingSkeleton_01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+20, 180411, 1, 4709, 4843, '0', 0, 0, -487.161468505859375, -1467.9913330078125, 98.11215972900390625, 3.665196180343627929, 0, 0, -0.96592521667480468, 0.258821308612823486, 120, 255, 1, 46366), -- G_Ghost_01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+21, 180414, 1, 4709, 4843, '0', 0, 0, -487.3350830078125, -1467.7864990234375, 94.28156280517578125, 1.256635904312133789, 0, 0, 0.587784767150878906, 0.809017360210418701, 120, 255, 1, 46366), -- Cauldron (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+22, 180415, 1, 4709, 4843, '0', 0, 0, -339.782989501953125, -1537.4879150390625, 87.25281524658203125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+23, 180415, 1, 4709, 4843, '0', 0, 0, -338.86285400390625, -1537.5103759765625, 88.9371337890625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+24, 180415, 1, 4709, 4843, '0', 0, 0, -388.864593505859375, -1532.46533203125, 87.82769012451171875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+25, 180415, 1, 4709, 4843, '0', 0, 0, -388.529510498046875, -1534.5191650390625, 88.5606231689453125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+26, 180415, 1, 4709, 4843, '0', 0, 0, -388.064239501953125, -1537.125, 89.49372100830078125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+27, 180415, 1, 4709, 4843, '0', 0, 0, -387.680572509765625, -1539.2447509765625, 90.24883270263671875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+28, 180415, 1, 4709, 4843, '0', 0, 0, -387.23089599609375, -1541.0242919921875, 90.89581298828125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+29, 180415, 1, 4709, 4843, '0', 0, 0, -411.3125, -1544.5711669921875, 87.98502349853515625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+30, 180415, 1, 4709, 4843, '0', 0, 0, -405.14410400390625, -1550.482666015625, 90.95931243896484375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+31, 180415, 1, 4709, 4843, '0', 0, 0, -407.736114501953125, -1547.8004150390625, 89.6524505615234375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+32, 180415, 1, 4709, 4843, '0', 0, 0, -406.619781494140625, -1549.1475830078125, 90.2681121826171875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+33, 180415, 1, 4709, 4843, '0', 0, 0, -409.739593505859375, -1546.0728759765625, 88.7382659912109375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+34, 180415, 1, 4709, 4843, '0', 0, 0, -470.736114501953125, -1429.0382080078125, 94.76062774658203125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+35, 180415, 1, 4709, 4843, '0', 0, 0, -474.774322509765625, -1424.0885009765625, 97.00070953369140625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+36, 180415, 1, 4709, 4843, '0', 0, 0, -473.583343505859375, -1425.392333984375, 96.3792877197265625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+37, 180415, 1, 4709, 4843, '0', 0, 0, -472.329864501953125, -1427.0364990234375, 95.658447265625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+38, 180415, 1, 4709, 4843, '0', 0, 0, -460.227447509765625, -1407.8316650390625, 95.7776947021484375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+39, 180415, 1, 4709, 4843, '0', 0, 0, -457.704864501953125, -1408.54345703125, 94.8620758056640625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+40, 180415, 1, 4709, 4843, '0', 0, 0, -461.99652099609375, -1407.314208984375, 96.4232635498046875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+41, 180415, 1, 4709, 4843, '0', 0, 0, -463.74652099609375, -1406.9322509765625, 97.04463958740234375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+42, 180425, 1, 4709, 4843, '0', 0, 0, -340.111114501953125, -1538.3350830078125, 87.99057769775390625, 2.583080768585205078, 0, 0, 0.961260795593261718, 0.275640487670898437, 120, 255, 1, 46366), -- SkullCandle01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+43, 180426, 1, 4709, 4843, '0', 0, 0, -424.677093505859375, -1495.876708984375, 91.25925445556640625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+44, 180426, 1, 4709, 4843, '0', 0, 0, -412.9288330078125, -1449.045166015625, 94.052642822265625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+45, 180426, 1, 4709, 4843, '0', 0, 0, -399.828125, -1428.5555419921875, 95.392852783203125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+46, 180426, 1, 4709, 4843, '0', 0, 0, -455.1163330078125, -1458.03125, 96.65770721435546875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+47, 180426, 1, 4709, 4843, '0', 0, 0, -432.789947509765625, -1431.9132080078125, 97.1610107421875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+48, 180426, 1, 4709, 4843, '0', 0, 0, -404.376739501953125, -1397.388916015625, 95.86664581298828125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+49, 180426, 1, 4709, 4843, '0', 0, 0, -448.138885498046875, -1468.4375, 94.456085205078125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+50, 180426, 1, 4709, 4843, '0', 0, 0, -434.46875, -1426.09033203125, 97.520416259765625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+51, 180426, 1, 4709, 4843, '0', 0, 0, -398.82464599609375, -1400.77783203125, 95.35594940185546875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+52, 180426, 1, 4709, 4843, '0', 0, 0, -414.829864501953125, -1389.16845703125, 96.92046356201171875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+53, 180426, 1, 4709, 4843, '0', 0, 0, -426.1875, -1436.0833740234375, 95.85826873779296875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+54, 180426, 1, 4709, 4843, '0', 0, 0, -394.942718505859375, -1360.6197509765625, 94.63848114013671875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+55, 180427, 1, 4709, 4843, '0', 0, 0, -417.78472900390625, -1487.4930419921875, 91.27526092529296875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+56, 180427, 1, 4709, 4843, '0', 0, 0, -409.40625, -1516.3316650390625, 89.78594207763671875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+57, 180427, 1, 4709, 4843, '0', 0, 0, -408.345489501953125, -1463.8785400390625, 91.88300323486328125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+58, 180427, 1, 4709, 4843, '0', 0, 0, -404.65972900390625, -1444.90625, 94.20061492919921875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+59, 180427, 1, 4709, 4843, '0', 0, 0, -441.227447509765625, -1481.6822509765625, 93.90219879150390625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+60, 180427, 1, 4709, 4843, '0', 0, 0, -449.4444580078125, -1503.079833984375, 92.60198211669921875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+61, 180427, 1, 4709, 4843, '0', 0, 0, -390.454864501953125, -1384.0885009765625, 94.99570465087890625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+62, 180427, 1, 4709, 4843, '0', 0, 0, -449.111114501953125, -1463.1353759765625, 95.28435516357421875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+63, 180427, 1, 4709, 4843, '0', 0, 0, -398.102447509765625, -1403.8472900390625, 95.36516571044921875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+64, 180427, 1, 4709, 4843, '0', 0, 0, -426.6944580078125, -1429.0625, 97.25103759765625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+65, 180471, 1, 4709, 4843, '0', 0, 0, -382.7413330078125, -1558.4478759765625, 108.34490966796875, 3.263772249221801757, 0, 0, -0.99813461303710937, 0.061051756143569946, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+66, 180471, 1, 4709, 4843, '0', 0, 0, -370.53125, -1571.048583984375, 108.3351669311523437, 1.710421562194824218, 0, 0, 0.754709243774414062, 0.656059443950653076, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+67, 180471, 1, 4709, 4843, '0', 0, 0, -370.5225830078125, -1569.5538330078125, 108.345947265625, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+68, 180471, 1, 4709, 4843, '0', 0, 0, -374.407989501953125, -1580.078125, 108.34490966796875, 0.925023794174194335, 0, 0, 0.446197509765625, 0.894934535026550292, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+69, 180471, 1, 4709, 4843, '0', 0, 0, -373.3038330078125, -1579.0711669921875, 108.345947265625, 0.994837164878845214, 0, 0, 0.477158546447753906, 0.878817260265350341, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+70, 180471, 1, 4709, 4843, '0', 0, 0, -376.39410400390625, -1560.3367919921875, 108.344970703125, 2.530723094940185546, 0, 0, 0.953716278076171875, 0.300707906484603881, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+71, 180471, 1, 4709, 4843, '0', 0, 0, -385.638885498046875, -1558.6510009765625, 108.344970703125, 3.316144466400146484, 0, 0, -0.99619388580322265, 0.087165042757987976, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+72, 180471, 1, 4709, 4843, '0', 0, 0, -374.083343505859375, -1562.126708984375, 108.3351669311523437, 2.495818138122558593, 0, 0, 0.948323249816894531, 0.317305892705917358, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+73, 180471, 1, 4709, 4843, '0', 0, 0, -372.640625, -1577.76220703125, 108.344970703125, 0.942476630210876464, 0, 0, 0.453989982604980468, 0.891006767749786376, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+74, 180471, 1, 4709, 4843, '0', 0, 0, -375.118072509765625, -1561.0399169921875, 108.345947265625, 2.565631866455078125, 0, 0, 0.958819389343261718, 0.284016460180282592, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+75, 180471, 1, 4709, 4843, '0', 0, 0, -370.96875, -1568.157958984375, 108.344970703125, 1.727874636650085449, 0, 0, 0.760405540466308593, 0.649448513984680175, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+76, 180471, 1, 4709, 4843, '0', 0, 0, -384.229156494140625, -1558.28125, 108.345947265625, 3.333590030670166015, 0, 0, -0.99539566040039062, 0.095851235091686248, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+77, 180471, 1, 4709, 4843, '0', 0, 0, -390.149322509765625, -1581.4739990234375, 108.344970703125, 5.6897735595703125, 0, 0, -0.29237174987792968, 0.956304728984832763, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+78, 180471, 1, 4709, 4843, '0', 0, 0, -383.5850830078125, -1583.7117919921875, 108.34490966796875, 0.15707901120185852, 0, 0, 0.078458786010742187, 0.996917366981506347, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+79, 180471, 1, 4709, 4843, '0', 0, 0, -393.670135498046875, -1564.107666015625, 108.344970703125, 4.084071159362792968, 0, 0, -0.8910064697265625, 0.453990638256072998, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+80, 180471, 1, 4709, 4843, '0', 0, 0, -382.09375, -1583.7916259765625, 108.345947265625, 0.24434557557106018, 0, 0, 0.121869087219238281, 0.9925462007522583, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+81, 180471, 1, 4709, 4843, '0', 0, 0, -380.697906494140625, -1583.3507080078125, 108.344970703125, 0.209439441561698913, 0, 0, 0.104528427124023437, 0.994521915912628173, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+82, 180471, 1, 4709, 4843, '0', 0, 0, -392.414947509765625, -1579.6441650390625, 108.34490966796875, 5.637413978576660156, 0, 0, -0.31730461120605468, 0.948323667049407958, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+83, 180471, 1, 4709, 4843, '0', 0, 0, -391.857635498046875, -1561.84033203125, 108.34490966796875, 4.066620349884033203, 0, 0, -0.89493370056152343, 0.44619917869567871, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+84, 180471, 1, 4709, 4843, '0', 0, 0, -395.885406494140625, -1572.01220703125, 108.345947265625, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+85, 180471, 1, 4709, 4843, '0', 0, 0, -391.439239501953125, -1580.77783203125, 108.345947265625, 5.70722818374633789, 0, 0, -0.28401470184326171, 0.958819925785064697, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+86, 180471, 1, 4709, 4843, '0', 0, 0, -395.76910400390625, -1570.5225830078125, 108.34490966796875, 4.817109584808349609, 0, 0, -0.66913032531738281, 0.74314504861831665, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+87, 180471, 1, 4709, 4843, '0', 0, 0, -395.473968505859375, -1573.4132080078125, 108.344970703125, 4.834563255310058593, 0, 0, -0.66261959075927734, 0.748956084251403808, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+88, 180471, 1, 4709, 4843, '0', 0, 0, -392.98785400390625, -1562.8194580078125, 108.345947265625, 4.118979454040527343, 0, 0, -0.88294696807861328, 0.469472706317901611, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+89, 180471, 1, 4709, 4843, '0', 0, 0, -488.65625, -1475.8316650390625, 102.1529922485351562, 1.291541695594787597, 0, 0, 0.60181427001953125, 0.798636078834533691, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+90, 180471, 1, 4709, 4843, '0', 0, 0, -486.361114501953125, -1469.59033203125, 103.6724624633789062, 2.007128477096557617, 0, 0, 0.84339141845703125, 0.537299633026123046, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+91, 180471, 1, 4709, 4843, '0', 0, 0, -487.21527099609375, -1473.5103759765625, 102.9069900512695312, 1.361356139183044433, 0, 0, 0.629320144653320312, 0.77714616060256958, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+92, 180471, 1, 4709, 4843, '0', 0, 0, -486.734375, -1468.94970703125, 103.6724624633789062, 2.007128477096557617, 0, 0, 0.84339141845703125, 0.537299633026123046, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+93, 180471, 1, 4709, 4843, '0', 0, 0, -486.055572509765625, -1471.3472900390625, 103.5111236572265625, 1.274088263511657714, 0, 0, 0.594821929931640625, 0.80385744571685791, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+94, 180471, 1, 4709, 4843, '0', 0, 0, -488.010406494140625, -1474.6510009765625, 102.4972000122070312, 1.291541695594787597, 0, 0, 0.60181427001953125, 0.798636078834533691, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+95, 180471, 1, 4709, 4843, '0', 0, 0, -486.071197509765625, -1470.4879150390625, 103.6724624633789062, 1.884953022003173828, 0, 0, 0.809016227722167968, 0.587786316871643066, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+96, 180471, 1, 4709, 4843, '0', 0, 0, -486.520843505859375, -1472.2691650390625, 103.2761306762695312, 1.274088263511657714, 0, 0, 0.594821929931640625, 0.80385744571685791, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+97, 180471, 1, 4709, 4843, '0', 0, 0, -502.42535400390625, -1408.404541015625, 114.3814468383789062, 5.375615119934082031, 0, 0, -0.4383707046508789, 0.898794233798980712, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+98, 180471, 1, 4709, 4843, '0', 0, 0, -495.40277099609375, -1412.423583984375, 114.3635635375976562, 6.178466320037841796, 0, 0, -0.05233573913574218, 0.998629570007324218, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+99, 180471, 1, 4709, 4843, '0', 0, 0, -484.75347900390625, -1409.4791259765625, 114.3814468383789062, 0.698131442070007324, 0, 0, 0.342020034790039062, 0.939692676067352294, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+100, 180471, 1, 4709, 4843, '0', 0, 0, -487.045135498046875, -1411.0816650390625, 114.3927764892578125, 0.663223206996917724, 0, 0, 0.325567245483398437, 0.945518851280212402, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+101, 180471, 1, 4709, 4843, '0', 0, 0, -496.638885498046875, -1411.9879150390625, 114.3927764892578125, 6.12610626220703125, 0, 0, -0.07845878601074218, 0.996917366981506347, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+102, 180471, 1, 4709, 4843, '0', 0, 0, -485.864593505859375, -1410.5103759765625, 114.3635635375976562, 0.715584874153137207, 0, 0, 0.350207328796386718, 0.936672210693359375, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+103, 180471, 1, 4709, 4843, '0', 0, 0, -493.890625, -1412.484375, 114.3814468383789062, 6.14356088638305664, 0, 0, -0.06975555419921875, 0.997564136981964111, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+104, 180471, 1, 4709, 4843, '0', 0, 0, -480.55035400390625, -1402.298583984375, 114.3635635375976562, 1.48352813720703125, 0, 0, 0.675589561462402343, 0.737277925014495849, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+105, 180471, 1, 4709, 4843, '0', 0, 0, -503.489593505859375, -1407.326416015625, 114.3635635375976562, 5.410521507263183593, 0, 0, -0.42261791229248046, 0.906307935714721679, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+106, 180471, 1, 4709, 4843, '0', 0, 0, -504.1007080078125, -1406.16845703125, 114.3927764892578125, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+107, 180471, 1, 4709, 4843, '0', 0, 0, -480.95660400390625, -1403.545166015625, 114.3927764892578125, 1.431168079376220703, 0, 0, 0.656058311462402343, 0.754710197448730468, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+108, 180471, 1, 4709, 4843, '0', 0, 0, -480.515625, -1400.7742919921875, 114.3814468383789062, 1.448621988296508789, 0, 0, 0.662619590759277343, 0.748956084251403808, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+109, 180471, 1, 4709, 4843, '0', 0, 0, -505.625, -1399.2222900390625, 114.3814468383789062, 4.59021615982055664, 0, 0, -0.74895572662353515, 0.662620067596435546, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+110, 180471, 1, 4709, 4843, '0', 0, 0, -499.140625, -1388.8992919921875, 114.3927764892578125, 3.78736734390258789, 0, 0, -0.94832324981689453, 0.317305892705917358, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+111, 180471, 1, 4709, 4843, '0', 0, 0, -505.28472900390625, -1396.4461669921875, 114.3927764892578125, 4.59021615982055664, 0, 0, -0.74895572662353515, 0.662620067596435546, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+112, 180471, 1, 4709, 4843, '0', 0, 0, -482.46527099609375, -1392.736083984375, 114.3635635375976562, 2.286378860473632812, 0, 0, 0.909960746765136718, 0.414694398641586303, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+113, 180471, 1, 4709, 4843, '0', 0, 0, -500.33160400390625, -1389.451416015625, 114.3635635375976562, 3.839725255966186523, 0, 0, -0.93969249725341796, 0.34202045202255249, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+114, 180471, 1, 4709, 4843, '0', 0, 0, -481.914947509765625, -1393.9271240234375, 114.3927764892578125, 2.216565132141113281, 0, 0, 0.894933700561523437, 0.44619917869567871, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+115, 180471, 1, 4709, 4843, '0', 0, 0, -489.494781494140625, -1387.7569580078125, 114.3927764892578125, 3.019413232803344726, 0, 0, 0.998134613037109375, 0.061051756143569946, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+116, 180471, 1, 4709, 4843, '0', 0, 0, -490.75, -1387.375, 114.3635635375976562, 3.071766138076782226, 0, 0, 0.999390602111816406, 0.034906134009361267, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+117, 180471, 1, 4709, 4843, '0', 0, 0, -501.473968505859375, -1390.453125, 114.3814468383789062, 3.839725255966186523, 0, 0, -0.93969249725341796, 0.34202045202255249, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+118, 180471, 1, 4709, 4843, '0', 0, 0, -505.645843505859375, -1397.703125, 114.3635635375976562, 4.625123500823974609, 0, 0, -0.73727703094482421, 0.67559051513671875, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+119, 180471, 1, 4709, 4843, '0', 0, 0, -483.473968505859375, -1391.595458984375, 114.3814468383789062, 2.286378860473632812, 0, 0, 0.909960746765136718, 0.414694398641586303, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+120, 180471, 1, 4709, 4843, '0', 0, 0, -492.274322509765625, -1387.3697509765625, 114.3814468383789062, 3.036838293075561523, 0, 0, 0.998628616333007812, 0.052353221923112869, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+121, 180472, 1, 4709, 4843, '0', 0, 0, -389.8125, -1558.16845703125, 97.20450592041015625, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+122, 180472, 1, 4709, 4843, '0', 0, 0, -480.993072509765625, -1407.876708984375, 103.3373336791992187, 5.6897735595703125, 0, 0, -0.29237174987792968, 0.956304728984832763, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+123, 180523, 1, 4709, 4843, '0', 0, 0, -351.0069580078125, -1540.8021240234375, 87.51639556884765625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Apple Bob (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+124, 207941, 1, 4709, 4843, '0', 0, 0, -849.14581298828125, -1554.4010009765625, 154.8351593017578125, 4.939284324645996093, 0, 0, -0.6225137710571289, 0.78260880708694458, 120, 255, 1, 46366), -- G_WitchHat_01 scale 2.0 (Area: Honor's Stand - Difficulty: 0)
+(@OGUID+125, 208169, 1, 4709, 4843, '0', 0, 0, -338.734375, -1535.6927490234375, 87.29409027099609375, 4.136432647705078125, 0, 0, -0.87881660461425781, 0.477159708738327026, 120, 255, 1, 46366); -- Candy Bucket (Area: Honor's Stand - Difficulty: 0)
+
+-- Event spawns
+DELETE FROM `game_event_creature` WHERE `eventEntry`=12 AND `guid`=@CGUID+0;
+INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES
+(12, @CGUID+0);
+
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+125;
+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),
+(12, @OGUID+115),
+(12, @OGUID+116),
+(12, @OGUID+117),
+(12, @OGUID+118),
+(12, @OGUID+119),
+(12, @OGUID+120),
+(12, @OGUID+121),
+(12, @OGUID+122),
+(12, @OGUID+123),
+(12, @OGUID+124),
+(12, @OGUID+125);
diff --git a/sql/updates/world/master/2022_11_11_28_world_southern_barrens_northwatch_hold.sql b/sql/updates/world/master/2022_11_11_28_world_southern_barrens_northwatch_hold.sql
new file mode 100644
index 00000000000..95d90c1042a
--- /dev/null
+++ b/sql/updates/world/master/2022_11_11_28_world_southern_barrens_northwatch_hold.sql
@@ -0,0 +1,197 @@
+SET @CGUID := 396410;
+SET @OGUID := 247338;
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=46366 WHERE `entry`=208170; -- Candy Bucket
+
+UPDATE `gameobject_template_addon` SET `faction`=1732 WHERE `entry`=208170; -- Candy Bucket
+
+-- Quests
+DELETE FROM `quest_offer_reward` WHERE `ID`=29007;
+INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES
+(29007, 0, 0, 0, 0, 0, 0, 0, 0, 'Candy buckets like this are located in inns throughout the realms. Go ahead... take some!', 46366); -- Candy Bucket
+
+DELETE FROM `gameobject_queststarter` WHERE `id`=208170;
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(208170, 29007, 46366);
+
+UPDATE `gameobject_questender` SET `VerifiedBuild`=46366 WHERE (`id`=208170 AND `quest`=29007);
+
+DELETE FROM `game_event_gameobject_quest` WHERE `id`=208170;
+
+-- Creature spawns
+DELETE FROM `creature` WHERE `guid`=@CGUID+0;
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+(@CGUID+0, 22816, 1, 4709, 4847, '0', 0, 0, 0, 0, -2148.983642578125, -3538.833740234375, 92.31920623779296875, 3.528267383575439453, 120, 10, 0, 188, 0, 1, 0, 0, 0, 46366); -- Black Cat (Area: Northwatch Hold - Difficulty: 0) (possible waypoints or random movement)
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+79;
+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, 1, 4709, 4847, '0', 0, 0, -2070.932373046875, -3512.630126953125, 101.6366119384765625, 1.553341388702392578, 0, 0, 0.700908660888671875, 0.713251054286956787, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+1, 180405, 1, 4709, 4847, '0', 0, 0, -2118.788330078125, -3508.40625, 102.233856201171875, 5.70722818374633789, 0, 0, -0.28401470184326171, 0.958819925785064697, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+2, 180405, 1, 4709, 4847, '0', 0, 0, -2154.232666015625, -3551.494873046875, 92.392608642578125, 2.740161895751953125, 0, 0, 0.979924201965332031, 0.199370384216308593, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+3, 180405, 1, 4709, 4847, '0', 0, 0, -2162.552001953125, -3607.55908203125, 91.58831787109375, 1.605701684951782226, 0, 0, 0.719339370727539062, 0.694658815860748291, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+4, 180405, 1, 4709, 4847, '0', 0, 0, -2158.927001953125, -3685.26220703125, 83.74652862548828125, 4.555310726165771484, 0, 0, -0.76040554046630859, 0.649448513984680175, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+5, 180405, 1, 4709, 4847, '0', 0, 0, -2234.826416015625, -3734.088623046875, 91.37229156494140625, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+6, 180405, 1, 4709, 4847, '0', 0, 0, -2194.494873046875, -3715.6025390625, 94.1358489990234375, 4.380776405334472656, 0, 0, -0.81411552429199218, 0.580702960491180419, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+7, 180406, 1, 4709, 4847, '0', 0, 0, -2072.338623046875, -3489.298583984375, 101.63775634765625, 2.635444164276123046, 0, 0, 0.96814727783203125, 0.250381410121917724, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+8, 180406, 1, 4709, 4847, '0', 0, 0, -2116.48095703125, -3492.517333984375, 101.637786865234375, 4.660029888153076171, 0, 0, -0.72537422180175781, 0.688354730606079101, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+9, 180406, 1, 4709, 4847, '0', 0, 0, -2109.632080078125, -3522.77783203125, 102.2338104248046875, 5.881760597229003906, 0, 0, -0.19936752319335937, 0.979924798011779785, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+10, 180406, 1, 4709, 4847, '0', 0, 0, -2186.479248046875, -3656.0556640625, 90.92240142822265625, 1.553341388702392578, 0, 0, 0.700908660888671875, 0.713251054286956787, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+11, 180406, 1, 4709, 4847, '0', 0, 0, -2165.645751953125, -3696.319580078125, 89.40224456787109375, 4.468043327331542968, 0, 0, -0.7880105972290039, 0.615661680698394775, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+12, 180406, 1, 4709, 4847, '0', 0, 0, -2190.114501953125, -3707.625, 92.759552001953125, 4.817109584808349609, 0, 0, -0.66913032531738281, 0.74314504861831665, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+13, 180407, 1, 4709, 4847, '0', 0, 0, -2093.09716796875, -3477.645751953125, 101.6398696899414062, 3.612837791442871093, 0, 0, -0.97236919403076171, 0.233448356389999389, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+14, 180407, 1, 4709, 4847, '0', 0, 0, -2094.4931640625, -3527.517333984375, 101.637237548828125, 0.488691210746765136, 0, 0, 0.241921424865722656, 0.970295846462249755, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+15, 180407, 1, 4709, 4847, '0', 0, 0, -2181.39404296875, -3703.38720703125, 94.0216827392578125, 3.892086982727050781, 0, 0, -0.93041706085205078, 0.366502493619918823, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+16, 180407, 1, 4709, 4847, '0', 0, 0, -2218.42529296875, -3702.4462890625, 92.3603363037109375, 1.32644820213317871, 0, 0, 0.615660667419433593, 0.788011372089385986, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+17, 180408, 1, 4709, 4847, '0', 0, 0, -2154.092041015625, -3551.532958984375, 94.03586578369140625, 2.059488296508789062, 0, 0, 0.857167243957519531, 0.515038192272186279, 120, 255, 1, 46366), -- G_WitchHat_01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+18, 180411, 1, 4709, 4847, '0', 0, 0, -2230.069580078125, -3734.03125, 94.0643768310546875, 4.677483558654785156, 0, 0, -0.71933937072753906, 0.694658815860748291, 120, 255, 1, 46366), -- G_Ghost_01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+19, 180414, 1, 4709, 4847, '0', 0, 0, -2154.25, -3548.78466796875, 92.48007965087890625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Cauldron (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+20, 180415, 1, 4709, 4847, '0', 0, 0, -2154.638916015625, -3546.651123046875, 92.47592926025390625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+21, 180415, 1, 4709, 4847, '0', 0, 0, -2151.248291015625, -3548.072998046875, 92.404815673828125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+22, 180415, 1, 4709, 4847, '0', 0, 0, -2151.015625, -3550.29345703125, 92.2989349365234375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+23, 180415, 1, 4709, 4847, '0', 0, 0, -2154.18408203125, -3544.208251953125, 92.45920562744140625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+24, 180415, 1, 4709, 4847, '0', 0, 0, -2152.772705078125, -3546.954833984375, 92.47650146484375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+25, 180415, 1, 4709, 4847, '0', 0, 0, -2153.92529296875, -3541.682373046875, 92.387939453125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+26, 180415, 1, 4709, 4847, '0', 0, 0, -2151.326416015625, -3552.092041015625, 92.2301788330078125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+27, 180415, 1, 4709, 4847, '0', 0, 0, -2155.1337890625, -3558.34716796875, 91.79749298095703125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+28, 180415, 1, 4709, 4847, '0', 0, 0, -2154.69970703125, -3553.8525390625, 92.24387359619140625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+29, 180415, 1, 4709, 4847, '0', 0, 0, -2152.725830078125, -3553.345458984375, 92.22872161865234375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+30, 180415, 1, 4709, 4847, '0', 0, 0, -2154.911376953125, -3555.626708984375, 92.076080322265625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+31, 180415, 1, 4709, 4847, '0', 0, 0, -2160.1181640625, -3600.58154296875, 91.7639923095703125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+32, 180415, 1, 4709, 4847, '0', 0, 0, -2161.359375, -3603.95654296875, 91.68021392822265625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+33, 180415, 1, 4709, 4847, '0', 0, 0, -2165.7744140625, -3614.04345703125, 91.62944793701171875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+34, 180415, 1, 4709, 4847, '0', 0, 0, -2164.411376953125, -3610.692626953125, 91.60495758056640625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+35, 180415, 1, 4709, 4847, '0', 0, 0, -2188.54345703125, -3658.625, 90.9993133544921875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+36, 180415, 1, 4709, 4847, '0', 0, 0, -2190.241455078125, -3662.515625, 90.9618072509765625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+37, 180415, 1, 4709, 4847, '0', 0, 0, -2186.038330078125, -3652.8212890625, 90.86511993408203125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+38, 180415, 1, 4709, 4847, '0', 0, 0, -2184.213623046875, -3649.395751953125, 91.24613189697265625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+39, 180415, 1, 4709, 4847, '0', 0, 0, -2231.859375, -3736.576416015625, 93.381134033203125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+40, 180415, 1, 4709, 4847, '0', 0, 0, -2223.513916015625, -3707.744873046875, 91.86260986328125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+41, 180415, 1, 4709, 4847, '0', 0, 0, -2236.921875, -3733.473876953125, 91.8242340087890625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+42, 180415, 1, 4709, 4847, '0', 0, 0, -2216.322998046875, -3699.142333984375, 92.56069183349609375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+43, 180415, 1, 4709, 4847, '0', 0, 0, -2213.723876953125, -3696.067626953125, 92.6726531982421875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+44, 180415, 1, 4709, 4847, '0', 0, 0, -2220.96533203125, -3704.72216796875, 92.22063446044921875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+45, 180415, 1, 4709, 4847, '0', 0, 0, -2233.244873046875, -3735.632080078125, 93.3547210693359375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+46, 180425, 1, 4709, 4847, '0', 0, 0, -2156.373291015625, -3560.505126953125, 92.4424591064453125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- SkullCandle01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+47, 180425, 1, 4709, 4847, '0', 0, 0, -2155.579833984375, -3562.505126953125, 92.42082977294921875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- SkullCandle01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+48, 180426, 1, 4709, 4847, '0', 0, 0, -2064.142333984375, -3461.48779296875, 91.96524810791015625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+49, 180426, 1, 4709, 4847, '0', 0, 0, -2054.708251953125, -3469.432373046875, 97.1211090087890625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+50, 180426, 1, 4709, 4847, '0', 0, 0, -2067.692626953125, -3458.43408203125, 93.53896331787109375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+51, 180426, 1, 4709, 4847, '0', 0, 0, -2134.145751953125, -3531.451416015625, 91.66544342041015625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+52, 180426, 1, 4709, 4847, '0', 0, 0, -2131.015625, -3556.65625, 97.27268218994140625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+53, 180426, 1, 4709, 4847, '0', 0, 0, -2133.782958984375, -3582.9306640625, 94.23220062255859375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+54, 180426, 1, 4709, 4847, '0', 0, 0, -2148.8525390625, -3613.678955078125, 99.65700531005859375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+55, 180426, 1, 4709, 4847, '0', 0, 0, -2164.17529296875, -3638.2275390625, 97.16341400146484375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+56, 180426, 1, 4709, 4847, '0', 0, 0, -2179.375, -3677.407958984375, 87.9856414794921875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+57, 180426, 1, 4709, 4847, '0', 0, 0, -2205.87841796875, -3714.265625, 98.39243316650390625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+58, 180427, 1, 4709, 4847, '0', 0, 0, -2097.0087890625, -3495.947998046875, 130.0844268798828125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+59, 180427, 1, 4709, 4847, '0', 0, 0, -2096.935791015625, -3501.302001953125, 124.9828872680664062, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+60, 180427, 1, 4709, 4847, '0', 0, 0, -2093.177001953125, -3509.880126953125, 130.0844268798828125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+61, 180427, 1, 4709, 4847, '0', 0, 0, -2088.82470703125, -3501.401123046875, 130.0844268798828125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+62, 180427, 1, 4709, 4847, '0', 0, 0, -2120.963623046875, -3556.616455078125, 100.7679519653320312, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+63, 180427, 1, 4709, 4847, '0', 0, 0, -2125.7587890625, -3551.838623046875, 110.1633682250976562, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+64, 180427, 1, 4709, 4847, '0', 0, 0, -2135.076416015625, -3583.126708984375, 109.2811965942382812, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+65, 180427, 1, 4709, 4847, '0', 0, 0, -2141.364501953125, -3620.114501953125, 106.5954666137695312, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+66, 180427, 1, 4709, 4847, '0', 0, 0, -2164.48095703125, -3659.34375, 108.9088897705078125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+67, 180427, 1, 4709, 4847, '0', 0, 0, -2181.22216796875, -3689.80029296875, 102.0066299438476562, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+68, 180428, 1, 4709, 4847, '0', 0, 0, -2155.30029296875, -3550.1806640625, 92.390411376953125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- G_WitchBroom_01 scale 0.5 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+69, 180472, 1, 4709, 4847, '0', 0, 0, -2095.8056640625, -3490.098876953125, 113.3903579711914062, 1.85004889965057373, 0, 0, 0.798635482788085937, 0.60181504487991333, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+70, 180472, 1, 4709, 4847, '0', 0, 0, -2086.3837890625, -3492.3212890625, 113.3822708129882812, 1.151916384696960449, 0, 0, 0.544638633728027343, 0.838670849800109863, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+71, 180472, 1, 4709, 4847, '0', 0, 0, -2104.138916015625, -3495.194580078125, 113.3955917358398437, 2.565631866455078125, 0, 0, 0.958819389343261718, 0.284016460180282592, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+72, 180472, 1, 4709, 4847, '0', 0, 0, -2083.390625, -3510.15283203125, 113.4044265747070312, 5.6897735595703125, 0, 0, -0.29237174987792968, 0.956304728984832763, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+73, 180472, 1, 4709, 4847, '0', 0, 0, -2081.295166015625, -3500.572998046875, 113.3610610961914062, 0.261798173189163208, 0, 0, 0.130525588989257812, 0.991444945335388183, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+74, 180472, 1, 4709, 4847, '0', 0, 0, -2101.2587890625, -3513.098876953125, 113.4020767211914062, 4.031712055206298828, 0, 0, -0.90258502960205078, 0.430511653423309326, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+75, 180472, 1, 4709, 4847, '0', 0, 0, -2091.848876953125, -3515.177001953125, 113.3554534912109375, 4.97418975830078125, 0, 0, -0.60876083374023437, 0.793353796005249023, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+76, 180472, 1, 4709, 4847, '0', 0, 0, -2106.36279296875, -3504.7744140625, 113.3764419555664062, 3.385940074920654296, 0, 0, -0.99254608154296875, 0.121869951486587524, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+77, 180523, 1, 4709, 4847, '0', 0, 0, -2098.375, -3499.4375, 95.33441925048828125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Apple Bob (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+78, 185435, 1, 4709, 4847, '0', 0, 0, -2153.08154296875, -3548.522705078125, 92.47210693359375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Sitting Skeleton 02 (Area: Northwatch Hold - Difficulty: 0)
+(@OGUID+79, 208170, 1, 4709, 4847, '0', 0, 0, -2095.6181640625, -3506.585205078125, 94.9953460693359375, 5.113816738128662109, 0, 0, -0.55193614959716796, 0.833886384963989257, 120, 255, 1, 46366); -- Candy Bucket (Area: Northwatch Hold - Difficulty: 0)
+
+-- Event spawns
+DELETE FROM `game_event_creature` WHERE `eventEntry`=12 AND `guid`=@CGUID+0;
+INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES
+(12, @CGUID+0);
+
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+79;
+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);
diff --git a/sql/updates/world/master/2022_11_11_29_world_southern_barrens_fort_triumph.sql b/sql/updates/world/master/2022_11_11_29_world_southern_barrens_fort_triumph.sql
new file mode 100644
index 00000000000..6fb36b02f19
--- /dev/null
+++ b/sql/updates/world/master/2022_11_11_29_world_southern_barrens_fort_triumph.sql
@@ -0,0 +1,183 @@
+SET @CGUID := 396411;
+SET @OGUID := 247418;
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=46366 WHERE `entry`=208171; -- Candy Bucket
+
+UPDATE `gameobject_template_addon` SET `faction`=1732 WHERE `entry`=208171; -- Candy Bucket
+
+-- Quests
+DELETE FROM `quest_offer_reward` WHERE `ID`=29008;
+INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES
+(29008, 0, 0, 0, 0, 0, 0, 0, 0, 'Candy buckets like this are located in inns throughout the realms. Go ahead... take some!', 46366); -- Candy Bucket
+
+DELETE FROM `gameobject_queststarter` WHERE `id`=208171;
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(208171, 29008, 46366);
+
+UPDATE `gameobject_questender` SET `VerifiedBuild`=46366 WHERE (`id`=208171 AND `quest`=29008);
+
+DELETE FROM `game_event_gameobject_quest` WHERE `id`=208171;
+
+-- Creature spawns
+DELETE FROM `creature` WHERE `guid`=@CGUID+0;
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+(@CGUID+0, 22816, 1, 4709, 4854, '0', 0, 0, 0, 0, -3130.102294921875, -2259.208984375, 97.29632568359375, 3.033955335617065429, 120, 10, 0, 188, 0, 1, 0, 0, 0, 46366); -- Black Cat (Area: Fort Triumph - Difficulty: 0)
+
+-- Old gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 227336 AND 227388;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 227336 AND 227388;
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+70;
+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, 1, 4709, 4854, '0', 0, 0, -3147.005126953125, -2319.654541015625, 98.949249267578125, 3.874631166458129882, 0, 0, -0.93358039855957031, 0.358368009328842163, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+1, 180405, 1, 4709, 4854, '0', 0, 0, -3187.755126953125, -2279.6650390625, 93.2809295654296875, 1.047197580337524414, 0, 0, 0.5, 0.866025388240814208, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+2, 180406, 1, 4709, 4854, '0', 0, 0, -3174.036376953125, -2274.854248046875, 94.75032806396484375, 1.047197580337524414, 0, 0, 0.5, 0.866025388240814208, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+3, 180406, 1, 4709, 4854, '0', 0, 0, -3106.130126953125, -2293.640625, 97.37984466552734375, 5.166176319122314453, 0, 0, -0.52991867065429687, 0.84804844856262207, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+4, 180407, 1, 4709, 4854, '0', 0, 0, -3108.576416015625, -2274.08154296875, 97.362579345703125, 5.340708732604980468, 0, 0, -0.45398998260498046, 0.891006767749786376, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+5, 180407, 1, 4709, 4854, '0', 0, 0, -3165.50341796875, -2325.135498046875, 97.92482757568359375, 3.717553615570068359, 0, 0, -0.95881938934326171, 0.284016460180282592, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+6, 180407, 1, 4709, 4854, '0', 0, 0, -3177.15283203125, -2273.454833984375, 94.7529144287109375, 0.401424884796142578, 0, 0, 0.199367523193359375, 0.979924798011779785, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+7, 180410, 1, 4709, 4854, '0', 0, 0, -3169.286376953125, -2327.088623046875, 97.28879547119140625, 1.692969322204589843, 0, 0, 0.748955726623535156, 0.662620067596435546, 120, 255, 1, 46366), -- G_HangingSkeleton_01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+8, 180410, 1, 4709, 4854, '0', 0, 0, -3113.6025390625, -2270.4375, 96.83802032470703125, 2.757613182067871093, 0, 0, 0.981626510620117187, 0.190812408924102783, 120, 255, 1, 46366), -- G_HangingSkeleton_01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+9, 180410, 1, 4709, 4854, '0', 0, 0, -3114.729248046875, -2308.189208984375, 94.634552001953125, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46366), -- G_HangingSkeleton_01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+10, 180415, 1, 4709, 4854, '0', 0, 0, -3136.678955078125, -2285.897705078125, 95.0146942138671875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+11, 180415, 1, 4709, 4854, '0', 0, 0, -3140.6875, -2286.600830078125, 94.8637847900390625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+12, 180415, 1, 4709, 4854, '0', 0, 0, -3129.225830078125, -2289.713623046875, 95.49250030517578125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+13, 180415, 1, 4709, 4854, '0', 0, 0, -3155.7119140625, -2262.053955078125, 96.452545166015625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+14, 180415, 1, 4709, 4854, '0', 0, 0, -3154.2744140625, -2270.2900390625, 96.91870880126953125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+15, 180415, 1, 4709, 4854, '0', 0, 0, -3155.298583984375, -2266.232666015625, 97.16230010986328125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+16, 180415, 1, 4709, 4854, '0', 0, 0, -3133.147705078125, -2288.060791015625, 95.70511627197265625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+17, 180415, 1, 4709, 4854, '0', 0, 0, -3112.850830078125, -2259.123291015625, 95.65775299072265625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+18, 180415, 1, 4709, 4854, '0', 0, 0, -3158.48095703125, -2259.56591796875, 96.52063751220703125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+19, 180415, 1, 4709, 4854, '0', 0, 0, -3116.986083984375, -2269.045166015625, 98.2745361328125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+20, 180415, 1, 4709, 4854, '0', 0, 0, -3158.451416015625, -2255.5556640625, 96.4629669189453125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+21, 180415, 1, 4709, 4854, '0', 0, 0, -3145.944580078125, -2318.939208984375, 98.62383270263671875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+22, 180415, 1, 4709, 4854, '0', 0, 0, -3113.067626953125, -2267.427001953125, 97.9392852783203125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+23, 180415, 1, 4709, 4854, '0', 0, 0, -3121.04345703125, -2270.046875, 97.71132659912109375, 0.401424884796142578, 0, 0, 0.199367523193359375, 0.979924798011779785, 120, 255, 1, 46366), -- CandleBlack01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+24, 180415, 1, 4709, 4854, '0', 0, 0, -3109.16845703125, -2272.892333984375, 97.12329864501953125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+25, 180415, 1, 4709, 4854, '0', 0, 0, -3113.663330078125, -2257.927001953125, 96.69116973876953125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+26, 180415, 1, 4709, 4854, '0', 0, 0, -3166.708251953125, -2324.651123046875, 97.5452728271484375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+27, 180415, 1, 4709, 4854, '0', 0, 0, -3106.333251953125, -2294.998291015625, 97.162139892578125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+28, 180415, 1, 4709, 4854, '0', 0, 0, -3123.052001953125, -2273.210205078125, 97.51555633544921875, 5.550147056579589843, 0, 0, -0.358367919921875, 0.933580458164215087, 120, 255, 1, 46366), -- CandleBlack01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+29, 180415, 1, 4709, 4854, '0', 0, 0, -3127.078125, -2273.65966796875, 97.158233642578125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+30, 180426, 1, 4709, 4854, '0', 0, 0, -3159.015625, -2276.41845703125, 94.8774566650390625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+31, 180426, 1, 4709, 4854, '0', 0, 0, -3136.203125, -2289.020751953125, 95.48450469970703125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+32, 180426, 1, 4709, 4854, '0', 0, 0, -3140.986083984375, -2289.692626953125, 92.88883209228515625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+33, 180426, 1, 4709, 4854, '0', 0, 0, -3133.392333984375, -2273.857666015625, 94.1103515625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+34, 180426, 1, 4709, 4854, '0', 0, 0, -3150.382080078125, -2279.510498046875, 93.2991790771484375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+35, 180426, 1, 4709, 4854, '0', 0, 0, -3172.8994140625, -2293.052001953125, 93.26047515869140625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+36, 180426, 1, 4709, 4854, '0', 0, 0, -3160.53466796875, -2292.90966796875, 93.26726531982421875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+37, 180426, 1, 4709, 4854, '0', 0, 0, -3144.807373046875, -2261.015625, 95.31029510498046875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+38, 180427, 1, 4709, 4854, '0', 0, 0, -3140.939208984375, -2283.796875, 93.0189361572265625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+39, 180427, 1, 4709, 4854, '0', 0, 0, -3140.56591796875, -2279.94970703125, 93.18634033203125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+40, 180427, 1, 4709, 4854, '0', 0, 0, -3135.09375, -2280.1025390625, 102.9301834106445312, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+41, 180427, 1, 4709, 4854, '0', 0, 0, -3154.607666015625, -2290.22216796875, 94.82157135009765625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+42, 180427, 1, 4709, 4854, '0', 0, 0, -3166.8525390625, -2296.583251953125, 100.70098876953125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+43, 180471, 1, 4709, 4854, '0', 0, 0, -3085.765625, -2269.28125, 114.194091796875, 3.78736734390258789, 0, 0, -0.94832324981689453, 0.317305892705917358, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+44, 180471, 1, 4709, 4854, '0', 0, 0, -3086.835205078125, -2270.232666015625, 114.1970367431640625, 3.752462387084960937, 0, 0, -0.95371627807617187, 0.300707906484603881, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+45, 180471, 1, 4709, 4854, '0', 0, 0, -3084.333251953125, -2268.803955078125, 114.1806411743164062, 3.700104713439941406, 0, 0, -0.96126079559326171, 0.275640487670898437, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+46, 180471, 1, 4709, 4854, '0', 0, 0, -3069.135498046875, -2272.998291015625, 114.1970367431640625, 2.199114561080932617, 0, 0, 0.8910064697265625, 0.453990638256072998, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+47, 180471, 1, 4709, 4854, '0', 0, 0, -3071.9150390625, -2290.685791015625, 114.1970367431640625, 0.610863447189331054, 0, 0, 0.3007049560546875, 0.953717231750488281, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+48, 180471, 1, 4709, 4854, '0', 0, 0, -3090.913330078125, -2275.671875, 114.1806411743164062, 4.468043327331542968, 0, 0, -0.7880105972290039, 0.615661680698394775, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+49, 180471, 1, 4709, 4854, '0', 0, 0, -3074.40283203125, -2292.140625, 114.1806411743164062, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+50, 180471, 1, 4709, 4854, '0', 0, 0, -3091.64404296875, -2277.010498046875, 114.194091796875, 4.555310726165771484, 0, 0, -0.76040554046630859, 0.649448513984680175, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+51, 180471, 1, 4709, 4854, '0', 0, 0, -3077.3994140625, -2267.953125, 114.1970367431640625, 2.984498262405395507, 0, 0, 0.996916770935058593, 0.078466430306434631, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+52, 180471, 1, 4709, 4854, '0', 0, 0, -3068.145751953125, -2274.032958984375, 114.194091796875, 2.234017848968505859, 0, 0, 0.898793220520019531, 0.438372820615768432, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+53, 180471, 1, 4709, 4854, '0', 0, 0, -3090.5244140625, -2286.81591796875, 114.194091796875, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+54, 180471, 1, 4709, 4854, '0', 0, 0, -3067.632080078125, -2275.460205078125, 114.1806411743164062, 2.164205789566040039, 0, 0, 0.882946968078613281, 0.469472706317901611, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+55, 180471, 1, 4709, 4854, '0', 0, 0, -3075.967041015625, -2268.052001953125, 114.194091796875, 3.019413232803344726, 0, 0, 0.998134613037109375, 0.061051756143569946, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+56, 180471, 1, 4709, 4854, '0', 0, 0, -3074.630126953125, -2268.755126953125, 114.1806411743164062, 2.914689540863037109, 0, 0, 0.993571281433105468, 0.113208353519439697, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+57, 180471, 1, 4709, 4854, '0', 0, 0, -3084.0869140625, -2292.217041015625, 114.1806411743164062, 6.073746204376220703, 0, 0, -0.10452842712402343, 0.994521915912628173, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+58, 180471, 1, 4709, 4854, '0', 0, 0, -3089.560791015625, -2287.875, 114.1970367431640625, 5.305802345275878906, 0, 0, -0.46947097778320312, 0.882947921752929687, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+59, 180471, 1, 4709, 4854, '0', 0, 0, -3066.94970703125, -2283.803955078125, 114.194091796875, 1.466075778007507324, 0, 0, 0.669130325317382812, 0.74314504861831665, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+60, 180471, 1, 4709, 4854, '0', 0, 0, -3072.960205078125, -2291.654541015625, 114.194091796875, 0.663223206996917724, 0, 0, 0.325567245483398437, 0.945518851280212402, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+61, 180471, 1, 4709, 4854, '0', 0, 0, -3091.7587890625, -2278.439208984375, 114.1970367431640625, 4.520402908325195312, 0, 0, -0.77162456512451171, 0.636078238487243652, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+62, 180471, 1, 4709, 4854, '0', 0, 0, -3066.861083984375, -2282.376708984375, 114.1970367431640625, 1.448621988296508789, 0, 0, 0.662619590759277343, 0.748956084251403808, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+63, 180471, 1, 4709, 4854, '0', 0, 0, -3091.005126953125, -2285.37158203125, 114.1806411743164062, 5.270895957946777343, 0, 0, -0.48480892181396484, 0.87462007999420166, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+64, 180471, 1, 4709, 4854, '0', 0, 0, -3082.725830078125, -2292.8994140625, 114.194091796875, 6.161012649536132812, 0, 0, -0.06104850769042968, 0.998134791851043701, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+65, 180471, 1, 4709, 4854, '0', 0, 0, -3081.291748046875, -2292.96533203125, 114.1970367431640625, 6.12610626220703125, 0, 0, -0.07845878601074218, 0.996917366981506347, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+66, 180471, 1, 4709, 4854, '0', 0, 0, -3067.65966796875, -2285.147705078125, 114.1806411743164062, 1.361356139183044433, 0, 0, 0.629320144653320312, 0.77714616060256958, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+67, 180472, 1, 4709, 4854, '0', 0, 0, -3150.567626953125, -2334.47216796875, 104.1604232788085937, 1.919861555099487304, 0, 0, 0.819151878356933593, 0.573576688766479492, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+68, 180472, 1, 4709, 4854, '0', 0, 0, -3093.598876953125, -2282.104248046875, 103.5648269653320312, 3.263772249221801757, 0, 0, -0.99813461303710937, 0.061051756143569946, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+69, 180523, 1, 4709, 4854, '0', 0, 0, -3174.08154296875, -2279.01904296875, 93.5771636962890625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Apple Bob (Area: Fort Triumph - Difficulty: 0)
+(@OGUID+70, 208171, 1, 4709, 4854, '0', 0, 0, -3181.076416015625, -2279.244873046875, 93.2809295654296875, 0.174532130360603332, 0, 0, 0.087155342102050781, 0.996194720268249511, 120, 255, 1, 46366); -- Candy Bucket (Area: Fort Triumph - Difficulty: 0)
+
+-- Event spawns
+DELETE FROM `game_event_creature` WHERE `eventEntry`=12 AND `guid`=@CGUID+0;
+INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES
+(12, @CGUID+0);
+
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+70;
+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);