aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMeji <alvaro.megias@outlook.com>2023-02-20 21:34:23 +0100
committerMeji <alvaro.megias@outlook.com>2023-02-20 21:34:23 +0100
commit0f31a6fe99cd018b11e7d6fa42ada0c68a08fd7d (patch)
tree405e70e8088c86cd1ed70ef0dc580bcd82a9fe7a
parent89239946b8ca60c20ef237f2df27eca833c23151 (diff)
DB/TheExodar: Added Love is in the Air spawns
-rw-r--r--sql/updates/world/master/2023_02_20_07_world.sql409
1 files changed, 409 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_02_20_07_world.sql b/sql/updates/world/master/2023_02_20_07_world.sql
new file mode 100644
index 00000000000..9140e6d7348
--- /dev/null
+++ b/sql/updates/world/master/2023_02_20_07_world.sql
@@ -0,0 +1,409 @@
+SET @CGUID := 2000000;
+SET @OGUID := 2000000;
+SET @EVENT := 8;
+
+-- Creature templates
+UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `speed_run`=1, `unit_flags`=32768 WHERE `entry`=38040; -- Kwee Q. Peddlefeet
+
+-- Equipments
+UPDATE `creature_equip_template` SET `VerifiedBuild`=48069 WHERE (`ID`=1 AND `CreatureID` IN (176650,50306,47586,47570,34987,34986,30716,20674,18924,18892,18800,17520,17519,17468,17431,17219,17204,16733,16708,16706)) OR (`ID`=3 AND `CreatureID`=16733) OR (`ID`=5 AND `CreatureID`=16733) OR (`ID`=2 AND `CreatureID`=16733) OR (`ID`=4 AND `CreatureID`=16733);
+
+-- Models
+DELETE FROM `creature_model_info` WHERE `DisplayID` IN (110565, 110562, 110564, 110552);
+INSERT INTO `creature_model_info` (`DisplayID`, `BoundingRadius`, `CombatReach`, `DisplayID_Other_Gender`, `VerifiedBuild`) VALUES
+(110565, 1, 1.5, 0, 48069),
+(110562, 1, 1.5, 0, 48069),
+(110564, 1, 1.5, 0, 48069),
+(110552, 1, 1.5, 0, 48069);
+
+UPDATE `creature_model_info` SET `VerifiedBuild`=48069 WHERE `DisplayID` IN (100547, 100548, 87511, 19301, 74942, 42481, 42343, 4959, 4960, 4626, 37399, 37016, 35709, 35694, 31016, 29509, 29508, 27297, 27264, 21050, 19999, 19987, 19985, 16726, 19872, 19873, 19871, 19870, 19869, 19740, 20107, 20105, 19351, 19195, 74789, 18418, 16925, 18329, 18328, 18326, 18325, 18324, 18322, 18321, 18299, 18298, 18297, 18296, 18295, 18281, 18285, 18282, 19231, 19233, 19234, 18222, 18221, 18340, 18195, 18341, 17684, 17683, 17682, 17518, 17124, 17110, 17085, 18154, 17063, 6820, 17792, 17243, 17222, 17248, 17249, 17226, 17488, 17214, 17822, 8714, 15538, 17025, 1283, 178, 16914, 641, 17600, 3031, 6805, 16873, 16872, 12348, 17511, 17227, 17213, 17293, 17212, 17500, 17499, 17486, 17483, 17217, 17508, 17509, 17225, 17245, 17247, 17517, 17439, 17494, 17492, 17512, 17242, 17440, 17491, 17487, 17485, 17436, 17489, 17479, 17481, 17246, 17434, 17431, 17495, 17437, 17375, 17374, 17373, 17372, 17503, 17501, 17507, 17219, 17505, 17502, 17498, 17493, 17490, 17482, 16858, 17496, 17506, 17514, 17223, 17510, 17221, 17344, 17516, 18137, 17478, 17513, 17497, 17220, 17484, 17504, 4878);
+
+-- Scaling
+DELETE FROM `creature_template_scaling` WHERE (`DifficultyID`=0 AND `Entry` IN (199159,199155,38040));
+INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES
+(199159, 0, 0, 0, 864, 48069),
+(199155, 0, 0, 0, 864, 48069),
+(38040, 0, 0, 0, 378, 48069);
+
+UPDATE `creature_template_scaling` SET `VerifiedBuild`=48069 WHERE (`DifficultyID`=0 AND `Entry` IN (176650,141904,118895,118892,62464,62050,61143,61080,51501,50306,47586,47570,34987,34986,30732,30716,22905,22851,21376,21019,21018,21010,21008,20914,20850,20849,20848,20847,20846,20722,20674,20121,19778,19658,19073,18985,18955,18924,18921,18919,18918,18917,18916,18915,18903,18902,18901,18900,18899,18896,18892,18815,18814,18813,18812,18800,18350,18349,18348,17773,17614,17584,17555,17538,17530,17520,17519,17514,17513,17512,17511,17510,17509,17505,17504,17468,17436,17435,17431,17374,17373,17219,17216,17204,17203,17202,17201,17200,17197,17122,17121,17120,16774,16771,16768,16767,16766,16765,16764,16763,16762,16761,16757,16756,16755,16753,16752,16751,16750,16749,16748,16747,16746,16745,16743,16742,16741,16740,16739,16738,16736,16735,16734,16733,16732,16731,16729,16728,16727,16726,16725,16724,16723,16722,16721,16719,16718,16716,16715,16714,16713,16712,16710,16709,16708,16707,16706,16705,16657,16632,6145));
+
+-- Quests
+UPDATE `quest_template` SET `Expansion`=9, `VerifiedBuild`=48069 WHERE `ID`=24611; -- A Gift for the Prophet
+
+UPDATE `quest_poi` SET `VerifiedBuild`=48069 WHERE (`QuestID`=24611 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=24611 AND `BlobIndex`=0 AND `Idx1`=0);
+
+UPDATE `quest_poi_points` SET `VerifiedBuild`=48069 WHERE (`QuestID`=24611 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=24611 AND `Idx1`=0 AND `Idx2`=0);
+
+DELETE FROM `quest_details` WHERE `ID`=24611;
+INSERT INTO `quest_details` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `VerifiedBuild`) VALUES
+(24611, 0, 0, 0, 0, 0, 0, 0, 0, 48069); -- A Gift for the Prophet
+
+DELETE FROM `creature_queststarter` WHERE (`id`=38040 AND `quest`=24611);
+INSERT INTO `creature_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(38040, 24611, 48069); -- A Gift for the Prophet offered Kwee Q. Peddlefeet
+
+DELETE FROM `game_event_creature_quest` WHERE (`id`=38040 AND `quest`=24611);
+
+-- Old creature spawns
+DELETE FROM `creature` WHERE `guid` IN (40506, 40483, 208796, 208811);
+DELETE FROM `game_event_creature` WHERE `guid` IN (40506, 40483, 208796, 208811);
+
+-- Creature spawns
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+4;
+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, 530, 3557, 0, '0', 0, 0, 0, 0, -4006.7744140625, -11844.939453125, 1.430115342140197753, 4.468042850494384765, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 48069), -- Lovely Merchant (Area: 0 - Difficulty: 0) (Auras: )
+(@CGUID+1, 37675, 530, 3557, 0, '0', 0, 0, 0, 0, -4004.755126953125, -11845.498046875, 1.443716406822204589, 4.78220224380493164, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 48069), -- Public Relations Agent (Area: 0 - Difficulty: 0) (Auras: )
+(@CGUID+2, 38040, 530, 3557, 0, '0', 0, 0, 0, 0, -4011.397705078125, -11844.7158203125, 0.209571331739425659, 4.991641521453857421, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 48069), -- Kwee Q. Peddlefeet (Area: 0 - Difficulty: 0)
+(@CGUID+3, 38293, 530, 3557, 0, '0', 0, 0, 0, 0, -4015.30029296875, -11869.7080078125, 0.058880336582660675, 1.221730470657348632, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 48069), -- Junior Inspector (Area: 0 - Difficulty: 0)
+(@CGUID+4, 40438, 530, 3557, 0, '0', 0, 0, 0, 0, -3934.50341796875, -11604.7568359375, -138.513031005859375, 4.764749050140380859, 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 43738 AND 43771;
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 43807 AND 43844;
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 43872 AND 43898;
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 43960 AND 43976;
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 43999 AND 44005;
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 44035 AND 44050;
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 84757 AND 84761;
+DELETE FROM `gameobject` WHERE `guid` IN (43805, 83302, 84718, 84719, 84720);
+DELETE FROM `gameobject_addon` WHERE `guid` BETWEEN 43738 AND 43771;
+DELETE FROM `gameobject_addon` WHERE `guid` BETWEEN 43807 AND 43844;
+DELETE FROM `gameobject_addon` WHERE `guid` BETWEEN 43872 AND 43898;
+DELETE FROM `gameobject_addon` WHERE `guid` BETWEEN 43960 AND 43976;
+DELETE FROM `gameobject_addon` WHERE `guid` BETWEEN 43999 AND 44005;
+DELETE FROM `gameobject_addon` WHERE `guid` BETWEEN 44035 AND 44050;
+DELETE FROM `gameobject_addon` WHERE `guid`=43805;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 43738 AND 43771;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 43807 AND 43844;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 43872 AND 43898;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 43960 AND 43976;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 43999 AND 44005;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 44035 AND 44050;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 84757 AND 84761;
+DELETE FROM `game_event_gameobject` WHERE `guid` IN (43805, 83302, 84718, 84719, 84720);
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+154;
+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, 181014, 530, 3557, 0, '0', 0, 0, -3991.588134765625, -11552.546875, -122.168663024902343, 5.340708732604980468, 0, 0, -0.45398998260498046, 0.891006767749786376, 120, 255, 1, 48069), -- Hanging, Square, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+1, 181014, 530, 3557, 0, '0', 0, 0, -4022.099853515625, -11517.6494140625, -123.535232543945312, 2.129300594329833984, 0, 0, 0.874619483947753906, 0.484810054302215576, 120, 255, 1, 48069), -- Hanging, Square, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+2, 181014, 530, 3557, 0, '0', 0, 0, -3966.362548828125, -11588.181640625, -97.2340240478515625, 5.305802345275878906, 0, 0, -0.46947097778320312, 0.882947921752929687, 120, 255, 1, 48069), -- Hanging, Square, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+3, 181014, 530, 3557, 0, '0', 0, 0, -3966.4501953125, -11587.626953125, -97.81689453125, 2.164205789566040039, 0, 0, 0.882946968078613281, 0.469472706317901611, 120, 255, 1, 48069), -- Hanging, Square, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+4, 181014, 530, 3557, 0, '0', 0, 0, -3785.23388671875, -11420.61328125, -122.395362854003906, 4.223697185516357421, 0, 0, -0.85716724395751953, 0.515038192272186279, 120, 255, 1, 48069), -- Hanging, Square, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+5, 181014, 530, 3557, 0, '0', 0, 0, -3868.659423828125, -11590.5078125, -95.2881240844726562, 4.223697185516357421, 0, 0, -0.85716724395751953, 0.515038192272186279, 120, 255, 1, 48069), -- Hanging, Square, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+6, 181014, 530, 3557, 0, '0', 0, 0, -3866.91015625, -11587.146484375, -96.3765335083007812, 1.221729278564453125, 0, 0, 0.573575973510742187, 0.819152355194091796, 120, 255, 1, 48069), -- Hanging, Square, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+7, 181014, 530, 3557, 0, '0', 0, 0, -4014.814697265625, -11671.7021484375, -97.8474273681640625, 3.071766138076782226, 0, 0, 0.999390602111816406, 0.034906134009361267, 120, 255, 1, 48069), -- Hanging, Square, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+8, 181014, 530, 3557, 0, '0', 0, 0, -4011.885009765625, -11672.0673828125, -97.3294296264648437, 0.034906249493360519, 0, 0, 0.017452239990234375, 0.999847710132598876, 120, 255, 1, 48069), -- Hanging, Square, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+9, 181014, 530, 3557, 0, '0', 0, 0, -3864.28466796875, -11742.6533203125, -84.61895751953125, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 48069), -- Hanging, Square, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+10, 181014, 530, 3557, 0, '0', 0, 0, -3989.1171875, -11849.0791015625, 25.73338699340820312, 4.171337604522705078, 0, 0, -0.87035560607910156, 0.492423713207244873, 120, 255, 1, 48069), -- Hanging, Square, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+11, 181015, 530, 3557, 0, '0', 0, 0, -4005.507080078125, -11842.263671875, 1.427111029624938964, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, 48069), -- Standing, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+12, 181015, 530, 3557, 0, '0', 0, 0, -4006.776123046875, -11844.982421875, 0.173840999603271484, 4.468043327331542968, 0, 0, -0.7880105972290039, 0.615661680698394775, 120, 255, 1, 48069), -- Standing, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+13, 181015, 530, 3557, 0, '0', 0, 0, -4004.751708984375, -11845.4150390625, 0.192708998918533325, 4.642575740814208984, 0, 0, -0.731353759765625, 0.681998312473297119, 120, 255, 1, 48069), -- Standing, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+14, 181015, 530, 3557, 0, '0', 0, 0, -4004.692626953125, -11842.23828125, 0.20165400207042694, 0, 0, 0, 0, 1, 120, 255, 1, 48069), -- Standing, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+15, 181015, 530, 3557, 0, '0', 0, 0, -4006.26220703125, -11842.126953125, 0.186350002884864807, 4.1538848876953125, 0, 0, -0.8746194839477539, 0.484810054302215576, 120, 255, 1, 48069), -- Standing, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+16, 181016, 530, 3524, 0, '0', 0, 0, -4180.39453125, -11586.9951171875, -123.979927062988281, 5.619962215423583984, 0, 0, -0.32556724548339843, 0.945518851280212402, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+17, 181016, 530, 3524, 0, '0', 0, 0, -4149.005859375, -11480.560546875, -130.89447021484375, 5.89921426773071289, 0, 0, -0.19080829620361328, 0.981627285480499267, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+18, 181016, 530, 3524, 0, '0', 0, 0, -4150.38720703125, -11469.783203125, -130.922622680664062, 2.70525527000427246, 0, 0, 0.97629547119140625, 0.216442063450813293, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+19, 181016, 530, 3524, 0, '0', 0, 0, -4196.21484375, -11595.271484375, -125.408432006835937, 1.239183306694030761, 0, 0, 0.580702781677246093, 0.814115643501281738, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+20, 181016, 530, 3524, 0, '0', 0, 0, -4072.7314453125, -11547.6689453125, -138.704299926757812, 0.977383077144622802, 0, 0, 0.469470977783203125, 0.882947921752929687, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+21, 181016, 530, 3524, 0, '0', 0, 0, -4070.251220703125, -11542.4501953125, -138.655410766601562, 4.555310726165771484, 0, 0, -0.76040554046630859, 0.649448513984680175, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+22, 181016, 530, 3557, 0, '0', 0, 0, -4040.37158203125, -11581.4111328125, -138.451919555664062, 0.680676698684692382, 0, 0, 0.333806037902832031, 0.942641794681549072, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+23, 181016, 530, 3557, 0, '0', 0, 0, -3987.21484375, -11495.4736328125, -137.14398193359375, 2.251473426818847656, 0, 0, 0.902585029602050781, 0.430511653423309326, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+24, 181016, 530, 3557, 0, '0', 0, 0, -4006.56689453125, -11572.7314453125, -138.041900634765625, 2.67034769058227539, 0, 0, 0.972369194030761718, 0.233448356389999389, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+25, 181016, 530, 3557, 0, '0', 0, 0, -3979.7587890625, -11500.7841796875, -137.076507568359375, 6.248279094696044921, 0, 0, -0.01745223999023437, 0.999847710132598876, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+26, 181016, 530, 3557, 0, '0', 0, 0, -4025.3291015625, -11590.40234375, -138.327667236328125, 1.762782454490661621, 0, 0, 0.771624565124511718, 0.636078238487243652, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+27, 181016, 530, 3557, 0, '0', 0, 0, -3988.78125, -11386.52734375, -122.711898803710937, 5.305802345275878906, 0, 0, -0.46947097778320312, 0.882947921752929687, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+28, 181016, 530, 3557, 0, '0', 0, 0, -4008.92529296875, -11350.9833984375, -122.813980102539062, 4.206246376037597656, 0, 0, -0.86162853240966796, 0.50753939151763916, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+29, 181016, 530, 3557, 0, '0', 0, 0, -3979.865966796875, -11369.396484375, -122.542320251464843, 1.378809213638305664, 0, 0, 0.636077880859375, 0.771624863147735595, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+30, 181016, 530, 3557, 0, '0', 0, 0, -3990.306884765625, -11353.0830078125, -122.603202819824218, 5.480334281921386718, 0, 0, -0.39073085784912109, 0.920504987239837646, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+31, 181016, 530, 3557, 0, '0', 0, 0, -3891.189208984375, -11640.6484375, -134.49072265625, 1.291541695594787597, 0, 0, 0.60181427001953125, 0.798636078834533691, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+32, 181016, 530, 3557, 0, '0', 0, 0, -4200.80908203125, -11604.302734375, -125.620033264160156, 0.471238493919372558, 0, 0, 0.233445167541503906, 0.972369968891143798, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+33, 181016, 530, 3557, 0, '0', 0, 0, -4167.5556640625, -11641.123046875, -98.3939971923828125, 1.134462952613830566, 0, 0, 0.537299156188964843, 0.843391716480255126, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+34, 181016, 530, 3557, 0, '0', 0, 0, -4155.24072265625, -11635.466796875, -98.1755752563476562, 5.375615119934082031, 0, 0, -0.4383707046508789, 0.898794233798980712, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+35, 181016, 530, 3557, 0, '0', 0, 0, -4185.56689453125, -11653.0595703125, -143.44879150390625, 5.044002056121826171, 0, 0, -0.58070278167724609, 0.814115643501281738, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+36, 181016, 530, 3557, 0, '0', 0, 0, -4163.96484375, -11666.73828125, -143.258132934570312, 4.677483558654785156, 0, 0, -0.71933937072753906, 0.694658815860748291, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+37, 181016, 530, 3557, 0, '0', 0, 0, -4225.97265625, -11648.0830078125, -143.864120483398437, 5.881760597229003906, 0, 0, -0.19936752319335937, 0.979924798011779785, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+38, 181016, 530, 3557, 0, '0', 0, 0, -4229.96484375, -11608.4189453125, -126.282623291015625, 0.837757468223571777, 0, 0, 0.406736373901367187, 0.913545548915863037, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+39, 181016, 530, 3557, 0, '0', 0, 0, -4204.8212890625, -11678.4853515625, -143.191604614257812, 0.401424884796142578, 0, 0, 0.199367523193359375, 0.979924798011779785, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+40, 181016, 530, 3557, 0, '0', 0, 0, -4207.48583984375, -11645.037109375, -143.676971435546875, 0.104719325900077819, 0, 0, 0.052335739135742187, 0.998629570007324218, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+41, 181016, 530, 3557, 0, '0', 0, 0, -4209.63818359375, -11675.4228515625, -143.244140625, 5.89921426773071289, 0, 0, -0.19080829620361328, 0.981627285480499267, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+42, 181016, 530, 3557, 0, '0', 0, 0, -4065.432861328125, -11688.7900390625, -142.187881469726562, 0.383971005678176879, 0, 0, 0.190808296203613281, 0.981627285480499267, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+43, 181016, 530, 3557, 0, '0', 0, 0, -4154.533203125, -11704.791015625, -143.31939697265625, 5.986480236053466796, 0, 0, -0.14780902862548828, 0.989015936851501464, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+44, 181016, 530, 3557, 0, '0', 0, 0, -4065.592041015625, -11664.1513671875, -142.100540161132812, 0.226892471313476562, 0, 0, 0.113203048706054687, 0.993571877479553222, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+45, 181016, 530, 3557, 0, '0', 0, 0, -4178.04052734375, -11713.5400390625, -143.601715087890625, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+46, 181016, 530, 3557, 0, '0', 0, 0, -4185.51513671875, -11746.03515625, -132.272537231445312, 3.036838293075561523, 0, 0, 0.998628616333007812, 0.052353221923112869, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+47, 181016, 530, 3557, 0, '0', 0, 0, -4194.7353515625, -11728.541015625, -143.45147705078125, 3.24634718894958496, 0, 0, -0.99862861633300781, 0.052353221923112869, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+48, 181016, 530, 3557, 0, '0', 0, 0, -4161.400390625, -11800.5830078125, -132.195220947265625, 4.555310726165771484, 0, 0, -0.76040554046630859, 0.649448513984680175, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+49, 181016, 530, 3557, 0, '0', 0, 0, -4228.94873046875, -11818.9404296875, -115.934478759765625, 0.802850961685180664, 0, 0, 0.390730857849121093, 0.920504987239837646, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+50, 181016, 530, 3557, 0, '0', 0, 0, -4221.80712890625, -11830.91796875, -115.895927429199218, 5.305802345275878906, 0, 0, -0.46947097778320312, 0.882947921752929687, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+51, 181016, 530, 3557, 0, '0', 0, 0, -4253.185546875, -11675.283203125, -143.764739990234375, 4.677483558654785156, 0, 0, -0.71933937072753906, 0.694658815860748291, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+52, 181016, 530, 3557, 0, '0', 0, 0, -4244.82373046875, -11657.95703125, -143.624862670898437, 1.727874636650085449, 0, 0, 0.760405540466308593, 0.649448513984680175, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+53, 181016, 530, 3557, 0, '0', 0, 0, -3938.107177734375, -11702.048828125, -135.276275634765625, 1.500982880592346191, 0, 0, 0.681998252868652343, 0.731353819370269775, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+54, 181016, 530, 3557, 0, '0', 0, 0, -3943.940673828125, -11674.0791015625, -135.238632202148437, 3.595378875732421875, 0, 0, -0.97437000274658203, 0.224951311945915222, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+55, 181016, 530, 3557, 0, '0', 0, 0, -3943.486572265625, -11689.103515625, -135.289199829101562, 0.610863447189331054, 0, 0, 0.3007049560546875, 0.953717231750488281, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+56, 181016, 530, 3557, 0, '0', 0, 0, -3939.97998046875, -11660.91796875, -135.145401000976562, 3.874631166458129882, 0, 0, -0.93358039855957031, 0.358368009328842163, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+57, 181016, 530, 3557, 0, '0', 0, 0, -3928.3095703125, -11712.5419921875, -135.2059326171875, 5.148722648620605468, 0, 0, -0.53729915618896484, 0.843391716480255126, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+58, 181016, 530, 3557, 0, '0', 0, 0, -3931.237060546875, -11649.388671875, -135.003005981445312, 1.710421562194824218, 0, 0, 0.754709243774414062, 0.656059443950653076, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+59, 181016, 530, 3557, 0, '0', 0, 0, -3919.52001953125, -11641.96875, -134.831253051757812, 0.209439441561698913, 0, 0, 0.104528427124023437, 0.994521915912628173, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+60, 181016, 530, 3557, 0, '0', 0, 0, -3905.642822265625, -11638.7509765625, -134.663406372070312, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+61, 181016, 530, 3557, 0, '0', 0, 0, -3877.953125, -11647.3515625, -134.367874145507812, 4.677483558654785156, 0, 0, -0.71933937072753906, 0.694658815860748291, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+62, 181017, 530, 3557, 0, '0', 0, 0, -4145.79931640625, -11745.6220703125, -124.152946472167968, 2.024578809738159179, 0, 0, 0.848047256469726562, 0.529920578002929687, 120, 255, 1, 48069), -- Hanging, Streamer - Val (Area: 0 - Difficulty: 0)
+(@OGUID+63, 181017, 530, 3557, 0, '0', 0, 0, -4213.72900390625, -11685.4033203125, -130.823410034179687, 0.942476630210876464, 0, 0, 0.453989982604980468, 0.891006767749786376, 120, 255, 1, 48069), -- Hanging, Streamer - Val (Area: 0 - Difficulty: 0)
+(@OGUID+64, 181018, 530, 3557, 0, '0', 0, 0, -3758.169677734375, -11705.3193359375, -100.71826171875, 0.087265998125076293, 0, 0, 0.043619155883789062, 0.999048233032226562, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+65, 181018, 530, 3557, 0, '0', 0, 0, -3759.18408203125, -11686.46875, -100.742576599121093, 6.178466320037841796, 0, 0, -0.05233573913574218, 0.998629570007324218, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+66, 181018, 530, 3557, 0, '0', 0, 0, -3740.86767578125, -11676.3828125, -98.6888275146484375, 5.131268978118896484, 0, 0, -0.54463863372802734, 0.838670849800109863, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+67, 181018, 530, 3557, 0, '0', 0, 0, -3738.774658203125, -11714.69921875, -99.0851211547851562, 1.378809213638305664, 0, 0, 0.636077880859375, 0.771624863147735595, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+68, 181018, 530, 3557, 0, '0', 0, 0, -3720.251708984375, -11684.9443359375, -94.6487197875976562, 3.630291461944580078, 0, 0, -0.97029495239257812, 0.241925001144409179, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+69, 181018, 530, 3557, 0, '0', 0, 0, -3719.03466796875, -11703.5556640625, -95.1452407836914062, 2.775068521499633789, 0, 0, 0.983254432678222656, 0.182238012552261352, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+70, 181019, 530, 3557, 0, '0', 0, 0, -3918.3212890625, -11545.5234375, -149.044464111328125, 0.471238493919372558, 0, 0, 0.233445167541503906, 0.972369968891143798, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+71, 181019, 530, 3557, 0, '0', 0, 0, -3919.77783203125, -11545.478515625, -149.060989379882812, 0.104719325900077819, 0, 0, 0.052335739135742187, 0.998629570007324218, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+72, 181019, 530, 3557, 0, '0', 0, 0, -3924.432861328125, -11545.478515625, -149.110885620117187, 2.600535154342651367, 0, 0, 0.963629722595214843, 0.26724100112915039, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+73, 181019, 530, 3557, 0, '0', 0, 0, -3913.77001953125, -11545.5185546875, -148.998291015625, 0.471238493919372558, 0, 0, 0.233445167541503906, 0.972369968891143798, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+74, 181019, 530, 3557, 0, '0', 0, 0, -4022.251708984375, -11739.3212890625, -150.798065185546875, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+75, 181019, 530, 3557, 0, '0', 0, 0, -4026.649658203125, -11731.4931640625, -150.800018310546875, 2.600535154342651367, 0, 0, 0.963629722595214843, 0.26724100112915039, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+76, 181019, 530, 3557, 0, '0', 0, 0, -3744.044189453125, -11692.3623046875, -104.606300354003906, 3.420850038528442382, 0, 0, -0.99026775360107421, 0.139175355434417724, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+77, 181019, 530, 3557, 0, '0', 0, 0, -3743.69189453125, -11697.8212890625, -104.6240234375, 3.176533222198486328, 0, 0, -0.999847412109375, 0.017469281330704689, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+78, 181019, 530, 3557, 0, '0', 0, 0, -3740.327392578125, -11688.5693359375, -104.60479736328125, 4.97418975830078125, 0, 0, -0.60876083374023437, 0.793353796005249023, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+79, 181019, 530, 3557, 0, '0', 0, 0, -3739.729736328125, -11701.2900390625, -104.592422485351562, 2.44346022605895996, 0, 0, 0.939692497253417968, 0.34202045202255249, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+80, 181022, 530, 3524, 0, '0', 0, 0, -4144.75341796875, -11423.6201171875, -130.6719970703125, 3.473210096359252929, 0, 0, -0.98628520965576171, 0.165049895644187927, 120, 255, 1, 48069), -- Standing, Giant - Val (Area: 0 - Difficulty: 0)
+(@OGUID+81, 181022, 530, 3524, 0, '0', 0, 0, -4127.2099609375, -11534.9384765625, -136.012664794921875, 0.628316879272460937, 0, 0, 0.309016227722167968, 0.95105677843093872, 120, 255, 1, 48069), -- Standing, Giant - Val (Area: 0 - Difficulty: 0)
+(@OGUID+82, 181022, 530, 3524, 0, '0', 0, 0, -4120.4951171875, -11437.0947265625, -130.379013061523437, 4.834563255310058593, 0, 0, -0.66261959075927734, 0.748956084251403808, 120, 255, 1, 48069), -- Standing, Giant - Val (Area: 0 - Difficulty: 0)
+(@OGUID+83, 181022, 530, 3524, 0, '0', 0, 0, -4105.2216796875, -11544.513671875, -135.781646728515625, 1.605701684951782226, 0, 0, 0.719339370727539062, 0.694658815860748291, 120, 255, 1, 48069), -- Standing, Giant - Val (Area: 0 - Difficulty: 0)
+(@OGUID+84, 181022, 530, 3524, 0, '0', 0, 0, -4157.99853515625, -11597.3251953125, -138.910385131835937, 4.834563255310058593, 0, 0, -0.66261959075927734, 0.748956084251403808, 120, 255, 1, 48069), -- Standing, Giant - Val (Area: 0 - Difficulty: 0)
+(@OGUID+85, 181022, 530, 3524, 0, '0', 0, 0, -4030.150146484375, -11520.591796875, -141.262283325195312, 1.658061861991882324, 0, 0, 0.737277030944824218, 0.67559051513671875, 120, 255, 1, 48069), -- Standing, Giant - Val (Area: 0 - Difficulty: 0)
+(@OGUID+86, 181022, 530, 3524, 0, '0', 0, 0, -4129.01123046875, -11606.8251953125, -139.120803833007812, 4.206246376037597656, 0, 0, -0.86162853240966796, 0.50753939151763916, 120, 255, 1, 48069), -- Standing, Giant - Val (Area: 0 - Difficulty: 0)
+(@OGUID+87, 181022, 530, 3557, 0, '0', 0, 0, -4016.01611328125, -11510.4658203125, -141.069549560546875, 2.879789113998413085, 0, 0, 0.991444587707519531, 0.130528271198272705, 120, 255, 1, 48069), -- Standing, Giant - Val (Area: 0 - Difficulty: 0)
+(@OGUID+88, 181022, 530, 3557, 0, '0', 0, 0, -3973.86279296875, -11427.123046875, -136.736160278320312, 3.839725255966186523, 0, 0, -0.93969249725341796, 0.34202045202255249, 120, 255, 1, 48069), -- Standing, Giant - Val (Area: 0 - Difficulty: 0)
+(@OGUID+89, 181022, 530, 3557, 0, '0', 0, 0, -3968.95654296875, -11453.91015625, -136.772018432617187, 1.692969322204589843, 0, 0, 0.748955726623535156, 0.662620067596435546, 120, 255, 1, 48069), -- Standing, Giant - Val (Area: 0 - Difficulty: 0)
+(@OGUID+90, 181022, 530, 3557, 0, '0', 0, 0, -4000.541748046875, -11392.84765625, -123.377090454101562, 3.159062385559082031, 0, 0, -0.99996185302734375, 0.008734640665352344, 120, 255, 1, 48069), -- Standing, Giant - Val (Area: 0 - Difficulty: 0)
+(@OGUID+91, 181022, 530, 3557, 0, '0', 0, 0, -4019.296875, -11367.580078125, -123.678451538085937, 4.555310726165771484, 0, 0, -0.76040554046630859, 0.649448513984680175, 120, 255, 1, 48069), -- Standing, Giant - Val (Area: 0 - Difficulty: 0)
+(@OGUID+92, 181022, 530, 3557, 0, '0', 0, 0, -3974.517333984375, -11624.7451171875, -138.87567138671875, 4.904376029968261718, 0, 0, -0.636077880859375, 0.771624863147735595, 120, 255, 1, 48069), -- Standing, Giant - Val (Area: 0 - Difficulty: 0)
+(@OGUID+93, 181022, 530, 3557, 0, '0', 0, 0, -3935.25341796875, -11599.67578125, -138.455047607421875, 5.654868602752685546, 0, 0, -0.30901622772216796, 0.95105677843093872, 120, 255, 1, 48069), -- Standing, Giant - Val (Area: 0 - Difficulty: 0)
+(@OGUID+94, 181022, 530, 3557, 0, '0', 0, 0, -3988.4775390625, -11651.169921875, -139.043380737304687, 0.383971005678176879, 0, 0, 0.190808296203613281, 0.981627285480499267, 120, 255, 1, 48069), -- Standing, Giant - Val (Area: 0 - Difficulty: 0)
+(@OGUID+95, 181022, 530, 3557, 0, '0', 0, 0, -3903.50341796875, -11599.638671875, -137.785751342773437, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 120, 255, 1, 48069), -- Standing, Giant - Val (Area: 0 - Difficulty: 0)
+(@OGUID+96, 181022, 530, 3557, 0, '0', 0, 0, -3898.60888671875, -11445.353515625, -132.852264404296875, 0.104719325900077819, 0, 0, 0.052335739135742187, 0.998629570007324218, 120, 255, 1, 48069), -- Standing, Giant - Val (Area: 0 - Difficulty: 0)
+(@OGUID+97, 181022, 530, 3557, 0, '0', 0, 0, -3903.453125, -11420.75, -132.773666381835937, 0.191985160112380981, 0, 0, 0.095845222473144531, 0.995396256446838378, 120, 255, 1, 48069), -- Standing, Giant - Val (Area: 0 - Difficulty: 0)
+(@OGUID+98, 181022, 530, 3557, 0, '0', 0, 0, -3843.451416015625, -11503.50390625, -139.097488403320312, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 120, 255, 1, 48069), -- Standing, Giant - Val (Area: 0 - Difficulty: 0)
+(@OGUID+99, 181022, 530, 3557, 0, '0', 0, 0, -3732.544677734375, -11501.005859375, -134.029251098632812, 2.373644113540649414, 0, 0, 0.927183151245117187, 0.37460830807685852, 120, 255, 1, 48069), -- Standing, Giant - Val (Area: 0 - Difficulty: 0)
+(@OGUID+100, 181022, 530, 3557, 0, '0', 0, 0, -3753.63330078125, -11517.73046875, -134.326950073242187, 2.094393253326416015, 0, 0, 0.866024971008300781, 0.50000077486038208, 120, 255, 1, 48069), -- Standing, Giant - Val (Area: 0 - Difficulty: 0)
+(@OGUID+101, 181022, 530, 3557, 0, '0', 0, 0, -3821.1962890625, -11515.71875, -138.644241333007812, 1.518436193466186523, 0, 0, 0.6883544921875, 0.725374460220336914, 120, 255, 1, 48069), -- Standing, Giant - Val (Area: 0 - Difficulty: 0)
+(@OGUID+102, 181022, 530, 3557, 0, '0', 0, 0, -3657.604736328125, -11491.41796875, -119.097312927246093, 1.989672422409057617, 0, 0, 0.838669776916503906, 0.544640243053436279, 120, 255, 1, 48069), -- Standing, Giant - Val (Area: 0 - Difficulty: 0)
+(@OGUID+103, 181022, 530, 3557, 0, '0', 0, 0, -3640.53271484375, -11468.5869140625, -118.808647155761718, 3.019413232803344726, 0, 0, 0.998134613037109375, 0.061051756143569946, 120, 255, 1, 48069), -- Standing, Giant - Val (Area: 0 - Difficulty: 0)
+(@OGUID+104, 181022, 530, 3557, 0, '0', 0, 0, -3862.00341796875, -11617.357421875, -136.832565307617187, 4.939284324645996093, 0, 0, -0.6225137710571289, 0.78260880708694458, 120, 255, 1, 48069), -- Standing, Giant - Val (Area: 0 - Difficulty: 0)
+(@OGUID+105, 181022, 530, 3557, 0, '0', 0, 0, -4102.17138671875, -11696.2744140625, -142.664474487304687, 2.460912704467773437, 0, 0, 0.942641258239746093, 0.333807557821273803, 120, 255, 1, 48069), -- Standing, Giant - Val (Area: 0 - Difficulty: 0)
+(@OGUID+106, 181022, 530, 3557, 0, '0', 0, 0, -4122.1953125, -11707.25, -142.920608520507812, 1.832594871520996093, 0, 0, 0.793353080749511718, 0.608761727809906005, 120, 255, 1, 48069), -- Standing, Giant - Val (Area: 0 - Difficulty: 0)
+(@OGUID+107, 181022, 530, 3557, 0, '0', 0, 0, -3985.045166015625, -11695.9130859375, -139.365875244140625, 5.742135047912597656, 0, 0, -0.26723766326904296, 0.96363067626953125, 120, 255, 1, 48069), -- Standing, Giant - Val (Area: 0 - Difficulty: 0)
+(@OGUID+108, 181022, 530, 3557, 0, '0', 0, 0, -3970.779541015625, -11722.8818359375, -138.835647583007812, 1.518436193466186523, 0, 0, 0.6883544921875, 0.725374460220336914, 120, 255, 1, 48069), -- Standing, Giant - Val (Area: 0 - Difficulty: 0)
+(@OGUID+109, 181022, 530, 3557, 0, '0', 0, 0, -4186.2900390625, -11803.0126953125, -133.1741943359375, 0.610863447189331054, 0, 0, 0.3007049560546875, 0.953717231750488281, 120, 255, 1, 48069), -- Standing, Giant - Val (Area: 0 - Difficulty: 0)
+(@OGUID+110, 181022, 530, 3557, 0, '0', 0, 0, -4210.17578125, -11796.1630859375, -133.245193481445312, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 48069), -- Standing, Giant - Val (Area: 0 - Difficulty: 0)
+(@OGUID+111, 181022, 530, 3557, 0, '0', 0, 0, -3929.12841796875, -11744.81640625, -138.612197875976562, 0.628316879272460937, 0, 0, 0.309016227722167968, 0.95105677843093872, 120, 255, 1, 48069), -- Standing, Giant - Val (Area: 0 - Difficulty: 0)
+(@OGUID+112, 181025, 530, 3524, 0, '0', 0, 0, -4142.4970703125, -11540.021484375, -124.575332641601562, 0.837757468223571777, 0, 0, 0.406736373901367187, 0.913545548915863037, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+113, 181025, 530, 3524, 0, '0', 0, 0, -4097.3515625, -11552.8828125, -124.005912780761718, 1.884953022003173828, 0, 0, 0.809016227722167968, 0.587786316871643066, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+114, 181025, 530, 3557, 0, '0', 0, 0, -4066.69580078125, -11607.896484375, -129.408767700195312, 4.101525306701660156, 0, 0, -0.88701057434082031, 0.461749136447906494, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+115, 181025, 530, 3557, 0, '0', 0, 0, -4091.51904296875, -11339.2431640625, -129.597854614257812, 5.270895957946777343, 0, 0, -0.48480892181396484, 0.87462007999420166, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+116, 181025, 530, 3557, 0, '0', 0, 0, -4141.859375, -11371.3447265625, -129.852737426757812, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+117, 181025, 530, 3557, 0, '0', 0, 0, -3942.768798828125, -11632.9990234375, -199.473220825195312, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+118, 181025, 530, 3557, 0, '0', 0, 0, -3905.56689453125, -11457.8017578125, -112.987098693847656, 1.117009282112121582, 0, 0, 0.529918670654296875, 0.84804844856262207, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+119, 181025, 530, 3557, 0, '0', 0, 0, -3915.053955078125, -11411.20703125, -111.862556457519531, 6.09120035171508789, 0, 0, -0.09584522247314453, 0.995396256446838378, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+120, 181025, 530, 3557, 0, '0', 0, 0, -3905.15283203125, -11333.1982421875, -121.9205322265625, 5.183629035949707031, 0, 0, -0.52249813079833984, 0.852640450000762939, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+121, 181025, 530, 3557, 0, '0', 0, 0, -3848.599853515625, -11508.4267578125, -128.930374145507812, 0.733038187026977539, 0, 0, 0.358367919921875, 0.933580458164215087, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+122, 181025, 530, 3557, 0, '0', 0, 0, -3871.6962890625, -11319.818359375, -121.622833251953125, 5.078907966613769531, 0, 0, -0.56640625, 0.824126183986663818, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+123, 181025, 530, 3557, 0, '0', 0, 0, -3666.974365234375, -11418.333984375, -113.767120361328125, 3.333590030670166015, 0, 0, -0.99539566040039062, 0.095851235091686248, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+124, 181025, 530, 3557, 0, '0', 0, 0, -3662.1328125, -11453.9765625, -113.086982727050781, 3.333590030670166015, 0, 0, -0.99539566040039062, 0.095851235091686248, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+125, 181025, 530, 3557, 0, '0', 0, 0, -3822.28955078125, -11521.759765625, -128.501220703125, 1.466075778007507324, 0, 0, 0.669130325317382812, 0.74314504861831665, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+126, 181025, 530, 3557, 0, '0', 0, 0, -3802.614501953125, -11620.1787109375, -92.7153472900390625, 4.747295856475830078, 0, 0, -0.69465827941894531, 0.719339847564697265, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+127, 181025, 530, 3557, 0, '0', 0, 0, -3855.356689453125, -11639.212890625, -293.878265380859375, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+128, 181025, 530, 3557, 0, '0', 0, 0, -3855.822509765625, -11639.529296875, -169.809463500976562, 3.961898565292358398, 0, 0, -0.91705989837646484, 0.398749500513076782, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+129, 181025, 530, 3557, 0, '0', 0, 0, -3897.788330078125, -11618.37109375, -185.583709716796875, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+130, 181025, 530, 3557, 0, '0', 0, 0, -3905.8369140625, -11628.607421875, -302.98126220703125, 6.178466320037841796, 0, 0, -0.05233573913574218, 0.998629570007324218, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+131, 181025, 530, 3557, 0, '0', 0, 0, -4036.0673828125, -11724.2646484375, -125.335502624511718, 2.199114561080932617, 0, 0, 0.8910064697265625, 0.453990638256072998, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+132, 181025, 530, 3557, 0, '0', 0, 0, -3964.05859375, -11674.84375, -216.94000244140625, 0.104719325900077819, 0, 0, 0.052335739135742187, 0.998629570007324218, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+133, 181025, 530, 3557, 0, '0', 0, 0, -4129.51611328125, -11792.517578125, -122.023399353027343, 2.268925428390502929, 0, 0, 0.906307220458984375, 0.422619491815567016, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+134, 181025, 530, 3557, 0, '0', 0, 0, -3949.171875, -11719.732421875, -231.763397216796875, 0.663223206996917724, 0, 0, 0.325567245483398437, 0.945518851280212402, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+135, 181025, 530, 3557, 0, '0', 0, 0, -3906.888916015625, -11740.65625, -247.154861450195312, 1.448621988296508789, 0, 0, 0.662619590759277343, 0.748956084251403808, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+136, 181025, 530, 3557, 0, '0', 0, 0, -3861.938720703125, -11726.7001953125, -264.663330078125, 2.426007747650146484, 0, 0, 0.936672210693359375, 0.350207358598709106, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+137, 181025, 530, 3557, 0, '0', 0, 0, -3845.705810546875, -11764.55078125, -72.8578948974609375, 5.375615119934082031, 0, 0, -0.4383707046508789, 0.898794233798980712, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+138, 181025, 530, 3557, 0, '0', 0, 0, -3840.368408203125, -11683.5302734375, -278.9307861328125, 3.071766138076782226, 0, 0, 0.999390602111816406, 0.034906134009361267, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+139, 181025, 530, 3557, 0, '0', 0, 0, -3794.911376953125, -11730.607421875, -93.0702896118164062, 2.111847877502441406, 0, 0, 0.870355606079101562, 0.492423713207244873, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+140, 181025, 530, 3557, 0, '0', 0, 0, -3838.579345703125, -11819.7568359375, -46.669677734375, 4.188792228698730468, 0, 0, -0.86602497100830078, 0.50000077486038208, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+141, 181025, 530, 3557, 0, '0', 0, 0, -3783.91796875, -11674.640625, -93.7094497680664062, 3.24634718894958496, 0, 0, -0.99862861633300781, 0.052353221923112869, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+142, 181025, 530, 3557, 0, '0', 0, 0, -3907.01123046875, -11840.6474609375, -17.3894023895263671, 2.757613182067871093, 0, 0, 0.981626510620117187, 0.190812408924102783, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+143, 181027, 530, 3557, 0, '0', 0, 0, -3807.1650390625, -11439.646484375, -139.028274536132812, 1.431168079376220703, 0, 0, 0.656058311462402343, 0.754710197448730468, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+144, 181027, 530, 3557, 0, '0', 0, 0, -3816.788330078125, -11421.1767578125, -139.071380615234375, 5.270895957946777343, 0, 0, -0.48480892181396484, 0.87462007999420166, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+145, 181027, 530, 3557, 0, '0', 0, 0, -3822.314697265625, -11399.5576171875, -139.054473876953125, 3.298687219619750976, 0, 0, -0.99691677093505859, 0.078466430306434631, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+146, 181027, 530, 3557, 0, '0', 0, 0, -3794.798583984375, -11366.09375, -138.60455322265625, 5.969027042388916015, 0, 0, -0.1564340591430664, 0.987688362598419189, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+147, 181027, 530, 3557, 0, '0', 0, 0, -3774.08154296875, -11374.013671875, -138.391189575195312, 4.555310726165771484, 0, 0, -0.76040554046630859, 0.649448513984680175, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+148, 181027, 530, 3557, 0, '0', 0, 0, -3745.376708984375, -11403.87109375, -138.167022705078125, 2.321286916732788085, 0, 0, 0.917059898376464843, 0.398749500513076782, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+149, 181027, 530, 3557, 0, '0', 0, 0, -3756.67578125, -11382.49609375, -138.21881103515625, 0.314158439636230468, 0, 0, 0.156434059143066406, 0.987688362598419189, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+150, 181027, 530, 3557, 0, '0', 0, 0, -3754.06591796875, -11431.4306640625, -138.373428344726562, 2.094393253326416015, 0, 0, 0.866024971008300781, 0.50000077486038208, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+151, 181027, 530, 3557, 0, '0', 0, 0, -3769.15966796875, -11443.173828125, -138.595184326171875, 1.466075778007507324, 0, 0, 0.669130325317382812, 0.74314504861831665, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+152, 181027, 530, 3557, 0, '0', 0, 0, -3788.143798828125, -11452.6396484375, -138.854019165039062, 1.029743075370788574, 0, 0, 0.492423057556152343, 0.870355963706970214, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+153, 181060, 530, 3524, 0, '0', 0, 0, -4043.15283203125, -11563.0048828125, -136.852401733398437, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0)
+(@OGUID+154, 201940, 530, 3557, 0, '0', 0, 0, -4005.6494140625, -11844.5849609375, 0.186078995466232299, 4.520402908325195312, 0, 0, -0.77162456512451171, 0.636078238487243652, 120, 255, 1, 48069); -- Valentine Arch (x2.00) (Area: 0 - Difficulty: 0)
+
+-- Event spawns
+DELETE FROM `game_event_creature` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @CGUID+0 AND @CGUID+4;
+INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES
+(@EVENT, @CGUID+0),
+(@EVENT, @CGUID+1),
+(@EVENT, @CGUID+2),
+(@EVENT, @CGUID+3),
+(@EVENT, @CGUID+4);
+
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @OGUID+0 AND @OGUID+154;
+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),
+(@EVENT, @OGUID+142),
+(@EVENT, @OGUID+143),
+(@EVENT, @OGUID+144),
+(@EVENT, @OGUID+145),
+(@EVENT, @OGUID+146),
+(@EVENT, @OGUID+147),
+(@EVENT, @OGUID+148),
+(@EVENT, @OGUID+149),
+(@EVENT, @OGUID+150),
+(@EVENT, @OGUID+151),
+(@EVENT, @OGUID+152),
+(@EVENT, @OGUID+153),
+(@EVENT, @OGUID+154);