aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorMeji <alvaro.megias@outlook.com>2023-02-20 21:35:55 +0100
committerMeji <alvaro.megias@outlook.com>2023-02-20 21:35:55 +0100
commitd26f5bafca117f8dfb328d5068b1a35641249205 (patch)
treeffc9c88ffe0ab8cc9d4b5883931f91422540c891 /sql
parentbf9e47001d8cba3331bebbc7b8a107472fdc4050 (diff)
DB/ThunderBluff: Added Love is in the Air spawns
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2023_02_20_09_world.sql329
1 files changed, 329 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_02_20_09_world.sql b/sql/updates/world/master/2023_02_20_09_world.sql
new file mode 100644
index 00000000000..c8b5e304b8d
--- /dev/null
+++ b/sql/updates/world/master/2023_02_20_09_world.sql
@@ -0,0 +1,329 @@
+SET @CGUID := 3000050;
+SET @OGUID := 3001025;
+SET @EVENT := 8;
+
+-- Creature templates
+UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `npcflag`=3, `unit_flags`=512 WHERE `entry`=38295; -- Junior Detective
+UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70, `speed_run`=1, `unit_flags`=32768 WHERE `entry`=38044; -- Kwee Q. Peddlefeet
+
+DELETE FROM `creature_template_addon` WHERE `entry` IN (38295, 38044);
+INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES
+(38295, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- 38295 (Junior Detective)
+(38044, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''); -- 38044 (Kwee Q. Peddlefeet)
+
+-- Gossips
+UPDATE `gossip_menu` SET `VerifiedBuild`=48069 WHERE (`MenuID`=10991 AND `TextID`=15284);
+
+-- Equipments
+UPDATE `creature_equip_template` SET `VerifiedBuild`=48069 WHERE (`ID`=1 AND `CreatureID` IN (133271,133218,96470,52651,51640,51639,51638,51372,51143,50483,47589,47572,43892,43883,43881,43870,43796,43795,43004,43001,36648,34978,34976,34766,30709,14442,14441,14440,11084,11071,11047,10881,10278,10086,10054,9087,9076,8664,8401,8398,8364,8363,8362,8361,8357,8356,7089,6746,6410,6393,5957,5906,5770,5769,5599,5543,5189,5054,4943,4721,3978,3447,3441,3419,3095,3093,3092,3084,3083,3050,3049,3048,3047,3046,3045,3044,3043,3042,3041,3040,3039,3038,3037,3036,3034,3033,3029,3028,3027,3026,3025,3024,3023,3022,3021,3020,3019,3018,3017,3016,3015,3014,3013,3012,3011,3010,3009,3008,3007,3005,3004,3003,3002,3001,2999,2998,2997,2996,2995,2798));
+
+-- Models
+DELETE FROM `creature_model_info` WHERE `DisplayID` IN (110602, 110598, 110597, 110595, 110594, 110593, 110589);
+INSERT INTO `creature_model_info` (`DisplayID`, `BoundingRadius`, `CombatReach`, `DisplayID_Other_Gender`, `VerifiedBuild`) VALUES
+(110602, 0.698000013828277587, 3, 0, 48069),
+(110598, 0.722000002861022949, 3, 0, 48069),
+(110597, 0.698000013828277587, 3, 0, 48069),
+(110595, 0.722000002861022949, 3, 0, 48069),
+(110594, 0.698000013828277587, 3, 0, 48069),
+(110593, 0.698000013828277587, 3, 0, 48069),
+(110589, 0.722000002861022949, 3, 0, 48069);
+
+UPDATE `creature_model_info` SET `VerifiedBuild`=48069 WHERE `DisplayID` IN (82820, 82821, 83225, 82748, 74863, 64916, 42497, 45958, 38011, 38010, 38009, 38006, 37564, 37563, 37562, 37400, 37343, 37344, 37342, 37345, 37013, 37022, 35712, 35697, 33550, 33544, 33542, 33540, 29250, 29249, 33539, 33524, 31016, 30272, 29503, 29502, 29398, 27289, 27257, 14496, 14495, 14494, 10617, 10614, 10586, 10577, 10188, 9742, 9337, 9272, 8356, 8355, 7998, 7999, 7936, 7629, 10689, 7627, 7628, 7626, 7625, 7624, 7623, 7622, 7620, 7621, 5847, 5487, 5372, 5371, 4959, 4665, 4542, 4513, 4519, 3550, 3371, 3129, 3002, 2951, 2738, 43948, 1547, 4518, 1056, 4383, 4520, 1814, 2132, 2129, 2133, 2140, 4517, 2135, 6058, 2134, 2137, 2138, 2139, 2113, 2096, 2103, 2105, 2087, 2112, 2122, 2115, 1059, 2121, 2106, 2120, 2088, 2095, 2107, 2111, 2097, 2125, 2124, 2089, 2085, 2084, 2086, 2117, 2099, 2114, 2119, 2091, 2118, 2101, 2116, 2108, 2094, 2127, 2093, 2126, 2109, 2092, 2083, 2100, 2090, 2110, 2104, 2098, 10869, 1255, 161, 643, 1221, 1220, 2131, 1072, 4626);
+UPDATE `creature_model_info` SET `BoundingRadius`=1.374822378158569335, `CombatReach`=1.105102062225341796, `VerifiedBuild`=48069 WHERE `DisplayID`=1228;
+
+-- Scaling
+DELETE FROM `creature_template_scaling` WHERE (`DifficultyID`=0 AND `Entry` IN (199258,199245,199241,199240,199239,199225,199222,38295,38044));
+INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES
+(199258, 0, 0, 0, 865, 48069),
+(199245, 0, 0, 0, 865, 48069),
+(199241, 0, 0, 0, 865, 48069),
+(199240, 0, 0, 0, 865, 48069),
+(199239, 0, 0, 0, 865, 48069),
+(199225, 0, 0, 0, 865, 48069),
+(199222, 0, 0, 0, 865, 48069),
+(38295, 0, 0, 0, 378, 48069),
+(38044, 0, 0, 0, 378, 48069);
+
+UPDATE `creature_template_scaling` SET `VerifiedBuild`=48069 WHERE (`DifficultyID`=0 AND `Entry` IN (133218,118512,96470,62462,62176,61143,61141,52658,52657,52655,52651,51640,51639,51638,51503,51372,51143,50483,47589,47572,43892,43883,43881,43870,43796,43795,43004,43001,36648,34978,34976,34766,30724,30709,15164,14442,14441,14440,12383,11084,11071,11051,11047,10881,10278,10086,10054,9087,9076,8722,8674,8664,8401,8398,8364,8363,8362,8361,8360,8359,8358,8357,8356,7089,6746,6410,6393,6271,5957,5906,5770,5769,5599,5543,5189,5054,4943,4721,4166,3978,3566,3447,3441,3419,3095,3093,3092,3083,3050,3049,3048,3047,3046,3045,3044,3043,3042,3041,3040,3039,3038,3037,3036,3035,3034,3033,3029,3028,3027,3026,3025,3024,3023,3022,3021,3020,3019,3018,3017,3016,3015,3014,3013,3012,3011,3010,3009,3008,3007,3005,3004,3003,3002,3001,2999,2998,2997,2996,2995,2971,2969,2965,2964,2960,2959,2957,2956,2798,2620,721));
+
+-- Quests
+UPDATE `quest_poi` SET `VerifiedBuild`=48069 WHERE (`QuestID`=24614 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=24614 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=24805 AND `BlobIndex`=4 AND `Idx1`=5) OR (`QuestID`=24805 AND `BlobIndex`=3 AND `Idx1`=4) OR (`QuestID`=24805 AND `BlobIndex`=2 AND `Idx1`=3) OR (`QuestID`=24805 AND `BlobIndex`=1 AND `Idx1`=2) OR (`QuestID`=24805 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=24805 AND `BlobIndex`=0 AND `Idx1`=0);
+
+UPDATE `quest_poi_points` SET `VerifiedBuild`=48069 WHERE (`QuestID`=24614 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=24614 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=24805 AND `Idx1`=5 AND `Idx2`=0) OR (`QuestID`=24805 AND `Idx1`=4 AND `Idx2`=0) OR (`QuestID`=24805 AND `Idx1`=3 AND `Idx2`=0) OR (`QuestID`=24805 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=24805 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=24805 AND `Idx1`=0 AND `Idx2`=0);
+
+DELETE FROM `quest_details` WHERE `ID` IN (24614 /*A Gift for the High Chieftain*/, 24805 /*Uncommon Scents*/);
+INSERT INTO `quest_details` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `VerifiedBuild`) VALUES
+(24614, 0, 0, 0, 0, 0, 0, 0, 0, 48069), -- A Gift for the High Chieftain
+(24805, 1, 0, 0, 0, 0, 0, 0, 0, 48069); -- Uncommon Scents
+
+DELETE FROM `creature_queststarter` WHERE (`id`=38044 AND `quest`=24614) OR (`id`=38295 AND `quest`=24805);
+INSERT INTO `creature_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(38044, 24614, 48069), -- A Gift for the High Chieftain offered Kwee Q. Peddlefeet
+(38295, 24805, 48069); -- Uncommon Scents offered Junior Detective
+
+DELETE FROM `game_event_creature_quest` WHERE (`id`=38044 AND `quest`=24614) OR (`id`=38295 AND `quest`=24805);
+
+-- 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, 1, 1638, 5345, '0', 0, 0, 0, 0, -1218.8819580078125, 63.5868072509765625, 130.904083251953125, 3.455751895904541015, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 48069), -- Lovely Merchant (Area: Thunder Bluff - Difficulty: 0) (Auras: )
+(@CGUID+1, 37675, 1, 1638, 5345, '0', 0, 0, 0, 0, -1218.1666259765625, 61.68402862548828125, 130.866973876953125, 3.665191411972045898, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 48069), -- Public Relations Agent (Area: Thunder Bluff - Difficulty: 0) (Auras: )
+(@CGUID+2, 38044, 1, 1638, 5345, '0', 0, 0, 0, 0, -1216.001708984375, 57.39409637451171875, 130.0072784423828125, 3.769911050796508789, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 48069), -- Kwee Q. Peddlefeet (Area: Thunder Bluff - Difficulty: 0)
+(@CGUID+3, 38295, 1, 1638, 5345, '0', 0, 0, 0, 0, -1238.6666259765625, 55.02777862548828125, 127.1610794067382812, 0.48869219422340393, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 48069), -- Junior Detective (Area: Thunder Bluff - Difficulty: 0) (Auras: )
+(@CGUID+4, 40438, 1, 1638, 5345, '0', 0, 0, 0, 0, -1273.0242919921875, 71.2743072509765625, 128.0668182373046875, 5.8817596435546875, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 48069); -- Steamwheedle Shyster (Area: Thunder Bluff - Difficulty: 0)
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+119;
+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, 1, 1638, 5345, '0', 0, 0, -1297.6649169921875, 192.8706817626953125, 137.1883697509765625, 1.658061861991882324, 0, 0, 0.737277030944824218, 0.67559051513671875, 120, 255, 1, 48069), -- Hanging, Square, Large - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+1, 181014, 1, 1638, 5345, '0', 0, 0, -1204.99658203125, 134.3524932861328125, 149.1890411376953125, 3.857182979583740234, 0, 0, -0.93667125701904296, 0.350209832191467285, 120, 255, 1, 48069), -- Hanging, Square, Large - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+2, 181014, 1, 1638, 5345, '0', 0, 0, -1210.715087890625, 34.21560287475585937, 192.2454376220703125, 2.844882726669311523, 0, 0, 0.989015579223632812, 0.147811368107795715, 120, 255, 1, 48069), -- Hanging, Square, Large - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+3, 181014, 1, 1638, 5345, '0', 0, 0, -1184.013916015625, 27.71354103088378906, 195.24468994140625, 5.986480236053466796, 0, 0, -0.14780902862548828, 0.989015936851501464, 120, 255, 1, 48069), -- Hanging, Square, Large - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+4, 181014, 1, 1638, 5345, '0', 0, 0, -1123.9444580078125, 65.1875, 158.3504791259765625, 4.415683269500732421, 0, 0, -0.80385684967041015, 0.594822824001312255, 120, 255, 1, 48069), -- Hanging, Square, Large - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+5, 181014, 1, 1638, 5345, '0', 0, 0, -1236.5347900390625, -90.0243072509765625, 178.07391357421875, 0.436331570148468017, 0, 0, 0.216439247131347656, 0.976296067237854003, 120, 255, 1, 48069), -- Hanging, Square, Large - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+6, 181014, 1, 1638, 5345, '0', 0, 0, -1180.6649169921875, -92.8975677490234375, 177.5315704345703125, 2.530723094940185546, 0, 0, 0.953716278076171875, 0.300707906484603881, 120, 255, 1, 48069), -- Hanging, Square, Large - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+7, 181014, 1, 1638, 5345, '0', 0, 0, -1108.482666015625, -10.3020830154418945, 157.7762603759765625, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 48069), -- Hanging, Square, Large - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+8, 181014, 1, 1638, 5345, '0', 0, 0, -1028.031005859375, -41.6272773742675781, 147.1649627685546875, 2.600535154342651367, 0, 0, 0.963629722595214843, 0.26724100112915039, 120, 255, 1, 48069), -- Hanging, Square, Large - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+9, 181015, 1, 1638, 5345, '0', 0, 0, -1215.689208984375, 65.04340362548828125, 129.9542236328125, 0.401424884796142578, 0, 0, 0.199367523193359375, 0.979924798011779785, 120, 255, 1, 48069), -- Standing, Large - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+10, 181015, 1, 1638, 5345, '0', 0, 0, -1218.12158203125, 61.67013931274414062, 129.6227569580078125, 3.577930212020874023, 0, 0, -0.97629547119140625, 0.216442063450813293, 120, 255, 1, 48069), -- Standing, Large - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+11, 181015, 1, 1638, 5345, '0', 0, 0, -1218.8367919921875, 63.53819656372070312, 129.6519317626953125, 3.473210096359252929, 0, 0, -0.98628520965576171, 0.165049895644187927, 120, 255, 1, 48069), -- Standing, Large - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+12, 181015, 1, 1638, 5345, '0', 0, 0, -1215.1336669921875, 63.625, 129.957733154296875, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 48069), -- Standing, Large - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+13, 181015, 1, 1638, 5345, '0', 0, 0, -1215.4166259765625, 64.47916412353515625, 131.1912384033203125, 5.218535900115966796, 0, 0, -0.507537841796875, 0.861629426479339599, 120, 255, 1, 48069), -- Standing, Large - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+14, 181016, 1, 1638, 5345, '0', 0, 0, -1304.96533203125, 144.895233154296875, 131.3851318359375, 1.413715124130249023, 0, 0, 0.649447441101074218, 0.760406434535980224, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+15, 181016, 1, 1638, 5345, '0', 0, 0, -1290.703125, 150.55035400390625, 129.7427978515625, 1.762782454490661621, 0, 0, 0.771624565124511718, 0.636078238487243652, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+16, 181016, 1, 1638, 5345, '0', 0, 0, -1277.2467041015625, 162.139190673828125, 131.1357269287109375, 2.687806606292724609, 0, 0, 0.974370002746582031, 0.224951311945915222, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+17, 181016, 1, 1638, 5345, '0', 0, 0, -1292.9110107421875, 49.4334869384765625, 129.2085113525390625, 5.113816738128662109, 0, 0, -0.55193614959716796, 0.833886384963989257, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+18, 181016, 1, 1638, 5345, '0', 0, 0, -1287.728759765625, 37.0892486572265625, 129.2085113525390625, 1.972219824790954589, 0, 0, 0.83388519287109375, 0.55193793773651123, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+19, 181016, 1, 1638, 5345, '0', 0, 0, -1202.386474609375, 25.20323371887207031, 176.9491729736328125, 0.855210542678833007, 0, 0, 0.414692878723144531, 0.909961462020874023, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+20, 181016, 1, 1638, 5345, '0', 0, 0, -1263.3033447265625, 18.50992774963378906, 128.1865692138671875, 0.820303261280059814, 0, 0, 0.398748397827148437, 0.917060375213623046, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+21, 181016, 1, 1638, 5345, '0', 0, 0, -1250.871826171875, 27.58224868774414062, 128.18658447265625, 3.577930212020874023, 0, 0, -0.97629547119140625, 0.216442063450813293, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+22, 181016, 1, 1638, 5345, '0', 0, 0, -1265.9132080078125, 26.07470703125, 128.18658447265625, 6.056293010711669921, 0, 0, -0.11320304870605468, 0.993571877479553222, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+23, 181016, 1, 1638, 5345, '0', 0, 0, -1190.9443359375, 25.93354034423828125, 176.9491729736328125, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+24, 181016, 1, 1638, 5345, '0', 0, 0, -1251.76806640625, 20.05962562561035156, 128.18658447265625, 2.548179388046264648, 0, 0, 0.956304550170898437, 0.292372345924377441, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+25, 181016, 1, 1638, 5345, '0', 0, 0, -1399.608642578125, -48.9439010620117187, 156.6848907470703125, 3.892086982727050781, 0, 0, -0.93041706085205078, 0.366502493619918823, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+26, 181016, 1, 1638, 5345, '0', 0, 0, -1385.486083984375, -58.1903228759765625, 158.535247802734375, 4.171337604522705078, 0, 0, -0.87035560607910156, 0.492423713207244873, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+27, 181016, 1, 1638, 5345, '0', 0, 0, -1067.5364990234375, -18.40625, 140.60736083984375, 5.759587764739990234, 0, 0, -0.25881862640380859, 0.965925931930541992, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+28, 181016, 1, 1638, 5345, '0', 0, 0, -1059.1336669921875, -7.60405778884887695, 141.3106536865234375, 5.515241622924804687, 0, 0, -0.37460613250732421, 0.927184045314788818, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+29, 181016, 1, 1638, 5345, '0', 0, 0, -1071.9114990234375, -32.9583320617675781, 141.3477783203125, 6.108653545379638671, 0, 0, -0.08715534210205078, 0.996194720268249511, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+30, 181016, 1, 1638, 5345, '0', 0, 0, -1069.7593994140625, 187.88482666015625, 107.7155838012695312, 1.064649581909179687, 0, 0, 0.507537841796875, 0.861629426479339599, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+31, 181016, 1, 1638, 5345, '0', 0, 0, -1074.3677978515625, 218.6214447021484375, 110.2166366577148437, 0.24434557557106018, 0, 0, 0.121869087219238281, 0.9925462007522583, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+32, 181016, 1, 1638, 5345, '0', 0, 0, -1021.12567138671875, 192.480224609375, 135.497314453125, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+33, 181016, 1, 1638, 5345, '0', 0, 0, -1031.923828125, 202.6702423095703125, 135.269744873046875, 0.872663915157318115, 0, 0, 0.422617912292480468, 0.906307935714721679, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+34, 181016, 1, 1638, 1640, '0', 0, 0, -1079.052978515625, 228.9611358642578125, 112.2561416625976562, 0.488691210746765136, 0, 0, 0.241921424865722656, 0.970295846462249755, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: Spirit Rise - Difficulty: 0)
+(@OGUID+35, 181016, 1, 1638, 1640, '0', 0, 0, -1000.06927490234375, 264.76171875, 137.5902252197265625, 4.380776405334472656, 0, 0, -0.81411552429199218, 0.580702960491180419, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: Spirit Rise - Difficulty: 0)
+(@OGUID+36, 181016, 1, 1638, 2197, '0', 0, 0, -989.99456787109375, 260.398284912109375, 137.5902099609375, 4.118979454040527343, 0, 0, -0.88294696807861328, 0.469472706317901611, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: The Pools of Vision - Difficulty: 0)
+(@OGUID+37, 181016, 1, 1638, 5345, '0', 0, 0, -1059.8780517578125, 187.7550201416015625, 107.2493667602539062, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+38, 181016, 1, 1638, 2197, '0', 0, 0, -998.57305908203125, 280.934417724609375, 111.9098663330078125, 0.15707901120185852, 0, 0, 0.078458786010742187, 0.996917366981506347, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: The Pools of Vision - Difficulty: 0)
+(@OGUID+39, 181016, 1, 1638, 2197, '0', 0, 0, -956.91461181640625, 267.94720458984375, 104.9567337036132812, 3.543023586273193359, 0, 0, -0.97992420196533203, 0.199370384216308593, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: The Pools of Vision - Difficulty: 0)
+(@OGUID+40, 181016, 1, 1638, 2197, '0', 0, 0, -938.90625, 278.451385498046875, 111.7419204711914062, 2.426007747650146484, 0, 0, 0.936672210693359375, 0.350207358598709106, 120, 255, 1, 48069), -- Standing, Exterior, Medium - Val (Area: The Pools of Vision - Difficulty: 0)
+(@OGUID+41, 181017, 1, 1638, 5345, '0', 0, 0, -1294.71875, 40.15451431274414062, 135.8617401123046875, 3.612837791442871093, 0, 0, -0.97236919403076171, 0.233448356389999389, 120, 255, 1, 48069), -- Hanging, Streamer - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+42, 181017, 1, 1638, 5345, '0', 0, 0, -1311.322021484375, 32.30734634399414062, 135.913665771484375, 0.541050612926483154, 0, 0, 0.267237663269042968, 0.96363067626953125, 120, 255, 1, 48069), -- Hanging, Streamer - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+43, 181019, 1, 1638, 5345, '0', 0, 0, -1290.5570068359375, 49.20296096801757812, 138.7949066162109375, 4.520402908325195312, 0, 0, -0.77162456512451171, 0.636078238487243652, 120, 255, 1, 48069), -- Standing, Interior, Medium - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+44, 181020, 1, 1638, 5345, '0', 0, 0, -1200.7392578125, 40.05040359497070312, 180.8592529296875, 4.939284324645996093, 0, 0, -0.6225137710571289, 0.78260880708694458, 120, 255, 1, 48069), -- Hanging, Square, Medium - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+45, 181020, 1, 1638, 5345, '0', 0, 0, -1204.6141357421875, 25.11626625061035156, 181.1231231689453125, 0.750490784645080566, 0, 0, 0.3665008544921875, 0.93041771650314331, 120, 255, 1, 48069), -- Hanging, Square, Medium - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+46, 181020, 1, 1638, 5345, '0', 0, 0, -1189.541259765625, 36.99929428100585937, 180.6167144775390625, 3.874631166458129882, 0, 0, -0.93358039855957031, 0.358368009328842163, 120, 255, 1, 48069), -- Hanging, Square, Medium - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+47, 181020, 1, 1638, 5345, '0', 0, 0, -1192.921875, 22.21918487548828125, 181.239837646484375, 1.902408957481384277, 0, 0, 0.814115524291992187, 0.580702960491180419, 120, 255, 1, 48069), -- Hanging, Square, Medium - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+48, 181020, 1, 1638, 5345, '0', 0, 0, -1146.219970703125, 17.28130531311035156, 150.334930419921875, 0.488691210746765136, 0, 0, 0.241921424865722656, 0.970295846462249755, 120, 255, 1, 48069), -- Hanging, Square, Medium - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+49, 181020, 1, 1638, 0, '0', 0, 0, -1248.75, -62.7546653747558593, 170.3091888427734375, 0.087265998125076293, 0, 0, 0.043619155883789062, 0.999048233032226562, 120, 255, 1, 48069), -- Hanging, Square, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+50, 181020, 1, 1638, 0, '0', 0, 0, -1423.9271240234375, -109.048622131347656, 167.309967041015625, 5.672322273254394531, 0, 0, -0.3007049560546875, 0.953717231750488281, 120, 255, 1, 48069), -- Hanging, Square, Medium - Val (Area: 0 - Difficulty: 0)
+(@OGUID+51, 181020, 1, 1638, 5345, '0', 0, 0, -1175.136962890625, -48.8111457824707031, 167.6138153076171875, 3.071766138076782226, 0, 0, 0.999390602111816406, 0.034906134009361267, 120, 255, 1, 48069), -- Hanging, Square, Medium - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+52, 181020, 1, 1638, 5345, '0', 0, 0, -1085.99462890625, 5.730089187622070312, 147.634185791015625, 3.385940074920654296, 0, 0, -0.99254608154296875, 0.121869951486587524, 120, 255, 1, 48069), -- Hanging, Square, Medium - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+53, 181020, 1, 1638, 5345, '0', 0, 0, -1057.5440673828125, -259.68505859375, 168.674072265625, 1.710421562194824218, 0, 0, 0.754709243774414062, 0.656059443950653076, 120, 255, 1, 48069), -- Hanging, Square, Medium - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+54, 181021, 1, 1638, 5345, '0', 0, 0, -1277.654052734375, 49.86848831176757812, 144.23760986328125, 0.558503925800323486, 0, 0, 0.275636672973632812, 0.961261868476867675, 120, 255, 1, 48069), -- Hanging, Door - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+55, 181027, 1, 1638, 5345, '0', 0, 0, -1261.5184326171875, 94.57465362548828125, 127.886383056640625, 0.872663915157318115, 0, 0, 0.422617912292480468, 0.906307935714721679, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+56, 181027, 1, 1638, 5345, '0', 0, 0, -1266.0574951171875, 100.9608001708984375, 127.886383056640625, 5.096362113952636718, 0, 0, -0.55919265747070312, 0.829037725925445556, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+57, 181027, 1, 1638, 5345, '0', 0, 0, -1256.9385986328125, 101.0687408447265625, 127.886383056640625, 2.199114561080932617, 0, 0, 0.8910064697265625, 0.453990638256072998, 120, 255, 1, 48069), -- Floating, Medium - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+58, 181060, 1, 1638, 5345, '0', 0, 0, -1258.5885009765625, 134.4774322509765625, 135.557403564453125, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+59, 181060, 1, 1638, 5345, '0', 0, 0, -1218.060791015625, 145.6770782470703125, 136.9156036376953125, 4.677483558654785156, 0, 0, -0.71933937072753906, 0.694658815860748291, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+60, 181060, 1, 1638, 5345, '0', 0, 0, -1292.994140625, 112.3231430053710937, 134.36663818359375, 0.907570242881774902, 0, 0, 0.438370704650878906, 0.898794233798980712, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+61, 181060, 1, 1638, 5345, '0', 0, 0, -1243.2122802734375, 137.3705291748046875, 136.0482940673828125, 4.991643905639648437, 0, 0, -0.60181427001953125, 0.798636078834533691, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+62, 181060, 1, 1638, 5345, '0', 0, 0, -1292.634765625, 114.8027725219726562, 134.36663818359375, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+63, 181060, 1, 1638, 5345, '0', 0, 0, -1245.642333984375, 137.2523345947265625, 136.0482940673828125, 1.413715124130249023, 0, 0, 0.649447441101074218, 0.760406434535980224, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+64, 181060, 1, 1638, 5345, '0', 0, 0, -1278.8707275390625, 81.89482879638671875, 131.8394927978515625, 3.700104713439941406, 0, 0, -0.96126079559326171, 0.275640487670898437, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+65, 181060, 1, 1638, 5345, '0', 0, 0, -1294.2308349609375, 97.88785552978515625, 133.6595458984375, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+66, 181060, 1, 1638, 5345, '0', 0, 0, -1288.8802490234375, 130.986602783203125, 134.571075439453125, 2.042035102844238281, 0, 0, 0.852640151977539062, 0.522498607635498046, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+67, 181060, 1, 1638, 5345, '0', 0, 0, -1220.5035400390625, 145.8506927490234375, 136.915618896484375, 4.642575740814208984, 0, 0, -0.731353759765625, 0.681998312473297119, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+68, 181060, 1, 1638, 5345, '0', 0, 0, -1295.1300048828125, 100.2773971557617187, 133.6595458984375, 2.652894020080566406, 0, 0, 0.970294952392578125, 0.241925001144409179, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+69, 181060, 1, 1638, 5345, '0', 0, 0, -1290.470458984375, 132.9488983154296875, 134.571075439453125, 5.654868602752685546, 0, 0, -0.30901622772216796, 0.95105677843093872, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+70, 181060, 1, 1638, 5345, '0', 0, 0, -1261.0103759765625, 134.4913177490234375, 135.5670928955078125, 4.834563255310058593, 0, 0, -0.66261959075927734, 0.748956084251403808, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+71, 181060, 1, 1638, 5345, '0', 0, 0, -1234.4388427734375, 84.67583465576171875, 133.53326416015625, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+72, 181060, 1, 1638, 5345, '0', 0, 0, -1253.876220703125, 51.97222137451171875, 129.9654693603515625, 1.466075778007507324, 0, 0, 0.669130325317382812, 0.74314504861831665, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+73, 181060, 1, 1638, 5345, '0', 0, 0, -1277.001220703125, 80.466064453125, 131.8394927978515625, 0.436331570148468017, 0, 0, 0.216439247131347656, 0.976296067237854003, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+74, 181060, 1, 1638, 5345, '0', 0, 0, -1236.0772705078125, 82.8995208740234375, 133.53326416015625, 3.543023586273193359, 0, 0, -0.97992420196533203, 0.199370384216308593, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+75, 181060, 1, 1638, 5345, '0', 0, 0, -1224.4246826171875, 81.43978118896484375, 133.7146759033203125, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+76, 181060, 1, 1638, 5345, '0', 0, 0, -1226.719970703125, 80.64111328125, 133.7146759033203125, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+77, 181060, 1, 1638, 5345, '0', 0, 0, -1256.150390625, 51.2523345947265625, 129.9654693603515625, 3.508116960525512695, 0, 0, -0.98325443267822265, 0.182238012552261352, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+78, 181060, 1, 1638, 5345, '0', 0, 0, -1226.410400390625, 45.39122390747070312, 131.0964813232421875, 3.52557229995727539, 0, 0, -0.98162651062011718, 0.190812408924102783, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+79, 181060, 1, 1638, 5345, '0', 0, 0, -1228.7491455078125, 45.35286331176757812, 131.0964813232421875, 3.769911527633666992, 0, 0, -0.95105648040771484, 0.309017121791839599, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+80, 181060, 1, 1638, 5345, '0', 0, 0, -1147.0972900390625, 26.90738868713378906, 148.4151763916015625, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+81, 181060, 1, 1638, 5345, '0', 0, 0, -1139.33447265625, 50.64811325073242187, 147.170196533203125, 0.052358884364366531, 0, 0, 0.02617645263671875, 0.999657332897186279, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+82, 181060, 1, 1638, 5345, '0', 0, 0, -1160.0379638671875, 29.34076690673828125, 149.0304718017578125, 1.204277276992797851, 0, 0, 0.56640625, 0.824126183986663818, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+83, 181060, 1, 1638, 5345, '0', 0, 0, -1162.2547607421875, 29.90814971923828125, 149.0304718017578125, 4.852017402648925781, 0, 0, -0.65605831146240234, 0.754710197448730468, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+84, 181060, 1, 1638, 5345, '0', 0, 0, -1149.4215087890625, 27.28667640686035156, 148.4151763916015625, 3.43830275535583496, 0, 0, -0.98901557922363281, 0.147811368107795715, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+85, 181060, 1, 1638, 5345, '0', 0, 0, -1140.3104248046875, 48.54817581176757812, 147.170196533203125, 1.274088263511657714, 0, 0, 0.594821929931640625, 0.80385744571685791, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+86, 181060, 1, 1638, 5345, '0', 0, 0, -1213.4647216796875, -12.5487194061279296, 169.180908203125, 5.253442287445068359, 0, 0, -0.49242305755615234, 0.870355963706970214, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+87, 181060, 1, 1638, 5345, '0', 0, 0, -1193.2265625, -7.46245718002319335, 168.891204833984375, 6.021387100219726562, 0, 0, -0.13052558898925781, 0.991444945335388183, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+88, 181060, 1, 1638, 5345, '0', 0, 0, -1213.212158203125, -10.1758899688720703, 169.180908203125, 2.007128477096557617, 0, 0, 0.84339141845703125, 0.537299633026123046, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+89, 181060, 1, 1638, 5345, '0', 0, 0, -1192.8543701171875, -5.08306217193603515, 168.891204833984375, 5.148722648620605468, 0, 0, -0.53729915618896484, 0.843391716480255126, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+90, 181060, 1, 1638, 5345, '0', 0, 0, -1230.7047119140625, -41.4822044372558593, 167.7692718505859375, 2.600535154342651367, 0, 0, 0.963629722595214843, 0.26724100112915039, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+91, 181060, 1, 1638, 5345, '0', 0, 0, -1118.2960205078125, 39.44601821899414062, 144.7226409912109375, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+92, 181060, 1, 1638, 5345, '0', 0, 0, -1114.9776611328125, 7.12733316421508789, 145.23272705078125, 4.328419685363769531, 0, 0, -0.82903671264648437, 0.559194147586822509, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+93, 181060, 1, 1638, 5345, '0', 0, 0, -1118.1959228515625, 37.14789581298828125, 144.7226409912109375, 3.595378875732421875, 0, 0, -0.97437000274658203, 0.224951311945915222, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+94, 181060, 1, 1638, 5345, '0', 0, 0, -1231.693603515625, -43.6813163757324218, 167.7692718505859375, 1.972219824790954589, 0, 0, 0.83388519287109375, 0.55193793773651123, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+95, 181060, 1, 1638, 0, '0', 0, 0, -1235.884521484375, -55.7594947814941406, 166.207275390625, 5.235987663269042968, 0, 0, -0.5, 0.866025388240814208, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0)
+(@OGUID+96, 181060, 1, 1638, 0, '0', 0, 0, -1236.0909423828125, -58.232421875, 166.207275390625, 3.159062385559082031, 0, 0, -0.99996185302734375, 0.008734640665352344, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0)
+(@OGUID+97, 181060, 1, 1638, 0, '0', 0, 0, -1406.429443359375, -109.241539001464843, 162.2984161376953125, 4.380776405334472656, 0, 0, -0.81411552429199218, 0.580702960491180419, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0)
+(@OGUID+98, 181060, 1, 1638, 0, '0', 0, 0, -1407.6434326171875, -111.458282470703125, 162.2984161376953125, 2.879789113998413085, 0, 0, 0.991444587707519531, 0.130528271198272705, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: 0 - Difficulty: 0)
+(@OGUID+99, 181060, 1, 1638, 5345, '0', 0, 0, -1174.347900390625, -72.669219970703125, 165.6610870361328125, 0.523597896099090576, 0, 0, 0.258818626403808593, 0.965925931930541992, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+100, 181060, 1, 1638, 5345, '0', 0, 0, -1183.1595458984375, -54.9835090637207031, 165.0548858642578125, 0.24434557557106018, 0, 0, 0.121869087219238281, 0.9925462007522583, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+101, 181060, 1, 1638, 5345, '0', 0, 0, -1187.5284423828125, -36.2961158752441406, 166.353759765625, 5.811946868896484375, 0, 0, -0.2334451675415039, 0.972369968891143798, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+102, 181060, 1, 1638, 5345, '0', 0, 0, -1186.3060302734375, -38.4025077819824218, 166.353759765625, 0.959929943084716796, 0, 0, 0.461748123168945312, 0.887011110782623291, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+103, 181060, 1, 1638, 5345, '0', 0, 0, -1174.2098388671875, -75.0950546264648437, 165.6610870361328125, 2.844882726669311523, 0, 0, 0.989015579223632812, 0.147811368107795715, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+104, 181060, 1, 1638, 5345, '0', 0, 0, -1183.140625, -57.48828125, 165.0548858642578125, 0.24434557557106018, 0, 0, 0.121869087219238281, 0.9925462007522583, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+105, 181060, 1, 1638, 5345, '0', 0, 0, -1114.4302978515625, 4.692165851593017578, 145.2327423095703125, 4.852017402648925781, 0, 0, -0.65605831146240234, 0.754710197448730468, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+106, 181060, 1, 1638, 5345, '0', 0, 0, -1103.803466796875, 21.81060218811035156, 143.860504150390625, 4.118979454040527343, 0, 0, -0.88294696807861328, 0.469472706317901611, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+107, 181060, 1, 1638, 5345, '0', 0, 0, -1102.7022705078125, 19.67789649963378906, 143.860504150390625, 5.532694816589355468, 0, 0, -0.3665008544921875, 0.93041771650314331, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+108, 181060, 1, 1638, 5345, '0', 0, 0, -1091.0267333984375, 1.14784097671508789, 143.9541015625, 2.617989301681518554, 0, 0, 0.965925216674804687, 0.258821308612823486, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+109, 181060, 1, 1638, 5345, '0', 0, 0, -1091.3724365234375, -1.32107198238372802, 143.9541015625, 0.767943859100341796, 0, 0, 0.374606132507324218, 0.927184045314788818, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+110, 181060, 1, 1638, 5345, '0', 0, 0, -1041.5947265625, -213.362518310546875, 162.631591796875, 3.822272777557373046, 0, 0, -0.94264125823974609, 0.333807557821273803, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+111, 181060, 1, 1638, 5345, '0', 0, 0, -1066.189697265625, -241.400283813476562, 162.2833099365234375, 3.001946926116943359, 0, 0, 0.997563362121582031, 0.069766148924827575, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+112, 181060, 1, 1638, 5345, '0', 0, 0, -1042.255859375, -215.808914184570312, 162.6315765380859375, 4.258606910705566406, 0, 0, -0.84804725646972656, 0.529920578002929687, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+113, 181060, 1, 1638, 5345, '0', 0, 0, -1063.76025390625, -241.52203369140625, 162.2833099365234375, 0.558503925800323486, 0, 0, 0.275636672973632812, 0.961261868476867675, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+114, 181060, 1, 1638, 1640, '0', 0, 0, -1000.31182861328125, 230.149932861328125, 138.291107177734375, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Spirit Rise - Difficulty: 0)
+(@OGUID+115, 181060, 1, 1638, 1640, '0', 0, 0, -991.78668212890625, 211.693389892578125, 138.7931671142578125, 2.059488296508789062, 0, 0, 0.857167243957519531, 0.515038192272186279, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Spirit Rise - Difficulty: 0)
+(@OGUID+116, 181060, 1, 1638, 1640, '0', 0, 0, -993.94464111328125, 210.49053955078125, 138.7931671142578125, 4.345870018005371093, 0, 0, -0.82412624359130859, 0.566406130790710449, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Spirit Rise - Difficulty: 0)
+(@OGUID+117, 181060, 1, 1638, 1640, '0', 0, 0, -1002.318603515625, 231.2728729248046875, 138.291107177734375, 4.625123500823974609, 0, 0, -0.73727703094482421, 0.67559051513671875, 120, 255, 1, 48069), -- Standing, Interior, Small - Val (Area: Spirit Rise - Difficulty: 0)
+(@OGUID+118, 195266, 1, 1638, 5345, '0', 0, 0, -1259.4410400390625, 39.81076431274414062, 133.9119720458984375, 1.623155713081359863, 0, 0, 0.725374221801757812, 0.688354730606079101, 120, 255, 1, 48069), -- Hanging, Streamer - Brewfest (Area: Thunder Bluff - Difficulty: 0)
+(@OGUID+119, 201940, 1, 1638, 5345, '0', 0, 0, -1217.9444580078125, 62.78819656372070312, 129.7745819091796875, 3.508116960525512695, 0, 0, -0.98325443267822265, 0.182238012552261352, 120, 255, 1, 48069); -- Valentine Arch (x2.00) (Area: Thunder Bluff - 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+119;
+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);