DB/EasternPlaguelands: Added Hallows End spawns

1 files changed, 353 insertions, 0 deletions

diff --git a/sql/updates/world/master/2023_11_06_06_world_eastern_plaguelands_lights_hope_chapel.sql b/sql/updates/world/master/2023_11_06_06_world_eastern_plaguelands_lights_hope_chapel.sql
new file mode 100644
index 00000000000..3e4d295d636
--- /dev/null
+++ b/sql/updates/world/master/2023_11_06_06_world_eastern_plaguelands_lights_hope_chapel.sql
@@ -0,0 +1,353 @@
+SET @CGUID := 3000136;
+SET @OGUID := 3002590;
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `VerifiedBuild`=51886 WHERE `entry`=190108; -- Candy Bucket
+
+UPDATE `gameobject_template_addon` SET `faction`=35 WHERE `entry`=190108; -- Candy Bucket
+
+-- Quests
+UPDATE `quest_offer_reward` SET `VerifiedBuild`=51886 WHERE `ID`=12402;
+
+DELETE FROM `gameobject_queststarter` WHERE `id`=190108;
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(190108, 12402, 51886);
+
+UPDATE `gameobject_questender` SET `VerifiedBuild`=51886 WHERE (`id`=190108 AND `quest`=12402);
+
+DELETE FROM `game_event_gameobject_quest` WHERE `id`=190108;
+
+-- 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, 139, 2268, '0', 0, 0, 0, 0, 2265.072509765625, -5267.275390625, 80.8935340576171875, 0.760045289993286132, 120, 10, 0, 1129, 0, 1, NULL, NULL, NULL, NULL, 51886); -- Black Cat (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1 (possible waypoints or random movement)
+
+-- Old gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 229087 AND 229372;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 229087 AND 229372;
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+156;
+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, 139, 2268, '0', 0, 0, 2286.26904296875, -5328.7431640625, 91.0661773681640625, 4.363324165344238281, 0, 0, -0.81915187835693359, 0.573576688766479492, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+1, 180405, 0, 139, 2268, '0', 0, 0, 2265.73779296875, -5313.8974609375, 84.3344268798828125, 4.555310726165771484, 0, 0, -0.76040554046630859, 0.649448513984680175, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+2, 180405, 0, 139, 2268, '0', 0, 0, 2304.401123046875, -5352.6337890625, 91.44635009765625, 3.857182979583740234, 0, 0, -0.93667125701904296, 0.350209832191467285, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+3, 180405, 0, 139, 2268, '0', 0, 0, 2278.678955078125, -5383.45849609375, 93.467529296875, 2.164205789566040039, 0, 0, 0.882946968078613281, 0.469472706317901611, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+4, 180405, 0, 139, 2268, '0', 0, 0, 2341.513916015625, -5394.830078125, 95.8531341552734375, 3.857182979583740234, 0, 0, -0.93667125701904296, 0.350209832191467285, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+5, 180405, 0, 139, 2268, '0', 0, 0, 2340.694580078125, -5283.26904296875, 82.12946319580078125, 4.171337604522705078, 0, 0, -0.87035560607910156, 0.492423713207244873, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+6, 180405, 0, 139, 2268, '0', 0, 0, 2279.310791015625, -5282.439453125, 84.92397308349609375, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+7, 180405, 0, 139, 2268, '0', 0, 0, 2371.100830078125, -5262.375, 80.640533447265625, 2.932138919830322265, 0, 0, 0.994521141052246093, 0.104535527527332305, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+8, 180406, 0, 139, 2268, '0', 0, 0, 2254.423583984375, -5346.41650390625, 88.12967681884765625, 4.223697185516357421, 0, 0, -0.85716724395751953, 0.515038192272186279, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+9, 180406, 0, 139, 2268, '0', 0, 0, 2289.923583984375, -5325.02783203125, 91.065460205078125, 4.345870018005371093, 0, 0, -0.82412624359130859, 0.566406130790710449, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+10, 180406, 0, 139, 2268, '0', 0, 0, 2309.157958984375, -5327.35595703125, 90.385894775390625, 4.101525306701660156, 0, 0, -0.88701057434082031, 0.461749136447906494, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+11, 180406, 0, 139, 2268, '0', 0, 0, 2282.7900390625, -5287.5087890625, 84.94217681884765625, 1.692969322204589843, 0, 0, 0.748955726623535156, 0.662620067596435546, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+12, 180406, 0, 139, 2268, '0', 0, 0, 2274.53466796875, -5285.30908203125, 84.89984130859375, 4.555310726165771484, 0, 0, -0.76040554046630859, 0.649448513984680175, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+13, 180406, 0, 139, 2268, '0', 0, 0, 2322.911376953125, -5387.26416015625, 94.21547698974609375, 3.647741317749023437, 0, 0, -0.96814727783203125, 0.250381410121917724, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+14, 180406, 0, 139, 2268, '0', 0, 0, 2345.404541015625, -5257.76904296875, 81.7318267822265625, 0.680676698684692382, 0, 0, 0.333806037902832031, 0.942641794681549072, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+15, 180407, 0, 139, 2268, '0', 0, 0, 2267.24658203125, -5348.798828125, 86.94087982177734375, 3.682650327682495117, 0, 0, -0.96362972259521484, 0.26724100112915039, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+16, 180407, 0, 139, 2268, '0', 0, 0, 2314.25, -5342.53662109375, 91.44635009765625, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+17, 180407, 0, 139, 2268, '0', 0, 0, 2256.244873046875, -5296.30029296875, 82.21856689453125, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+18, 180407, 0, 139, 2268, '0', 0, 0, 2337.1806640625, -5359.93408203125, 95.18897247314453125, 4.014260292053222656, 0, 0, -0.90630722045898437, 0.422619491815567016, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+19, 180407, 0, 139, 2268, '0', 0, 0, 2277.55029296875, -5290.953125, 84.97817230224609375, 0.261798173189163208, 0, 0, 0.130525588989257812, 0.991444945335388183, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+20, 180407, 0, 139, 2268, '0', 0, 0, 2326.24658203125, -5297.69970703125, 84.45952606201171875, 3.577930212020874023, 0, 0, -0.97629547119140625, 0.216442063450813293, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+21, 180407, 0, 139, 2268, '0', 0, 0, 2365.600830078125, -5254.01904296875, 80.69263458251953125, 2.426007747650146484, 0, 0, 0.936672210693359375, 0.350207358598709106, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+22, 180410, 0, 139, 2268, '0', 0, 0, 2331.350830078125, -5266.126953125, 83.80975341796875, 3.001946926116943359, 0, 0, 0.997563362121582031, 0.069766148924827575, 120, 255, 1, 51886), -- G_HangingSkeleton_01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+23, 180410, 0, 139, 2268, '0', 0, 0, 2332.142333984375, -5257.14599609375, 83.30274200439453125, 2.234017848968505859, 0, 0, 0.898793220520019531, 0.438372820615768432, 120, 255, 1, 51886), -- G_HangingSkeleton_01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+24, 180411, 0, 139, 2268, '0', 0, 0, 2292.163330078125, -5324.0087890625, 107.2151031494140625, 5.044002056121826171, 0, 0, -0.58070278167724609, 0.814115643501281738, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+25, 180411, 0, 139, 2268, '0', 0, 0, 2262.83154296875, -5257.76416015625, 86.24571990966796875, 5.70722818374633789, 0, 0, -0.28401470184326171, 0.958819925785064697, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+26, 180411, 0, 139, 2268, '0', 0, 0, 2313, -5350.97900390625, 97.8755035400390625, 2.268925428390502929, 0, 0, 0.906307220458984375, 0.422619491815567016, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+27, 180411, 0, 139, 2268, '0', 0, 0, 2290.3681640625, -5242.1162109375, 86.65909576416015625, 5.044002056121826171, 0, 0, -0.58070278167724609, 0.814115643501281738, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+28, 180415, 0, 139, 2268, '0', 0, 0, 2290.895751953125, -5336.359375, 92.65265655517578125, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+29, 180415, 0, 139, 2268, '0', 0, 0, 2291.125, -5341.7431640625, 92.65290069580078125, 1.972219824790954589, 0, 0, 0.83388519287109375, 0.55193793773651123, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+30, 180415, 0, 139, 2268, '0', 0, 0, 2290.00341796875, -5337.30224609375, 92.60272979736328125, 4.328419685363769531, 0, 0, -0.82903671264648437, 0.559194147586822509, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+31, 180415, 0, 139, 2268, '0', 0, 0, 2291.569580078125, -5342.18212890625, 92.670318603515625, 4.084071159362792968, 0, 0, -0.8910064697265625, 0.453990638256072998, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+32, 180415, 0, 139, 2268, '0', 0, 0, 2290.427001953125, -5336.88037109375, 92.69451141357421875, 4.1538848876953125, 0, 0, -0.8746194839477539, 0.484810054302215576, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+33, 180415, 0, 139, 2268, '0', 0, 0, 2291.99658203125, -5342.58154296875, 92.657501220703125, 5.113816738128662109, 0, 0, -0.55193614959716796, 0.833886384963989257, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+34, 180415, 0, 139, 2268, '0', 0, 0, 2302.861083984375, -5329.35400390625, 92.70284271240234375, 0.767943859100341796, 0, 0, 0.374606132507324218, 0.927184045314788818, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+35, 180415, 0, 139, 2268, '0', 0, 0, 2308.98095703125, -5342.65087890625, 90.67360687255859375, 2.984498262405395507, 0, 0, 0.996916770935058593, 0.078466430306434631, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+36, 180415, 0, 139, 2268, '0', 0, 0, 2310.100830078125, -5341.4599609375, 90.68730926513671875, 4.101525306701660156, 0, 0, -0.88701057434082031, 0.461749136447906494, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+37, 180415, 0, 139, 2268, '0', 0, 0, 2303.359375, -5329.81787109375, 92.73896026611328125, 1.745326757431030273, 0, 0, 0.766043663024902343, 0.642788589000701904, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+38, 180415, 0, 139, 2268, '0', 0, 0, 2310.522705078125, -5350.27783203125, 92.49631500244140625, 4.572763919830322265, 0, 0, -0.75470924377441406, 0.656059443950653076, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+39, 180415, 0, 139, 2268, '0', 0, 0, 2296.7587890625, -5347.140625, 92.624542236328125, 5.253442287445068359, 0, 0, -0.49242305755615234, 0.870355963706970214, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+40, 180415, 0, 139, 2268, '0', 0, 0, 2293.848876953125, -5316.59033203125, 91.98831939697265625, 6.03883981704711914, 0, 0, -0.12186908721923828, 0.9925462007522583, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+41, 180415, 0, 139, 2268, '0', 0, 0, 2309.157958984375, -5335.359375, 92.71067047119140625, 2.111847877502441406, 0, 0, 0.870355606079101562, 0.492423713207244873, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+42, 180415, 0, 139, 2268, '0', 0, 0, 2298.51220703125, -5328.4755859375, 92.686920166015625, 3.90954136848449707, 0, 0, -0.92718315124511718, 0.37460830807685852, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+43, 180415, 0, 139, 2268, '0', 0, 0, 2302.291748046875, -5352.5, 92.66370391845703125, 4.363324165344238281, 0, 0, -0.81915187835693359, 0.573576688766479492, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+44, 180415, 0, 139, 2268, '0', 0, 0, 2297.234375, -5347.580078125, 92.68328857421875, 2.478367090225219726, 0, 0, 0.94551849365234375, 0.325568377971649169, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+45, 180415, 0, 139, 2268, '0', 0, 0, 2308.111083984375, -5334.4150390625, 92.70389556884765625, 5.916667938232421875, 0, 0, -0.18223476409912109, 0.98325502872467041, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+46, 180415, 0, 139, 2268, '0', 0, 0, 2304.58154296875, -5347.171875, 90.68735504150390625, 1.605701684951782226, 0, 0, 0.719339370727539062, 0.694658815860748291, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+47, 180415, 0, 139, 2268, '0', 0, 0, 2307.78466796875, -5343.86279296875, 90.64972686767578125, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+48, 180415, 0, 139, 2268, '0', 0, 0, 2308.55029296875, -5334.8525390625, 92.7119293212890625, 1.815141916275024414, 0, 0, 0.788010597229003906, 0.615661680698394775, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+49, 180415, 0, 139, 2268, '0', 0, 0, 2296.270751953125, -5346.73291015625, 92.65512847900390625, 5.427974700927734375, 0, 0, -0.41469287872314453, 0.909961462020874023, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+50, 180415, 0, 139, 2268, '0', 0, 0, 2302.210205078125, -5349.70849609375, 90.62139129638671875, 2.844882726669311523, 0, 0, 0.989015579223632812, 0.147811368107795715, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+51, 180415, 0, 139, 2268, '0', 0, 0, 2305.767333984375, -5345.93408203125, 90.65911102294921875, 0.890116631984710693, 0, 0, 0.430510520935058593, 0.902585566043853759, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+52, 180415, 0, 139, 2268, '0', 0, 0, 2307.6650390625, -5353.57666015625, 92.6982574462890625, 3.001946926116943359, 0, 0, 0.997563362121582031, 0.069766148924827575, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+53, 180415, 0, 139, 2268, '0', 0, 0, 2308.12841796875, -5353.1025390625, 92.70688629150390625, 4.572763919830322265, 0, 0, -0.75470924377441406, 0.656059443950653076, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+54, 180415, 0, 139, 2268, '0', 0, 0, 2297.666748046875, -5329.37841796875, 92.72130584716796875, 5.026549339294433593, 0, 0, -0.5877847671508789, 0.809017360210418701, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+55, 180415, 0, 139, 2268, '0', 0, 0, 2301.50341796875, -5351.76220703125, 92.68486785888671875, 1.710421562194824218, 0, 0, 0.754709243774414062, 0.656059443950653076, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+56, 180415, 0, 139, 2268, '0', 0, 0, 2294.928955078125, -5316.94775390625, 92.07209014892578125, 5.096362113952636718, 0, 0, -0.55919265747070312, 0.829037725925445556, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+57, 180415, 0, 139, 2268, '0', 0, 0, 2292.986083984375, -5319.09912109375, 92.1828765869140625, 1.989672422409057617, 0, 0, 0.838669776916503906, 0.544640243053436279, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+58, 180415, 0, 139, 2268, '0', 0, 0, 2303.454833984375, -5348.36474609375, 90.65325927734375, 2.146752834320068359, 0, 0, 0.878816604614257812, 0.477159708738327026, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+59, 180415, 0, 139, 2268, '0', 0, 0, 2301.060791015625, -5350.8193359375, 90.70269012451171875, 3.385940074920654296, 0, 0, -0.99254608154296875, 0.121869951486587524, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+60, 180415, 0, 139, 2268, '0', 0, 0, 2292.796875, -5317.09716796875, 92.0177154541015625, 0.453785061836242675, 0, 0, 0.224950790405273437, 0.974370121955871582, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+61, 180415, 0, 139, 2268, '0', 0, 0, 2303.901123046875, -5330.2900390625, 92.71920013427734375, 1.954769015312194824, 0, 0, 0.829037666320800781, 0.559192776679992675, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+62, 180415, 0, 139, 2268, '0', 0, 0, 2308.513916015625, -5352.72216796875, 92.70720672607421875, 0.401424884796142578, 0, 0, 0.199367523193359375, 0.979924798011779785, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+63, 180415, 0, 139, 2268, '0', 0, 0, 2301.920166015625, -5352.1787109375, 92.68753814697265625, 2.652894020080566406, 0, 0, 0.970294952392578125, 0.241925001144409179, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+64, 180415, 0, 139, 2268, '0', 0, 0, 2298.05908203125, -5329, 92.71724700927734375, 3.211419343948364257, 0, 0, -0.9993906021118164, 0.034906134009361267, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+65, 180415, 0, 139, 2268, '0', 0, 0, 2295.06591796875, -5318.9443359375, 92.27352142333984375, 3.595378875732421875, 0, 0, -0.97437000274658203, 0.224951311945915222, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+66, 180415, 0, 139, 2268, '0', 0, 0, 2315.427001953125, -5345.5380859375, 92.65518951416015625, 0.27925160527229309, 0, 0, 0.139172554016113281, 0.990268170833587646, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+67, 180415, 0, 139, 2268, '0', 0, 0, 2331.442626953125, -5290.859375, 83.45114898681640625, 0.872663915157318115, 0, 0, 0.422617912292480468, 0.906307935714721679, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+68, 180415, 0, 139, 2268, '0', 0, 0, 2311.177001953125, -5349.6025390625, 92.4794464111328125, 3.281238555908203125, 0, 0, -0.99756336212158203, 0.069766148924827575, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+69, 180415, 0, 139, 2268, '0', 0, 0, 2311.741455078125, -5348.96533203125, 92.49457550048828125, 1.640606880187988281, 0, 0, 0.731352806091308593, 0.6819993257522583, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+70, 180415, 0, 139, 2268, '0', 0, 0, 2313.25341796875, -5339.390625, 92.71083831787109375, 1.361356139183044433, 0, 0, 0.629320144653320312, 0.77714616060256958, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+71, 180415, 0, 139, 2268, '0', 0, 0, 2313.685791015625, -5339.7744140625, 92.71817779541015625, 6.003933906555175781, 0, 0, -0.13917255401611328, 0.990268170833587646, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+72, 180415, 0, 139, 2268, '0', 0, 0, 2287.501708984375, -5396.48095703125, 91.5151214599609375, 2.129300594329833984, 0, 0, 0.874619483947753906, 0.484810054302215576, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+73, 180415, 0, 139, 2268, '0', 0, 0, 2332.75341796875, -5348.21728515625, 93.28089141845703125, 5.044002056121826171, 0, 0, -0.58070278167724609, 0.814115643501281738, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+74, 180415, 0, 139, 2268, '0', 0, 0, 2311.177001953125, -5340.376953125, 90.67960357666015625, 5.89921426773071289, 0, 0, -0.19080829620361328, 0.981627285480499267, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+75, 180415, 0, 139, 2268, '0', 0, 0, 2314.632080078125, -5346.3818359375, 92.6880035400390625, 3.822272777557373046, 0, 0, -0.94264125823974609, 0.333807557821273803, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+76, 180415, 0, 139, 2268, '0', 0, 0, 2312.4306640625, -5339.00341796875, 90.6640625, 0.017452461645007133, 0, 0, 0.008726119995117187, 0.999961912631988525, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+77, 180415, 0, 139, 2268, '0', 0, 0, 2337.451416015625, -5349.01904296875, 91.65317535400390625, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+78, 180415, 0, 139, 2268, '0', 0, 0, 2300.838623046875, -5391.99658203125, 93.65512847900390625, 5.986480236053466796, 0, 0, -0.14780902862548828, 0.989015936851501464, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+79, 180415, 0, 139, 2268, '0', 0, 0, 2287.507080078125, -5394.6630859375, 91.43029022216796875, 0.331610709428787231, 0, 0, 0.16504669189453125, 0.986285746097564697, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+80, 180415, 0, 139, 2268, '0', 0, 0, 2344.932373046875, -5347.720703125, 92.1095123291015625, 4.328419685363769531, 0, 0, -0.82903671264648437, 0.559194147586822509, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+81, 180415, 0, 139, 2268, '0', 0, 0, 2338.798583984375, -5347.7275390625, 91.65317535400390625, 3.857182979583740234, 0, 0, -0.93667125701904296, 0.350209832191467285, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+82, 180415, 0, 139, 2268, '0', 0, 0, 2315.053955078125, -5345.92529296875, 92.71337890625, 0.698131442070007324, 0, 0, 0.342020034790039062, 0.939692676067352294, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+83, 180415, 0, 139, 2268, '0', 0, 0, 2312.296875, -5348.3994140625, 92.44593048095703125, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+84, 180415, 0, 139, 2268, '0', 0, 0, 2305.5400390625, -5395.6787109375, 91.93224334716796875, 5.986480236053466796, 0, 0, -0.14780902862548828, 0.989015936851501464, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+85, 180415, 0, 139, 2268, '0', 0, 0, 2301.12158203125, -5391.96728515625, 93.746978759765625, 5.026549339294433593, 0, 0, -0.5877847671508789, 0.809017360210418701, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+86, 180415, 0, 139, 2268, '0', 0, 0, 2314.1806640625, -5340.22900390625, 92.68340301513671875, 1.884953022003173828, 0, 0, 0.809016227722167968, 0.587786316871643066, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+87, 180415, 0, 139, 2268, '0', 0, 0, 2335.671875, -5259.8681640625, 83.5624847412109375, 3.822272777557373046, 0, 0, -0.94264125823974609, 0.333807557821273803, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+88, 180415, 0, 139, 2268, '0', 0, 0, 2335.3125, -5268.09228515625, 83.91208648681640625, 4.049167633056640625, 0, 0, -0.89879322052001953, 0.438372820615768432, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+89, 180415, 0, 139, 2268, '0', 0, 0, 2335.541748046875, -5267.84228515625, 83.87387847900390625, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 51886), -- CandleBlack01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+90, 180425, 0, 139, 2268, '0', 0, 0, 2294.5625, -5319.1875, 92.33405303955078125, 2.042035102844238281, 0, 0, 0.852640151977539062, 0.522498607635498046, 120, 255, 1, 51886), -- SkullCandle01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+91, 180425, 0, 139, 2268, '0', 0, 0, 2295.145751953125, -5317.45166015625, 92.19921112060546875, 3.577930212020874023, 0, 0, -0.97629547119140625, 0.216442063450813293, 120, 255, 1, 51886), -- SkullCandle01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+92, 180425, 0, 139, 2268, '0', 0, 0, 2292.802001953125, -5318.68603515625, 92.20313262939453125, 0.471238493919372558, 0, 0, 0.233445167541503906, 0.972369968891143798, 120, 255, 1, 51886), -- SkullCandle01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+93, 180425, 0, 139, 2268, '0', 0, 0, 2293.326416015625, -5316.814453125, 92.0527496337890625, 5.201082706451416015, 0, 0, -0.51503753662109375, 0.857167601585388183, 120, 255, 1, 51886), -- SkullCandle01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+94, 180425, 0, 139, 2268, '0', 0, 0, 2332.432373046875, -5290.9462890625, 84.16156005859375, 1.658061861991882324, 0, 0, 0.737277030944824218, 0.67559051513671875, 120, 255, 1, 51886), -- SkullCandle01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+95, 180425, 0, 139, 2268, '0', 0, 0, 2305.630126953125, -5379.21533203125, 92.53952789306640625, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 120, 255, 1, 51886), -- SkullCandle01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+96, 180425, 0, 139, 2268, '0', 0, 0, 2332.89404296875, -5347.9462890625, 93.54027557373046875, 2.111847877502441406, 0, 0, 0.870355606079101562, 0.492423713207244873, 120, 255, 1, 51886), -- SkullCandle01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+97, 180425, 0, 139, 2268, '0', 0, 0, 2344.111083984375, -5348.29150390625, 92.39048004150390625, 2.111847877502441406, 0, 0, 0.870355606079101562, 0.492423713207244873, 120, 255, 1, 51886), -- SkullCandle01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+98, 180425, 0, 139, 2268, '0', 0, 0, 2300.14404296875, -5391.9150390625, 93.8883209228515625, 1.082102894783020019, 0, 0, 0.51503753662109375, 0.857167601585388183, 120, 255, 1, 51886), -- SkullCandle01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+99, 180426, 0, 139, 2268, '0', 0, 0, 2279.751708984375, -5279.548828125, 97.00121307373046875, 1.500982880592346191, 0, 0, 0.681998252868652343, 0.731353819370269775, 120, 255, 1, 51886), -- Bat01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+100, 180426, 0, 139, 2268, '0', 0, 0, 2271.123291015625, -5284.71337890625, 99.5720672607421875, 2.792518377304077148, 0, 0, 0.984807014465332031, 0.173652306199073791, 120, 255, 1, 51886), -- Bat01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+101, 180426, 0, 139, 2268, '0', 0, 0, 2275.298583984375, -5282.43603515625, 101.5712203979492187, 1.239183306694030761, 0, 0, 0.580702781677246093, 0.814115643501281738, 120, 255, 1, 51886), -- Bat01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+102, 180426, 0, 139, 2268, '0', 0, 0, 2277.020751953125, -5293.48974609375, 83.07950592041015625, 4.398232460021972656, 0, 0, -0.80901622772216796, 0.587786316871643066, 120, 255, 1, 51886), -- Bat01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+103, 180426, 0, 139, 2268, '0', 0, 0, 2278.12158203125, -5285.96533203125, 90.06604766845703125, 5.340708732604980468, 0, 0, -0.45398998260498046, 0.891006767749786376, 120, 255, 1, 51886), -- Bat01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+104, 180426, 0, 139, 2268, '0', 0, 0, 2273.973876953125, -5289.8193359375, 96.71059417724609375, 3.769911527633666992, 0, 0, -0.95105648040771484, 0.309017121791839599, 120, 255, 1, 51886), -- Bat01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+105, 180427, 0, 139, 2268, '0', 0, 0, 2278.741455078125, -5286.65966796875, 94.8214263916015625, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat02 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+106, 180427, 0, 139, 2268, '0', 0, 0, 2285.8369140625, -5289.65478515625, 98.79636383056640625, 5.829400539398193359, 0, 0, -0.22495079040527343, 0.974370121955871582, 120, 255, 1, 51886), -- Bat02 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+107, 180427, 0, 139, 2268, '0', 0, 0, 2283.234375, -5283.5244140625, 94.4915313720703125, 0.558503925800323486, 0, 0, 0.275636672973632812, 0.961261868476867675, 120, 255, 1, 51886), -- Bat02 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+108, 180427, 0, 139, 2268, '0', 0, 0, 2283.017333984375, -5292.736328125, 101.9259185791015625, 5.323255538940429687, 0, 0, -0.46174812316894531, 0.887011110782623291, 120, 255, 1, 51886), -- Bat02 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+109, 180429, 0, 139, 2268, '0', 0, 0, 2293.94091796875, -5376.18603515625, 94.7587127685546875, 2.321286916732788085, 0, 0, 0.917059898376464843, 0.398749500513076782, 120, 255, 1, 51886), -- G_WitchHat_01 scale 0.5 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+110, 180471, 0, 139, 2268, '0', 0, 0, 2291.567626953125, -5342.12841796875, 95.42337799072265625, 2.338739633560180664, 0, 0, 0.920504570007324218, 0.3907318115234375, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+111, 180471, 0, 139, 2268, '0', 0, 0, 2290.97216796875, -5342.77978515625, 95.72019195556640625, 5.567600727081298828, 0, 0, -0.35020732879638671, 0.936672210693359375, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+112, 180471, 0, 139, 2268, '0', 0, 0, 2289.611083984375, -5336.48291015625, 95.75272369384765625, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+113, 180471, 0, 139, 2268, '0', 0, 0, 2290.552001953125, -5336.8837890625, 95.48455810546875, 0.855210542678833007, 0, 0, 0.414692878723144531, 0.909961462020874023, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+114, 180471, 0, 139, 2268, '0', 0, 0, 2296.828125, -5347.02783203125, 95.34485626220703125, 2.268925428390502929, 0, 0, 0.906307220458984375, 0.422619491815567016, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+115, 180471, 0, 139, 2268, '0', 0, 0, 2296.19091796875, -5347.72412109375, 95.5358428955078125, 5.567600727081298828, 0, 0, -0.35020732879638671, 0.936672210693359375, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+116, 180471, 0, 139, 2268, '0', 0, 0, 2308.475830078125, -5334.9775390625, 95.52036285400390625, 5.550147056579589843, 0, 0, -0.358367919921875, 0.933580458164215087, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+117, 180471, 0, 139, 2268, '0', 0, 0, 2307.998291015625, -5353.0693359375, 95.15290069580078125, 3.94444584846496582, 0, 0, -0.92050457000732421, 0.3907318115234375, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+118, 180471, 0, 139, 2268, '0', 0, 0, 2301.342041015625, -5352.69091796875, 95.66717529296875, 5.550147056579589843, 0, 0, -0.358367919921875, 0.933580458164215087, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+119, 180471, 0, 139, 2268, '0', 0, 0, 2298.0244140625, -5328.91162109375, 95.1256866455078125, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+120, 180471, 0, 139, 2268, '0', 0, 0, 2308.73095703125, -5353.8505859375, 95.63327789306640625, 0.680676698684692382, 0, 0, 0.333806037902832031, 0.942641794681549072, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+121, 180471, 0, 139, 2268, '0', 0, 0, 2303.32470703125, -5329.97216796875, 95.40807342529296875, 5.70722818374633789, 0, 0, -0.28401470184326171, 0.958819925785064697, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+122, 180471, 0, 139, 2268, '0', 0, 0, 2297.748291015625, -5328.10400390625, 95.73749542236328125, 3.94444584846496582, 0, 0, -0.92050457000732421, 0.3907318115234375, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+123, 180471, 0, 139, 2268, '0', 0, 0, 2304.00341796875, -5329.29541015625, 95.7574310302734375, 2.268925428390502929, 0, 0, 0.906307220458984375, 0.422619491815567016, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+124, 180471, 0, 139, 2268, '0', 0, 0, 2309.21875, -5334.25537109375, 95.82689666748046875, 2.338739633560180664, 0, 0, 0.920504570007324218, 0.3907318115234375, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+125, 180471, 0, 139, 2268, '0', 0, 0, 2301.9619140625, -5352.0400390625, 95.04496002197265625, 2.321286916732788085, 0, 0, 0.917059898376464843, 0.398749500513076782, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+126, 180471, 0, 139, 2268, '0', 0, 0, 2314.30029296875, -5339.27587890625, 95.919708251953125, 2.426007747650146484, 0, 0, 0.936672210693359375, 0.350207358598709106, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+127, 180471, 0, 139, 2268, '0', 0, 0, 2296.263916015625, -5299.26904296875, 87.9412841796875, 4.223697185516357421, 0, 0, -0.85716724395751953, 0.515038192272186279, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+128, 180471, 0, 139, 2268, '0', 0, 0, 2255.015625, -5260.66845703125, 91.900634765625, 3.612837791442871093, 0, 0, -0.97236919403076171, 0.233448356389999389, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+129, 180471, 0, 139, 2268, '0', 0, 0, 2255.47216796875, -5260.3837890625, 92.3596038818359375, 3.612837791442871093, 0, 0, -0.97236919403076171, 0.233448356389999389, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+130, 180471, 0, 139, 2268, '0', 0, 0, 2313.625, -5339.96728515625, 95.32628631591796875, 5.585053920745849609, 0, 0, -0.34202003479003906, 0.939692676067352294, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+131, 180471, 0, 139, 2268, '0', 0, 0, 2263.757080078125, -5256.875, 91.92984771728515625, 3.612837791442871093, 0, 0, -0.97236919403076171, 0.233448356389999389, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+132, 180471, 0, 139, 2268, '0', 0, 0, 2315.71875, -5346.658203125, 95.72467041015625, 0.820303261280059814, 0, 0, 0.398748397827148437, 0.917060375213623046, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+133, 180471, 0, 139, 2268, '0', 0, 0, 2315.007080078125, -5345.94287109375, 95.09500885009765625, 3.94444584846496582, 0, 0, -0.92050457000732421, 0.3907318115234375, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+134, 180471, 0, 139, 2268, '0', 0, 0, 2297.491455078125, -5298.23974609375, 87.78670501708984375, 3.612837791442871093, 0, 0, -0.97236919403076171, 0.233448356389999389, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+135, 180471, 0, 139, 2268, '0', 0, 0, 2264.248291015625, -5256.546875, 91.53931427001953125, 3.612837791442871093, 0, 0, -0.97236919403076171, 0.233448356389999389, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+136, 180471, 0, 139, 2268, '0', 0, 0, 2263.23095703125, -5257.15478515625, 92.4715576171875, 3.612837791442871093, 0, 0, -0.97236919403076171, 0.233448356389999389, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+137, 180471, 0, 139, 2268, '0', 0, 0, 2254.55029296875, -5260.94775390625, 91.25125885009765625, 3.612837791442871093, 0, 0, -0.97236919403076171, 0.233448356389999389, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+138, 180472, 0, 139, 2268, '0', 0, 0, 2311.1875, -5349.19775390625, 99.7682037353515625, 2.216565132141113281, 0, 0, 0.894933700561523437, 0.44619917869567871, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+139, 180472, 0, 139, 2268, '0', 0, 0, 2280.447998046875, -5283.73291015625, 88.87378692626953125, 1.675513744354248046, 0, 0, 0.743144035339355468, 0.669131457805633544, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+140, 180523, 0, 139, 2268, '0', 0, 0, 2300.298583984375, -5346.4287109375, 91.28202056884765625, 5.6897735595703125, 0, 0, -0.29237174987792968, 0.956304728984832763, 120, 255, 1, 51886), -- Apple Bob (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+141, 190108, 0, 139, 2268, '0', 0, 0, 2298.40625, -5333.79541015625, 90.7519073486328125, 4.537858963012695312, 0, 0, -0.76604366302490234, 0.642788589000701904, 120, 255, 1, 51886), -- Candy Bucket (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+142, 207941, 0, 139, 2268, '0', 0, 0, 2292.27783203125, -5331.17529296875, 129.117401123046875, 4.118979454040527343, 0, 0, -0.88294696807861328, 0.469472706317901611, 120, 255, 1, 51886), -- G_WitchHat_01 scale 2.0 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+143, 208058, 0, 139, 2268, '0', 0, 0, 2292.342041015625, -5331.03466796875, 123.9795608520507812, 4.363324165344238281, 0, 0, -0.81915187835693359, 0.573576688766479492, 120, 255, 1, 51886), -- G_Pumpkin_01 Scale 3.0 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+144, 208063, 0, 139, 2268, '0', 0, 0, 2289.239501953125, -5327.99462890625, 92.55487823486328125, 2.408554315567016601, 0, 0, 0.933580398559570312, 0.358368009328842163, 120, 255, 1, 51886), -- Web Hanging (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+145, 208063, 0, 139, 2268, '0', 0, 0, 2311.032958984375, -5349.111328125, 96.36521148681640625, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 120, 255, 1, 51886), -- Web Hanging (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+146, 208064, 0, 139, 2268, '0', 0, 0, 2299.572998046875, -5349.783203125, 95.4796295166015625, 2.391098499298095703, 0, 0, 0.930417060852050781, 0.366502493619918823, 120, 255, 1, 51886), -- Web Corner (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+147, 208064, 0, 139, 2268, '0', 0, 0, 2305.87841796875, -5332.2724609375, 95.41345977783203125, 5.480334281921386718, 0, 0, -0.39073085784912109, 0.920504987239837646, 120, 255, 1, 51886), -- Web Corner (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+148, 208064, 0, 139, 2268, '0', 0, 0, 2293.90283203125, -5344.22412109375, 95.61484527587890625, 2.391098499298095703, 0, 0, 0.930417060852050781, 0.366502493619918823, 120, 255, 1, 51886), -- Web Corner (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+149, 208064, 0, 139, 2268, '0', 0, 0, 2311.27783203125, -5337.61279296875, 95.4651947021484375, 5.480334281921386718, 0, 0, -0.39073085784912109, 0.920504987239837646, 120, 255, 1, 51886), -- Web Corner (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+150, 208069, 0, 139, 2268, '0', 0, 0, 2275.046875, -5387.44970703125, 91.88714599609375, 1.884953022003173828, 0, 0, 0.809016227722167968, 0.587786316871643066, 120, 255, 1, 51886), -- G_Pumpkin_02 Scale 0.5 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+151, 208069, 0, 139, 2268, '0', 0, 0, 2318.786376953125, -5383.158203125, 92.1848602294921875, 3.595378875732421875, 0, 0, -0.97437000274658203, 0.224951311945915222, 120, 255, 1, 51886), -- G_Pumpkin_02 Scale 0.5 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+152, 208071, 0, 139, 2268, '0', 0, 0, 2288.5869140625, -5327.7724609375, 105.1411514282226562, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 120, 255, 1, 51886), -- Web Hanging Scale 3.0 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+153, 208072, 0, 139, 2268, '0', 0, 0, 2287.489501953125, -5395.6181640625, 91.89174652099609375, 2.059488296508789062, 0, 0, 0.857167243957519531, 0.515038192272186279, 120, 255, 1, 51886), -- G_Pumpkin_03 Scale 0.5 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+154, 208072, 0, 139, 2268, '0', 0, 0, 2331.66845703125, -5360.09228515625, 91.94684600830078125, 4.276057243347167968, 0, 0, -0.84339141845703125, 0.537299633026123046, 120, 255, 1, 51886), -- G_Pumpkin_03 Scale 0.5 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+155, 208078, 0, 139, 2268, '0', 0, 0, 2304.638916015625, -5395.736328125, 92.4785003662109375, 3.52557229995727539, 0, 0, -0.98162651062011718, 0.190812408924102783, 120, 255, 1, 51886), -- G_Pumpkin_01 scale 0.5 (Area: Light's Hope Chapel - Difficulty: 0) CreateObject1
+(@OGUID+156, 208078, 0, 139, 2268, '0', 0, 0, 2338.157958984375, -5348.3994140625, 91.884765625, 4.223697185516357421, 0, 0, -0.85716724395751953, 0.515038192272186279, 120, 255, 1, 51886); -- G_Pumpkin_01 scale 0.5 (Area: Light's Hope Chapel - 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+156;
+INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES
+(12, @OGUID+0),
+(12, @OGUID+1),
+(12, @OGUID+2),
+(12, @OGUID+3),
+(12, @OGUID+4),
+(12, @OGUID+5),
+(12, @OGUID+6),
+(12, @OGUID+7),
+(12, @OGUID+8),
+(12, @OGUID+9),
+(12, @OGUID+10),
+(12, @OGUID+11),
+(12, @OGUID+12),
+(12, @OGUID+13),
+(12, @OGUID+14),
+(12, @OGUID+15),
+(12, @OGUID+16),
+(12, @OGUID+17),
+(12, @OGUID+18),
+(12, @OGUID+19),
+(12, @OGUID+20),
+(12, @OGUID+21),
+(12, @OGUID+22),
+(12, @OGUID+23),
+(12, @OGUID+24),
+(12, @OGUID+25),
+(12, @OGUID+26),
+(12, @OGUID+27),
+(12, @OGUID+28),
+(12, @OGUID+29),
+(12, @OGUID+30),
+(12, @OGUID+31),
+(12, @OGUID+32),
+(12, @OGUID+33),
+(12, @OGUID+34),
+(12, @OGUID+35),
+(12, @OGUID+36),
+(12, @OGUID+37),
+(12, @OGUID+38),
+(12, @OGUID+39),
+(12, @OGUID+40),
+(12, @OGUID+41),
+(12, @OGUID+42),
+(12, @OGUID+43),
+(12, @OGUID+44),
+(12, @OGUID+45),
+(12, @OGUID+46),
+(12, @OGUID+47),
+(12, @OGUID+48),
+(12, @OGUID+49),
+(12, @OGUID+50),
+(12, @OGUID+51),
+(12, @OGUID+52),
+(12, @OGUID+53),
+(12, @OGUID+54),
+(12, @OGUID+55),
+(12, @OGUID+56),
+(12, @OGUID+57),
+(12, @OGUID+58),
+(12, @OGUID+59),
+(12, @OGUID+60),
+(12, @OGUID+61),
+(12, @OGUID+62),
+(12, @OGUID+63),
+(12, @OGUID+64),
+(12, @OGUID+65),
+(12, @OGUID+66),
+(12, @OGUID+67),
+(12, @OGUID+68),
+(12, @OGUID+69),
+(12, @OGUID+70),
+(12, @OGUID+71),
+(12, @OGUID+72),
+(12, @OGUID+73),
+(12, @OGUID+74),
+(12, @OGUID+75),
+(12, @OGUID+76),
+(12, @OGUID+77),
+(12, @OGUID+78),
+(12, @OGUID+79),
+(12, @OGUID+80),
+(12, @OGUID+81),
+(12, @OGUID+82),
+(12, @OGUID+83),
+(12, @OGUID+84),
+(12, @OGUID+85),
+(12, @OGUID+86),
+(12, @OGUID+87),
+(12, @OGUID+88),
+(12, @OGUID+89),
+(12, @OGUID+90),
+(12, @OGUID+91),
+(12, @OGUID+92),
+(12, @OGUID+93),
+(12, @OGUID+94),
+(12, @OGUID+95),
+(12, @OGUID+96),
+(12, @OGUID+97),
+(12, @OGUID+98),
+(12, @OGUID+99),
+(12, @OGUID+100),
+(12, @OGUID+101),
+(12, @OGUID+102),
+(12, @OGUID+103),
+(12, @OGUID+104),
+(12, @OGUID+105),
+(12, @OGUID+106),
+(12, @OGUID+107),
+(12, @OGUID+108),
+(12, @OGUID+109),
+(12, @OGUID+110),
+(12, @OGUID+111),
+(12, @OGUID+112),
+(12, @OGUID+113),
+(12, @OGUID+114),
+(12, @OGUID+115),
+(12, @OGUID+116),
+(12, @OGUID+117),
+(12, @OGUID+118),
+(12, @OGUID+119),
+(12, @OGUID+120),
+(12, @OGUID+121),
+(12, @OGUID+122),
+(12, @OGUID+123),
+(12, @OGUID+124),
+(12, @OGUID+125),
+(12, @OGUID+126),
+(12, @OGUID+127),
+(12, @OGUID+128),
+(12, @OGUID+129),
+(12, @OGUID+130),
+(12, @OGUID+131),
+(12, @OGUID+132),
+(12, @OGUID+133),
+(12, @OGUID+134),
+(12, @OGUID+135),
+(12, @OGUID+136),
+(12, @OGUID+137),
+(12, @OGUID+138),
+(12, @OGUID+139),
+(12, @OGUID+140),
+(12, @OGUID+141),
+(12, @OGUID+142),
+(12, @OGUID+143),
+(12, @OGUID+144),
+(12, @OGUID+145),
+(12, @OGUID+146),
+(12, @OGUID+147),
+(12, @OGUID+148),
+(12, @OGUID+149),
+(12, @OGUID+150),
+(12, @OGUID+151),
+(12, @OGUID+152),
+(12, @OGUID+153),
+(12, @OGUID+154),
+(12, @OGUID+155),
+(12, @OGUID+156);