diff options
3 files changed, 1285 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_11_06_09_world_tirisfal_glades_undercity.sql b/sql/updates/world/master/2023_11_06_09_world_tirisfal_glades_undercity.sql new file mode 100644 index 00000000000..50daaa997e0 --- /dev/null +++ b/sql/updates/world/master/2023_11_06_09_world_tirisfal_glades_undercity.sql @@ -0,0 +1,739 @@ +SET @CGUID := 3000138; +SET @OGUID := 3002889; + +-- Old creature spawns +DELETE FROM `creature` WHERE `guid` BETWEEN 395876 AND 395931; +DELETE FROM `creature_addon` WHERE `guid` BETWEEN 395876 AND 395931; +DELETE FROM `waypoint_data` WHERE `id`=31670160; +DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 395876 AND 395931; + +-- Creature spawns +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+55; +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 +-- Undercity +(@CGUID+0, 40435, 0, 85, 153, '0', 0, 0, 0, 0, 1637.60595703125, 239.5381927490234375, -44.0193977355957031, 3.106686115264892578, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Ghost (Area: 0 - Difficulty: 0) (Auras: 33900 - Shroud of Death) +-- Ruins of Lordaeron +(@CGUID+1, 15195, 0, 14046, 14046, '0', 0, 0, 0, 0, 1797.2223, 193.25348, 70.58827, 0, 120, 0, 0, 176865, 0, 2, NULL, NULL, NULL, NULL, 45745), -- Wickerman Guardian (Area: Tirisfal Glades - Difficulty: 0) (Auras: 12187 - Disease Cloud) (possible waypoints or random movement) +(@CGUID+2, 15195, 0, 14046, 14046, '0', 0, 0, 0, 0, 1815.6649169921875, 238.6996612548828125, 60.58826446533203125, 0.030314229428768157, 120, 0, 0, 176865, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Wickerman Guardian (Area: Tirisfal Glades - Difficulty: 0) (Auras: 12187 - Disease Cloud) +(@CGUID+3, 15195, 0, 14046, 14046, '0', 0, 0, 0, 0, 1806.63720703125, 265.41839599609375, 65.5882720947265625, 5.60678863525390625, 120, 0, 0, 176865, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Wickerman Guardian (Area: Tirisfal Glades - Difficulty: 0) (Auras: 12187 - Disease Cloud) +(@CGUID+4, 15197, 0, 14046, 14046, '0', 0, 0, 0, 1, 1794.0694580078125, 226.3333282470703125, 59.73805618286132812, 1.01229095458984375, 120, 0, 0, 8020, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Darkcaller Yanka (Area: Tirisfal Glades - Difficulty: 0) +(@CGUID+5, 15309, 0, 14046, 14046, '0', 0, 0, 0, 0, 1835.76220703125, 225.9739532470703125, 60.32813262939453125, 2.844886541366577148, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Spoops (Area: Tirisfal Glades - Difficulty: 0) +(@CGUID+6, 51702, 0, 14046, 14046, '0', 0, 0, 0, 0, 1800.970458984375, 215.6631927490234375, 65.95555877685546875, 0, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Wickerman Crowd Bunny 01 (Area: Tirisfal Glades - Difficulty: 0) +(@CGUID+7, 51703, 0, 14046, 14046, '0', 0, 0, 0, 0, 1805.1788330078125, 219.4635467529296875, 60.45840072631835937, 0, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Wickerman Crowd Bunny 02 (Area: Tirisfal Glades - Difficulty: 0) +(@CGUID+8, 51720, 0, 14046, 14046, '0', 0, 0, 0, 0, 1774.8975830078125, 217.5052032470703125, 73.76888275146484375, 2.478367567062377929, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Wickerman Torch Point (Area: Tirisfal Glades - Difficulty: 0) +(@CGUID+9, 51720, 0, 14046, 14046, '0', 0, 0, 0, 0, 1781.984375, 214.2465362548828125, 78.56402587890625, 2.478367567062377929, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Wickerman Torch Point (Area: Tirisfal Glades - Difficulty: 0) +(@CGUID+10, 51720, 0, 14046, 14046, '0', 0, 0, 0, 0, 1782.9896240234375, 211.717010498046875, 71.58807373046875, 2.483798027038574218, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Wickerman Torch Point (Area: Tirisfal Glades - Difficulty: 0) +(@CGUID+11, 51720, 0, 14046, 14046, '0', 0, 0, 0, 0, 1787.4149169921875, 206.4375, 75.89892578125, 2.478367567062377929, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Wickerman Torch Point (Area: Tirisfal Glades - Difficulty: 0) +(@CGUID+12, 51720, 0, 14046, 14046, '0', 0, 0, 0, 0, 1780.41845703125, 213.9270782470703125, 70.55231475830078125, 2.478367567062377929, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Wickerman Torch Point (Area: Tirisfal Glades - Difficulty: 0) +(@CGUID+13, 51720, 0, 14046, 14046, '0', 0, 0, 0, 0, 1787.77783203125, 209.296875, 73.43389892578125, 2.478367567062377929, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Wickerman Torch Point (Area: Tirisfal Glades - Difficulty: 0) +(@CGUID+14, 51720, 0, 14046, 14046, '0', 0, 0, 0, 0, 1783.8646240234375, 210.9288177490234375, 64.4205474853515625, 2.478367567062377929, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Wickerman Torch Point (Area: Tirisfal Glades - Difficulty: 0) +(@CGUID+15, 51720, 0, 14046, 14046, '0', 0, 0, 0, 0, 1778.59033203125, 215.0381927490234375, 64.96781158447265625, 2.478367567062377929, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Wickerman Torch Point (Area: Tirisfal Glades - Difficulty: 0) +(@CGUID+16, 51720, 0, 14046, 14046, '0', 0, 0, 0, 0, 1783.923583984375, 212.4427032470703125, 80.1749420166015625, 2.478367567062377929, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Wickerman Torch Point (Area: Tirisfal Glades - Difficulty: 0) +(@CGUID+17, 51720, 0, 14046, 14046, '0', 0, 0, 0, 0, 1775.736083984375, 216.5104217529296875, 78.94315338134765625, 2.478367567062377929, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Wickerman Torch Point (Area: Tirisfal Glades - Difficulty: 0) +(@CGUID+18, 51720, 0, 14046, 14046, '0', 0, 0, 0, 0, 1783.904541015625, 211.015625, 75.6013031005859375, 2.478367567062377929, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Wickerman Torch Point (Area: Tirisfal Glades - Difficulty: 0) +(@CGUID+19, 51720, 0, 14046, 14046, '0', 0, 0, 0, 0, 1780.8004150390625, 215.0868072509765625, 77.540252685546875, 2.478367567062377929, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Wickerman Torch Point (Area: Tirisfal Glades - Difficulty: 0) +(@CGUID+20, 51720, 0, 14046, 14046, '0', 0, 0, 0, 0, 1782.5625, 213.5833282470703125, 73.53997802734375, 2.478367567062377929, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Wickerman Torch Point (Area: Tirisfal Glades - Difficulty: 0) +(@CGUID+21, 51720, 0, 14046, 14046, '0', 0, 0, 0, 0, 1778.68408203125, 214.19097900390625, 71.52509307861328125, 2.478367567062377929, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Wickerman Torch Point (Area: Tirisfal Glades - Difficulty: 0) +(@CGUID+22, 51720, 0, 14046, 14046, '0', 0, 0, 0, 0, 1779.736083984375, 216.342010498046875, 62.45322418212890625, 2.478367567062377929, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Wickerman Torch Point (Area: Tirisfal Glades - Difficulty: 0) +(@CGUID+23, 51720, 0, 14046, 14046, '0', 0, 0, 0, 0, 1783.41845703125, 212.9965362548828125, 76.1242523193359375, 2.407310962677001953, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Wickerman Torch Point (Area: Tirisfal Glades - Difficulty: 0) +(@CGUID+24, 51730, 0, 14046, 14046, '0', 0, 0, 0, 0, 1789.4271240234375, 224.78125, 59.57237625122070312, 4.415682792663574218, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Wickerman Reveler (Area: Tirisfal Glades - Difficulty: 0) (Auras: 95957 - Hold Torch Visual) +(@CGUID+25, 51730, 0, 14046, 14046, '0', 0, 0, 0, 0, 1798.704833984375, 219.6458282470703125, 59.82982635498046875, 0.383972436189651489, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Wickerman Reveler (Area: Tirisfal Glades - Difficulty: 0) (Auras: 95957 - Hold Torch Visual) +(@CGUID+26, 51730, 0, 14046, 14046, '0', 0, 0, 0, 0, 1800.52783203125, 220.295135498046875, 59.82598876953125, 3.577924966812133789, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Wickerman Reveler (Area: Tirisfal Glades - Difficulty: 0) (Auras: 95957 - Hold Torch Visual) +(@CGUID+27, 51730, 0, 14046, 14046, '0', 0, 0, 0, 0, 1792.1024169921875, 219.83160400390625, 59.97956085205078125, 5.096361160278320312, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Wickerman Reveler (Area: Tirisfal Glades - Difficulty: 0) (Auras: 95957 - Hold Torch Visual) +(@CGUID+28, 51730, 0, 14046, 14046, '0', 0, 0, 0, 0, 1793.0555419921875, 218.126739501953125, 60.1507568359375, 2.076941728591918945, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Wickerman Reveler (Area: Tirisfal Glades - Difficulty: 0) (Auras: 95957 - Hold Torch Visual) +(@CGUID+29, 51730, 0, 14046, 14046, '0', 0, 0, 0, 0, 1824.15625, 252.3663177490234375, 60.08759307861328125, 1.09691023826599121, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Wickerman Reveler (Area: Tirisfal Glades - Difficulty: 0) (Auras: 95957 - Hold Torch Visual) +(@CGUID+30, 51730, 0, 14046, 14046, '0', 0, 0, 0, 0, 1787.1649169921875, 224.5729217529296875, 59.49418258666992187, 5.009094715118408203, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Wickerman Reveler (Area: Tirisfal Glades - Difficulty: 0) (Auras: 95957 - Hold Torch Visual) +(@CGUID+31, 51730, 0, 14046, 14046, '0', 0, 0, 0, 0, 1823.470458984375, 254.6788177490234375, 60.03674697875976562, 6.078156948089599609, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Wickerman Reveler (Area: Tirisfal Glades - Difficulty: 0) (Auras: 95957 - Hold Torch Visual) +(@CGUID+32, 51730, 0, 14046, 14046, '0', 0, 0, 0, 0, 1786.05908203125, 253.5364532470703125, 59.63842010498046875, 2.06206369400024414, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Wickerman Reveler (Area: Tirisfal Glades - Difficulty: 0) (Auras: 95957 - Hold Torch Visual) +(@CGUID+33, 51730, 0, 14046, 14046, '0', 0, 0, 0, 0, 1786.4635009765625, 259.87152099609375, 59.66410446166992187, 4.267926692962646484, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Wickerman Reveler (Area: Tirisfal Glades - Difficulty: 0) (Auras: 95957 - Hold Torch Visual) +(@CGUID+34, 51731, 0, 14046, 14046, '0', 0, 0, 0, 1, 1792.720458984375, 223.50347900390625, 59.81268310546875, 3.682644605636596679, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Wickerman Reveler (Area: Tirisfal Glades - Difficulty: 0) +(@CGUID+35, 53756, 0, 14046, 14046, '0', 0, 0, 0, 0, 1836.660888671875, 219.086578369140625, 60.25131988525390625, 2.693991661071777343, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Darla (Area: Tirisfal Glades - Difficulty: 0) (Auras: 100315 - Scary Tiki Mask) (possible waypoints or random movement) +(@CGUID+36, 53757, 0, 14046, 14046, '0', 0, 0, 0, 0, 1835.5675048828125, 223.5998382568359375, 60.44070816040039062, 2.918202638626098632, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Chub (Area: Tirisfal Glades - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+37, 53760, 0, 14046, 14046, '0', 0, 0, 0, 0, 1835.2855224609375, 216.7303314208984375, 60.30122756958007812, 2.505059719085693359, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Farina (Area: Tirisfal Glades - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+38, 53763, 0, 14046, 14046, '0', 0, 0, 0, 0, 1827.6805419921875, 212.5243072509765625, 60.44593048095703125, 4.729842185974121093, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Candace Fenlow (Area: Tirisfal Glades - Difficulty: 0) +(@CGUID+39, 53764, 0, 14046, 14046, '0', 0, 0, 0, 0, 1818.342041015625, 226.03125, 59.66989898681640625, 5.497786998748779296, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Crina Fenlow (Area: Tirisfal Glades - Difficulty: 0) +(@CGUID+40, 53865, 0, 14046, 14046, '0', 0, 0, 0, 0, 1833.9288330078125, 212.8506927490234375, 60.38811492919921875, 2.268928050994873046, 120, 0, 0, 1604, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Orphan Matron Nanee (Area: Tirisfal Glades - Difficulty: 0) +(@CGUID+41, 54043, 0, 14046, 14046, '0', 0, 0, 0, 0, 1804.076416015625, 153.8645782470703125, 70.48151397705078125, 4.607669353485107421, 120, 0, 0, 1604, 852, 0, NULL, NULL, NULL, NULL, 45745), -- Spider Summoner (Catacombs) (Area: Tirisfal Glades - Difficulty: 0) +(@CGUID+42, 54072, 0, 14046, 0, '0', 0, 0, 0, 1, 1584.1649169921875, 62.74479293823242187, 62.61980438232421875, 4.764749050140380859, 120, 0, 0, 14739, 2434, 0, NULL, NULL, NULL, NULL, 45745), -- Sanath Lim-yo (Area: 0 - Difficulty: 0) +(@CGUID+43, 54169, 0, 14046, 0, '0', 0, 0, 0, 0, 1583.4566650390625, 59.19444656372070312, 62.61980438232421875, 1.710422635078430175, 120, 0, 0, 1604, 100, 0, NULL, NULL, NULL, NULL, 45745), -- Maxim the Sly (Area: 0 - Difficulty: 0) (Auras: ) +(@CGUID+44, 54207, 0, 14046, 14046, '0', 0, 0, 0, 0, 1811.93408203125, 139.5572967529296875, 70.48291778564453125, 2.722713708877563476, 120, 0, 0, 1604, 100, 0, NULL, NULL, NULL, NULL, 45745), -- Dead Undercity Citizen (Area: Tirisfal Glades - Difficulty: 0) (Auras: 100600 - Cripple State, 29266 - Permanent Feign Death) +(@CGUID+45, 54207, 0, 14046, 0, '0', 0, 0, 0, 0, 1793.560791015625, 124.4201431274414062, 61.73511505126953125, 4.764749050140380859, 120, 0, 0, 1604, 100, 0, NULL, NULL, NULL, NULL, 45745), -- Dead Undercity Citizen (Area: 0 - Difficulty: 0) (Auras: 100600 - Cripple State, 29266 - Permanent Feign Death) +(@CGUID+46, 54207, 0, 14046, 0, '0', 0, 0, 0, 0, 1776.4375, 124.6076431274414062, 65.48291778564453125, 5.619960308074951171, 120, 0, 0, 1604, 100, 0, NULL, NULL, NULL, NULL, 45745), -- Dead Undercity Citizen (Area: 0 - Difficulty: 0) (Auras: 100600 - Cripple State, 29266 - Permanent Feign Death) +(@CGUID+47, 54207, 0, 14046, 0, '0', 0, 0, 0, 0, 1804.6614990234375, 107.0225677490234375, 61.4874725341796875, 1.797689080238342285, 120, 0, 0, 1604, 100, 0, NULL, NULL, NULL, NULL, 45745), -- Dead Undercity Citizen (Area: 0 - Difficulty: 0) (Auras: 100600 - Cripple State, 29266 - Permanent Feign Death) +(@CGUID+48, 54207, 0, 14046, 0, '0', 0, 0, 0, 0, 1781.9879150390625, 73.63889312744140625, 60.98386001586914062, 0.680678427219390869, 120, 0, 0, 1604, 100, 0, NULL, NULL, NULL, NULL, 45745), -- Dead Undercity Citizen (Area: 0 - Difficulty: 0) (Auras: 100600 - Cripple State, 29266 - Permanent Feign Death) +(@CGUID+49, 54207, 0, 14046, 0, '0', 0, 0, 0, 0, 1795.5572509765625, 60.48611068725585937, 62.69221115112304687, 2.897246599197387695, 120, 0, 0, 1604, 100, 0, NULL, NULL, NULL, NULL, 45745), -- Dead Undercity Citizen (Area: 0 - Difficulty: 0) (Auras: 100600 - Cripple State, 29266 - Permanent Feign Death) +(@CGUID+50, 54207, 0, 14046, 0, '0', 0, 0, 0, 0, 1709.873291015625, 52.45833206176757812, 60.71137237548828125, 0.191986218094825744, 120, 0, 0, 1604, 100, 0, NULL, NULL, NULL, NULL, 45745), -- Dead Undercity Citizen (Area: 0 - Difficulty: 0) (Auras: 100600 - Cripple State, 29266 - Permanent Feign Death) +(@CGUID+51, 54207, 0, 14046, 0, '0', 0, 0, 0, 0, 1675.0103759765625, 61.36458206176757812, 61.7610321044921875, 3.246312379837036132, 120, 0, 0, 1604, 100, 0, NULL, NULL, NULL, NULL, 45745), -- Dead Undercity Citizen (Area: 0 - Difficulty: 0) (Auras: 100600 - Cripple State, 29266 - Permanent Feign Death) +(@CGUID+52, 54207, 0, 14046, 0, '0', 0, 0, 0, 0, 1646.6649169921875, 68.1475677490234375, 60.78204345703125, 5.497786998748779296, 120, 0, 0, 1604, 100, 0, NULL, NULL, NULL, NULL, 45745), -- Dead Undercity Citizen (Area: 0 - Difficulty: 0) (Auras: 100600 - Cripple State, 29266 - Permanent Feign Death) +(@CGUID+53, 54207, 0, 85, 153, '0', 0, 0, 0, 0, 1635.8629150390625, 48.22222137451171875, 61.12198638916015625, 0.523598790168762207, 120, 0, 0, 1604, 100, 0, NULL, NULL, NULL, NULL, 45745), -- Dead Undercity Citizen (Area: Ruins of Lordaeron - Difficulty: 0) (Auras: 100600 - Cripple State, 29266 - Permanent Feign Death) +(@CGUID+54, 54207, 0, 14046, 0, '0', 0, 0, 0, 0, 1613.21533203125, 53.58159637451171875, 60.67036056518554687, 2.321287870407104492, 120, 0, 0, 1604, 100, 0, NULL, NULL, NULL, NULL, 45745), -- Dead Undercity Citizen (Area: 0 - Difficulty: 0) (Auras: 100600 - Cripple State, 29266 - Permanent Feign Death) +(@CGUID+55, 109688, 0, 14046, 14046, '0', 0, 0, 0, 0, 1835.6441650390625, 214.2152862548828125, 60.37485504150390625, 2.763052940368652343, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745); -- Woim (Area: Tirisfal Glades - Difficulty: 0) + +SET @ENTRY := 15195; +SET @PATHOFFSET := 0; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `creature_addon` WHERE `guid` IN (@CGUID+1, @CGUID+38); +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+1, @PATH, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '131700 12187'), -- 15195 (Wickerman Guardian) +(@CGUID+38, 0, 0, 0, 0, 0, 1, 0, 133, 0, 0, 0, 0, ''); -- 53763 (Candace Fenlow) + +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 1797.2223, 193.25348, 70.58827, NULL, 0), +(@PATH, 1, 1785.7795, 193.0868, 70.58827, NULL, 0), +(@PATH, 2, 1776.5365, 192.85764, 70.58827, NULL, 0), +(@PATH, 3, 1765.2795, 192.77083, 70.58827, NULL, 0), +(@PATH, 4, 1756.5087, 192.5382, 70.58827, NULL, 0), +(@PATH, 5, 1765.2795, 192.77083, 70.58827, NULL, 0), +(@PATH, 6, 1776.5365, 192.85764, 70.58827, NULL, 0), +(@PATH, 7, 1785.7795, 193.0868, 70.58827, NULL, 0); + +-- Old gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN 242660 AND 242941; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 242660 AND 242941; + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+281; +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, 14046, 14046, '0', 0, 0, 1809.0989990234375, 215.4930572509765625, 65.872222900390625, 2.635215997695922851, 0, 0, 0.968118667602539062, 0.250491976737976074, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+1, 180405, 0, 14046, 14046, '0', 0, 0, 1834.6285400390625, 209.9131927490234375, 60.45355224609375, 4.1538848876953125, 0, 0, -0.8746194839477539, 0.484810054302215576, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+2, 180405, 0, 14046, 14046, '0', 0, 0, 1847.189208984375, 219.1684112548828125, 60.5933990478515625, 5.253442287445068359, 0, 0, -0.49242305755615234, 0.870355963706970214, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+3, 180405, 0, 85, 153, '0', 0, 0, 1628.3187255859375, 172.412841796875, -43.0912361145019531, 4.852017402648925781, 0, 0, -0.65605831146240234, 0.754710197448730468, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+4, 180405, 0, 14046, 0, '0', 0, 0, 1583.968017578125, 201.573516845703125, -34.8288192749023437, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: 0 - Difficulty: 0) +(@OGUID+5, 180405, 0, 85, 153, '0', 0, 0, 1565.1083984375, 214.7675323486328125, -34.8034477233886718, 1.832594871520996093, 0, 0, 0.793353080749511718, 0.608761727809906005, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+6, 180405, 0, 85, 153, '0', 0, 0, 1608, 227.7916717529296875, -29.0580043792724609, 1.169368624687194824, 0, 0, 0.551936149597167968, 0.833886384963989257, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+7, 180405, 0, 85, 153, '0', 0, 0, 1626.0599365234375, 214.751922607421875, -34.8047943115234375, 5.201082706451416015, 0, 0, -0.51503753662109375, 0.857167601585388183, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+8, 180405, 0, 85, 153, '0', 0, 0, 1649.0904541015625, 216.2608184814453125, -43.1031837463378906, 4.433136463165283203, 0, 0, -0.79863548278808593, 0.60181504487991333, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+9, 180405, 0, 85, 153, '0', 0, 0, 1589.8896484375, 246.0355377197265625, 60.10080337524414062, 1.204277276992797851, 0, 0, 0.56640625, 0.824126183986663818, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+10, 180405, 0, 85, 153, '0', 0, 0, 1583.404541015625, 252.8246612548828125, -29.1276454925537109, 4.380776405334472656, 0, 0, -0.81411552429199218, 0.580702960491180419, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+11, 180405, 0, 85, 153, '0', 0, 0, 1634.56689453125, 252.314697265625, -34.7899818420410156, 4.642575740814208984, 0, 0, -0.731353759765625, 0.681998312473297119, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+12, 180405, 0, 85, 153, '0', 0, 0, 1565.489990234375, 266.373992919921875, -34.8027000427246093, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+13, 180405, 0, 85, 153, '0', 0, 0, 1560.9559326171875, 259.985687255859375, -34.8058662414550781, 0.436331570148468017, 0, 0, 0.216439247131347656, 0.976296067237854003, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+14, 180405, 0, 85, 153, '0', 0, 0, 1520.1422119140625, 243.825408935546875, -41.3898773193359375, 1.151916384696960449, 0, 0, 0.544638633728027343, 0.838670849800109863, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+15, 180405, 0, 85, 153, '0', 0, 0, 1552.1600341796875, 257.957000732421875, -42.3670997619628906, 1.640606880187988281, 0, 0, 0.731352806091308593, 0.6819993257522583, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+16, 180405, 0, 85, 153, '0', 0, 0, 1584.4544677734375, 279.161529541015625, -34.8301467895507812, 6.03883981704711914, 0, 0, -0.12186908721923828, 0.9925462007522583, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+17, 180405, 0, 85, 153, '0', 0, 0, 1621.0269775390625, 271.11187744140625, -34.8236274719238281, 0.523597896099090576, 0, 0, 0.258818626403808593, 0.965925931930541992, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+18, 180405, 0, 85, 153, '0', 0, 0, 1644.8897705078125, 261.73699951171875, -43.103118896484375, 5.567600727081298828, 0, 0, -0.35020732879638671, 0.936672210693359375, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+19, 180406, 0, 14046, 14046, '0', 0, 0, 1847.282958984375, 216.90625, 60.46810531616210937, 5.061456203460693359, 0, 0, -0.57357597351074218, 0.819152355194091796, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+20, 180406, 0, 14046, 14046, '0', 0, 0, 1793.0103759765625, 250.045135498046875, 59.73082733154296875, 3.933400154113769531, 0, 0, -0.92264842987060546, 0.385642111301422119, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+21, 180406, 0, 14046, 14046, '0', 0, 0, 1822.6788330078125, 229.2274322509765625, 60.28553009033203125, 1.169368624687194824, 0, 0, 0.551936149597167968, 0.833886384963989257, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+22, 180406, 0, 14046, 14046, '0', 0, 0, 1818.16845703125, 250.265625, 60.01464080810546875, 2.422221183776855468, 0, 0, 0.936007499694824218, 0.351980090141296386, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+23, 180406, 0, 14046, 14046, '0', 0, 0, 1836.25, 211.7569427490234375, 60.5699615478515625, 4.206246376037597656, 0, 0, -0.86162853240966796, 0.50753939151763916, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+24, 180406, 0, 14046, 0, '0', 0, 0, 1570.4771728515625, 209.51373291015625, -34.8258514404296875, 3.595378875732421875, 0, 0, -0.97437000274658203, 0.224951311945915222, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: 0 - Difficulty: 0) +(@OGUID+25, 180406, 0, 14046, 0, '0', 0, 0, 1606.85400390625, 201.3957061767578125, -34.8287277221679687, 3.054326534271240234, 0, 0, 0.999048233032226562, 0.043619260191917419, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: 0 - Difficulty: 0) +(@OGUID+26, 180406, 0, 85, 153, '0', 0, 0, 1583.1944580078125, 228.0069427490234375, -29.064279556274414, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+27, 180406, 0, 85, 153, '0', 0, 0, 1637.0924072265625, 203.1681060791015625, -39.8801727294921875, 4.764749526977539062, 0, 0, -0.6883544921875, 0.725374460220336914, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+28, 180406, 0, 85, 153, '0', 0, 0, 1620.476806640625, 208.920684814453125, -34.8198966979980468, 3.403396368026733398, 0, 0, -0.99144458770751953, 0.130528271198272705, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+29, 180406, 0, 85, 153, '0', 0, 0, 1634.6728515625, 228.0672454833984375, -43.1026763916015625, 5.550147056579589843, 0, 0, -0.358367919921875, 0.933580458164215087, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+30, 180406, 0, 85, 153, '0', 0, 0, 1608.217041015625, 252.59722900390625, -29.096527099609375, 2.687806606292724609, 0, 0, 0.974370002746582031, 0.224951311945915222, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+31, 180406, 0, 85, 153, '0', 0, 0, 1556.8779296875, 228.18414306640625, -34.7916717529296875, 1.431168079376220703, 0, 0, 0.656058311462402343, 0.754710197448730468, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+32, 180406, 0, 85, 153, '0', 0, 0, 1528.061767578125, 206.5446319580078125, -43.0566902160644531, 3.176533222198486328, 0, 0, -0.999847412109375, 0.017469281330704689, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+33, 180406, 0, 85, 153, '0', 0, 0, 1557.234619140625, 252.9652557373046875, -34.7952766418457031, 2.216565132141113281, 0, 0, 0.894933700561523437, 0.44619917869567871, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+34, 180406, 0, 85, 153, '0', 0, 0, 1599.2099609375, 316.441009521484375, -41.4244003295898437, 5.916667938232421875, 0, 0, -0.18223476409912109, 0.98325502872467041, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+35, 180406, 0, 85, 153, '0', 0, 0, 1577.3360595703125, 275.89642333984375, -34.8360633850097656, 1.640606880187988281, 0, 0, 0.731352806091308593, 0.6819993257522583, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+36, 180406, 0, 85, 153, '0', 0, 0, 1595.969970703125, 279.402008056640625, -55.3428993225097656, 0.418878614902496337, 0, 0, 0.207911491394042968, 0.978147625923156738, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+37, 180406, 0, 85, 153, '0', 0, 0, 1614.7266845703125, 275.667694091796875, -34.8357963562011718, 5.305802345275878906, 0, 0, -0.46947097778320312, 0.882947921752929687, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+38, 180406, 0, 1497, 0, '0', 0, 0, 1630.687744140625, 259.74481201171875, -34.8042488098144531, 0.139624491333961486, 0, 0, 0.06975555419921875, 0.997564136981964111, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: 0 - Difficulty: 0) +(@OGUID+39, 180407, 0, 14046, 14046, '0', 0, 0, 1835.30908203125, 210.984375, 62.27329635620117187, 4.258606910705566406, 0, 0, -0.84804725646972656, 0.529920578002929687, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+40, 180407, 0, 14046, 14046, '0', 0, 0, 1847.2882080078125, 218.0086822509765625, 62.10429000854492187, 4.9218292236328125, 0, 0, -0.62932014465332031, 0.77714616060256958, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+41, 180407, 0, 85, 153, '0', 0, 0, 1592.18994140625, 164.1150054931640625, -41.4244003295898437, 2.757613182067871093, 0, 0, 0.981626510620117187, 0.190812408924102783, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+42, 180407, 0, 14046, 0, '0', 0, 0, 1614.2052001953125, 204.8680267333984375, -34.8363800048828125, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: 0 - Difficulty: 0) +(@OGUID+43, 180407, 0, 14046, 0, '0', 0, 0, 1574.81298828125, 201.274871826171875, -43.1024360656738281, 2.652894020080566406, 0, 0, 0.970294952392578125, 0.241925001144409179, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: 0 - Difficulty: 0) +(@OGUID+44, 180407, 0, 14046, 0, '0', 0, 0, 1576.7606201171875, 205.0225677490234375, -34.8363533020019531, 2.199114561080932617, 0, 0, 0.8910064697265625, 0.453990638256072998, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: 0 - Difficulty: 0) +(@OGUID+45, 180407, 0, 14046, 0, '0', 0, 0, 1605.0799560546875, 201.4420013427734375, -53.711700439453125, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: 0 - Difficulty: 0) +(@OGUID+46, 180407, 0, 85, 153, '0', 0, 0, 1630.65283203125, 220.042266845703125, -34.8873977661132812, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+47, 180407, 0, 85, 153, '0', 0, 0, 1560.5902099609375, 221.10943603515625, -34.8046150207519531, 3.368495941162109375, 0, 0, -0.99357128143310546, 0.113208353519439697, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+48, 180407, 0, 85, 153, '0', 0, 0, 1589.9556884765625, 234.6583404541015625, 60.0869140625, 2.67034769058227539, 0, 0, 0.972369194030761718, 0.233448356389999389, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+49, 180407, 0, 85, 153, '0', 0, 0, 1634.9110107421875, 227.9540557861328125, -34.8457260131835937, 5.148722648620605468, 0, 0, -0.53729915618896484, 0.843391716480255126, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+50, 180407, 0, 85, 153, '0', 0, 0, 1597.55908203125, 242.138885498046875, -6.65454912185668945, 2.70525527000427246, 0, 0, 0.97629547119140625, 0.216442063450813293, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+51, 180407, 0, 85, 153, '0', 0, 0, 1593.82470703125, 238.4600677490234375, -6.75038719177246093, 5.84685373306274414, 0, 0, -0.21643924713134765, 0.976296067237854003, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+52, 180407, 0, 85, 153, '0', 0, 0, 1593.8680419921875, 242.171875, -6.67416906356811523, 4.293513298034667968, 0, 0, -0.8386697769165039, 0.544640243053436279, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+53, 180407, 0, 85, 153, '0', 0, 0, 1597.53125, 238.4479217529296875, -6.70423603057861328, 1.169368624687194824, 0, 0, 0.551936149597167968, 0.833886384963989257, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+54, 180407, 0, 85, 153, '0', 0, 0, 1570.8900146484375, 271.516998291015625, -34.8237991333007812, 0.226892471313476562, 0, 0, 0.113203048706054687, 0.993571877479553222, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+55, 180407, 0, 85, 153, '0', 0, 0, 1563, 308.404998779296875, -43.0912017822265625, 1.640606880187988281, 0, 0, 0.731352806091308593, 0.6819993257522583, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+56, 180407, 0, 14046, 0, '0', 0, 0, 1607.5592041015625, 278.910247802734375, -34.8317756652832031, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: 0 - Difficulty: 0) +(@OGUID+57, 180407, 0, 85, 153, '0', 0, 0, 1626.27978515625, 265.87213134765625, -34.8035545349121093, 4.97418975830078125, 0, 0, -0.60876083374023437, 0.793353796005249023, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+58, 180408, 0, 85, 153, '0', 0, 0, 1643.61767578125, 223.363037109375, -38.3810615539550781, 3.735006093978881835, 0, 0, -0.95630455017089843, 0.292372345924377441, 120, 255, 1, 45745), -- G_WitchHat_01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+59, 180409, 0, 85, 153, '0', 0, 0, 1640.760009765625, 223.3173065185546875, -43.1032600402832031, 6.161012649536132812, 0, 0, -0.06104850769042968, 0.998134791851043701, 120, 255, 1, 45745), -- G_WitchBroom_01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+60, 180410, 0, 14046, 0, '0', 0, 0, 1560.32470703125, 200.0553741455078125, -41.0121536254882812, 2.426007747650146484, 0, 0, 0.936672210693359375, 0.350207358598709106, 120, 255, 1, 45745), -- G_HangingSkeleton_01 (Area: 0 - Difficulty: 0) +(@OGUID+61, 180410, 0, 85, 153, '0', 0, 0, 1643.4798583984375, 223.043731689453125, -41.6657752990722656, 4.555310726165771484, 0, 0, -0.76040554046630859, 0.649448513984680175, 120, 255, 1, 45745), -- G_HangingSkeleton_01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+62, 180411, 0, 85, 153, '0', 0, 0, 1633.028076171875, 224.2049713134765625, -34.1373939514160156, 5.93412017822265625, 0, 0, -0.17364788055419921, 0.984807789325714111, 120, 255, 1, 45745), -- G_Ghost_01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+63, 180411, 0, 85, 153, '0', 0, 0, 1565.699951171875, 271.37298583984375, -32.0598983764648437, 2.146752834320068359, 0, 0, 0.878816604614257812, 0.477159708738327026, 120, 255, 1, 45745), -- G_Ghost_01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+64, 180412, 0, 14046, 14046, '0', 0, 0, 1839.8177490234375, 217.6319427490234375, 60.10001754760742187, 4.328419685363769531, 0, 0, -0.82903671264648437, 0.559194147586822509, 120, 255, 1, 45745), -- G_CandyBucket_01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+65, 180412, 0, 14046, 14046, '0', 0, 0, 1837.8975830078125, 216.204864501953125, 60.09865951538085937, 3.577930212020874023, 0, 0, -0.97629547119140625, 0.216442063450813293, 120, 255, 1, 45745), -- G_CandyBucket_01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+66, 180412, 0, 14046, 14046, '0', 0, 0, 1838.1336669921875, 213.861114501953125, 60.22890090942382812, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 45745), -- G_CandyBucket_01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+67, 180414, 0, 14046, 14046, '0', 0, 0, 1827.751708984375, 210.876739501953125, 60.27971267700195312, 0, 0, 0, 0, 1, 120, 255, 1, 45745), -- Cauldron (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+68, 180415, 0, 14046, 14046, '0', 0, 0, 1828.8211669921875, 212.189239501953125, 60.37230682373046875, 0, 0, 0, 0, 1, 120, 255, 1, 45745), -- CandleBlack01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+69, 180415, 0, 14046, 14046, '0', 0, 0, 1828.6632080078125, 209.1336822509765625, 60.14522171020507812, 0, 0, 0, 0, 1, 120, 255, 1, 45745), -- CandleBlack01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+70, 180415, 0, 14046, 14046, '0', 0, 0, 1829.6771240234375, 210.6805572509765625, 60.26622772216796875, 0, 0, 0, 0, 1, 120, 255, 1, 45745), -- CandleBlack01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+71, 180415, 0, 14046, 14046, '0', 0, 0, 1826.7552490234375, 211.7777862548828125, 60.28120803833007812, 0, 0, 0, 0, 1, 120, 255, 1, 45745), -- CandleBlack01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+72, 180415, 0, 14046, 14046, '0', 0, 0, 1826.982666015625, 209.7309112548828125, 60.19806671142578125, 0, 0, 0, 0, 1, 120, 255, 1, 45745), -- CandleBlack01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+73, 180415, 0, 14046, 0, '0', 0, 0, 1567.814208984375, 205.9461822509765625, -41.699798583984375, 4.415683269500732421, 0, 0, -0.80385684967041015, 0.594822824001312255, 120, 255, 1, 45745), -- CandleBlack01 (Area: 0 - Difficulty: 0) +(@OGUID+74, 180415, 0, 85, 153, '0', 0, 0, 1635.25732421875, 218.1834869384765625, -41.85992431640625, 3.752462387084960937, 0, 0, -0.95371627807617187, 0.300707906484603881, 120, 255, 1, 45745), -- CandleBlack01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+75, 180415, 0, 85, 153, '0', 0, 0, 1650.33349609375, 218.2913665771484375, -41.20745849609375, 5.096362113952636718, 0, 0, -0.55919265747070312, 0.829037725925445556, 120, 255, 1, 45745), -- CandleBlack01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+76, 180415, 0, 14046, 0, '0', 0, 0, 1617.373291015625, 294.527374267578125, -42.0468521118164062, 5.916667938232421875, 0, 0, -0.18223476409912109, 0.98325502872467041, 120, 255, 1, 45745), -- CandleBlack01 (Area: 0 - Difficulty: 0) +(@OGUID+77, 180415, 0, 14046, 0, '0', 0, 0, 1615.943359375, 288.853668212890625, -42.3453712463378906, 3.22885894775390625, 0, 0, -0.99904823303222656, 0.043619260191917419, 120, 255, 1, 45745), -- CandleBlack01 (Area: 0 - Difficulty: 0) +(@OGUID+78, 180415, 0, 14046, 0, '0', 0, 0, 1616.799072265625, 288.283416748046875, -42.3592872619628906, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 45745), -- CandleBlack01 (Area: 0 - Difficulty: 0) +(@OGUID+79, 180425, 0, 14046, 0, '0', 0, 0, 1591.554931640625, 206.648651123046875, -54.2179603576660156, 0.802850961685180664, 0, 0, 0.390730857849121093, 0.920504987239837646, 120, 255, 1, 45745), -- SkullCandle01 (Area: 0 - Difficulty: 0) +(@OGUID+80, 180425, 0, 14046, 0, '0', 0, 0, 1567.515625, 206.1510467529296875, -41.5122756958007812, 1.274088263511657714, 0, 0, 0.594821929931640625, 0.80385744571685791, 120, 255, 1, 45745), -- SkullCandle01 (Area: 0 - Difficulty: 0) +(@OGUID+81, 180425, 0, 85, 153, '0', 0, 0, 1636.5989990234375, 218.00347900390625, -41.8460273742675781, 2.042035102844238281, 0, 0, 0.852640151977539062, 0.522498607635498046, 120, 255, 1, 45745), -- SkullCandle01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+82, 180425, 0, 14046, 0, '0', 0, 0, 1620.4453125, 291.464752197265625, -42.2896995544433593, 3.351046562194824218, 0, 0, -0.99452114105224609, 0.104535527527332305, 120, 255, 1, 45745), -- SkullCandle01 (Area: 0 - Difficulty: 0) +(@OGUID+83, 180425, 0, 14046, 0, '0', 0, 0, 1616.4090576171875, 288.450286865234375, -42.2828903198242187, 4.084071159362792968, 0, 0, -0.8910064697265625, 0.453990638256072998, 120, 255, 1, 45745), -- SkullCandle01 (Area: 0 - Difficulty: 0) +(@OGUID+84, 180426, 0, 14046, 14046, '0', 0, 0, 1774.342041015625, 201.9947967529296875, 72.77500152587890625, 2.391098499298095703, 0, 0, 0.930417060852050781, 0.366502493619918823, 120, 255, 1, 45745), -- Bat01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+85, 180426, 0, 14046, 14046, '0', 0, 0, 1781.2916259765625, 212.5555572509765625, 59.86441421508789062, 2.600535154342651367, 0, 0, 0.963629722595214843, 0.26724100112915039, 120, 255, 1, 45745), -- Bat01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+86, 180426, 0, 14046, 14046, '0', 0, 0, 1791.49658203125, 214.92535400390625, 60.00310516357421875, 0.855210542678833007, 0, 0, 0.414692878723144531, 0.909961462020874023, 120, 255, 1, 45745), -- Bat01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+87, 180426, 0, 14046, 14046, '0', 0, 0, 1775.27783203125, 219.701385498046875, 59.5826416015625, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 120, 255, 1, 45745), -- Bat01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+88, 180426, 0, 14046, 14046, '0', 0, 0, 1764.998291015625, 200.48785400390625, 70.87223052978515625, 5.619962215423583984, 0, 0, -0.32556724548339843, 0.945518851280212402, 120, 255, 1, 45745), -- Bat01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+89, 180426, 0, 14046, 14046, '0', 0, 0, 1790.407958984375, 200.5225677490234375, 70.87223052978515625, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 45745), -- Bat01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+90, 180426, 0, 14046, 14046, '0', 0, 0, 1782.0069580078125, 212.6822967529296875, 59.8203887939453125, 5.550147056579589843, 0, 0, -0.358367919921875, 0.933580458164215087, 120, 255, 1, 45745), -- Bat01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+91, 180426, 0, 14046, 14046, '0', 0, 0, 1779.1353759765625, 204.4635467529296875, 59.9626007080078125, 3.001946926116943359, 0, 0, 0.997563362121582031, 0.069766148924827575, 120, 255, 1, 45745), -- Bat01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+92, 180426, 0, 14046, 14046, '0', 0, 0, 1779.2586669921875, 212.8645782470703125, 59.878662109375, 5.026549339294433593, 0, 0, -0.5877847671508789, 0.809017360210418701, 120, 255, 1, 45745), -- Bat01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+93, 180426, 0, 14046, 14046, '0', 0, 0, 1783.32470703125, 199.6527862548828125, 70.87223052978515625, 0.663223206996917724, 0, 0, 0.325567245483398437, 0.945518851280212402, 120, 255, 1, 45745), -- Bat01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+94, 180427, 0, 14046, 14046, '0', 0, 0, 1780.001708984375, 210.6822967529296875, 59.9851837158203125, 1.134462952613830566, 0, 0, 0.537299156188964843, 0.843391716480255126, 120, 255, 1, 45745), -- Bat02 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+95, 180427, 0, 14046, 14046, '0', 0, 0, 1794.826416015625, 218.33160400390625, 60.02405548095703125, 2.740161895751953125, 0, 0, 0.979924201965332031, 0.199370384216308593, 120, 255, 1, 45745), -- Bat02 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+96, 180427, 0, 14046, 14046, '0', 0, 0, 1784.3004150390625, 218.8836822509765625, 59.75374984741210937, 3.036838293075561523, 0, 0, 0.998628616333007812, 0.052353221923112869, 120, 255, 1, 45745), -- Bat02 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+97, 180427, 0, 14046, 14046, '0', 0, 0, 1772.8038330078125, 203.62847900390625, 60.39958953857421875, 3.385940074920654296, 0, 0, -0.99254608154296875, 0.121869951486587524, 120, 255, 1, 45745), -- Bat02 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+98, 180427, 0, 14046, 14046, '0', 0, 0, 1787.704833984375, 231.9479217529296875, 59.98978805541992187, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 45745), -- Bat02 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+99, 180427, 0, 14046, 14046, '0', 0, 0, 1776.6197509765625, 220.11285400390625, 59.5583648681640625, 4.660029888153076171, 0, 0, -0.72537422180175781, 0.688354730606079101, 120, 255, 1, 45745), -- Bat02 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+100, 180427, 0, 14046, 14046, '0', 0, 0, 1791.2847900390625, 215.6475677490234375, 59.9879302978515625, 1.117009282112121582, 0, 0, 0.529918670654296875, 0.84804844856262207, 120, 255, 1, 45745), -- Bat02 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+101, 180427, 0, 14046, 14046, '0', 0, 0, 1778.87158203125, 224.1788177490234375, 59.51313018798828125, 5.078907966613769531, 0, 0, -0.56640625, 0.824126183986663818, 120, 255, 1, 45745), -- Bat02 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+102, 180427, 0, 14046, 14046, '0', 0, 0, 1785.7691650390625, 219.9010467529296875, 59.74382781982421875, 5.969027042388916015, 0, 0, -0.1564340591430664, 0.987688362598419189, 120, 255, 1, 45745), -- Bat02 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+103, 180427, 0, 14046, 14046, '0', 0, 0, 1788.2430419921875, 212.7864532470703125, 59.84340286254882812, 2.111847877502441406, 0, 0, 0.870355606079101562, 0.492423713207244873, 120, 255, 1, 45745), -- Bat02 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+104, 180427, 0, 85, 153, '0', 0, 0, 1597.91845703125, 237.5121612548828125, -42.8651580810546875, 2.460912704467773437, 0, 0, 0.942641258239746093, 0.333807557821273803, 120, 255, 1, 45745), -- Bat02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+105, 180427, 0, 85, 153, '0', 0, 0, 1594.7222900390625, 240.59722900390625, -40.9484672546386718, 5.270895957946777343, 0, 0, -0.48480892181396484, 0.87462007999420166, 120, 255, 1, 45745), -- Bat02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+106, 180427, 0, 85, 153, '0', 0, 0, 1595.9896240234375, 237.5277862548828125, -42.4693222045898437, 5.811946868896484375, 0, 0, -0.2334451675415039, 0.972369968891143798, 120, 255, 1, 45745), -- Bat02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+107, 180427, 0, 85, 153, '0', 0, 0, 1595.5382080078125, 236.8958282470703125, -45.0109901428222656, 3.054326534271240234, 0, 0, 0.999048233032226562, 0.043619260191917419, 120, 255, 1, 45745), -- Bat02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+108, 180427, 0, 85, 153, '0', 0, 0, 1595.6927490234375, 240.498260498046875, -48.3859710693359375, 2.303830623626708984, 0, 0, 0.913544654846191406, 0.406738430261611938, 120, 255, 1, 45745), -- Bat02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+109, 180427, 0, 85, 153, '0', 0, 0, 1596.8072509765625, 240.7100677490234375, -50.3026618957519531, 3.263772249221801757, 0, 0, -0.99813461303710937, 0.061051756143569946, 120, 255, 1, 45745), -- Bat02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+110, 180427, 0, 85, 153, '0', 0, 0, 1595.095458984375, 239.0104217529296875, -46.3859748840332031, 3.385940074920654296, 0, 0, -0.99254608154296875, 0.121869951486587524, 120, 255, 1, 45745), -- Bat02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+111, 180427, 0, 85, 153, '0', 0, 0, 1596.1336669921875, 239.4791717529296875, -49.7818260192871093, 1.989672422409057617, 0, 0, 0.838669776916503906, 0.544640243053436279, 120, 255, 1, 45745), -- Bat02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+112, 180427, 0, 85, 153, '0', 0, 0, 1595.5521240234375, 243.58160400390625, -45.6984672546386718, 4.293513298034667968, 0, 0, -0.8386697769165039, 0.544640243053436279, 120, 255, 1, 45745), -- Bat02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+113, 180427, 0, 85, 153, '0', 0, 0, 1594.40283203125, 241.4027862548828125, -50.3234672546386718, 5.235987663269042968, 0, 0, -0.5, 0.866025388240814208, 120, 255, 1, 45745), -- Bat02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+114, 180427, 0, 85, 153, '0', 0, 0, 1596.107666015625, 240.48785400390625, -51.6915473937988281, 4.206246376037597656, 0, 0, -0.86162853240966796, 0.50753939151763916, 120, 255, 1, 45745), -- Bat02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+115, 180427, 0, 85, 153, '0', 0, 0, 1593.5069580078125, 242.2899322509765625, -41.5179023742675781, 5.916667938232421875, 0, 0, -0.18223476409912109, 0.98325502872467041, 120, 255, 1, 45745), -- Bat02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+116, 180427, 0, 85, 153, '0', 0, 0, 1597.69970703125, 242.079864501953125, -48.4415321350097656, 5.70722818374633789, 0, 0, -0.28401470184326171, 0.958819925785064697, 120, 255, 1, 45745), -- Bat02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+117, 180427, 0, 85, 153, '0', 0, 0, 1596.3072509765625, 240.095489501953125, -45.8790359497070312, 2.72271275520324707, 0, 0, 0.978147506713867187, 0.207912087440490722, 120, 255, 1, 45745), -- Bat02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+118, 180427, 0, 85, 153, '0', 0, 0, 1597.4774169921875, 240.140625, -44.6915359497070312, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 120, 255, 1, 45745), -- Bat02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+119, 180427, 0, 85, 153, '0', 0, 0, 1596.3062744140625, 239.9547882080078125, -52.1429176330566406, 4.118979454040527343, 0, 0, -0.88294696807861328, 0.469472706317901611, 120, 255, 1, 45745), -- Bat02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+120, 180427, 0, 85, 153, '0', 0, 0, 1593.23095703125, 238.40625, -45.0040359497070312, 5.253442287445068359, 0, 0, -0.49242305755615234, 0.870355963706970214, 120, 255, 1, 45745), -- Bat02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+121, 180427, 0, 85, 153, '0', 0, 0, 1596.2257080078125, 240.7777862548828125, -49.7054176330566406, 1.762782454490661621, 0, 0, 0.771624565124511718, 0.636078238487243652, 120, 255, 1, 45745), -- Bat02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+122, 180427, 0, 85, 153, '0', 0, 0, 1597.46533203125, 241.7621612548828125, -47.0526466369628906, 4.328419685363769531, 0, 0, -0.82903671264648437, 0.559194147586822509, 120, 255, 1, 45745), -- Bat02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+123, 180427, 0, 85, 153, '0', 0, 0, 1592.59033203125, 240.157989501953125, -47.3998527526855468, 4.869470596313476562, 0, 0, -0.64944744110107421, 0.760406434535980224, 120, 255, 1, 45745), -- Bat02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+124, 180428, 0, 14046, 14046, '0', 0, 0, 1818.6353759765625, 228.3506927490234375, 59.62416458129882812, 0, 0, 0, 0, 1, 120, 255, 1, 45745), -- G_WitchBroom_01 scale 0.5 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+125, 180431, 0, 14046, 14046, '0', 0, 0, 1642.021240234375, 239.8374786376953125, 62.59157180786132812, 1.972219824790954589, 0, 0, 0.83388519287109375, 0.55193793773651123, 120, 255, 1, 45745), -- G_Pumpkin_01 scale 4.0 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+126, 180432, 0, 14046, 14046, '0', 0, 0, 1816.2535400390625, 207.5225677490234375, 57.33654022216796875, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 45745), -- Forsaken Banner (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+127, 180432, 0, 14046, 14046, '0', 0, 0, 1793.5347900390625, 207.6996612548828125, 57.36068344116210937, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 120, 255, 1, 45745), -- Forsaken Banner (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+128, 180432, 0, 14046, 14046, '0', 0, 0, 1810.9114990234375, 199.4947967529296875, 69.08628082275390625, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 45745), -- Forsaken Banner (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+129, 180432, 0, 14046, 14046, '0', 0, 0, 1799.326416015625, 199.6197967529296875, 69.0862579345703125, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 45745), -- Forsaken Banner (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+130, 180433, 0, 14046, 14046, '0', 0, 0, 1782.6614990234375, 214.126739501953125, 59.79413604736328125, 0.942476630210876464, 0, 0, 0.453989982604980468, 0.891006767749786376, 120, 255, 1, 45745), -- The Wickerman (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+131, 180434, 0, 14046, 14046, '0', 0, 0, 1827.4566650390625, 254.2586822509765625, 59.79866409301757812, 5.654868602752685546, 0, 0, -0.30901622772216796, 0.95105677843093872, 120, 255, 1, 45745), -- Bonfire (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+132, 180434, 0, 14046, 14046, '0', 0, 0, 1785.26220703125, 257.182281494140625, 59.50574493408203125, 0.191985160112380981, 0, 0, 0.095845222473144531, 0.995396256446838378, 120, 255, 1, 45745), -- Bonfire (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+133, 180434, 0, 85, 153, '0', 0, 0, 1759.492431640625, 515.94879150390625, 35.30905914306640625, 5.253442287445068359, 0, 0, -0.49242305755615234, 0.870355963706970214, 120, 255, 1, 45745), -- Bonfire (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+134, 180437, 0, 14046, 14046, '0', 0, 0, 1784.640625, 220.1319427490234375, 59.73944091796875, 3.612837791442871093, 0, 0, -0.97236919403076171, 0.233448356389999389, 120, 255, 1, 45745), -- Wickerman Ashes (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+135, 180437, 0, 14046, 14046, '0', 0, 0, 1782.44970703125, 224.8559112548828125, 59.36582565307617187, 4.066620349884033203, 0, 0, -0.89493370056152343, 0.44619917869567871, 120, 255, 1, 45745), -- Wickerman Ashes (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+136, 180437, 0, 14046, 14046, '0', 0, 0, 1778.02783203125, 226.109375, 59.52318572998046875, 4.817109584808349609, 0, 0, -0.66913032531738281, 0.74314504861831665, 120, 255, 1, 45745), -- Wickerman Ashes (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+137, 180437, 0, 14046, 14046, '0', 0, 0, 1773.592041015625, 225.2916717529296875, 59.67877197265625, 4.817109584808349609, 0, 0, -0.66913032531738281, 0.74314504861831665, 120, 255, 1, 45745), -- Wickerman Ashes (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+138, 180437, 0, 14046, 14046, '0', 0, 0, 1790.27783203125, 217.7291717529296875, 59.93278121948242187, 5.602506637573242187, 0, 0, -0.33380699157714843, 0.942641437053680419, 120, 255, 1, 45745), -- Wickerman Ashes (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+139, 180437, 0, 14046, 14046, '0', 0, 0, 1785.126708984375, 216.56597900390625, 59.7205352783203125, 3.717553615570068359, 0, 0, -0.95881938934326171, 0.284016460180282592, 120, 255, 1, 45745), -- Wickerman Ashes (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+140, 180437, 0, 14046, 14046, '0', 0, 0, 1790.0191650390625, 209.15972900390625, 59.9146728515625, 3.752462387084960937, 0, 0, -0.95371627807617187, 0.300707906484603881, 120, 255, 1, 45745), -- Wickerman Ashes (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+141, 180437, 0, 14046, 14046, '0', 0, 0, 1789.15283203125, 213.2465362548828125, 59.89113235473632812, 4.817109584808349609, 0, 0, -0.66913032531738281, 0.74314504861831665, 120, 255, 1, 45745), -- Wickerman Ashes (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+142, 180437, 0, 14046, 14046, '0', 0, 0, 1780.701416015625, 221.9184112548828125, 59.62030792236328125, 4.817109584808349609, 0, 0, -0.66913032531738281, 0.74314504861831665, 120, 255, 1, 45745), -- Wickerman Ashes (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+143, 180471, 0, 14046, 0, '0', 0, 0, 1577.6129150390625, 205.204864501953125, -36.9064521789550781, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: 0 - Difficulty: 0) +(@OGUID+144, 180471, 0, 14046, 0, '0', 0, 0, 1570.2239990234375, 210.3125, -36.9758987426757812, 3.52557229995727539, 0, 0, -0.98162651062011718, 0.190812408924102783, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: 0 - Difficulty: 0) +(@OGUID+145, 180471, 0, 14046, 0, '0', 0, 0, 1613.2257080078125, 204.89410400390625, -36.9133987426757812, 4.59021615982055664, 0, 0, -0.74895572662353515, 0.662620067596435546, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: 0 - Difficulty: 0) +(@OGUID+146, 180471, 0, 85, 153, '0', 0, 0, 1620.6978759765625, 209.94097900390625, -36.8022842407226562, 2.740161895751953125, 0, 0, 0.979924201965332031, 0.199370384216308593, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+147, 180471, 0, 85, 153, '0', 0, 0, 1633.489990234375, 227.1705780029296875, -36.95050048828125, 4.852017402648925781, 0, 0, -0.65605831146240234, 0.754710197448730468, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+148, 180471, 0, 85, 153, '0', 0, 0, 1587.642333984375, 232.3836822509765625, -56.6338157653808593, 5.410521507263183593, 0, 0, -0.42261791229248046, 0.906307935714721679, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+149, 180471, 0, 85, 153, '0', 0, 0, 1603.62158203125, 232.2309112548828125, -56.6963157653808593, 0.715584874153137207, 0, 0, 0.350207328796386718, 0.936672210693359375, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+150, 180471, 0, 14046, 0, '0', 0, 0, 1636.0867919921875, 235.4496612548828125, -36.9088325500488281, 3.351046562194824218, 0, 0, -0.99452114105224609, 0.104535527527332305, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: 0 - Difficulty: 0) +(@OGUID+151, 180471, 0, 14046, 0, '0', 0, 0, 1636.34375, 244.611114501953125, -36.9296684265136718, 5.70722818374633789, 0, 0, -0.28401470184326171, 0.958819925785064697, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: 0 - Difficulty: 0) +(@OGUID+152, 180471, 0, 85, 153, '0', 0, 0, 1557.6597900390625, 227.7916717529296875, -36.8602218627929687, 0.802850961685180664, 0, 0, 0.390730857849121093, 0.920504987239837646, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+153, 180471, 0, 85, 153, '0', 0, 0, 1603.128662109375, 240.336395263671875, -48.5862617492675781, 1.675513744354248046, 0, 0, 0.743144035339355468, 0.669131457805633544, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+154, 180471, 0, 85, 153, '0', 0, 0, 1588.71875, 240.34375, -48.8432083129882812, 4.660029888153076171, 0, 0, -0.72537422180175781, 0.688354730606079101, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+155, 180471, 0, 85, 153, '0', 0, 0, 1633.9288330078125, 252.671875, -36.88800048828125, 4.206246376037597656, 0, 0, -0.86162853240966796, 0.50753939151763916, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+156, 180471, 0, 85, 153, '0', 0, 0, 1587.736083984375, 248.4166717529296875, -56.6546173095703125, 3.892086982727050781, 0, 0, -0.93041706085205078, 0.366502493619918823, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+157, 180471, 0, 85, 153, '0', 0, 0, 1603.7691650390625, 248.2430572509765625, -56.682373046875, 2.268925428390502929, 0, 0, 0.906307220458984375, 0.422619491815567016, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+158, 180471, 0, 85, 153, '0', 0, 0, 1557.829833984375, 253.4322967529296875, -36.7838325500488281, 2.024578809738159179, 0, 0, 0.848047256469726562, 0.529920578002929687, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+159, 180471, 0, 85, 153, '0', 0, 0, 1570.68994140625, 270.759002685546875, -36.8717002868652343, 6.09120035171508789, 0, 0, -0.09584522247314453, 0.995396256446838378, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+160, 180471, 0, 85, 153, '0', 0, 0, 1592.673583984375, 273.842010498046875, -48.2894935607910156, 6.195919513702392578, 0, 0, -0.04361915588378906, 0.999048233032226562, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+161, 180471, 0, 85, 153, '0', 0, 0, 1578.048583984375, 275.73089599609375, -36.8578414916992187, 1.500982880592346191, 0, 0, 0.681998252868652343, 0.731353819370269775, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+162, 180471, 0, 85, 153, '0', 0, 0, 1636.220458984375, 274.520843505859375, -37.1635665893554687, 3.857182979583740234, 0, 0, -0.93667125701904296, 0.350209832191467285, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+163, 180471, 0, 85, 153, '0', 0, 0, 1636.9930419921875, 281.951385498046875, -37.1579170227050781, 5.410521507263183593, 0, 0, -0.42261791229248046, 0.906307935714721679, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+164, 180471, 0, 85, 153, '0', 0, 0, 1621.201416015625, 270.244781494140625, -36.9064521789550781, 0.191985160112380981, 0, 0, 0.095845222473144531, 0.995396256446838378, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+165, 180471, 0, 85, 153, '0', 0, 0, 1599.3472900390625, 273.69097900390625, -48.0918617248535156, 0.191985160112380981, 0, 0, 0.095845222473144531, 0.995396256446838378, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+166, 180471, 0, 85, 153, '0', 0, 0, 1629.7691650390625, 281.555572509765625, -37.33245849609375, 0.837757468223571777, 0, 0, 0.406736373901367187, 0.913545548915863037, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+167, 180471, 0, 85, 153, '0', 0, 0, 1613.8802490234375, 275.4375, -36.9203414916992187, 4.869470596313476562, 0, 0, -0.64944744110107421, 0.760406434535980224, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+168, 180472, 0, 14046, 0, '0', 0, 0, 1595.795166015625, 207.28125, -45.7957038879394531, 1.553341388702392578, 0, 0, 0.700908660888671875, 0.713251054286956787, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: 0 - Difficulty: 0) +(@OGUID+169, 180472, 0, 14046, 0, '0', 0, 0, 1583.4930419921875, 202.1145782470703125, -35.4792747497558593, 2.373644113540649414, 0, 0, 0.927183151245117187, 0.37460830807685852, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: 0 - Difficulty: 0) +(@OGUID+170, 180472, 0, 14046, 0, '0', 0, 0, 1607.3836669921875, 202.1614532470703125, -35.507049560546875, 1.029743075370788574, 0, 0, 0.492423057556152343, 0.870355963706970214, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: 0 - Difficulty: 0) +(@OGUID+171, 180472, 0, 85, 153, '0', 0, 0, 1630.3568115234375, 221.2655181884765625, -35.4991111755371093, 1.640606880187988281, 0, 0, 0.731352806091308593, 0.6819993257522583, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+172, 180472, 0, 85, 153, '0', 0, 0, 1560.734375, 221.8697967529296875, -35.4782791137695312, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+173, 180472, 0, 85, 153, '0', 0, 0, 1625.0833740234375, 214.170135498046875, -35.4435615539550781, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+174, 180472, 0, 85, 153, '0', 0, 0, 1565.9305419921875, 214.6527862548828125, -35.4852294921875, 6.021387100219726562, 0, 0, -0.13052558898925781, 0.991444945335388183, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+175, 180472, 0, 85, 153, '0', 0, 0, 1595.6754150390625, 233.138885498046875, -47.3432083129882812, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+176, 180472, 0, 85, 153, '0', 0, 0, 1595.7396240234375, 247.670135498046875, -47.34320068359375, 1.675513744354248046, 0, 0, 0.743144035339355468, 0.669131457805633544, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+177, 180472, 0, 85, 153, '0', 0, 0, 1566.489990234375, 266.5, -35.4782981872558593, 0.209439441561698913, 0, 0, 0.104528427124023437, 0.994521915912628173, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+178, 180472, 0, 85, 153, '0', 0, 0, 1561.0382080078125, 259.305572509765625, -35.4713325500488281, 4.764749526977539062, 0, 0, -0.6883544921875, 0.725374460220336914, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+179, 180472, 0, 85, 153, '0', 0, 0, 1584.111083984375, 278.579864501953125, -35.4862213134765625, 4.310965538024902343, 0, 0, -0.83388519287109375, 0.55193793773651123, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+180, 180472, 0, 14046, 0, '0', 0, 0, 1607.9757080078125, 278.263885498046875, -35.5209426879882812, 5.113816738128662109, 0, 0, -0.55193614959716796, 0.833886384963989257, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: 0 - Difficulty: 0) +(@OGUID+181, 180472, 0, 85, 153, '0', 0, 0, 1625.4427490234375, 266.02777099609375, -35.4852218627929687, 3.106652259826660156, 0, 0, 0.999847412109375, 0.017469281330704689, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+182, 180472, 0, 1497, 0, '0', 0, 0, 1630.701416015625, 258.836822509765625, -35.4782829284667968, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: 0 - Difficulty: 0) +(@OGUID+183, 180523, 0, 14046, 14046, '0', 0, 0, 1839.4617919921875, 220.8038177490234375, 60.17534255981445312, 4.520402908325195312, 0, 0, -0.77162456512451171, 0.636078238487243652, 120, 255, 1, 45745), -- Apple Bob (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+184, 180523, 0, 85, 153, '0', 0, 0, 1645.078125, 218.875, -42.7976036071777343, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 45745), -- Apple Bob (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+185, 190071, 0, 85, 153, '0', 0, 0, 1638.4921875, 223.1143341064453125, -43.1032218933105468, 5.061456203460693359, 0, 0, -0.57357597351074218, 0.819152355194091796, 120, 255, 1, 45745), -- Candy Bucket (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+186, 190217, 0, 14046, 14046, '0', 0, 0, 1840.4097900390625, 223.0555572509765625, 60.19789505004882812, 6.12610626220703125, 0, 0, -0.07845878601074218, 0.996917366981506347, 120, 255, 1, 45745), -- Forsaken Tent 04 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+187, 190217, 0, 14046, 14046, '0', 0, 0, 1842.060791015625, 216.2256927490234375, 60.18104934692382812, 5.89921426773071289, 0, 0, -0.19080829620361328, 0.981627285480499267, 120, 255, 1, 45745), -- Forsaken Tent 04 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+188, 208198, 0, 14046, 14046, '0', 0, 0, 1788.38720703125, 220.657989501953125, 59.7380523681640625, 3.368495941162109375, 0, 0, -0.99357128143310546, 0.113208353519439697, 120, 255, 1, 45745), -- Bonfire (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+189, 208200, 0, 14046, 14046, '0', 0, 0, 1758.357666015625, 159.59375, -62.24005126953125, 5.078907966613769531, 0, 0, -0.56640625, 0.824126183986663818, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+190, 208200, 0, 14046, 0, '0', 0, 0, 1741.8785400390625, 385.9600830078125, -62.2913818359375, 6.213373661041259765, 0, 0, -0.03489875793457031, 0.999390840530395507, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+191, 208200, 0, 14046, 0, '0', 0, 0, 1789.0555419921875, 99.30902862548828125, -59.3170356750488281, 2.199114561080932617, 0, 0, 0.8910064697265625, 0.453990638256072998, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+192, 208200, 0, 14046, 0, '0', 0, 0, 1704.6024169921875, 182.9444427490234375, -62.1829833984375, 0, 0, 0, 0, 1, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+193, 208200, 0, 14046, 0, '0', 0, 0, 1699.64453125, 232.611114501953125, -49.061370849609375, 0.051103435456752777, 0, 0, 0.025548934936523437, 0.99967360496520996, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+194, 208200, 0, 14046, 0, '0', 0, 0, 1747.5711669921875, 86.77777862548828125, -62.2694778442382812, 2.199114561080932617, 0, 0, 0.8910064697265625, 0.453990638256072998, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+195, 208200, 0, 85, 153, '0', 0, 0, 1725.15625, 35.65277862548828125, -62.2749519348144531, 2.199114561080932617, 0, 0, 0.8910064697265625, 0.453990638256072998, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+196, 208200, 0, 14046, 0, '0', 0, 0, 1599.546875, 60.05729293823242187, -62.1757087707519531, 0.977383077144622802, 0, 0, 0.469470977783203125, 0.882947921752929687, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+197, 208200, 0, 14046, 0, '0', 0, 0, 1592.65283203125, 119.6996536254882812, -62.1777000427246093, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+198, 208200, 0, 14046, 0, '0', 0, 0, 1536.1041259765625, 110.2378463745117187, -62.1772880554199218, 0.733038187026977539, 0, 0, 0.358367919921875, 0.933580458164215087, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+199, 208200, 0, 14046, 0, '0', 0, 0, 1507.5728759765625, 87.97222137451171875, -57.1533889770507812, 0.977383077144622802, 0, 0, 0.469470977783203125, 0.882947921752929687, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+200, 208200, 0, 85, 153, '0', 0, 0, 1523.5867919921875, 150.998260498046875, -62.1641921997070312, 0.733038187026977539, 0, 0, 0.358367919921875, 0.933580458164215087, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+201, 208200, 0, 14046, 0, '0', 0, 0, 1555.7535400390625, 206.013885498046875, -43.1021652221679687, 0, 0, 0, 0, 1, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+202, 208200, 0, 85, 153, '0', 0, 0, 1651.86767578125, 187.4478759765625, -62.1789627075195312, 3.8561859130859375, 0, 0, -0.93684577941894531, 0.349742770195007324, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+203, 208200, 0, 85, 153, '0', 0, 0, 1651.828125, 229.8559112548828125, -62.1777000427246093, 0.453785061836242675, 0, 0, 0.224950790405273437, 0.974370121955871582, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+204, 208200, 0, 85, 153, '0', 0, 0, 1583.4739990234375, 239.9027862548828125, -62.0773811340332031, 0, 0, 0, 0, 1, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+205, 208200, 0, 85, 153, '0', 0, 0, 1690.546875, 197.1215362548828125, -62.1770210266113281, 5.078907966613769531, 0, 0, -0.56640625, 0.824126183986663818, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+206, 208200, 0, 85, 153, '0', 0, 0, 1500.0347900390625, 195.6458282470703125, -62.1392135620117187, 4.014260292053222656, 0, 0, -0.90630722045898437, 0.422619491815567016, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+207, 208200, 0, 85, 153, '0', 0, 0, 1490.6944580078125, 157.185760498046875, -60.0903511047363281, 2.216565132141113281, 0, 0, 0.894933700561523437, 0.44619917869567871, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+208, 208200, 0, 85, 153, '0', 0, 0, 1398.0191650390625, 133.78125, -62.2960968017578125, 0.034906249493360519, 0, 0, 0.017452239990234375, 0.999847710132598876, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+209, 208200, 0, 85, 153, '0', 0, 0, 1490.845458984375, 52.9149322509765625, -62.296142578125, 0.977383077144622802, 0, 0, 0.469470977783203125, 0.882947921752929687, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+210, 208200, 0, 85, 153, '0', 0, 0, 1463.532958984375, 270.161468505859375, -62.1776885986328125, 4.48549652099609375, 0, 0, -0.7826080322265625, 0.622514784336090087, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+211, 208200, 0, 85, 153, '0', 0, 0, 1509.7882080078125, 281.942718505859375, -62.1716804504394531, 4.48549652099609375, 0, 0, -0.7826080322265625, 0.622514784336090087, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+212, 208200, 0, 85, 153, '0', 0, 0, 1464.9254150390625, 200.126739501953125, -62.1769752502441406, 4.014260292053222656, 0, 0, -0.90630722045898437, 0.422619491815567016, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+213, 208200, 0, 85, 153, '0', 0, 0, 1485.9166259765625, 309.12847900390625, -61.5094070434570312, 4.48549652099609375, 0, 0, -0.7826080322265625, 0.622514784336090087, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+214, 208200, 0, 85, 153, '0', 0, 0, 1420.920166015625, 296.368072509765625, -62.1826324462890625, 0.034906249493360519, 0, 0, 0.017452239990234375, 0.999847710132598876, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+215, 208200, 0, 85, 153, '0', 0, 0, 1439.1163330078125, 331.545135498046875, -62.2662239074707031, 2.617989301681518554, 0, 0, 0.965925216674804687, 0.258821308612823486, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+216, 208200, 0, 85, 153, '0', 0, 0, 1388.8941650390625, 340.244781494140625, -66.0161972045898437, 0.034906249493360519, 0, 0, 0.017452239990234375, 0.999847710132598876, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+217, 208200, 0, 85, 153, '0', 0, 0, 1521.99658203125, 319.524322509765625, -62.1329421997070312, 2.251473426818847656, 0, 0, 0.902585029602050781, 0.430511653423309326, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+218, 208200, 0, 85, 153, '0', 0, 0, 1493.4791259765625, 342.74652099609375, -61.1160354614257812, 4.48549652099609375, 0, 0, -0.7826080322265625, 0.622514784336090087, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+219, 208200, 0, 85, 153, '0', 0, 0, 1538.203125, 371.697906494140625, -62.2473907470703125, 2.251473426818847656, 0, 0, 0.902585029602050781, 0.430511653423309326, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+220, 208200, 0, 85, 153, '0', 0, 0, 1571.717041015625, 299.00347900390625, -43.0911445617675781, 0, 0, 0, 0, 1, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+221, 208200, 0, 85, 153, '0', 0, 0, 1490.2396240234375, 414.828125, -62.1852302551269531, 5.270895957946777343, 0, 0, -0.48480892181396484, 0.87462007999420166, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+222, 208200, 0, 85, 153, '0', 0, 0, 1608.5086669921875, 301.6788330078125, -62.1776885986328125, 6.003933906555175781, 0, 0, -0.13917255401611328, 0.990268170833587646, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+223, 208200, 0, 14046, 0, '0', 0, 0, 1638.7257080078125, 419.86285400390625, -62.1767387390136718, 4.049167633056640625, 0, 0, -0.89879322052001953, 0.438372820615768432, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+224, 208200, 0, 14046, 0, '0', 0, 0, 1641.3853759765625, 287.84375, -62.1836357116699218, 2.164205789566040039, 0, 0, 0.882946968078613281, 0.469472706317901611, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+225, 208200, 0, 1497, 0, '0', 0, 0, 1641.092041015625, 333.7100830078125, -62.1859130859375, 2.251473426818847656, 0, 0, 0.902585029602050781, 0.430511653423309326, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+226, 208200, 0, 1497, 0, '0', 0, 0, 1391.73095703125, 377.2569580078125, -66.0236663818359375, 5.131268978118896484, 0, 0, -0.54463863372802734, 0.838670849800109863, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+227, 208200, 0, 1497, 0, '0', 0, 0, 1531.0069580078125, 212.7552032470703125, -43.0565948486328125, 0, 0, 0, 0, 1, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+228, 208200, 0, 1497, 0, '0', 0, 0, 1557.217041015625, 183.6944427490234375, -62.1776008605957031, 6.003933906555175781, 0, 0, -0.13917255401611328, 0.990268170833587646, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+229, 208200, 0, 1497, 0, '0', 0, 0, 1668.032958984375, 208.6145782470703125, -62.1776885986328125, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+230, 208200, 0, 1497, 0, '0', 0, 0, 1633.07470703125, 195.2083282470703125, -60.769775390625, 3.94444584846496582, 0, 0, -0.92050457000732421, 0.3907318115234375, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+231, 208200, 0, 1497, 0, '0', 0, 0, 1557.7611083984375, 304.699066162109375, -62.17767333984375, 0.673102021217346191, 0, 0, 0.330233573913574218, 0.943899273872375488, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+232, 208200, 0, 1497, 0, '0', 0, 0, 1608.29345703125, 235.71875, -62.0773582458496093, 0, 0, 0, 0, 1, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+233, 208200, 0, 1497, 0, '0', 0, 0, 1593.1837158203125, 178.7835540771484375, -62.1779251098632812, 3.107313871383666992, 0, 0, 0.999853134155273437, 0.017138602212071418, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+234, 208200, 0, 1497, 0, '0', 0, 0, 1768.857666015625, 230.89788818359375, -62.1756820678710937, 4.52569580078125, 0, 0, -0.76993846893310546, 0.638118147850036621, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+235, 208200, 0, 14046, 0, '0', 0, 0, 1698.0992431640625, 240.6975555419921875, -62.1776695251464843, 4.460465908050537109, 0, 0, -0.79033756256103515, 0.612671613693237304, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+236, 208200, 0, 14046, 0, '0', 0, 0, 1693.045166015625, 142.0677032470703125, -55.2144966125488281, 3.560472726821899414, 0, 0, -0.97814750671386718, 0.207912087440490722, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+237, 208200, 0, 1497, 0, '0', 0, 0, 1636.953125, 134.9756927490234375, -62.1579132080078125, 3.333590030670166015, 0, 0, -0.99539566040039062, 0.095851235091686248, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+238, 208200, 0, 1497, 0, '0', 0, 0, 1529.8214111328125, 223.845703125, -62.1778564453125, 1.856184601783752441, 0, 0, 0.800477981567382812, 0.599362134933471679, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+239, 208200, 0, 1497, 0, '0', 0, 0, 1467.6822509765625, 238.1145782470703125, -62.1776809692382812, 3.263772249221801757, 0, 0, -0.99813461303710937, 0.061051756143569946, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+240, 208200, 0, 1497, 4617, '0', 0, 0, 1551.3680419921875, 213.3993072509765625, -58.5725975036621093, 3.45575571060180664, 0, 0, -0.98768806457519531, 0.156436234712600708, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: Elevator - Difficulty: 0) +(@OGUID+241, 208200, 0, 1497, 0, '0', 0, 0, 1591.0052490234375, 251.2864532470703125, -62.0870437622070312, 0, 0, 0, 0, 1, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+242, 208200, 0, 1497, 0, '0', 0, 0, 1729.670166015625, 224.609375, -62.1776924133300781, 0, 0, 0, 0, 1, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+243, 208200, 0, 1497, 0, '0', 0, 0, 1772.6563720703125, 234.324462890625, -62.1756820678710937, 3.469304561614990234, 0, 0, -0.98660564422607421, 0.163123577833175659, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+244, 208200, 0, 1497, 0, '0', 0, 0, 1774.4478759765625, 333.380218505859375, -62.2883377075195312, 1.361356139183044433, 0, 0, 0.629320144653320312, 0.77714616060256958, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+245, 208200, 0, 1497, 0, '0', 0, 0, 1602.342041015625, 365.654510498046875, -62.1776885986328125, 2.251473426818847656, 0, 0, 0.902585029602050781, 0.430511653423309326, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+246, 208200, 0, 1497, 0, '0', 0, 0, 1534.0069580078125, 238.201385498046875, -62.1779861450195312, 4.118979454040527343, 0, 0, -0.88294696807861328, 0.469472706317901611, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+247, 208200, 0, 1497, 0, '0', 0, 0, 1543.3685302734375, 289.494781494140625, -62.1813468933105468, 0.984741449356079101, 0, 0, 0.472716331481933593, 0.881214678287506103, 120, 255, 1, 45745), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+248, 208200, 0, 14046, 0, '0', 0, 0, 1771.8038330078125, 234.2604217529296875, -62.1757125854492187, 5.078907966613769531, 0, 0, -0.56640625, 0.824126183986663818, 120, 255, 1, 46340), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+249, 208200, 0, 14046, 0, '0', 0, 0, 1700.126708984375, 294.6944580078125, -62.1607131958007812, 2.251473426818847656, 0, 0, 0.902585029602050781, 0.430511653423309326, 120, 255, 1, 46340), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+250, 208200, 0, 14046, 0, '0', 0, 0, 1670.4635009765625, 163.9756927490234375, -62.12957763671875, 5.916667938232421875, 0, 0, -0.18223476409912109, 0.98325502872467041, 120, 255, 1, 46340), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+251, 208200, 0, 1497, 0, '0', 0, 0, 1605.845458984375, 241.173614501953125, -52.1507644653320312, 1.85004889965057373, 0, 0, 0.798635482788085937, 0.60181504487991333, 120, 255, 1, 46340), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+252, 208200, 0, 1497, 0, '0', 0, 0, 1572.3177490234375, 192.36285400390625, -42.9935188293457031, 0, 0, 0, 0, 1, 120, 255, 1, 46340), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+253, 208200, 0, 1497, 0, '0', 0, 0, 1556.9947509765625, 279.15972900390625, -43.1021957397460937, 0, 0, 0, 0, 1, 120, 255, 1, 46340), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+254, 208200, 0, 1497, 0, '0', 0, 0, 1692.310791015625, 90.58333587646484375, -62.217529296875, 2.199114561080932617, 0, 0, 0.8910064697265625, 0.453990638256072998, 120, 255, 1, 46340), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+255, 208200, 0, 1497, 0, '0', 0, 0, 1667.484375, 117.0711822509765625, -61.4775543212890625, 1.692969322204589843, 0, 0, 0.748955726623535156, 0.662620067596435546, 120, 255, 1, 46340), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+256, 208200, 0, 1497, 0, '0', 0, 0, 1619.4166259765625, 111.260406494140625, -62.1776924133300781, 0.733038187026977539, 0, 0, 0.358367919921875, 0.933580458164215087, 120, 255, 1, 46340), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+257, 208200, 0, 1497, 0, '0', 0, 0, 1596.2447509765625, 424.5, -46.3621826171875, 4.049167633056640625, 0, 0, -0.89879322052001953, 0.438372820615768432, 120, 255, 1, 46340), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+258, 208200, 0, 1497, 0, '0', 0, 0, 1699.71875, 383.8663330078125, -62.2056694030761718, 6.213373661041259765, 0, 0, -0.03489875793457031, 0.999390840530395507, 120, 255, 1, 46340), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+259, 208200, 0, 1497, 0, '0', 0, 0, 1702.689208984375, 417.65625, -62.3405303955078125, 4.049167633056640625, 0, 0, -0.89879322052001953, 0.438372820615768432, 120, 255, 1, 46340), -- Stink Bomb Cloud (Area: 0 - Difficulty: 0) +(@OGUID+260, 208394, 0, 14046, 14046, '0', 0, 0, 1840.3507080078125, 215.3020782470703125, 60.04131317138671875, 3.612837791442871093, 0, 0, -0.97236919403076171, 0.233448356389999389, 120, 255, 1, 45745), -- Pile of Candy (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+261, 208394, 0, 14046, 14046, '0', 0, 0, 1841.076416015625, 216.0381927490234375, 60.07797622680664062, 4.328419685363769531, 0, 0, -0.82903671264648437, 0.559194147586822509, 120, 255, 1, 45745), -- Pile of Candy (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+262, 208394, 0, 14046, 14046, '0', 0, 0, 1840.7899169921875, 214.204864501953125, 60.15583038330078125, 3.612837791442871093, 0, 0, -0.97236919403076171, 0.233448356389999389, 120, 255, 1, 45745), -- Pile of Candy (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+263, 208394, 0, 14046, 14046, '0', 0, 0, 1839.421875, 214.8402862548828125, 60.07273483276367187, 2.059488296508789062, 0, 0, 0.857167243957519531, 0.515038192272186279, 120, 255, 1, 45745), -- Pile of Candy (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+264, 208394, 0, 14046, 14046, '0', 0, 0, 1839.828125, 213.4340362548828125, 60.24547576904296875, 2.932138919830322265, 0, 0, 0.994521141052246093, 0.104535527527332305, 120, 255, 1, 45745), -- Pile of Candy (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+265, 208394, 0, 14046, 14046, '0', 0, 0, 1839.6754150390625, 215.9010467529296875, 60.06316375732421875, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 45745), -- Pile of Candy (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+266, 208963, 0, 14046, 14046, '0', 0, 0, 1827.842041015625, 210.421875, 60.24535369873046875, 5.078907966613769531, 0, 0, -0.56640625, 0.824126183986663818, 120, 255, 1, 45745), -- Forsaken Tent 03 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+267, 208965, 0, 14046, 14046, '0', 0, 0, 1815.467041015625, 226.9930572509765625, 59.5797119140625, 2.321286916732788085, 0, 0, 0.917059898376464843, 0.398749500513076782, 120, 255, 1, 45745), -- Undead Lamp Post (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+268, 208965, 0, 14046, 14046, '0', 0, 0, 1809.982666015625, 220.767364501953125, 59.67888641357421875, 0, 0, 0, 0, 1, 120, 255, 1, 45745), -- Undead Lamp Post (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+269, 208965, 0, 14046, 14046, '0', 0, 0, 1816.4132080078125, 228.2552032470703125, 59.63434600830078125, 2.391098499298095703, 0, 0, 0.930417060852050781, 0.366502493619918823, 120, 255, 1, 45745), -- Undead Lamp Post (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+270, 208965, 0, 14046, 14046, '0', 0, 0, 1828.592041015625, 233.8958282470703125, 60.34052276611328125, 0, 0, 0, 0, 1, 120, 255, 1, 45745), -- Undead Lamp Post (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+271, 208965, 0, 14046, 14046, '0', 0, 0, 1823.0850830078125, 234.921875, 60.33228302001953125, 0, 0, 0, 0, 1, 120, 255, 1, 45745), -- Undead Lamp Post (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+272, 208965, 0, 14046, 14046, '0', 0, 0, 1821.907958984375, 204.5868072509765625, 60.0557861328125, 6.073746204376220703, 0, 0, -0.10452842712402343, 0.994521915912628173, 120, 255, 1, 45745), -- Undead Lamp Post (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+273, 208965, 0, 14046, 14046, '0', 0, 0, 1839.4478759765625, 226.8993072509765625, 60.23472213745117187, 6.073746204376220703, 0, 0, -0.10452842712402343, 0.994521915912628173, 120, 255, 1, 45745), -- Undead Lamp Post (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+274, 209064, 0, 14046, 0, '0', 0, 0, 1787.748291015625, 119.9027786254882812, 69.30057525634765625, 0, 0, 0, 0, 1, 120, 255, 1, 45745), -- Catacombs Lightning (Area: 0 - Difficulty: 0) +(@OGUID+275, 209064, 0, 14046, 0, '0', 0, 0, 1801.9722900390625, 59.56770706176757812, 63.96684646606445312, 0, 0, 0, 0, 1, 120, 255, 1, 45745), -- Catacombs Lightning (Area: 0 - Difficulty: 0) +(@OGUID+276, 209064, 0, 14046, 0, '0', 0, 0, 1735.7691650390625, 58.22222137451171875, 64.20218658447265625, 5.6897735595703125, 0, 0, -0.29237174987792968, 0.956304728984832763, 120, 255, 1, 45745), -- Catacombs Lightning (Area: 0 - Difficulty: 0) +(@OGUID+277, 209064, 0, 85, 153, '0', 0, 0, 1693.234375, 58.30208206176757812, 63.33312225341796875, 5.323255538940429687, 0, 0, -0.46174812316894531, 0.887011110782623291, 120, 255, 1, 45745), -- Catacombs Lightning (Area: Ruins of Lordaeron - Difficulty: 0) +(@OGUID+278, 209064, 0, 14046, 0, '0', 0, 0, 1646.765625, 59.15625, 62.40178298950195312, 0, 0, 0, 0, 1, 120, 255, 1, 45745), -- Catacombs Lightning (Area: 0 - Difficulty: 0) +(@OGUID+279, 209065, 0, 14046, 0, '0', 0, 0, 1585.7430419921875, 61.296875, 63.57022476196289062, 0, 0, 0, 0, 1, 120, 255, 1, 45745), -- Catacombs Lightning 2 (Area: 0 - Difficulty: 0) +(@OGUID+280, 209094, 0, 14046, 0, '0', 0, 0, 1584.248291015625, 61.21527862548828125, 62.53647232055664062, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 45745), -- Stolen Crate (Area: 0 - Difficulty: 0) +(@OGUID+281, 209140, 0, 14046, 14046, '0', 0, 0, 1782.6614990234375, 214.126739501953125, 59.79413604736328125, 0.942476630210876464, 0, 0, 0.453989982604980468, 0.891006767749786376, 120, 255, 1, 45745); -- Wickerman (Area: Tirisfal Glades - Difficulty: 0) + +-- Event spawns +-- Event spawns +DELETE FROM `game_event_creature` WHERE `eventEntry`=12 AND `guid` BETWEEN @CGUID+0 AND @CGUID+55; +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), +(12, @CGUID+47), +(12, @CGUID+48), +(12, @CGUID+49), +(12, @CGUID+50), +(12, @CGUID+51), +(12, @CGUID+52), +(12, @CGUID+53), +(12, @CGUID+54), +(12, @CGUID+55); + +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+281; +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), +(12, @OGUID+157), +(12, @OGUID+158), +(12, @OGUID+159), +(12, @OGUID+160), +(12, @OGUID+161), +(12, @OGUID+162), +(12, @OGUID+163), +(12, @OGUID+164), +(12, @OGUID+165), +(12, @OGUID+166), +(12, @OGUID+167), +(12, @OGUID+168), +(12, @OGUID+169), +(12, @OGUID+170), +(12, @OGUID+171), +(12, @OGUID+172), +(12, @OGUID+173), +(12, @OGUID+174), +(12, @OGUID+175), +(12, @OGUID+176), +(12, @OGUID+177), +(12, @OGUID+178), +(12, @OGUID+179), +(12, @OGUID+180), +(12, @OGUID+181), +(12, @OGUID+182), +(12, @OGUID+183), +(12, @OGUID+184), +(12, @OGUID+185), +(12, @OGUID+186), +(12, @OGUID+187), +(12, @OGUID+188), +(12, @OGUID+189), +(12, @OGUID+190), +(12, @OGUID+191), +(12, @OGUID+192), +(12, @OGUID+193), +(12, @OGUID+194), +(12, @OGUID+195), +(12, @OGUID+196), +(12, @OGUID+197), +(12, @OGUID+198), +(12, @OGUID+199), +(12, @OGUID+200), +(12, @OGUID+201), +(12, @OGUID+202), +(12, @OGUID+203), +(12, @OGUID+204), +(12, @OGUID+205), +(12, @OGUID+206), +(12, @OGUID+207), +(12, @OGUID+208), +(12, @OGUID+209), +(12, @OGUID+210), +(12, @OGUID+211), +(12, @OGUID+212), +(12, @OGUID+213), +(12, @OGUID+214), +(12, @OGUID+215), +(12, @OGUID+216), +(12, @OGUID+217), +(12, @OGUID+218), +(12, @OGUID+219), +(12, @OGUID+220), +(12, @OGUID+221), +(12, @OGUID+222), +(12, @OGUID+223), +(12, @OGUID+224), +(12, @OGUID+225), +(12, @OGUID+226), +(12, @OGUID+227), +(12, @OGUID+228), +(12, @OGUID+229), +(12, @OGUID+230), +(12, @OGUID+231), +(12, @OGUID+232), +(12, @OGUID+233), +(12, @OGUID+234), +(12, @OGUID+235), +(12, @OGUID+236), +(12, @OGUID+237), +(12, @OGUID+238), +(12, @OGUID+239), +(12, @OGUID+240), +(12, @OGUID+241), +(12, @OGUID+242), +(12, @OGUID+243), +(12, @OGUID+244), +(12, @OGUID+245), +(12, @OGUID+246), +(12, @OGUID+247), +(12, @OGUID+248), +(12, @OGUID+249), +(12, @OGUID+250), +(12, @OGUID+251), +(12, @OGUID+252), +(12, @OGUID+253), +(12, @OGUID+254), +(12, @OGUID+255), +(12, @OGUID+256), +(12, @OGUID+257), +(12, @OGUID+258), +(12, @OGUID+259), +(12, @OGUID+260), +(12, @OGUID+261), +(12, @OGUID+262), +(12, @OGUID+263), +(12, @OGUID+264), +(12, @OGUID+265), +(12, @OGUID+266), +(12, @OGUID+267), +(12, @OGUID+268), +(12, @OGUID+269), +(12, @OGUID+270), +(12, @OGUID+271), +(12, @OGUID+272), +(12, @OGUID+273), +(12, @OGUID+274), +(12, @OGUID+275), +(12, @OGUID+276), +(12, @OGUID+277), +(12, @OGUID+278), +(12, @OGUID+279), +(12, @OGUID+280), +(12, @OGUID+281); + +-- SAI +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=51730; + +SET @ACTIONLIST := 51730 * 100; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (51730,-(@CGUID+25),-(@CGUID+26),-(@CGUID+27),-(@CGUID+28)) AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ACTIONLIST AND `source_type`=9; +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `event_param_string`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param7`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(-(@CGUID+25),0,0,0,1,0,100,0,0,6000,3500,6500,0,'',80,@ACTIONLIST,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,'Wickerman Reveler - Out of combat (3.5 - 6.5 seconds) - Call timed actionlist'), +(-(@CGUID+26),0,0,0,1,0,100,0,0,6000,3500,6500,0,'',80,@ACTIONLIST,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,'Wickerman Reveler - Out of combat (3.5 - 6.5 seconds) - Call timed actionlist'), +(-(@CGUID+27),0,0,0,1,0,100,0,0,6000,3500,6500,0,'',80,@ACTIONLIST,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,'Wickerman Reveler - Out of combat (3.5 - 6.5 seconds) - Call timed actionlist'), +(-(@CGUID+28),0,0,0,1,0,100,0,0,6000,3500,6500,0,'',80,@ACTIONLIST,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,'Wickerman Reveler - Out of combat (3.5 - 6.5 seconds) - Call timed actionlist'), + +(@ACTIONLIST,9,0,0,0,0,100,0,0,0,0,0,0,'',10,6,273,274,396,0,0,0,1,0,0,0,0,0,0,0,0,'Actionlist - Wickerman Reveler - Play random emote'); diff --git a/sql/updates/world/master/2023_11_06_10_world_tirisfal_glades_brill.sql b/sql/updates/world/master/2023_11_06_10_world_tirisfal_glades_brill.sql new file mode 100644 index 00000000000..4fcaf8b85b1 --- /dev/null +++ b/sql/updates/world/master/2023_11_06_10_world_tirisfal_glades_brill.sql @@ -0,0 +1,389 @@ +SET @CGUID := 3000194; +SET @OGUID := 3003171; + +-- Old creature spawns +DELETE FROM `creature` WHERE `guid` BETWEEN 395822 AND 395871; +DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 395822 AND 395871; + +-- Creature spawns +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+49; +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, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2240.095458984375, 459.133697509765625, 38.630889892578125, 4.694935798645019531, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) +(@CGUID+1, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2261.326416015625, 347.430572509765625, 43.05722808837890625, 0.541052043437957763, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+2, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2254.84033203125, 314.2257080078125, 41.2130584716796875, 1.448623299598693847, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+3, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2235.05322265625, 472.6627197265625, 38.12391281127929687, 4.380776405334472656, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) +(@CGUID+4, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2230.423583984375, 464.6475830078125, 40.73132705688476562, 2.373647689819335937, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) +(@CGUID+5, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2257.7431640625, 317.984375, 41.88471221923828125, 5.410520553588867187, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42091 - Headless Horseman - Fire Size, 42154 - Headless Horseman - Dim Fire) +(@CGUID+6, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2251.34375, 337.368072509765625, 42.2274017333984375, 3.298672199249267578, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42091 - Headless Horseman - Fire Size, 42154 - Headless Horseman - Dim Fire) +(@CGUID+7, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2254.84716796875, 323.204864501953125, 42.45365142822265625, 2.775073528289794921, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+8, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2252.361083984375, 331.067718505859375, 42.41402053833007812, 3.298672199249267578, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42091 - Headless Horseman - Fire Size, 42154 - Headless Horseman - Dim Fire) +(@CGUID+9, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2239.493408203125, 487.851959228515625, 37.7115020751953125, 1.239183783531188964, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42096 - Headless Horseman - Fire onSpawn, Size, 42074 - Headless Horseman - Fire) +(@CGUID+10, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2231.300048828125, 482.617034912109375, 40.07016372680664062, 3.124139308929443359, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) +(@CGUID+11, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2252.342041015625, 309.69964599609375, 44.13006210327148437, 4.066617012023925781, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+12, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2246.005126953125, 303.354156494140625, 43.400665283203125, 0.959931075572967529, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+13, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2238.9150390625, 304.5, 44.37771987915039062, 3.071779489517211914, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+14, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2300.70654296875, 303.961822509765625, 46.98241424560546875, 1.361356854438781738, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+15, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2284.486083984375, 291.9288330078125, 46.61287689208984375, 0.541052043437957763, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+16, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2231.848876953125, 309.005218505859375, 43.41153717041015625, 3.071779489517211914, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+17, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2278.322998046875, 291.321197509765625, 40.31996917724609375, 0.541052043437957763, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+18, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2274.392333984375, 289.6944580078125, 48.61417388916015625, 0.541052043437957763, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+19, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2293.942626953125, 297.873260498046875, 46.41251373291015625, 2.408554315567016601, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+20, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2278.8125, 294.53472900390625, 47.22496795654296875, 0.541052043437957763, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+21, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2290.505126953125, 293.51910400390625, 45.98954010009765625, 0.541052043437957763, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+22, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2279.421875, 301.767364501953125, 36.4935760498046875, 0.541052043437957763, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+23, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2295.428955078125, 303.126739501953125, 47.12674713134765625, 0.418879032135009765, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+24, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2260.09375, 269.25347900390625, 40.70278549194335937, 0.541052043437957763, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+25, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2280.515625, 275.111114501953125, 49.28763580322265625, 4.328416347503662109, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+26, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2274.296875, 271.305572509765625, 37.42652130126953125, 1.553343057632446289, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+27, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2273.189208984375, 285.73785400390625, 48.31700897216796875, 4.415682792663574218, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+28, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2285.73779296875, 270.548614501953125, 50.0669708251953125, 3.822271108627319335, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+29, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2228.833251953125, 292.661468505859375, 42.8594512939453125, 0.541052043437957763, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+30, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2274.55029296875, 279.1788330078125, 48.409698486328125, 0.366519153118133544, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+31, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2293.850830078125, 257.7257080078125, 44.3997650146484375, 3.577924966812133789, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+32, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2287.6494140625, 259.76214599609375, 45.74924087524414062, 6.056292533874511718, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+33, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2241.072998046875, 268.640625, 35.41741180419921875, 0.541052043437957763, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+34, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2290.99658203125, 257.970489501953125, 41.21030807495117187, 0.244346097111701965, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+35, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2286.732666015625, 263.130218505859375, 49.06853485107421875, 5.759586334228515625, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+36, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2243.270751953125, 243.640625, 46.15302658081054687, 0.383972436189651489, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+37, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2248.6181640625, 243.6458282470703125, 43.66082382202148437, 3.50811171531677246, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+38, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2240.4931640625, 242.982635498046875, 48.13275909423828125, 2.007128715515136718, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+39, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2234.392333984375, 237.579864501953125, 43.66956710815429687, 4.450589656829833984, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+40, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2252.62841796875, 235.0885467529296875, 43.33164596557617187, 2.076941728591918945, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+41, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2238.380126953125, 241.4809112548828125, 46.202789306640625, 3.141592741012573242, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+42, 23537, 0, 85, 159, '0', 0, 0, 0, 0, 2230.328125, 232.3715362548828125, 43.55051422119140625, 2.687807083129882812, 120, 0, 0, 9433, 5751, 0, NULL, NULL, NULL, NULL, 45745), -- Headless Horseman - Fire (DND) (Area: Brill - Difficulty: 0) (Auras: 42154 - Headless Horseman - Dim Fire) +(@CGUID+43, 23971, 0, 85, 159, '0', 0, 0, 0, 0, 2224.717041015625, 278.857635498046875, 33.7032012939453125, 2.181661605834960937, 120, 0, 0, 27, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Traveling Orphan (Area: Brill - Difficulty: 0) +(@CGUID+44, 23971, 0, 85, 159, '0', 0, 0, 0, 0, 2225.18408203125, 280.41839599609375, 33.70176315307617187, 3.246312379837036132, 120, 0, 0, 27, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Traveling Orphan (Area: Brill - Difficulty: 0) +(@CGUID+45, 23971, 0, 85, 159, '0', 0, 0, 0, 0, 2223.236083984375, 278.833343505859375, 33.88888931274414062, 1.2042771577835083, 120, 0, 0, 27, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Traveling Orphan (Area: Brill - Difficulty: 0) +(@CGUID+46, 23971, 0, 85, 159, '0', 0, 0, 0, 0, 2224.944580078125, 281.713531494140625, 33.7413177490234375, 3.979350566864013671, 120, 0, 0, 34, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Traveling Orphan (Area: Brill - Difficulty: 0) +(@CGUID+47, 23973, 0, 85, 159, '0', 0, 0, 0, 0, 2223.42529296875, 280.708343505859375, 33.82149124145507812, 5.637413501739501953, 120, 0, 0, 11791, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Masked Orphan Matron (Area: Brill - Difficulty: 0) +(@CGUID+48, 24491, 0, 85, 159, '0', 0, 0, 0, 1, 2256.2353515625, 471.555084228515625, 34.11893463134765625, 0.296705961227416992, 120, 0, 0, 3208, 0, 0, NULL, NULL, NULL, NULL, 45745), -- Deathguard Florence (Area: Brill - Difficulty: 0) +(@CGUID+49, 53977, 0, 14046, 0, '0', 0, 0, 0, 1, 2070.704833984375, 285.623260498046875, 97.1148681640625, 2.827433347702026367, 120, 0, 0, 58955, 0, 0, NULL, NULL, NULL, NULL, 45745); -- Darkcaller Yanka (Area: 0 - Difficulty: 0) + +-- Old gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN 242528 AND 242659; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 242528 AND 242659; + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+131; +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, 85, 159, '0', 0, 0, 2268.817626953125, 422.5069580078125, 34.3983154296875, 3.368495941162109375, 0, 0, -0.99357128143310546, 0.113208353519439697, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Brill - Difficulty: 0) +(@OGUID+1, 180405, 0, 85, 159, '0', 0, 0, 2269.35595703125, 376.489593505859375, 46.12230682373046875, 1.32644820213317871, 0, 0, 0.615660667419433593, 0.788011372089385986, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Brill - Difficulty: 0) +(@OGUID+2, 180405, 0, 85, 159, '0', 0, 0, 2271.475830078125, 377.70660400390625, 35.9481201171875, 1.518436193466186523, 0, 0, 0.6883544921875, 0.725374460220336914, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Brill - Difficulty: 0) +(@OGUID+3, 180405, 0, 85, 159, '0', 0, 0, 2277.2744140625, 291.432281494140625, 48.373809814453125, 4.468043327331542968, 0, 0, -0.7880105972290039, 0.615661680698394775, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Brill - Difficulty: 0) +(@OGUID+4, 180405, 0, 85, 159, '0', 0, 0, 2247.513916015625, 296.4444580078125, 36.89109420776367187, 0.907570242881774902, 0, 0, 0.438370704650878906, 0.898794233798980712, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Brill - Difficulty: 0) +(@OGUID+5, 180405, 0, 85, 159, '0', 0, 0, 2272.166748046875, 278.348968505859375, 35.35729217529296875, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Brill - Difficulty: 0) +(@OGUID+6, 180405, 0, 85, 159, '0', 0, 0, 2259.62841796875, 269.189239501953125, 40.6492462158203125, 4.328419685363769531, 0, 0, -0.82903671264648437, 0.559194147586822509, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Brill - Difficulty: 0) +(@OGUID+7, 180405, 0, 85, 159, '0', 0, 0, 2244.390625, 253.44097900390625, 33.58501434326171875, 0.942476630210876464, 0, 0, 0.453989982604980468, 0.891006767749786376, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Brill - Difficulty: 0) +(@OGUID+8, 180405, 0, 85, 159, '0', 0, 0, 2326.239501953125, 242.013885498046875, 29.50647735595703125, 1.884953022003173828, 0, 0, 0.809016227722167968, 0.587786316871643066, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Brill - Difficulty: 0) +(@OGUID+9, 180405, 0, 85, 159, '0', 0, 0, 2295.84033203125, 205.829864501953125, 34.25822067260742187, 4.310965538024902343, 0, 0, -0.83388519287109375, 0.55193793773651123, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Brill - Difficulty: 0) +(@OGUID+10, 180405, 0, 85, 159, '0', 0, 0, 2173.7431640625, 236.9739532470703125, 38.3304595947265625, 6.108653545379638671, 0, 0, -0.08715534210205078, 0.996194720268249511, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Brill - Difficulty: 0) +(@OGUID+11, 180405, 0, 14046, 0, '0', 0, 0, 2093.842041015625, 318.810760498046875, 54.18476486206054687, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: 0 - Difficulty: 0) +(@OGUID+12, 180405, 0, 14046, 0, '0', 0, 0, 2069.526611328125, 282.1065673828125, 97.03143310546875, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: 0 - Difficulty: 0) +(@OGUID+13, 180405, 0, 14046, 0, '0', 0, 0, 2055.904541015625, 248.9583282470703125, 99.768707275390625, 0.436331570148468017, 0, 0, 0.216439247131347656, 0.976296067237854003, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: 0 - Difficulty: 0) +(@OGUID+14, 180405, 0, 14046, 0, '0', 0, 0, 2059.69091796875, 308.01910400390625, 54.52080917358398437, 5.131268978118896484, 0, 0, -0.54463863372802734, 0.838670849800109863, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: 0 - Difficulty: 0) +(@OGUID+15, 180405, 0, 14046, 0, '0', 0, 0, 2047.3214111328125, 280.66290283203125, 56.46856689453125, 4.904376029968261718, 0, 0, -0.636077880859375, 0.771624863147735595, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: 0 - Difficulty: 0) +(@OGUID+16, 180406, 0, 85, 159, '0', 0, 0, 2313.342041015625, 401.7413330078125, 33.9480133056640625, 5.375615119934082031, 0, 0, -0.4383707046508789, 0.898794233798980712, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Brill - Difficulty: 0) +(@OGUID+17, 180406, 0, 85, 159, '0', 0, 0, 2261.1650390625, 339.638885498046875, 34.18529129028320312, 1.675513744354248046, 0, 0, 0.743144035339355468, 0.669131457805633544, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Brill - Difficulty: 0) +(@OGUID+18, 180406, 0, 85, 159, '0', 0, 0, 2284.876708984375, 425.3194580078125, 34.33960342407226562, 3.630291461944580078, 0, 0, -0.97029495239257812, 0.241925001144409179, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Brill - Difficulty: 0) +(@OGUID+19, 180406, 0, 85, 159, '0', 0, 0, 2272.126708984375, 285.973968505859375, 55.36051177978515625, 4.747295856475830078, 0, 0, -0.69465827941894531, 0.719339847564697265, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Brill - Difficulty: 0) +(@OGUID+20, 180406, 0, 85, 159, '0', 0, 0, 2270.401123046875, 281.10589599609375, 48.33415985107421875, 4.607671737670898437, 0, 0, -0.74314403533935546, 0.669131457805633544, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Brill - Difficulty: 0) +(@OGUID+21, 180406, 0, 85, 159, '0', 0, 0, 2239.37841796875, 270.883697509765625, 35.32658767700195312, 3.473210096359252929, 0, 0, -0.98628520965576171, 0.165049895644187927, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Brill - Difficulty: 0) +(@OGUID+22, 180406, 0, 85, 159, '0', 0, 0, 2340.810791015625, 271.513885498046875, 34.49287796020507812, 3.473210096359252929, 0, 0, -0.98628520965576171, 0.165049895644187927, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Brill - Difficulty: 0) +(@OGUID+23, 180406, 0, 85, 159, '0', 0, 0, 2217.239501953125, 270.196197509765625, 38.78445053100585937, 1.448621988296508789, 0, 0, 0.662619590759277343, 0.748956084251403808, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Brill - Difficulty: 0) +(@OGUID+24, 180406, 0, 85, 159, '0', 0, 0, 2239.432373046875, 245.84722900390625, 50.15337753295898437, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Brill - Difficulty: 0) +(@OGUID+25, 180406, 0, 85, 159, '0', 0, 0, 2297.3212890625, 208.298614501953125, 33.93912506103515625, 4.433136463165283203, 0, 0, -0.79863548278808593, 0.60181504487991333, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Brill - Difficulty: 0) +(@OGUID+26, 180406, 0, 85, 159, '0', 0, 0, 2183.5400390625, 224.453125, 37.49752426147460937, 5.096362113952636718, 0, 0, -0.55919265747070312, 0.829037725925445556, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Brill - Difficulty: 0) +(@OGUID+27, 180406, 0, 14046, 0, '0', 0, 0, 2082.337158203125, 273.5054931640625, 56.9151763916015625, 1.745326757431030273, 0, 0, 0.766043663024902343, 0.642788589000701904, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: 0 - Difficulty: 0) +(@OGUID+28, 180406, 0, 14046, 0, '0', 0, 0, 2091.30908203125, 327.592010498046875, 54.47382354736328125, 1.902408957481384277, 0, 0, 0.814115524291992187, 0.580702960491180419, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: 0 - Difficulty: 0) +(@OGUID+29, 180406, 0, 14046, 0, '0', 0, 0, 2049.03466796875, 289.130218505859375, 56.72039031982421875, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: 0 - Difficulty: 0) +(@OGUID+30, 180406, 0, 14046, 0, '0', 0, 0, 2063.32470703125, 342.52777099609375, 82.36009979248046875, 2.059488296508789062, 0, 0, 0.857167243957519531, 0.515038192272186279, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: 0 - Difficulty: 0) +(@OGUID+31, 180407, 0, 85, 159, '0', 0, 0, 2313.015625, 394.001739501953125, 33.90306472778320312, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Brill - Difficulty: 0) +(@OGUID+32, 180407, 0, 85, 159, '0', 0, 0, 2276.77783203125, 389.90625, 34.37842178344726562, 2.111847877502441406, 0, 0, 0.870355606079101562, 0.492423713207244873, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Brill - Difficulty: 0) +(@OGUID+33, 180407, 0, 85, 159, '0', 0, 0, 2262.20654296875, 320.3038330078125, 33.58481597900390625, 1.256635904312133789, 0, 0, 0.587784767150878906, 0.809017360210418701, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Brill - Difficulty: 0) +(@OGUID+34, 180407, 0, 85, 159, '0', 0, 0, 2284.595458984375, 299.557281494140625, 37.51879501342773437, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Brill - Difficulty: 0) +(@OGUID+35, 180407, 0, 85, 159, '0', 0, 0, 2272.421875, 290.62847900390625, 48.33542251586914062, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Brill - Difficulty: 0) +(@OGUID+36, 180407, 0, 85, 159, '0', 0, 0, 2274.7744140625, 278.2413330078125, 48.36402130126953125, 5.410521507263183593, 0, 0, -0.42261791229248046, 0.906307935714721679, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Brill - Difficulty: 0) +(@OGUID+37, 180407, 0, 85, 159, '0', 0, 0, 2205.4375, 296.526031494140625, 39.30980300903320312, 2.687806606292724609, 0, 0, 0.974370002746582031, 0.224951311945915222, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Brill - Difficulty: 0) +(@OGUID+38, 180407, 0, 85, 159, '0', 0, 0, 2279.710205078125, 252.6145782470703125, 35.49803543090820312, 5.410521507263183593, 0, 0, -0.42261791229248046, 0.906307935714721679, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Brill - Difficulty: 0) +(@OGUID+39, 180407, 0, 85, 159, '0', 0, 0, 2234.15283203125, 254.84722900390625, 33.57361602783203125, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Brill - Difficulty: 0) +(@OGUID+40, 180407, 0, 85, 159, '0', 0, 0, 2293.0087890625, 205.046875, 33.8228912353515625, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Brill - Difficulty: 0) +(@OGUID+41, 180407, 0, 85, 159, '0', 0, 0, 2326.578125, 223.53472900390625, 28.71483802795410156, 2.303830623626708984, 0, 0, 0.913544654846191406, 0.406738430261611938, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Brill - Difficulty: 0) +(@OGUID+42, 180407, 0, 14046, 0, '0', 0, 0, 2084.196533203125, 281.981964111328125, 57.29332733154296875, 1.745326757431030273, 0, 0, 0.766043663024902343, 0.642788589000701904, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: 0 - Difficulty: 0) +(@OGUID+43, 180407, 0, 14046, 0, '0', 0, 0, 2057.39404296875, 315.552093505859375, 54.15450286865234375, 5.6897735595703125, 0, 0, -0.29237174987792968, 0.956304728984832763, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: 0 - Difficulty: 0) +(@OGUID+44, 180407, 0, 14046, 0, '0', 0, 0, 2062.645751953125, 247.611114501953125, 99.76775360107421875, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: 0 - Difficulty: 0) +(@OGUID+45, 180407, 0, 14046, 0, '0', 0, 0, 2062.9306640625, 283.673919677734375, 97.03136444091796875, 2.792518377304077148, 0, 0, 0.984807014465332031, 0.173652306199073791, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: 0 - Difficulty: 0) +(@OGUID+46, 180408, 0, 85, 159, '0', 0, 0, 2238.963623046875, 269.270843505859375, 46.97807693481445312, 2.879789113998413085, 0, 0, 0.991444587707519531, 0.130528271198272705, 120, 255, 1, 45745), -- G_WitchHat_01 (Area: Brill - Difficulty: 0) +(@OGUID+47, 180410, 0, 85, 159, '0', 0, 0, 2252.017333984375, 311.052093505859375, 34.86345291137695312, 1.047197580337524414, 0, 0, 0.5, 0.866025388240814208, 120, 255, 1, 45745), -- G_HangingSkeleton_01 (Area: Brill - Difficulty: 0) +(@OGUID+48, 180410, 0, 85, 159, '0', 0, 0, 2287.73095703125, 290.611114501953125, 35.64279937744140625, 4.293513298034667968, 0, 0, -0.8386697769165039, 0.544640243053436279, 120, 255, 1, 45745), -- G_HangingSkeleton_01 (Area: Brill - Difficulty: 0) +(@OGUID+49, 180410, 0, 85, 159, '0', 0, 0, 2272.585205078125, 282.177093505859375, 35.02240371704101562, 2.146752834320068359, 0, 0, 0.878816604614257812, 0.477159708738327026, 120, 255, 1, 45745), -- G_HangingSkeleton_01 (Area: Brill - Difficulty: 0) +(@OGUID+50, 180410, 0, 85, 159, '0', 0, 0, 2307.703125, 285.130218505859375, 34.674072265625, 3.124123096466064453, 0, 0, 0.99996185302734375, 0.008734640665352344, 120, 255, 1, 45745), -- G_HangingSkeleton_01 (Area: Brill - Difficulty: 0) +(@OGUID+51, 180410, 0, 85, 159, '0', 0, 0, 2304.954833984375, 272.111114501953125, 34.550872802734375, 2.775068521499633789, 0, 0, 0.983254432678222656, 0.182238012552261352, 120, 255, 1, 45745), -- G_HangingSkeleton_01 (Area: Brill - Difficulty: 0) +(@OGUID+52, 180410, 0, 85, 159, '0', 0, 0, 2284.260498046875, 275.414947509765625, 34.68327713012695312, 1.308995485305786132, 0, 0, 0.608760833740234375, 0.793353796005249023, 120, 255, 1, 45745), -- G_HangingSkeleton_01 (Area: Brill - Difficulty: 0) +(@OGUID+53, 180410, 0, 85, 159, '0', 0, 0, 2242.65625, 245.0121612548828125, 35.51081085205078125, 2.792518377304077148, 0, 0, 0.984807014465332031, 0.173652306199073791, 120, 255, 1, 45745), -- G_HangingSkeleton_01 (Area: Brill - Difficulty: 0) +(@OGUID+54, 180411, 0, 85, 159, '0', 0, 0, 2260.7119140625, 314.29339599609375, 43.70012283325195312, 5.654868602752685546, 0, 0, -0.30901622772216796, 0.95105677843093872, 120, 255, 1, 45745), -- G_Ghost_01 (Area: Brill - Difficulty: 0) +(@OGUID+55, 180411, 0, 85, 159, '0', 0, 0, 2258, 309.598968505859375, 43.64711380004882812, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, 45745), -- G_Ghost_01 (Area: Brill - Difficulty: 0) +(@OGUID+56, 180411, 0, 85, 159, '0', 0, 0, 2272.2744140625, 290.774322509765625, 40.96544265747070312, 5.969027042388916015, 0, 0, -0.1564340591430664, 0.987688362598419189, 120, 255, 1, 45745), -- G_Ghost_01 (Area: Brill - Difficulty: 0) +(@OGUID+57, 180411, 0, 85, 159, '0', 0, 0, 2300.557373046875, 281.4375, 36.82360458374023437, 0.698131442070007324, 0, 0, 0.342020034790039062, 0.939692676067352294, 120, 255, 1, 45745), -- G_Ghost_01 (Area: Brill - Difficulty: 0) +(@OGUID+58, 180411, 0, 85, 159, '0', 0, 0, 2270.46875, 281.274322509765625, 40.94758987426757812, 1.431168079376220703, 0, 0, 0.656058311462402343, 0.754710197448730468, 120, 255, 1, 45745), -- G_Ghost_01 (Area: Brill - Difficulty: 0) +(@OGUID+59, 180411, 0, 85, 159, '0', 0, 0, 2243.123291015625, 246.8993072509765625, 36.92656326293945312, 3.665196180343627929, 0, 0, -0.96592521667480468, 0.258821308612823486, 120, 255, 1, 45745), -- G_Ghost_01 (Area: Brill - Difficulty: 0) +(@OGUID+60, 180411, 0, 85, 159, '0', 0, 0, 2236.14404296875, 244.00347900390625, 36.92360687255859375, 2.129300594329833984, 0, 0, 0.874619483947753906, 0.484810054302215576, 120, 255, 1, 45745), -- G_Ghost_01 (Area: Brill - Difficulty: 0) +(@OGUID+61, 180415, 0, 85, 159, '0', 0, 0, 2270.81591796875, 287.732635498046875, 33.69063186645507812, 4.45059061050415039, 0, 0, -0.79335308074951171, 0.608761727809906005, 120, 255, 1, 45745), -- CandleBlack01 (Area: Brill - Difficulty: 0) +(@OGUID+62, 180415, 0, 85, 159, '0', 0, 0, 2273.079833984375, 286.541656494140625, 33.96987533569335937, 3.90954136848449707, 0, 0, -0.92718315124511718, 0.37460830807685852, 120, 255, 1, 45745), -- CandleBlack01 (Area: Brill - Difficulty: 0) +(@OGUID+63, 180415, 0, 85, 159, '0', 0, 0, 2272.6875, 284.44097900390625, 34.00270462036132812, 3.961898565292358398, 0, 0, -0.91705989837646484, 0.398749500513076782, 120, 255, 1, 45745), -- CandleBlack01 (Area: Brill - Difficulty: 0) +(@OGUID+64, 180415, 0, 85, 159, '0', 0, 0, 2270.91845703125, 282.420135498046875, 33.92834091186523437, 0.017452461645007133, 0, 0, 0.008726119995117187, 0.999961912631988525, 120, 255, 1, 45745), -- CandleBlack01 (Area: Brill - Difficulty: 0) +(@OGUID+65, 180415, 0, 85, 159, '0', 0, 0, 2268.94091796875, 282.901031494140625, 33.82201004028320312, 2.67034769058227539, 0, 0, 0.972369194030761718, 0.233448356389999389, 120, 255, 1, 45745), -- CandleBlack01 (Area: Brill - Difficulty: 0) +(@OGUID+66, 180425, 0, 85, 159, '0', 0, 0, 2262.538330078125, 329.243072509765625, 34.74338531494140625, 0.122172988951206207, 0, 0, 0.061048507690429687, 0.998134791851043701, 120, 255, 1, 45745), -- SkullCandle01 (Area: Brill - Difficulty: 0) +(@OGUID+67, 180425, 0, 85, 159, '0', 0, 0, 2267.710205078125, 290.73785400390625, 35.65375900268554687, 0.750490784645080566, 0, 0, 0.3665008544921875, 0.93041771650314331, 120, 255, 1, 45745), -- SkullCandle01 (Area: Brill - Difficulty: 0) +(@OGUID+68, 180425, 0, 85, 159, '0', 0, 0, 2267.09033203125, 290.15277099609375, 35.63885116577148437, 4.049167633056640625, 0, 0, -0.89879322052001953, 0.438372820615768432, 120, 255, 1, 45745), -- SkullCandle01 (Area: Brill - Difficulty: 0) +(@OGUID+69, 180425, 0, 85, 159, '0', 0, 0, 2241.39404296875, 272.229156494140625, 35.33657073974609375, 1.308995485305786132, 0, 0, 0.608760833740234375, 0.793353796005249023, 120, 255, 1, 45745), -- SkullCandle01 (Area: Brill - Difficulty: 0) +(@OGUID+70, 180425, 0, 85, 159, '0', 0, 0, 2239.83154296875, 272.664947509765625, 35.36143112182617187, 1.186823248863220214, 0, 0, 0.559192657470703125, 0.829037725925445556, 120, 255, 1, 45745), -- SkullCandle01 (Area: Brill - Difficulty: 0) +(@OGUID+71, 180426, 0, 85, 159, '0', 0, 0, 2263.7275390625, 288.914947509765625, 44.90937042236328125, 3.351046562194824218, 0, 0, -0.99452114105224609, 0.104535527527332305, 120, 255, 1, 45745), -- Bat01 (Area: Brill - Difficulty: 0) +(@OGUID+72, 180426, 0, 85, 159, '0', 0, 0, 2260.861083984375, 292.28125, 45.84617996215820312, 1.134462952613830566, 0, 0, 0.537299156188964843, 0.843391716480255126, 120, 255, 1, 45745), -- Bat01 (Area: Brill - Difficulty: 0) +(@OGUID+73, 180426, 0, 85, 159, '0', 0, 0, 2262.803955078125, 290.63714599609375, 45.96056365966796875, 4.869470596313476562, 0, 0, -0.64944744110107421, 0.760406434535980224, 120, 255, 1, 45745), -- Bat01 (Area: Brill - Difficulty: 0) +(@OGUID+74, 180426, 0, 85, 159, '0', 0, 0, 2261.6806640625, 289.217010498046875, 47.07680130004882812, 4.520402908325195312, 0, 0, -0.77162456512451171, 0.636078238487243652, 120, 255, 1, 45745), -- Bat01 (Area: Brill - Difficulty: 0) +(@OGUID+75, 180426, 0, 85, 159, '0', 0, 0, 2260.68408203125, 289.57464599609375, 54.01663589477539062, 4.084071159362792968, 0, 0, -0.8910064697265625, 0.453990638256072998, 120, 255, 1, 45745), -- Bat01 (Area: Brill - Difficulty: 0) +(@OGUID+76, 180426, 0, 85, 159, '0', 0, 0, 2260.53466796875, 285.626739501953125, 45.98318099975585937, 0.645771682262420654, 0, 0, 0.317304611206054687, 0.948323667049407958, 120, 255, 1, 45745), -- Bat01 (Area: Brill - Difficulty: 0) +(@OGUID+77, 180426, 0, 85, 159, '0', 0, 0, 2260.9306640625, 287.453125, 45.70987319946289062, 3.961898565292358398, 0, 0, -0.91705989837646484, 0.398749500513076782, 120, 255, 1, 45745), -- Bat01 (Area: Brill - Difficulty: 0) +(@OGUID+78, 180426, 0, 85, 159, '0', 0, 0, 2263.53466796875, 286.48785400390625, 45.85614395141601562, 5.462882041931152343, 0, 0, -0.39874839782714843, 0.917060375213623046, 120, 255, 1, 45745), -- Bat01 (Area: Brill - Difficulty: 0) +(@OGUID+79, 180426, 0, 85, 159, '0', 0, 0, 2262.95654296875, 287.760406494140625, 45.75661849975585937, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 120, 255, 1, 45745), -- Bat01 (Area: Brill - Difficulty: 0) +(@OGUID+80, 180426, 0, 85, 159, '0', 0, 0, 2264.888916015625, 287.03125, 51.21295547485351562, 3.071766138076782226, 0, 0, 0.999390602111816406, 0.034906134009361267, 120, 255, 1, 45745), -- Bat01 (Area: Brill - Difficulty: 0) +(@OGUID+81, 180427, 0, 85, 159, '0', 0, 0, 2260.732666015625, 291.78125, 45.87396621704101562, 4.869470596313476562, 0, 0, -0.64944744110107421, 0.760406434535980224, 120, 255, 1, 45745), -- Bat02 (Area: Brill - Difficulty: 0) +(@OGUID+82, 180427, 0, 85, 159, '0', 0, 0, 2257.78125, 290.126739501953125, 45.70293426513671875, 4.345870018005371093, 0, 0, -0.82412624359130859, 0.566406130790710449, 120, 255, 1, 45745), -- Bat02 (Area: Brill - Difficulty: 0) +(@OGUID+83, 180427, 0, 85, 159, '0', 0, 0, 2259.41845703125, 290.055572509765625, 41.71333694458007812, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 120, 255, 1, 45745), -- Bat02 (Area: Brill - Difficulty: 0) +(@OGUID+84, 180427, 0, 85, 159, '0', 0, 0, 2261.864501953125, 291.34375, 51.23927688598632812, 6.195919513702392578, 0, 0, -0.04361915588378906, 0.999048233032226562, 120, 255, 1, 45745), -- Bat02 (Area: Brill - Difficulty: 0) +(@OGUID+85, 180427, 0, 85, 159, '0', 0, 0, 2261.73779296875, 290.5069580078125, 47.17763137817382812, 0.24434557557106018, 0, 0, 0.121869087219238281, 0.9925462007522583, 120, 255, 1, 45745), -- Bat02 (Area: Brill - Difficulty: 0) +(@OGUID+86, 180427, 0, 85, 159, '0', 0, 0, 2259.001708984375, 291.609375, 45.74871063232421875, 3.351046562194824218, 0, 0, -0.99452114105224609, 0.104535527527332305, 120, 255, 1, 45745), -- Bat02 (Area: Brill - Difficulty: 0) +(@OGUID+87, 180427, 0, 85, 159, '0', 0, 0, 2259.4306640625, 288.4757080078125, 45.70293426513671875, 2.967041015625, 0, 0, 0.996193885803222656, 0.087165042757987976, 120, 255, 1, 45745), -- Bat02 (Area: Brill - Difficulty: 0) +(@OGUID+88, 180427, 0, 85, 159, '0', 0, 0, 2257.505126953125, 288.4913330078125, 41.71333694458007812, 2.687806606292724609, 0, 0, 0.974370002746582031, 0.224951311945915222, 120, 255, 1, 45745), -- Bat02 (Area: Brill - Difficulty: 0) +(@OGUID+89, 180427, 0, 85, 159, '0', 0, 0, 2259.5087890625, 286.65277099609375, 48.82779312133789062, 1.256635904312133789, 0, 0, 0.587784767150878906, 0.809017360210418701, 120, 255, 1, 45745), -- Bat02 (Area: Brill - Difficulty: 0) +(@OGUID+90, 180427, 0, 85, 159, '0', 0, 0, 2258.489501953125, 287.513885498046875, 48.70108413696289062, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 45745), -- Bat02 (Area: Brill - Difficulty: 0) +(@OGUID+91, 180428, 0, 85, 159, '0', 0, 0, 2272.263916015625, 283.392364501953125, 33.96635055541992187, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 120, 255, 1, 45745), -- G_WitchBroom_01 scale 0.5 (Area: Brill - Difficulty: 0) +(@OGUID+92, 180471, 0, 85, 159, '0', 0, 0, 2288.29345703125, 391.09027099609375, 35.74422073364257812, 2.007128477096557617, 0, 0, 0.84339141845703125, 0.537299633026123046, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+93, 180471, 0, 85, 159, '0', 0, 0, 2273.23779296875, 422.072906494140625, 35.44816970825195312, 0.767943859100341796, 0, 0, 0.374606132507324218, 0.927184045314788818, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+94, 180471, 0, 85, 159, '0', 0, 0, 2269.43408203125, 374.76910400390625, 43.201812744140625, 5.305802345275878906, 0, 0, -0.46947097778320312, 0.882947921752929687, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+95, 180471, 0, 85, 159, '0', 0, 0, 2280.43408203125, 422.508697509765625, 35.49641799926757812, 0.366517573595046997, 0, 0, 0.182234764099121093, 0.98325502872467041, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+96, 180471, 0, 85, 159, '0', 0, 0, 2255.104248046875, 314.03125, 39.51722335815429687, 4.852017402648925781, 0, 0, -0.65605831146240234, 0.754710197448730468, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+97, 180471, 0, 85, 159, '0', 0, 0, 2267.272705078125, 319.501739501953125, 35.19652175903320312, 4.572763919830322265, 0, 0, -0.75470924377441406, 0.656059443950653076, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+98, 180471, 0, 85, 159, '0', 0, 0, 2268.376708984375, 292.3819580078125, 35.31812667846679687, 1.186823248863220214, 0, 0, 0.559192657470703125, 0.829037725925445556, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+99, 180471, 0, 85, 159, '0', 0, 0, 2295.763916015625, 291.114593505859375, 39.42935562133789062, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+100, 180471, 0, 85, 159, '0', 0, 0, 2256.24658203125, 299.130218505859375, 35.34776687622070312, 2.984498262405395507, 0, 0, 0.996916770935058593, 0.078466430306434631, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+101, 180471, 0, 85, 159, '0', 0, 0, 2299.0556640625, 290.432281494140625, 39.32700347900390625, 6.03883981704711914, 0, 0, -0.12186908721923828, 0.9925462007522583, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+102, 180471, 0, 85, 159, '0', 0, 0, 2293.848876953125, 270.4444580078125, 39.62081146240234375, 1.169368624687194824, 0, 0, 0.551936149597167968, 0.833886384963989257, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+103, 180471, 0, 85, 159, '0', 0, 0, 2294.842041015625, 269.989593505859375, 39.54152297973632812, 1.466075778007507324, 0, 0, 0.669130325317382812, 0.74314504861831665, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+104, 180471, 0, 85, 159, '0', 0, 0, 2264.032958984375, 280.7100830078125, 35.255340576171875, 3.52557229995727539, 0, 0, -0.98162651062011718, 0.190812408924102783, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+105, 180471, 0, 85, 159, '0', 0, 0, 2293.100830078125, 270.182281494140625, 39.17103958129882812, 1.48352813720703125, 0, 0, 0.675589561462402343, 0.737277925014495849, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+106, 180471, 0, 85, 159, '0', 0, 0, 2242.59375, 255.0069427490234375, 35.3006591796875, 1.867502212524414062, 0, 0, 0.803856849670410156, 0.594822824001312255, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+107, 180471, 0, 85, 159, '0', 0, 0, 2325.6962890625, 237.013885498046875, 30.36153793334960937, 4.433136463165283203, 0, 0, -0.79863548278808593, 0.60181504487991333, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+108, 180471, 0, 85, 159, '0', 0, 0, 2324.482666015625, 228.5989532470703125, 30.03060531616210937, 4.433136463165283203, 0, 0, -0.79863548278808593, 0.60181504487991333, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+109, 180471, 0, 85, 159, '0', 0, 0, 2185.1806640625, 242.9791717529296875, 37.70568084716796875, 3.054326534271240234, 0, 0, 0.999048233032226562, 0.043619260191917419, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+110, 180471, 0, 85, 159, '0', 0, 0, 2192.90625, 231.84375, 37.04900741577148437, 0.541050612926483154, 0, 0, 0.267237663269042968, 0.96363067626953125, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Brill - Difficulty: 0) +(@OGUID+111, 180472, 0, 85, 159, '0', 0, 0, 2263.897705078125, 344.836822509765625, 38.86483001708984375, 2.216565132141113281, 0, 0, 0.894933700561523437, 0.44619917869567871, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: Brill - Difficulty: 0) +(@OGUID+112, 180472, 0, 85, 159, '0', 0, 0, 2256.123291015625, 316.041656494140625, 40.66569900512695312, 3.001946926116943359, 0, 0, 0.997563362121582031, 0.069766148924827575, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: Brill - Difficulty: 0) +(@OGUID+113, 180472, 0, 85, 159, '0', 0, 0, 2253.87841796875, 312.16839599609375, 40.70804977416992187, 2.391098499298095703, 0, 0, 0.930417060852050781, 0.366502493619918823, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: Brill - Difficulty: 0) +(@OGUID+114, 180472, 0, 85, 159, '0', 0, 0, 2310.4375, 277.75, 31.71162986755371093, 6.09120035171508789, 0, 0, -0.09584522247314453, 0.995396256446838378, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: Brill - Difficulty: 0) +(@OGUID+115, 180472, 0, 85, 159, '0', 0, 0, 2255.69091796875, 268.942718505859375, 38.70105361938476562, 0.052358884364366531, 0, 0, 0.02617645263671875, 0.999657332897186279, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: Brill - Difficulty: 0) +(@OGUID+116, 180472, 0, 85, 159, '0', 0, 0, 2241.947998046875, 239.3506927490234375, 40.92840576171875, 5.305802345275878906, 0, 0, -0.46947097778320312, 0.882947921752929687, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: Brill - Difficulty: 0) +(@OGUID+117, 180523, 0, 85, 159, '0', 0, 0, 2289.8369140625, 286.477447509765625, 33.24811553955078125, 0.24434557557106018, 0, 0, 0.121869087219238281, 0.9925462007522583, 120, 255, 1, 45745), -- Apple Bob (Area: Brill - Difficulty: 0) +(@OGUID+118, 186234, 0, 85, 159, '0', 0, 0, 2221.625, 275.9288330078125, 33.71171951293945312, 3.263772249221801757, 0, 0, -0.99813461303710937, 0.061051756143569946, 120, 255, 1, 45745), -- Water Barrel (Area: Brill - Difficulty: 0) +(@OGUID+119, 186234, 0, 85, 159, '0', 0, 0, 2254.413330078125, 474.39410400390625, 33.878875732421875, 2.792518377304077148, 0, 0, 0.984807014465332031, 0.173652306199073791, 120, 255, 1, 45745), -- Water Barrel (Area: Brill - Difficulty: 0) +(@OGUID+120, 186614, 0, 85, 159, '0', 0, 0, 2255.53125, 476.2725830078125, 33.83548355102539062, 4.310965538024902343, 0, 0, -0.83388519287109375, 0.55193793773651123, 120, 255, 1, 45745), -- Water Bucket (Area: Brill - Difficulty: 0) +(@OGUID+121, 186614, 0, 85, 159, '0', 0, 0, 2255.864501953125, 473.28472900390625, 33.88770294189453125, 4.171337604522705078, 0, 0, -0.87035560607910156, 0.492423713207244873, 120, 255, 1, 45745), -- Water Bucket (Area: Brill - Difficulty: 0) +(@OGUID+122, 186614, 0, 85, 159, '0', 0, 0, 2222.963623046875, 277.90277099609375, 33.5111083984375, 1.797688722610473632, 0, 0, 0.7826080322265625, 0.622514784336090087, 120, 255, 1, 45745), -- Water Bucket (Area: Brill - Difficulty: 0) +(@OGUID+123, 186614, 0, 85, 159, '0', 0, 0, 2222.435791015625, 273.6319580078125, 33.48462295532226562, 2.70525527000427246, 0, 0, 0.97629547119140625, 0.216442063450813293, 120, 255, 1, 45745), -- Water Bucket (Area: Brill - Difficulty: 0) +(@OGUID+124, 186615, 0, 85, 159, '0', 0, 0, 2254.22216796875, 476.39410400390625, 33.8637542724609375, 1.448621988296508789, 0, 0, 0.662619590759277343, 0.748956084251403808, 120, 255, 1, 45745), -- Water Buckets (Area: Brill - Difficulty: 0) +(@OGUID+125, 186615, 0, 85, 159, '0', 0, 0, 2224.244873046875, 275.385406494140625, 33.46975326538085937, 5.84685373306274414, 0, 0, -0.21643924713134765, 0.976296067237854003, 120, 255, 1, 45745), -- Water Buckets (Area: Brill - Difficulty: 0) +(@OGUID+126, 186720, 0, 85, 159, '0', 0, 0, 2240.4375, 459.15972900390625, 38.43698883056640625, 0.820303261280059814, 0, 0, 0.398748397827148437, 0.917060375213623046, 120, 255, 1, 45745), -- Fire Effigy (Area: Brill - Difficulty: 0) +(@OGUID+127, 186720, 0, 85, 159, '0', 0, 0, 2230.421875, 464.664947509765625, 40.62353134155273437, 0.401424884796142578, 0, 0, 0.199367523193359375, 0.979924798011779785, 120, 255, 1, 45745), -- Fire Effigy (Area: Brill - Difficulty: 0) +(@OGUID+128, 186720, 0, 85, 159, '0', 0, 0, 2235.046875, 472.654510498046875, 37.98011398315429687, 0.104719325900077819, 0, 0, 0.052335739135742187, 0.998629570007324218, 120, 255, 1, 45745), -- Fire Effigy (Area: Brill - Difficulty: 0) +(@OGUID+129, 186720, 0, 85, 159, '0', 0, 0, 2239.491455078125, 487.861114501953125, 37.34464263916015625, 5.567600727081298828, 0, 0, -0.35020732879638671, 0.936672210693359375, 120, 255, 1, 45745), -- Fire Effigy (Area: Brill - Difficulty: 0) +(@OGUID+130, 186720, 0, 85, 159, '0', 0, 0, 2231.30029296875, 482.6163330078125, 39.66044235229492187, 5.95157480239868164, 0, 0, -0.16504669189453125, 0.986285746097564697, 120, 255, 1, 45745), -- Fire Effigy (Area: Brill - Difficulty: 0) +(@OGUID+131, 190066, 0, 85, 159, '0', 0, 0, 2288.75341796875, 277.498260498046875, 33.25130081176757812, 3.735006093978881835, 0, 0, -0.95630455017089843, 0.292372345924377441, 120, 255, 1, 45745); -- Candy Bucket (Area: Brill - Difficulty: 0) + +-- Event spawns +DELETE FROM `game_event_creature` WHERE `eventEntry`=12 AND `guid` BETWEEN @CGUID+0 AND @CGUID+49; +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), +(12, @CGUID+47), +(12, @CGUID+48), +(12, @CGUID+49); + +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+131; +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); diff --git a/sql/updates/world/master/2023_11_06_11_world_tirisfal_glades_the_bulwark.sql b/sql/updates/world/master/2023_11_06_11_world_tirisfal_glades_the_bulwark.sql new file mode 100644 index 00000000000..9cc7357d65c --- /dev/null +++ b/sql/updates/world/master/2023_11_06_11_world_tirisfal_glades_the_bulwark.sql @@ -0,0 +1,157 @@ +SET @OGUID := 3003303; + +-- Gameobject templates +UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=51886 WHERE `entry`=208149; -- Candy Bucket + +UPDATE `gameobject_template_addon` SET `faction`=1735 WHERE `entry`=208149; -- Candy Bucket + +-- Quests +DELETE FROM `quest_offer_reward` WHERE `ID`=28972; +INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES +(28972, 0, 0, 0, 0, 0, 0, 0, 0, 'Candy buckets like this are located in inns throughout the realms. Go ahead... take some!', 51886); -- Candy Bucket + +DELETE FROM `gameobject_queststarter` WHERE `id`=208149; +INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(208149, 28972, 51886); + +UPDATE `gameobject_questender` SET `VerifiedBuild`=51886 WHERE (`id`=208149 AND `quest`=28972); + +DELETE FROM `game_event_gameobject_quest` WHERE `id`=208149; + +-- Old gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN 229442 AND 229497; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 229710 AND 229763; +DELETE FROM `gameobject` WHERE `guid`=231991; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 229442 AND 229497; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 229710 AND 229763; +DELETE FROM `game_event_gameobject` WHERE `guid`=231991; + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+60; +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, 85, 152, '0', 0, 0, 1715.34375, -692.36981201171875, 54.65004730224609375, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+1, 180405, 0, 85, 152, '0', 0, 0, 1673.3992919921875, -721.58856201171875, 58.81418228149414062, 2.70525527000427246, 0, 0, 0.97629547119140625, 0.216442063450813293, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+2, 180406, 0, 85, 152, '0', 0, 0, 1689.861083984375, -733.29168701171875, 58.94339370727539062, 2.67034769058227539, 0, 0, 0.972369194030761718, 0.233448356389999389, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+3, 180406, 0, 85, 152, '0', 0, 0, 1697.5086669921875, -694.58160400390625, 54.088714599609375, 3.281238555908203125, 0, 0, -0.99756336212158203, 0.069766148924827575, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+4, 180407, 0, 85, 152, '0', 0, 0, 1682.62158203125, -730.8524169921875, 68.0818023681640625, 2.844882726669311523, 0, 0, 0.989015579223632812, 0.147811368107795715, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+5, 180407, 0, 85, 152, '0', 0, 0, 1725.670166015625, -757.0711669921875, 59.10930633544921875, 4.363324165344238281, 0, 0, -0.81915187835693359, 0.573576688766479492, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+6, 180410, 0, 85, 152, '0', 0, 0, 1758.954833984375, -733.09552001953125, 61.3712310791015625, 1.500982880592346191, 0, 0, 0.681998252868652343, 0.731353819370269775, 120, 255, 1, 51886), -- G_HangingSkeleton_01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+7, 180411, 0, 85, 152, '0', 0, 0, 1724.251708984375, -760.88714599609375, 60.7620391845703125, 5.637413978576660156, 0, 0, -0.31730461120605468, 0.948323667049407958, 120, 255, 1, 51886), -- G_Ghost_01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+8, 180415, 0, 85, 152, '0', 0, 0, 1755.48095703125, -728.671875, 60.70103073120117187, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+9, 180415, 0, 85, 152, '0', 0, 0, 1672.6649169921875, -724.77606201171875, 60.12980270385742187, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+10, 180415, 0, 85, 152, '0', 0, 0, 1766.4913330078125, -730.36114501953125, 60.90683364868164062, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+11, 180415, 0, 85, 152, '0', 0, 0, 1671.30908203125, -722.1961669921875, 59.49248123168945312, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+12, 180415, 0, 85, 152, '0', 0, 0, 1741.3836669921875, -728.83331298828125, 60.66893768310546875, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+13, 180415, 0, 85, 152, '0', 0, 0, 1672.0555419921875, -723.76043701171875, 60.47997283935546875, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+14, 180425, 0, 85, 152, '0', 0, 0, 1673.1163330078125, -723.8992919921875, 59.52499008178710937, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- SkullCandle01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+15, 180425, 0, 85, 152, '0', 0, 0, 1755.2291259765625, -729.8507080078125, 61.12210464477539062, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- SkullCandle01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+16, 180426, 0, 85, 152, '0', 0, 0, 1715.2882080078125, -737.232666015625, 77.0455780029296875, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+17, 180426, 0, 85, 152, '0', 0, 0, 1703.5538330078125, -721.4149169921875, 75.6016845703125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+18, 180426, 0, 85, 152, '0', 0, 0, 1686.060791015625, -714.763916015625, 80.02059173583984375, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+19, 180426, 0, 85, 152, '0', 0, 0, 1731.904541015625, -719.47052001953125, 81.0478973388671875, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+20, 180426, 0, 85, 152, '0', 0, 0, 1707.9791259765625, -723.20831298828125, 75.00325775146484375, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+21, 180426, 0, 85, 152, '0', 0, 0, 1730.4913330078125, -719.98614501953125, 80.9859619140625, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+22, 180426, 0, 85, 152, '0', 0, 0, 1754.4271240234375, -717.23089599609375, 81.18017578125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+23, 180426, 0, 85, 152, '0', 0, 0, 1747.1129150390625, -712.765625, 81.20735931396484375, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+24, 180426, 0, 85, 152, '0', 0, 0, 1684.74658203125, -718.58331298828125, 80.0290985107421875, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+25, 180427, 0, 85, 152, '0', 0, 0, 1709.423583984375, -738.16143798828125, 54.85278701782226562, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat02 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+26, 180427, 0, 85, 152, '0', 0, 0, 1733.9600830078125, -717.13018798828125, 60.06647491455078125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat02 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+27, 180427, 0, 85, 152, '0', 0, 0, 1689.048583984375, -716.25518798828125, 58.59185791015625, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat02 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+28, 180427, 0, 85, 152, '0', 0, 0, 1741.060791015625, -721.17364501953125, 81.17830657958984375, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat02 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+29, 180427, 0, 85, 152, '0', 0, 0, 1720.9635009765625, -727.13714599609375, 57.56277084350585937, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat02 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+30, 180427, 0, 85, 152, '0', 0, 0, 1706.9322509765625, -720.44793701171875, 53.83124923706054687, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Bat02 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+31, 180471, 0, 85, 152, '0', 0, 0, 1740.7899169921875, -733.52081298828125, 62.98698043823242187, 4.014260292053222656, 0, 0, -0.90630722045898437, 0.422619491815567016, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+32, 180471, 0, 85, 152, '0', 0, 0, 1775.0382080078125, -728.12677001953125, 64.039581298828125, 5.986480236053466796, 0, 0, -0.14780902862548828, 0.989015936851501464, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+33, 180471, 0, 85, 152, '0', 0, 0, 1746.907958984375, -737.78472900390625, 63.59131622314453125, 1.047197580337524414, 0, 0, 0.5, 0.866025388240814208, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+34, 180471, 0, 85, 152, '0', 0, 0, 1679.73095703125, -728.26739501953125, 62.67742919921875, 4.066620349884033203, 0, 0, -0.89493370056152343, 0.44619917869567871, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+35, 180471, 0, 85, 152, '0', 0, 0, 1668.43408203125, -721.28643798828125, 62.11988067626953125, 2.635444164276123046, 0, 0, 0.96814727783203125, 0.250381410121917724, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+36, 180471, 0, 85, 152, '0', 0, 0, 1669.765625, -726.3975830078125, 62.13672637939453125, 1.099556446075439453, 0, 0, 0.522498130798339843, 0.852640450000762939, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+37, 180471, 0, 85, 152, '0', 0, 0, 1664.720458984375, -727.670166015625, 62.10521697998046875, 5.777040958404541015, 0, 0, -0.25037956237792968, 0.968147754669189453, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+38, 180471, 0, 85, 152, '0', 0, 0, 1772.9427490234375, -724.46875, 64.0744171142578125, 4.328419685363769531, 0, 0, -0.82903671264648437, 0.559194147586822509, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+39, 180471, 0, 85, 152, '0', 0, 0, 1776.65283203125, -722.3680419921875, 64.10593414306640625, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+40, 180471, 0, 85, 152, '0', 0, 0, 1761.0225830078125, -730.61981201171875, 61.90310287475585937, 2.408554315567016601, 0, 0, 0.933580398559570312, 0.358368009328842163, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+41, 180471, 0, 85, 152, '0', 0, 0, 1685.1285400390625, -727.70489501953125, 62.906982421875, 2.234017848968505859, 0, 0, 0.898793220520019531, 0.438372820615768432, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+42, 180471, 0, 85, 152, '0', 0, 0, 1756.9375, -730.763916015625, 61.89927291870117187, 3.961898565292358398, 0, 0, -0.91705989837646484, 0.398749500513076782, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+43, 180471, 0, 85, 152, '0', 0, 0, 1680.19970703125, -733.76214599609375, 62.83770751953125, 5.585053920745849609, 0, 0, -0.34202003479003906, 0.939692676067352294, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+44, 180471, 0, 85, 152, '0', 0, 0, 1741.65283203125, -738.685791015625, 62.93024444580078125, 5.672322273254394531, 0, 0, -0.3007049560546875, 0.953717231750488281, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+45, 180471, 0, 85, 152, '0', 0, 0, 1685.7066650390625, -733.1336669921875, 62.80352020263671875, 0.942476630210876464, 0, 0, 0.453989982604980468, 0.891006767749786376, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+46, 180471, 0, 85, 152, '0', 0, 0, 1778.751708984375, -726.10418701171875, 64.1016387939453125, 1.308995485305786132, 0, 0, 0.608760833740234375, 0.793353796005249023, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+47, 180471, 0, 85, 152, '0', 0, 0, 1757.0816650390625, -734.265625, 62.10749053955078125, 5.305802345275878906, 0, 0, -0.46947097778320312, 0.882947921752929687, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+48, 180471, 0, 85, 152, '0', 0, 0, 1663.4132080078125, -722.73785400390625, 62.13486099243164062, 4.1538848876953125, 0, 0, -0.8746194839477539, 0.484810054302215576, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+49, 180471, 0, 85, 152, '0', 0, 0, 1760.5069580078125, -734.29168701171875, 62.13278579711914062, 0.959929943084716796, 0, 0, 0.461748123168945312, 0.887011110782623291, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+50, 180471, 0, 85, 152, '0', 0, 0, 1745.875, -732.55902099609375, 63.63408279418945312, 2.513273954391479492, 0, 0, 0.951056480407714843, 0.309017121791839599, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+51, 180472, 0, 85, 152, '0', 0, 0, 1754.420166015625, -732.795166015625, 65.67305755615234375, 2.862335443496704101, 0, 0, 0.990267753601074218, 0.139175355434417724, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+52, 180472, 0, 85, 152, '0', 0, 0, 1759.032958984375, -728.51043701171875, 65.90134429931640625, 1.745326757431030273, 0, 0, 0.766043663024902343, 0.642788589000701904, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+53, 180472, 0, 85, 152, '0', 0, 0, 1763.3941650390625, -732.67706298828125, 66.06093597412109375, 1.204277276992797851, 0, 0, 0.56640625, 0.824126183986663818, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+54, 180472, 0, 85, 152, '0', 0, 0, 1666.5885009765625, -724.52606201171875, 63.60851287841796875, 1.047197580337524414, 0, 0, 0.5, 0.866025388240814208, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+55, 180523, 0, 85, 152, '0', 0, 0, 1662.63720703125, -716.5242919921875, 59.26189041137695312, 6.056293010711669921, 0, 0, -0.11320304870605468, 0.993571877479553222, 120, 255, 1, 51886), -- Apple Bob (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+56, 208056, 0, 85, 152, '0', 0, 0, 1665.703125, -723.0850830078125, 62.45366668701171875, 3.996806621551513671, 0, 0, -0.90996074676513671, 0.414694398641586303, 120, 255, 1, 51886), -- G_Ghost_01 (Scale 0.5) (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+57, 208057, 0, 85, 152, '0', 0, 0, 1687.873291015625, -787.15106201171875, 98.37052154541015625, 0.488691210746765136, 0, 0, 0.241921424865722656, 0.970295846462249755, 120, 255, 1, 51886), -- G_Pumpkin_01 Scale 2.0 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+58, 208061, 0, 85, 152, '0', 0, 0, 1743.93408203125, -788.3038330078125, 103.1657333374023437, 0.488691210746765136, 0, 0, 0.241921424865722656, 0.970295846462249755, 120, 255, 1, 51886), -- G_Pumpkin_02 Scale 2.0 (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+59, 208063, 0, 85, 152, '0', 0, 0, 1664.6197509765625, -723.63543701171875, 60.51529312133789062, 4.188792228698730468, 0, 0, -0.86602497100830078, 0.50000077486038208, 120, 255, 1, 51886), -- Web Hanging (Area: The Bulwark - Difficulty: 0) CreateObject1 +(@OGUID+60, 208149, 0, 85, 152, '0', 0, 0, 1666.3385009765625, -719.3194580078125, 58.91488265991210937, 2.460912704467773437, 0, 0, 0.942641258239746093, 0.333807557821273803, 120, 255, 1, 51886); -- Candy Bucket (Area: The Bulwark - Difficulty: 0) CreateObject1 + +-- Event spawns +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+60; +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); |