aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMeji <alvaro.megias@outlook.com>2023-02-20 21:33:56 +0100
committerMeji <alvaro.megias@outlook.com>2023-02-20 21:33:56 +0100
commit89239946b8ca60c20ef237f2df27eca833c23151 (patch)
tree41ba4c2281d4f512e5d47dd0979fe1cb514cf4a1
parent3fcf2c460dc6432d862a7c0038b83e872e0d992f (diff)
DB/Darnassus: Added Love is in the Air spawns
-rw-r--r--sql/updates/world/master/2023_02_20_06_world.sql372
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);