DB/BlastedLands: Added Hallows End spawns

author: Meji <alvaro.megias@outlook.com> 2023-11-22 20:41:57 +0100
committer: Meji <alvaro.megias@outlook.com> 2023-11-22 20:41:57 +0100
commit: be599c48ed891add91488a6bd6c26c2270f602a6 (patch)
tree: cbcba17d645bdadfca0eeb3363dcd7fc8cf3ef51
parent: 0d11ccd36be7f742f74551a68f9f5bef1c952e04 (diff)
3 files changed, 769 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_11_22_04_world_blasted_lands_dreadmaul_hold.sql b/sql/updates/world/master/2023_11_22_04_world_blasted_lands_dreadmaul_hold.sql
new file mode 100644
index 00000000000..6f5eb048d4a
--- /dev/null
+++ b/sql/updates/world/master/2023_11_22_04_world_blasted_lands_dreadmaul_hold.sql
@@ -0,0 +1,259 @@
+SET @CGUID := 3000347;
+SET @OGUID := 3005674;
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=51886 WHERE `entry`=208144; -- Candy Bucket
+
+UPDATE `gameobject_template_addon` SET `faction`=1735 WHERE `entry`=208144; -- Candy Bucket
+
+-- Quests
+DELETE FROM `quest_offer_reward` WHERE `ID`=28959;
+INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES
+(28959, 0, 0, 0, 0, 0, 0, 0, 0, 'Candy buckets like this are located in inns throughout the realms. Go ahead... take some!', 51886); -- Candy Bucket
+
+DELETE FROM `gameobject_queststarter` WHERE `id`=208144;
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(208144, 28959, 51886);
+
+UPDATE `gameobject_questender` SET `VerifiedBuild`=51886 WHERE (`id`=208144 AND `quest`=28959);
+
+DELETE FROM `game_event_gameobject_quest` WHERE `id`=208144;
+
+-- 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`, `unit_flags2`, `unit_flags3`, `VerifiedBuild`) VALUES
+(@CGUID+0, 22816, 0, 4, 1437, '0', 0, 0, 0, 0, -10854.5068359375, -2662.6806640625, 55.06182098388671875, 0, 120, 0, 0, 1129, 0, 0, NULL, NULL, NULL, NULL, 51886); -- Black Cat (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+
+-- Old gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 231534 AND 231616;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 231534 AND 231616;
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+108;
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
+(@OGUID+0, 180405, 0, 4, 1437, '0', 0, 0, -10910.3837890625, -2781.6875, 27.11775779724121093, 4.782202720642089843, 0, 0, -0.68199825286865234, 0.731353819370269775, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+1, 180405, 0, 4, 1437, '0', 0, 0, -10890.7607421875, -2715.4150390625, 13.47322654724121093, 5.585053920745849609, 0, 0, -0.34202003479003906, 0.939692676067352294, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+2, 180405, 0, 4, 1437, '0', 0, 0, -10910.2607421875, -2692.03125, 13.51072406768798828, 6.056293010711669921, 0, 0, -0.11320304870605468, 0.993571877479553222, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+3, 180408, 0, 4, 1437, '0', 0, 0, -10867.7392578125, -2692.520751953125, 12.28029727935791015, 3.106652259826660156, 0, 0, 0.999847412109375, 0.017469281330704689, 120, 255, 1, 51886), -- G_WitchHat_01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+4, 180408, 0, 4, 1437, '0', 0, 0, -10884.8134765625, -2672.1806640625, 12.39948844909667968, 0.907570242881774902, 0, 0, 0.438370704650878906, 0.898794233798980712, 120, 255, 1, 51886), -- G_WitchHat_01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+5, 180408, 0, 4, 1437, '0', 0, 0, -10879.228515625, -2667.1650390625, 12.27243518829345703, 0.15707901120185852, 0, 0, 0.078458786010742187, 0.996917366981506347, 120, 255, 1, 51886), -- G_WitchHat_01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+6, 180408, 0, 4, 1437, '0', 0, 0, -10861.591796875, -2687.84375, 12.40300941467285156, 4.258606910705566406, 0, 0, -0.84804725646972656, 0.529920578002929687, 120, 255, 1, 51886), -- G_WitchHat_01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+7, 180410, 0, 4, 1437, '0', 0, 0, -10933.021484375, -2796.90966796875, 26.38058280944824218, 1.867502212524414062, 0, 0, 0.803856849670410156, 0.594822824001312255, 120, 255, 1, 51886), -- G_HangingSkeleton_01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+8, 180410, 0, 4, 1437, '0', 0, 0, -10937.939453125, -2793.989501953125, 26.41790771484375, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 51886), -- G_HangingSkeleton_01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+9, 180411, 0, 4, 1437, '0', 0, 0, -10946.716796875, -2772.248291015625, 11.16553115844726562, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+10, 180414, 0, 4, 1437, '0', 0, 0, -10941.2099609375, -2762.298583984375, 7.439187049865722656, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Cauldron (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+11, 180415, 0, 4, 1437, '0', 0, 0, -10931.7080078125, -2796.625, 25.58553695678710937, 2.495818138122558593, 0, 0, 0.948323249816894531, 0.317305892705917358, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+12, 180415, 0, 4, 1437, '0', 0, 0, -10938.08203125, -2793.05029296875, 25.47644996643066406, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+13, 180415, 0, 4, 1437, '0', 0, 0, -10936.7080078125, -2794.34375, 25.65151405334472656, 0.226892471313476562, 0, 0, 0.113203048706054687, 0.993571877479553222, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+14, 180415, 0, 4, 1437, '0', 0, 0, -10932.486328125, -2795.96875, 25.64968490600585937, 5.340708732604980468, 0, 0, -0.45398998260498046, 0.891006767749786376, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+15, 180415, 0, 4, 1437, '0', 0, 0, -10931.5712890625, -2796.23779296875, 25.46962928771972656, 6.073746204376220703, 0, 0, -0.10452842712402343, 0.994521915912628173, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+16, 180415, 0, 4, 1437, '0', 0, 0, -10931.326171875, -2796.55908203125, 25.56562232971191406, 5.550147056579589843, 0, 0, -0.358367919921875, 0.933580458164215087, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+17, 180415, 0, 4, 1437, '0', 0, 0, -10936.9912109375, -2793.432373046875, 25.61476516723632812, 3.752462387084960937, 0, 0, -0.95371627807617187, 0.300707906484603881, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+18, 180415, 0, 4, 1437, '0', 0, 0, -10936.7412109375, -2793.9306640625, 25.61432838439941406, 3.682650327682495117, 0, 0, -0.96362972259521484, 0.26724100112915039, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+19, 180415, 0, 4, 1437, '0', 0, 0, -10937.4755859375, -2793.078125, 25.58017730712890625, 0.191985160112380981, 0, 0, 0.095845222473144531, 0.995396256446838378, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+20, 180415, 0, 4, 1437, '0', 0, 0, -10880.2724609375, -2696.053955078125, 21.04797172546386718, 4.48549652099609375, 0, 0, -0.7826080322265625, 0.622514784336090087, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+21, 180415, 0, 4, 1437, '0', 0, 0, -10882.25390625, -2694.307373046875, 21.18779182434082031, 3.24634718894958496, 0, 0, -0.99862861633300781, 0.052353221923112869, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+22, 180415, 0, 4, 1437, '0', 0, 0, -10872.59375, -2699.845458984375, 22.39959335327148437, 5.881760597229003906, 0, 0, -0.19936752319335937, 0.979924798011779785, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+23, 180415, 0, 4, 1437, '0', 0, 0, -10870.4384765625, -2698.451416015625, 20.96318244934082031, 1.064649581909179687, 0, 0, 0.507537841796875, 0.861629426479339599, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+24, 180415, 0, 4, 1437, '0', 0, 0, -10889.8505859375, -2684.567626953125, 21.07930946350097656, 3.124123096466064453, 0, 0, 0.99996185302734375, 0.008734640665352344, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+25, 180415, 0, 4, 1437, '0', 0, 0, -10876.3388671875, -2699.53125, 22.39856529235839843, 3.874631166458129882, 0, 0, -0.93358039855957031, 0.358368009328842163, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+26, 180415, 0, 4, 1437, '0', 0, 0, -10868.533203125, -2696.796875, 21.08182525634765625, 6.03883981704711914, 0, 0, -0.12186908721923828, 0.9925462007522583, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+27, 180415, 0, 4, 1437, '0', 0, 0, -10888.39453125, -2687.007080078125, 21.21856880187988281, 4.1538848876953125, 0, 0, -0.8746194839477539, 0.484810054302215576, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+28, 180415, 0, 4, 1437, '0', 0, 0, -10878.40625, -2697.6962890625, 20.94845008850097656, 4.014260292053222656, 0, 0, -0.90630722045898437, 0.422619491815567016, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+29, 180415, 0, 4, 1437, '0', 0, 0, -10866.7451171875, -2695.263916015625, 21.18761825561523437, 0.349065244197845458, 0, 0, 0.173647880554199218, 0.984807789325714111, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+30, 180415, 0, 4, 1437, '0', 0, 0, -10863.921875, -2692.0244140625, 21.28647994995117187, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+31, 180415, 0, 4, 1437, '0', 0, 0, -10892.205078125, -2680.98095703125, 22.40239143371582031, 3.752462387084960937, 0, 0, -0.95371627807617187, 0.300707906484603881, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+32, 180415, 0, 4, 1437, '0', 0, 0, -10864.96875, -2693.732666015625, 21.26141357421875, 0.401424884796142578, 0, 0, 0.199367523193359375, 0.979924798011779785, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+33, 180415, 0, 4, 1437, '0', 0, 0, -10891.513671875, -2682.12158203125, 20.86907768249511718, 3.874631166458129882, 0, 0, -0.93358039855957031, 0.358368009328842163, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+34, 180415, 0, 4, 1437, '0', 0, 0, -10878.7451171875, -2664.782958984375, 21.16489219665527343, 0.174532130360603332, 0, 0, 0.087155342102050781, 0.996194720268249511, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+35, 180415, 0, 4, 1437, '0', 0, 0, -10880.96875, -2666.607666015625, 21.26066398620605468, 2.652894020080566406, 0, 0, 0.970294952392578125, 0.241925001144409179, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+36, 180415, 0, 4, 1437, '0', 0, 0, -10853.3408203125, -2683.953125, 20.49903297424316406, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+37, 180415, 0, 4, 1437, '0', 0, 0, -10857.5283203125, -2687.4375, 21.04805946350097656, 5.113816738128662109, 0, 0, -0.55193614959716796, 0.833886384963989257, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+38, 180415, 0, 4, 1437, '0', 0, 0, -10889.828125, -2674.276123046875, 20.99936866760253906, 1.32644820213317871, 0, 0, 0.615660667419433593, 0.788011372089385986, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+39, 180415, 0, 4, 1437, '0', 0, 0, -10876.267578125, -2662.685791015625, 20.9932098388671875, 3.036838293075561523, 0, 0, 0.998628616333007812, 0.052353221923112869, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+40, 180415, 0, 4, 1437, '0', 0, 0, -10862.3486328125, -2690.73095703125, 21.27455711364746093, 5.811946868896484375, 0, 0, -0.2334451675415039, 0.972369968891143798, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+41, 180415, 0, 4, 1437, '0', 0, 0, -10886.419921875, -2671.392333984375, 21.19450569152832031, 2.652894020080566406, 0, 0, 0.970294952392578125, 0.241925001144409179, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+42, 180415, 0, 4, 1437, '0', 0, 0, -10884.4130859375, -2670.09033203125, 21.27244377136230468, 1.466075778007507324, 0, 0, 0.669130325317382812, 0.74314504861831665, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+43, 180415, 0, 4, 1437, '0', 0, 0, -10859.103515625, -2688.78125, 21.08301353454589843, 3.52557229995727539, 0, 0, -0.98162651062011718, 0.190812408924102783, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+44, 180415, 0, 4, 1437, '0', 0, 0, -10855.7568359375, -2685.939208984375, 20.9032440185546875, 6.12610626220703125, 0, 0, -0.07845878601074218, 0.996917366981506347, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+45, 180415, 0, 4, 1437, '0', 0, 0, -10888.08203125, -2672.782958984375, 21.15075302124023437, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+46, 180415, 0, 4, 1437, '0', 0, 0, -10860.6474609375, -2690.064208984375, 21.21953773498535156, 5.95157480239868164, 0, 0, -0.16504669189453125, 0.986285746097564697, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+47, 180415, 0, 4, 1437, '0', 0, 0, -10891.810546875, -2676.390625, 22.41292762756347656, 4.049167633056640625, 0, 0, -0.89879322052001953, 0.438372820615768432, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+48, 180415, 0, 4, 1437, '0', 0, 0, -10882.607421875, -2668.475830078125, 21.36581993103027343, 3.211419343948364257, 0, 0, -0.9993906021118164, 0.034906134009361267, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+49, 180415, 0, 4, 1437, '0', 0, 0, -10872.3330078125, -2659.755126953125, 22.41662025451660156, 0.907570242881774902, 0, 0, 0.438370704650878906, 0.898794233798980712, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+50, 180415, 0, 4, 1437, '0', 0, 0, -10870.2080078125, -2660.260498046875, 22.40339088439941406, 3.45575571060180664, 0, 0, -0.98768806457519531, 0.156436234712600708, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+51, 180415, 0, 4, 1437, '0', 0, 0, -10867.3330078125, -2663.6875, 20.87957191467285156, 0.087265998125076293, 0, 0, 0.043619155883789062, 0.999048233032226562, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+52, 180415, 0, 4, 1437, '0', 0, 0, -10863.9169921875, -2667.77783203125, 21.21164894104003906, 1.762782454490661621, 0, 0, 0.771624565124511718, 0.636078238487243652, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+53, 180415, 0, 4, 1437, '0', 0, 0, -10869.1630859375, -2661.498291015625, 20.72495269775390625, 2.042035102844238281, 0, 0, 0.852640151977539062, 0.522498607635498046, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+54, 180415, 0, 4, 1437, '0', 0, 0, -10857.67578125, -2675.13720703125, 21.09292793273925781, 1.274088263511657714, 0, 0, 0.594821929931640625, 0.80385744571685791, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+55, 180415, 0, 4, 1437, '0', 0, 0, -10862.09375, -2671.314208984375, 21.2926483154296875, 0.104719325900077819, 0, 0, 0.052335739135742187, 0.998629570007324218, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+56, 180415, 0, 4, 1437, '0', 0, 0, -10854.75390625, -2678.630126953125, 20.81046676635742187, 5.916667938232421875, 0, 0, -0.18223476409912109, 0.98325502872467041, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+57, 180415, 0, 4, 1437, '0', 0, 0, -10860.9619140625, -2672.61279296875, 21.28261756896972656, 0.314158439636230468, 0, 0, 0.156434059143066406, 0.987688362598419189, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+58, 180415, 0, 4, 1437, '0', 0, 0, -10873.548828125, -2660.354248046875, 20.64093208312988281, 3.752462387084960937, 0, 0, -0.95371627807617187, 0.300707906484603881, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+59, 180415, 0, 4, 1437, '0', 0, 0, -10859.2236328125, -2673.357666015625, 21.26133537292480468, 1.239183306694030761, 0, 0, 0.580702781677246093, 0.814115643501281738, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+60, 180415, 0, 4, 1437, '0', 0, 0, -10853.1826171875, -2682.59716796875, 21.25728225708007812, 0.383971005678176879, 0, 0, 0.190808296203613281, 0.981627285480499267, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+61, 180415, 0, 4, 1437, '0', 0, 0, -10863.455078125, -2669.598876953125, 21.2589111328125, 0.523597896099090576, 0, 0, 0.258818626403808593, 0.965925931930541992, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+62, 180415, 0, 4, 1437, '0', 0, 0, -10853.0712890625, -2680.632080078125, 21.2674713134765625, 0.523597896099090576, 0, 0, 0.258818626403808593, 0.965925931930541992, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+63, 180415, 0, 4, 1437, '0', 0, 0, -10856.2158203125, -2676.857666015625, 21.01546669006347656, 1.413715124130249023, 0, 0, 0.649447441101074218, 0.760406434535980224, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+64, 180415, 0, 4, 1437, '0', 0, 0, -10865.453125, -2665.9306640625, 21.09947586059570312, 1.239183306694030761, 0, 0, 0.580702781677246093, 0.814115643501281738, 120, 255, 1, 51886), -- CandleBlack01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+65, 180425, 0, 4, 1437, '0', 0, 0, -10932.8193359375, -2795.96533203125, 25.69707679748535156, 1.396261811256408691, 0, 0, 0.642786979675292968, 0.766044974327087402, 120, 255, 1, 51886), -- SkullCandle01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+66, 180426, 0, 4, 1437, '0', 0, 0, -10981.107421875, -2774.01220703125, 19.45093727111816406, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+67, 180426, 0, 4, 1437, '0', 0, 0, -10949.5400390625, -2766.82470703125, 32.81339645385742187, 5.672322273254394531, 0, 0, -0.3007049560546875, 0.953717231750488281, 120, 255, 1, 51886), -- Bat01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+68, 180426, 0, 4, 1437, '0', 0, 0, -10926.1474609375, -2750.795166015625, 33.78972244262695312, 4.084071159362792968, 0, 0, -0.8910064697265625, 0.453990638256072998, 120, 255, 1, 51886), -- Bat01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+69, 180426, 0, 4, 1437, '0', 0, 0, -10975.6357421875, -2770.654541015625, 24.09937858581542968, 0.715584874153137207, 0, 0, 0.350207328796386718, 0.936672210693359375, 120, 255, 1, 51886), -- Bat01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+70, 180427, 0, 4, 1437, '0', 0, 0, -10914.8388671875, -2786.30908203125, 25.67024612426757812, 5.811946868896484375, 0, 0, -0.2334451675415039, 0.972369968891143798, 120, 255, 1, 51886), -- Bat02 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+71, 180427, 0, 4, 1437, '0', 0, 0, -10966.263671875, -2763.541748046875, 22.07467079162597656, 4.468043327331542968, 0, 0, -0.7880105972290039, 0.615661680698394775, 120, 255, 1, 51886), -- Bat02 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+72, 180427, 0, 4, 1437, '0', 0, 0, -10937.015625, -2744.145751953125, 31.75851821899414062, 2.408554315567016601, 0, 0, 0.933580398559570312, 0.358368009328842163, 120, 255, 1, 51886), -- Bat02 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+73, 180427, 0, 4, 1437, '0', 0, 0, -10813.125, -2718.1025390625, 24.43842315673828125, 0.383971005678176879, 0, 0, 0.190808296203613281, 0.981627285480499267, 120, 255, 1, 51886), -- Bat02 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+74, 180471, 0, 4, 1437, '0', 0, 0, -10914.4482421875, -2787.776123046875, 30.84101676940917968, 4.049167633056640625, 0, 0, -0.89879322052001953, 0.438372820615768432, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+75, 180471, 0, 4, 1437, '0', 0, 0, -10915.3193359375, -2788.029541015625, 30.24696159362792968, 4.328419685363769531, 0, 0, -0.82903671264648437, 0.559194147586822509, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+76, 180471, 0, 4, 1437, '0', 0, 0, -10913.734375, -2787.3056640625, 31.01108551025390625, 3.45575571060180664, 0, 0, -0.98768806457519531, 0.156436234712600708, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+77, 180471, 0, 4, 1437, '0', 0, 0, -10913.3095703125, -2786.598876953125, 30.06057167053222656, 3.717553615570068359, 0, 0, -0.95881938934326171, 0.284016460180282592, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+78, 180471, 0, 4, 1437, '0', 0, 0, -10985.828125, -2743.486083984375, 11.39045429229736328, 0.226892471313476562, 0, 0, 0.113203048706054687, 0.993571877479553222, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+79, 180471, 0, 4, 1437, '0', 0, 0, -10985.294921875, -2743.001708984375, 11.72096061706542968, 0.663223206996917724, 0, 0, 0.325567245483398437, 0.945518851280212402, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+80, 180471, 0, 4, 1437, '0', 0, 0, -10986.341796875, -2743.892333984375, 10.93878841400146484, 1.117009282112121582, 0, 0, 0.529918670654296875, 0.84804844856262207, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+81, 180472, 0, 4, 1437, '0', 0, 0, -10981.3388671875, -2739.81591796875, 12.38718509674072265, 4.991643905639648437, 0, 0, -0.60181427001953125, 0.798636078834533691, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+82, 180523, 0, 4, 1437, '0', 0, 0, -10863.736328125, -2672.55029296875, 10, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 120, 255, 1, 51886), -- Apple Bob (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+83, 185438, 0, 4, 1437, '0', 0, 0, -10935.8857421875, -2796.335205078125, 25.83452033996582031, 0.27925160527229309, 0, 0, 0.139172554016113281, 0.990268170833587646, 120, 255, 1, 51886), -- Sitting Skeleton 04 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+84, 185454, 0, 4, 1437, '0', 0, 0, -10951.123046875, -2732.432373046875, 7.780379295349121093, 1.919861555099487304, 0, 0, 0.819151878356933593, 0.573576688766479492, 120, 255, 1, 51886), -- Laying Skeleton 02 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+85, 208057, 0, 4, 1437, '0', 0, 0, -10960.5986328125, -2805.107666015625, 25.33040809631347656, 5.95157480239868164, 0, 0, -0.16504669189453125, 0.986285746097564697, 120, 255, 1, 51886), -- G_Pumpkin_01 Scale 2.0 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+86, 208057, 0, 4, 1437, '0', 0, 0, -11035.70703125, -2726.470458984375, 29.81352424621582031, 5.881760597229003906, 0, 0, -0.19936752319335937, 0.979924798011779785, 120, 255, 1, 51886), -- G_Pumpkin_01 Scale 2.0 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+87, 208058, 0, 4, 1437, '0', 0, 0, -10886.6181640625, -2691.796875, 29.88393211364746093, 5.794494152069091796, 0, 0, -0.24192142486572265, 0.970295846462249755, 120, 255, 1, 51886), -- G_Pumpkin_01 Scale 3.0 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+88, 208061, 0, 4, 1437, '0', 0, 0, -11010.298828125, -2754.46875, 24.56011390686035156, 5.969027042388916015, 0, 0, -0.1564340591430664, 0.987688362598419189, 120, 255, 1, 51886), -- G_Pumpkin_02 Scale 2.0 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+89, 208061, 0, 4, 1437, '0', 0, 0, -11048.359375, -2712.453125, 30.43739891052246093, 6.03883981704711914, 0, 0, -0.12186908721923828, 0.9925462007522583, 120, 255, 1, 51886), -- G_Pumpkin_02 Scale 2.0 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+90, 208062, 0, 4, 1437, '0', 0, 0, -10945.748046875, -2816.338623046875, 27.55253410339355468, 5.462882041931152343, 0, 0, -0.39874839782714843, 0.917060375213623046, 120, 255, 1, 51886), -- G_Pumpkin_03 Scale 2.0 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+91, 208062, 0, 4, 1437, '0', 0, 0, -11022.84765625, -2741.460205078125, 25.54814529418945312, 5.89921426773071289, 0, 0, -0.19080829620361328, 0.981627285480499267, 120, 255, 1, 51886), -- G_Pumpkin_03 Scale 2.0 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+92, 208062, 0, 4, 1437, '0', 0, 0, -11061.2763671875, -2699.8369140625, 36.09294509887695312, 5.89921426773071289, 0, 0, -0.19080829620361328, 0.981627285480499267, 120, 255, 1, 51886), -- G_Pumpkin_03 Scale 2.0 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+93, 208064, 0, 4, 1437, '0', 0, 0, -10980.5048828125, -2739.32470703125, 9.357750892639160156, 5.235987663269042968, 0, 0, -0.5, 0.866025388240814208, 120, 255, 1, 51886), -- Web Corner (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+94, 208064, 0, 4, 1437, '0', 0, 0, -10987.080078125, -2744.114501953125, 9.373150825500488281, 2.042035102844238281, 0, 0, 0.852640151977539062, 0.522498607635498046, 120, 255, 1, 51886), -- Web Corner (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+95, 208069, 0, 4, 1437, '0', 0, 0, -10919.095703125, -2788.875, 28.64537239074707031, 3.43830275535583496, 0, 0, -0.98901557922363281, 0.147811368107795715, 120, 255, 1, 51886), -- G_Pumpkin_02 Scale 0.5 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+96, 208069, 0, 4, 1437, '0', 0, 0, -11013.8994140625, -2761.072998046875, 5.69873666763305664, 5.096362113952636718, 0, 0, -0.55919265747070312, 0.829037725925445556, 120, 255, 1, 51886), -- G_Pumpkin_02 Scale 0.5 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+97, 208069, 0, 4, 1437, '0', 0, 0, -10943.763671875, -2723.513916015625, 9.95449066162109375, 1.169368624687194824, 0, 0, 0.551936149597167968, 0.833886384963989257, 120, 255, 1, 51886), -- G_Pumpkin_02 Scale 0.5 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+98, 208070, 0, 4, 1437, '0', 0, 0, -10913.763671875, -2788.109375, 27.71202659606933593, 2.181660413742065429, 0, 0, 0.887010574340820312, 0.461749136447906494, 120, 255, 1, 51886), -- Web Hanging Scale 2.0 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+99, 208070, 0, 4, 1437, '0', 0, 0, -10886.4736328125, -2691.671875, 15.40763568878173828, 3.892086982727050781, 0, 0, -0.93041706085205078, 0.366502493619918823, 120, 255, 1, 51886), -- Web Hanging Scale 2.0 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+100, 208071, 0, 4, 1437, '0', 0, 0, -10872.3681640625, -2723.94970703125, 32.01842880249023437, 3.857182979583740234, 0, 0, -0.93667125701904296, 0.350209832191467285, 120, 255, 1, 51886), -- Web Hanging Scale 3.0 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+101, 208071, 0, 4, 1437, '0', 0, 0, -11035.107421875, -2738.67529296875, 15.28093147277832031, 3.857182979583740234, 0, 0, -0.93667125701904296, 0.350209832191467285, 120, 255, 1, 51886), -- Web Hanging Scale 3.0 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+102, 208071, 0, 4, 1437, '0', 0, 0, -11060.201171875, -2711.748291015625, 21.99753761291503906, 3.839725255966186523, 0, 0, -0.93969249725341796, 0.34202045202255249, 120, 255, 1, 51886), -- Web Hanging Scale 3.0 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+103, 208071, 0, 4, 1437, '0', 0, 0, -10914.9580078125, -2672.8681640625, 32.30809402465820312, 3.857182979583740234, 0, 0, -0.93667125701904296, 0.350209832191467285, 120, 255, 1, 51886), -- Web Hanging Scale 3.0 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+104, 208072, 0, 4, 1437, '0', 0, 0, -10909.9619140625, -2779.739501953125, 27.70479774475097656, 5.096362113952636718, 0, 0, -0.55919265747070312, 0.829037725925445556, 120, 255, 1, 51886), -- G_Pumpkin_03 Scale 0.5 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+105, 208072, 0, 4, 1437, '0', 0, 0, -10967.359375, -2817.708251953125, 8.939711570739746093, 5.096362113952636718, 0, 0, -0.55919265747070312, 0.829037725925445556, 120, 255, 1, 51886), -- G_Pumpkin_03 Scale 0.5 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+106, 208078, 0, 4, 1437, '0', 0, 0, -10950.470703125, -2725.845458984375, 9.944890975952148437, 0.331610709428787231, 0, 0, 0.16504669189453125, 0.986285746097564697, 120, 255, 1, 51886), -- G_Pumpkin_01 scale 0.5 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+107, 208078, 0, 4, 1437, '0', 0, 0, -11021.896484375, -2750.913330078125, 5.953338623046875, 5.881760597229003906, 0, 0, -0.19936752319335937, 0.979924798011779785, 120, 255, 1, 51886), -- G_Pumpkin_01 scale 0.5 (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+(@OGUID+108, 208144, 0, 4, 1437, '0', 0, 0, -10858.763671875, -2676.095458984375, 9.80770111083984375, 5.078907966613769531, 0, 0, -0.56640625, 0.824126183986663818, 120, 255, 1, 51886); -- Candy Bucket (Area: Dreadmaul Hold - Difficulty: 0) CreateObject1
+
+-- 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+108;
+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);
diff --git a/sql/updates/world/master/2023_11_22_05_world_blasted_lands_nethergarde_keep.sql b/sql/updates/world/master/2023_11_22_05_world_blasted_lands_nethergarde_keep.sql
new file mode 100644
index 00000000000..133b45c34ba
--- /dev/null
+++ b/sql/updates/world/master/2023_11_22_05_world_blasted_lands_nethergarde_keep.sql
@@ -0,0 +1,245 @@
+SET @CGUID := 3000348;
+SET @OGUID := 3005783;
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=51886 WHERE `entry`=208122; -- Candy Bucket
+
+UPDATE `gameobject_template_addon` SET `faction`=1732 WHERE `entry`=208122; -- Candy Bucket
+
+-- Quests
+UPDATE `quest_template` SET `Expansion`=9, `VerifiedBuild`=51886 WHERE `ID`=28960; -- Candy Bucket
+
+DELETE FROM `quest_offer_reward` WHERE `ID`=28960;
+INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES
+(28960, 0, 0, 0, 0, 0, 0, 0, 0, 'Candy buckets like this are located in inns throughout the realms. Go ahead... take some!', 51886); -- Candy Bucket
+
+DELETE FROM `gameobject_queststarter` WHERE `id`=208122;
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(208122, 28960, 51886);
+
+UPDATE `gameobject_questender` SET `VerifiedBuild`=51886 WHERE (`id`=208122 AND `quest`=28960);
+
+DELETE FROM `game_event_gameobject_quest` WHERE `id`=208122;
+
+-- Creature spawns
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+1;
+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`, `unit_flags2`, `unit_flags3`, `VerifiedBuild`) VALUES
+(@CGUID+0, 22816, 0, 4, 1438, '0', 0, 0, 0, 0, -11012.487234375, -3373.503349609375, 64.28792919921875, 6.144051074981689453, 120, 10, 0, 1129, 0, 1, NULL, NULL, NULL, NULL, 51886), -- Black Cat (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@CGUID+1, 22816, 0, 4, 1438, '0', 0, 0, 0, 0, -11112.21575, -3435.637314453125, 79.3337249755859375, 5.947369098663330078, 120, 5, 0, 1129, 0, 1, NULL, NULL, NULL, NULL, 51886); -- Black Cat (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+101;
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
+(@OGUID+0, 180405, 0, 4, 1438, '0', 0, 0, -11046.2568359375, -3398.210205078125, 68.50495147705078125, 2.303830623626708984, 0, 0, 0.913544654846191406, 0.406738430261611938, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+1, 180405, 0, 4, 1438, '0', 0, 0, -10953.7744140625, -3383.772705078125, 68.44934844970703125, 5.061456203460693359, 0, 0, -0.57357597351074218, 0.819152355194091796, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+2, 180405, 0, 4, 1438, '0', 0, 0, -11112.546875, -3439.303955078125, 79.0820465087890625, 4.136432647705078125, 0, 0, -0.87881660461425781, 0.477159708738327026, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+3, 180406, 0, 4, 1438, '0', 0, 0, -11039.2431640625, -3408.854248046875, 68.50495147705078125, 2.757613182067871093, 0, 0, 0.981626510620117187, 0.190812408924102783, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+4, 180407, 0, 4, 1438, '0', 0, 0, -10956.626953125, -3396.229248046875, 68.44934844970703125, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+5, 180408, 0, 4, 1438, '0', 0, 0, -11108.298828125, -3456.411376953125, 70.87290191650390625, 2.111847877502441406, 0, 0, 0.870355606079101562, 0.492423713207244873, 120, 255, 1, 51886), -- G_WitchHat_01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+6, 180408, 0, 4, 1438, '0', 0, 0, -11125.279296875, -3517.567626953125, 71.086181640625, 4.939284324645996093, 0, 0, -0.6225137710571289, 0.78260880708694458, 120, 255, 1, 51886), -- G_WitchHat_01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+7, 180408, 0, 4, 1438, '0', 0, 0, -11152.001953125, -3485.15283203125, 71.06095123291015625, 6.073746204376220703, 0, 0, -0.10452842712402343, 0.994521915912628173, 120, 255, 1, 51886), -- G_WitchHat_01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+8, 180410, 0, 4, 1438, '0', 0, 0, -11028.6494140625, -3371.7744140625, 66.39879608154296875, 4.991643905639648437, 0, 0, -0.60181427001953125, 0.798636078834533691, 120, 255, 1, 51886), -- G_HangingSkeleton_01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+9, 180410, 0, 4, 1438, '0', 0, 0, -10967.154296875, -3404.897705078125, 65.5581817626953125, 2.932138919830322265, 0, 0, 0.994521141052246093, 0.104535527527332305, 120, 255, 1, 51886), -- G_HangingSkeleton_01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+10, 180411, 0, 4, 1438, '0', 0, 0, -10949.705078125, -3391.489501953125, 71.04183197021484375, 5.777040958404541015, 0, 0, -0.25037956237792968, 0.968147754669189453, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+11, 180411, 0, 4, 1438, '0', 0, 0, -11047.3134765625, -3406.522705078125, 71.12029266357421875, 3.298687219619750976, 0, 0, -0.99691677093505859, 0.078466430306434631, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+12, 180415, 0, 4, 1438, '0', 0, 0, -11007.8974609375, -3387.109375, 64.48087310791015625, 4.328419685363769531, 0, 0, -0.82903671264648437, 0.559194147586822509, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+13, 180415, 0, 4, 1438, '0', 0, 0, -11003.7451171875, -3386.578125, 63.8908843994140625, 4.031712055206298828, 0, 0, -0.90258502960205078, 0.430511653423309326, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+14, 180415, 0, 4, 1438, '0', 0, 0, -11003.0712890625, -3390.8056640625, 63.75310516357421875, 3.560472726821899414, 0, 0, -0.97814750671386718, 0.207912087440490722, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+15, 180415, 0, 4, 1438, '0', 0, 0, -10992.6826171875, -3433.53466796875, 63.59180450439453125, 5.811946868896484375, 0, 0, -0.2334451675415039, 0.972369968891143798, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+16, 180415, 0, 4, 1438, '0', 0, 0, -10992.419921875, -3437.6494140625, 63.86163330078125, 4.502951622009277343, 0, 0, -0.7771453857421875, 0.629321098327636718, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+17, 180415, 0, 4, 1438, '0', 0, 0, -10989.0888671875, -3435.640625, 63.54892349243164062, 4.433136463165283203, 0, 0, -0.79863548278808593, 0.60181504487991333, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+18, 180415, 0, 4, 1438, '0', 0, 0, -11012.861328125, -3455.848876953125, 66.6010284423828125, 3.508116960525512695, 0, 0, -0.98325443267822265, 0.182238012552261352, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+19, 180415, 0, 4, 1438, '0', 0, 0, -10967.4482421875, -3456.046875, 66.58673095703125, 5.95157480239868164, 0, 0, -0.16504669189453125, 0.986285746097564697, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+20, 180415, 0, 4, 1438, '0', 0, 0, -11008.6025390625, -3455.60595703125, 66.57810211181640625, 5.340708732604980468, 0, 0, -0.45398998260498046, 0.891006767749786376, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+21, 180415, 0, 4, 1438, '0', 0, 0, -10966.169921875, -3452.09716796875, 66.55905914306640625, 6.021387100219726562, 0, 0, -0.13052558898925781, 0.991444945335388183, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+22, 180415, 0, 4, 1438, '0', 0, 0, -11004.4736328125, -3455.951416015625, 66.61136627197265625, 4.049167633056640625, 0, 0, -0.89879322052001953, 0.438372820615768432, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+23, 180415, 0, 4, 1438, '0', 0, 0, -11045.9287109375, -3459.416748046875, 67.31052398681640625, 4.310965538024902343, 0, 0, -0.83388519287109375, 0.55193793773651123, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+24, 180415, 0, 4, 1438, '0', 0, 0, -11042.7255859375, -3462.057373046875, 66.82050323486328125, 3.94444584846496582, 0, 0, -0.92050457000732421, 0.3907318115234375, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+25, 180415, 0, 4, 1438, '0', 0, 0, -11032.5107421875, -3470.604248046875, 66.594390869140625, 3.351046562194824218, 0, 0, -0.99452114105224609, 0.104535527527332305, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+26, 180415, 0, 4, 1438, '0', 0, 0, -11038.96875, -3465.2900390625, 66.58574676513671875, 3.94444584846496582, 0, 0, -0.92050457000732421, 0.3907318115234375, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+27, 180415, 0, 4, 1438, '0', 0, 0, -11048.8212890625, -3462.52783203125, 67.19550323486328125, 3.333590030670166015, 0, 0, -0.99539566040039062, 0.095851235091686248, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+28, 180415, 0, 4, 1438, '0', 0, 0, -11035.7861328125, -3468.032958984375, 66.60455322265625, 3.612837791442871093, 0, 0, -0.97236919403076171, 0.233448356389999389, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+29, 180415, 0, 4, 1438, '0', 0, 0, -11051.0732421875, -3466.00341796875, 66.90793609619140625, 4.520402908325195312, 0, 0, -0.77162456512451171, 0.636078238487243652, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+30, 180415, 0, 4, 1438, '0', 0, 0, -11055.203125, -3466.59716796875, 66.846954345703125, 5.393068790435791015, 0, 0, -0.43051052093505859, 0.902585566043853759, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+31, 180415, 0, 4, 1438, '0', 0, 0, -11071.5986328125, -3465.663330078125, 66.597442626953125, 3.769911527633666992, 0, 0, -0.95105648040771484, 0.309017121791839599, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+32, 180415, 0, 4, 1438, '0', 0, 0, -11111.603515625, -3431.255126953125, 79.07505035400390625, 6.12610626220703125, 0, 0, -0.07845878601074218, 0.996917366981506347, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+33, 180415, 0, 4, 1438, '0', 0, 0, -11060.896484375, -3472.623291015625, 66.6041107177734375, 5.323255538940429687, 0, 0, -0.46174812316894531, 0.887011110782623291, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+34, 180415, 0, 4, 1438, '0', 0, 0, -11058.392578125, -3469.270751953125, 66.70288848876953125, 3.700104713439941406, 0, 0, -0.96126079559326171, 0.275640487670898437, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+35, 180415, 0, 4, 1438, '0', 0, 0, -11075.765625, -3466.154541015625, 66.54193878173828125, 3.508116960525512695, 0, 0, -0.98325443267822265, 0.182238012552261352, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+36, 180415, 0, 4, 1438, '0', 0, 0, -11032.47265625, -3474.798583984375, 66.64788818359375, 3.071766138076782226, 0, 0, 0.999390602111816406, 0.034906134009361267, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+37, 180415, 0, 4, 1438, '0', 0, 0, -11108.7470703125, -3438.609375, 79.2433624267578125, 0.942476630210876464, 0, 0, 0.453989982604980468, 0.891006767749786376, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+38, 180415, 0, 4, 1438, '0', 0, 0, -11076.154296875, -3462.036376953125, 66.615234375, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+39, 180415, 0, 4, 1438, '0', 0, 0, -11115.7783203125, -3432.84033203125, 78.82354736328125, 4.852017402648925781, 0, 0, -0.65605831146240234, 0.754710197448730468, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+40, 180415, 0, 4, 1438, '0', 0, 0, -11108.001953125, -3434.05908203125, 79.25872802734375, 5.70722818374633789, 0, 0, -0.28401470184326171, 0.958819925785064697, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+41, 180415, 0, 4, 1438, '0', 0, 0, -11034.64453125, -3478.34033203125, 66.59519195556640625, 2.792518377304077148, 0, 0, 0.984807014465332031, 0.173652306199073791, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+42, 180415, 0, 4, 1438, '0', 0, 0, -11063.046875, -3476.25, 66.63637542724609375, 4.415683269500732421, 0, 0, -0.80385684967041015, 0.594822824001312255, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+43, 180415, 0, 4, 1438, '0', 0, 0, -11066.9619140625, -3477.62841796875, 66.58322906494140625, 5.323255538940429687, 0, 0, -0.46174812316894531, 0.887011110782623291, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+44, 180415, 0, 4, 1438, '0', 0, 0, -11073.138671875, -3478.28125, 66.56403350830078125, 5.602506637573242187, 0, 0, -0.33380699157714843, 0.942641437053680419, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+45, 180415, 0, 4, 1438, '0', 0, 0, -11036.8662109375, -3481.890625, 66.60845947265625, 2.478367090225219726, 0, 0, 0.94551849365234375, 0.325568377971649169, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+46, 180415, 0, 4, 1438, '0', 0, 0, -11070.3076171875, -3475.1337890625, 66.5517730712890625, 4.345870018005371093, 0, 0, -0.82412624359130859, 0.566406130790710449, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+47, 180415, 0, 4, 1438, '0', 0, 0, -11042.8994140625, -3487.342041015625, 66.60446929931640625, 1.867502212524414062, 0, 0, 0.803856849670410156, 0.594822824001312255, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+48, 180415, 0, 4, 1438, '0', 0, 0, -11045.111328125, -3490.895751953125, 66.661651611328125, 1.675513744354248046, 0, 0, 0.743144035339355468, 0.669131457805633544, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+49, 180415, 0, 4, 1438, '0', 0, 0, -11039.14453125, -3485.421875, 66.65476226806640625, 2.164205789566040039, 0, 0, 0.882946968078613281, 0.469472706317901611, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+50, 180415, 0, 4, 1438, '0', 0, 0, -11072.904296875, -3489.765625, 66.5834808349609375, 3.508116960525512695, 0, 0, -0.98325443267822265, 0.182238012552261352, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+51, 180415, 0, 4, 1438, '0', 0, 0, -11075.107421875, -3486.161376953125, 66.5663909912109375, 5.480334281921386718, 0, 0, -0.39073085784912109, 0.920504987239837646, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+52, 180415, 0, 4, 1438, '0', 0, 0, -11047.4482421875, -3494.435791015625, 66.66265869140625, 1.553341388702392578, 0, 0, 0.700908660888671875, 0.713251054286956787, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+53, 180415, 0, 4, 1438, '0', 0, 0, -11075.185546875, -3481.942626953125, 66.5948638916015625, 4.049167633056640625, 0, 0, -0.89879322052001953, 0.438372820615768432, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+54, 180415, 0, 4, 1438, '0', 0, 0, -11050.9580078125, -3492.013916015625, 66.65380859375, 1.361356139183044433, 0, 0, 0.629320144653320312, 0.77714616060256958, 120, 255, 1, 51886), -- CandleBlack01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+55, 180425, 0, 4, 1438, '0', 0, 0, -11110.8369140625, -3440.078125, 79.17050933837890625, 1.902408957481384277, 0, 0, 0.814115524291992187, 0.580702960491180419, 120, 255, 1, 51886), -- SkullCandle01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+56, 180425, 0, 4, 1438, '0', 0, 0, -11114.23828125, -3431.279541015625, 79.03771209716796875, 5.113816738128662109, 0, 0, -0.55193614959716796, 0.833886384963989257, 120, 255, 1, 51886), -- SkullCandle01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+57, 180425, 0, 4, 1438, '0', 0, 0, -11107.658203125, -3436.515625, 79.3122406005859375, 2.932138919830322265, 0, 0, 0.994521141052246093, 0.104535527527332305, 120, 255, 1, 51886), -- SkullCandle01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+58, 180425, 0, 4, 1438, '0', 0, 0, -11109.4482421875, -3432.0400390625, 79.20508575439453125, 4.014260292053222656, 0, 0, -0.90630722045898437, 0.422619491815567016, 120, 255, 1, 51886), -- SkullCandle01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+59, 180426, 0, 4, 1438, '0', 0, 0, -10997.2392578125, -3380.545166015625, 89.46469879150390625, 1.204277276992797851, 0, 0, 0.56640625, 0.824126183986663818, 120, 255, 1, 51886), -- Bat01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+60, 180426, 0, 4, 1438, '0', 0, 0, -11000.5732421875, -3382.66845703125, 82.22509002685546875, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+61, 180426, 0, 4, 1438, '0', 0, 0, -10995.95703125, -3386.975830078125, 91.05004119873046875, 4.782202720642089843, 0, 0, -0.68199825286865234, 0.731353819370269775, 120, 255, 1, 51886), -- Bat01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+62, 180426, 0, 4, 1438, '0', 0, 0, -11003.955078125, -3388.57470703125, 85.3719329833984375, 1.692969322204589843, 0, 0, 0.748955726623535156, 0.662620067596435546, 120, 255, 1, 51886), -- Bat01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+63, 180427, 0, 4, 1438, '0', 0, 0, -11000.595703125, -3385.57470703125, 81.42990875244140625, 3.508116960525512695, 0, 0, -0.98325443267822265, 0.182238012552261352, 120, 255, 1, 51886), -- Bat02 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+64, 180427, 0, 4, 1438, '0', 0, 0, -10996.6806640625, -3393.28125, 89.76798248291015625, 0.418878614902496337, 0, 0, 0.207911491394042968, 0.978147625923156738, 120, 255, 1, 51886), -- Bat02 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+65, 180427, 0, 4, 1438, '0', 0, 0, -10999.1884765625, -3386.288330078125, 86.4967193603515625, 1.815141916275024414, 0, 0, 0.788010597229003906, 0.615661680698394775, 120, 255, 1, 51886), -- Bat02 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+66, 180429, 0, 4, 1438, '0', 0, 0, -10933.642578125, -3500.63720703125, 67.3153839111328125, 3.298687219619750976, 0, 0, -0.99691677093505859, 0.078466430306434631, 120, 255, 1, 51886), -- G_WitchHat_01 scale 0.5 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+67, 180429, 0, 4, 1438, '0', 0, 0, -10939.17578125, -3499.270751953125, 67.45981597900390625, 2.042035102844238281, 0, 0, 0.852640151977539062, 0.522498607635498046, 120, 255, 1, 51886), -- G_WitchHat_01 scale 0.5 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+68, 180471, 0, 4, 1438, '0', 0, 0, -11030.7158203125, -3372.70654296875, 68.09624481201171875, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+69, 180471, 0, 4, 1438, '0', 0, 0, -11038.873046875, -3374.57470703125, 68.12918853759765625, 5.829400539398193359, 0, 0, -0.22495079040527343, 0.974370121955871582, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+70, 180471, 0, 4, 1438, '0', 0, 0, -11018.8701171875, -3369.736083984375, 68.20053863525390625, 1.221729278564453125, 0, 0, 0.573575973510742187, 0.819152355194091796, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+71, 180471, 0, 4, 1438, '0', 0, 0, -11026.794921875, -3372.272705078125, 68.19976806640625, 6.056293010711669921, 0, 0, -0.11320304870605468, 0.993571877479553222, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+72, 180471, 0, 4, 1438, '0', 0, 0, -11023.876953125, -3405.61279296875, 68.5333709716796875, 3.176533222198486328, 0, 0, -0.999847412109375, 0.017469281330704689, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+73, 180471, 0, 4, 1438, '0', 0, 0, -11019.4267578125, -3412.505126953125, 68.40533447265625, 1.500982880592346191, 0, 0, 0.681998252868652343, 0.731353819370269775, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+74, 180471, 0, 4, 1438, '0', 0, 0, -10960.185546875, -3450.748291015625, 69.7870330810546875, 4.241150379180908203, 0, 0, -0.85264015197753906, 0.522498607635498046, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+75, 180471, 0, 4, 1438, '0', 0, 0, -10961.013671875, -3452.0087890625, 69.78281402587890625, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+76, 180471, 0, 4, 1438, '0', 0, 0, -10960.5986328125, -3451.397705078125, 69.5558013916015625, 4.642575740814208984, 0, 0, -0.731353759765625, 0.681998312473297119, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+77, 180471, 0, 4, 1438, '0', 0, 0, -10959.4443359375, -3449.51904296875, 69.74945831298828125, 4.014260292053222656, 0, 0, -0.90630722045898437, 0.422619491815567016, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+78, 180471, 0, 4, 1438, '0', 0, 0, -11089.498046875, -3447.0556640625, 68.2094268798828125, 0.104719325900077819, 0, 0, 0.052335739135742187, 0.998629570007324218, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+79, 180471, 0, 4, 1438, '0', 0, 0, -11094.4345703125, -3440.463623046875, 68.1926727294921875, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+80, 180471, 0, 4, 1438, '0', 0, 0, -11053.6611328125, -3481.265625, 68.609283447265625, 2.844882726669311523, 0, 0, 0.989015579223632812, 0.147811368107795715, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+81, 180471, 0, 4, 1438, '0', 0, 0, -11053.013671875, -3481.751708984375, 68.48416900634765625, 2.286378860473632812, 0, 0, 0.909960746765136718, 0.414694398641586303, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+82, 180471, 0, 4, 1438, '0', 0, 0, -11052.419921875, -3482.138916015625, 68.35546112060546875, 2.600535154342651367, 0, 0, 0.963629722595214843, 0.26724100112915039, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+83, 180523, 0, 4, 1438, '0', 0, 0, -10916.763671875, -3421.395751953125, 66.54460906982421875, 3.194002151489257812, 0, 0, -0.99965667724609375, 0.026201646775007247, 120, 255, 1, 51886), -- Apple Bob (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+84, 185436, 0, 4, 1438, '0', 0, 0, -11051.0849609375, -3372.609375, 65.60971832275390625, 5.986480236053466796, 0, 0, -0.14780902862548828, 0.989015936851501464, 120, 255, 1, 51886), -- Sitting Skeleton 03 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+85, 185438, 0, 4, 1438, '0', 0, 0, -11044.9931640625, -3386.515625, 65.9428863525390625, 0.27925160527229309, 0, 0, 0.139172554016113281, 0.990268170833587646, 120, 255, 1, 51886), -- Sitting Skeleton 04 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+86, 207941, 0, 4, 1438, '0', 0, 0, -10989.783203125, -3471.6337890625, 80.555450439453125, 3.298687219619750976, 0, 0, -0.99691677093505859, 0.078466430306434631, 120, 255, 1, 51886), -- G_WitchHat_01 scale 2.0 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+87, 208058, 0, 4, 1438, '0', 0, 0, -10989.6162109375, -3471.885498046875, 75.31905364990234375, 3.717553615570068359, 0, 0, -0.95881938934326171, 0.284016460180282592, 120, 255, 1, 51886), -- G_Pumpkin_01 Scale 3.0 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+88, 208064, 0, 4, 1438, '0', 0, 0, -11058.4482421875, -3478.882080078125, 66.61786651611328125, 0.942476630210876464, 0, 0, 0.453989982604980468, 0.891006767749786376, 120, 255, 1, 51886), -- Web Corner (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+89, 208069, 0, 4, 1438, '0', 0, 0, -11000.8134765625, -3348.732666015625, 68.52735137939453125, 4.555310726165771484, 0, 0, -0.76040554046630859, 0.649448513984680175, 120, 255, 1, 51886), -- G_Pumpkin_02 Scale 0.5 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+90, 208069, 0, 4, 1438, '0', 0, 0, -11008.216796875, -3456.578125, 68.56320953369140625, 3.612837791442871093, 0, 0, -0.97236919403076171, 0.233448356389999389, 120, 255, 1, 51886), -- G_Pumpkin_02 Scale 0.5 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+91, 208069, 0, 4, 1438, '0', 0, 0, -11121.576171875, -3491.147705078125, 68.88101959228515625, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 51886), -- G_Pumpkin_02 Scale 0.5 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+92, 208071, 0, 4, 1438, '0', 0, 0, -10943.5361328125, -3392.60595703125, 66.8695220947265625, 6.056293010711669921, 0, 0, -0.11320304870605468, 0.993571877479553222, 120, 255, 1, 51886), -- Web Hanging Scale 3.0 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+93, 208071, 0, 4, 1438, '0', 0, 0, -11051.798828125, -3409.385498046875, 67.65984344482421875, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 51886), -- Web Hanging Scale 3.0 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+94, 208072, 0, 4, 1438, '0', 0, 0, -11004.484375, -3387.739501953125, 66.05234527587890625, 2.146752834320068359, 0, 0, 0.878816604614257812, 0.477159708738327026, 120, 255, 1, 51886), -- G_Pumpkin_03 Scale 0.5 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+95, 208072, 0, 4, 1438, '0', 0, 0, -10965.5849609375, -3452.92529296875, 68.64261627197265625, 3.543023586273193359, 0, 0, -0.97992420196533203, 0.199370384216308593, 120, 255, 1, 51886), -- G_Pumpkin_03 Scale 0.5 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+96, 208072, 0, 4, 1438, '0', 0, 0, -11042.3408203125, -3461.288330078125, 68.84896087646484375, 1.274088263511657714, 0, 0, 0.594821929931640625, 0.80385744571685791, 120, 255, 1, 51886), -- G_Pumpkin_03 Scale 0.5 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+97, 208078, 0, 4, 1438, '0', 0, 0, -11013.6962890625, -3351.61279296875, 68.85970306396484375, 2.775068521499633789, 0, 0, 0.983254432678222656, 0.182238012552261352, 120, 255, 1, 51886), -- G_Pumpkin_01 scale 0.5 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+98, 208078, 0, 4, 1438, '0', 0, 0, -10992.0361328125, -3434.739501953125, 65.70574951171875, 4.084071159362792968, 0, 0, -0.8910064697265625, 0.453990638256072998, 120, 255, 1, 51886), -- G_Pumpkin_01 scale 0.5 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+99, 208078, 0, 4, 1438, '0', 0, 0, -11075.2119140625, -3465.170166015625, 68.61144256591796875, 0.418878614902496337, 0, 0, 0.207911491394042968, 0.978147625923156738, 120, 255, 1, 51886), -- G_Pumpkin_01 scale 0.5 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+100, 208078, 0, 4, 1438, '0', 0, 0, -11132.201171875, -3480.095458984375, 68.84516143798828125, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 51886), -- G_Pumpkin_01 scale 0.5 (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+(@OGUID+101, 208122, 0, 4, 1438, '0', 0, 0, -10926.87890625, -3416.520751953125, 66.49752044677734375, 5.131268978118896484, 0, 0, -0.54463863372802734, 0.838670849800109863, 120, 255, 1, 51886); -- Candy Bucket (Area: Nethergarde Keep - Difficulty: 0) CreateObject1
+
+-- Event spawns
+DELETE FROM `game_event_creature` WHERE `eventEntry`=12 AND `guid` BETWEEN @CGUID+0 AND @CGUID+1;
+INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES
+(12, @CGUID+0),
+(12, @CGUID+1);
+
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+101;
+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);
diff --git a/sql/updates/world/master/2023_11_22_06_world_blasted_lands_surwich.sql b/sql/updates/world/master/2023_11_22_06_world_blasted_lands_surwich.sql
new file mode 100644
index 00000000000..45b80389d12
--- /dev/null
+++ b/sql/updates/world/master/2023_11_22_06_world_blasted_lands_surwich.sql
@@ -0,0 +1,265 @@
+SET @CGUID := 3000350;
+SET @OGUID := 3005885;
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=51886 WHERE `entry`=208123; -- Candy Bucket
+
+UPDATE `gameobject_template_addon` SET `faction`=1732 WHERE `entry`=208123; -- Candy Bucket
+
+-- Quests
+UPDATE `quest_template` SET `Expansion`=9, `VerifiedBuild`=51886 WHERE `ID`=28961; -- Candy Bucket
+
+DELETE FROM `quest_offer_reward` WHERE `ID`=28961;
+INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES
+(28961, 0, 0, 0, 0, 0, 0, 0, 0, 'Candy buckets like this are located in inns throughout the realms. Go ahead... take some!', 51886); -- Candy Bucket
+
+DELETE FROM `gameobject_queststarter` WHERE `id`=208123;
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(208123, 28961, 51886);
+
+UPDATE `gameobject_questender` SET `VerifiedBuild`=51886 WHERE (`id`=208123 AND `quest`=28961);
+
+DELETE FROM `game_event_gameobject_quest` WHERE `id`=208123;
+
+-- 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`, `unit_flags2`, `unit_flags3`, `VerifiedBuild`) VALUES
+(@CGUID+0, 22816, 0, 4, 5084, '0', 0, 0, 0, 0, -12741.9541875, -2933.1281921875, 7.111256122589111328, 3.494016647338867187, 120, 10, 0, 1129, 0, 1, NULL, NULL, NULL, NULL, 51886); -- Black Cat (Area: Surwich - Difficulty: 0) CreateObject1 (possible waypoints or random movement)
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+112;
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
+(@OGUID+0, 180405, 0, 4, 5044, '0', 0, 0, -12685.798828125, -2862.810791015625, 3.037108659744262695, 5.567600727081298828, 0, 0, -0.35020732879638671, 0.936672210693359375, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+1, 180405, 0, 4, 5044, '0', 0, 0, -12716.896484375, -2910.138916015625, 1.61208510398864746, 2.949595451354980468, 0, 0, 0.995395660400390625, 0.095851235091686248, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+2, 180405, 0, 4, 5084, '0', 0, 0, -12759.5517578125, -2905.5244140625, 8.800129890441894531, 0.488691210746765136, 0, 0, 0.241921424865722656, 0.970295846462249755, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+3, 180405, 0, 4, 5084, '0', 0, 0, -12745.5244140625, -2921.546875, 8.818005561828613281, 2.844882726669311523, 0, 0, 0.989015579223632812, 0.147811368107795715, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+4, 180406, 0, 4, 5044, '0', 0, 0, -12721.1181640625, -2957.1181640625, 8.849879264831542968, 3.106652259826660156, 0, 0, 0.999847412109375, 0.017469281330704689, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+5, 180406, 0, 4, 5044, '0', 0, 0, -12730.048828125, -2933.076416015625, 8.765553474426269531, 3.159062385559082031, 0, 0, -0.99996185302734375, 0.008734640665352344, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+6, 180406, 0, 4, 5084, '0', 0, 0, -12769.955078125, -2918.873291015625, 8.788874626159667968, 2.199114561080932617, 0, 0, 0.8910064697265625, 0.453990638256072998, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+7, 180406, 0, 4, 5084, '0', 0, 0, -12751.7255859375, -2878.73779296875, 1.754202008247375488, 2.513273954391479492, 0, 0, 0.951056480407714843, 0.309017121791839599, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+8, 180407, 0, 4, 5044, '0', 0, 0, -12710.6181640625, -2942.89404296875, 8.910387992858886718, 5.044002056121826171, 0, 0, -0.58070278167724609, 0.814115643501281738, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+9, 180407, 0, 4, 5084, '0', 0, 0, -12714.794921875, -2846.380126953125, 1.40623021125793457, 0.226892471313476562, 0, 0, 0.113203048706054687, 0.993571877479553222, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+10, 180408, 0, 4, 5044, '0', 0, 0, -12685.8017578125, -2862.826416015625, 4.647865772247314453, 5.288348197937011718, 0, 0, -0.4771585464477539, 0.878817260265350341, 120, 255, 1, 51886), -- G_WitchHat_01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+11, 180411, 0, 4, 5044, '0', 0, 0, -12693.455078125, -2863.788330078125, 19.14152717590332031, 0.541050612926483154, 0, 0, 0.267237663269042968, 0.96363067626953125, 120, 255, 1, 51886), -- G_Ghost_01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+12, 180411, 0, 4, 5084, '0', 0, 0, -12759.9892578125, -2856.083251953125, 15.28971195220947265, 2.111847877502441406, 0, 0, 0.870355606079101562, 0.492423713207244873, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+13, 180415, 0, 4, 5044, '0', 0, 0, -12667.955078125, -2908.920166015625, 3.875008106231689453, 1.623155713081359863, 0, 0, 0.725374221801757812, 0.688354730606079101, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+14, 180415, 0, 4, 5044, '0', 0, 0, -12687.06640625, -2908.100830078125, 4.126121997833251953, 3.24634718894958496, 0, 0, -0.99862861633300781, 0.052353221923112869, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+15, 180415, 0, 4, 5044, '0', 0, 0, -12648.625, -2906.263916015625, 3.721983671188354492, 1.867502212524414062, 0, 0, 0.803856849670410156, 0.594822824001312255, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+16, 180415, 0, 4, 5044, '0', 0, 0, -12665.40625, -2908.751708984375, 4.07225799560546875, 3.194002151489257812, 0, 0, -0.99965667724609375, 0.026201646775007247, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+17, 180415, 0, 4, 5044, '0', 0, 0, -12659.4130859375, -2908.671875, 3.901810646057128906, 4.049167633056640625, 0, 0, -0.89879322052001953, 0.438372820615768432, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+18, 180415, 0, 4, 5044, '0', 0, 0, -12671.03125, -2908.654541015625, 3.99348759651184082, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+19, 180415, 0, 4, 5044, '0', 0, 0, -12676.6142578125, -2908.326416015625, 4.286301136016845703, 4.014260292053222656, 0, 0, -0.90630722045898437, 0.422619491815567016, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+20, 180415, 0, 4, 5044, '0', 0, 0, -12684.09765625, -2908.095458984375, 4.182917594909667968, 0.715584874153137207, 0, 0, 0.350207328796386718, 0.936672210693359375, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+21, 180415, 0, 4, 5044, '0', 0, 0, -12662.3818359375, -2908.845458984375, 3.846030473709106445, 0.750490784645080566, 0, 0, 0.3665008544921875, 0.93041771650314331, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+22, 180415, 0, 4, 5044, '0', 0, 0, -12654.31640625, -2908.96875, 3.841618061065673828, 4.939284324645996093, 0, 0, -0.6225137710571289, 0.78260880708694458, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+23, 180415, 0, 4, 5044, '0', 0, 0, -12679.107421875, -2908.28466796875, 3.994385719299316406, 1.518436193466186523, 0, 0, 0.6883544921875, 0.725374460220336914, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+24, 180415, 0, 4, 5044, '0', 0, 0, -12656.794921875, -2908.935791015625, 4.144119739532470703, 1.553341388702392578, 0, 0, 0.700908660888671875, 0.713251054286956787, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+25, 180415, 0, 4, 5044, '0', 0, 0, -12681.6142578125, -2908.303955078125, 4.220055103302001953, 2.024578809738159179, 0, 0, 0.848047256469726562, 0.529920578002929687, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+26, 180415, 0, 4, 5044, '0', 0, 0, -12649.267578125, -2908.963623046875, 4.03537750244140625, 0.488691210746765136, 0, 0, 0.241921424865722656, 0.970295846462249755, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+27, 180415, 0, 4, 5044, '0', 0, 0, -12651.7744140625, -2908.8212890625, 4.07260751724243164, 3.281238555908203125, 0, 0, -0.99756336212158203, 0.069766148924827575, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+28, 180415, 0, 4, 5044, '0', 0, 0, -12673.576171875, -2908.57470703125, 4.17918252944946289, 1.047197580337524414, 0, 0, 0.5, 0.866025388240814208, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+29, 180415, 0, 4, 5044, '0', 0, 0, -12687.3232421875, -2894.210205078125, 3.616232156753540039, 5.393068790435791015, 0, 0, -0.43051052093505859, 0.902585566043853759, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+30, 180415, 0, 4, 5044, '0', 0, 0, -12687.423828125, -2876.491455078125, 4.013937950134277343, 3.996806621551513671, 0, 0, -0.90996074676513671, 0.414694398641586303, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+31, 180415, 0, 4, 5044, '0', 0, 0, -12681.7119140625, -2874.029541015625, 3.913488149642944335, 1.466075778007507324, 0, 0, 0.669130325317382812, 0.74314504861831665, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+32, 180415, 0, 4, 5044, '0', 0, 0, -12687.1767578125, -2904.4306640625, 4.012222766876220703, 5.393068790435791015, 0, 0, -0.43051052093505859, 0.902585566043853759, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+33, 180415, 0, 4, 5044, '0', 0, 0, -12684.21875, -2874.145751953125, 4.145032405853271484, 2.146752834320068359, 0, 0, 0.878816604614257812, 0.477159708738327026, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+34, 180415, 0, 4, 5044, '0', 0, 0, -12687.0693359375, -2901.770751953125, 3.826684236526489257, 5.393068790435791015, 0, 0, -0.43051052093505859, 0.902585566043853759, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+35, 180415, 0, 4, 5044, '0', 0, 0, -12687.173828125, -2899.2275390625, 4.019043445587158203, 5.393068790435791015, 0, 0, -0.43051052093505859, 0.902585566043853759, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+36, 180415, 0, 4, 5044, '0', 0, 0, -12673.1943359375, -2874.4619140625, 4.252676963806152343, 5.305802345275878906, 0, 0, -0.46947097778320312, 0.882947921752929687, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+37, 180415, 0, 4, 5044, '0', 0, 0, -12687.294921875, -2881.51904296875, 4.082584381103515625, 5.427974700927734375, 0, 0, -0.41469287872314453, 0.909961462020874023, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+38, 180415, 0, 4, 5044, '0', 0, 0, -12676.19140625, -2874.2431640625, 4.106088161468505859, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+39, 180415, 0, 4, 5044, '0', 0, 0, -12687.451171875, -2884.538330078125, 3.975873231887817382, 0.191985160112380981, 0, 0, 0.095845222473144531, 0.995396256446838378, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+40, 180415, 0, 4, 5044, '0', 0, 0, -12665.41015625, -2874.4462890625, 4.035517215728759765, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+41, 180415, 0, 4, 5044, '0', 0, 0, -12713.013671875, -2940.833251953125, 9.393002510070800781, 4.537858963012695312, 0, 0, -0.76604366302490234, 0.642788589000701904, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+42, 180415, 0, 4, 5044, '0', 0, 0, -12687.3994140625, -2887.09375, 3.787144660949707031, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+43, 180415, 0, 4, 5044, '0', 0, 0, -12687.2783203125, -2896.1337890625, 3.652406930923461914, 5.393068790435791015, 0, 0, -0.43051052093505859, 0.902585566043853759, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+44, 180415, 0, 4, 5044, '0', 0, 0, -12687.2783203125, -2879.015625, 3.783233165740966796, 4.625123500823974609, 0, 0, -0.73727703094482421, 0.67559051513671875, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+45, 180415, 0, 4, 5044, '0', 0, 0, -12670.56640625, -2874.55029296875, 4.069497585296630859, 4.817109584808349609, 0, 0, -0.66913032531738281, 0.74314504861831665, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+46, 180415, 0, 4, 5044, '0', 0, 0, -12679.142578125, -2874.04345703125, 4.208169460296630859, 0.715584874153137207, 0, 0, 0.350207328796386718, 0.936672210693359375, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+47, 180415, 0, 4, 5044, '0', 0, 0, -12667.9931640625, -2874.428955078125, 4.261453151702880859, 3.752462387084960937, 0, 0, -0.95371627807617187, 0.300707906484603881, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+48, 180415, 0, 4, 5044, '0', 0, 0, -12657.8681640625, -2849.579833984375, 5.128314971923828125, 2.530723094940185546, 0, 0, 0.953716278076171875, 0.300707906484603881, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+49, 180415, 0, 4, 5044, '0', 0, 0, -12658.0634765625, -2849.763916015625, 4.958123207092285156, 2.530723094940185546, 0, 0, 0.953716278076171875, 0.300707906484603881, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+50, 180415, 0, 4, 5044, '0', 0, 0, -12715.5693359375, -2939.142333984375, 9.447949409484863281, 4.049167633056640625, 0, 0, -0.89879322052001953, 0.438372820615768432, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+51, 180415, 0, 4, 5044, '0', 0, 0, -12723.767578125, -2932.552001953125, 9.554886817932128906, 4.398232460021972656, 0, 0, -0.80901622772216796, 0.587786316871643066, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+52, 180415, 0, 4, 5044, '0', 0, 0, -12658.013671875, -2850.007080078125, 5.12425851821899414, 4.206246376037597656, 0, 0, -0.86162853240966796, 0.50753939151763916, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+53, 180415, 0, 4, 5044, '0', 0, 0, -12687.271484375, -2874.017333984375, 3.974351167678833007, 3.298687219619750976, 0, 0, -0.99691677093505859, 0.078466430306434631, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+54, 180415, 0, 4, 5044, '0', 0, 0, -12717.517578125, -2937.298583984375, 9.684453010559082031, 3.682650327682495117, 0, 0, -0.96362972259521484, 0.26724100112915039, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+55, 180415, 0, 4, 5044, '0', 0, 0, -12721.78515625, -2934.239501953125, 9.566246986389160156, 4.293513298034667968, 0, 0, -0.8386697769165039, 0.544640243053436279, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+56, 180415, 0, 4, 5044, '0', 0, 0, -12719.62890625, -2935.71533203125, 9.375110626220703125, 5.427974700927734375, 0, 0, -0.41469287872314453, 0.909961462020874023, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+57, 180415, 0, 4, 5084, '0', 0, 0, -12748.7392578125, -2913.663330078125, 9.516018867492675781, 5.218535900115966796, 0, 0, -0.507537841796875, 0.861629426479339599, 120, 255, 1, 51886), -- CandleBlack01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+58, 180415, 0, 4, 5084, '0', 0, 0, -12750.896484375, -2912.157958984375, 9.345971107482910156, 4.223697185516357421, 0, 0, -0.85716724395751953, 0.515038192272186279, 120, 255, 1, 51886), -- CandleBlack01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+59, 180415, 0, 4, 5084, '0', 0, 0, -12752.9892578125, -2910.59716796875, 9.568341255187988281, 4.223697185516357421, 0, 0, -0.85716724395751953, 0.515038192272186279, 120, 255, 1, 51886), -- CandleBlack01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+60, 180415, 0, 4, 5084, '0', 0, 0, -12739.59765625, -2893.65966796875, 2.907981634140014648, 3.857182979583740234, 0, 0, -0.93667125701904296, 0.350209832191467285, 120, 255, 1, 51886), -- CandleBlack01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+61, 180415, 0, 4, 5084, '0', 0, 0, -12753.6181640625, -2877.29345703125, 3.465916395187377929, 6.108653545379638671, 0, 0, -0.08715534210205078, 0.996194720268249511, 120, 255, 1, 51886), -- CandleBlack01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+62, 180415, 0, 4, 5084, '0', 0, 0, -12744.228515625, -2916.854248046875, 8.778136253356933593, 4.869470596313476562, 0, 0, -0.64944744110107421, 0.760406434535980224, 120, 255, 1, 51886), -- CandleBlack01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+63, 180415, 0, 4, 5084, '0', 0, 0, -12766.767578125, -2921.958251953125, 7.877005577087402343, 5.393068790435791015, 0, 0, -0.43051052093505859, 0.902585566043853759, 120, 255, 1, 51886), -- CandleBlack01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+64, 180415, 0, 4, 5084, '0', 0, 0, -12746.75390625, -2915.307373046875, 9.533960342407226562, 5.427974700927734375, 0, 0, -0.41469287872314453, 0.909961462020874023, 120, 255, 1, 51886), -- CandleBlack01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+65, 180415, 0, 4, 5084, '0', 0, 0, -12754.9482421875, -2908.7275390625, 9.406966209411621093, 3.577930212020874023, 0, 0, -0.97629547119140625, 0.216442063450813293, 120, 255, 1, 51886), -- CandleBlack01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+66, 180415, 0, 4, 5084, '0', 0, 0, -12740.0419921875, -2893.4306640625, 3.06853795051574707, 5.061456203460693359, 0, 0, -0.57357597351074218, 0.819152355194091796, 120, 255, 1, 51886), -- CandleBlack01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+67, 180415, 0, 4, 5084, '0', 0, 0, -12744.0068359375, -2917.392333984375, 8.724954605102539062, 4.660029888153076171, 0, 0, -0.72537422180175781, 0.688354730606079101, 120, 255, 1, 51886), -- CandleBlack01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+68, 180415, 0, 4, 5084, '0', 0, 0, -12766.9658203125, -2920.255126953125, 8.043856620788574218, 6.003933906555175781, 0, 0, -0.13917255401611328, 0.990268170833587646, 120, 255, 1, 51886), -- CandleBlack01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+69, 180415, 0, 4, 5084, '0', 0, 0, -12754.3857421875, -2873.079833984375, 3.34106755256652832, 5.096362113952636718, 0, 0, -0.55919265747070312, 0.829037725925445556, 120, 255, 1, 51886), -- CandleBlack01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+70, 180415, 0, 4, 5084, '0', 0, 0, -12746.84765625, -2856.32470703125, 3.148106813430786132, 0.645771682262420654, 0, 0, 0.317304611206054687, 0.948323667049407958, 120, 255, 1, 51886), -- CandleBlack01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+71, 180415, 0, 4, 5084, '0', 0, 0, -12750.0595703125, -2862.1875, 9.03588104248046875, 5.201082706451416015, 0, 0, -0.51503753662109375, 0.857167601585388183, 120, 255, 1, 51886), -- CandleBlack01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+72, 180415, 0, 4, 5084, '0', 0, 0, -12744.5595703125, -2856.111083984375, 8.978785514831542968, 4.276057243347167968, 0, 0, -0.84339141845703125, 0.537299633026123046, 120, 255, 1, 51886), -- CandleBlack01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+73, 180415, 0, 4, 5084, '0', 0, 0, -12749.22265625, -2859.34375, 3.330092191696166992, 4.293513298034667968, 0, 0, -0.8386697769165039, 0.544640243053436279, 120, 255, 1, 51886), -- CandleBlack01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+74, 180415, 0, 4, 5084, '0', 0, 0, -12744.6220703125, -2855.748291015625, 9.007655143737792968, 5.585053920745849609, 0, 0, -0.34202003479003906, 0.939692676067352294, 120, 255, 1, 51886), -- CandleBlack01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+75, 180415, 0, 4, 5084, '0', 0, 0, -12749.6494140625, -2862.197998046875, 9.111638069152832031, 5.393068790435791015, 0, 0, -0.43051052093505859, 0.902585566043853759, 120, 255, 1, 51886), -- CandleBlack01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+76, 180415, 0, 4, 5084, '0', 0, 0, -12746.96875, -2856.5869140625, 3.181696176528930664, 4.869470596313476562, 0, 0, -0.64944744110107421, 0.760406434535980224, 120, 255, 1, 51886), -- CandleBlack01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+77, 180415, 0, 4, 5084, '0', 0, 0, -12749.3818359375, -2861.9462890625, 9.015587806701660156, 5.585053920745849609, 0, 0, -0.34202003479003906, 0.939692676067352294, 120, 255, 1, 51886), -- CandleBlack01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+78, 180415, 0, 4, 5084, '0', 0, 0, -12747.1142578125, -2856.453125, 3.355197668075561523, 0.645771682262420654, 0, 0, 0.317304611206054687, 0.948323667049407958, 120, 255, 1, 51886), -- CandleBlack01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+79, 180415, 0, 4, 5084, '0', 0, 0, -12749.4306640625, -2859.678955078125, 3.267570018768310546, 5.585053920745849609, 0, 0, -0.34202003479003906, 0.939692676067352294, 120, 255, 1, 51886), -- CandleBlack01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+80, 180415, 0, 4, 5084, '0', 0, 0, -12740.392578125, -2847.475830078125, 9.434838294982910156, 4.276057243347167968, 0, 0, -0.84339141845703125, 0.537299633026123046, 120, 255, 1, 51886), -- CandleBlack01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+81, 180415, 0, 4, 5084, '0', 0, 0, -12722.41015625, -2828.470458984375, 15.04636478424072265, 3.52557229995727539, 0, 0, -0.98162651062011718, 0.190812408924102783, 120, 255, 1, 51886), -- CandleBlack01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+82, 180415, 0, 4, 5084, '0', 0, 0, -12722.103515625, -2828.545166015625, 14.99956130981445312, 3.333590030670166015, 0, 0, -0.99539566040039062, 0.095851235091686248, 120, 255, 1, 51886), -- CandleBlack01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+83, 180415, 0, 4, 5084, '0', 0, 0, -12727.3232421875, -2828.4931640625, 14.83307933807373046, 3.194002151489257812, 0, 0, -0.99965667724609375, 0.026201646775007247, 120, 255, 1, 51886), -- CandleBlack01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+84, 180415, 0, 4, 5084, '0', 0, 0, -12726.9130859375, -2828.51220703125, 14.9207916259765625, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 120, 255, 1, 51886), -- CandleBlack01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+85, 180415, 0, 4, 5084, '0', 0, 0, -12727.271484375, -2828.107666015625, 15.027984619140625, 2.094393253326416015, 0, 0, 0.866024971008300781, 0.50000077486038208, 120, 255, 1, 51886), -- CandleBlack01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+86, 180425, 0, 4, 5084, '0', 0, 0, -12739.646484375, -2893.38720703125, 3.163272857666015625, 0.942476630210876464, 0, 0, 0.453989982604980468, 0.891006767749786376, 120, 255, 1, 51886), -- SkullCandle01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+87, 180425, 0, 4, 5084, '0', 0, 0, -12766.4130859375, -2921.984375, 8.115584373474121093, 0.628316879272460937, 0, 0, 0.309016227722167968, 0.95105677843093872, 120, 255, 1, 51886), -- SkullCandle01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+88, 180425, 0, 4, 5084, '0', 0, 0, -12744.03125, -2917.032958984375, 8.854428291320800781, 0.593410074710845947, 0, 0, 0.292370796203613281, 0.95630502700805664, 120, 255, 1, 51886), -- SkullCandle01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+89, 180425, 0, 4, 5084, '0', 0, 0, -12753.87890625, -2875.126708984375, 3.349851369857788085, 0.331610709428787231, 0, 0, 0.16504669189453125, 0.986285746097564697, 120, 255, 1, 51886), -- SkullCandle01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+90, 180425, 0, 4, 5084, '0', 0, 0, -12754.6533203125, -2870.579833984375, 3.96897292137145996, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 51886), -- SkullCandle01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+91, 180426, 0, 4, 5044, '0', 0, 0, -12720.4033203125, -2885.65966796875, 8.425326347351074218, 5.288348197937011718, 0, 0, -0.4771585464477539, 0.878817260265350341, 120, 255, 1, 51886), -- Bat01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+92, 180426, 0, 4, 5044, '0', 0, 0, -12719.736328125, -2884.717041015625, 15.24245166778564453, 1.553341388702392578, 0, 0, 0.700908660888671875, 0.713251054286956787, 120, 255, 1, 51886), -- Bat01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+93, 180426, 0, 4, 5084, '0', 0, 0, -12712.9345703125, -2860.6181640625, 21.18886756896972656, 2.44346022605895996, 0, 0, 0.939692497253417968, 0.34202045202255249, 120, 255, 1, 51886), -- Bat01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+94, 180426, 0, 4, 5084, '0', 0, 0, -12717.56640625, -2860.302001953125, 27.85648155212402343, 2.44346022605895996, 0, 0, 0.939692497253417968, 0.34202045202255249, 120, 255, 1, 51886), -- Bat01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+95, 180426, 0, 4, 5084, '0', 0, 0, -12716.7919921875, -2862.73779296875, 23.76578712463378906, 3.752462387084960937, 0, 0, -0.95371627807617187, 0.300707906484603881, 120, 255, 1, 51886), -- Bat01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+96, 180427, 0, 4, 5044, '0', 0, 0, -12715.8505859375, -2886.6962890625, 33.80703353881835937, 1.48352813720703125, 0, 0, 0.675589561462402343, 0.737277925014495849, 120, 255, 1, 51886), -- Bat02 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+97, 180427, 0, 4, 5044, '0', 0, 0, -12719.7392578125, -2884.444580078125, 22.93523216247558593, 2.635444164276123046, 0, 0, 0.96814727783203125, 0.250381410121917724, 120, 255, 1, 51886), -- Bat02 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+98, 180427, 0, 4, 5084, '0', 0, 0, -12717.3369140625, -2856.19091796875, 30.01530265808105468, 1.48352813720703125, 0, 0, 0.675589561462402343, 0.737277925014495849, 120, 255, 1, 51886), -- Bat02 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+99, 180427, 0, 4, 5084, '0', 0, 0, -12723.7255859375, -2856.755126953125, 22.91867828369140625, 5.637413978576660156, 0, 0, -0.31730461120605468, 0.948323667049407958, 120, 255, 1, 51886), -- Bat02 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+100, 180471, 0, 4, 5044, '0', 0, 0, -12685.3056640625, -2858.802001953125, 7.48454141616821289, 5.235987663269042968, 0, 0, -0.5, 0.866025388240814208, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+101, 180471, 0, 4, 5044, '0', 0, 0, -12686.201171875, -2857.491455078125, 7.582268714904785156, 5.393068790435791015, 0, 0, -0.43051052093505859, 0.902585566043853759, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+102, 180471, 0, 4, 5044, '0', 0, 0, -12685.7568359375, -2858.119873046875, 7.911072731018066406, 5.70722818374633789, 0, 0, -0.28401470184326171, 0.958819925785064697, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+103, 180471, 0, 4, 5084, '0', 0, 0, -12728.8505859375, -2829.376708984375, 9.911944389343261718, 5.70722818374633789, 0, 0, -0.28401470184326171, 0.958819925785064697, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+104, 180472, 0, 4, 5084, '0', 0, 0, -12720.6142578125, -2829.255126953125, 11.08089160919189453, 5.253442287445068359, 0, 0, -0.49242305755615234, 0.870355963706970214, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+105, 180523, 0, 4, 5084, '0', 0, 0, -12708.4169921875, -2817.720458984375, 7.539838314056396484, 3.961898565292358398, 0, 0, -0.91705989837646484, 0.398749500513076782, 120, 255, 1, 51886), -- Apple Bob (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+106, 185435, 0, 4, 5084, '0', 0, 0, -12752.16015625, -2868.73779296875, 3.218705415725708007, 6.108653545379638671, 0, 0, -0.08715534210205078, 0.996194720268249511, 120, 255, 1, 51886), -- Sitting Skeleton 02 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+107, 208057, 0, 4, 5084, '0', 0, 0, -12749.3232421875, -2853.173583984375, 18.36668014526367187, 1.308995485305786132, 0, 0, 0.608760833740234375, 0.793353796005249023, 120, 255, 1, 51886), -- G_Pumpkin_01 Scale 2.0 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+108, 208063, 0, 4, 5044, '0', 0, 0, -12685.78515625, -2858.005126953125, 5.998166084289550781, 3.700104713439941406, 0, 0, -0.96126079559326171, 0.275640487670898437, 120, 255, 1, 51886), -- Web Hanging (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+109, 208064, 0, 4, 5044, '0', 0, 0, -12719.7119140625, -2890.45654296875, 4.22096109390258789, 3.822272777557373046, 0, 0, -0.94264125823974609, 0.333807557821273803, 120, 255, 1, 51886), -- Web Corner (Area: The Tainted Forest - Difficulty: 0) CreateObject1
+(@OGUID+110, 208064, 0, 4, 5084, '0', 0, 0, -12719.111328125, -2879.3994140625, 4.232028484344482421, 0.698131442070007324, 0, 0, 0.342020034790039062, 0.939692676067352294, 120, 255, 1, 51886), -- Web Corner (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+111, 208069, 0, 4, 5084, '0', 0, 0, -12739.1142578125, -2895.13720703125, 3.22200322151184082, 3.159062385559082031, 0, 0, -0.99996185302734375, 0.008734640665352344, 120, 255, 1, 51886), -- G_Pumpkin_02 Scale 0.5 (Area: Surwich - Difficulty: 0) CreateObject1
+(@OGUID+112, 208123, 0, 4, 5084, '0', 0, 0, -12722.0380859375, -2817.779541015625, 7.540986061096191406, 6.003933906555175781, 0, 0, -0.13917255401611328, 0.990268170833587646, 120, 255, 1, 51886); -- Candy Bucket (Area: Surwich - Difficulty: 0) CreateObject1
+
+-- 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+112;
+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);
author	Meji <alvaro.megias@outlook.com>	2023-11-22 20:41:57 +0100
committer	Meji <alvaro.megias@outlook.com>	2023-11-22 20:41:57 +0100
commit	be599c48ed891add91488a6bd6c26c2270f602a6 (patch)
tree	cbcba17d645bdadfca0eeb3363dcd7fc8cf3ef51
parent	0d11ccd36be7f742f74551a68f9f5bef1c952e04 (diff)