diff options
| -rw-r--r-- | sql/updates/world/master/2024_03_10_00_world.sql | 288 |
1 files changed, 288 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_03_10_00_world.sql b/sql/updates/world/master/2024_03_10_00_world.sql new file mode 100644 index 00000000000..b03b66a0647 --- /dev/null +++ b/sql/updates/world/master/2024_03_10_00_world.sql @@ -0,0 +1,288 @@ +SET @CGUID := 9800003; +SET @OGUID := 9800057; +SET @EVENT := 8; +SET @NPCTEXTID := 590110; + +-- Creature templates +UPDATE `creature_template` SET `faction`=534, `npcflag`=2, `BaseAttackTime`=2000, `unit_flags`=256, `unit_flags2`=2048 WHERE `entry`=215197; -- Gabbo Blinkwink + +DELETE FROM `creature_template_addon` WHERE `entry`=215197; +INSERT INTO `creature_template_addon` (`entry`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(215197, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '427424'); -- 215197 (Gabbo Blinkwink) - [DNT] Mirror Image + +-- Models +UPDATE `creature_model_info` SET `VerifiedBuild`=53262 WHERE `DisplayID` IN (109714, 109476, 5554, 99617, 99600, 74943, 65406, 64921, 24982, 42481, 304, 26184, 43152, 15395, 37957, 37956, 37844, 37836, 37695, 37693, 37514, 37401, 37349, 99842, 99840, 37348, 37350, 36940, 36941, 36938, 36934, 36936, 36937, 37017, 37018, 36357, 4959, 36342, 35706, 33140, 9288, 9289, 8826, 32681, 32680, 35687, 29573, 29520, 29512, 27298, 27274, 25955, 22397, 21265, 18844, 18845, 15986, 15984, 15965, 15625, 15369, 14405, 14404, 14396, 14235, 13850, 11053, 10694, 10693, 10588, 10722, 10571, 10184, 9821, 9818, 9740, 9741, 9338, 9258, 9131, 8829, 8171, 7989, 7951, 7990, 7598, 7805, 7769, 7120, 7041, 7028, 7003, 6072, 6062, 6588, 5647, 5377, 5085, 4988, 4986, 4893, 4892, 4891, 4889, 4999, 4865, 4995, 4950, 3756, 3591, 3526, 99837, 3525, 3527, 3524, 77915, 99838, 99836, 3458, 3457, 3596, 3125, 3124, 3118, 3117, 3122, 3116, 3115, 3103, 3114, 3113, 3100, 3101, 3112, 3121, 3096, 3095, 3094, 3120, 3111, 3071, 3070, 3069, 3091, 3110, 3119, 3068, 3087, 3088, 3089, 3109, 10214, 3108, 3085, 3066, 3086, 3065, 3064, 3063, 3082, 3107, 3081, 3106, 3105, 3104, 3080, 3079, 3078, 5408, 3077, 3076, 3057, 3075, 3073, 3072, 3056, 3055, 3054, 3051, 3047, 3046, 3050, 3049, 3045, 3044, 3043, 3042, 3041, 3040, 3039, 2999, 3098, 3097, 3093, 3092, 2184, 2049, 1935, 7916, 3598, 3595, 5410, 3599, 9817, 1670, 10548, 3038, 3037, 3600, 1891, 3053, 10629, 3007, 10620, 3594, 1655, 10635); +UPDATE `creature_model_info` SET `BoundingRadius`=0.221895694732666015, `CombatReach`=0.800000011920928955, `VerifiedBuild`=53262 WHERE `DisplayID`=88407; +UPDATE `creature_model_info` SET `BoundingRadius`=0.305999994277954101, `CombatReach`=1.5, `VerifiedBuild`=53262 WHERE `DisplayID` IN (18847, 18846); +UPDATE `creature_model_info` SET `DisplayID_Other_Gender`=0, `VerifiedBuild`=53262 WHERE `DisplayID`=15872; + +UPDATE `creature_template_model` SET `VerifiedBuild`=53262 WHERE (`Idx`=0 AND `CreatureID` IN (42146,11146,10877,3979,52586,5154,5125,9984,51383,5140,5122,1356,5637,2737,5161,5170,11406,5144,5141,6181,5109,6569,50308,15186,6120,5107,153285,1246,23127,51976,7312,5142,5111,19148,61317,14365,24110,97762,5172,50717,5143,5132,42131,5124,5158,118889,5171,52321,122323,2460,5177,1959,6294,10456,50716,7978,6114,5150,47582,6031,50309,5160,52584,2943,53544,1703,42129,5119,5116,5174,42147,39718,50732,6178,89830,2461,5099,6175,5100,2790,34991,9616,5159,8720,5049,48972,8256,5169,197776,29141,27478,5129,5114,5605,5175,11145,35073,50723,5165,50729,14363,5103,5123,10277,3842,62425,52335,9859,5126,5157,175403,7944,4259,2916,5163,175412,13843,2092,7976,7298,96490,16013,5162,5153,2918,14183,5113,5121,7950,50720,5133,51596,8671,8517,5115,19172,5595,5148,5146,53568,5120,35007,5570,5569,11029,6826,5102,5130,42928,5137,11065,5178,10276,4258,5387,4254,175411,51978,5147,5145,5151,5110,5108,215197,5138,10090,197249,5117,61690,5128,7292,1901,6169,4256,6382,5173,8681,5127,1466,5149,5152,5106,5101,30733,9099,7936,5167,16069,5155,6291,15871,1274,51495,42152,30717,2786,5156,8507,8879,34281,5112,2695,4081,48935,1573,14367,5166,16070,10455,175410,2489,6179,11028)) OR (`Idx`=7 AND `CreatureID` IN (51383,5595)) OR (`Idx`=6 AND `CreatureID` IN (51383,5595)) OR (`Idx`=5 AND `CreatureID` IN (51383,5595)) OR (`Idx`=4 AND `CreatureID` IN (51383,5595)) OR (`Idx`=3 AND `CreatureID` IN (51383,89830,5595)) OR (`Idx`=2 AND `CreatureID` IN (51383,42147,89830,5595,53568)) OR (`Idx`=1 AND `CreatureID` IN (51383,19148,61317,24110,122323,42147,89830,48972,19172,5595,53568,42152,34281)); + +-- Difficulties +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456 WHERE (`DifficultyID`=0 AND `Entry` IN (215103,215105,215104)); +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=215197 AND `DifficultyID`=0); -- Gabbo Blinkwink +UPDATE `creature_template_difficulty` SET `VerifiedBuild`=53262 WHERE (`DifficultyID`=0 AND `Entry` IN (197776,197249,175412,175411,175410,175403,153285,122323,118889,97762,96490,89830,62425,61690,61317,53568,53544,52586,52584,52335,52321,51978,51976,51596,51495,51383,50732,50729,50723,50720,50717,50716,50309,50308,48972,48935,47582,42928,42152,42147,42146,42131,42129,39718,35073,35007,34991,34281,30733,30717,29141,27478,24110,23127,19172,19148,16070,16069,16013,15871,15186,14367,14365,14363,14183,13843,11406,11146,11145,11065,11029,11028,10877,10456,10455,10277,10276,10090,9984,9859,9616,9099,8879,8720,8681,8671,8517,8507,8256,7978,7976,7950,7944,7936,7312,7298,7292,6826,6569,6382,6294,6291,6181,6179,6178,6175,6169,6120,6114,6031,5637,5605,5595,5570,5569,5387,5178,5177,5175,5174,5173,5172,5171,5170,5169,5167,5166,5165,5163,5162,5161,5160,5159,5158,5157,5156,5155,5154,5153,5152,5151,5150,5149,5148,5147,5146,5145,5144,5143,5142,5141,5140,5138,5137,5133,5132,5130,5129,5128,5127,5126,5125,5124,5123,5122,5121,5120,5119,5117,5116,5115,5114,5113,5112,5111,5110,5109,5108,5107,5106,5103,5102,5101,5100,5099,5049,4259,4258,4256,4254,4081,3979,3842,2943,2918,2916,2790,2786,2737,2695,2489,2461,2460,2092,1959,1901,1703,1573,1466,1356,1274,1246)); + +-- Gameobject templates +DELETE FROM `gameobject_template` WHERE `entry` IN (416381 /*Portal Arch*/, 398729 /*Chair*/); +INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `size`, `Data0`, `Data1`, `Data2`, `Data3`, `Data4`, `Data5`, `Data6`, `Data7`, `Data8`, `Data9`, `Data10`, `Data11`, `Data12`, `Data13`, `Data14`, `Data15`, `Data16`, `Data17`, `Data18`, `Data19`, `Data20`, `Data21`, `Data22`, `Data23`, `Data24`, `Data25`, `Data26`, `Data27`, `Data28`, `Data29`, `Data30`, `Data31`, `Data32`, `Data33`, `Data34`, `ContentTuningId`, `VerifiedBuild`) VALUES +(416381, 5, 85945, 'Portal Arch', '', '', '', 3, 0, 0, 0, 1, 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, 53262), -- Portal Arch +(398729, 0, 51162, 'Chair', '', '', '', 0.999999761581420898, 0, 0, 3000, 0, 0, 0, 0, 0, 1, 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, 53262); -- Chair + +UPDATE `gameobject_template` SET `VerifiedBuild`=53262 WHERE `entry` IN (171712, 203607, 171551, 137647, 175683, 171562, 171561, 171686, 171631, 143296, 171598, 190680, 171569, 187294, 171524, 143318, 171645, 171658, 171705, 143343, 171566, 171530, 171687, 171623, 143298, 143245, 303171, 171577, 32427, 171587, 142912, 143334, 175682, 175679, 171725, 171630, 143295, 208244, 176624, 171612, 171585, 171668, 171707, 143349, 171592, 142873, 171765, 171776, 171767, 171685, 203611, 190684, 32385, 176625, 171697, 143320, 171672, 171737, 171735, 171560, 143273, 171593, 171768, 137644, 171617, 171557, 171667, 171734, 174848, 171744, 142340, 171680, 171541, 203613, 203615, 308115, 32424, 176627, 171535, 171750, 171732, 171711, 171774, 32383, 171684, 245052, 171695, 143253, 171653, 143254, 171552, 171746, 205220, 1685, 171749, 142339, 171717, 143344, 171724, 171632, 171775, 143243, 171771, 143256, 203464, 203614, 171570, 142838, 171635, 171608, 171644, 171659, 171740, 171532, 32391, 171563, 32389, 143342, 171681, 309564, 190683, 171572, 207320, 171583, 171671, 143255, 171733, 171534, 32416, 175688, 171627, 171626, 143348, 203612, 203609, 149418, 205080, 176629, 143321, 171643, 171669, 171752, 144162, 171709, 171742, 177222, 171727, 171590, 171625, 171729, 171603, 195256, 171600, 171543, 149417, 171573, 205079, 171615, 171618, 171613, 171540, 171656, 171638, 171525, 171555, 171748, 171679, 171716, 143363, 171661, 307673, 171578, 171636, 176626, 26499, 143323, 171582, 171657, 142916, 203415, 171553, 171715, 171714, 175684, 175265, 175725, 175685, 150087, 171688, 142872, 171628, 142871, 143244, 171594, 171682, 171722, 171693, 171702, 137646, 149413, 171650, 171527, 142914, 171754, 171738, 203605, 171708, 175734, 171589, 143247, 26494, 171692, 171696, 171588, 143322, 171539, 181688, 142915, 149412, 171755, 171710, 32404, 143333, 171528, 142874, 26495, 171647, 171597, 171723, 171694, 171571, 143324, 171611, 143326, 171652, 171654, 171606, 143250, 32358, 244883, 171548, 171689, 171629, 142341, 171766, 179984, 171616, 171640, 171747, 171741, 143362, 171565, 171726, 171769, 171547, 143317, 174746, 171701, 176924, 171634, 171559, 171526, 171666, 37478, 206975, 205221, 171753, 175681, 171691, 171624, 171772, 171703, 171579, 144159, 171614, 171584, 139852, 171537, 171558, 171641, 143337, 171739, 171564, 171529, 184955, 171773, 180884, 171596, 171544, 203610, 32349, 171704, 171698, 171609, 171581, 171642, 171651, 171639, 171756, 171554, 143251, 171743, 208860, 175686, 171549, 143328, 171646, 171545, 152614, 171536, 143249, 171670, 208870, 171706, 171713, 143338, 171690, 143246, 171602, 171770, 171542, 203604, 171574, 32431, 171580, 143319, 171655, 171556, 171731, 180756, 171730, 143347, 175736, 171531, 171728, 171591, 143299, 143297, 171745, 32425, 143301, 171599, 171595, 26496, 171764, 203608, 308114, 171576, 142911, 171664, 171604, 142851, 171605, 143345, 171550, 171533, 175726, 175687, 175689, 143314, 34360, 195259, 171601, 32355, 171683, 171546, 190681, 205077, 176628, 171633, 143325, 171586, 171538, 143336, 171673, 171665, 171607, 171736, 143346, 32429, 244886, 175742, 175680, 143242, 171660, 208375, 171575, 171700, 171699, 171610, 171678, 268896, 171751); +UPDATE `gameobject_template` SET `displayId`=85962, `name`='Lovely Wreath', `VerifiedBuild`=53262 WHERE `entry`=181021; -- Hanging, Door - Val +UPDATE `gameobject_template` SET `displayId`=86537, `VerifiedBuild`=53262 WHERE `entry`=176231; -- Ship (The Lady Mehley) + +DELETE FROM `gameobject_template_addon` WHERE `entry` IN (416381 /*Portal Arch*/, 398729 /*Chair*/, 309564 /*Remnant of the Earthen Ritual*/, 308114 /*Door to Old Ironforge*/, 307673 /*Door to Aegrim's Study*/, 268896 /*Cask 'n' Anvil*/, 245052 /*Large Collision Wall*/); +INSERT INTO `gameobject_template_addon` (`entry`, `faction`, `flags`, `WorldEffectID`, `AIAnimKitID`) VALUES +(416381, 114, 32, 0, 0), -- Portal Arch +(398729, 0, 32, 0, 0), -- Chair +(309564, 0, 2113540, 0, 0), -- Remnant of the Earthen Ritual +(308114, 0, 262144, 0, 5061), -- Door to Old Ironforge +(307673, 0, 262144, 0, 5061), -- Door to Aegrim's Study +(268896, 0, 32, 0, 0), -- Cask 'n' Anvil +(245052, 1375, 0, 0, 0); -- Large Collision Wall + +UPDATE `gameobject_template_addon` SET `faction`=35 WHERE `entry`=259114; -- [DNT] Command Table Collision Cylinder +UPDATE `gameobject_template_addon` SET `WorldEffectID`=16227 WHERE `entry` IN (190684, 190683); -- Barbershop Chair + +-- Gossips +DELETE FROM `npc_text` WHERE `ID` BETWEEN @NPCTEXTID+0 AND @NPCTEXTID+0; +INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextId0`, `BroadcastTextId1`, `BroadcastTextId2`, `BroadcastTextId3`, `BroadcastTextId4`, `BroadcastTextId5`, `BroadcastTextId6`, `BroadcastTextId7`, `VerifiedBuild`) VALUES +(@NPCTEXTID+0, 1, 0, 0, 0, 0, 0, 0, 0, 250291, 0, 0, 0, 0, 0, 0, 0, 53262); -- 411551 (Scenic Getaway Portal) + +DELETE FROM `gossip_menu` WHERE (`MenuID`=32934 AND `TextID`=@NPCTEXTID+0); +INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES +(32934, @NPCTEXTID+0, 53262); -- 411551 (Scenic Getaway Portal) + +DELETE FROM `gossip_menu_option` WHERE (`MenuID`=32934 AND `OptionID` IN (11,12,3,10,13)); +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, 120253, 3, 0, 'The Gala of Gifts.', 0, 0, 1, 0, 0, NULL, 0, 0, NULL, 0, NULL, NULL, 53262), +(32934, 114309, 10, 0, 'A romantic hideout in Val''sharah.', 0, 0, 0, 0, 0, NULL, 0, 0, NULL, 0, NULL, NULL, 53262), +(32934, 114308, 11, 0, 'The thrilling peaks of the Jade Forest.', 0, 0, 0, 0, 0, NULL, 0, 0, NULL, 0, NULL, NULL, 53262), +(32934, 114307, 12, 0, 'A relaxing wade into Winterspring hot springs.', 0, 0, 0, 0, 0, NULL, 0, 0, NULL, 0, NULL, NULL, 53262), +(32934, 119770, 13, 0, 'The lovely lakeside in Northern Stranglethorn.', 0, 0, 0, 0, 0, NULL, 0, 0, NULL, 0, NULL, NULL, 53262); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=32934 AND `SourceEntry`=3; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(15, 32934, 3, 0, 0, 47, 0, 78329, 2, 0, '', 0, 0, 0, '', 'Show gossip option if quest 78329 is completed'); + +-- Quests +DELETE FROM `creature_queststarter` WHERE (`id`=215197 AND `quest`=78329); +INSERT INTO `creature_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(215197, 78329, 53262); -- Love is in the Air offered by Gabbo Blinkwink + +-- Misc +DELETE FROM `spell_target_position` WHERE (`ID`=430728 AND `EffectIndex`=0); +INSERT INTO `spell_target_position` (`ID`, `EffectIndex`, `MapID`, `PositionX`, `PositionY`, `PositionZ`, `VerifiedBuild`) VALUES +(430728, 0, 0, -9019.3798828125, 469.589996337890625, 150, 53262); -- Spell: 430728 (Portal: Gala of Gifts...?) Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) + +-- SAI +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=215197; + +DELETE FROM `smart_scripts` WHERE `entryorguid`=215197 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 +(215197,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,'Gabbo Blinkwink - Out of combat (5.0 - 8.5 seconds) - Play emote'); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceGroup`=1 AND `SourceEntry`=215197; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(22, 1, 215197, 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 3000021 AND 3000025; +DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 3000021 AND 3000025; + +-- 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, 0, 1537, 5719, '0', 0, 0, 0, 0, -4939.44775390625, -937.36981201171875, 503.2398681640625, 0.767944872379302978, 120, 0, 0, 112919, 0, 0, NULL, NULL, NULL, NULL, 53262), -- Steamwheedle Shyster (Area: The Commons - Difficulty: 0) CreateObject1 +(@CGUID+1, 215197, 0, 1537, 5719, '0', 0, 0, 0, 0, -4920.6025390625, -975.02606201171875, 501.5517578125, 2.295789718627929687, 120, 0, 0, 112919, 0, 0, NULL, NULL, NULL, NULL, 53262); -- Gabbo Blinkwink (Area: The Commons - Difficulty: 0) CreateObject1 (Auras: 427424 - [DNT] Mirror Image) + +-- Old gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN 3000635 AND 3000719; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 3000635 AND 3000719; + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+85; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@OGUID+0, 181015, 0, 1537, 5719, '0', 0, 0, -4923.484375, -987.1875, 501.44683837890625, 2.071596145629882812, 0, 0, 0.860269546508789062, 0.509839534759521484, 120, 255, 1, 53262), -- Crate (Area: The Commons - Difficulty: 0) CreateObject1 +(@OGUID+1, 181015, 0, 1537, 5719, '0', 0, 0, -4915.658203125, -981.22222900390625, 501.44427490234375, 1.557761192321777343, 0, 0, 0.702483177185058593, 0.711700379848480224, 120, 255, 1, 53262), -- Crate (Area: The Commons - Difficulty: 0) CreateObject1 +(@OGUID+2, 181015, 0, 1537, 5719, '0', 0, 0, -4925.1943359375, -989.50347900390625, 501.4462890625, 2.576072454452514648, 0, 0, 0.96028900146484375, 0.279007226228713989, 120, 255, 1, 53262), -- Crate (Area: The Commons - Difficulty: 0) CreateObject1 +(@OGUID+3, 181015, 0, 1537, 5719, '0', 0, 0, -4915.90966796875, -984.4617919921875, 501.446624755859375, 2.199114561080932617, 0, 0, 0.8910064697265625, 0.453990638256072998, 120, 255, 1, 53262), -- Crate (Area: The Commons - Difficulty: 0) CreateObject1 +(@OGUID+4, 181016, 0, 1537, 5719, '0', 0, 0, -4928.40966796875, -981.78302001953125, 501.470123291015625, 2.599380254745483398, 0, 0, 0.963475227355957031, 0.267797440290451049, 120, 255, 1, 53262), -- Wreath (Area: The Commons - Difficulty: 0) CreateObject1 +(@OGUID+5, 181016, 0, 1537, 5719, '0', 0, 0, -4997.84912109375, -880.6900634765625, 501.659332275390625, 0.715584874153137207, 0, 0, 0.350207328796386718, 0.936672210693359375, 120, 255, 1, 53262), -- Wreath (Area: The Commons - Difficulty: 0) CreateObject1 +(@OGUID+6, 181016, 0, 1537, 0, '0', 0, 0, -5018.2275390625, -855.9774169921875, 501.659332275390625, 0.680676698684692382, 0, 0, 0.333806037902832031, 0.942641794681549072, 120, 255, 1, 53262), -- Wreath (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+7, 181016, 0, 1537, 0, '0', 0, 0, -5000.1611328125, -841.3087158203125, 501.659332275390625, 3.822272777557373046, 0, 0, -0.94264125823974609, 0.333807557821273803, 120, 255, 1, 53262), -- Wreath (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+8, 181016, 0, 1537, 0, '0', 0, 0, -5008.32275390625, -868.1883544921875, 501.659332275390625, 0.767943859100341796, 0, 0, 0.374606132507324218, 0.927184045314788818, 120, 255, 1, 53262), -- Wreath (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+9, 181016, 0, 1537, 0, '0', 0, 0, -4990.28857421875, -853.3427734375, 501.659332275390625, 3.839725255966186523, 0, 0, -0.93969249725341796, 0.34202045202255249, 120, 255, 1, 53262), -- Wreath (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+10, 181016, 0, 1537, 0, '0', 0, 0, -4980.03466796875, -865.87548828125, 501.659332275390625, 3.735006093978881835, 0, 0, -0.95630455017089843, 0.292372345924377441, 120, 255, 1, 53262), -- Wreath (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+11, 181016, 0, 1537, 5344, '0', 0, 0, -4609.134765625, -905.39166259765625, 501.067718505859375, 3.90954136848449707, 0, 0, -0.92718315124511718, 0.37460830807685852, 120, 255, 1, 53262), -- Wreath (Area: The Mystic Ward - Difficulty: 0) CreateObject1 +(@OGUID+12, 181016, 0, 1537, 5344, '0', 0, 0, -4602.83056640625, -912.78594970703125, 501.066070556640625, 3.78736734390258789, 0, 0, -0.94832324981689453, 0.317305892705917358, 120, 255, 1, 53262), -- Wreath (Area: The Mystic Ward - Difficulty: 0) CreateObject1 +(@OGUID+13, 181016, 0, 1537, 5344, '0', 0, 0, -4618.0244140625, -925.11968994140625, 501.0621337890625, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 120, 255, 1, 53262), -- Wreath (Area: The Mystic Ward - Difficulty: 0) CreateObject1 +(@OGUID+14, 181016, 0, 1537, 5344, '0', 0, 0, -4623.98583984375, -917.63336181640625, 501.06304931640625, 0.698131442070007324, 0, 0, 0.342020034790039062, 0.939692676067352294, 120, 255, 1, 53262), -- Wreath (Area: The Mystic Ward - Difficulty: 0) CreateObject1 +(@OGUID+15, 181017, 0, 1537, 1537, '0', 0, 0, -4804.95654296875, -1180.3507080078125, 510.45892333984375, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 53262), -- Hanging Streamer (Area: Ironforge - Difficulty: 0) CreateObject1 +(@OGUID+16, 181017, 0, 1537, 1537, '0', 0, 0, -4927.70654296875, -1279.470458984375, 509.795623779296875, 2.652894020080566406, 0, 0, 0.970294952392578125, 0.241925001144409179, 120, 255, 1, 53262), -- Hanging Streamer (Area: Ironforge - Difficulty: 0) CreateObject1 +(@OGUID+17, 181017, 0, 1537, 5343, '0', 0, 0, -4868.57470703125, -1144.732666015625, 510.406951904296875, 0.383971005678176879, 0, 0, 0.190808296203613281, 0.981627285480499267, 120, 255, 1, 53262), -- Hanging Streamer (Area: The Military Ward - Difficulty: 0) CreateObject1 +(@OGUID+18, 181017, 0, 1537, 5343, '0', 0, 0, -5041.65283203125, -1166.185791015625, 508.227386474609375, 0.314158439636230468, 0, 0, 0.156434059143066406, 0.987688362598419189, 120, 255, 1, 53262), -- Hanging Streamer (Area: The Military Ward - Difficulty: 0) CreateObject1 +(@OGUID+19, 181017, 0, 1537, 5343, '0', 0, 0, -4989.77783203125, -1117.27783203125, 508.185760498046875, 3.316144466400146484, 0, 0, -0.99619388580322265, 0.087165042757987976, 120, 255, 1, 53262), -- Hanging Streamer (Area: The Military Ward - Difficulty: 0) CreateObject1 +(@OGUID+20, 181017, 0, 1537, 5343, '0', 0, 0, -5030.98095703125, -1153.90283203125, 509.76019287109375, 5.009094715118408203, 0, 0, -0.59482288360595703, 0.80385679006576538, 120, 255, 1, 53262), -- Hanging Streamer (Area: The Military Ward - Difficulty: 0) CreateObject1 +(@OGUID+21, 181017, 0, 1537, 5343, '0', 0, 0, -5017.75, -1125.0382080078125, 509.957183837890625, 0.191985160112380981, 0, 0, 0.095845222473144531, 0.995396256446838378, 120, 255, 1, 53262), -- Hanging Streamer (Area: The Military Ward - Difficulty: 0) CreateObject1 +(@OGUID+22, 181017, 0, 1537, 5719, '0', 0, 0, -4974.47900390625, -1033.467041015625, 509.7349853515625, 2.775068521499633789, 0, 0, 0.983254432678222656, 0.182238012552261352, 120, 255, 1, 53262), -- Hanging Streamer (Area: The Commons - Difficulty: 0) CreateObject1 +(@OGUID+23, 181017, 0, 1537, 5719, '0', 0, 0, -4899.02783203125, -982.31427001953125, 510.77691650390625, 2.286378860473632812, 0, 0, 0.909960746765136718, 0.414694398641586303, 120, 255, 1, 53262), -- Hanging Streamer (Area: The Commons - Difficulty: 0) CreateObject1 +(@OGUID+24, 181017, 0, 1537, 5719, '0', 0, 0, -4880.09716796875, -957.7725830078125, 509.6275634765625, 1.937312245368957519, 0, 0, 0.824125289916992187, 0.566407561302185058, 120, 255, 1, 53262), -- Hanging Streamer (Area: The Commons - Difficulty: 0) CreateObject1 +(@OGUID+25, 181017, 0, 1537, 0, '0', 0, 0, -4849.923828125, -877.53643798828125, 506.388824462890625, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, 53262), -- Hanging Streamer (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+26, 181017, 0, 1537, 0, '0', 0, 0, -4840.26904296875, -859.96875, 506.08197021484375, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 120, 255, 1, 53262), -- Hanging Streamer (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+27, 181017, 0, 1537, 5719, '0', 0, 0, -4798.3662109375, -908.9757080078125, 503.249847412109375, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 53262), -- Hanging Streamer (Area: The Commons - Difficulty: 0) CreateObject1 +(@OGUID+28, 181017, 0, 1537, 5719, '0', 0, 0, -4765.7744140625, -913.38714599609375, 508.2344970703125, 1.32644820213317871, 0, 0, 0.615660667419433593, 0.788011372089385986, 120, 255, 1, 53262), -- Hanging Streamer (Area: The Commons - Difficulty: 0) CreateObject1 +(@OGUID+29, 181017, 0, 1537, 5719, '0', 0, 0, -4707.56591796875, -948.40972900390625, 509.871734619140625, 0.907570242881774902, 0, 0, 0.438370704650878906, 0.898794233798980712, 120, 255, 1, 53262), -- Hanging Streamer (Area: The Commons - Difficulty: 0) CreateObject1 +(@OGUID+30, 181017, 0, 1537, 5344, '0', 0, 0, -4591.765625, -999.46356201171875, 508.2066650390625, 3.43830275535583496, 0, 0, -0.98901557922363281, 0.147811368107795715, 120, 255, 1, 53262), -- Hanging Streamer (Area: The Mystic Ward - Difficulty: 0) CreateObject1 +(@OGUID+31, 181017, 0, 1537, 5344, '0', 0, 0, -4601.875, -1010.21527099609375, 509.9107666015625, 1.815141916275024414, 0, 0, 0.788010597229003906, 0.615661680698394775, 120, 255, 1, 53262), -- Hanging Streamer (Area: The Mystic Ward - Difficulty: 0) CreateObject1 +(@OGUID+32, 181017, 0, 1537, 5344, '0', 0, 0, -4730.88720703125, -1063.310791015625, 508.73834228515625, 3.665196180343627929, 0, 0, -0.96592521667480468, 0.258821308612823486, 120, 255, 1, 53262), -- Hanging Streamer (Area: The Mystic Ward - Difficulty: 0) CreateObject1 +(@OGUID+33, 181017, 0, 1537, 5344, '0', 0, 0, -4612.87841796875, -1093.2603759765625, 509.64056396484375, 3.054326534271240234, 0, 0, 0.999048233032226562, 0.043619260191917419, 120, 255, 1, 53262), -- Hanging Streamer (Area: The Mystic Ward - Difficulty: 0) CreateObject1 +(@OGUID+34, 181017, 0, 1537, 5344, '0', 0, 0, -4614.03662109375, -1114.4791259765625, 509.549957275390625, 3.333590030670166015, 0, 0, -0.99539566040039062, 0.095851235091686248, 120, 255, 1, 53262), -- Hanging Streamer (Area: The Mystic Ward - Difficulty: 0) CreateObject1 +(@OGUID+35, 181017, 0, 1537, 4679, '0', 0, 0, -4691.63525390625, -1183.8958740234375, 509.914825439453125, 5.550147056579589843, 0, 0, -0.358367919921875, 0.933580458164215087, 120, 255, 1, 53262), -- Hanging Streamer (Area: The Forlorn Cavern - Difficulty: 0) CreateObject1 +(@OGUID+36, 181017, 0, 1537, 5341, '0', 0, 0, -4732.765625, -1146.4896240234375, 507.5391845703125, 2.652894020080566406, 0, 0, 0.970294952392578125, 0.241925001144409179, 120, 255, 1, 53262), -- Hanging Streamer (Area: Hall of Explorers - Difficulty: 0) CreateObject1 +(@OGUID+37, 181017, 0, 1537, 5342, '0', 0, 0, -4847.69091796875, -1162.9617919921875, 508.74658203125, 0.837757468223571777, 0, 0, 0.406736373901367187, 0.913545548915863037, 120, 255, 1, 53262), -- Hanging Streamer (Area: The Great Forge - Difficulty: 0) CreateObject1 +(@OGUID+38, 181018, 0, 1537, 5719, '0', 0, 0, -4897.69091796875, -1002.0504150390625, 510.0543212890625, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 53262), -- Ribbon (Area: The Commons - Difficulty: 0) CreateObject1 +(@OGUID+39, 181018, 0, 1537, 5719, '0', 0, 0, -4888.8212890625, -994.73785400390625, 510.048828125, 2.321286916732788085, 0, 0, 0.917059898376464843, 0.398749500513076782, 120, 255, 1, 53262), -- Ribbon (Area: The Commons - Difficulty: 0) CreateObject1 +(@OGUID+40, 181018, 0, 1537, 5719, '0', 0, 0, -4879.8349609375, -987.32989501953125, 509.98291015625, 2.146752834320068359, 0, 0, 0.878816604614257812, 0.477159708738327026, 120, 255, 1, 53262), -- Ribbon (Area: The Commons - Difficulty: 0) CreateObject1 +(@OGUID+41, 181019, 0, 1537, 5719, '0', 0, 0, -4899.34814453125, -1004.4788818359375, 504.7578125, 5.602506637573242187, 0, 0, -0.33380699157714843, 0.942641437053680419, 120, 255, 1, 53262), -- Rose Vase (Area: The Commons - Difficulty: 0) CreateObject1 +(@OGUID+42, 181019, 0, 1537, 5719, '0', 0, 0, -4905.373046875, -979.254150390625, 503.518463134765625, 5.742135047912597656, 0, 0, -0.26723766326904296, 0.96363067626953125, 120, 255, 1, 53262), -- Rose Vase (Area: The Commons - Difficulty: 0) CreateObject1 +(@OGUID+43, 181019, 0, 1537, 5719, '0', 0, 0, -4895.28857421875, -1001.1298828125, 504.7578125, 3.263772249221801757, 0, 0, -0.99813461303710937, 0.061051756143569946, 120, 255, 1, 53262), -- Rose Vase (Area: The Commons - Difficulty: 0) CreateObject1 +(@OGUID+44, 181019, 0, 1537, 5719, '0', 0, 0, -4890.2255859375, -996.79949951171875, 504.7578125, 0.418878614902496337, 0, 0, 0.207911491394042968, 0.978147625923156738, 120, 255, 1, 53262), -- Rose Vase (Area: The Commons - Difficulty: 0) CreateObject1 +(@OGUID+45, 181019, 0, 1537, 5719, '0', 0, 0, -4886.38330078125, -993.6834716796875, 504.7578125, 2.321286916732788085, 0, 0, 0.917059898376464843, 0.398749500513076782, 120, 255, 1, 53262), -- Rose Vase (Area: The Commons - Difficulty: 0) CreateObject1 +(@OGUID+46, 181019, 0, 1537, 5719, '0', 0, 0, -4900.673828125, -975.40972900390625, 503.49066162109375, 2.70525527000427246, 0, 0, 0.97629547119140625, 0.216442063450813293, 120, 255, 1, 53262), -- Rose Vase (Area: The Commons - Difficulty: 0) CreateObject1 +(@OGUID+47, 181019, 0, 1537, 5719, '0', 0, 0, -4881.06103515625, -989.32257080078125, 504.7578125, 5.253442287445068359, 0, 0, -0.49242305755615234, 0.870355963706970214, 120, 255, 1, 53262), -- Rose Vase (Area: The Commons - Difficulty: 0) CreateObject1 +(@OGUID+48, 181019, 0, 1537, 5719, '0', 0, 0, -4877.421875, -986.307861328125, 504.7578125, 5.70722818374633789, 0, 0, -0.28401470184326171, 0.958819925785064697, 120, 255, 1, 53262), -- Rose Vase (Area: The Commons - Difficulty: 0) CreateObject1 +(@OGUID+49, 181019, 0, 1537, 0, '0', 0, 0, -4846.3212890625, -864.107666015625, 502.8443603515625, 5.480334281921386718, 0, 0, -0.39073085784912109, 0.920504987239837646, 120, 255, 1, 53262), -- Rose Vase (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+50, 181019, 0, 1537, 0, '0', 0, 0, -4837.50927734375, -865.4373779296875, 502.851348876953125, 0.855210542678833007, 0, 0, 0.414692878723144531, 0.909961462020874023, 120, 255, 1, 53262), -- Rose Vase (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+51, 181021, 0, 1537, 5719, '0', 0, 0, -4993.27783203125, -886.91668701171875, 524.600341796875, 0.680676698684692382, 0, 0, 0.333806037902832031, 0.942641794681549072, 120, 255, 1, 53262), -- Hanging, Door - Val (Area: The Commons - Difficulty: 0) CreateObject1 +(@OGUID+52, 181021, 0, 1537, 0, '0', 0, 0, -5003.3349609375, -874.71356201171875, 524.83770751953125, 0.680676698684692382, 0, 0, 0.333806037902832031, 0.942641794681549072, 120, 255, 1, 53262), -- Hanging, Door - Val (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+53, 181021, 0, 1537, 0, '0', 0, 0, -4974.6494140625, -871.54168701171875, 524.52850341796875, 3.839725255966186523, 0, 0, -0.93969249725341796, 0.34202045202255249, 120, 255, 1, 53262), -- Hanging, Door - Val (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+54, 181021, 0, 1537, 0, '0', 0, 0, -5013.38916015625, -862.51910400390625, 524.67938232421875, 0.698131442070007324, 0, 0, 0.342020034790039062, 0.939692676067352294, 120, 255, 1, 53262), -- Hanging, Door - Val (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+55, 181021, 0, 1537, 0, '0', 0, 0, -4984.7099609375, -859.3367919921875, 524.798828125, 3.822272777557373046, 0, 0, -0.94264125823974609, 0.333807557821273803, 120, 255, 1, 53262), -- Hanging, Door - Val (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+56, 181021, 0, 1537, 0, '0', 0, 0, -4994.7783203125, -847.123291015625, 524.5223388671875, 3.822272777557373046, 0, 0, -0.94264125823974609, 0.333807557821273803, 120, 255, 1, 53262), -- Hanging, Door - Val (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+57, 181021, 0, 1537, 5344, '0', 0, 0, -4634.705078125, -1025.5736083984375, 514.93280029296875, 1.675513744354248046, 0, 0, 0.743144035339355468, 0.669131457805633544, 120, 255, 1, 53262), -- Hanging, Door - Val (Area: The Mystic Ward - Difficulty: 0) CreateObject1 +(@OGUID+58, 181021, 0, 1537, 4679, '0', 0, 0, -4641.595703125, -1178.900634765625, 515.0255126953125, 4.223697185516357421, 0, 0, -0.85716724395751953, 0.515038192272186279, 120, 255, 1, 53262), -- Hanging, Door - Val (Area: The Forlorn Cavern - Difficulty: 0) CreateObject1 +(@OGUID+59, 181025, 0, 1537, 1537, '0', 0, 0, -4684.71630859375, -1205.30712890625, 510.450103759765625, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 120, 255, 1, 53262), -- Huge Ribbon (Area: Ironforge - Difficulty: 0) CreateObject1 +(@OGUID+60, 181025, 0, 1537, 1537, '0', 0, 0, -4672.89892578125, -992.93902587890625, 510.1920166015625, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 53262), -- Huge Ribbon (Area: Ironforge - Difficulty: 0) CreateObject1 +(@OGUID+61, 181025, 0, 1537, 1537, '0', 0, 0, -4971.14892578125, -937.86602783203125, 510.348785400390625, 5.532694816589355468, 0, 0, -0.3665008544921875, 0.93041771650314331, 120, 255, 1, 53262), -- Huge Ribbon (Area: Ironforge - Difficulty: 0) CreateObject1 +(@OGUID+62, 181025, 0, 1537, 1537, '0', 0, 0, -4700.93505859375, -958.9013671875, 510.295135498046875, 0.820303261280059814, 0, 0, 0.398748397827148437, 0.917060375213623046, 120, 255, 1, 53262), -- Huge Ribbon (Area: Ironforge - Difficulty: 0) CreateObject1 +(@OGUID+63, 181025, 0, 1537, 1537, '0', 0, 0, -5003.4814453125, -983.32867431640625, 510.498046875, 5.794494152069091796, 0, 0, -0.24192142486572265, 0.970295846462249755, 120, 255, 1, 53262), -- Huge Ribbon (Area: Ironforge - Difficulty: 0) CreateObject1 +(@OGUID+64, 181025, 0, 1537, 1537, '0', 0, 0, -4928.48681640625, -902.7635498046875, 510.451171875, 5.288348197937011718, 0, 0, -0.4771585464477539, 0.878817260265350341, 120, 255, 1, 53262), -- Huge Ribbon (Area: Ironforge - Difficulty: 0) CreateObject1 +(@OGUID+65, 181025, 0, 1537, 1537, '0', 0, 0, -4878.06005859375, -879.94696044921875, 510.241851806640625, 5.026549339294433593, 0, 0, -0.5877847671508789, 0.809017360210418701, 120, 255, 1, 53262), -- Huge Ribbon (Area: Ironforge - Difficulty: 0) CreateObject1 +(@OGUID+66, 181025, 0, 1537, 1537, '0', 0, 0, -4959.70703125, -1172.3468017578125, 509.829864501953125, 3.700104713439941406, 0, 0, -0.96126079559326171, 0.275640487670898437, 120, 255, 1, 53262), -- Huge Ribbon (Area: Ironforge - Difficulty: 0) CreateObject1 +(@OGUID+67, 181025, 0, 1537, 1537, '0', 0, 0, -4720.98291015625, -1235.19873046875, 510.422576904296875, 2.129300594329833984, 0, 0, 0.874619483947753906, 0.484810054302215576, 120, 255, 1, 53262), -- Huge Ribbon (Area: Ironforge - Difficulty: 0) CreateObject1 +(@OGUID+68, 181025, 0, 1537, 1537, '0', 0, 0, -4931.61474609375, -1206.3570556640625, 509.640350341796875, 3.961898565292358398, 0, 0, -0.91705989837646484, 0.398749500513076782, 120, 255, 1, 53262), -- Huge Ribbon (Area: Ironforge - Difficulty: 0) CreateObject1 +(@OGUID+69, 181060, 0, 1537, 5719, '0', 0, 0, -4888.35205078125, -1008.2703857421875, 506.957855224609375, 1.884953022003173828, 0, 0, 0.809016227722167968, 0.587786316871643066, 120, 255, 1, 53262), -- Lovely Candle (Area: The Commons - Difficulty: 0) CreateObject1 +(@OGUID+70, 181060, 0, 1537, 5719, '0', 0, 0, -4885.0947265625, -1005.57061767578125, 506.957855224609375, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 53262), -- Lovely Candle (Area: The Commons - Difficulty: 0) CreateObject1 +(@OGUID+71, 181060, 0, 1537, 5719, '0', 0, 0, -4877.7509765625, -999.52667236328125, 506.957855224609375, 3.22885894775390625, 0, 0, -0.99904823303222656, 0.043619260191917419, 120, 255, 1, 53262), -- Lovely Candle (Area: The Commons - Difficulty: 0) CreateObject1 +(@OGUID+72, 181060, 0, 1537, 5719, '0', 0, 0, -4875.5341796875, -997.69598388671875, 506.957855224609375, 5.811946868896484375, 0, 0, -0.2334451675415039, 0.972369968891143798, 120, 255, 1, 53262), -- Lovely Candle (Area: The Commons - Difficulty: 0) CreateObject1 +(@OGUID+73, 181060, 0, 1537, 0, '0', 0, 0, -4843.60791015625, -859.5867919921875, 502.78375244140625, 5.393068790435791015, 0, 0, -0.43051052093505859, 0.902585566043853759, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+74, 181060, 0, 1537, 0, '0', 0, 0, -4844.4921875, -874.7479248046875, 511.13970947265625, 1.989672422409057617, 0, 0, 0.838669776916503906, 0.544640243053436279, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+75, 181060, 0, 1537, 0, '0', 0, 0, -4841.9296875, -874.42425537109375, 511.13970947265625, 5.235987663269042968, 0, 0, -0.5, 0.866025388240814208, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+76, 181060, 0, 1537, 0, '0', 0, 0, -4843.251953125, -874.55352783203125, 511.13970947265625, 3.78736734390258789, 0, 0, -0.94832324981689453, 0.317305892705917358, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+77, 181060, 0, 1537, 0, '0', 0, 0, -4839.0927734375, -874.047119140625, 511.13970947265625, 2.268925428390502929, 0, 0, 0.906307220458984375, 0.422619491815567016, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+78, 181060, 0, 1537, 0, '0', 0, 0, -4837.7333984375, -873.98687744140625, 511.13970947265625, 3.595378875732421875, 0, 0, -0.97437000274658203, 0.224951311945915222, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+79, 181060, 0, 1537, 0, '0', 0, 0, -4840.7568359375, -874.3367919921875, 511.13970947265625, 2.967041015625, 0, 0, 0.996193885803222656, 0.087165042757987976, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+80, 181060, 0, 1537, 0, '0', 0, 0, -4837.337890625, -858.78009033203125, 502.78082275390625, 4.206246376037597656, 0, 0, -0.86162853240966796, 0.50753939151763916, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+81, 181060, 0, 1537, 0, '0', 0, 0, -4836.302734375, -873.739501953125, 511.13970947265625, 1.762782454490661621, 0, 0, 0.771624565124511718, 0.636078238487243652, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+82, 181060, 0, 1537, 0, '0', 0, 0, -4835.0693359375, -873.53497314453125, 511.13970947265625, 2.059488296508789062, 0, 0, 0.857167243957519531, 0.515038192272186279, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+83, 187575, 0, 1537, 5344, '0', 0, 0, -4630.103515625, -928.94500732421875, 506.122406005859375, 0.733038187026977539, 0, 0, 0.358367919921875, 0.933580458164215087, 120, 255, 1, 53262), -- Hanging, Square, Small - Val (Area: The Mystic Ward - Difficulty: 0) CreateObject1 +(@OGUID+84, 411551, 0, 1537, 1537, '0', 0, 0, -4921.88916015625, -980.6319580078125, 501.353179931640625, 2.268925428390502929, 0, 0, 0.906307220458984375, 0.422619491815567016, 120, 255, 1, 53262), -- Scenic Getaway Portal (Area: Ironforge - Difficulty: 0) CreateObject1 +(@OGUID+85, 416381, 0, 1537, 1537, '0', 0, 0, -4921.88916015625, -980.6319580078125, 501.465545654296875, 2.268925428390502929, 0, 0, 0.906307220458984375, 0.422619491815567016, 120, 255, 1, 53262); -- Portal Arch (Area: Ironforge - 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+85; +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); |