diff options
| -rw-r--r-- | sql/updates/world/master/2024_03_10_03_world.sql | 363 |
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); |