DB/Undercity: Added Love is in the Air spawns

1 files changed, 312 insertions, 0 deletions

diff --git a/sql/updates/world/master/2023_02_20_10_world.sql b/sql/updates/world/master/2023_02_20_10_world.sql
new file mode 100644
index 00000000000..0574527df8b
--- /dev/null
+++ b/sql/updates/world/master/2023_02_20_10_world.sql
@@ -0,0 +1,312 @@
+SET @CGUID := 3000055;
+SET @OGUID := 3001145;
+SET @EVENT := 8;
+
+-- Creature templates
+UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `speed_run`=1, `unit_flags`=32768 WHERE `entry`=38045; -- Kwee Q. Peddlefeet
+UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `speed_run`=1, `unit_flags`=33536, `unit_flags2`=67127296, `unit_flags3`=17301504 WHERE `entry`=37966; -- Undercity Love Boat
+UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `unit_flags`=33587200, `flags_extra`=`flags_extra`|128 WHERE `entry`=37964; -- [DND] Love Boat Summoner 02
+
+DELETE FROM `creature_template_addon` WHERE `entry` IN (38045, 37966, 37964);
+INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES
+(38045, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- 38045 (Kwee Q. Peddlefeet)
+(37966, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- 37966 (Undercity Love Boat)
+(37964, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''); -- 37964 ([DND] Love Boat Summoner 02)
+
+DELETE FROM `creature_template_movement` WHERE `CreatureId` IN (37964, 37966);
+INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`, `InteractionPauseTimer`) VALUES
+(37964, 0, 0, 1, 1, 0, 0, NULL),
+(37966, 0, 1, 1, 0, 0, 0, NULL);
+
+-- Gossips
+UPDATE `gossip_menu` SET `VerifiedBuild`=48069 WHERE (`MenuID`=8217 AND `TextID`=10212);
+
+-- Equipments
+UPDATE `creature_equip_template` SET `VerifiedBuild`=48069 WHERE (`ID`=1 AND `CreatureID` IN (53528,52319,52317,50609,50304,47587,47382,46483,39116,36517,36273,36226,36225,36224,34985,34983,30711,23776,23713,20406,16287,13839,11835,11067,11049,11048,11044,11031,10879,10781,10181,10136,10053,8403,8390,7980,7683,7297,7087,6741,6566,6522,6467,6411,6395,6293,5821,5820,5819,5754,5753,5747,5744,5733,5732,5731,5707,5706,5705,5704,5703,5702,5701,5700,5699,5698,5696,5693,5679,5675,5670,5669,5668,5665,5664,5663,5662,5661,5660,5659,5658,5657,5656,5655,5654,5653,5651,5204,5190,5052,4775,4617,4615,4614,4613,4612,4611,4610,4609,4608,4607,4605,4604,4603,4602,4601,4600,4599,4598,4597,4596,4595,4594,4593,4592,4591,4590,4589,4588,4587,4586,4585,4584,4583,4582,4581,4580,4578,4577,4576,4575,4574,4573,4572,4571,4570,4569,4568,4567,4566,4565,4564,4563,4562,4561,4560,4559,4558,4557,4556,4555,4554,4553,4552,4551,4549,4488,2934,2802,2799,2492,2459,2458,2308,2055,2050,1768,1498,223)) OR (`ID`=2 AND `CreatureID`=5697);
+
+-- Models
+UPDATE `creature_model_info` SET `VerifiedBuild`=48069 WHERE `DisplayID` IN (74857, 74859, 74856, 74858, 74837, 74834, 74835, 74833, 74838, 74839, 74853, 74852, 74854, 74822, 65411, 64888, 44094, 45952, 9807, 4122, 4121, 4012, 8054, 37692, 38381, 38376, 37959, 37958, 37834, 37833, 35161, 1566, 66644, 36172, 35570, 34074, 34073, 34075, 34076, 34064, 30500, 32658, 34055, 34054, 34057, 34056, 34051, 34053, 34052, 34050, 31290, 31314, 30852, 16925, 24719, 30163, 30075, 30073, 30072, 30071, 30069, 29507, 29506, 27294, 27260, 26451, 25624, 25902, 21746, 11466, 4732, 19596, 16112, 9904, 9906, 15781, 15783, 15780, 15784, 15782, 13856, 13807, 13855, 13854, 11756, 11694, 10590, 10581, 10580, 10576, 10572, 10187, 10130, 28213, 9353, 9273, 7994, 7995, 7632, 7599, 7597, 7117, 14369, 6837, 6065, 5845, 5449, 5346, 5206, 5235, 5576, 4987, 7449, 4381, 4379, 4378, 4150, 4149, 4123, 4120, 856, 328, 4119, 3975, 3979, 4111, 4110, 4109, 4108, 2346, 4064, 4063, 4062, 4061, 4060, 4059, 4058, 4057, 4053, 4052, 4054, 4050, 4020, 4009, 3948, 3020, 4005, 4010, 4004, 3883, 3880, 3882, 3879, 3876, 3863, 3859, 3860, 3861, 3862, 3864, 3854, 3853, 3019, 6228, 10699, 4056, 3130, 2998, 2811, 2651, 12955, 2665, 2669, 2621, 1201, 2623, 2676, 2624, 2618, 2626, 10723, 2615, 2656, 2643, 2616, 2627, 2628, 2672, 2617, 2649, 2632, 2614, 2658, 2620, 2642, 2670, 2633, 2635, 2613, 2661, 2630, 2625, 2631, 2639, 2659, 2648, 2668, 2664, 2671, 2634, 2663, 2667, 2612, 2650, 2640, 2673, 2619, 2657, 2644, 10733, 2646, 2637, 2675, 2652, 2622, 2654, 2653, 2666, 2636, 2629, 2660, 2674, 2647, 2662, 2638, 3942, 2655, 10197, 2177, 1418, 2176, 1141, 5751, 10563, 2610, 2810, 2641, 2645, 1585, 10731, 1680, 4011, 540, 346, 9020, 4055, 10619);
+
+-- Scaling
+DELETE FROM `creature_template_scaling` WHERE (`DifficultyID`=0 AND `Entry` IN (38045,37966,37964,5727));
+INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES
+(38045, 0, 0, 0, 378, 48069),
+(37966, 0, 0, 0, 378, 48069),
+(37964, 0, 0, 0, 378, 48069),
+(5727, 0, 0, 0, 867, 48069);
+
+UPDATE `creature_template_scaling` SET `VerifiedBuild`=48069 WHERE (`DifficultyID`=0 AND `Entry` IN (118702,118629,118628,118627,118625,118624,118623,118516,118511,97766,96368,62393,61905,61889,61829,61753,61366,61169,54244,53591,53528,53517,52588,52587,52319,52317,51496,51384,50609,49965,47587,47382,46560,46559,46483,44786,44766,44764,44737,44734,44733,44732,44731,43359,39116,37574,37543,36517,36273,36226,36225,36224,36217,36213,34985,34983,34281,30729,30711,29728,29139,29095,23776,23713,23103,20725,20406,16287,16030,15686,15684,15683,15682,15676,15675,13839,11835,11750,11067,11049,11048,11044,11031,10879,10781,10181,10136,10053,8721,8672,8403,8393,8390,7980,7683,7395,7297,7087,6741,6522,6467,6411,6395,6293,6033,5821,5820,5819,5754,5753,5747,5744,5738,5736,5735,5734,5733,5732,5731,5707,5706,5705,5704,5703,5702,5701,5700,5699,5698,5697,5696,5693,5679,5675,5674,5670,5669,5668,5665,5664,5663,5662,5661,5660,5659,5658,5657,5656,5655,5654,5653,5652,5651,5624,5204,5190,5052,4775,4617,4616,4615,4614,4613,4612,4611,4610,4609,4608,4607,4606,4605,4604,4603,4602,4601,4600,4599,4598,4597,4596,4595,4594,4593,4592,4591,4590,4589,4588,4587,4586,4585,4584,4583,4582,4581,4580,4578,4577,4576,4575,4574,4573,4572,4571,4570,4569,4568,4567,4566,4565,4564,4563,4562,4561,4560,4559,4558,4557,4556,4555,4554,4553,4552,4551,4550,4549,4488,4076,4075,2934,2802,2799,2492,2459,2458,2308,2227,2055,2050,1908,1768,1548,1498,223));
+
+-- Quests
+UPDATE `quest_poi` SET `VerifiedBuild`=48069 WHERE (`QuestID`=24613 AND `BlobIndex`=1 AND `Idx1`=2) OR (`QuestID`=24613 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=24613 AND `BlobIndex`=0 AND `Idx1`=0);
+
+UPDATE `quest_poi_points` SET `VerifiedBuild`=48069 WHERE (`QuestID`=24613 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=24613 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=24613 AND `Idx1`=0 AND `Idx2`=0);
+
+DELETE FROM `quest_details` WHERE `ID`=24613;
+INSERT INTO `quest_details` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `VerifiedBuild`) VALUES
+(24613, 0, 0, 0, 0, 0, 0, 0, 0, 48069); -- A Gift for the Banshee Queen
+
+DELETE FROM `creature_queststarter` WHERE (`id`=38045 AND `quest`=24613);
+INSERT INTO `creature_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(38045, 24613, 48069); -- A Gift for the Banshee Queen offered Kwee Q. Peddlefeet
+
+DELETE FROM `game_event_creature_quest` WHERE (`id`=38045 AND `quest`=24613);
+
+-- Old creature spawns
+DELETE FROM `creature` WHERE `guid`=52030;
+DELETE FROM `game_event_creature` WHERE `guid`=52030;
+
+-- 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, 0, 1497, 1497, '0', 0, 0, 0, 0, 1630.03125, 238.782989501953125, 65.06574249267578125, 6.230825424194335937, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 48069), -- Lovely Merchant (Area: 0 - Difficulty: 0) (Auras: )
+(@CGUID+1, 37675, 0, 1497, 1497, '0', 0, 0, 0, 0, 1630.0555419921875, 240.8854217529296875, 65.06858062744140625, 0.436332315206527709, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 48069), -- Public Relations Agent (Area: 0 - Difficulty: 0) (Auras: )
+(@CGUID+2, 37964, 0, 1497, 1497, '0', 0, 0, 0, 0, 1485.3316650390625, 348.76214599609375, -64.6302032470703125, 0.837758064270019531, 120, 0, 0, 1693785, 63100, 0, 0, 0, 0, 48069), -- [DND] Love Boat Summoner 02 (Area: Ruins of Lordaeron - Difficulty: 0)
+(@CGUID+3, 38045, 0, 1497, 1497, '0', 0, 0, 0, 0, 1630.888916015625, 234.814239501953125, 62.93344497680664062, 0.48869219422340393, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 48069), -- Kwee Q. Peddlefeet (Area: 0 - Difficulty: 0)
+(@CGUID+4, 38295, 0, 1497, 1497, '0', 0, 0, 0, 0, 1637.90625, 256.55035400390625, 62.677490234375, 4.223696708679199218, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 48069), -- Junior Detective (Area: Ruins of Lordaeron - Difficulty: 0)
+(@CGUID+5, 40438, 0, 1497, 1497, '0', 0, 0, 0, 0, 1637.60595703125, 239.5381927490234375, -43.0193977355957031, 3.106686115264892578, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 48069); -- Steamwheedle Shyster (Area: 0 - Difficulty: 0) (Auras: )
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+113;
+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, 0, 1497, 1497, '0', 0, 0, 1627.6475830078125, 241.607635498046875, 63.7686920166015625, 4.904376029968261718, 0, 0, -0.636077880859375, 0.771624863147735595, 120, 255, 1, 48069), -- Standing, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+1, 181015, 0, 1497, 1497, '0', 0, 0, 1630.0850830078125, 240.8697967529296875, 63.83428192138671875, 0.104719325900077819, 0, 0, 0.052335739135742187, 0.998629570007324218, 120, 255, 1, 48069), -- Standing, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+2, 181015, 0, 1497, 1497, '0', 0, 0, 1627.9583740234375, 238.3524322509765625, 65.02048492431640625, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 48069), -- Standing, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+3, 181015, 0, 1497, 1497, '0', 0, 0, 1627.953125, 238.28125, 63.79163360595703125, 6.073746204376220703, 0, 0, -0.10452842712402343, 0.994521915912628173, 120, 255, 1, 48069), -- Standing, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+4, 181015, 0, 1497, 1497, '0', 0, 0, 1629.99658203125, 238.7777862548828125, 63.81675338745117187, 6.12610626220703125, 0, 0, -0.07845878601074218, 0.996917366981506347, 120, 255, 1, 48069), -- Standing, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+5, 181015, 0, 1497, 1497, '0', 0, 0, 1595.8428955078125, 240.163055419921875, -52.1429328918457031, 0.890116631984710693, 0, 0, 0.430510520935058593, 0.902585566043853759, 120, 255, 1, 48069), -- Standing, Large - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+6, 181016, 0, 1497, 1497, '0', 0, 0, 1589.828857421875, 245.835418701171875, 60.15068817138671875, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+7, 181016, 0, 1497, 1497, '0', 0, 0, 1589.5499267578125, 234.288330078125, 60.15068817138671875, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+8, 181016, 0, 1497, 1497, '0', 0, 0, 1769.0699462890625, 72.61750030517578125, -45.2478981018066406, 5.078907966613769531, 0, 0, -0.56640625, 0.824126183986663818, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: Tirisfal Glades - Difficulty: 0)
+(@OGUID+9, 181016, 0, 1497, 1497, '0', 0, 0, 1761.9300537109375, 64.971099853515625, -45.2478981018066406, 5.916667938232421875, 0, 0, -0.18223476409912109, 0.98325502872467041, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: Tirisfal Glades - Difficulty: 0)
+(@OGUID+10, 181018, 0, 1497, 1497, '0', 0, 0, 1605.1632080078125, 230.5572967529296875, -47.8257369995117187, 5.532694816589355468, 0, 0, -0.3665008544921875, 0.93041771650314331, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+11, 181018, 0, 1497, 1497, '0', 0, 0, 1586.0728759765625, 250.11285400390625, -47.698760986328125, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Medium - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+12, 181018, 0, 1497, 1497, '0', 0, 0, 1605.4427490234375, 249.8697967529296875, -47.7426528930664062, 0.802850961685180664, 0, 0, 0.390730857849121093, 0.920504987239837646, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Medium - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+13, 181018, 0, 1497, 1497, '0', 0, 0, 1585.8629150390625, 230.6458282470703125, -47.8968849182128906, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Medium - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+14, 181019, 0, 1497, 1497, '0', 0, 0, 1715.1348876953125, 232.0016021728515625, -41.2660484313964843, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: Tirisfal Glades - Difficulty: 0)
+(@OGUID+15, 181019, 0, 1497, 1497, '0', 0, 0, 1700.9322509765625, 241.1961822509765625, -40.1241340637207031, 1.308995485305786132, 0, 0, 0.608760833740234375, 0.793353796005249023, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+16, 181019, 0, 1497, 1497, '0', 0, 0, 1702.40625, 232.1041717529296875, -41.2568702697753906, 3.159062385559082031, 0, 0, -0.99996185302734375, 0.008734640665352344, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+17, 181019, 0, 1497, 1497, '0', 0, 0, 1700.8992919921875, 237.7465362548828125, -40.1240653991699218, 2.129300594329833984, 0, 0, 0.874619483947753906, 0.484810054302215576, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+18, 181019, 0, 1497, 1497, '0', 0, 0, 1708.2965087890625, 231.7843780517578125, -41.2570877075195312, 1.675513744354248046, 0, 0, 0.743144035339355468, 0.669131457805633544, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+19, 181019, 0, 1497, 1497, '0', 0, 0, 1690.9288330078125, 232.203125, -41.2571563720703125, 2.44346022605895996, 0, 0, 0.939692497253417968, 0.34202045202255249, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+20, 181019, 0, 1497, 1497, '0', 0, 0, 1682.9410400390625, 232.4444427490234375, -41.25701904296875, 2.164205789566040039, 0, 0, 0.882946968078613281, 0.469472706317901611, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+21, 181019, 0, 1497, 1497, '0', 0, 0, 1590.3524169921875, 206.828125, -54.266571044921875, 2.914689540863037109, 0, 0, 0.993571281433105468, 0.113208353519439697, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+22, 181019, 0, 1497, 1497, '0', 0, 0, 1586.315185546875, 277.427825927734375, -54.2526359558105468, 1.134462952613830566, 0, 0, 0.537299156188964843, 0.843391716480255126, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+23, 181019, 0, 1497, 1497, '0', 0, 0, 1605.6944580078125, 276.23785400390625, -54.2526283264160156, 6.003933906555175781, 0, 0, -0.13917255401611328, 0.990268170833587646, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+24, 181019, 0, 1497, 1497, '0', 0, 0, 1714.6978759765625, 246.5416717529296875, -41.2577400207519531, 2.181660413742065429, 0, 0, 0.887010574340820312, 0.461749136447906494, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+25, 181019, 0, 1497, 1497, '0', 0, 0, 1708.935791015625, 246.7256927490234375, -41.2577285766601562, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+26, 181019, 0, 1497, 1497, '0', 0, 0, 1690.7396240234375, 247.125, -41.2577095031738281, 1.099556446075439453, 0, 0, 0.522498130798339843, 0.852640450000762939, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+27, 181019, 0, 1497, 1497, '0', 0, 0, 1702.2708740234375, 246.8350677490234375, -41.2572784423828125, 0.226892471313476562, 0, 0, 0.113203048706054687, 0.993571877479553222, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+28, 181019, 0, 1497, 1497, '0', 0, 0, 1682.744873046875, 246.8034210205078125, -41.2576675415039062, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+29, 181025, 0, 1497, 1497, '0', 0, 0, 1783.2021484375, 237.7364959716796875, -50.62408447265625, 3.159062385559082031, 0, 0, -0.99996185302734375, 0.008734640665352344, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: Tirisfal Glades - Difficulty: 0)
+(@OGUID+30, 181025, 0, 1497, 1497, '0', 0, 0, 1719.1656494140625, 239.08837890625, -24.510965347290039, 0, 0, 0, 0, 1, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: Tirisfal Glades - Difficulty: 0)
+(@OGUID+31, 181025, 0, 1497, 1497, '0', 0, 0, 1594.3900146484375, 52.9281005859375, -50.7142982482910156, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+32, 181025, 0, 1497, 1497, '0', 0, 0, 1408.340087890625, 241.41070556640625, -50.6635971069335937, 0.017452461645007133, 0, 0, 0.008726119995117187, 0.999961912631988525, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+33, 181025, 0, 1497, 1497, '0', 0, 0, 1702.953125, 531.1961669921875, -3.7574169635772705, 3.874631166458129882, 0, 0, -0.93358039855957031, 0.358368009328842163, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+34, 181025, 0, 1497, 1497, '0', 0, 0, 1696.1666259765625, 524.71875, -3.46358394622802734, 0.767943859100341796, 0, 0, 0.374606132507324218, 0.927184045314788818, 120, 255, 1, 48069), -- Hanging, Tall/Thin, Large - Val (Area: 0 - Difficulty: 0)
+(@OGUID+35, 181027, 0, 1497, 1497, '0', 0, 0, 1757.701416015625, 242.39410400390625, -64.4785614013671875, 4.241150379180908203, 0, 0, -0.85264015197753906, 0.522498607635498046, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Tirisfal Glades - Difficulty: 0)
+(@OGUID+36, 181027, 0, 1497, 1497, '0', 0, 0, 1743.01220703125, 196.17535400390625, -64.4785614013671875, 3.717553615570068359, 0, 0, -0.95881938934326171, 0.284016460180282592, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Tirisfal Glades - Difficulty: 0)
+(@OGUID+37, 181027, 0, 1497, 1497, '0', 0, 0, 1751.6961669921875, 277.83160400390625, -64.4785614013671875, 0.802850961685180664, 0, 0, 0.390730857849121093, 0.920504987239837646, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Tirisfal Glades - Difficulty: 0)
+(@OGUID+38, 181027, 0, 1497, 1497, '0', 0, 0, 1735.892333984375, 157.373260498046875, -64.4785614013671875, 4.59021615982055664, 0, 0, -0.74895572662353515, 0.662620067596435546, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Tirisfal Glades - Difficulty: 0)
+(@OGUID+39, 181027, 0, 1497, 1497, '0', 0, 0, 1704.9322509765625, 125.1614608764648437, -67.8613357543945312, 4.188792228698730468, 0, 0, -0.86602497100830078, 0.50000077486038208, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Tirisfal Glades - Difficulty: 0)
+(@OGUID+40, 181027, 0, 1497, 1497, '0', 0, 0, 1667.69970703125, 107.447906494140625, -64.4785614013671875, 5.026549339294433593, 0, 0, -0.5877847671508789, 0.809017360210418701, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Tirisfal Glades - Difficulty: 0)
+(@OGUID+41, 181027, 0, 1497, 1497, '0', 0, 0, 1634.06005859375, 90.87000274658203125, -64.4785614013671875, 2.234017848968505859, 0, 0, 0.898793220520019531, 0.438372820615768432, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+42, 181027, 0, 1497, 1497, '0', 0, 0, 1609.729248046875, 208.7392120361328125, -64.4785614013671875, 4.991643905639648437, 0, 0, -0.60181427001953125, 0.798636078834533691, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+43, 181027, 0, 1497, 1497, '0', 0, 0, 1594.96533203125, 77.49826812744140625, -64.4785614013671875, 6.108653545379638671, 0, 0, -0.08715534210205078, 0.996194720268249511, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+44, 181027, 0, 1497, 1497, '0', 0, 0, 1581.261962890625, 208.7772979736328125, -64.4785614013671875, 5.619962215423583984, 0, 0, -0.32556724548339843, 0.945518851280212402, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+45, 181027, 0, 1497, 1497, '0', 0, 0, 1556.19970703125, 83.13541412353515625, -64.4785614013671875, 3.769911527633666992, 0, 0, -0.95105648040771484, 0.309017121791839599, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+46, 181027, 0, 1497, 1497, '0', 0, 0, 1513.7083740234375, 100.5572891235351562, -64.4785614013671875, 0.453785061836242675, 0, 0, 0.224950790405273437, 0.974370121955871582, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+47, 181027, 0, 1497, 1497, '0', 0, 0, 1481.61328125, 127.7064132690429687, -64.4785614013671875, 1.308995485305786132, 0, 0, 0.608760833740234375, 0.793353796005249023, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+48, 181027, 0, 1497, 1497, '0', 0, 0, 1453.279541015625, 159.7118072509765625, -64.4785614013671875, 3.857182979583740234, 0, 0, -0.93667125701904296, 0.350209832191467285, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+49, 181027, 0, 1497, 1497, '0', 0, 0, 1452.7066650390625, 187.1041717529296875, -64.4785614013671875, 4.660029888153076171, 0, 0, -0.72537422180175781, 0.688354730606079101, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+50, 181027, 0, 1497, 1497, '0', 0, 0, 1442.8680419921875, 242.888885498046875, -64.4785614013671875, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+51, 181027, 0, 1497, 1497, '0', 0, 0, 1452.1944580078125, 294.993072509765625, -64.4785614013671875, 3.996806621551513671, 0, 0, -0.90996074676513671, 0.414694398641586303, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+52, 181027, 0, 1497, 1497, '0', 0, 0, 1455.0382080078125, 322.291656494140625, -64.4785614013671875, 1.291541695594787597, 0, 0, 0.60181427001953125, 0.798636078834533691, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+53, 181027, 0, 1497, 1497, '0', 0, 0, 1480.517333984375, 358.368072509765625, -64.4785614013671875, 1.48352813720703125, 0, 0, 0.675589561462402343, 0.737277925014495849, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+54, 181027, 0, 1497, 1497, '0', 0, 0, 1515.90625, 382.6632080078125, -64.4785614013671875, 0.296705186367034912, 0, 0, 0.147809028625488281, 0.989015936851501464, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+55, 181027, 0, 1497, 1497, '0', 0, 0, 1554.5572509765625, 396.56597900390625, -64.4785614013671875, 4.223697185516357421, 0, 0, -0.85716724395751953, 0.515038192272186279, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+56, 181027, 0, 1497, 1497, '0', 0, 0, 1582.8155517578125, 270.91943359375, -64.4785614013671875, 1.186823248863220214, 0, 0, 0.559192657470703125, 0.829037725925445556, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+57, 181027, 0, 1497, 1497, '0', 0, 0, 1611.554931640625, 269.952301025390625, -64.4785614013671875, 3.752462387084960937, 0, 0, -0.95371627807617187, 0.300707906484603881, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+58, 181027, 0, 1497, 1497, '0', 0, 0, 1596.826416015625, 392.0069580078125, -64.4785614013671875, 5.93412017822265625, 0, 0, -0.17364788055419921, 0.984807789325714111, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+59, 181027, 0, 1497, 1497, '0', 0, 0, 1636.529541015625, 389.251739501953125, -64.4785614013671875, 0.383971005678176879, 0, 0, 0.190808296203613281, 0.981627285480499267, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+60, 181027, 0, 1497, 1497, '0', 0, 0, 1686.798583984375, 364.626739501953125, -64.4785614013671875, 0.907570242881774902, 0, 0, 0.438370704650878906, 0.898794233798980712, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+61, 181027, 0, 1497, 1497, '0', 0, 0, 1720.8299560546875, 336.019012451171875, -67.5817031860351562, 0.645771682262420654, 0, 0, 0.317304611206054687, 0.948323667049407958, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+62, 181060, 0, 1497, 1497, '0', 0, 0, 1772.4000244140625, 72.19210052490234375, -45.2444992065429687, 4.677483558654785156, 0, 0, -0.71933937072753906, 0.694658815860748291, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Tirisfal Glades - Difficulty: 0)
+(@OGUID+63, 181060, 0, 1497, 1497, '0', 0, 0, 1762, 61.73509979248046875, -45.2444992065429687, 0.034906249493360519, 0, 0, 0.017452239990234375, 0.999847710132598876, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Tirisfal Glades - Difficulty: 0)
+(@OGUID+64, 181060, 0, 1497, 1497, '0', 0, 0, 1633.423583984375, 227.125, -34.8087158203125, 2.844882726669311523, 0, 0, 0.989015579223632812, 0.147811368107795715, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0)
+(@OGUID+65, 181060, 0, 1497, 1497, '0', 0, 0, 1620.7291259765625, 209.984375, -34.84014892578125, 2.181660413742065429, 0, 0, 0.887010574340820312, 0.461749136447906494, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0)
+(@OGUID+66, 181060, 0, 1497, 1497, '0', 0, 0, 1618.0833740234375, 205.6163177490234375, -40.7263679504394531, 5.305802345275878906, 0, 0, -0.46947097778320312, 0.882947921752929687, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0)
+(@OGUID+67, 181060, 0, 1497, 1497, '0', 0, 0, 1603.578125, 198.9774322509765625, -40.7299537658691406, 1.832594871520996093, 0, 0, 0.793353080749511718, 0.608761727809906005, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0)
+(@OGUID+68, 181060, 0, 1497, 1497, '0', 0, 0, 1629.359375, 216.486114501953125, -40.6939468383789062, 5.637413978576660156, 0, 0, -0.31730461120605468, 0.948323667049407958, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0)
+(@OGUID+69, 181060, 0, 1497, 1497, '0', 0, 0, 1607.40625, 202.19097900390625, -34.8443832397460937, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0)
+(@OGUID+70, 181060, 0, 1497, 1497, '0', 0, 0, 1624.9305419921875, 214.1336822509765625, -34.8113288879394531, 2.513273954391479492, 0, 0, 0.951056480407714843, 0.309017121791839599, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0)
+(@OGUID+71, 181060, 0, 1497, 1497, '0', 0, 0, 1630.38720703125, 221.2916717529296875, -34.8106613159179687, 0.925023794174194335, 0, 0, 0.446197509765625, 0.894934535026550292, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0)
+(@OGUID+72, 181060, 0, 1497, 1497, '0', 0, 0, 1613.23095703125, 204.8854217529296875, -34.8433265686035156, 3.665196180343627929, 0, 0, -0.96592521667480468, 0.258821308612823486, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0)
+(@OGUID+73, 181060, 0, 1497, 1497, '0', 0, 0, 1636.8072509765625, 230.7916717529296875, -40.6942138671875, 5.986480236053466796, 0, 0, -0.14780902862548828, 0.989015936851501464, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0)
+(@OGUID+74, 181060, 0, 1497, 1497, '0', 0, 0, 1572.717041015625, 205.9913177490234375, -40.7268295288085937, 0.959929943084716796, 0, 0, 0.461748123168945312, 0.887011110782623291, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0)
+(@OGUID+75, 181060, 0, 1497, 1497, '0', 0, 0, 1600.7476806640625, 223.210479736328125, 60.1515045166015625, 3.106652259826660156, 0, 0, 0.999847412109375, 0.017469281330704689, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0)
+(@OGUID+76, 181060, 0, 1497, 1497, '0', 0, 0, 1583.3228759765625, 202.3871612548828125, -34.8442459106445312, 4.415683269500732421, 0, 0, -0.80385684967041015, 0.594822824001312255, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0)
+(@OGUID+77, 181060, 0, 1497, 1497, '0', 0, 0, 1577.5816650390625, 205.1840362548828125, -34.8433837890625, 4.136432647705078125, 0, 0, -0.87881660461425781, 0.477159708738327026, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0)
+(@OGUID+78, 181060, 0, 1497, 1497, '0', 0, 0, 1590.3629150390625, 223.3343353271484375, 60.1515045166015625, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0)
+(@OGUID+79, 181060, 0, 1497, 1497, '0', 0, 0, 1636.0260009765625, 235.576385498046875, -34.8121871948242187, 2.827429771423339843, 0, 0, 0.987688064575195312, 0.156436234712600708, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0)
+(@OGUID+80, 181060, 0, 1497, 1497, '0', 0, 0, 1636.1007080078125, 244.3541717529296875, -34.8122482299804687, 3.385940074920654296, 0, 0, -0.99254608154296875, 0.121869951486587524, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0)
+(@OGUID+81, 181060, 0, 1497, 1497, '0', 0, 0, 1587.1319580078125, 199.11285400390625, -40.72998046875, 1.32644820213317871, 0, 0, 0.615660667419433593, 0.788011372089385986, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0)
+(@OGUID+82, 181060, 0, 1497, 1497, '0', 0, 0, 1570.1666259765625, 210.420135498046875, -34.8405036926269531, 4.084071159362792968, 0, 0, -0.8910064697265625, 0.453990638256072998, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0)
+(@OGUID+83, 181060, 0, 1497, 1497, '0', 0, 0, 1566.03125, 214.640625, -34.8114433288574218, 3.769911527633666992, 0, 0, -0.95105648040771484, 0.309017121791839599, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+84, 181060, 0, 1497, 1497, '0', 0, 0, 1561.6666259765625, 217.0260467529296875, -40.6939964294433593, 0.645771682262420654, 0, 0, 0.317304611206054687, 0.948323667049407958, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+85, 181060, 0, 1497, 1497, '0', 0, 0, 1557.7691650390625, 227.7708282470703125, -34.8091163635253906, 0.27925160527229309, 0, 0, 0.139172554016113281, 0.990268170833587646, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+86, 181060, 0, 1497, 1497, '0', 0, 0, 1554.4410400390625, 231.47222900390625, -40.6943588256835937, 0.314158439636230468, 0, 0, 0.156434059143066406, 0.987688362598419189, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+87, 181060, 0, 1497, 1497, '0', 0, 0, 1554.5885009765625, 249.8211822509765625, -40.6941413879394531, 6.003933906555175781, 0, 0, -0.13917255401611328, 0.990268170833587646, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+88, 181060, 0, 1497, 1497, '0', 0, 0, 1560.71533203125, 222, -34.8123359680175781, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+89, 181060, 0, 1497, 1497, '0', 0, 0, 1578.1978759765625, 275.744781494140625, -34.8436012268066406, 5.270895957946777343, 0, 0, -0.48480892181396484, 0.87462007999420166, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+90, 181060, 0, 1497, 1497, '0', 0, 0, 1562.029541015625, 264.161468505859375, -40.6943092346191406, 5.637413978576660156, 0, 0, -0.31730461120605468, 0.948323667049407958, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+91, 181060, 0, 1497, 1497, '0', 0, 0, 1566.4305419921875, 266.50347900390625, -34.8109512329101562, 5.637413978576660156, 0, 0, -0.31730461120605468, 0.948323667049407958, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+92, 181060, 0, 1497, 1497, '0', 0, 0, 1573.295166015625, 275.01910400390625, -40.7265434265136718, 5.253442287445068359, 0, 0, -0.49242305755615234, 0.870355963706970214, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+93, 181060, 0, 1497, 1497, '0', 0, 0, 1561.0347900390625, 259.25, -34.8115119934082031, 5.637413978576660156, 0, 0, -0.31730461120605468, 0.948323667049407958, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+94, 181060, 0, 1497, 1497, '0', 0, 0, 1557.9566650390625, 253.513885498046875, -34.8083381652832031, 5.986480236053466796, 0, 0, -0.14780902862548828, 0.989015936851501464, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+95, 181060, 0, 1497, 1497, '0', 0, 0, 1570.6805419921875, 270.711822509765625, -34.8390159606933593, 5.305802345275878906, 0, 0, -0.46947097778320312, 0.882947921752929687, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+96, 181060, 0, 1497, 1497, '0', 0, 0, 1583.9896240234375, 278.458343505859375, -34.8444709777832031, 4.991643905639648437, 0, 0, -0.60181427001953125, 0.798636078834533691, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+97, 181060, 0, 1497, 1497, '0', 0, 0, 1604.2847900390625, 281.520843505859375, -40.72979736328125, 4.433136463165283203, 0, 0, -0.79863548278808593, 0.60181504487991333, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+98, 181060, 0, 1497, 1497, '0', 0, 0, 1590.423583984375, 256.86651611328125, 60.15149688720703125, 6.230826377868652343, 0, 0, -0.02617645263671875, 0.999657332897186279, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+99, 181060, 0, 1497, 1497, '0', 0, 0, 1579.1903076171875, 245.8570098876953125, 60.15149688720703125, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+100, 181060, 0, 1497, 1497, '0', 0, 0, 1587.720458984375, 281.642364501953125, -40.7300148010253906, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+101, 181060, 0, 1497, 1497, '0', 0, 0, 1608.07470703125, 278.2413330078125, -34.844512939453125, 4.433136463165283203, 0, 0, -0.79863548278808593, 0.60181504487991333, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+102, 181060, 0, 1497, 1497, '0', 0, 0, 1601.556396484375, 256.76666259765625, 60.15149688720703125, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+103, 181060, 0, 1497, 1497, '0', 0, 0, 1578.8707275390625, 234.809326171875, 60.1515045166015625, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+104, 181060, 0, 1497, 1497, '0', 0, 0, 1618.75, 274.61285400390625, -40.726959228515625, 4.101525306701660156, 0, 0, -0.88701057434082031, 0.461749136447906494, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+105, 181060, 0, 1497, 1497, '0', 0, 0, 1625.3663330078125, 266.015625, -34.8114051818847656, 3.735006093978881835, 0, 0, -0.95630455017089843, 0.292372345924377441, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+106, 181060, 0, 1497, 1497, '0', 0, 0, 1613.7899169921875, 275.435760498046875, -34.8438453674316406, 4.101525306701660156, 0, 0, -0.88701057434082031, 0.461749136447906494, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+107, 181060, 0, 1497, 1497, '0', 0, 0, 1621.21533203125, 270.211822509765625, -34.8408279418945312, 4.101525306701660156, 0, 0, -0.88701057434082031, 0.461749136447906494, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+108, 181060, 0, 1497, 1497, '0', 0, 0, 1629.8004150390625, 263.55035400390625, -40.6943588256835937, 3.769911527633666992, 0, 0, -0.95105648040771484, 0.309017121791839599, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+109, 181060, 0, 1497, 1497, '0', 0, 0, 1630.6875, 258.633697509765625, -34.811614990234375, 3.717553615570068359, 0, 0, -0.95881938934326171, 0.284016460180282592, 120, 255, 1, 48069), -- Standing, Interior; Small - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+110, 181060, 0, 1497, 1497, '0', 0, 0, 1633.6458740234375, 252.861114501953125, -34.8087959289550781, 3.420850038528442382, 0, 0, -0.99026775360107421, 0.139175355434417724, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+111, 181060, 0, 1497, 1497, '0', 0, 0, 1636.967041015625, 249.140625, -40.6942634582519531, 3.403396368026733398, 0, 0, -0.99144458770751953, 0.130528271198272705, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Ruins of Lordaeron - Difficulty: 0)
+(@OGUID+112, 181060, 0, 1497, 1497, '0', 0, 0, 1765.550048828125, 68.70510101318359375, -45.2478981018066406, 5.480334281921386718, 0, 0, -0.39073085784912109, 0.920504987239837646, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Tirisfal Glades - Difficulty: 0)
+(@OGUID+113, 201940, 0, 1497, 1497, '0', 0, 0, 1629.0191650390625, 239.795135498046875, 63.8515167236328125, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 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+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+113;
+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);