diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2022_11_01_01_world.sql | 412 |
1 files changed, 412 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_11_01_01_world.sql b/sql/updates/world/master/2022_11_01_01_world.sql new file mode 100644 index 00000000000..6390cbc097a --- /dev/null +++ b/sql/updates/world/master/2022_11_01_01_world.sql @@ -0,0 +1,412 @@ +SET @CGUID := 396029; +SET @OGUID := 244141; + +-- Gossips +DELETE FROM `gossip_menu_option` WHERE (`MenuID`=9469 AND `OptionID`=0); +INSERT INTO `gossip_menu_option` (`MenuID`, `OptionID`, `OptionNpc`, `OptionText`, `OptionBroadcastTextId`, `Language`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES +(9469, 0, 0, 'Who is the Headless Horseman?', 22620, 0, 8880, 0, 0, 0, NULL, 0, 46366); + +-- Gameobject templates +UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=46366 WHERE `entry`=190037; -- Candy Bucket + +UPDATE `gameobject_template_addon` SET `faction`=1732 WHERE `entry`=190037; -- Candy Bucket + +-- Quests +UPDATE `quest_offer_reward` SET `VerifiedBuild`=46366 WHERE `ID`=12333; + +DELETE FROM `gameobject_queststarter` WHERE `id`=190037; +INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(190037, 12333, 46366); + +UPDATE `gameobject_questender` SET `VerifiedBuild`=46366 WHERE (`id`=190037 AND `quest`=12333); + +DELETE FROM `game_event_gameobject_quest` WHERE `id`=190037; + +-- Old creature spawns +DELETE FROM `creature` WHERE `guid` IN (11000,11005,11011,20298,85701,85702,86586,86848,86849,86850); +DELETE FROM `game_event_creature` WHERE `guid` IN (11000,11005,11011,20298,85701,85702,86586,86848,86849,86850); + +-- Creature spawns +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+46; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(@CGUID+0, 18038, 530, 3524, 0, '0', 0, 0, 0, 1, -4194.95556640625, -12281.197265625, 0.749703288078308105, 5.689773082733154296, 120, 0, 0, 3412, 0, 0, 0, 0, 0, 46366), -- Azuremyst Peacekeeper (Area: 0 - Difficulty: 0) +(@CGUID+1, 23537, 530, 3524, 3576, '0', 0, 0, 0, 0, -4213.01025390625, -12515.451171875, 52.52944564819335937, 0.252863407135009765, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: Azure Watch - Difficulty: 0) (Auras: 42074 - Headless Horseman - Fire) +(@CGUID+2, 23537, 530, 3524, 3576, '0', 0, 0, 0, 0, -4130.1650390625, -12484.8330078125, 49.45761871337890625, 4.418400287628173828, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: Azure Watch - Difficulty: 0) +(@CGUID+3, 23537, 530, 3524, 3576, '0', 0, 0, 0, 0, -4126.0556640625, -12484.1669921875, 46.7120819091796875, 0.369236618280410766, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: Azure Watch - Difficulty: 0) +(@CGUID+4, 23537, 530, 3524, 3576, '0', 0, 0, 0, 0, -4149.71728515625, -12482.451171875, 53.907501220703125, 4.06933450698852539, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: Azure Watch - Difficulty: 0) +(@CGUID+5, 23537, 530, 3524, 3576, '0', 0, 0, 0, 0, -4139.328125, -12486.9384765625, 54.24388885498046875, 3.074496984481811523, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: Azure Watch - Difficulty: 0) +(@CGUID+6, 23537, 530, 3524, 3576, '0', 0, 0, 0, 0, -4214.171875, -12517.0283203125, 55.0714263916015625, 3.586442232131958007, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: Azure Watch - Difficulty: 0) (Auras: 42112 - Headless Horseman - Update Size) +(@CGUID+7, 23537, 530, 3524, 3576, '0', 0, 0, 0, 0, -4136.97412109375, -12485.521484375, 55.1362457275390625, 0.386689931154251098, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: Azure Watch - Difficulty: 0) +(@CGUID+8, 23537, 530, 3524, 3576, '0', 0, 0, 0, 0, -4134.7412109375, -12487.5693359375, 51.09186553955078125, 3.51082921028137207, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: Azure Watch - Difficulty: 0) +(@CGUID+9, 23537, 530, 3524, 3576, '0', 0, 0, 0, 0, -4214.98291015625, -12513.50390625, 53.46002197265625, 2.41707158088684082, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: Azure Watch - Difficulty: 0) (Auras: 42112 - Headless Horseman - Update Size) +(@CGUID+10, 23537, 530, 3524, 3576, '0', 0, 0, 0, 0, -4151.39599609375, -12476.5107421875, 50.64475250244140625, 1.992392778396606445, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: Azure Watch - Difficulty: 0) +(@CGUID+11, 23537, 530, 3524, 3576, '0', 0, 0, 0, 0, -4146.171875, -12486.375, 54.20624923706054687, 5.413238048553466796, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: Azure Watch - Difficulty: 0) +(@CGUID+12, 23537, 530, 3524, 3576, '0', 0, 0, 0, 0, -4150.59033203125, -12472.732421875, 51.58469390869140625, 4.453307151794433593, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: Azure Watch - Difficulty: 0) +(@CGUID+13, 23537, 530, 3524, 3576, '0', 0, 0, 0, 0, -4123.58349609375, -12481.3056640625, 44.85959625244140625, 1.1197282075881958, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: Azure Watch - Difficulty: 0) +(@CGUID+14, 23537, 530, 3524, 3576, '0', 0, 0, 0, 0, -4213.142578125, -12519.5869140625, 51.0774078369140625, 6.064809799194335937, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: Azure Watch - Difficulty: 0) (Auras: 42074 - Headless Horseman - Fire, 42096 - Headless Horseman - Fire onSpawn, Size) +(@CGUID+15, 23537, 530, 3524, 3576, '0', 0, 0, 0, 0, -4143.65966796875, -12489.267578125, 47.77335357666015625, 3.301389694213867187, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: Azure Watch - Difficulty: 0) +(@CGUID+16, 23537, 530, 3524, 3576, '0', 0, 0, 0, 0, -4138.35400390625, -12489.4931640625, 51.50437545776367187, 2.079659223556518554, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: Azure Watch - Difficulty: 0) +(@CGUID+17, 23537, 530, 3524, 3576, '0', 0, 0, 0, 0, -4214.67529296875, -12512.2392578125, 50.97021102905273437, 6.204436302185058593, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: Azure Watch - Difficulty: 0) (Auras: 42074 - Headless Horseman - Fire) +(@CGUID+18, 23537, 530, 3524, 3576, '0', 0, 0, 0, 0, -4141.45654296875, -12490.4658203125, 49.78397750854492187, 2.463631629943847656, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: Azure Watch - Difficulty: 0) +(@CGUID+19, 23537, 530, 3524, 3576, '0', 0, 0, 0, 0, -4148.73779296875, -12485.294921875, 53.26068878173828125, 1.451340794563293457, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: Azure Watch - Difficulty: 0) +(@CGUID+20, 23537, 530, 3524, 3576, '0', 0, 0, 0, 0, -4150.875, -12481.12890625, 49.62337112426757812, 0.962648570537567138, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: Azure Watch - Difficulty: 0) +(@CGUID+21, 23537, 530, 3524, 3576, '0', 0, 0, 0, 0, -4149.11474609375, -12475.853515625, 53.1472625732421875, 0.316876739263534545, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: Azure Watch - Difficulty: 0) +(@CGUID+22, 23537, 530, 3524, 3576, '0', 0, 0, 0, 0, -4132.37841796875, -12484.7080078125, 54.00955581665039062, 0.543769538402557373, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: Azure Watch - Difficulty: 0) +(@CGUID+23, 23537, 530, 3524, 3576, '0', 0, 0, 0, 0, -4147.29345703125, -12473.1845703125, 53.9451141357421875, 2.690524578094482421, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: Azure Watch - Difficulty: 0) +(@CGUID+24, 23537, 530, 3524, 3576, '0', 0, 0, 0, 0, -4145.27587890625, -12488.0556640625, 51.10165786743164062, 2.777791023254394531, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: Azure Watch - Difficulty: 0) +(@CGUID+25, 23537, 530, 3524, 3576, '0', 0, 0, 0, 0, -4216.84375, -12524.0283203125, 52.26282501220703125, 5.506304264068603515, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: Azure Watch - Difficulty: 0) (Auras: 42091 - Headless Horseman - Fire Size, 42096 - Headless Horseman - Fire onSpawn, Size) +(@CGUID+26, 23537, 530, 3524, 3576, '0', 0, 0, 0, 0, -4221.62841796875, -12507.8017578125, 49.60944366455078125, 4.738359451293945312, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: Azure Watch - Difficulty: 0) (Auras: 42091 - Headless Horseman - Fire Size) +(@CGUID+27, 23537, 530, 3524, 3576, '0', 0, 0, 0, 0, -4225.36279296875, -12508.478515625, 48.54803848266601562, 4.563826560974121093, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: Azure Watch - Difficulty: 0) +(@CGUID+28, 23537, 530, 3524, 3576, '0', 0, 0, 0, 0, -4216.20849609375, -12510.771484375, 47.28512191772460937, 3.900601625442504882, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: Azure Watch - Difficulty: 0) (Auras: 42091 - Headless Horseman - Fire Size) +(@CGUID+29, 23537, 530, 3524, 3576, '0', 0, 0, 0, 0, -4220.51904296875, -12528.8505859375, 49.85346603393554687, 1.561860322952270507, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: Azure Watch - Difficulty: 0) (Auras: 42091 - Headless Horseman - Fire Size, 42096 - Headless Horseman - Fire onSpawn, Size) +(@CGUID+30, 23537, 530, 3524, 3576, '0', 0, 0, 0, 0, -4220.298828125, -12510.9931640625, 52.38683700561523437, 3.132656574249267578, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: Azure Watch - Difficulty: 0) (Auras: 42112 - Headless Horseman - Update Size) +(@CGUID+31, 23537, 530, 3524, 3576, '0', 0, 0, 0, 0, -4223.689453125, -12529.0419921875, 51.87207412719726562, 1.369874119758605957, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: Azure Watch - Difficulty: 0) (Auras: 42091 - Headless Horseman - Fire Size, 42096 - Headless Horseman - Fire onSpawn, Size) +(@CGUID+32, 23537, 530, 3524, 3576, '0', 0, 0, 0, 0, -4216.80029296875, -12527.1181640625, 50.93590545654296875, 2.242538690567016601, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: Azure Watch - Difficulty: 0) (Auras: 42091 - Headless Horseman - Fire Size, 42096 - Headless Horseman - Fire onSpawn, Size) +(@CGUID+33, 23537, 530, 3524, 3576, '0', 0, 0, 0, 0, -4214.29345703125, -12523.53515625, 50.40539169311523437, 5.768103599548339843, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: Azure Watch - Difficulty: 0) (Auras: 42074 - Headless Horseman - Fire) +(@CGUID+34, 23537, 530, 3524, 3576, '0', 0, 0, 0, 0, -4218.69091796875, -12508.41015625, 49.02115249633789062, 0.130690366029739379, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: Azure Watch - Difficulty: 0) (Auras: 42091 - Headless Horseman - Fire Size) +(@CGUID+35, 23537, 530, 3524, 3576, '0', 0, 0, 0, 0, -4223.1630859375, -12530.875, 48.23623275756835937, 0.427396327257156372, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: Azure Watch - Difficulty: 0) (Auras: 42091 - Headless Horseman - Fire Size, 42096 - Headless Horseman - Fire onSpawn, Size) +(@CGUID+36, 23537, 530, 3524, 3576, '0', 0, 0, 0, 0, -4223.60791015625, -12510.9306640625, 52.02587890625, 1.247701048851013183, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: Azure Watch - Difficulty: 0) (Auras: 42091 - Headless Horseman - Fire Size) +(@CGUID+37, 23537, 530, 3524, 0, '0', 0, 0, 0, 0, -4198.75341796875, -12264.4755859375, 3.137856245040893554, 4.625122547149658203, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: 0 - Difficulty: 0) +(@CGUID+38, 23537, 530, 3524, 0, '0', 0, 0, 0, 0, -4203.650390625, -12283.09765625, 2.559959173202514648, 1.623156189918518066, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: 0 - Difficulty: 0) +(@CGUID+39, 23537, 530, 3524, 0, '0', 0, 0, 0, 0, -4192.44677734375, -12268.0634765625, 1.632104396820068359, 5.375614166259765625, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: 0 - Difficulty: 0) +(@CGUID+40, 23537, 530, 3524, 0, '0', 0, 0, 0, 0, -4207.79931640625, -12276.6748046875, 3.902661323547363281, 6.195918560028076171, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: 0 - Difficulty: 0) +(@CGUID+41, 23537, 530, 3524, 0, '0', 0, 0, 0, 0, -4203.5556640625, -12270.728515625, 3.779903173446655273, 6.021385669708251953, 120, 0, 0, 15017, 5751, 0, 0, 0, 0, 46366), -- Headless Horseman - Fire (DND) (Area: 0 - Difficulty: 0) +(@CGUID+42, 23712, 530, 3524, 3576, '0', 0, 0, 0, 0, -4188.38671875, -12501.90234375, 44.44465255737304687, 0.331612557172775268, 120, 0, 0, 34, 0, 0, 0, 0, 0, 46366), -- Touring Orphan (Area: Azure Watch - Difficulty: 0) +(@CGUID+43, 23712, 530, 3524, 3576, '0', 0, 0, 0, 0, -4188.1259765625, -12500.5517578125, 44.44465255737304687, 5.619960308074951171, 120, 0, 0, 34, 0, 0, 0, 0, 0, 46366), -- Touring Orphan (Area: Azure Watch - Difficulty: 0) +(@CGUID+44, 23712, 530, 3524, 3576, '0', 0, 0, 0, 0, -4187.20947265625, -12499.896484375, 44.44465255737304687, 4.852015495300292968, 120, 0, 0, 34, 0, 0, 0, 0, 0, 46366), -- Touring Orphan (Area: Azure Watch - Difficulty: 0) +(@CGUID+45, 23712, 530, 3524, 3576, '0', 0, 0, 0, 0, -4187.45556640625, -12502.751953125, 44.44465255737304687, 1.256637096405029296, 120, 0, 0, 34, 0, 0, 0, 0, 0, 46366), -- Touring Orphan (Area: Azure Watch - Difficulty: 0) +(@CGUID+46, 24519, 530, 3524, 3576, '0', 0, 0, 0, 0, -4187.1376953125, -12501.388671875, 44.44465255737304687, 2.897246599197387695, 120, 0, 0, 18771, 0, 0, 0, 0, 0, 46366); -- Costumed Orphan Matron (Area: Azure Watch - Difficulty: 0) + +-- Old gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN 34436 AND 34484; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 36222 AND 36226; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 36660 AND 36662; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 37078 AND 37081; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 37827 AND 37841; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 38158 AND 38167; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 38607 AND 38614; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 39069 AND 39077; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 39476 AND 39481; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 39476 AND 39481; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 66913 AND 66916; +DELETE FROM `gameobject` WHERE `guid` IN (37527,39853,43064,43065,43066,43068,43071,81088); +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 34436 AND 34484; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 36222 AND 36226; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 36660 AND 36662; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 37078 AND 37081; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 37827 AND 37841; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 38158 AND 38167; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 38607 AND 38614; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 39069 AND 39077; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 39476 AND 39481; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 39476 AND 39481; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 66913 AND 66916; +DELETE FROM `game_event_gameobject` WHERE `guid` IN (37527,39853,43064,43065,43066,43068,43071,81088); + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+124; +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, 530, 3524, 3576, '0', 0, 0, -4106.099609375, -12482.2490234375, 42.60072708129882812, 1.85004889965057373, 0, 0, 0.798635482788085937, 0.60181504487991333, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+1, 180405, 530, 3524, 3576, '0', 0, 0, -4209.689453125, -12516.853515625, 45.6704864501953125, 2.234017848968505859, 0, 0, 0.898793220520019531, 0.438372820615768432, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+2, 180405, 530, 3524, 3576, '0', 0, 0, -4154.16845703125, -12485.9892578125, 44.48395919799804687, 5.89921426773071289, 0, 0, -0.19080829620361328, 0.981627285480499267, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+3, 180405, 530, 3524, 3576, '0', 0, 0, -4232.39306640625, -12497.5966796875, 43.78133010864257812, 4.660029888153076171, 0, 0, -0.72537422180175781, 0.688354730606079101, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+4, 180405, 530, 3524, 3576, '0', 0, 0, -4210.13427734375, -12559.54296875, 41.69550704956054687, 0.802850961685180664, 0, 0, 0.390730857849121093, 0.920504987239837646, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+5, 180406, 530, 3524, 3576, '0', 0, 0, -4103.95703125, -12500.955078125, 42.72493362426757812, 2.303830623626708984, 0, 0, 0.913544654846191406, 0.406738430261611938, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Azure Watch - Difficulty: 0) +(@OGUID+6, 180406, 530, 3524, 3576, '0', 0, 0, -4155.759765625, -12535.306640625, 45.46803665161132812, 3.874631166458129882, 0, 0, -0.93358039855957031, 0.358368009328842163, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Azure Watch - Difficulty: 0) +(@OGUID+7, 180406, 530, 3524, 3576, '0', 0, 0, -4227.47314453125, -12483.6865234375, 44.2101593017578125, 4.97418975830078125, 0, 0, -0.60876083374023437, 0.793353796005249023, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Azure Watch - Difficulty: 0) +(@OGUID+8, 180407, 530, 3524, 3576, '0', 0, 0, -4212.15869140625, -12511.021484375, 45.32862091064453125, 2.286378860473632812, 0, 0, 0.909960746765136718, 0.414694398641586303, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Azure Watch - Difficulty: 0) +(@OGUID+9, 180407, 530, 3524, 3576, '0', 0, 0, -4181.39697265625, -12564.78515625, 40.294525146484375, 6.108653545379638671, 0, 0, -0.08715534210205078, 0.996194720268249511, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Azure Watch - Difficulty: 0) +(@OGUID+10, 180407, 530, 3524, 3576, '0', 0, 0, -4150.23681640625, -12490.3330078125, 44.47504425048828125, 5.794494152069091796, 0, 0, -0.24192142486572265, 0.970295846462249755, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Azure Watch - Difficulty: 0) +(@OGUID+11, 180407, 530, 3524, 3576, '0', 0, 0, -4167.341796875, -12452.5908203125, 44.03234100341796875, 5.89921426773071289, 0, 0, -0.19080829620361328, 0.981627285480499267, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Azure Watch - Difficulty: 0) +(@OGUID+12, 180411, 530, 3524, 3576, '0', 0, 0, -4230.20166015625, -12521.87890625, 50.21706771850585937, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 46366), -- G_Ghost_01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+13, 180415, 530, 3524, 3576, '0', 0, 0, -4180.38525390625, -12501.123046875, 47.1245880126953125, 3.368495941162109375, 0, 0, -0.99357128143310546, 0.113208353519439697, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+14, 180415, 530, 3524, 3576, '0', 0, 0, -4180.27880859375, -12501.986328125, 47.12661361694335937, 3.682650327682495117, 0, 0, -0.96362972259521484, 0.26724100112915039, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+15, 180415, 530, 3524, 3576, '0', 0, 0, -4178.26318359375, -12503.6689453125, 47.12734222412109375, 4.171337604522705078, 0, 0, -0.87035560607910156, 0.492423713207244873, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+16, 180415, 530, 3524, 3576, '0', 0, 0, -4177.80126953125, -12503.763671875, 47.12590408325195312, 1.308995485305786132, 0, 0, 0.608760833740234375, 0.793353796005249023, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+17, 180415, 530, 3524, 3576, '0', 0, 0, -4190.67822265625, -12467.5087890625, 46.48041152954101562, 5.654868602752685546, 0, 0, -0.30901622772216796, 0.95105677843093872, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+18, 180415, 530, 3524, 3576, '0', 0, 0, -4176.59619140625, -12499.7578125, 47.12430191040039062, 4.188792228698730468, 0, 0, -0.86602497100830078, 0.50000077486038208, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+19, 180415, 530, 3524, 3576, '0', 0, 0, -4175.74560546875, -12502.263671875, 47.134979248046875, 3.857182979583740234, 0, 0, -0.93667125701904296, 0.350209832191467285, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+20, 180415, 530, 3524, 3576, '0', 0, 0, -4180.013671875, -12502.603515625, 47.13022232055664062, 4.502951622009277343, 0, 0, -0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+21, 180415, 530, 3524, 3576, '0', 0, 0, -4179.40625, -12503.5068359375, 47.13358306884765625, 5.567600727081298828, 0, 0, -0.35020732879638671, 0.936672210693359375, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+22, 180415, 530, 3524, 3576, '0', 0, 0, -4179.17919921875, -12499.4140625, 47.13383865356445312, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+23, 180415, 530, 3524, 3576, '0', 0, 0, -4176.68212890625, -12503.44140625, 47.12620162963867187, 3.665196180343627929, 0, 0, -0.96592521667480468, 0.258821308612823486, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+24, 180415, 530, 3524, 3576, '0', 0, 0, -4178.6337890625, -12503.607421875, 47.129119873046875, 4.852017402648925781, 0, 0, -0.65605831146240234, 0.754710197448730468, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+25, 180415, 530, 3524, 3576, '0', 0, 0, -4179.900390625, -12502.87109375, 47.13166427612304687, 3.316144466400146484, 0, 0, -0.99619388580322265, 0.087165042757987976, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+26, 180415, 530, 3524, 3576, '0', 0, 0, -4177.380859375, -12499.419921875, 47.12635421752929687, 0.698131442070007324, 0, 0, 0.342020034790039062, 0.939692676067352294, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+27, 180415, 530, 3524, 3576, '0', 0, 0, -4178.173828125, -12499.294921875, 47.13103103637695312, 5.445427894592285156, 0, 0, -0.40673637390136718, 0.913545548915863037, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+28, 180415, 530, 3524, 3576, '0', 0, 0, -4176.42822265625, -12500.19921875, 47.1257781982421875, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+29, 180415, 530, 3524, 3576, '0', 0, 0, -4176.44091796875, -12503.1240234375, 47.12855911254882812, 5.270895957946777343, 0, 0, -0.48480892181396484, 0.87462007999420166, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+30, 180415, 530, 3524, 3576, '0', 0, 0, -4177.76318359375, -12499.369140625, 47.12849807739257812, 5.637413978576660156, 0, 0, -0.31730461120605468, 0.948323667049407958, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+31, 180415, 530, 3524, 3576, '0', 0, 0, -4178.5009765625, -12499.2275390625, 47.13319778442382812, 5.410521507263183593, 0, 0, -0.42261791229248046, 0.906307935714721679, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+32, 180415, 530, 3524, 3576, '0', 0, 0, -4176.87744140625, -12503.7236328125, 47.12460708618164062, 2.67034769058227539, 0, 0, 0.972369194030761718, 0.233448356389999389, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+33, 180415, 530, 3524, 3576, '0', 0, 0, -4175.7275390625, -12501.7822265625, 47.13441848754882812, 2.44346022605895996, 0, 0, 0.939692497253417968, 0.34202045202255249, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+34, 180415, 530, 3524, 3576, '0', 0, 0, -4179.37939453125, -12499.705078125, 47.13203048706054687, 5.637413978576660156, 0, 0, -0.31730461120605468, 0.948323667049407958, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+35, 180415, 530, 3524, 3576, '0', 0, 0, -4175.984375, -12502.54296875, 47.13262176513671875, 3.43830275535583496, 0, 0, -0.98901557922363281, 0.147811368107795715, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+36, 180415, 530, 3524, 3576, '0', 0, 0, -4180.43212890625, -12501.67578125, 47.12528610229492187, 5.93412017822265625, 0, 0, -0.17364788055419921, 0.984807789325714111, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+37, 180415, 530, 3524, 3576, '0', 0, 0, -4176.23828125, -12500.580078125, 47.128387451171875, 4.782202720642089843, 0, 0, -0.68199825286865234, 0.731353819370269775, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+38, 180415, 530, 3524, 3576, '0', 0, 0, -4179.04052734375, -12503.5537109375, 47.13144683837890625, 2.495818138122558593, 0, 0, 0.948323249816894531, 0.317305892705917358, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+39, 180415, 530, 3524, 3576, '0', 0, 0, -4179.88232421875, -12500.4033203125, 47.12837600708007812, 5.201082706451416015, 0, 0, -0.51503753662109375, 0.857167601585388183, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+40, 180415, 530, 3524, 3576, '0', 0, 0, -4176.060546875, -12501.0234375, 47.13015365600585937, 2.897245407104492187, 0, 0, 0.99254608154296875, 0.121869951486587524, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+41, 180415, 530, 3524, 3576, '0', 0, 0, -4177.05810546875, -12499.4677734375, 47.12438583374023437, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+42, 180415, 530, 3524, 3576, '0', 0, 0, -4177.38134765625, -12503.8369140625, 47.12417984008789062, 5.777040958404541015, 0, 0, -0.25037956237792968, 0.968147754669189453, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+43, 180415, 530, 3524, 3576, '0', 0, 0, -4178.8046875, -12499.2021484375, 47.1342620849609375, 1.797688722610473632, 0, 0, 0.7826080322265625, 0.622514784336090087, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+44, 180415, 530, 3524, 3576, '0', 0, 0, -4180.1318359375, -12500.765625, 47.126373291015625, 5.078907966613769531, 0, 0, -0.56640625, 0.824126183986663818, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+45, 180415, 530, 3524, 3576, '0', 0, 0, -4175.892578125, -12501.416015625, 47.1322479248046875, 4.48549652099609375, 0, 0, -0.7826080322265625, 0.622514784336090087, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+46, 180415, 530, 3524, 3576, '0', 0, 0, -4179.79052734375, -12503.166015625, 47.1336212158203125, 5.550147056579589843, 0, 0, -0.358367919921875, 0.933580458164215087, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+47, 180415, 530, 3524, 3576, '0', 0, 0, -4176.1982421875, -12502.8408203125, 47.131011962890625, 1.815141916275024414, 0, 0, 0.788010597229003906, 0.615661680698394775, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+48, 180415, 530, 3524, 3576, '0', 0, 0, -4180.15087890625, -12502.2724609375, 47.12825775146484375, 1.972219824790954589, 0, 0, 0.83388519287109375, 0.55193793773651123, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+49, 180415, 530, 3524, 3576, '0', 0, 0, -4197.96630859375, -12462.2392578125, 47.00961685180664062, 6.195919513702392578, 0, 0, -0.04361915588378906, 0.999048233032226562, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+50, 180415, 530, 3524, 3576, '0', 0, 0, -4179.6162109375, -12500.0439453125, 47.12999725341796875, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+51, 180415, 530, 3524, 3576, '0', 0, 0, -4217.92431640625, -12472.2080078125, 46.1710205078125, 2.72271275520324707, 0, 0, 0.978147506713867187, 0.207912087440490722, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+52, 180415, 530, 3524, 3576, '0', 0, 0, -4207.0234375, -12465.798828125, 47.82985305786132812, 4.48549652099609375, 0, 0, -0.7826080322265625, 0.622514784336090087, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+53, 180415, 530, 3524, 3576, '0', 0, 0, -4205.6376953125, -12452.578125, 46.42663192749023437, 3.176533222198486328, 0, 0, -0.999847412109375, 0.017469281330704689, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+54, 180415, 530, 3524, 3576, '0', 0, 0, -4202.3837890625, -12453.958984375, 46.42408370971679687, 0.174532130360603332, 0, 0, 0.087155342102050781, 0.996194720268249511, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+55, 180415, 530, 3524, 3576, '0', 0, 0, -4217.71435546875, -12471.5986328125, 46.1710205078125, 2.775068521499633789, 0, 0, 0.983254432678222656, 0.182238012552261352, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+56, 180415, 530, 3524, 3576, '0', 0, 0, -4206.8271484375, -12465.4658203125, 47.00087738037109375, 0.558503925800323486, 0, 0, 0.275636672973632812, 0.961261868476867675, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+57, 180415, 530, 3524, 3576, '0', 0, 0, -4218.4296875, -12472.6201171875, 46.1710205078125, 0.610863447189331054, 0, 0, 0.3007049560546875, 0.953717231750488281, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+58, 180415, 530, 3524, 3576, '0', 0, 0, -4212.3544921875, -12456.9833984375, 46.51558303833007812, 6.12610626220703125, 0, 0, -0.07845878601074218, 0.996917366981506347, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+59, 180415, 530, 3524, 3576, '0', 0, 0, -4217.966796875, -12471.021484375, 46.1710205078125, 1.623155713081359863, 0, 0, 0.725374221801757812, 0.688354730606079101, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+60, 180415, 530, 3524, 3576, '0', 0, 0, -4218.9990234375, -12472.607421875, 46.1710205078125, 2.199114561080932617, 0, 0, 0.8910064697265625, 0.453990638256072998, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+61, 180415, 530, 3524, 3576, '0', 0, 0, -4211.396484375, -12453.6533203125, 46.50823211669921875, 1.972219824790954589, 0, 0, 0.83388519287109375, 0.55193793773651123, 120, 255, 1, 46366), -- CandleBlack01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+62, 180425, 530, 3524, 3576, '0', 0, 0, -4179.0712890625, -12499.0947265625, 47.13811111450195312, 1.867502212524414062, 0, 0, 0.803856849670410156, 0.594822824001312255, 120, 255, 1, 46366), -- SkullCandle01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+63, 180425, 530, 3524, 3576, '0', 0, 0, -4175.5341796875, -12502.05078125, 47.137908935546875, 6.003933906555175781, 0, 0, -0.13917255401611328, 0.990268170833587646, 120, 255, 1, 46366), -- SkullCandle01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+64, 180425, 530, 3524, 3576, '0', 0, 0, -4176.6923828125, -12499.388671875, 47.126251220703125, 0.733038187026977539, 0, 0, 0.358367919921875, 0.933580458164215087, 120, 255, 1, 46366), -- SkullCandle01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+65, 180425, 530, 3524, 3576, '0', 0, 0, -4179.7080078125, -12503.482421875, 47.13659286499023437, 4.101525306701660156, 0, 0, -0.88701057434082031, 0.461749136447906494, 120, 255, 1, 46366), -- SkullCandle01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+66, 180425, 530, 3524, 3576, '0', 0, 0, -4176.9755859375, -12503.9951171875, 47.125457763671875, 5.270895957946777343, 0, 0, -0.48480892181396484, 0.87462007999420166, 120, 255, 1, 46366), -- SkullCandle01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+67, 180425, 530, 3524, 3576, '0', 0, 0, -4189.14013671875, -12467.173828125, 46.47801589965820312, 5.811946868896484375, 0, 0, -0.2334451675415039, 0.972369968891143798, 120, 255, 1, 46366), -- SkullCandle01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+68, 180425, 530, 3524, 3576, '0', 0, 0, -4180.62939453125, -12501.390625, 47.12571334838867187, 3.124123096466064453, 0, 0, 0.99996185302734375, 0.008734640665352344, 120, 255, 1, 46366), -- SkullCandle01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+69, 180425, 530, 3524, 3576, '0', 0, 0, -4199.078125, -12461.638671875, 46.99699020385742187, 1.169368624687194824, 0, 0, 0.551936149597167968, 0.833886384963989257, 120, 255, 1, 46366), -- SkullCandle01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+70, 180425, 530, 3524, 3576, '0', 0, 0, -4206.26171875, -12467.5693359375, 46.98130416870117187, 5.986480236053466796, 0, 0, -0.14780902862548828, 0.989015936851501464, 120, 255, 1, 46366), -- SkullCandle01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+71, 180425, 530, 3524, 3576, '0', 0, 0, -4217.70947265625, -12471.953125, 46.1710205078125, 6.108653545379638671, 0, 0, -0.08715534210205078, 0.996194720268249511, 120, 255, 1, 46366), -- SkullCandle01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+72, 180425, 530, 3524, 3576, '0', 0, 0, -4218.14697265625, -12470.7470703125, 46.1710205078125, 0.942476630210876464, 0, 0, 0.453989982604980468, 0.891006767749786376, 120, 255, 1, 46366), -- SkullCandle01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+73, 180425, 530, 3524, 3576, '0', 0, 0, -4217.7490234375, -12471.283203125, 46.1710205078125, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 46366), -- SkullCandle01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+74, 180425, 530, 3524, 3576, '0', 0, 0, -4218.10498046875, -12472.4501953125, 46.1710205078125, 5.375615119934082031, 0, 0, -0.4383707046508789, 0.898794233798980712, 120, 255, 1, 46366), -- SkullCandle01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+75, 180425, 530, 3524, 3576, '0', 0, 0, -4218.7080078125, -12472.685546875, 46.1710205078125, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, 46366), -- SkullCandle01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+76, 180425, 530, 3524, 3576, '0', 0, 0, -4219.26513671875, -12472.5126953125, 46.1710205078125, 4.101525306701660156, 0, 0, -0.88701057434082031, 0.461749136447906494, 120, 255, 1, 46366), -- SkullCandle01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+77, 180426, 530, 3524, 3576, '0', 0, 0, -4180.767578125, -12511.125, 49.06965255737304687, 0.15707901120185852, 0, 0, 0.078458786010742187, 0.996917366981506347, 120, 255, 1, 46366), -- Bat01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+78, 180426, 530, 3524, 3576, '0', 0, 0, -4171.09033203125, -12492.8408203125, 52.7796478271484375, 6.021387100219726562, 0, 0, -0.13052558898925781, 0.991444945335388183, 120, 255, 1, 46366), -- Bat01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+79, 180426, 530, 3524, 3576, '0', 0, 0, -4187.01904296875, -12508.8056640625, 50.33354568481445312, 2.391098499298095703, 0, 0, 0.930417060852050781, 0.366502493619918823, 120, 255, 1, 46366), -- Bat01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+80, 180426, 530, 3524, 3576, '0', 0, 0, -4177.125, -12519.96875, 53.60570526123046875, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 120, 255, 1, 46366), -- Bat01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+81, 180426, 530, 3524, 3576, '0', 0, 0, -4176.20849609375, -12507.9384765625, 52.56463241577148437, 2.042035102844238281, 0, 0, 0.852640151977539062, 0.522498607635498046, 120, 255, 1, 46366), -- Bat01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+82, 180426, 530, 3524, 3576, '0', 0, 0, -4184.10791015625, -12507.013671875, 46.86132049560546875, 6.195919513702392578, 0, 0, -0.04361915588378906, 0.999048233032226562, 120, 255, 1, 46366), -- Bat01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+83, 180426, 530, 3524, 3576, '0', 0, 0, -4186.8837890625, -12499.8017578125, 46.27798843383789062, 0.558503925800323486, 0, 0, 0.275636672973632812, 0.961261868476867675, 120, 255, 1, 46366), -- Bat01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+84, 180426, 530, 3524, 3576, '0', 0, 0, -4181.4755859375, -12508.896484375, 49.92382049560546875, 3.420850038528442382, 0, 0, -0.99026775360107421, 0.139175355434417724, 120, 255, 1, 46366), -- Bat01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+85, 180426, 530, 3524, 3576, '0', 0, 0, -4173.49462890625, -12509.5556640625, 46.95159912109375, 5.619962215423583984, 0, 0, -0.32556724548339843, 0.945518851280212402, 120, 255, 1, 46366), -- Bat01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+86, 180426, 530, 3524, 3576, '0', 0, 0, -4175.81591796875, -12511.146484375, 49.93076705932617187, 1.989672422409057617, 0, 0, 0.838669776916503906, 0.544640243053436279, 120, 255, 1, 46366), -- Bat01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+87, 180427, 530, 3524, 3576, '0', 0, 0, -4177.5244140625, -12492.2607421875, 54.54271316528320312, 5.270895957946777343, 0, 0, -0.48480892181396484, 0.87462007999420166, 120, 255, 1, 46366), -- Bat02 (Area: Azure Watch - Difficulty: 0) +(@OGUID+88, 180427, 530, 3524, 3576, '0', 0, 0, -4182.125, -12512.0869140625, 54.15298843383789062, 0.680676698684692382, 0, 0, 0.333806037902832031, 0.942641794681549072, 120, 255, 1, 46366), -- Bat02 (Area: Azure Watch - Difficulty: 0) +(@OGUID+89, 180427, 530, 3524, 3576, '0', 0, 0, -4176.626953125, -12510.0634765625, 56.49326705932617187, 4.206246376037597656, 0, 0, -0.86162853240966796, 0.50753939151763916, 120, 255, 1, 46366), -- Bat02 (Area: Azure Watch - Difficulty: 0) +(@OGUID+90, 180427, 530, 3524, 3576, '0', 0, 0, -4198.50341796875, -12495.732421875, 44.80474090576171875, 5.95157480239868164, 0, 0, -0.16504669189453125, 0.986285746097564697, 120, 255, 1, 46366), -- Bat02 (Area: Azure Watch - Difficulty: 0) +(@OGUID+91, 180427, 530, 3524, 3576, '0', 0, 0, -4182.2744140625, -12511.0556640625, 51.16687774658203125, 1.710421562194824218, 0, 0, 0.754709243774414062, 0.656059443950653076, 120, 255, 1, 46366), -- Bat02 (Area: Azure Watch - Difficulty: 0) +(@OGUID+92, 180427, 530, 3524, 3576, '0', 0, 0, -4183.9443359375, -12509.1943359375, 51.3196563720703125, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 46366), -- Bat02 (Area: Azure Watch - Difficulty: 0) +(@OGUID+93, 180427, 530, 3524, 3576, '0', 0, 0, -4187.21875, -12507.5693359375, 57.39604568481445312, 2.460912704467773437, 0, 0, 0.942641258239746093, 0.333807557821273803, 120, 255, 1, 46366), -- Bat02 (Area: Azure Watch - Difficulty: 0) +(@OGUID+94, 180427, 530, 3524, 3576, '0', 0, 0, -4175.83984375, -12509.099609375, 52.77239990234375, 2.391098499298095703, 0, 0, 0.930417060852050781, 0.366502493619918823, 120, 255, 1, 46366), -- Bat02 (Area: Azure Watch - Difficulty: 0) +(@OGUID+95, 180471, 530, 3524, 3576, '0', 0, 0, -4156.8974609375, -12470.701171875, 50.00299072265625, 4.380776405334472656, 0, 0, -0.81411552429199218, 0.580702960491180419, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+96, 180471, 530, 3524, 3576, '0', 0, 0, -4157.30712890625, -12471.5556640625, 50.10779190063476562, 4.345870018005371093, 0, 0, -0.82412624359130859, 0.566406130790710449, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+97, 180471, 530, 3524, 3576, '0', 0, 0, -4137.77099609375, -12495.7470703125, 49.07127761840820312, 6.230826377868652343, 0, 0, -0.02617645263671875, 0.999657332897186279, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+98, 180471, 530, 3524, 3576, '0', 0, 0, -4156.37158203125, -12469.91015625, 50.18156051635742187, 4.328419685363769531, 0, 0, -0.82903671264648437, 0.559194147586822509, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+99, 180471, 530, 3524, 3576, '0', 0, 0, -4135.51025390625, -12495.896484375, 49.96358108520507812, 6.178466320037841796, 0, 0, -0.05233573913574218, 0.998629570007324218, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+100, 180471, 530, 3524, 3576, '0', 0, 0, -4136.673828125, -12495.84375, 49.37393569946289062, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+101, 180471, 530, 3524, 3576, '0', 0, 0, -4156.23779296875, -12469.1767578125, 50.44903564453125, 4.310965538024902343, 0, 0, -0.83388519287109375, 0.55193793773651123, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+102, 180471, 530, 3524, 3576, '0', 0, 0, -4155.890625, -12468.357421875, 49.88698196411132812, 4.363324165344238281, 0, 0, -0.81915187835693359, 0.573576688766479492, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+103, 180471, 530, 3524, 3576, '0', 0, 0, -4134.3037109375, -12495.830078125, 49.29045486450195312, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Azure Watch - Difficulty: 0) +(@OGUID+104, 180472, 530, 3524, 3576, '0', 0, 0, -4213.849609375, -12515.5390625, 50.4872283935546875, 0.401424884796142578, 0, 0, 0.199367523193359375, 0.979924798011779785, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Azure Watch - Difficulty: 0) +(@OGUID+105, 180472, 530, 3524, 3576, '0', 0, 0, -4160.591796875, -12457.58984375, 47.74982070922851562, 4.782202720642089843, 0, 0, -0.68199825286865234, 0.731353819370269775, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Azure Watch - Difficulty: 0) +(@OGUID+106, 180472, 530, 3524, 3576, '0', 0, 0, -4207.44775390625, -12526.7880859375, 49.5806121826171875, 0.698131442070007324, 0, 0, 0.342020034790039062, 0.939692676067352294, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Azure Watch - Difficulty: 0) +(@OGUID+107, 180472, 530, 3524, 3576, '0', 0, 0, -4148.58154296875, -12485.201171875, 51.35175704956054687, 3.318858146667480468, 0, 0, -0.99607467651367187, 0.0885167196393013, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Azure Watch - Difficulty: 0) +(@OGUID+108, 180472, 530, 3524, 3576, '0', 0, 0, -4150.66064453125, -12527.0458984375, 50.1160736083984375, 3.577930212020874023, 0, 0, -0.97629547119140625, 0.216442063450813293, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Azure Watch - Difficulty: 0) +(@OGUID+109, 180472, 530, 3524, 3576, '0', 0, 0, -4216.9453125, -12481.42578125, 49.19249343872070312, 5.724681377410888671, 0, 0, -0.27563667297363281, 0.961261868476867675, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Azure Watch - Difficulty: 0) +(@OGUID+110, 180523, 530, 3524, 3576, '0', 0, 0, -4138.38037109375, -12473.2080078125, 45.09204864501953125, 0.264516770839691162, 0, 0, 0.131873130798339843, 0.991266608238220214, 120, 255, 1, 46366), -- Apple Bob (Area: Azure Watch - Difficulty: 0) +(@OGUID+111, 186234, 530, 3524, 3576, '0', 0, 0, -4185.75341796875, -12504.5302734375, 44.36132049560546875, 3.94444584846496582, 0, 0, -0.92050457000732421, 0.3907318115234375, 120, 255, 1, 46366), -- Water Barrel (Area: Azure Watch - Difficulty: 0) +(@OGUID+112, 186234, 530, 3524, 3576, '0', 0, 0, -4193.51025390625, -12277.8232421875, 0.310070991516113281, 1.256635904312133789, 0, 0, 0.587784767150878906, 0.809017360210418701, 120, 255, 1, 46366), -- Water Barrel (Area: Azure Watch - Difficulty: 0) +(@OGUID+113, 186614, 530, 3524, 3576, '0', 0, 0, -4186.720703125, -12506.3583984375, 44.36132049560546875, 4.45059061050415039, 0, 0, -0.79335308074951171, 0.608761727809906005, 120, 255, 1, 46366), -- Water Bucket (Area: Azure Watch - Difficulty: 0) +(@OGUID+114, 186614, 530, 3524, 3576, '0', 0, 0, -4187.3759765625, -12504.0244140625, 44.36132049560546875, 5.969027042388916015, 0, 0, -0.1564340591430664, 0.987688362598419189, 120, 255, 1, 46366), -- Water Bucket (Area: Azure Watch - Difficulty: 0) +(@OGUID+115, 186614, 530, 3524, 0, '0', 0, 0, -4191.74462890625, -12277.638671875, 0.059397000819444656, 4.625123500823974609, 0, 0, -0.73727703094482421, 0.67559051513671875, 120, 255, 1, 46366), -- Water Bucket (Area: 0 - Difficulty: 0) +(@OGUID+116, 186614, 530, 3524, 0, '0', 0, 0, -4193.408203125, -12279.6357421875, 0.272792011499404907, 2.757613182067871093, 0, 0, 0.981626510620117187, 0.190812408924102783, 120, 255, 1, 46366), -- Water Bucket (Area: 0 - Difficulty: 0) +(@OGUID+117, 186615, 530, 3524, 3576, '0', 0, 0, -4185.22119140625, -12506.474609375, 44.36132049560546875, 5.009094715118408203, 0, 0, -0.59482288360595703, 0.80385679006576538, 120, 255, 1, 46366), -- Water Buckets (Area: Azure Watch - Difficulty: 0) +(@OGUID+118, 186615, 530, 3524, 0, '0', 0, 0, -4192.17724609375, -12279.00390625, -0.03774299845099449, 5.061456203460693359, 0, 0, -0.57357597351074218, 0.819152355194091796, 120, 255, 1, 46366), -- Water Buckets (Area: 0 - Difficulty: 0) +(@OGUID+119, 186720, 530, 3524, 0, '0', 0, 0, -4198.7509765625, -12264.4716796875, 3.053963899612426757, 5.078907966613769531, 0, 0, -0.56640625, 0.824126183986663818, 120, 255, 1, 46366), -- Fire Effigy (Area: 0 - Difficulty: 0) +(@OGUID+120, 186720, 530, 3524, 0, '0', 0, 0, -4192.38427734375, -12268.05859375, 1.533890008926391601, 4.555310726165771484, 0, 0, -0.76040554046630859, 0.649448513984680175, 120, 255, 1, 46366), -- Fire Effigy (Area: 0 - Difficulty: 0) +(@OGUID+121, 186720, 530, 3524, 0, '0', 0, 0, -4203.6708984375, -12283.0791015625, 2.483135938644409179, 0.506144583225250244, 0, 0, 0.250379562377929687, 0.968147754669189453, 120, 255, 1, 46366), -- Fire Effigy (Area: 0 - Difficulty: 0) +(@OGUID+122, 186720, 530, 3524, 0, '0', 0, 0, -4207.84423828125, -12276.7001953125, 3.820851087570190429, 6.213373661041259765, 0, 0, -0.03489875793457031, 0.999390840530395507, 120, 255, 1, 46366), -- Fire Effigy (Area: 0 - Difficulty: 0) +(@OGUID+123, 186720, 530, 3524, 0, '0', 0, 0, -4203.6767578125, -12270.6162109375, 3.725678920745849609, 5.672322273254394531, 0, 0, -0.3007049560546875, 0.953717231750488281, 120, 255, 1, 46366), -- Fire Effigy (Area: 0 - Difficulty: 0) +(@OGUID+124, 190037, 530, 3524, 3576, '0', 0, 0, -4125.09033203125, -12473.84765625, 44.56914138793945312, 4.540574550628662109, 0, 0, -0.76517009735107421, 0.643828153610229492, 120, 255, 1, 46366); -- Candy Bucket (Area: Azure Watch - Difficulty: 0) + +-- Event spawns +DELETE FROM `game_event_creature` WHERE `eventEntry`=12 AND `guid` BETWEEN @CGUID+0 AND @CGUID+46; +INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES +(12, @CGUID+0), +(12, @CGUID+1), +(12, @CGUID+2), +(12, @CGUID+3), +(12, @CGUID+4), +(12, @CGUID+5), +(12, @CGUID+6), +(12, @CGUID+7), +(12, @CGUID+8), +(12, @CGUID+9), +(12, @CGUID+10), +(12, @CGUID+11), +(12, @CGUID+12), +(12, @CGUID+13), +(12, @CGUID+14), +(12, @CGUID+15), +(12, @CGUID+16), +(12, @CGUID+17), +(12, @CGUID+18), +(12, @CGUID+19), +(12, @CGUID+20), +(12, @CGUID+21), +(12, @CGUID+22), +(12, @CGUID+23), +(12, @CGUID+24), +(12, @CGUID+25), +(12, @CGUID+26), +(12, @CGUID+27), +(12, @CGUID+28), +(12, @CGUID+29), +(12, @CGUID+30), +(12, @CGUID+31), +(12, @CGUID+32), +(12, @CGUID+33), +(12, @CGUID+34), +(12, @CGUID+35), +(12, @CGUID+36), +(12, @CGUID+37), +(12, @CGUID+38), +(12, @CGUID+39), +(12, @CGUID+40), +(12, @CGUID+41), +(12, @CGUID+42), +(12, @CGUID+43), +(12, @CGUID+44), +(12, @CGUID+45), +(12, @CGUID+46); + +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+124; +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); |