aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMeji <alvaro.megias@outlook.com>2024-03-10 18:38:35 +0100
committerMeji <alvaro.megias@outlook.com>2024-03-10 18:38:35 +0100
commitb5b726114c83d03e3eee962cc744e31290c45e88 (patch)
treefd1d92b261406ff9eb8048e6f3cb6710f3966347
parent8c256d3a3555058ad8db95887ca1f0fa05ad76c5 (diff)
DB/Thunderbluff: Update Love is in the Air spawns
-rw-r--r--sql/updates/world/master/2024_03_10_03_world.sql363
1 files changed, 363 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_03_10_03_world.sql b/sql/updates/world/master/2024_03_10_03_world.sql
new file mode 100644
index 00000000000..62bf239478e
--- /dev/null
+++ b/sql/updates/world/master/2024_03_10_03_world.sql
@@ -0,0 +1,363 @@
+SET @CGUID := 9800010;
+SET @OGUID := 9800440;
+SET @EVENT := 8;
+
+-- Creature templates
+UPDATE `creature_template` SET `faction`=2361, `npcflag`=2, `BaseAttackTime`=2000, `unit_flags`=256, `unit_flags2`=2048 WHERE `entry`=215196; -- Aurora Vabsley
+
+DELETE FROM `creature_template_addon` WHERE `entry`=215196;
+INSERT INTO `creature_template_addon` (`entry`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES
+(215196, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '427424'); -- 215196 (Aurora Vabsley) - [DNT] Mirror Image
+
+-- Models
+DELETE FROM `creature_model_info` WHERE `DisplayID` IN (116050, 113845, 113844);
+INSERT INTO `creature_model_info` (`DisplayID`, `BoundingRadius`, `CombatReach`, `DisplayID_Other_Gender`, `VerifiedBuild`) VALUES
+(116050, 0.382999986410140991, 1.5, 0, 53262),
+(113845, 0.698000013828277587, 3, 0, 53262),
+(113844, 0.722000002861022949, 3, 0, 53262);
+
+UPDATE `creature_model_info` SET `VerifiedBuild`=53262 WHERE `DisplayID` IN (110602, 110598, 110597, 110595, 110594, 110593, 110589, 74863, 64916, 38011, 38010, 38009, 38006, 37564, 37563, 37562, 37400, 37345, 37344, 37342, 37343, 37013, 37022, 36615, 35712, 35697, 33550, 33544, 33542, 33540, 29250, 29249, 33539, 33524, 30272, 29503, 29502, 29398, 29375, 29371, 29370, 29369, 29368, 29367, 29366, 27289, 27257, 22873, 22750, 18872, 18871, 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, 4665, 4542, 4513, 4519, 3550, 3371, 3129, 3002, 2951, 2738, 1547, 43948, 4518, 1056, 4383, 4520, 1814, 2132, 2129, 2133, 9391, 2141, 9392, 8572, 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, 10824, 10869, 1255, 161, 643, 1221, 1220, 2131);
+
+UPDATE `creature_template_model` SET `VerifiedBuild`=53262 WHERE (`Idx`=0 AND `CreatureID` IN (43881,14441,3024,3015,3036,24935,199245,2798,2957,19176,3095,8359,6393,12383,3010,3047,3044,51638,3002,52651,51503,11084,2995,2999,10086,34976,3033,3029,34717,199240,30709,3084,43001,43004,2960,199239,3447,3035,3018,10278,3014,3027,3008,43795,3083,62462,3022,215196,3092,3004,7089,199222,43870,34730,51640,52657,3001,5054,3021,3007,3025,61141,199258,6410,199225,34721,3048,30724,3003,3005,9087,3009,4166,50483,5599,5769,3037,3016,8674,6746,2998,3039,3978,11071,8358,8401,9076,34723,2965,43883,3046,5543,49750,3026,3023,3017,356,8664,8363,8398,2996,4721,15164,209293,5906,3012,3011,2964,3566,43892,11051,36648,3013,3441,51143,3034,209294,34766,3045,14440,10881,14442,11047,8364,3050,18379,4943,51639,3093,5770,2971,34719,34718,52655,2997,3020,3040,34978,24934,3419,2959,8362,8722,10054,3019,8360,3041,118512,43796,47572,3028,96470,5957,2956,8361,47589,3042,3038,199241,51372,3043,34715,25075,3049,52658,5189,8356,8357)) OR (`Idx`=1 AND `CreatureID` IN (19176,3084,4166,51372)) OR (`Idx`=3 AND `CreatureID` IN (3084,51372)) OR (`Idx`=2 AND `CreatureID` IN (3084,4166,51372));
+
+-- Difficulties
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=215196 AND `DifficultyID`=0); -- Aurora Vabsley
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=865, `VerifiedBuild`=53262 WHERE (`Entry`=209294 AND `DifficultyID`=0); -- Se'tah Bloodtotem
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=865, `VerifiedBuild`=53262 WHERE (`Entry`=209293 AND `DifficultyID`=0); -- Tihkan Soultotem
+UPDATE `creature_template_difficulty` SET `VerifiedBuild`=53262 WHERE (`DifficultyID`=0 AND `Entry` IN (199258,199245,199241,199240,199239,199225,199222,118512,96470,62462,61141,52658,52657,52655,52651,51640,51639,51638,51503,51372,51143,50483,49750,47589,47572,43892,43883,43881,43870,43796,43795,43004,43001,36648,34978,34976,34766,34730,34723,34721,34719,34718,34717,34715,30724,30709,25075,24935,24934,19176,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,5957,5906,5770,5769,5599,5543,5189,5054,4943,4721,4166,3978,3566,3447,3441,3419,3095,3093,3092,3084,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,2965,2964,2960,2959,2957,2956,2798));
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `VerifiedBuild`=53262 WHERE `entry` IN (50445, 177208, 177268, 74727, 177209, 177205, 203234, 177207, 177270, 208878, 177265, 177266, 3298, 74729, 208875, 177267, 3286, 208887, 208867, 208888, 50448, 177204, 178571, 74730, 181273, 208889, 190549, 50446, 74728, 187295, 3296, 160426, 208880, 50449, 50447, 208890, 4170, 152583, 4171, 177269, 50468, 47297, 3315, 50450, 47296, 143985, 50469, 207323, 3303);
+
+UPDATE `gameobject_template_addon` SET `WorldEffectID`=8830 WHERE `entry`=207323; -- Warchief's Command Board
+
+-- Gossips
+DELETE FROM `gossip_menu_option` WHERE (`MenuID`=32934 AND `OptionID`=2);
+INSERT INTO `gossip_menu_option` (`MenuID`, `GossipOptionID`, `OptionID`, `OptionNpc`, `OptionText`, `OptionBroadcastTextID`, `Language`, `Flags`, `ActionMenuID`, `ActionPoiID`, `GossipNpcOptionID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `SpellID`, `OverrideIconID`, `VerifiedBuild`) VALUES
+(32934, 120254, 2, 0, 'The Gala of Gifts.', 0, 0, 1, 0, 0, NULL, 0, 0, NULL, 0, NULL, NULL, 53262);
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=32934 AND `SourceEntry`=2;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(15, 32934, 2, 0, 0, 47, 0, 78981, 2, 0, '', 0, 0, 0, '', 'Show gossip option if quest 78981 is completed');
+
+-- Quests
+DELETE FROM `quest_template` WHERE `ID`=78981;
+INSERT INTO `quest_template` (`ID`, `QuestType`, `QuestPackageID`, `ContentTuningID`, `QuestSortID`, `QuestInfoID`, `SuggestedGroupNum`, `RewardNextQuest`, `RewardXPDifficulty`, `RewardXPMultiplier`, `RewardMoneyDifficulty`, `RewardMoneyMultiplier`, `RewardSpell`, `RewardHonor`, `RewardKillHonor`, `StartItem`, `RewardArtifactXPDifficulty`, `RewardArtifactXPMultiplier`, `RewardArtifactCategoryID`, `Flags`, `FlagsEx`, `FlagsEx2`, `RewardSkillLineID`, `RewardNumSkillUps`, `PortraitGiver`, `PortraitGiverMount`, `PortraitGiverModelSceneID`, `PortraitTurnIn`, `RewardItem1`, `RewardItem2`, `RewardItem3`, `RewardItem4`, `RewardAmount1`, `RewardAmount2`, `RewardAmount3`, `RewardAmount4`, `ItemDrop1`, `ItemDrop2`, `ItemDrop3`, `ItemDrop4`, `ItemDropQuantity1`, `ItemDropQuantity2`, `ItemDropQuantity3`, `ItemDropQuantity4`, `RewardChoiceItemID1`, `RewardChoiceItemID2`, `RewardChoiceItemID3`, `RewardChoiceItemID4`, `RewardChoiceItemID5`, `RewardChoiceItemID6`, `RewardChoiceItemQuantity1`, `RewardChoiceItemQuantity2`, `RewardChoiceItemQuantity3`, `RewardChoiceItemQuantity4`, `RewardChoiceItemQuantity5`, `RewardChoiceItemQuantity6`, `RewardChoiceItemDisplayID1`, `RewardChoiceItemDisplayID2`, `RewardChoiceItemDisplayID3`, `RewardChoiceItemDisplayID4`, `RewardChoiceItemDisplayID5`, `RewardChoiceItemDisplayID6`, `POIContinent`, `POIx`, `POIy`, `POIPriority`, `RewardTitle`, `RewardArenaPoints`, `RewardFactionID1`, `RewardFactionID2`, `RewardFactionID3`, `RewardFactionID4`, `RewardFactionID5`, `RewardFactionValue1`, `RewardFactionValue2`, `RewardFactionValue3`, `RewardFactionValue4`, `RewardFactionValue5`, `RewardFactionCapIn1`, `RewardFactionCapIn2`, `RewardFactionCapIn3`, `RewardFactionCapIn4`, `RewardFactionCapIn5`, `RewardFactionOverride1`, `RewardFactionOverride2`, `RewardFactionOverride3`, `RewardFactionOverride4`, `RewardFactionOverride5`, `RewardFactionFlags`, `AreaGroupID`, `TimeAllowed`, `AllowableRaces`, `TreasurePickerID`, `Expansion`, `ManagedWorldStateID`, `QuestSessionBonus`, `LogTitle`, `LogDescription`, `QuestDescription`, `AreaDescription`, `QuestCompletionLog`, `RewardCurrencyID1`, `RewardCurrencyID2`, `RewardCurrencyID3`, `RewardCurrencyID4`, `RewardCurrencyQty1`, `RewardCurrencyQty2`, `RewardCurrencyQty3`, `RewardCurrencyQty4`, `PortraitGiverText`, `PortraitGiverName`, `PortraitTurnInText`, `PortraitTurnInName`, `AcceptedSoundKitID`, `CompleteSoundKitID`, `VerifiedBuild`) VALUES
+(78981, 2, 0, 378, -376, 0, 0, 78328, 1, 1, 1, 1, 0, 0, 0, 0, 0, 1, 0, 8, 64, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 12261800583900083122, 0, 9, 0, 0, 'Love is in the Air', 'Visit the Gala of Gifts in Durotar, near Rocktusk Farm.', 'Smell these roses! My partner got them for me at the Gala of Gifts.\n\nInterested in seeing things yourself? Head to Durotar. There are gifts, and food, and you should taste the chocolate, it\'s delicious!', '', 'Speak with Mahaja Cloudsong at the Gala of Gifts.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 53262); -- Love is in the Air
+
+UPDATE `quest_template` SET `VerifiedBuild`=53262 WHERE `ID` IN (74440, 69850, 69865, 69849, 66356, 74441, 69837, 66004, 51443, 69964, 72128, 47514, 53435, 54759, 75874, 69882, 42985, 49930, 65435);
+
+UPDATE `quest_poi` SET `VerifiedBuild`=53262 WHERE (`QuestID`=78981 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=75874 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=65435 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=65435 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=54759 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=54759 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=53435 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=53435 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=49930 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=49930 AND `BlobIndex`=0 AND `Idx1`=0);
+
+UPDATE `quest_poi_points` SET `VerifiedBuild`=53262 WHERE (`QuestID`=78981 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=75874 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=65435 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=65435 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=54759 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=54759 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=53435 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=53435 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=49930 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=49930 AND `Idx1`=0 AND `Idx2`=0);
+
+DELETE FROM `quest_details` WHERE `ID`=78981;
+INSERT INTO `quest_details` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `VerifiedBuild`) VALUES
+(78981, 669, 0, 0, 0, 0, 0, 0, 0, 53262); -- Love is in the Air
+
+DELETE FROM `quest_description_conditional` WHERE (`QuestId`=78981 AND `PlayerConditionId`=0 AND `QuestgiverCreatureId`=215196 AND `locale`='enUS');
+INSERT INTO `quest_description_conditional` (`QuestId`, `PlayerConditionId`, `QuestgiverCreatureId`, `locale`, `Text`, `OrderIndex`, `VerifiedBuild`) VALUES
+(78981, 0, 215196, 'enUS', 'Do you appreciate gifts, flowers, and food? How about vacations to beautiful, distant lands?\n\nCome to the Gala of Gifts! There are roses aplenty and chocolates galore!\n\nMy portal will take you there. Simply touch it and imagine your heart\'s desire!', 0, 53262); -- Love is in the Air
+
+DELETE FROM `quest_objectives` WHERE `ID`=445601;
+INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `Order`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `Flags2`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES
+(445601, 78981, 0, 0, 0, 215196, 1, 28, 0, 0, '[DNT] Arch glow', 53262); -- 445601
+
+UPDATE `quest_objectives` SET `VerifiedBuild`=53262 WHERE `ID` IN (433736, 429357, 429325, 429339, 429324, 426823, 433737, 429315, 423679, 335884, 335883, 429567, 431741, 341368);
+
+DELETE FROM `quest_visual_effect` WHERE (`ID`=445601 AND `Index`=0);
+INSERT INTO `quest_visual_effect` (`ID`, `Index`, `VisualEffect`, `VerifiedBuild`) VALUES
+(445601, 0, 24666, 53262);
+
+UPDATE `quest_visual_effect` SET `VerifiedBuild`=53262 WHERE (`Index`=0 AND `ID` IN (429315,426823,335884,335883)) OR (`Index`=2 AND `ID`=335884) OR (`Index`=1 AND `ID`=335884);
+
+UPDATE `quest_reward_display_spell` SET `VerifiedBuild`=53262 WHERE (`QuestID`=54759 AND `Idx`=0);
+
+DELETE FROM `creature_queststarter` WHERE (`id`=215196 AND `quest`=78981);
+INSERT INTO `creature_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(215196, 78981, 53262); -- Love is in the Air offered by Aurora Vabsley
+
+-- Misc
+DELETE FROM `spell_target_position` WHERE (`ID`=430729 AND `EffectIndex`=0);
+INSERT INTO `spell_target_position` (`ID`, `EffectIndex`, `MapID`, `PositionX`, `PositionY`, `PositionZ`, `VerifiedBuild`) VALUES
+(430729, 0, 1, 1246.989990234375, -4262.9599609375, 77, 53262); -- Spell: 430729 (Portal: Gala of Gifts...?) Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS)
+
+-- SAI
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=215196;
+
+DELETE FROM `smart_scripts` WHERE `entryorguid`=215196 AND `source_type`=0;
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `event_param_string`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param7`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
+(215196,0,0,0,1,0,100,0,0,0,5000,8500,0,'',5,3,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,'Aurora Vabsley - Out of combat (5.0 - 8.5 seconds) - Play emote');
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceGroup`=1 AND `SourceEntry`=215196;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(22, 1, 215196, 0, 0, 57, 1, 0, 0, 0, '', 1, 0, 0, '', 'Execute SAI if object is not a personal clone');
+
+-- Old creature spawns
+DELETE FROM `creature` WHERE `guid` BETWEEN 3000050 AND 3000054;
+DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 3000050 AND 3000054;
+
+-- Creature spawns
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+1;
+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`, `unit_flags2`, `unit_flags3`, `VerifiedBuild`) VALUES
+(@CGUID+0, 40438, 1, 1638, 5345, '0', 0, 0, 0, 0, -1273.0242919921875, 71.2743072509765625, 128.0668182373046875, 5.8817596435546875, 120, 0, 0, 112919, 0, 0, NULL, NULL, NULL, NULL, 53262), -- Steamwheedle Shyster (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@CGUID+1, 215196, 1, 1638, 5345, '0', 0, 0, 0, 0, -1223.2222900390625, 65.579864501953125, 129.588531494140625, 3.656330347061157226, 120, 0, 0, 112919, 0, 0, NULL, NULL, NULL, NULL, 53262); -- Aurora Vabsley (Area: Thunder Bluff - Difficulty: 0) CreateObject1 (Auras: 427424 - [DNT] Mirror Image)
+
+-- Old gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 3001025 AND 3001144;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 3001025 AND 3001144;
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+120;
+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, -1028.031005859375, -41.6272773742675781, 147.1649627685546875, 2.600535154342651367, 0, 0, 0.963629722595214843, 0.26724100112915039, 120, 255, 1, 53262), -- Lovely Wreath (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+1, 181014, 1, 1638, 5345, '0', 0, 0, -1108.482666015625, -10.3020830154418945, 157.7762603759765625, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 53262), -- Lovely Wreath (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+2, 181014, 1, 1638, 5345, '0', 0, 0, -1297.6649169921875, 192.8706817626953125, 137.1883697509765625, 1.658061861991882324, 0, 0, 0.737277030944824218, 0.67559051513671875, 120, 255, 1, 53262), -- Lovely Wreath (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@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, 53262), -- Lovely Wreath (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+4, 181014, 1, 1638, 5345, '0', 0, 0, -1236.5347900390625, -90.0243072509765625, 178.07391357421875, 0.436331570148468017, 0, 0, 0.216439247131347656, 0.976296067237854003, 120, 255, 1, 53262), -- Lovely Wreath (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+5, 181014, 1, 1638, 5345, '0', 0, 0, -1180.6649169921875, -92.8975677490234375, 177.5315704345703125, 2.530723094940185546, 0, 0, 0.953716278076171875, 0.300707906484603881, 120, 255, 1, 53262), -- Lovely Wreath (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+6, 181014, 1, 1638, 5345, '0', 0, 0, -1204.99658203125, 134.3524932861328125, 149.1890411376953125, 3.857182979583740234, 0, 0, -0.93667125701904296, 0.350209832191467285, 120, 255, 1, 53262), -- Lovely Wreath (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+7, 181014, 1, 1638, 5345, '0', 0, 0, -1210.715087890625, 34.21560287475585937, 192.2454376220703125, 2.844882726669311523, 0, 0, 0.989015579223632812, 0.147811368107795715, 120, 255, 1, 53262), -- Lovely Wreath (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+8, 181014, 1, 1638, 5345, '0', 0, 0, -1123.9444580078125, 65.1875, 158.3504791259765625, 4.415683269500732421, 0, 0, -0.80385684967041015, 0.594822824001312255, 120, 255, 1, 53262), -- Lovely Wreath (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+9, 181015, 1, 1638, 5345, '0', 0, 0, -1221.263916015625, 73.0381927490234375, 130.14703369140625, 3.775351285934448242, 0, 0, -0.95021247863769531, 0.311602741479873657, 120, 255, 1, 53262), -- Crate (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+10, 181015, 1, 1638, 5345, '0', 0, 0, -1220.0208740234375, 71.564239501953125, 130.1093597412109375, 3.775351285934448242, 0, 0, -0.95021247863769531, 0.311602741479873657, 120, 255, 1, 53262), -- Crate (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+11, 181015, 1, 1638, 5345, '0', 0, 0, -1213.1353759765625, 50.30034637451171875, 130.821014404296875, 2.463173389434814453, 0, 0, 0.943017959594726562, 0.332741826772689819, 120, 255, 1, 53262), -- Crate (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+12, 181015, 1, 1638, 5345, '0', 0, 0, -1211.263916015625, 52.03298568725585937, 131.050750732421875, 2.712075710296630859, 0, 0, 0.97702789306640625, 0.21311141550540924, 120, 255, 1, 53262), -- Crate (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+13, 181016, 1, 1638, 5345, '0', 0, 0, -1292.9110107421875, 49.4334869384765625, 129.2085113525390625, 5.113816738128662109, 0, 0, -0.55193614959716796, 0.833886384963989257, 120, 255, 1, 53262), -- Wreath (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+14, 181016, 1, 1638, 5345, '0', 0, 0, -1190.9443359375, 25.93354034423828125, 176.9491729736328125, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 120, 255, 1, 53262), -- Wreath (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+15, 181016, 1, 1638, 5345, '0', 0, 0, -1287.728759765625, 37.0892486572265625, 129.2085113525390625, 1.972219824790954589, 0, 0, 0.83388519287109375, 0.55193793773651123, 120, 255, 1, 53262), -- Wreath (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+16, 181016, 1, 1638, 5345, '0', 0, 0, -1250.871826171875, 27.58224868774414062, 128.18658447265625, 3.577930212020874023, 0, 0, -0.97629547119140625, 0.216442063450813293, 120, 255, 1, 53262), -- Wreath (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+17, 181016, 1, 1638, 5345, '0', 0, 0, -1202.386474609375, 25.20323371887207031, 176.9491729736328125, 0.855210542678833007, 0, 0, 0.414692878723144531, 0.909961462020874023, 120, 255, 1, 53262), -- Wreath (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+18, 181016, 1, 1638, 5345, '0', 0, 0, -1251.76806640625, 20.05962562561035156, 128.18658447265625, 2.548179388046264648, 0, 0, 0.956304550170898437, 0.292372345924377441, 120, 255, 1, 53262), -- Wreath (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+19, 181016, 1, 1638, 5345, '0', 0, 0, -1263.3033447265625, 18.50992774963378906, 128.1865692138671875, 0.820303261280059814, 0, 0, 0.398748397827148437, 0.917060375213623046, 120, 255, 1, 53262), -- Wreath (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+20, 181016, 1, 1638, 5345, '0', 0, 0, -1265.9132080078125, 26.07470703125, 128.18658447265625, 6.056293010711669921, 0, 0, -0.11320304870605468, 0.993571877479553222, 120, 255, 1, 53262), -- Wreath (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+21, 181016, 1, 1638, 5345, '0', 0, 0, -1220.8350830078125, 57.30382156372070312, 129.1302490234375, 3.426064252853393554, 0, 0, -0.98990154266357421, 0.141756594181060791, 120, 255, 1, 53262), -- Wreath (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+22, 181016, 1, 1638, 5345, '0', 0, 0, -1399.608642578125, -48.9439010620117187, 156.6848907470703125, 3.892086982727050781, 0, 0, -0.93041706085205078, 0.366502493619918823, 120, 255, 1, 53262), -- Wreath (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+23, 181016, 1, 1638, 5345, '0', 0, 0, -1385.486083984375, -58.1903228759765625, 158.535247802734375, 4.171337604522705078, 0, 0, -0.87035560607910156, 0.492423713207244873, 120, 255, 1, 53262), -- Wreath (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+24, 181016, 1, 1638, 5345, '0', 0, 0, -1304.96533203125, 144.895233154296875, 131.3851318359375, 1.413715124130249023, 0, 0, 0.649447441101074218, 0.760406434535980224, 120, 255, 1, 53262), -- Wreath (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+25, 181016, 1, 1638, 5345, '0', 0, 0, -1290.703125, 150.55035400390625, 129.7427978515625, 1.762782454490661621, 0, 0, 0.771624565124511718, 0.636078238487243652, 120, 255, 1, 53262), -- Wreath (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+26, 181016, 1, 1638, 5345, '0', 0, 0, -1277.2467041015625, 162.139190673828125, 131.1357269287109375, 2.687806606292724609, 0, 0, 0.974370002746582031, 0.224951311945915222, 120, 255, 1, 53262), -- Wreath (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+27, 181016, 1, 1638, 5345, '0', 0, 0, -1079.052978515625, 228.9611358642578125, 112.2561416625976562, 0.488691210746765136, 0, 0, 0.241921424865722656, 0.970295846462249755, 120, 255, 1, 53262), -- Wreath (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+28, 181016, 1, 1638, 5345, '0', 0, 0, -1074.3677978515625, 218.6214447021484375, 110.2166366577148437, 0.24434557557106018, 0, 0, 0.121869087219238281, 0.9925462007522583, 120, 255, 1, 53262), -- Wreath (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+29, 181016, 1, 1638, 5345, '0', 0, 0, -1031.923828125, 202.6702423095703125, 135.269744873046875, 0.872663915157318115, 0, 0, 0.422617912292480468, 0.906307935714721679, 120, 255, 1, 53262), -- Wreath (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+30, 181016, 1, 1638, 5345, '0', 0, 0, -1021.12567138671875, 192.480224609375, 135.497314453125, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 53262), -- Wreath (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+31, 181016, 1, 1638, 2197, '0', 0, 0, -1000.06927490234375, 264.76171875, 137.5902252197265625, 4.380776405334472656, 0, 0, -0.81411552429199218, 0.580702960491180419, 120, 255, 1, 53262), -- Wreath (Area: The Pools of Vision - Difficulty: 0) CreateObject1
+(@OGUID+32, 181016, 1, 1638, 2197, '0', 0, 0, -989.99456787109375, 260.398284912109375, 137.5902099609375, 4.118979454040527343, 0, 0, -0.88294696807861328, 0.469472706317901611, 120, 255, 1, 53262), -- Wreath (Area: The Pools of Vision - Difficulty: 0) CreateObject1
+(@OGUID+33, 181016, 1, 1638, 2197, '0', 0, 0, -938.90625, 278.451385498046875, 111.7419204711914062, 2.426007747650146484, 0, 0, 0.936672210693359375, 0.350207358598709106, 120, 255, 1, 53262), -- Wreath (Area: The Pools of Vision - Difficulty: 0) CreateObject1
+(@OGUID+34, 181016, 1, 1638, 5345, '0', 0, 0, -1071.9114990234375, -32.9583320617675781, 141.3477783203125, 6.108653545379638671, 0, 0, -0.08715534210205078, 0.996194720268249511, 120, 255, 1, 53262), -- Wreath (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+35, 181016, 1, 1638, 5345, '0', 0, 0, -1059.1336669921875, -7.60405778884887695, 141.3106536865234375, 5.515241622924804687, 0, 0, -0.37460613250732421, 0.927184045314788818, 120, 255, 1, 53262), -- Wreath (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+36, 181016, 1, 1638, 5345, '0', 0, 0, -1067.5364990234375, -18.40625, 140.60736083984375, 5.759587764739990234, 0, 0, -0.25881862640380859, 0.965925931930541992, 120, 255, 1, 53262), -- Wreath (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+37, 181016, 1, 1638, 5345, '0', 0, 0, -1069.7593994140625, 187.88482666015625, 107.7155838012695312, 1.064649581909179687, 0, 0, 0.507537841796875, 0.861629426479339599, 120, 255, 1, 53262), -- Wreath (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+38, 181016, 1, 1638, 5345, '0', 0, 0, -1059.8780517578125, 187.7550201416015625, 107.2493667602539062, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 53262), -- Wreath (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+39, 181016, 1, 1638, 2197, '0', 0, 0, -998.57305908203125, 280.934417724609375, 111.9098663330078125, 0.15707901120185852, 0, 0, 0.078458786010742187, 0.996917366981506347, 120, 255, 1, 53262), -- Wreath (Area: The Pools of Vision - Difficulty: 0) CreateObject1
+(@OGUID+40, 181016, 1, 1638, 2197, '0', 0, 0, -956.91461181640625, 267.94720458984375, 104.9567337036132812, 3.543023586273193359, 0, 0, -0.97992420196533203, 0.199370384216308593, 120, 255, 1, 53262), -- Wreath (Area: The Pools of Vision - Difficulty: 0) CreateObject1
+(@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, 53262), -- Hanging Streamer (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@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, 53262), -- Hanging Streamer (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+43, 181017, 1, 1638, 5345, '0', 0, 0, -1259.4410400390625, 39.81076431274414062, 133.9119720458984375, 1.623155713081359863, 0, 0, 0.725374221801757812, 0.688354730606079101, 120, 255, 1, 53262), -- Hanging, Streamer (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+44, 181019, 1, 1638, 5345, '0', 0, 0, -1290.5570068359375, 49.20296096801757812, 138.7949066162109375, 4.520402908325195312, 0, 0, -0.77162456512451171, 0.636078238487243652, 120, 255, 1, 53262), -- Rose Vase (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+45, 181020, 1, 1638, 5345, '0', 0, 0, -1189.541259765625, 36.99929428100585937, 180.6167144775390625, 3.874631166458129882, 0, 0, -0.93358039855957031, 0.358368009328842163, 120, 255, 1, 53262), -- Ribbon (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+46, 181020, 1, 1638, 5345, '0', 0, 0, -1146.219970703125, 17.28130531311035156, 150.334930419921875, 0.488691210746765136, 0, 0, 0.241921424865722656, 0.970295846462249755, 120, 255, 1, 53262), -- Ribbon (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+47, 181020, 1, 1638, 5345, '0', 0, 0, -1200.7392578125, 40.05040359497070312, 180.8592529296875, 4.939284324645996093, 0, 0, -0.6225137710571289, 0.78260880708694458, 120, 255, 1, 53262), -- Ribbon (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+48, 181020, 1, 1638, 5345, '0', 0, 0, -1175.136962890625, -48.8111457824707031, 167.6138153076171875, 3.071766138076782226, 0, 0, 0.999390602111816406, 0.034906134009361267, 120, 255, 1, 53262), -- Ribbon (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+49, 181020, 1, 1638, 5345, '0', 0, 0, -1192.921875, 22.21918487548828125, 181.239837646484375, 1.902408957481384277, 0, 0, 0.814115524291992187, 0.580702960491180419, 120, 255, 1, 53262), -- Ribbon (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+50, 181020, 1, 1638, 5345, '0', 0, 0, -1204.6141357421875, 25.11626625061035156, 181.1231231689453125, 0.750490784645080566, 0, 0, 0.3665008544921875, 0.93041771650314331, 120, 255, 1, 53262), -- Ribbon (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+51, 181020, 1, 1638, 0, '0', 0, 0, -1248.75, -62.7546653747558593, 170.3091888427734375, 0.087265998125076293, 0, 0, 0.043619155883789062, 0.999048233032226562, 120, 255, 1, 53262), -- Ribbon (Area: 0 - Difficulty: 0) CreateObject1
+(@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, 53262), -- Ribbon (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+53, 181020, 1, 1638, 1639, '0', 0, 0, -1057.5440673828125, -259.68505859375, 168.674072265625, 1.710421562194824218, 0, 0, 0.754709243774414062, 0.656059443950653076, 120, 255, 1, 53262), -- Ribbon (Area: Elder Rise - Difficulty: 0) CreateObject1
+(@OGUID+54, 181020, 1, 1638, 5345, '0', 0, 0, -1423.9271240234375, -109.048622131347656, 167.309967041015625, 5.672322273254394531, 0, 0, -0.3007049560546875, 0.953717231750488281, 120, 255, 1, 53262), -- Ribbon (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+55, 181021, 1, 1638, 5345, '0', 0, 0, -1277.654052734375, 49.86848831176757812, 144.23760986328125, 0.558503925800323486, 0, 0, 0.275636672973632812, 0.961261868476867675, 120, 255, 1, 53262), -- Lovely Wreath (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+56, 181027, 1, 1638, 5345, '0', 0, 0, -1256.9385986328125, 101.0687408447265625, 127.886383056640625, 2.199114561080932617, 0, 0, 0.8910064697265625, 0.453990638256072998, 120, 255, 1, 53262), -- Floating Wreath (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+57, 181027, 1, 1638, 5345, '0', 0, 0, -1266.0574951171875, 100.9608001708984375, 127.886383056640625, 5.096362113952636718, 0, 0, -0.55919265747070312, 0.829037725925445556, 120, 255, 1, 53262), -- Floating Wreath (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+58, 181027, 1, 1638, 5345, '0', 0, 0, -1261.5184326171875, 94.57465362548828125, 127.886383056640625, 0.872663915157318115, 0, 0, 0.422617912292480468, 0.906307935714721679, 120, 255, 1, 53262), -- Floating Wreath (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+59, 181060, 1, 1638, 5345, '0', 0, 0, -1235.884521484375, -55.7594947814941406, 166.207275390625, 5.235987663269042968, 0, 0, -0.5, 0.866025388240814208, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+60, 181060, 1, 1638, 5345, '0', 0, 0, -1193.2265625, -7.46245718002319335, 168.891204833984375, 6.021387100219726562, 0, 0, -0.13052558898925781, 0.991444945335388183, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+61, 181060, 1, 1638, 5345, '0', 0, 0, -1228.7491455078125, 45.35286331176757812, 131.0964813232421875, 3.769911527633666992, 0, 0, -0.95105648040771484, 0.309017121791839599, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+62, 181060, 1, 1638, 5345, '0', 0, 0, -1256.150390625, 51.2523345947265625, 129.9654693603515625, 3.508116960525512695, 0, 0, -0.98325443267822265, 0.182238012552261352, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+63, 181060, 1, 1638, 5345, '0', 0, 0, -1192.8543701171875, -5.08306217193603515, 168.891204833984375, 5.148722648620605468, 0, 0, -0.53729915618896484, 0.843391716480255126, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+64, 181060, 1, 1638, 5345, '0', 0, 0, -1140.3104248046875, 48.54817581176757812, 147.170196533203125, 1.274088263511657714, 0, 0, 0.594821929931640625, 0.80385744571685791, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+65, 181060, 1, 1638, 5345, '0', 0, 0, -1277.001220703125, 80.466064453125, 131.8394927978515625, 0.436331570148468017, 0, 0, 0.216439247131347656, 0.976296067237854003, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+66, 181060, 1, 1638, 5345, '0', 0, 0, -1162.2547607421875, 29.90814971923828125, 149.0304718017578125, 4.852017402648925781, 0, 0, -0.65605831146240234, 0.754710197448730468, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+67, 181060, 1, 1638, 5345, '0', 0, 0, -1183.1595458984375, -54.9835090637207031, 165.0548858642578125, 0.24434557557106018, 0, 0, 0.121869087219238281, 0.9925462007522583, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+68, 181060, 1, 1638, 5345, '0', 0, 0, -1226.719970703125, 80.64111328125, 133.7146759033203125, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+69, 181060, 1, 1638, 5345, '0', 0, 0, -1118.2960205078125, 39.44601821899414062, 144.7226409912109375, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+70, 181060, 1, 1638, 5345, '0', 0, 0, -1230.7047119140625, -41.4822044372558593, 167.7692718505859375, 2.600535154342651367, 0, 0, 0.963629722595214843, 0.26724100112915039, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+71, 181060, 1, 1638, 5345, '0', 0, 0, -1236.0909423828125, -58.232421875, 166.207275390625, 3.159062385559082031, 0, 0, -0.99996185302734375, 0.008734640665352344, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+72, 181060, 1, 1638, 5345, '0', 0, 0, -1186.3060302734375, -38.4025077819824218, 166.353759765625, 0.959929943084716796, 0, 0, 0.461748123168945312, 0.887011110782623291, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+73, 181060, 1, 1638, 5345, '0', 0, 0, -1231.693603515625, -43.6813163757324218, 167.7692718505859375, 1.972219824790954589, 0, 0, 0.83388519287109375, 0.55193793773651123, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+74, 181060, 1, 1638, 5345, '0', 0, 0, -1213.212158203125, -10.1758899688720703, 169.180908203125, 2.007128477096557617, 0, 0, 0.84339141845703125, 0.537299633026123046, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+75, 181060, 1, 1638, 5345, '0', 0, 0, -1118.1959228515625, 37.14789581298828125, 144.7226409912109375, 3.595378875732421875, 0, 0, -0.97437000274658203, 0.224951311945915222, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+76, 181060, 1, 1638, 5345, '0', 0, 0, -1224.4246826171875, 81.43978118896484375, 133.7146759033203125, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+77, 181060, 1, 1638, 5345, '0', 0, 0, -1234.4388427734375, 84.67583465576171875, 133.53326416015625, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+78, 181060, 1, 1638, 5345, '0', 0, 0, -1253.876220703125, 51.97222137451171875, 129.9654693603515625, 1.466075778007507324, 0, 0, 0.669130325317382812, 0.74314504861831665, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+79, 181060, 1, 1638, 5345, '0', 0, 0, -1160.0379638671875, 29.34076690673828125, 149.0304718017578125, 1.204277276992797851, 0, 0, 0.56640625, 0.824126183986663818, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+80, 181060, 1, 1638, 5345, '0', 0, 0, -1236.0772705078125, 82.8995208740234375, 133.53326416015625, 3.543023586273193359, 0, 0, -0.97992420196533203, 0.199370384216308593, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+81, 181060, 1, 1638, 5345, '0', 0, 0, -1147.0972900390625, 26.90738868713378906, 148.4151763916015625, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+82, 181060, 1, 1638, 5345, '0', 0, 0, -1278.8707275390625, 81.89482879638671875, 131.8394927978515625, 3.700104713439941406, 0, 0, -0.96126079559326171, 0.275640487670898437, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+83, 181060, 1, 1638, 5345, '0', 0, 0, -1139.33447265625, 50.64811325073242187, 147.170196533203125, 0.052358884364366531, 0, 0, 0.02617645263671875, 0.999657332897186279, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+84, 181060, 1, 1638, 5345, '0', 0, 0, -1183.140625, -57.48828125, 165.0548858642578125, 0.24434557557106018, 0, 0, 0.121869087219238281, 0.9925462007522583, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+85, 181060, 1, 1638, 5345, '0', 0, 0, -1149.4215087890625, 27.28667640686035156, 148.4151763916015625, 3.43830275535583496, 0, 0, -0.98901557922363281, 0.147811368107795715, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@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, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+87, 181060, 1, 1638, 5345, '0', 0, 0, -1226.410400390625, 45.39122390747070312, 131.0964813232421875, 3.52557229995727539, 0, 0, -0.98162651062011718, 0.190812408924102783, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+88, 181060, 1, 1638, 5345, '0', 0, 0, -1187.5284423828125, -36.2961158752441406, 166.353759765625, 5.811946868896484375, 0, 0, -0.2334451675415039, 0.972369968891143798, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+89, 181060, 1, 1638, 5345, '0', 0, 0, -1245.642333984375, 137.2523345947265625, 136.0482940673828125, 1.413715124130249023, 0, 0, 0.649447441101074218, 0.760406434535980224, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+90, 181060, 1, 1638, 5345, '0', 0, 0, -1243.2122802734375, 137.3705291748046875, 136.0482940673828125, 4.991643905639648437, 0, 0, -0.60181427001953125, 0.798636078834533691, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+91, 181060, 1, 1638, 5345, '0', 0, 0, -1261.0103759765625, 134.4913177490234375, 135.5670928955078125, 4.834563255310058593, 0, 0, -0.66261959075927734, 0.748956084251403808, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+92, 181060, 1, 1638, 5345, '0', 0, 0, -1292.994140625, 112.3231430053710937, 134.36663818359375, 0.907570242881774902, 0, 0, 0.438370704650878906, 0.898794233798980712, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+93, 181060, 1, 1638, 5345, '0', 0, 0, -1295.1300048828125, 100.2773971557617187, 133.6595458984375, 2.652894020080566406, 0, 0, 0.970294952392578125, 0.241925001144409179, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+94, 181060, 1, 1638, 5345, '0', 0, 0, -1292.634765625, 114.8027725219726562, 134.36663818359375, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+95, 181060, 1, 1638, 5345, '0', 0, 0, -1288.8802490234375, 130.986602783203125, 134.571075439453125, 2.042035102844238281, 0, 0, 0.852640151977539062, 0.522498607635498046, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+96, 181060, 1, 1638, 5345, '0', 0, 0, -1294.2308349609375, 97.88785552978515625, 133.6595458984375, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+97, 181060, 1, 1638, 5345, '0', 0, 0, -1258.5885009765625, 134.4774322509765625, 135.557403564453125, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+98, 181060, 1, 1638, 5345, '0', 0, 0, -1218.060791015625, 145.6770782470703125, 136.9156036376953125, 4.677483558654785156, 0, 0, -0.71933937072753906, 0.694658815860748291, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+99, 181060, 1, 1638, 5345, '0', 0, 0, -1220.5035400390625, 145.8506927490234375, 136.915618896484375, 4.642575740814208984, 0, 0, -0.731353759765625, 0.681998312473297119, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+100, 181060, 1, 1638, 5345, '0', 0, 0, -1290.470458984375, 132.9488983154296875, 134.571075439453125, 5.654868602752685546, 0, 0, -0.30901622772216796, 0.95105677843093872, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+101, 181060, 1, 1638, 1640, '0', 0, 0, -993.94464111328125, 210.49053955078125, 138.7931671142578125, 4.345870018005371093, 0, 0, -0.82412624359130859, 0.566406130790710449, 120, 255, 1, 53262), -- Lovely Candle (Area: Spirit Rise - Difficulty: 0) CreateObject1
+(@OGUID+102, 181060, 1, 1638, 1640, '0', 0, 0, -1002.318603515625, 231.2728729248046875, 138.291107177734375, 4.625123500823974609, 0, 0, -0.73727703094482421, 0.67559051513671875, 120, 255, 1, 53262), -- Lovely Candle (Area: Spirit Rise - Difficulty: 0) CreateObject1
+(@OGUID+103, 181060, 1, 1638, 1640, '0', 0, 0, -1000.31182861328125, 230.149932861328125, 138.291107177734375, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 120, 255, 1, 53262), -- Lovely Candle (Area: Spirit Rise - Difficulty: 0) CreateObject1
+(@OGUID+104, 181060, 1, 1638, 2197, '0', 0, 0, -991.78668212890625, 211.693389892578125, 138.7931671142578125, 2.059488296508789062, 0, 0, 0.857167243957519531, 0.515038192272186279, 120, 255, 1, 53262), -- Lovely Candle (Area: The Pools of Vision - Difficulty: 0) CreateObject1
+(@OGUID+105, 181060, 1, 1638, 5345, '0', 0, 0, -1103.803466796875, 21.81060218811035156, 143.860504150390625, 4.118979454040527343, 0, 0, -0.88294696807861328, 0.469472706317901611, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+106, 181060, 1, 1638, 5345, '0', 0, 0, -1102.7022705078125, 19.67789649963378906, 143.860504150390625, 5.532694816589355468, 0, 0, -0.3665008544921875, 0.93041771650314331, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+107, 181060, 1, 1638, 5345, '0', 0, 0, -1114.4302978515625, 4.692165851593017578, 145.2327423095703125, 4.852017402648925781, 0, 0, -0.65605831146240234, 0.754710197448730468, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+108, 181060, 1, 1638, 5345, '0', 0, 0, -1091.3724365234375, -1.32107198238372802, 143.9541015625, 0.767943859100341796, 0, 0, 0.374606132507324218, 0.927184045314788818, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+109, 181060, 1, 1638, 5345, '0', 0, 0, -1091.0267333984375, 1.14784097671508789, 143.9541015625, 2.617989301681518554, 0, 0, 0.965925216674804687, 0.258821308612823486, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+110, 181060, 1, 1638, 5345, '0', 0, 0, -1114.9776611328125, 7.12733316421508789, 145.23272705078125, 4.328419685363769531, 0, 0, -0.82903671264648437, 0.559194147586822509, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+111, 181060, 1, 1638, 5345, '0', 0, 0, -1174.2098388671875, -75.0950546264648437, 165.6610870361328125, 2.844882726669311523, 0, 0, 0.989015579223632812, 0.147811368107795715, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+112, 181060, 1, 1638, 5345, '0', 0, 0, -1174.347900390625, -72.669219970703125, 165.6610870361328125, 0.523597896099090576, 0, 0, 0.258818626403808593, 0.965925931930541992, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+113, 181060, 1, 1638, 1639, '0', 0, 0, -1041.5947265625, -213.362518310546875, 162.631591796875, 3.822272777557373046, 0, 0, -0.94264125823974609, 0.333807557821273803, 120, 255, 1, 53262), -- Lovely Candle (Area: Elder Rise - Difficulty: 0) CreateObject1
+(@OGUID+114, 181060, 1, 1638, 1639, '0', 0, 0, -1066.189697265625, -241.400283813476562, 162.2833099365234375, 3.001946926116943359, 0, 0, 0.997563362121582031, 0.069766148924827575, 120, 255, 1, 53262), -- Lovely Candle (Area: Elder Rise - Difficulty: 0) CreateObject1
+(@OGUID+115, 181060, 1, 1638, 1639, '0', 0, 0, -1042.255859375, -215.808914184570312, 162.6315765380859375, 4.258606910705566406, 0, 0, -0.84804725646972656, 0.529920578002929687, 120, 255, 1, 53262), -- Lovely Candle (Area: Elder Rise - Difficulty: 0) CreateObject1
+(@OGUID+116, 181060, 1, 1638, 1639, '0', 0, 0, -1063.76025390625, -241.52203369140625, 162.2833099365234375, 0.558503925800323486, 0, 0, 0.275636672973632812, 0.961261868476867675, 120, 255, 1, 53262), -- Lovely Candle (Area: Elder Rise - Difficulty: 0) CreateObject1
+(@OGUID+117, 181060, 1, 1638, 5345, '0', 0, 0, -1406.429443359375, -109.241539001464843, 162.2984161376953125, 4.380776405334472656, 0, 0, -0.81411552429199218, 0.580702960491180419, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+118, 181060, 1, 1638, 5345, '0', 0, 0, -1407.6434326171875, -111.458282470703125, 162.2984161376953125, 2.879789113998413085, 0, 0, 0.991444587707519531, 0.130528271198272705, 120, 255, 1, 53262), -- Lovely Candle (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+119, 411551, 1, 1638, 5345, '0', 0, 0, -1219.4305419921875, 62.51041793823242187, 129.6041717529296875, 3.38017582893371582, 0, 0, -0.99289321899414062, 0.119008727371692657, 120, 255, 1, 53262), -- Scenic Getaway Portal (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+(@OGUID+120, 416381, 1, 1638, 5345, '0', 0, 0, -1219.4305419921875, 62.51041793823242187, 129.6041717529296875, 3.38017582893371582, 0, 0, -0.99289321899414062, 0.119008727371692657, 120, 255, 1, 53262); -- Portal Arch (Area: Thunder Bluff - Difficulty: 0) CreateObject1
+
+-- Event spawns
+DELETE FROM `game_event_creature` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @CGUID+0 AND @CGUID+1;
+INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES
+(@EVENT, @CGUID+0),
+(@EVENT, @CGUID+1);
+
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @OGUID+0 AND @OGUID+120;
+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);