diff options
| -rw-r--r-- | sql/updates/world/master/2023_02_20_06_world.sql | 372 |
1 files changed, 372 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_02_20_06_world.sql b/sql/updates/world/master/2023_02_20_06_world.sql new file mode 100644 index 00000000000..2cf86e5561d --- /dev/null +++ b/sql/updates/world/master/2023_02_20_06_world.sql @@ -0,0 +1,372 @@ +SET @CGUID := 3000026; +SET @OGUID := 3000720; +SET @EVENT := 8; + +-- Creature templates +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `speed_run`=1, `unit_flags`=32768 WHERE `entry`=38039; -- Kwee Q. Peddlefeet +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `unit_flags`=33587456, `flags_extra`=`flags_extra`|128 WHERE `entry`=37981; -- [DND] Love Boat Summoner 03 +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `speed_run`=1, `unit_flags`=33536, `unit_flags2`=67127296, `unit_flags3`=17301504 WHERE `entry`=37980; -- Darnassus Love Boat + +DELETE FROM `creature_template_addon` WHERE `entry` IN (37981, 37980); +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(37981, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- 37981 ([DND] Love Boat Summoner 03) +(37980, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''); -- 37980 (Darnassus Love Boat) + +DELETE FROM `creature_template_movement` WHERE `CreatureId` IN (37980, 37981); +INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`, `InteractionPauseTimer`) VALUES +(37980, 0, 1, 1, 0, 0, 0, NULL), +(37981, 0, 0, 1, 0, 0, 0, NULL); + +-- Equipments +UPDATE `creature_equip_template` SET `VerifiedBuild`=48069 WHERE (`ID`=1 AND `CreatureID` IN (118905,52644,52643,52642,52641,52640,52637,52636,52292,51371,50715,50714,50690,50502,50501,50500,50499,50498,50497,47584,47569,36506,36479,35281,34989,34988,30715,17105,14380,14379,14378,11709,11083,11070,11042,11041,10118,10089,9047,8396,8026,7999,7907,7740,7315,7296,6735,6292,6142,5782,4262,4235,4234,4233,4232,4231,4230,4226,4223,4222,4221,4220,4219,4218,4217,4216,4215,4214,4210,4205,4204,4203,4180,4173,4171,4169,4165,4163,4160,4156,4146,4138,4092,4091,4089,4088,4087,3607,3561,2796)); + +-- Models +UPDATE `creature_model_info` SET `VerifiedBuild`=48069 WHERE `DisplayID` IN (87510, 87505, 74962, 74961, 74960, 74959, 74958, 74956, 74955, 74949, 74946, 74947, 74948, 74952, 74950, 74953, 74951, 74941, 47931, 47928, 38001, 38000, 37999, 37998, 37997, 37996, 37995, 37994, 37822, 37402, 36942, 36943, 36875, 37106, 37107, 37113, 37101, 37102, 37110, 37118, 37049, 37047, 37048, 37046, 30813, 30328, 30812, 33224, 29959, 29958, 29935, 29956, 29957, 29960, 36956, 36952, 36944, 36957, 62734, 6302, 29290, 12769, 35708, 35693, 35095, 37377, 29301, 1750, 30874, 30156, 30120, 29735, 29511, 29510, 27296, 27263, 16856, 14419, 14418, 14417, 6297, 6295, 1924, 11664, 11048, 10615, 10616, 10592, 10582, 10574, 10573, 9344, 9339, 9275, 8354, 7996, 7602, 7275, 39620, 7026, 7025, 6840, 6349, 6071, 6063, 5439, 4985, 5083, 5186, 4271, 3131, 3001, 5225, 5084, 5226, 9055, 14615, 780, 613, 9956, 2262, 2246, 2271, 2249, 2258, 2277, 2264, 2274, 2265, 2254, 2276, 2255, 2250, 2261, 2245, 2243, 2252, 2266, 2242, 2259, 2251, 2253, 2230, 2229, 2226, 2224, 2222, 2219, 2218, 2217, 2214, 7669, 2199, 2231, 2216, 10624, 2213, 2210, 2206, 2205, 2202, 2201, 2198, 2197, 2196, 1931, 1718, 2233, 1665, 2232); + +-- Scaling +DELETE FROM `creature_template_scaling` WHERE (`DifficultyID`=0 AND `Entry` IN (38039,37981,37980)); +INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES +(38039, 0, 0, 0, 378, 48069), +(37981, 0, 0, 0, 378, 48069), +(37980, 0, 0, 0, 378, 48069); + +UPDATE `creature_template_scaling` SET `VerifiedBuild`=48069 WHERE (`DifficultyID`=0 AND `Entry` IN (141903,141900,118921,118920,118919,118918,118917,118916,118905,118900,118899,118891,62450,62178,62177,61757,61071,53522,52645,52644,52643,52642,52641,52640,52637,52636,52292,51504,51371,50715,50714,50690,50521,50520,50519,50518,50517,50516,50513,50510,50509,50508,50507,50506,50505,50504,50502,50501,50500,50499,50498,50497,49842,49778,49728,48735,48624,48623,47584,47569,43845,42970,42968,42936,40552,36506,36479,35281,34989,34988,34396,30731,30715,17105,15679,15678,15384,14380,14379,14378,13321,11709,11700,11401,11083,11081,11070,11050,11042,11041,10118,10089,10056,9047,8723,8669,8396,8026,7999,7916,7907,7740,7316,7315,7296,6735,6292,6142,6034,5782,5191,5047,4786,4784,4783,4521,4262,4244,4243,4242,4241,4240,4236,4235,4234,4233,4232,4231,4230,4229,4228,4226,4225,4223,4222,4221,4220,4219,4218,4217,4216,4215,4214,4213,4212,4211,4210,4209,4208,4205,4204,4203,4181,4180,4177,4175,4173,4172,4171,4170,4169,4168,4165,4164,4163,4161,4160,4159,4156,4155,4146,4138,4092,4091,4089,4088,4087,3838,3607,3561,3468,2912,2796)); + +-- Quests +UPDATE `quest_template` SET `Expansion`=9, `VerifiedBuild`=48069 WHERE `ID`=24610; -- A Gift for the High Priestess of Elune + +UPDATE `quest_poi` SET `VerifiedBuild`=48069 WHERE (`QuestID`=24610 AND `BlobIndex`=0 AND `Idx1`=2) OR (`QuestID`=24610 AND `BlobIndex`=1 AND `Idx1`=1) OR (`QuestID`=24610 AND `BlobIndex`=0 AND `Idx1`=0); + +UPDATE `quest_poi_points` SET `VerifiedBuild`=48069 WHERE (`QuestID`=24610 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=24610 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=24610 AND `Idx1`=0 AND `Idx2`=0); + +DELETE FROM `quest_details` WHERE `ID`=24610; +INSERT INTO `quest_details` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `VerifiedBuild`) VALUES +(24610, 0, 0, 0, 0, 0, 0, 0, 0, 48069); -- A Gift for the High Priestess of Elune + +DELETE FROM `creature_queststarter` WHERE (`id`=38039 AND `quest`=24610); +INSERT INTO `creature_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(38039, 24610, 48069); -- A Gift for the High Priestess of Elune offered Kwee Q. Peddlefeet + +DELETE FROM `game_event_creature_quest` WHERE (`id`=38039 AND `quest`=24610); + +-- Old creature spawns +DELETE FROM `creature` WHERE `guid`=52031; +DELETE FROM `game_event_creature` WHERE `guid`=52031; + +-- Creature spawns +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+5; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(@CGUID+0, 37674, 1, 1657, 1662, '0', 0, 0, 0, 0, 9870.9501953125, 2492.469970703125, 1317.1134033203125, 5.969026088714599609, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 48069), -- Lovely Merchant (Area: Tradesmen's Terrace - Difficulty: 0) (Auras: ) +(@CGUID+1, 37675, 1, 1657, 1662, '0', 0, 0, 0, 0, 9871.6396484375, 2494.429931640625, 1317.1234130859375, 6.021385669708251953, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 48069), -- Public Relations Agent (Area: Tradesmen's Terrace - Difficulty: 0) (Auras: ) +(@CGUID+2, 37981, 1, 1657, 1662, '0', 0, 0, 0, 0, 9843.1337890625, 2430.732666015625, 1313.5167236328125, 5.567600250244140625, 120, 0, 0, 1693785, 63100, 0, 0, 0, 0, 48069), -- [DND] Love Boat Summoner 03 (Area: Tradesmen's Terrace - Difficulty: 0) +(@CGUID+3, 38039, 1, 1657, 1662, '0', 0, 0, 0, 0, 9871.41015625, 2488.31005859375, 1315.953369140625, 0.05235987901687622, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 48069), -- Kwee Q. Peddlefeet (Area: Tradesmen's Terrace - Difficulty: 0) +(@CGUID+4, 38293, 1, 1657, 1662, '0', 0, 0, 0, 0, 9885.1201171875, 2493.89990234375, 1315.9833984375, 3.40339207649230957, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 48069), -- Junior Inspector (Area: Tradesmen's Terrace - Difficulty: 0) +(@CGUID+5, 40438, 1, 1657, 0, '0', 0, 0, 0, 0, 9932.779296875, 2490.90966796875, 1317.70166015625, 1.256637096405029296, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 48069); -- Steamwheedle Shyster (Area: 0 - Difficulty: 0) + +-- Old gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN 83385 AND 83399; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 84752 AND 84756; +DELETE FROM `gameobject` WHERE `guid` IN (83301, 84963, 84964, 84965); +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 83385 AND 83399; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 84752 AND 84756; +DELETE FROM `game_event_gameobject` WHERE `guid` IN (83301, 84963, 84964, 84965); + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+140; +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, 181015, 1, 1657, 1662, '0', 0, 0, 9871.6103515625, 2494.43994140625, 1315.8699951171875, 6.003933906555175781, 0, 0, -0.13917255401611328, 0.990268170833587646, 120, 255, 1, 48069), -- Standing, Large - Val (Area: Tradesmen's Terrace - Difficulty: 0) +(@OGUID+1, 181015, 1, 1657, 1662, '0', 0, 0, 9870.919921875, 2492.5, 1315.8699951171875, 5.916667938232421875, 0, 0, -0.18223476409912109, 0.98325502872467041, 120, 255, 1, 48069), -- Standing, Large - Val (Area: Tradesmen's Terrace - Difficulty: 0) +(@OGUID+2, 181015, 1, 1657, 1662, '0', 0, 0, 9868.240234375, 2493.52001953125, 1315.8699951171875, 0, 0, 0, 0, 1, 120, 255, 1, 48069), -- Standing, Large - Val (Area: Tradesmen's Terrace - Difficulty: 0) +(@OGUID+3, 181015, 1, 1657, 1662, '0', 0, 0, 9868.400390625, 2494.360107421875, 1317.1099853515625, 5.70722818374633789, 0, 0, -0.28401470184326171, 0.958819925785064697, 120, 255, 1, 48069), -- Standing, Large - Val (Area: Tradesmen's Terrace - Difficulty: 0) +(@OGUID+4, 181015, 1, 1657, 1662, '0', 0, 0, 9868.740234375, 2495.0400390625, 1315.8699951171875, 5.916667938232421875, 0, 0, -0.18223476409912109, 0.98325502872467041, 120, 255, 1, 48069), -- Standing, Large - Val (Area: Tradesmen's Terrace - Difficulty: 0) +(@OGUID+5, 181016, 1, 1657, 0, '0', 0, 0, 9952.8642578125, 2607.1279296875, 1316.193359375, 3.263772249221801757, 0, 0, -0.99813461303710937, 0.061051756143569946, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+6, 181016, 1, 1657, 0, '0', 0, 0, 9939.0888671875, 2585.650390625, 1316.4146728515625, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+7, 181016, 1, 1657, 0, '0', 0, 0, 9939.4189453125, 2606.71728515625, 1316.725830078125, 6.230826377868652343, 0, 0, -0.02617645263671875, 0.999657332897186279, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+8, 181016, 1, 1657, 0, '0', 0, 0, 9952.1533203125, 2585.772705078125, 1316.1334228515625, 3.176533222198486328, 0, 0, -0.999847412109375, 0.017469281330704689, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+9, 181016, 1, 1657, 0, '0', 0, 0, 9952.3720703125, 2593.956298828125, 1316.53271484375, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+10, 181016, 1, 1657, 0, '0', 0, 0, 9939.7548828125, 2594.984619140625, 1316.2366943359375, 6.178466320037841796, 0, 0, -0.05233573913574218, 0.998629570007324218, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+11, 181016, 1, 1657, 1661, '0', 0, 0, 9687.2998046875, 2518.820068359375, 1337.31005859375, 2.513273954391479492, 0, 0, 0.951056480407714843, 0.309017121791839599, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: The Temple Gardens - Difficulty: 0) +(@OGUID+12, 181016, 1, 1657, 1661, '0', 0, 0, 9686.9599609375, 2531.010009765625, 1337.300048828125, 3.543023586273193359, 0, 0, -0.97992420196533203, 0.199370384216308593, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: The Temple Gardens - Difficulty: 0) +(@OGUID+13, 181016, 1, 1657, 0, '0', 0, 0, 9662.25, 2519.780029296875, 1331.6199951171875, 3.508116960525512695, 0, 0, -0.98325443267822265, 0.182238012552261352, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+14, 181016, 1, 1657, 0, '0', 0, 0, 9658.8603515625, 2532.6298828125, 1331.52001953125, 2.967041015625, 0, 0, 0.996193885803222656, 0.087165042757987976, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+15, 181019, 1, 1657, 0, '0', 0, 0, 9666.0400390625, 2517.080078125, 1333.6300048828125, 0.820303261280059814, 0, 0, 0.398748397827148437, 0.917060375213623046, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+16, 181019, 1, 1657, 0, '0', 0, 0, 9661.76953125, 2505.72998046875, 1334.1500244140625, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+17, 181019, 1, 1657, 0, '0', 0, 0, 10129.6396484375, 2220.782958984375, 1330.9371337890625, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+18, 181019, 1, 1657, 1659, '0', 0, 0, 10139.6376953125, 2208.229248046875, 1331.8416748046875, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: Craftsmen's Terrace - Difficulty: 0) +(@OGUID+19, 181019, 1, 1657, 1659, '0', 0, 0, 10137.66015625, 2226.1650390625, 1330.946044921875, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: Craftsmen's Terrace - Difficulty: 0) +(@OGUID+20, 181019, 1, 1657, 1659, '0', 0, 0, 10145.0107421875, 2211.8125, 1331.8353271484375, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: Craftsmen's Terrace - Difficulty: 0) +(@OGUID+21, 181019, 1, 1657, 0, '0', 0, 0, 9665.23046875, 2510.75, 1334.4300537109375, 4.310965538024902343, 0, 0, -0.83388519287109375, 0.55193793773651123, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+22, 181020, 1, 1657, 1660, '0', 0, 0, 9857.4501953125, 2344.72900390625, 1334.97216796875, 2.897245407104492187, 0, 0, 0.99254608154296875, 0.121869951486587524, 120, 255, 1, 48069), -- Hanging, Square, Medium - Val (Area: Warrior's Terrace - Difficulty: 0) +(@OGUID+23, 181020, 1, 1657, 1662, '0', 0, 0, 9798.345703125, 2309.28076171875, 1330.5626220703125, 4.415683269500732421, 0, 0, -0.80385684967041015, 0.594822824001312255, 120, 255, 1, 48069), -- Hanging, Square, Medium - Val (Area: Tradesmen's Terrace - Difficulty: 0) +(@OGUID+24, 181020, 1, 1657, 1661, '0', 0, 0, 9696.8330078125, 2518.314208984375, 1339.857177734375, 0.052358884364366531, 0, 0, 0.02617645263671875, 0.999657332897186279, 120, 255, 1, 48069), -- Hanging, Square, Medium - Val (Area: The Temple Gardens - Difficulty: 0) +(@OGUID+25, 181020, 1, 1657, 1661, '0', 0, 0, 9696.474609375, 2532.065673828125, 1339.7371826171875, 0, 0, 0, 0, 1, 120, 255, 1, 48069), -- Hanging, Square, Medium - Val (Area: The Temple Gardens - Difficulty: 0) +(@OGUID+26, 181020, 1, 1657, 1662, '0', 0, 0, 9821.78125, 2252.388671875, 1346.2120361328125, 6.03883981704711914, 0, 0, -0.12186908721923828, 0.9925462007522583, 120, 255, 1, 48069), -- Hanging, Square, Medium - Val (Area: Tradesmen's Terrace - Difficulty: 0) +(@OGUID+27, 181020, 1, 1657, 1659, '0', 0, 0, 10147.900390625, 2358.489990234375, 1341.0999755859375, 1.308995485305786132, 0, 0, 0.608760833740234375, 0.793353796005249023, 120, 255, 1, 48069), -- Hanging, Square, Medium - Val (Area: Craftsmen's Terrace - Difficulty: 0) +(@OGUID+28, 181020, 1, 1657, 1659, '0', 0, 0, 10072.8330078125, 2344.398681640625, 1335.1676025390625, 5.550147056579589843, 0, 0, -0.358367919921875, 0.933580458164215087, 120, 255, 1, 48069), -- Hanging, Square, Medium - Val (Area: Craftsmen's Terrace - Difficulty: 0) +(@OGUID+29, 181020, 1, 1657, 0, '0', 0, 0, 9695.8095703125, 2338.861572265625, 1340.9754638671875, 2.181660413742065429, 0, 0, 0.887010574340820312, 0.461749136447906494, 120, 255, 1, 48069), -- Hanging, Square, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+30, 181020, 1, 1657, 1662, '0', 0, 0, 9737.771484375, 2294.831298828125, 1346.488037109375, 5.585053920745849609, 0, 0, -0.34202003479003906, 0.939692676067352294, 120, 255, 1, 48069), -- Hanging, Square, Medium - Val (Area: Tradesmen's Terrace - Difficulty: 0) +(@OGUID+31, 181020, 1, 1657, 1660, '0', 0, 0, 10091.09375, 2264.77685546875, 1346.5098876953125, 0.471238493919372558, 0, 0, 0.233445167541503906, 0.972369968891143798, 120, 255, 1, 48069), -- Hanging, Square, Medium - Val (Area: Warrior's Terrace - Difficulty: 0) +(@OGUID+32, 181021, 1, 1657, 1662, '0', 0, 0, 9892.4033203125, 2238.71923828125, 1343.6077880859375, 6.195919513702392578, 0, 0, -0.04361915588378906, 0.999048233032226562, 120, 255, 1, 48069), -- Hanging, Door - Val (Area: Tradesmen's Terrace - Difficulty: 0) +(@OGUID+33, 181021, 1, 1657, 0, '0', 0, 0, 10013.5576171875, 2242.083251953125, 1343.91455078125, 3.24634718894958496, 0, 0, -0.99862861633300781, 0.052353221923112869, 120, 255, 1, 48069), -- Hanging, Door - Val (Area: 0 - Difficulty: 0) +(@OGUID+34, 181021, 1, 1657, 0, '0', 0, 0, 9892.5947265625, 2223.509521484375, 1343.6256103515625, 0.017452461645007133, 0, 0, 0.008726119995117187, 0.999961912631988525, 120, 255, 1, 48069), -- Hanging, Door - Val (Area: 0 - Difficulty: 0) +(@OGUID+35, 181021, 1, 1657, 1662, '0', 0, 0, 9893.3642578125, 2207.5390625, 1343.7637939453125, 0.034906249493360519, 0, 0, 0.017452239990234375, 0.999847710132598876, 120, 255, 1, 48069), -- Hanging, Door - Val (Area: Tradesmen's Terrace - Difficulty: 0) +(@OGUID+36, 181021, 1, 1657, 1660, '0', 0, 0, 10014.4228515625, 2211.135498046875, 1343.829345703125, 3.106652259826660156, 0, 0, 0.999847412109375, 0.017469281330704689, 120, 255, 1, 48069), -- Hanging, Door - Val (Area: Warrior's Terrace - Difficulty: 0) +(@OGUID+37, 181021, 1, 1657, 1660, '0', 0, 0, 10013.978515625, 2226.739501953125, 1343.6868896484375, 3.159062385559082031, 0, 0, -0.99996185302734375, 0.008734640665352344, 120, 255, 1, 48069), -- Hanging, Door - Val (Area: Warrior's Terrace - Difficulty: 0) +(@OGUID+38, 181021, 1, 1657, 0, '0', 0, 0, 9986.2841796875, 2022.8958740234375, 1351.8372802734375, 1.605701684951782226, 0, 0, 0.719339370727539062, 0.694658815860748291, 120, 255, 1, 48069), -- Hanging, Door - Val (Area: 0 - Difficulty: 0) +(@OGUID+39, 181021, 1, 1657, 0, '0', 0, 0, 9985.9443359375, 1978.33984375, 1352.1419677734375, 4.677483558654785156, 0, 0, -0.71933937072753906, 0.694658815860748291, 120, 255, 1, 48069), -- Hanging, Door - Val (Area: 0 - Difficulty: 0) +(@OGUID+40, 181025, 1, 1657, 0, '0', 0, 0, 9995.7421875, 2309.054443359375, 1340.9385986328125, 1.745326757431030273, 0, 0, 0.766043663024902343, 0.642788589000701904, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0) +(@OGUID+41, 181025, 1, 1657, 1660, '0', 0, 0, 9906.451171875, 2306.75048828125, 1340.8868408203125, 1.553341388702392578, 0, 0, 0.700908660888671875, 0.713251054286956787, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: Warrior's Terrace - Difficulty: 0) +(@OGUID+42, 181027, 1, 1657, 0, '0', 0, 0, 9990.1533203125, 2556.4189453125, 1313.66259765625, 6.03883981704711914, 0, 0, -0.12186908721923828, 0.9925462007522583, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+43, 181027, 1, 1657, 0, '0', 0, 0, 9879.4775390625, 2611.526611328125, 1313.66259765625, 4.206246376037597656, 0, 0, -0.86162853240966796, 0.50753939151763916, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+44, 181027, 1, 1657, 0, '0', 0, 0, 9987.9736328125, 2582.203369140625, 1313.66259765625, 2.478367090225219726, 0, 0, 0.94551849365234375, 0.325568377971649169, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+45, 181027, 1, 1657, 0, '0', 0, 0, 9910.9189453125, 2589, 1313.66259765625, 0.680676698684692382, 0, 0, 0.333806037902832031, 0.942641794681549072, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+46, 181027, 1, 1657, 0, '0', 0, 0, 10040.2158203125, 2582.506591796875, 1313.66259765625, 4.136432647705078125, 0, 0, -0.87881660461425781, 0.477159708738327026, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+47, 181027, 1, 1657, 0, '0', 0, 0, 9887.98828125, 2548.035400390625, 1313.66259765625, 3.560472726821899414, 0, 0, -0.97814750671386718, 0.207912087440490722, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+48, 181027, 1, 1657, 0, '0', 0, 0, 9880.6240234375, 2653.088134765625, 1313.66259765625, 2.879789113998413085, 0, 0, 0.991444587707519531, 0.130528271198272705, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+49, 181027, 1, 1657, 0, '0', 0, 0, 10016.478515625, 2549.553955078125, 1313.66259765625, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+50, 181027, 1, 1657, 0, '0', 0, 0, 9855.3828125, 2594.1728515625, 1313.66259765625, 0.698131442070007324, 0, 0, 0.342020034790039062, 0.939692676067352294, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+51, 181027, 1, 1657, 0, '0', 0, 0, 10017.7431640625, 2611.614501953125, 1313.66259765625, 3.054326534271240234, 0, 0, 0.999048233032226562, 0.043619260191917419, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+52, 181027, 1, 1657, 0, '0', 0, 0, 9854.1552734375, 2651.853515625, 1313.66259765625, 1.343901276588439941, 0, 0, 0.622513771057128906, 0.78260880708694458, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+53, 181027, 1, 1657, 0, '0', 0, 0, 9855.779296875, 2612.975341796875, 1313.66259765625, 2.72271275520324707, 0, 0, 0.978147506713867187, 0.207912087440490722, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+54, 181027, 1, 1657, 0, '0', 0, 0, 10040.3173828125, 2614.057373046875, 1313.66259765625, 1.413715124130249023, 0, 0, 0.649447441101074218, 0.760406434535980224, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+55, 181027, 1, 1657, 0, '0', 0, 0, 10019.458984375, 2649.182373046875, 1313.66259765625, 5.044002056121826171, 0, 0, -0.58070278167724609, 0.814115643501281738, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+56, 181027, 1, 1657, 0, '0', 0, 0, 10016.96484375, 2582.79931640625, 1313.66259765625, 2.338739633560180664, 0, 0, 0.920504570007324218, 0.3907318115234375, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+57, 181027, 1, 1657, 0, '0', 0, 0, 10020.1669921875, 2520.95654296875, 1313.66259765625, 0.715584874153137207, 0, 0, 0.350207328796386718, 0.936672210693359375, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+58, 181027, 1, 1657, 0, '0', 0, 0, 10039.6884765625, 2546.71044921875, 1313.66259765625, 3.857182979583740234, 0, 0, -0.93667125701904296, 0.350209832191467285, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+59, 181027, 1, 1657, 0, '0', 0, 0, 10047.5244140625, 2524.99951171875, 1313.66259765625, 2.740161895751953125, 0, 0, 0.979924201965332031, 0.199370384216308593, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+60, 181027, 1, 1657, 0, '0', 0, 0, 9985.4189453125, 2477.57373046875, 1313.66259765625, 2.164205789566040039, 0, 0, 0.882946968078613281, 0.469472706317901611, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+61, 181027, 1, 1657, 0, '0', 0, 0, 10020.771484375, 2461.275146484375, 1313.66259765625, 2.303830623626708984, 0, 0, 0.913544654846191406, 0.406738430261611938, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+62, 181027, 1, 1657, 0, '0', 0, 0, 9988.7421875, 2449.603759765625, 1313.66259765625, 1.151916384696960449, 0, 0, 0.544638633728027343, 0.838670849800109863, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+63, 181027, 1, 1657, 0, '0', 0, 0, 10056.4775390625, 2424.052490234375, 1313.66259765625, 2.617989301681518554, 0, 0, 0.965925216674804687, 0.258821308612823486, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+64, 181027, 1, 1657, 0, '0', 0, 0, 10050.2841796875, 2459.013916015625, 1313.66259765625, 5.131268978118896484, 0, 0, -0.54463863372802734, 0.838670849800109863, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+65, 181027, 1, 1657, 0, '0', 0, 0, 9950.990234375, 2441.914794921875, 1313.66259765625, 1.32644820213317871, 0, 0, 0.615660667419433593, 0.788011372089385986, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+66, 181027, 1, 1657, 0, '0', 0, 0, 9992.4755859375, 2419.781005859375, 1313.66259765625, 1.064649581909179687, 0, 0, 0.507537841796875, 0.861629426479339599, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+67, 181027, 1, 1657, 0, '0', 0, 0, 10015.4658203125, 2398.330810546875, 1313.66259765625, 1.658061861991882324, 0, 0, 0.737277030944824218, 0.67559051513671875, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+68, 181027, 1, 1657, 1659, '0', 0, 0, 10043.900390625, 2380.27001953125, 1313.66259765625, 4.328419685363769531, 0, 0, -0.82903671264648437, 0.559194147586822509, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Craftsmen's Terrace - Difficulty: 0) +(@OGUID+69, 181027, 1, 1657, 1659, '0', 0, 0, 9982.728515625, 2383.526123046875, 1313.66259765625, 2.775068521499633789, 0, 0, 0.983254432678222656, 0.182238012552261352, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Craftsmen's Terrace - Difficulty: 0) +(@OGUID+70, 181027, 1, 1657, 1659, '0', 0, 0, 10023.044921875, 2351.207763671875, 1313.66259765625, 4.084071159362792968, 0, 0, -0.8910064697265625, 0.453990638256072998, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Craftsmen's Terrace - Difficulty: 0) +(@OGUID+71, 181027, 1, 1657, 1659, '0', 0, 0, 9949.142578125, 2370.30908203125, 1313.66259765625, 2.408554315567016601, 0, 0, 0.933580398559570312, 0.358368009328842163, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Craftsmen's Terrace - Difficulty: 0) +(@OGUID+72, 181027, 1, 1657, 0, '0', 0, 0, 9916.1875, 2415.841064453125, 1313.66259765625, 0.645771682262420654, 0, 0, 0.317304611206054687, 0.948323667049407958, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+73, 181027, 1, 1657, 0, '0', 0, 0, 9928.7177734375, 2391.572998046875, 1313.66259765625, 2.67034769058227539, 0, 0, 0.972369194030761718, 0.233448356389999389, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+74, 181027, 1, 1657, 1660, '0', 0, 0, 9888.7470703125, 2392.522705078125, 1313.66259765625, 1.343901276588439941, 0, 0, 0.622513771057128906, 0.78260880708694458, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Warrior's Terrace - Difficulty: 0) +(@OGUID+75, 181027, 1, 1657, 1660, '0', 0, 0, 9891.6875, 2416.095458984375, 1313.66259765625, 2.652894020080566406, 0, 0, 0.970294952392578125, 0.241925001144409179, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Warrior's Terrace - Difficulty: 0) +(@OGUID+76, 181027, 1, 1657, 1660, '0', 0, 0, 9916.0087890625, 2481.231689453125, 1313.66259765625, 0.541050612926483154, 0, 0, 0.267237663269042968, 0.96363067626953125, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Warrior's Terrace - Difficulty: 0) +(@OGUID+77, 181027, 1, 1657, 1660, '0', 0, 0, 9922.99609375, 2450.674560546875, 1313.66259765625, 5.567600727081298828, 0, 0, -0.35020732879638671, 0.936672210693359375, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Warrior's Terrace - Difficulty: 0) +(@OGUID+78, 181027, 1, 1657, 1660, '0', 0, 0, 9849.216796875, 2418.9833984375, 1313.66259765625, 1.221729278564453125, 0, 0, 0.573575973510742187, 0.819152355194091796, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Warrior's Terrace - Difficulty: 0) +(@OGUID+79, 181027, 1, 1657, 1662, '0', 0, 0, 9823.3828125, 2416.881591796875, 1313.66259765625, 2.251473426818847656, 0, 0, 0.902585029602050781, 0.430511653423309326, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Tradesmen's Terrace - Difficulty: 0) +(@OGUID+80, 181027, 1, 1657, 1662, '0', 0, 0, 9848.236328125, 2479.29052734375, 1313.66259765625, 0.750490784645080566, 0, 0, 0.3665008544921875, 0.93041771650314331, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Tradesmen's Terrace - Difficulty: 0) +(@OGUID+81, 181027, 1, 1657, 1662, '0', 0, 0, 9819.462890625, 2391.36669921875, 1313.66259765625, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Tradesmen's Terrace - Difficulty: 0) +(@OGUID+82, 181027, 1, 1657, 1662, '0', 0, 0, 9817.466796875, 2450.540283203125, 1313.66259765625, 0.767943859100341796, 0, 0, 0.374606132507324218, 0.927184045314788818, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Tradesmen's Terrace - Difficulty: 0) +(@OGUID+83, 181027, 1, 1657, 1662, '0', 0, 0, 9884.5498046875, 2517.37939453125, 1313.66259765625, 4.066620349884033203, 0, 0, -0.89493370056152343, 0.44619917869567871, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Tradesmen's Terrace - Difficulty: 0) +(@OGUID+84, 181027, 1, 1657, 1662, '0', 0, 0, 9853.224609375, 2517.56103515625, 1313.66259765625, 4.188792228698730468, 0, 0, -0.86602497100830078, 0.50000077486038208, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Tradesmen's Terrace - Difficulty: 0) +(@OGUID+85, 181027, 1, 1657, 1662, '0', 0, 0, 9816.6064453125, 2485.602783203125, 1313.66259765625, 1.937312245368957519, 0, 0, 0.824125289916992187, 0.566407561302185058, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Tradesmen's Terrace - Difficulty: 0) +(@OGUID+86, 181027, 1, 1657, 0, '0', 0, 0, 9791.984375, 2452.619140625, 1313.66259765625, 5.009094715118408203, 0, 0, -0.59482288360595703, 0.80385679006576538, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+87, 181027, 1, 1657, 1662, '0', 0, 0, 9782.2626953125, 2386.587158203125, 1313.66259765625, 4.677483558654785156, 0, 0, -0.71933937072753906, 0.694658815860748291, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Tradesmen's Terrace - Difficulty: 0) +(@OGUID+88, 181027, 1, 1657, 1662, '0', 0, 0, 9791.9921875, 2473.59521484375, 1313.66259765625, 0.471238493919372558, 0, 0, 0.233445167541503906, 0.972369968891143798, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Tradesmen's Terrace - Difficulty: 0) +(@OGUID+89, 181027, 1, 1657, 1662, '0', 0, 0, 9750.3212890625, 2472.941650390625, 1313.66259765625, 0.942476630210876464, 0, 0, 0.453989982604980468, 0.891006767749786376, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Tradesmen's Terrace - Difficulty: 0) +(@OGUID+90, 181027, 1, 1657, 1661, '0', 0, 0, 9810.94140625, 2549.630126953125, 1313.66259765625, 4.642575740814208984, 0, 0, -0.731353759765625, 0.681998312473297119, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: The Temple Gardens - Difficulty: 0) +(@OGUID+91, 181027, 1, 1657, 1661, '0', 0, 0, 9816.9833984375, 2516.384033203125, 1313.66259765625, 1.221729278564453125, 0, 0, 0.573575973510742187, 0.819152355194091796, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: The Temple Gardens - Difficulty: 0) +(@OGUID+92, 181027, 1, 1657, 1661, '0', 0, 0, 9791.8935546875, 2515.9560546875, 1313.66259765625, 0.209439441561698913, 0, 0, 0.104528427124023437, 0.994521915912628173, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: The Temple Gardens - Difficulty: 0) +(@OGUID+93, 181027, 1, 1657, 1661, '0', 0, 0, 9785.53515625, 2582.45654296875, 1313.66259765625, 5.532694816589355468, 0, 0, -0.3665008544921875, 0.93041771650314331, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: The Temple Gardens - Difficulty: 0) +(@OGUID+94, 181027, 1, 1657, 1661, '0', 0, 0, 9753.912109375, 2584.861083984375, 1313.66259765625, 5.811946868896484375, 0, 0, -0.2334451675415039, 0.972369968891143798, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: The Temple Gardens - Difficulty: 0) +(@OGUID+95, 181027, 1, 1657, 1661, '0', 0, 0, 9785.8408203125, 2616.43505859375, 1313.66259765625, 3.43830275535583496, 0, 0, -0.98901557922363281, 0.147811368107795715, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: The Temple Gardens - Difficulty: 0) +(@OGUID+96, 181027, 1, 1657, 1661, '0', 0, 0, 9814.59375, 2612.671875, 1313.66259765625, 4.747295856475830078, 0, 0, -0.69465827941894531, 0.719339847564697265, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: The Temple Gardens - Difficulty: 0) +(@OGUID+97, 181027, 1, 1657, 1661, '0', 0, 0, 9825.4013671875, 2650.506103515625, 1313.66259765625, 4.59021615982055664, 0, 0, -0.74895572662353515, 0.662620067596435546, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: The Temple Gardens - Difficulty: 0) +(@OGUID+98, 181027, 1, 1657, 1661, '0', 0, 0, 9784.70703125, 2649.1494140625, 1313.66259765625, 4.241150379180908203, 0, 0, -0.85264015197753906, 0.522498607635498046, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: The Temple Gardens - Difficulty: 0) +(@OGUID+99, 181027, 1, 1657, 0, '0', 0, 0, 9722.103515625, 2587.236328125, 1313.66259765625, 4.642575740814208984, 0, 0, -0.731353759765625, 0.681998312473297119, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+100, 181027, 1, 1657, 0, '0', 0, 0, 9713.107421875, 2608.23291015625, 1313.66259765625, 0.698131442070007324, 0, 0, 0.342020034790039062, 0.939692676067352294, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+101, 181027, 1, 1657, 0, '0', 0, 0, 9686.7041015625, 2619.662841796875, 1313.66259765625, 3.263772249221801757, 0, 0, -0.99813461303710937, 0.061051756143569946, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+102, 181027, 1, 1657, 0, '0', 0, 0, 9715.9580078125, 2650.024658203125, 1313.66259765625, 4.45059061050415039, 0, 0, -0.79335308074951171, 0.608761727809906005, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0) +(@OGUID+103, 181055, 1, 1657, 1662, '0', 0, 0, 9919.376953125, 2271.4912109375, 1355.086669921875, 4.747295856475830078, 0, 0, -0.69465827941894531, 0.719339847564697265, 120, 255, 1, 48069), -- Hanging, Streamer x3 - Val (Area: Tradesmen's Terrace - Difficulty: 0) +(@OGUID+104, 181055, 1, 1657, 1662, '0', 0, 0, 9930.4130859375, 2271.809814453125, 1355.079345703125, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 48069), -- Hanging, Streamer x3 - Val (Area: Tradesmen's Terrace - Difficulty: 0) +(@OGUID+105, 181055, 1, 1657, 0, '0', 0, 0, 9985.8095703125, 2272.694580078125, 1354.99658203125, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 120, 255, 1, 48069), -- Hanging, Streamer x3 - Val (Area: 0 - Difficulty: 0) +(@OGUID+106, 181055, 1, 1657, 0, '0', 0, 0, 9996.8857421875, 2273.37841796875, 1355.0816650390625, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 48069), -- Hanging, Streamer x3 - Val (Area: 0 - Difficulty: 0) +(@OGUID+107, 181055, 1, 1657, 1659, '0', 0, 0, 10130.900390625, 2224.819580078125, 1352.219970703125, 2.111847877502441406, 0, 0, 0.870355606079101562, 0.492423713207244873, 120, 255, 1, 48069), -- Hanging, Streamer x3 - Val (Area: Craftsmen's Terrace - Difficulty: 0) +(@OGUID+108, 181055, 1, 1657, 1659, '0', 0, 0, 10144.400390625, 2233.65966796875, 1352.199951171875, 2.199114561080932617, 0, 0, 0.8910064697265625, 0.453990638256072998, 120, 255, 1, 48069), -- Hanging, Streamer x3 - Val (Area: Craftsmen's Terrace - Difficulty: 0) +(@OGUID+109, 181055, 1, 1657, 1662, '0', 0, 0, 9908.3173828125, 2270.951416015625, 1355.0899658203125, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 48069), -- Hanging, Streamer x3 - Val (Area: Tradesmen's Terrace - Difficulty: 0) +(@OGUID+110, 181055, 1, 1657, 0, '0', 0, 0, 9973.708984375, 2273.312255859375, 1355.0858154296875, 4.747295856475830078, 0, 0, -0.69465827941894531, 0.719339847564697265, 120, 255, 1, 48069), -- Hanging, Streamer x3 - Val (Area: 0 - Difficulty: 0) +(@OGUID+111, 181055, 1, 1657, 0, '0', 0, 0, 10119.2998046875, 2216.14990234375, 1351.8199462890625, 2.199114561080932617, 0, 0, 0.8910064697265625, 0.453990638256072998, 120, 255, 1, 48069), -- Hanging, Streamer x3 - Val (Area: 0 - Difficulty: 0) +(@OGUID+112, 181060, 1, 1657, 0, '0', 0, 0, 9955.1806640625, 2556.272216796875, 1316.1734619140625, 1.396261811256408691, 0, 0, 0.642786979675292968, 0.766044974327087402, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0) +(@OGUID+113, 181060, 1, 1657, 0, '0', 0, 0, 9934.30078125, 2557.725830078125, 1316.9478759765625, 4.572763919830322265, 0, 0, -0.75470924377441406, 0.656059443950653076, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0) +(@OGUID+114, 181060, 1, 1657, 0, '0', 0, 0, 9986.876953125, 2533.8935546875, 1315.75146484375, 4.677483558654785156, 0, 0, -0.71933937072753906, 0.694658815860748291, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0) +(@OGUID+115, 181060, 1, 1657, 0, '0', 0, 0, 9982.099609375, 2542.384033203125, 1316.060791015625, 4.258606910705566406, 0, 0, -0.84804725646972656, 0.529920578002929687, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0) +(@OGUID+116, 181060, 1, 1657, 0, '0', 0, 0, 9963.1650390625, 2552.3369140625, 1315.384521484375, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0) +(@OGUID+117, 181060, 1, 1657, 0, '0', 0, 0, 9906.7080078125, 2539.321044921875, 1315.7354736328125, 1.989672422409057617, 0, 0, 0.838669776916503906, 0.544640243053436279, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0) +(@OGUID+118, 181060, 1, 1657, 0, '0', 0, 0, 9904.9462890625, 2522.02197265625, 1315.9273681640625, 1.256635904312133789, 0, 0, 0.587784767150878906, 0.809017360210418701, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0) +(@OGUID+119, 181060, 1, 1657, 0, '0', 0, 0, 9917.05078125, 2550.0517578125, 1316.59228515625, 4.433136463165283203, 0, 0, -0.79863548278808593, 0.60181504487991333, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0) +(@OGUID+120, 181060, 1, 1657, 0, '0', 0, 0, 9923.767578125, 2553.712158203125, 1316.803466796875, 4.677483558654785156, 0, 0, -0.71933937072753906, 0.694658815860748291, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0) +(@OGUID+121, 181060, 1, 1657, 0, '0', 0, 0, 9911.5224609375, 2545.095458984375, 1316.07958984375, 4.468043327331542968, 0, 0, -0.7880105972290039, 0.615661680698394775, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0) +(@OGUID+122, 181060, 1, 1657, 0, '0', 0, 0, 9973.123046875, 2550.50634765625, 1315.554931640625, 0.349065244197845458, 0, 0, 0.173647880554199218, 0.984807789325714111, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0) +(@OGUID+123, 181060, 1, 1657, 0, '0', 0, 0, 9991.6845703125, 2525.6630859375, 1315.423828125, 5.95157480239868164, 0, 0, -0.16504669189453125, 0.986285746097564697, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0) +(@OGUID+124, 181060, 1, 1657, 0, '0', 0, 0, 9978.791015625, 2546.933349609375, 1315.7611083984375, 4.049167633056640625, 0, 0, -0.89879322052001953, 0.438372820615768432, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0) +(@OGUID+125, 181060, 1, 1657, 0, '0', 0, 0, 9984.974609375, 2508.034423828125, 1316.6595458984375, 1.361356139183044433, 0, 0, 0.629320144653320312, 0.77714616060256958, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0) +(@OGUID+126, 181060, 1, 1657, 0, '0', 0, 0, 9976.06640625, 2506.437744140625, 1316.49951171875, 4.276057243347167968, 0, 0, -0.84339141845703125, 0.537299633026123046, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0) +(@OGUID+127, 181060, 1, 1657, 0, '0', 0, 0, 9971.6298828125, 2499.947509765625, 1315.941650390625, 2.286378860473632812, 0, 0, 0.909960746765136718, 0.414694398641586303, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0) +(@OGUID+128, 181060, 1, 1657, 0, '0', 0, 0, 9967.181640625, 2493.3173828125, 1316.130615234375, 5.70722818374633789, 0, 0, -0.28401470184326171, 0.958819925785064697, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0) +(@OGUID+129, 181060, 1, 1657, 0, '0', 0, 0, 9960.7392578125, 2485.678466796875, 1316.0355224609375, 4.607671737670898437, 0, 0, -0.74314403533935546, 0.669131457805633544, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0) +(@OGUID+130, 181060, 1, 1657, 0, '0', 0, 0, 9941.6103515625, 2481.393798828125, 1316.3460693359375, 4.48549652099609375, 0, 0, -0.7826080322265625, 0.622514784336090087, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0) +(@OGUID+131, 181060, 1, 1657, 0, '0', 0, 0, 9936.701171875, 2484.00244140625, 1316.6773681640625, 3.176533222198486328, 0, 0, -0.999847412109375, 0.017469281330704689, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0) +(@OGUID+132, 181060, 1, 1657, 0, '0', 0, 0, 9928.6982421875, 2489.725830078125, 1317.01513671875, 0.261798173189163208, 0, 0, 0.130525588989257812, 0.991444945335388183, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0) +(@OGUID+133, 181060, 1, 1657, 0, '0', 0, 0, 9932.13671875, 2487.103271484375, 1316.735107421875, 2.042035102844238281, 0, 0, 0.852640151977539062, 0.522498607635498046, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0) +(@OGUID+134, 181060, 1, 1657, 0, '0', 0, 0, 9923.259765625, 2493.748291015625, 1317.0203857421875, 3.054326534271240234, 0, 0, 0.999048233032226562, 0.043619260191917419, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0) +(@OGUID+135, 181060, 1, 1657, 1662, '0', 0, 0, 9918.6494140625, 2498.4248046875, 1316.378662109375, 4.939284324645996093, 0, 0, -0.6225137710571289, 0.78260880708694458, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Tradesmen's Terrace - Difficulty: 0) +(@OGUID+136, 181060, 1, 1657, 1662, '0', 0, 0, 9908.2373046875, 2510.8857421875, 1316.39794921875, 2.426007747650146484, 0, 0, 0.936672210693359375, 0.350207358598709106, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Tradesmen's Terrace - Difficulty: 0) +(@OGUID+137, 181060, 1, 1657, 0, '0', 0, 0, 10127.576171875, 2219.45654296875, 1330.951171875, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0) +(@OGUID+138, 181060, 1, 1657, 1659, '0', 0, 0, 10135.9443359375, 2225.007080078125, 1330.9381103515625, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Craftsmen's Terrace - Difficulty: 0) +(@OGUID+139, 181060, 1, 1657, 1659, '0', 0, 0, 10139.111328125, 2227.236083984375, 1330.9615478515625, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Craftsmen's Terrace - Difficulty: 0) +(@OGUID+140, 201940, 1, 1657, 1662, '0', 0, 0, 9870.75, 2493.6298828125, 1315.8699951171875, 5.986480236053466796, 0, 0, -0.14780902862548828, 0.989015936851501464, 120, 255, 1, 48069); -- Valentine Arch (x2.00) (Area: Tradesmen's Terrace - Difficulty: 0) + +-- Event spawns +DELETE FROM `game_event_creature` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @CGUID+0 AND @CGUID+5; +INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES +(@EVENT, @CGUID+0), +(@EVENT, @CGUID+1), +(@EVENT, @CGUID+2), +(@EVENT, @CGUID+3), +(@EVENT, @CGUID+4), +(@EVENT, @CGUID+5); + +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @OGUID+0 AND @OGUID+140; +INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES +(@EVENT, @OGUID+0), +(@EVENT, @OGUID+1), +(@EVENT, @OGUID+2), +(@EVENT, @OGUID+3), +(@EVENT, @OGUID+4), +(@EVENT, @OGUID+5), +(@EVENT, @OGUID+6), +(@EVENT, @OGUID+7), +(@EVENT, @OGUID+8), +(@EVENT, @OGUID+9), +(@EVENT, @OGUID+10), +(@EVENT, @OGUID+11), +(@EVENT, @OGUID+12), +(@EVENT, @OGUID+13), +(@EVENT, @OGUID+14), +(@EVENT, @OGUID+15), +(@EVENT, @OGUID+16), +(@EVENT, @OGUID+17), +(@EVENT, @OGUID+18), +(@EVENT, @OGUID+19), +(@EVENT, @OGUID+20), +(@EVENT, @OGUID+21), +(@EVENT, @OGUID+22), +(@EVENT, @OGUID+23), +(@EVENT, @OGUID+24), +(@EVENT, @OGUID+25), +(@EVENT, @OGUID+26), +(@EVENT, @OGUID+27), +(@EVENT, @OGUID+28), +(@EVENT, @OGUID+29), +(@EVENT, @OGUID+30), +(@EVENT, @OGUID+31), +(@EVENT, @OGUID+32), +(@EVENT, @OGUID+33), +(@EVENT, @OGUID+34), +(@EVENT, @OGUID+35), +(@EVENT, @OGUID+36), +(@EVENT, @OGUID+37), +(@EVENT, @OGUID+38), +(@EVENT, @OGUID+39), +(@EVENT, @OGUID+40), +(@EVENT, @OGUID+41), +(@EVENT, @OGUID+42), +(@EVENT, @OGUID+43), +(@EVENT, @OGUID+44), +(@EVENT, @OGUID+45), +(@EVENT, @OGUID+46), +(@EVENT, @OGUID+47), +(@EVENT, @OGUID+48), +(@EVENT, @OGUID+49), +(@EVENT, @OGUID+50), +(@EVENT, @OGUID+51), +(@EVENT, @OGUID+52), +(@EVENT, @OGUID+53), +(@EVENT, @OGUID+54), +(@EVENT, @OGUID+55), +(@EVENT, @OGUID+56), +(@EVENT, @OGUID+57), +(@EVENT, @OGUID+58), +(@EVENT, @OGUID+59), +(@EVENT, @OGUID+60), +(@EVENT, @OGUID+61), +(@EVENT, @OGUID+62), +(@EVENT, @OGUID+63), +(@EVENT, @OGUID+64), +(@EVENT, @OGUID+65), +(@EVENT, @OGUID+66), +(@EVENT, @OGUID+67), +(@EVENT, @OGUID+68), +(@EVENT, @OGUID+69), +(@EVENT, @OGUID+70), +(@EVENT, @OGUID+71), +(@EVENT, @OGUID+72), +(@EVENT, @OGUID+73), +(@EVENT, @OGUID+74), +(@EVENT, @OGUID+75), +(@EVENT, @OGUID+76), +(@EVENT, @OGUID+77), +(@EVENT, @OGUID+78), +(@EVENT, @OGUID+79), +(@EVENT, @OGUID+80), +(@EVENT, @OGUID+81), +(@EVENT, @OGUID+82), +(@EVENT, @OGUID+83), +(@EVENT, @OGUID+84), +(@EVENT, @OGUID+85), +(@EVENT, @OGUID+86), +(@EVENT, @OGUID+87), +(@EVENT, @OGUID+88), +(@EVENT, @OGUID+89), +(@EVENT, @OGUID+90), +(@EVENT, @OGUID+91), +(@EVENT, @OGUID+92), +(@EVENT, @OGUID+93), +(@EVENT, @OGUID+94), +(@EVENT, @OGUID+95), +(@EVENT, @OGUID+96), +(@EVENT, @OGUID+97), +(@EVENT, @OGUID+98), +(@EVENT, @OGUID+99), +(@EVENT, @OGUID+100), +(@EVENT, @OGUID+101), +(@EVENT, @OGUID+102), +(@EVENT, @OGUID+103), +(@EVENT, @OGUID+104), +(@EVENT, @OGUID+105), +(@EVENT, @OGUID+106), +(@EVENT, @OGUID+107), +(@EVENT, @OGUID+108), +(@EVENT, @OGUID+109), +(@EVENT, @OGUID+110), +(@EVENT, @OGUID+111), +(@EVENT, @OGUID+112), +(@EVENT, @OGUID+113), +(@EVENT, @OGUID+114), +(@EVENT, @OGUID+115), +(@EVENT, @OGUID+116), +(@EVENT, @OGUID+117), +(@EVENT, @OGUID+118), +(@EVENT, @OGUID+119), +(@EVENT, @OGUID+120), +(@EVENT, @OGUID+121), +(@EVENT, @OGUID+122), +(@EVENT, @OGUID+123), +(@EVENT, @OGUID+124), +(@EVENT, @OGUID+125), +(@EVENT, @OGUID+126), +(@EVENT, @OGUID+127), +(@EVENT, @OGUID+128), +(@EVENT, @OGUID+129), +(@EVENT, @OGUID+130), +(@EVENT, @OGUID+131), +(@EVENT, @OGUID+132), +(@EVENT, @OGUID+133), +(@EVENT, @OGUID+134), +(@EVENT, @OGUID+135), +(@EVENT, @OGUID+136), +(@EVENT, @OGUID+137), +(@EVENT, @OGUID+138), +(@EVENT, @OGUID+139), +(@EVENT, @OGUID+140), +(@EVENT, @OGUID+141); |