diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2023_11_06_06_world_eastern_plaguelands_lights_hope_chapel.sql | 353 |
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); |