aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat
-rw-r--r--sql/updates/world/master/2022_11_12_03_world_desolace_nijels_point.sql133
-rw-r--r--sql/updates/world/master/2022_11_12_04_world_desolace_shadowprey_village.sql101
-rw-r--r--sql/updates/world/master/2022_11_12_05_world_desolace_karnums_glade.sql139
3 files changed, 373 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_11_12_03_world_desolace_nijels_point.sql b/sql/updates/world/master/2022_11_12_03_world_desolace_nijels_point.sql
new file mode 100644
index 00000000000..714a083bf75
--- /dev/null
+++ b/sql/updates/world/master/2022_11_12_03_world_desolace_nijels_point.sql
@@ -0,0 +1,133 @@
+SET @OGUID := 247550;
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=46366 WHERE `entry`=190051; -- Candy Bucket
+
+UPDATE `gameobject_template_addon` SET `faction`=1732 WHERE `entry`=190051; -- Candy Bucket
+
+-- Quests
+UPDATE `quest_offer_reward` SET `VerifiedBuild`=46366 WHERE `ID`=12348;
+
+DELETE FROM `gameobject_queststarter` WHERE `id`=190051;
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(190051, 12348, 46366);
+
+UPDATE `gameobject_questender` SET `VerifiedBuild`=46366 WHERE (`id`=190051 AND `quest`=12348);
+
+DELETE FROM `game_event_gameobject_quest` WHERE `id`=190051;
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+53;
+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, 405, 608, '0', 0, 0, 221.949920654296875, 1276.138671875, 201.6800384521484375, 5.445427894592285156, 0, 0, -0.40673637390136718, 0.913545548915863037, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+1, 180405, 1, 405, 608, '0', 0, 0, 221.74346923828125, 1259.8011474609375, 195.6831207275390625, 3.752462387084960937, 0, 0, -0.95371627807617187, 0.300707906484603881, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+2, 180405, 1, 405, 608, '0', 0, 0, 227.1924591064453125, 1234.6236572265625, 203.29559326171875, 0.628316879272460937, 0, 0, 0.309016227722167968, 0.95105677843093872, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+3, 180405, 1, 405, 608, '0', 0, 0, 261.901031494140625, 1276.8504638671875, 201.329071044921875, 2.146752834320068359, 0, 0, 0.878816604614257812, 0.477159708738327026, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+4, 180405, 1, 405, 608, '0', 0, 0, 271.16888427734375, 1238.32861328125, 201.329345703125, 2.059488296508789062, 0, 0, 0.857167243957519531, 0.515038192272186279, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+5, 180406, 1, 405, 608, '0', 0, 0, 212.835968017578125, 1257.55126953125, 195.6815948486328125, 3.717553615570068359, 0, 0, -0.95881938934326171, 0.284016460180282592, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+6, 180406, 1, 405, 608, '0', 0, 0, 218.6639556884765625, 1233.1553955078125, 195.6831207275390625, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+7, 180406, 1, 405, 608, '0', 0, 0, 221.1143646240234375, 1260.2047119140625, 203.297210693359375, 3.78736734390258789, 0, 0, -0.94832324981689453, 0.317305892705917358, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+8, 180406, 1, 405, 608, '0', 0, 0, 234.9542388916015625, 1220.6710205078125, 201.6930999755859375, 5.288348197937011718, 0, 0, -0.4771585464477539, 0.878817260265350341, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+9, 180406, 1, 405, 608, '0', 0, 0, 256.933258056640625, 1284.3687744140625, 201.6800079345703125, 2.164205789566040039, 0, 0, 0.882946968078613281, 0.469472706317901611, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+10, 180406, 1, 405, 608, '0', 0, 0, 270.58721923828125, 1245.658935546875, 201.3294219970703125, 2.129300594329833984, 0, 0, 0.874619483947753906, 0.484810054302215576, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+11, 180407, 1, 405, 608, '0', 0, 0, 212.62139892578125, 1258.2841796875, 203.2988433837890625, 3.735006093978881835, 0, 0, -0.95630455017089843, 0.292372345924377441, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+12, 180407, 1, 405, 608, '0', 0, 0, 227.55224609375, 1235.4893798828125, 195.6803741455078125, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+13, 180407, 1, 405, 608, '0', 0, 0, 218.8006744384765625, 1232.53564453125, 203.2965850830078125, 0.628316879272460937, 0, 0, 0.309016227722167968, 0.95105677843093872, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+14, 180407, 1, 405, 608, '0', 0, 0, 264.629669189453125, 1270.05859375, 201.32806396484375, 2.146752834320068359, 0, 0, 0.878816604614257812, 0.477159708738327026, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+15, 180407, 1, 405, 608, '0', 0, 0, 270.63800048828125, 1229.254150390625, 201.6952667236328125, 2.094393253326416015, 0, 0, 0.866024971008300781, 0.50000077486038208, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+16, 180410, 1, 405, 608, '0', 0, 0, 229.7708587646484375, 1241.9364013671875, 197.942657470703125, 1.797688722610473632, 0, 0, 0.7826080322265625, 0.622514784336090087, 120, 255, 1, 46366), -- G_HangingSkeleton_01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+17, 180411, 1, 405, 608, '0', 0, 0, 202.236114501953125, 1242.236083984375, 206.33197021484375, 0.087265998125076293, 0, 0, 0.043619155883789062, 0.999048233032226562, 120, 255, 1, 46366), -- G_Ghost_01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+18, 180411, 1, 405, 608, '0', 0, 0, 255.3680572509765625, 1213.6492919921875, 207.6495208740234375, 1.48352813720703125, 0, 0, 0.675589561462402343, 0.737277925014495849, 120, 255, 1, 46366), -- G_Ghost_01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+19, 180411, 1, 405, 608, '0', 0, 0, 251.51910400390625, 1229.7117919921875, 217.1167144775390625, 0.24434557557106018, 0, 0, 0.121869087219238281, 0.9925462007522583, 120, 255, 1, 46366), -- G_Ghost_01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+20, 180411, 1, 405, 608, '0', 0, 0, 240.50347900390625, 1275.9288330078125, 217.2572021484375, 0.087265998125076293, 0, 0, 0.043619155883789062, 0.999048233032226562, 120, 255, 1, 46366), -- G_Ghost_01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+21, 180411, 1, 405, 608, '0', 0, 0, 236.59722900390625, 1291.7447509765625, 207.300018310546875, 5.602506637573242187, 0, 0, -0.33380699157714843, 0.942641437053680419, 120, 255, 1, 46366), -- G_Ghost_01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+22, 180426, 1, 405, 608, '0', 0, 0, 245.8844757080078125, 1252.709228515625, 221.199920654296875, 3.473210096359252929, 0, 0, -0.98628520965576171, 0.165049895644187927, 120, 255, 1, 46366), -- Bat01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+23, 180426, 1, 405, 608, '0', 0, 0, 246.0086822509765625, 1252.8177490234375, 228.0140533447265625, 5.70722818374633789, 0, 0, -0.28401470184326171, 0.958819925785064697, 120, 255, 1, 46366), -- Bat01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+24, 180426, 1, 405, 608, '0', 0, 0, 245.8994140625, 1252.7877197265625, 221.20806884765625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+25, 180426, 1, 405, 608, '0', 0, 0, 246.0474395751953125, 1252.646484375, 221.196807861328125, 5.759587764739990234, 0, 0, -0.25881862640380859, 0.965925931930541992, 120, 255, 1, 46366), -- Bat01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+26, 180426, 1, 405, 608, '0', 0, 0, 246.048614501953125, 1252.5850830078125, 230.3841094970703125, 5.462882041931152343, 0, 0, -0.39874839782714843, 0.917060375213623046, 120, 255, 1, 46366), -- Bat01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+27, 180426, 1, 405, 608, '0', 0, 0, 246.0104217529296875, 1252.6944580078125, 225.764556884765625, 3.298687219619750976, 0, 0, -0.99691677093505859, 0.078466430306434631, 120, 255, 1, 46366), -- Bat01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+28, 180426, 1, 405, 608, '0', 0, 0, 245.9545135498046875, 1252.905517578125, 221.2194366455078125, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 46366), -- Bat01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+29, 180426, 1, 405, 608, '0', 0, 0, 245.9801483154296875, 1252.7508544921875, 221.20196533203125, 4.136432647705078125, 0, 0, -0.87881660461425781, 0.477159708738327026, 120, 255, 1, 46366), -- Bat01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+30, 180426, 1, 405, 608, '0', 0, 0, 245.9375, 1252.7274169921875, 229.2422943115234375, 3.036838293075561523, 0, 0, 0.998628616333007812, 0.052353221923112869, 120, 255, 1, 46366), -- Bat01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+31, 180426, 1, 405, 608, '0', 0, 0, 245.8871612548828125, 1252.732666015625, 224.278778076171875, 3.577930212020874023, 0, 0, -0.97629547119140625, 0.216442063450813293, 120, 255, 1, 46366), -- Bat01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+32, 180427, 1, 405, 608, '0', 0, 0, 245.8878021240234375, 1252.6629638671875, 221.1948089599609375, 4.171337604522705078, 0, 0, -0.87035560607910156, 0.492423713207244873, 120, 255, 1, 46366), -- Bat02 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+33, 180427, 1, 405, 608, '0', 0, 0, 245.9142303466796875, 1252.7020263671875, 221.1983795166015625, 0.383971005678176879, 0, 0, 0.190808296203613281, 0.981627285480499267, 120, 255, 1, 46366), -- Bat02 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+34, 180427, 1, 405, 608, '0', 0, 0, 245.90972900390625, 1252.7535400390625, 230.7041015625, 4.9218292236328125, 0, 0, -0.62932014465332031, 0.77714616060256958, 120, 255, 1, 46366), -- Bat02 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+35, 180427, 1, 405, 608, '0', 0, 0, 245.9114532470703125, 1252.7066650390625, 230.955810546875, 5.532694816589355468, 0, 0, -0.3665008544921875, 0.93041771650314331, 120, 255, 1, 46366), -- Bat02 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+36, 180427, 1, 405, 608, '0', 0, 0, 245.84722900390625, 1252.7083740234375, 225.2355499267578125, 5.619962215423583984, 0, 0, -0.32556724548339843, 0.945518851280212402, 120, 255, 1, 46366), -- Bat02 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+37, 180427, 1, 405, 608, '0', 0, 0, 245.9370880126953125, 1252.7607421875, 221.20416259765625, 5.654868602752685546, 0, 0, -0.30901622772216796, 0.95105677843093872, 120, 255, 1, 46366), -- Bat02 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+38, 180427, 1, 405, 608, '0', 0, 0, 245.8402862548828125, 1252.8125, 229.142852783203125, 5.026549339294433593, 0, 0, -0.5877847671508789, 0.809017360210418701, 120, 255, 1, 46366), -- Bat02 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+39, 180427, 1, 405, 608, '0', 0, 0, 245.9269256591796875, 1252.687744140625, 221.1964874267578125, 6.03883981704711914, 0, 0, -0.12186908721923828, 0.9925462007522583, 120, 255, 1, 46366), -- Bat02 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+40, 180427, 1, 405, 608, '0', 0, 0, 245.9895782470703125, 1252.6788330078125, 224.909088134765625, 1.937312245368957519, 0, 0, 0.824125289916992187, 0.566407561302185058, 120, 255, 1, 46366), -- Bat02 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+41, 180427, 1, 405, 608, '0', 0, 0, 245.8852081298828125, 1252.771484375, 221.2066802978515625, 1.291541695594787597, 0, 0, 0.60181427001953125, 0.798636078834533691, 120, 255, 1, 46366), -- Bat02 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+42, 180471, 1, 405, 608, '0', 0, 0, 230.8975677490234375, 1256.30908203125, 200.013153076171875, 0.15707901120185852, 0, 0, 0.078458786010742187, 0.996917366981506347, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+43, 180471, 1, 405, 608, '0', 0, 0, 233.92535400390625, 1243.501708984375, 200.5011138916015625, 3.333590030670166015, 0, 0, -0.99539566040039062, 0.095851235091686248, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+44, 180471, 1, 405, 608, '0', 0, 0, 259.958343505859375, 1242.7239990234375, 198.736785888671875, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+45, 180471, 1, 405, 608, '0', 0, 0, 260.314239501953125, 1236.01220703125, 198.7664642333984375, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+46, 180471, 1, 405, 608, '0', 0, 0, 251.3125, 1274.0242919921875, 198.7124176025390625, 4.939284324645996093, 0, 0, -0.6225137710571289, 0.78260880708694458, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+47, 180471, 1, 405, 608, '0', 0, 0, 253.90972900390625, 1267.8975830078125, 198.78460693359375, 4.991643905639648437, 0, 0, -0.60181427001953125, 0.798636078834533691, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+48, 180472, 1, 405, 608, '0', 0, 0, 225.439239501953125, 1242.1961669921875, 202.1258544921875, 1.797688722610473632, 0, 0, 0.7826080322265625, 0.622514784336090087, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+49, 180472, 1, 405, 608, '0', 0, 0, 222.9340362548828125, 1252.55908203125, 202.11334228515625, 4.939284324645996093, 0, 0, -0.6225137710571289, 0.78260880708694458, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+50, 180472, 1, 405, 608, '0', 0, 0, 252.6979217529296875, 1224.99658203125, 200.0660400390625, 5.009094715118408203, 0, 0, -0.59482288360595703, 0.80385679006576538, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+51, 180472, 1, 405, 608, '0', 0, 0, 239.39410400390625, 1280.4410400390625, 200.0805511474609375, 1.954769015312194824, 0, 0, 0.829037666320800781, 0.559192776679992675, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+52, 180523, 1, 405, 608, '0', 0, 0, 237.8680572509765625, 1255.6007080078125, 192.4280853271484375, 4.555310726165771484, 0, 0, -0.76040554046630859, 0.649448513984680175, 120, 255, 1, 46366), -- Apple Bob (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+53, 190051, 1, 405, 608, '0', 0, 0, 254.6195831298828125, 1251.2564697265625, 193.4336395263671875, 4.537858963012695312, 0, 0, -0.76604366302490234, 0.642788589000701904, 120, 255, 1, 46366); -- Candy Bucket (Area: Nijel's Point - Difficulty: 0)
+
+-- Event spawns
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+53;
+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);
diff --git a/sql/updates/world/master/2022_11_12_04_world_desolace_shadowprey_village.sql b/sql/updates/world/master/2022_11_12_04_world_desolace_shadowprey_village.sql
new file mode 100644
index 00000000000..a0201ac047f
--- /dev/null
+++ b/sql/updates/world/master/2022_11_12_04_world_desolace_shadowprey_village.sql
@@ -0,0 +1,101 @@
+SET @OGUID := 247604;
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=46366 WHERE `entry`=190083; -- Candy Bucket
+
+UPDATE `gameobject_template_addon` SET `faction`=1735 WHERE `entry`=190083; -- Candy Bucket
+
+-- Quests
+UPDATE `quest_offer_reward` SET `VerifiedBuild`=46366 WHERE `ID`=12381;
+
+DELETE FROM `gameobject_queststarter` WHERE `id`=190083;
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(190083, 12381, 46366);
+
+UPDATE `gameobject_questender` SET `VerifiedBuild`=46366 WHERE (`id`=190083 AND `quest`=12381);
+
+DELETE FROM `game_event_gameobject_quest` WHERE `id`=190083;
+
+-- Old gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 227481 AND 227516;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 227481 AND 227516;
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+35;
+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, 405, 2408, '0', 0, 0, -1609.78125, 3160.184814453125, 47.56081390380859375, 1.361356139183044433, 0, 0, 0.629320144653320312, 0.77714616060256958, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+1, 180405, 1, 405, 2408, '0', 0, 0, -1603.46533203125, 3126.34033203125, 47.65386962890625, 5.759587764739990234, 0, 0, -0.25881862640380859, 0.965925931930541992, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+2, 180406, 1, 405, 2408, '0', 0, 0, -1609.9010009765625, 3124.209228515625, 62.99876785278320312, 6.073746204376220703, 0, 0, -0.10452842712402343, 0.994521915912628173, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+3, 180406, 1, 405, 2408, '0', 0, 0, -1582.0242919921875, 3165.58935546875, 47.56081771850585937, 6.021387100219726562, 0, 0, -0.13052558898925781, 0.991444945335388183, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+4, 180407, 1, 405, 2408, '0', 0, 0, -1610.4583740234375, 3131.244873046875, 47.65163040161132812, 0.226892471313476562, 0, 0, 0.113203048706054687, 0.993571877479553222, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+5, 180407, 1, 405, 2408, '0', 0, 0, -1575.6441650390625, 3136.975830078125, 47.56081390380859375, 4.537858963012695312, 0, 0, -0.76604366302490234, 0.642788589000701904, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+6, 180411, 1, 405, 2408, '0', 0, 0, -1610.9254150390625, 3122.731689453125, 53.09714126586914062, 0.628316879272460937, 0, 0, 0.309016227722167968, 0.95105677843093872, 120, 255, 1, 46366), -- G_Ghost_01 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+7, 180426, 1, 405, 2408, '0', 0, 0, -1592.8629150390625, 3149.125, 80.897186279296875, 4.834563255310058593, 0, 0, -0.66261959075927734, 0.748956084251403808, 120, 255, 1, 46366), -- Bat01 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+8, 180426, 1, 405, 2408, '0', 0, 0, -1592.93408203125, 3149.16845703125, 80.820770263671875, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 120, 255, 1, 46366), -- Bat01 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+9, 180426, 1, 405, 2408, '0', 0, 0, -1592.7708740234375, 3149.18408203125, 80.86794281005859375, 5.585053920745849609, 0, 0, -0.34202003479003906, 0.939692676067352294, 120, 255, 1, 46366), -- Bat01 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+10, 180426, 1, 405, 2408, '0', 0, 0, -1592.875, 3149.07470703125, 80.855194091796875, 3.43830275535583496, 0, 0, -0.98901557922363281, 0.147811368107795715, 120, 255, 1, 46366), -- Bat01 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+11, 180426, 1, 405, 2408, '0', 0, 0, -1592.8472900390625, 3149.061767578125, 80.85068511962890625, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 46366), -- Bat01 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+12, 180426, 1, 405, 2408, '0', 0, 0, -1592.87158203125, 3149.09375, 80.86968231201171875, 3.316144466400146484, 0, 0, -0.99619388580322265, 0.087165042757987976, 120, 255, 1, 46366), -- Bat01 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+13, 180426, 1, 405, 2408, '0', 0, 0, -1592.859375, 3148.88720703125, 80.710174560546875, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 46366), -- Bat01 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+14, 180426, 1, 405, 2408, '0', 0, 0, -1592.9896240234375, 3148.967041015625, 80.69730377197265625, 1.221729278564453125, 0, 0, 0.573575973510742187, 0.819152355194091796, 120, 255, 1, 46366), -- Bat01 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+15, 180426, 1, 405, 2408, '0', 0, 0, -1592.890625, 3149.119873046875, 80.873748779296875, 6.14356088638305664, 0, 0, -0.06975555419921875, 0.997564136981964111, 120, 255, 1, 46366), -- Bat01 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+16, 180426, 1, 405, 2408, '0', 0, 0, -1592.8367919921875, 3149.15625, 80.91947174072265625, 2.949595451354980468, 0, 0, 0.995395660400390625, 0.095851235091686248, 120, 255, 1, 46366), -- Bat01 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+17, 180427, 1, 405, 2408, '0', 0, 0, -1592.8975830078125, 3149.0322265625, 80.8090057373046875, 0.401424884796142578, 0, 0, 0.199367523193359375, 0.979924798011779785, 120, 255, 1, 46366), -- Bat02 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+18, 180427, 1, 405, 2408, '0', 0, 0, -1592.6441650390625, 3149.007080078125, 80.76430511474609375, 3.543023586273193359, 0, 0, -0.97992420196533203, 0.199370384216308593, 120, 255, 1, 46366), -- Bat02 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+19, 180427, 1, 405, 2408, '0', 0, 0, -1592.7691650390625, 3149.16748046875, 80.87404632568359375, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 46366), -- Bat02 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+20, 180427, 1, 405, 2408, '0', 0, 0, -1592.8367919921875, 3149.092041015625, 80.8762664794921875, 2.426007747650146484, 0, 0, 0.936672210693359375, 0.350207358598709106, 120, 255, 1, 46366), -- Bat02 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+21, 180427, 1, 405, 2408, '0', 0, 0, -1592.9254150390625, 3149.0625, 80.80925750732421875, 2.059488296508789062, 0, 0, 0.857167243957519531, 0.515038192272186279, 120, 255, 1, 46366), -- Bat02 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+22, 180427, 1, 405, 2408, '0', 0, 0, -1592.8367919921875, 3149.174560546875, 80.91622161865234375, 0.349065244197845458, 0, 0, 0.173647880554199218, 0.984807789325714111, 120, 255, 1, 46366), -- Bat02 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+23, 180427, 1, 405, 2408, '0', 0, 0, -1592.8958740234375, 3148.935791015625, 80.74371337890625, 4.223697185516357421, 0, 0, -0.85716724395751953, 0.515038192272186279, 120, 255, 1, 46366), -- Bat02 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+24, 180427, 1, 405, 2408, '0', 0, 0, -1592.8367919921875, 3149.142333984375, 80.9112701416015625, 4.642575740814208984, 0, 0, -0.731353759765625, 0.681998312473297119, 120, 255, 1, 46366), -- Bat02 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+25, 180427, 1, 405, 2408, '0', 0, 0, -1592.85595703125, 3149.190185546875, 80.9032135009765625, 2.426007747650146484, 0, 0, 0.936672210693359375, 0.350207358598709106, 120, 255, 1, 46366), -- Bat02 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+26, 180427, 1, 405, 2408, '0', 0, 0, -1592.9254150390625, 3149.140625, 80.8411712646484375, 5.550147056579589843, 0, 0, -0.358367919921875, 0.933580458164215087, 120, 255, 1, 46366), -- Bat02 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+27, 180471, 1, 405, 2408, '0', 0, 0, -1602.8021240234375, 3126.710205078125, 50.84427261352539062, 5.532694816589355468, 0, 0, -0.3665008544921875, 0.93041771650314331, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+28, 180471, 1, 405, 2408, '0', 0, 0, -1609.9305419921875, 3131.578125, 50.72977828979492187, 5.637413978576660156, 0, 0, -0.31730461120605468, 0.948323667049407958, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+29, 180471, 1, 405, 2408, '0', 0, 0, -1578.826416015625, 3138.7353515625, 51.14436721801757812, 4.084071159362792968, 0, 0, -0.8910064697265625, 0.453990638256072998, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+30, 180472, 1, 405, 2408, '0', 0, 0, -1607.0538330078125, 3158.33935546875, 52.42725372314453125, 5.811946868896484375, 0, 0, -0.2334451675415039, 0.972369968891143798, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+31, 180472, 1, 405, 2408, '0', 0, 0, -1586.9132080078125, 3158.36376953125, 52.4399566650390625, 4.258606910705566406, 0, 0, -0.84804725646972656, 0.529920578002929687, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+32, 180472, 1, 405, 2408, '0', 0, 0, -1585.5521240234375, 3139.678955078125, 52.02799224853515625, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+33, 180472, 1, 405, 2408, '0', 0, 0, -1582.26220703125, 3144.87060546875, 52.05577468872070312, 3.752462387084960937, 0, 0, -0.95371627807617187, 0.300707906484603881, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+34, 180523, 1, 405, 2408, '0', 0, 0, -1582.52783203125, 3141.48876953125, 47.22888946533203125, 3.700104713439941406, 0, 0, -0.96126079559326171, 0.275640487670898437, 120, 255, 1, 46366), -- Apple Bob (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+35, 190083, 1, 405, 2408, '0', 0, 0, -1595.170166015625, 3150.905517578125, 46.95806121826171875, 0.017452461645007133, 0, 0, 0.008726119995117187, 0.999961912631988525, 120, 255, 1, 46366); -- Candy Bucket (Area: Shadowprey Village - Difficulty: 0)
+
+-- Event spawns
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+35;
+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);
diff --git a/sql/updates/world/master/2022_11_12_05_world_desolace_karnums_glade.sql b/sql/updates/world/master/2022_11_12_05_world_desolace_karnums_glade.sql
new file mode 100644
index 00000000000..1724350b77e
--- /dev/null
+++ b/sql/updates/world/master/2022_11_12_05_world_desolace_karnums_glade.sql
@@ -0,0 +1,139 @@
+SET @OGUID := 247640;
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=46366 WHERE `entry`=208157; -- Candy Bucket
+
+UPDATE `gameobject_template_addon` SET `faction`=35 WHERE `entry`=208157; -- Candy Bucket
+
+-- Quests
+DELETE FROM `quest_offer_reward` WHERE `ID`=28993;
+INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES
+(28993, 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`=208157;
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(208157, 28993, 46366);
+
+UPDATE `gameobject_questender` SET `VerifiedBuild`=46366 WHERE (`id`=208157 AND `quest`=28993);
+
+DELETE FROM `game_event_gameobject_quest` WHERE `id`=208157;
+
+-- Old gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 228305 AND 228357;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 228305 AND 228357;
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+53;
+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, 405, 4804, '0', 0, 0, -945.03643798828125, 1628.1666259765625, 65.23195648193359375, 2.024578809738159179, 0, 0, 0.848047256469726562, 0.529920578002929687, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Cenarion Wildlands - Difficulty: 0)
+(@OGUID+1, 180405, 1, 405, 4804, '0', 0, 0, -966.795166015625, 1673.2239990234375, 65.2319488525390625, 3.595378875732421875, 0, 0, -0.97437000274658203, 0.224951311945915222, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Cenarion Wildlands - Difficulty: 0)
+(@OGUID+2, 180405, 1, 405, 4805, '0', 0, 0, -1008.8367919921875, 1623.3367919921875, 65.2319488525390625, 5.567600727081298828, 0, 0, -0.35020732879638671, 0.936672210693359375, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+3, 180405, 1, 405, 4804, '0', 0, 0, -1044.125, 1669.2847900390625, 59.85930633544921875, 1.047197580337524414, 0, 0, 0.5, 0.866025388240814208, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Cenarion Wildlands - Difficulty: 0)
+(@OGUID+4, 180406, 1, 405, 4805, '0', 0, 0, -1011.69097900390625, 1650.3194580078125, 65.2319488525390625, 5.113816738128662109, 0, 0, -0.55193614959716796, 0.833886384963989257, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+5, 180406, 1, 405, 4805, '0', 0, 0, -962.1944580078125, 1608.5867919921875, 65.2319488525390625, 1.029743075370788574, 0, 0, 0.492423057556152343, 0.870355963706970214, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+6, 180406, 1, 405, 4805, '0', 0, 0, -1094.109375, 1657.513916015625, 60.91345977783203125, 2.932138919830322265, 0, 0, 0.994521141052246093, 0.104535527527332305, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+7, 180407, 1, 405, 4804, '0', 0, 0, -946.185791015625, 1654.6007080078125, 65.23195648193359375, 2.757613182067871093, 0, 0, 0.981626510620117187, 0.190812408924102783, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Cenarion Wildlands - Difficulty: 0)
+(@OGUID+8, 180407, 1, 405, 4805, '0', 0, 0, -993.5399169921875, 1671.107666015625, 65.23195648193359375, 3.857182979583740234, 0, 0, -0.93667125701904296, 0.350209832191467285, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+9, 180407, 1, 405, 4805, '0', 0, 0, -989, 1606.3125, 65.2319488525390625, 0.209439441561698913, 0, 0, 0.104528427124023437, 0.994521915912628173, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+10, 180407, 1, 405, 4805, '0', 0, 0, -1047.4774169921875, 1609.3055419921875, 60.01761245727539062, 2.338739633560180664, 0, 0, 0.920504570007324218, 0.3907318115234375, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+11, 180410, 1, 405, 4805, '0', 0, 0, -998.18402099609375, 1594.7430419921875, 61.21399688720703125, 1.413715124130249023, 0, 0, 0.649447441101074218, 0.760406434535980224, 120, 255, 1, 46366), -- G_HangingSkeleton_01 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+12, 180415, 1, 405, 4805, '0', 0, 0, -944.33856201171875, 1592.529541015625, 60.95909881591796875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+13, 180415, 1, 405, 4805, '0', 0, 0, -954.40277099609375, 1599.795166015625, 60.27069854736328125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+14, 180415, 1, 405, 4805, '0', 0, 0, -958.0399169921875, 1596.220458984375, 60.54174041748046875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+15, 180415, 1, 405, 4805, '0', 0, 0, -953.48785400390625, 1593.138916015625, 61.0576171875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+16, 180415, 1, 405, 4805, '0', 0, 0, -946.263916015625, 1588.248291015625, 60.86791229248046875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+17, 180415, 1, 405, 4805, '0', 0, 0, -951.32293701171875, 1595.388916015625, 60.72307586669921875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+18, 180415, 1, 405, 4805, '0', 0, 0, -1037.298583984375, 1640.470458984375, 60.5652618408203125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+19, 180415, 1, 405, 4805, '0', 0, 0, -1030.84033203125, 1642.2603759765625, 60.00897216796875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+20, 180415, 1, 405, 4805, '0', 0, 0, -1030.8697509765625, 1636.43408203125, 60.19165802001953125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+21, 180415, 1, 405, 4805, '0', 0, 0, -1034.57470703125, 1640.6129150390625, 60.25720977783203125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+22, 180415, 1, 405, 4805, '0', 0, 0, -1027.4305419921875, 1638.9913330078125, 59.98186111450195312, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+23, 180415, 1, 405, 4805, '0', 0, 0, -1025.4896240234375, 1619.8819580078125, 60.21964645385742187, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+24, 180415, 1, 405, 4805, '0', 0, 0, -1024.99658203125, 1612.0103759765625, 59.85584259033203125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+25, 180415, 1, 405, 4805, '0', 0, 0, -984.859375, 1593.60595703125, 59.89788055419921875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+26, 180415, 1, 405, 4805, '0', 0, 0, -1034.373291015625, 1634.8819580078125, 60.2301788330078125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+27, 180415, 1, 405, 4805, '0', 0, 0, -1012.30548095703125, 1607.80908203125, 59.93840789794921875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+28, 180415, 1, 405, 4805, '0', 0, 0, -1000.81951904296875, 1597.7864990234375, 59.86505889892578125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+29, 180415, 1, 405, 4805, '0', 0, 0, -1021.00347900390625, 1621.3072509765625, 59.96859359741210937, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+30, 180415, 1, 405, 4805, '0', 0, 0, -1030.8125, 1617.9879150390625, 60.12982940673828125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+31, 180415, 1, 405, 4805, '0', 0, 0, -1019.123291015625, 1615.3228759765625, 59.85802459716796875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+32, 180415, 1, 405, 4805, '0', 0, 0, -957.046875, 1566.7396240234375, 60.1750640869140625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+33, 180415, 1, 405, 4805, '0', 0, 0, -960.078125, 1562.5399169921875, 60.34851837158203125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+34, 180415, 1, 405, 4805, '0', 0, 0, -965.22918701171875, 1566.435791015625, 60.34218215942382812, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+35, 180415, 1, 405, 4805, '0', 0, 0, -967.90802001953125, 1575.185791015625, 59.91448974609375, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+36, 180415, 1, 405, 4805, '0', 0, 0, -962.6163330078125, 1570.8333740234375, 60.07040023803710937, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+37, 180415, 1, 405, 4805, '0', 0, 0, -969.248291015625, 1567.2847900390625, 60.04226303100585937, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- CandleBlack01 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+38, 180425, 1, 405, 4804, '0', 0, 0, -1041.6007080078125, 1659.982666015625, 62.3169708251953125, 5.759587764739990234, 0, 0, -0.25881862640380859, 0.965925931930541992, 120, 255, 1, 46366), -- SkullCandle01 (Area: Cenarion Wildlands - Difficulty: 0)
+(@OGUID+39, 180426, 1, 405, 4804, '0', 0, 0, -939.02606201171875, 1660.8958740234375, 59.86583709716796875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Cenarion Wildlands - Difficulty: 0)
+(@OGUID+40, 180426, 1, 405, 4804, '0', 0, 0, -978.66839599609375, 1677.23095703125, 63.265625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Cenarion Wildlands - Difficulty: 0)
+(@OGUID+41, 180426, 1, 405, 4804, '0', 0, 0, -939.29864501953125, 1620.407958984375, 59.88861846923828125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Cenarion Wildlands - Difficulty: 0)
+(@OGUID+42, 180426, 1, 405, 4805, '0', 0, 0, -971.97222900390625, 1593.2117919921875, 59.90062332153320312, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+43, 180426, 1, 405, 4805, '0', 0, 0, -1026.7882080078125, 1654.8055419921875, 59.91766357421875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+44, 180426, 1, 405, 4805, '0', 0, 0, -1009.19622802734375, 1664.0035400390625, 59.85584259033203125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat01 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+45, 180427, 1, 405, 4804, '0', 0, 0, -940.75177001953125, 1655.59033203125, 60.9012603759765625, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Cenarion Wildlands - Difficulty: 0)
+(@OGUID+46, 180427, 1, 405, 4804, '0', 0, 0, -939.66839599609375, 1647.9322509765625, 60.27737808227539062, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Cenarion Wildlands - Difficulty: 0)
+(@OGUID+47, 180427, 1, 405, 4804, '0', 0, 0, -982.39410400390625, 1682.3524169921875, 59.85596466064453125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Cenarion Wildlands - Difficulty: 0)
+(@OGUID+48, 180427, 1, 405, 4805, '0', 0, 0, -1018.3245849609375, 1648.763916015625, 60.21622848510742187, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+49, 180427, 1, 405, 4805, '0', 0, 0, -1016.71527099609375, 1630.8541259765625, 65.23198699951171875, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+50, 180427, 1, 405, 4805, '0', 0, 0, -963.9149169921875, 1599.6649169921875, 59.9457550048828125, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Bat02 (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+51, 180472, 1, 405, 4804, '0', 0, 0, -1042.7083740234375, 1673.5972900390625, 68.29161834716796875, 5.218535900115966796, 0, 0, -0.507537841796875, 0.861629426479339599, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Cenarion Wildlands - Difficulty: 0)
+(@OGUID+52, 180523, 1, 405, 4805, '0', 0, 0, -1032.8853759765625, 1674.3367919921875, 60.27830123901367187, 4.939284324645996093, 0, 0, -0.6225137710571289, 0.78260880708694458, 120, 255, 1, 46366), -- Apple Bob (Area: Karnum's Glade - Difficulty: 0)
+(@OGUID+53, 208157, 1, 405, 4804, '0', 0, 0, -1050.595458984375, 1683.173583984375, 60.13857650756835937, 1.082102894783020019, 0, 0, 0.51503753662109375, 0.857167601585388183, 120, 255, 1, 46366); -- Candy Bucket (Area: Cenarion Wildlands - Difficulty: 0)
+
+-- Event spawns
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+53;
+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);