diff options
| -rw-r--r-- | sql/updates/world/master/2024_03_10_04_world.sql | 346 |
1 files changed, 346 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_03_10_04_world.sql b/sql/updates/world/master/2024_03_10_04_world.sql new file mode 100644 index 00000000000..9cc032d4e5f --- /dev/null +++ b/sql/updates/world/master/2024_03_10_04_world.sql @@ -0,0 +1,346 @@ +SET @CGUID := 9800012; +SET @OGUID := 9800561; +SET @EVENT := 8; + +-- Creature templates +UPDATE `creature_template` SET `faction`=2361, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048, `unit_flags3`=0 WHERE `entry`=215478; -- Fresh Corpse +UPDATE `creature_template` SET `faction`=2361, `BaseAttackTime`=2000, `unit_flags`=256, `unit_flags2`=2048 WHERE `entry`=215477; -- Lovely Reveler +UPDATE `creature_template` SET `VehicleId`=548 WHERE `entry`=37966; -- Undercity Love Boat + +DELETE FROM `creature_template_addon` WHERE `entry` IN (215478, 215477); +INSERT INTO `creature_template_addon` (`entry`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(215478, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '159474'), -- 215478 (Fresh Corpse) - Permanent Feign Death (NO Stun, Untrackable, Immune) +(215477, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '166556 429397'); -- 215477 (Lovely Reveler) - Cannibalize Loop, [DNT] Heart Visual Aura + +-- Models +UPDATE `creature_model_info` SET `VerifiedBuild`=53262 WHERE `DisplayID` IN (74854, 90593, 87409, 64310, 64308, 74856, 74858, 74857, 74859, 74837, 74834, 74835, 74833, 74838, 74839, 74853, 74855, 74852, 74822, 65411, 64888, 44094, 45952, 9807, 16009, 2611, 37692, 38381, 38376, 37959, 37958, 37834, 37833, 35161, 1566, 66644, 37023, 36615, 36172, 35570, 34075, 34073, 34074, 34064, 30500, 32658, 34055, 34054, 34053, 31290, 31314, 24719, 30163, 30075, 30073, 30072, 30071, 30069, 29507, 29506, 27294, 27260, 26451, 25624, 25902, 24169, 21746, 8848, 11466, 4732, 19596, 18875, 18876, 16112, 7102, 10747, 11375, 9904, 9906, 15869, 15865, 15781, 15783, 15780, 15784, 15782, 15606, 13807, 13856, 13855, 13854, 11756, 11694, 10590, 10581, 10580, 10576, 10572, 10187, 10130, 28213, 9353, 9273, 8849, 7994, 7995, 7632, 7599, 7597, 14370, 14369, 7118, 7117, 6837, 6065, 5845, 5449, 10732, 5346, 5206, 5235, 5576, 4987, 7449, 4381, 4379, 4378, 4150, 4149, 4123, 4120, 4118, 3974, 3977, 3978, 4111, 4110, 4109, 4108, 1130, 10923, 4064, 4063, 4062, 4061, 4060, 4059, 4058, 4057, 4053, 4052, 4054, 4050, 4020, 4009, 3948, 3020, 4005, 4010, 4004, 3883, 3880, 3882, 3879, 3876, 3863, 3859, 3860, 3861, 3862, 3864, 3854, 3853, 3019, 6228, 10699, 4056, 3130, 2998, 2811, 2651, 12955, 2665, 2669, 2621, 1201, 2623, 2676, 2624, 2618, 2626, 10723, 2615, 2656, 2643, 2616, 2627, 2628, 2672, 2617, 2649, 2632, 2614, 2658, 2620, 2642, 2670, 2633, 2635, 2613, 2661, 2630, 2625, 2639, 2659, 2648, 2668, 2664, 2671, 2634, 2663, 2667, 2612, 2650, 2640, 2673, 2619, 2657, 2644, 10733, 2646, 2637, 2675, 2652, 2622, 2654, 2653, 2666, 2636, 2629, 2660, 2674, 2647, 2662, 2638, 3942, 2655, 10197, 2177, 11911, 5751, 10563, 2610, 2810, 2641, 2645, 1585, 10731, 1680, 4011, 540, 346, 47211, 9020, 2468, 4055, 10619); +UPDATE `creature_model_info` SET `DisplayID_Other_Gender`=0, `VerifiedBuild`=53262 WHERE `DisplayID` IN (15863, 15877, 15875); + +UPDATE `creature_template_model` SET `VerifiedBuild`=53262 WHERE (`Idx`=0 AND `CreatureID` IN (44731,5736,5734,7297,5729,118628,30729,49750,4613,36225,4549,36224,4596,4564,34983,4583,2492,5657,5658,5732,47587,4615,4576,1548,5693,36273,11044,6522,5705,4593,50609,5652,5747,4551,2308,5190,29095,7395,49965,1553,5742,4610,4582,5663,4590,4598,36226,15891,5668,4577,215478,16096,5730,44737,11835,5675,5660,4614,118516,61753,2458,5669,26539,46483,6467,4572,44786,4569,15686,47382,11049,5674,5707,141684,4611,96368,5703,5654,30711,4775,5651,4556,51496,15564,215196,20725,8393,5735,2802,4575,5698,2934,52319,4617,6293,223,4554,10879,15682,5697,5706,37966,61366,2227,4595,5731,8721,5052,19178,6741,54244,18379,5704,39116,37964,52317,11067,4573,118625,8672,29139,5700,4601,4570,215477,43359,5738,13839,29728,4607,5665,5662,7087,4604,15676,4603,4566,20406,36217,5728,6395,4612,118627,15684,4580,44732,5653,46560,4616,7683,15675,4553,4559,4560,4561,53528,61905,16287,6566,5744,97766,11750,5655,44764,44766,2050,2459,10053,4600,5821,5701,5753,61369,1908,4586,4571,4606,23776,4592,118702,4550,4602,15683,5819,51384,53517,37543,34985,1768,2055,10181,4587,118623,4552,4568,4563,6033,4609,4578,4574,5661,4581,4076,16030,3150,356,1536,4591,5820,118624,50304,4599,23713,5670,61169,4558,4605,4567,36517,8390,4488,4555,61829,141678,7980,4565,5702,5664,5696,52587,62393,6411,4597,53591,4608,46559,5699,4589,4585,118511,10781,5624,4562,5754,62664,9566,44733,61889,5733,2799,11031,1498,5679,5656,4588,11048,23103,36213,37574,141540,44734,10136,5204,4594,5659,118629,52588,4557,8403)) OR (`Idx`=3 AND `CreatureID` IN (5736,15891,215478,118516,46483,44786,5735,215477,5738,13839,44732,118702,7980,44733)) OR (`Idx`=2 AND `CreatureID` IN (5736,49965,15891,215478,16096,118516,46483,44786,5735,61366,215477,5738,13839,44732,118702,7980,44733,61889)) OR (`Idx`=1 AND `CreatureID` IN (5736,49965,15891,215478,16096,118516,61753,46483,44786,5735,61366,19178,54244,37964,215477,43359,5738,13839,44732,118702,37543,16030,1536,7980,53591,46559,44733,61889,37574,44734)) OR (`Idx`=6 AND `CreatureID` IN (215478,215477)) OR (`Idx`=5 AND `CreatureID` IN (215478,215477)) OR (`Idx`=4 AND `CreatureID` IN (215478,215477)) OR (`Idx`=12 AND `CreatureID`=215477) OR (`Idx`=11 AND `CreatureID`=215477) OR (`Idx`=10 AND `CreatureID`=215477) OR (`Idx`=9 AND `CreatureID`=215477) OR (`Idx`=8 AND `CreatureID`=215477) OR (`Idx`=7 AND `CreatureID`=215477); + +-- Difficulties +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=215478 AND `DifficultyID`=0); -- Fresh Corpse +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=215477 AND `DifficultyID`=0); -- Lovely Reveler +UPDATE `creature_template_difficulty` SET `ContentTuningID`=401, `VerifiedBuild`=53262 WHERE (`Entry`=15564 AND `DifficultyID`=0); -- Elder Darkcore +UPDATE `creature_template_difficulty` SET `VerifiedBuild`=53262 WHERE (`DifficultyID`=0 AND `Entry` IN (141684,141678,141540,118702,118629,118628,118627,118625,118624,118623,118516,118511,97766,96368,62664,62393,61905,61889,61829,61753,61369,61366,61169,54244,53591,53528,53517,52588,52587,52319,52317,51496,51384,50609,50304,49965,49750,47587,47382,46560,46559,46483,44786,44766,44764,44737,44734,44733,44732,44731,43359,39116,37966,37964,37574,37543,36517,36273,36226,36225,36224,36217,36213,34985,34983,30729,30711,29728,29139,29095,26539,23776,23713,23103,20725,20406,19178,16287,16096,16030,15891,15686,15684,15683,15682,15676,15675,13839,11835,11750,11067,11049,11048,11044,11031,10879,10781,10181,10136,10053,9566,8721,8672,8403,8393,8390,7980,7683,7395,7297,7087,6741,6566,6522,6467,6411,6395,6293,6033,5821,5820,5819,5754,5753,5747,5744,5738,5736,5735,5734,5733,5732,5731,5730,5729,5728,5707,5706,5705,5704,5703,5702,5701,5700,5699,5698,5697,5696,5693,5679,5675,5674,5670,5669,5668,5665,5664,5663,5662,5661,5660,5659,5658,5657,5656,5655,5654,5653,5652,5651,5624,5204,5190,5052,4775,4617,4616,4615,4614,4613,4612,4611,4610,4609,4608,4607,4606,4605,4604,4603,4602,4601,4600,4599,4598,4597,4596,4595,4594,4593,4592,4591,4590,4589,4588,4587,4586,4585,4583,4582,4581,4580,4578,4577,4576,4575,4574,4573,4572,4571,4570,4569,4568,4567,4566,4565,4564,4563,4562,4561,4560,4559,4558,4557,4556,4555,4554,4553,4552,4551,4550,4549,4488,4076,3150,2934,2802,2799,2492,2459,2458,2308,2227,2055,2050,1908,1768,1553,1548,1536,1498,223)); + +-- Gameobject templates +UPDATE `gameobject_template` SET `VerifiedBuild`=53262 WHERE `entry` IN (36126, 58627, 113755, 36113, 36079, 36127, 34012, 204331, 36094, 36092, 244852, 58596, 58605, 180885, 177884, 58611, 58626, 113572, 204333, 180760, 58616, 58601, 58606, 180778, 113753, 33999, 58614, 170355, 58620, 98347, 36105, 36102, 208841, 77813, 113576, 36093, 58629, 2045, 58609, 37097, 180666, 187290, 58607, 208876, 184503, 208828, 40303, 195142, 33998, 58600, 58610, 58623, 98354, 98350, 36070, 58603, 267750, 204329, 175749, 36098, 58597, 208842, 52175, 170354, 204330, 3662, 113570, 204332, 113574, 113571, 36398, 58621, 58622, 113575, 36086, 98343, 267745, 58615, 153695, 180768, 58619, 267751, 267747, 101850, 113568, 36080, 36118, 36073, 175659, 113754, 20651, 58613, 58612, 244854, 58599, 36096, 36071, 52176, 101851, 176594, 3705, 98351, 58602, 212205, 20656, 20650, 293763, 246683, 36078, 98348, 58618, 36077, 20657, 20652, 293758, 36085, 36095, 36083, 20649, 20655, 202901, 208816, 36072, 204334, 113577, 180776, 58604, 98349, 36090, 267746, 103600, 36397, 34013, 113569, 190704, 177064, 36082, 208839, 202900, 58625, 180775, 177044, 36091, 20654, 20653, 202899, 175754, 207324, 208840, 58617, 208874, 205056, 180663, 58624, 113756, 58598, 58608, 113752, 136101, 267748, 293689); + +UPDATE `gameobject_template_addon` SET `WorldEffectID`=8830 WHERE `entry`=207324; -- Warchief's Command Board +UPDATE `gameobject_template_addon` SET `WorldEffectID`=16227 WHERE `entry`=190704; -- Barbershop Chair + +-- Old creature spawns +DELETE FROM `creature` WHERE `guid` BETWEEN 3000055 AND 3000060; +DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 3000055 AND 3000060; + +-- Creature spawns +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+5; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `VerifiedBuild`) VALUES +(@CGUID+0, 37964, 0, 1497, 0, '0', 0, 0, 0, 0, 1485.3316650390625, 348.76214599609375, -64.6302032470703125, 0.837758064270019531, 120, 0, 0, 1693785, 63100, 0, NULL, NULL, NULL, NULL, 53262), -- [DND] Love Boat Summoner 02 (Area: 0 - Difficulty: 0) CreateObject1 +(@CGUID+1, 40438, 0, 14046, 0, '0', 0, 0, 0, 0, 1637.60595703125, 239.5381927490234375, -43.0193977355957031, 3.106686115264892578, 120, 0, 0, 112919, 0, 0, NULL, NULL, NULL, NULL, 53262), -- Steamwheedle Shyster (Area: 0 - Difficulty: 0) CreateObject1 +(@CGUID+2, 215196, 0, 85, 153, '0', 0, 0, 0, 0, 1824.795166015625, 260.94964599609375, 59.80034637451171875, 3.897258281707763671, 120, 0, 0, 112919, 0, 0, NULL, NULL, NULL, NULL, 53262), -- Aurora Vabsley (Area: Ruins of Lordaeron - Difficulty: 0) CreateObject1 (Auras: 427424 - [DNT] Mirror Image) +(@CGUID+3, 215477, 0, 85, 153, '0', 0, 0, 0, 0, 1829.4166259765625, 218.4652862548828125, 60.73097610473632812, 0.705949664115905761, 120, 0, 0, 112919, 0, 0, NULL, NULL, NULL, NULL, 53262), -- Lovely Reveler (Area: Ruins of Lordaeron - Difficulty: 0) CreateObject1 (Auras: 166556 - Cannibalize Loop, 429397 - [DNT] Heart Visual Aura) +(@CGUID+4, 215477, 0, 85, 153, '0', 0, 0, 0, 0, 1831.0816650390625, 219.670135498046875, 60.61642837524414062, 3.870104551315307617, 120, 0, 0, 112919, 0, 0, NULL, NULL, NULL, NULL, 53262), -- Lovely Reveler (Area: Ruins of Lordaeron - Difficulty: 0) CreateObject1 (Auras: 166556 - Cannibalize Loop, 429397 - [DNT] Heart Visual Aura) +(@CGUID+5, 215478, 0, 85, 153, '0', 0, 0, 0, 0, 1830.109375, 219.1788177490234375, 60.6906585693359375, 5.477125167846679687, 120, 0, 0, 112919, 0, 0, NULL, NULL, NULL, NULL, 53262); -- Fresh Corpse (Area: Ruins of Lordaeron - Difficulty: 0) CreateObject1 (Auras: 159474 - Permanent Feign Death (NO Stun, Untrackable; Immune)) + +-- Old gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN 3001145 AND 3001258; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 3001145 AND 3001258; + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+139; +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, 85, 153, '0', 0, 0, 1836.5728759765625, 252.986114501953125, 59.83522415161132812, 2.844921350479125976, 0, 0, 0.989018440246582031, 0.147792220115661621, 120, 255, 1, 53262), -- Crate (Area: Ruins of Lordaeron - Difficulty: 0) CreateObject1 +(@OGUID+1, 181015, 0, 85, 153, '0', 0, 0, 1837.013916015625, 251.0381927490234375, 59.93408966064453125, 3.428702831268310546, 0, 0, -0.98971366882324218, 0.143062442541122436, 120, 255, 1, 53262), -- Crate (Area: Ruins of Lordaeron - Difficulty: 0) CreateObject1 +(@OGUID+2, 181015, 0, 85, 153, '0', 0, 0, 1838.4114990234375, 252.2395782470703125, 59.89736557006835937, 3.428702831268310546, 0, 0, -0.98971366882324218, 0.143062442541122436, 120, 255, 1, 53262), -- Crate (Area: Ruins of Lordaeron - Difficulty: 0) CreateObject1 +(@OGUID+3, 181015, 0, 85, 153, '0', 0, 0, 1825.4913330078125, 268.625, 60.19530487060546875, 4.016275405883789062, 0, 0, -0.90588092803955078, 0.423532485961914062, 120, 255, 1, 53262), -- Crate (Area: Ruins of Lordaeron - Difficulty: 0) CreateObject1 +(@OGUID+4, 181015, 0, 85, 153, '0', 0, 0, 1827.4461669921875, 267.439239501953125, 60.07513427734375, 4.016275405883789062, 0, 0, -0.90588092803955078, 0.423532485961914062, 120, 255, 1, 53262), -- Crate (Area: Ruins of Lordaeron - Difficulty: 0) CreateObject1 +(@OGUID+5, 181015, 0, 1497, 0, '0', 0, 0, 1595.8428955078125, 240.163055419921875, -52.1429328918457031, 0.890116631984710693, 0, 0, 0.430510520935058593, 0.902585566043853759, 120, 255, 1, 53262), -- Crate (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+6, 181016, 0, 14046, 14046, '0', 0, 0, 2056.0556640625, 316.51214599609375, 54.15087127685546875, 3.78736734390258789, 0, 0, -0.94832324981689453, 0.317305892705917358, 120, 255, 1, 53262), -- Wreath (Area: Tirisfal Glades - Difficulty: 0) CreateObject1 +(@OGUID+7, 181016, 0, 14046, 14046, '0', 0, 0, 2063.98779296875, 340.98785400390625, 82.36017608642578125, 0.418878614902496337, 0, 0, 0.207911491394042968, 0.978147625923156738, 120, 255, 1, 53262), -- Wreath (Area: Tirisfal Glades - Difficulty: 0) CreateObject1 +(@OGUID+8, 181016, 0, 14046, 14046, '0', 0, 0, 2048.75, 289.079864501953125, 56.6565704345703125, 3.333590030670166015, 0, 0, -0.99539566040039062, 0.095851235091686248, 120, 255, 1, 53262), -- Wreath (Area: Tirisfal Glades - Difficulty: 0) CreateObject1 +(@OGUID+9, 181016, 0, 14046, 14046, '0', 0, 0, 2047.138427734375, 280.67059326171875, 56.42036819458007812, 2.775068521499633789, 0, 0, 0.983254432678222656, 0.182238012552261352, 120, 255, 1, 53262), -- Wreath (Area: Tirisfal Glades - Difficulty: 0) CreateObject1 +(@OGUID+10, 181016, 0, 14046, 14046, '0', 0, 0, 2094.260498046875, 317.633697509765625, 54.18476486206054687, 0.541050612926483154, 0, 0, 0.267237663269042968, 0.96363067626953125, 120, 255, 1, 53262), -- Wreath (Area: Tirisfal Glades - Difficulty: 0) CreateObject1 +(@OGUID+11, 181016, 0, 14046, 14046, '0', 0, 0, 2084.211669921875, 282.063232421875, 57.2977447509765625, 5.794494152069091796, 0, 0, -0.24192142486572265, 0.970295846462249755, 120, 255, 1, 53262), -- Wreath (Area: Tirisfal Glades - Difficulty: 0) CreateObject1 +(@OGUID+12, 181016, 0, 14046, 14046, '0', 0, 0, 2090.697998046875, 329.39410400390625, 54.62982177734375, 6.213373661041259765, 0, 0, -0.03489875793457031, 0.999390840530395507, 120, 255, 1, 53262), -- Wreath (Area: Tirisfal Glades - Difficulty: 0) CreateObject1 +(@OGUID+13, 181016, 0, 14046, 14046, '0', 0, 0, 2082.238037109375, 273.511932373046875, 56.91861343383789062, 6.161012649536132812, 0, 0, -0.06104850769042968, 0.998134791851043701, 120, 255, 1, 53262), -- Wreath (Area: Tirisfal Glades - Difficulty: 0) CreateObject1 +(@OGUID+14, 181016, 0, 85, 153, '0', 0, 0, 1829.0867919921875, 253.4809112548828125, 59.60590362548828125, 3.826357841491699218, 0, 0, -0.94195747375488281, 0.335732251405715942, 120, 255, 1, 53262), -- Wreath (Area: Ruins of Lordaeron - Difficulty: 0) CreateObject1 +(@OGUID+15, 181016, 0, 1497, 0, '0', 0, 0, 1589.828857421875, 245.835418701171875, 60.15068817138671875, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 120, 255, 1, 53262), -- Wreath (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+16, 181016, 0, 1497, 0, '0', 0, 0, 1589.5499267578125, 234.288330078125, 60.15068817138671875, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 120, 255, 1, 53262), -- Wreath (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+17, 181016, 0, 1497, 0, '0', 0, 0, 1761.9300537109375, 64.971099853515625, -45.2478981018066406, 5.916667938232421875, 0, 0, -0.18223476409912109, 0.98325502872467041, 120, 255, 1, 53262), -- Wreath (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+18, 181016, 0, 1497, 0, '0', 0, 0, 1769.0699462890625, 72.61750030517578125, -45.2478981018066406, 5.078907966613769531, 0, 0, -0.56640625, 0.824126183986663818, 120, 255, 1, 53262), -- Wreath (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+19, 181017, 0, 14046, 14046, '0', 0, 0, 2072.677490234375, 279.202728271484375, 65.41193389892578125, 6.09120035171508789, 0, 0, -0.09584522247314453, 0.995396256446838378, 120, 255, 1, 53262), -- Hanging Streamer (Area: Tirisfal Glades - Difficulty: 0) CreateObject1 +(@OGUID+20, 181017, 0, 14046, 14046, '0', 0, 0, 2068.6875, 315.526031494140625, 62.07224655151367187, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 120, 255, 1, 53262), -- Hanging Streamer (Area: Tirisfal Glades - Difficulty: 0) CreateObject1 +(@OGUID+21, 181017, 0, 14046, 14046, '0', 0, 0, 2063.374267578125, 269.648529052734375, 97.77622222900390625, 1.413715124130249023, 0, 0, 0.649447441101074218, 0.760406434535980224, 120, 255, 1, 53262), -- Hanging Streamer (Area: Tirisfal Glades - Difficulty: 0) CreateObject1 +(@OGUID+22, 181017, 0, 14046, 14046, '0', 0, 0, 2067.807373046875, 340.192718505859375, 89.05030059814453125, 1.937312245368957519, 0, 0, 0.824125289916992187, 0.566407561302185058, 120, 255, 1, 53262), -- Hanging Streamer (Area: Tirisfal Glades - Difficulty: 0) CreateObject1 +(@OGUID+23, 181017, 0, 14046, 14046, '0', 0, 0, 2058.600341796875, 282.822265625, 65.5201568603515625, 2.967041015625, 0, 0, 0.996193885803222656, 0.087165042757987976, 120, 255, 1, 53262), -- Hanging Streamer (Area: Tirisfal Glades - Difficulty: 0) CreateObject1 +(@OGUID+24, 181017, 0, 14046, 14046, '0', 0, 0, 2060.613525390625, 255.76641845703125, 75.142181396484375, 4.433136463165283203, 0, 0, -0.79863548278808593, 0.60181504487991333, 120, 255, 1, 53262), -- Hanging Streamer (Area: Tirisfal Glades - Difficulty: 0) CreateObject1 +(@OGUID+25, 181017, 0, 14046, 14046, '0', 0, 0, 2060.982177734375, 257.691650390625, 103.6666030883789062, 4.502951622009277343, 0, 0, -0.7771453857421875, 0.629321098327636718, 120, 255, 1, 53262), -- Hanging Streamer (Area: Tirisfal Glades - Difficulty: 0) CreateObject1 +(@OGUID+26, 181017, 0, 14046, 14046, '0', 0, 0, 2082.529541015625, 320.005218505859375, 61.95344924926757812, 0.366517573595046997, 0, 0, 0.182234764099121093, 0.98325502872467041, 120, 255, 1, 53262), -- Hanging Streamer (Area: Tirisfal Glades - Difficulty: 0) CreateObject1 +(@OGUID+27, 181018, 0, 1497, 0, '0', 0, 0, 1605.4427490234375, 249.8697967529296875, -47.7426528930664062, 0.802850961685180664, 0, 0, 0.390730857849121093, 0.920504987239837646, 120, 255, 1, 53262), -- Ribbon (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+28, 181018, 0, 1497, 0, '0', 0, 0, 1605.1632080078125, 230.5572967529296875, -47.8257369995117187, 5.532694816589355468, 0, 0, -0.3665008544921875, 0.93041771650314331, 120, 255, 1, 53262), -- Ribbon (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+29, 181018, 0, 1497, 0, '0', 0, 0, 1586.0728759765625, 250.11285400390625, -47.698760986328125, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 120, 255, 1, 53262), -- Ribbon (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+30, 181018, 0, 1497, 0, '0', 0, 0, 1585.8629150390625, 230.6458282470703125, -47.8968849182128906, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 120, 255, 1, 53262), -- Ribbon (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+31, 181019, 0, 14046, 0, '0', 0, 0, 1690.7396240234375, 247.125, -41.2577095031738281, 1.099556446075439453, 0, 0, 0.522498130798339843, 0.852640450000762939, 120, 255, 1, 53262), -- Rose Vase (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+32, 181019, 0, 14046, 0, '0', 0, 0, 1714.6978759765625, 246.5416717529296875, -41.2577400207519531, 2.181660413742065429, 0, 0, 0.887010574340820312, 0.461749136447906494, 120, 255, 1, 53262), -- Rose Vase (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+33, 181019, 0, 14046, 0, '0', 0, 0, 1682.9410400390625, 232.4444427490234375, -41.25701904296875, 2.164205789566040039, 0, 0, 0.882946968078613281, 0.469472706317901611, 120, 255, 1, 53262), -- Rose Vase (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+34, 181019, 0, 14046, 0, '0', 0, 0, 1708.935791015625, 246.7256927490234375, -41.2577285766601562, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, 53262), -- Rose Vase (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+35, 181019, 0, 14046, 0, '0', 0, 0, 1702.40625, 232.1041717529296875, -41.2568702697753906, 3.159062385559082031, 0, 0, -0.99996185302734375, 0.008734640665352344, 120, 255, 1, 53262), -- Rose Vase (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+36, 181019, 0, 14046, 0, '0', 0, 0, 1715.1348876953125, 232.0016021728515625, -41.2660484313964843, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 53262), -- Rose Vase (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+37, 181019, 0, 14046, 0, '0', 0, 0, 1700.8992919921875, 237.7465362548828125, -40.1240653991699218, 2.129300594329833984, 0, 0, 0.874619483947753906, 0.484810054302215576, 120, 255, 1, 53262), -- Rose Vase (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+38, 181019, 0, 14046, 0, '0', 0, 0, 1702.2708740234375, 246.8350677490234375, -41.2572784423828125, 0.226892471313476562, 0, 0, 0.113203048706054687, 0.993571877479553222, 120, 255, 1, 53262), -- Rose Vase (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+39, 181019, 0, 14046, 0, '0', 0, 0, 1700.9322509765625, 241.1961822509765625, -40.1241340637207031, 1.308995485305786132, 0, 0, 0.608760833740234375, 0.793353796005249023, 120, 255, 1, 53262), -- Rose Vase (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+40, 181019, 0, 14046, 0, '0', 0, 0, 1690.9288330078125, 232.203125, -41.2571563720703125, 2.44346022605895996, 0, 0, 0.939692497253417968, 0.34202045202255249, 120, 255, 1, 53262), -- Rose Vase (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+41, 181019, 0, 14046, 0, '0', 0, 0, 1682.744873046875, 246.8034210205078125, -41.2576675415039062, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 53262), -- Rose Vase (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+42, 181019, 0, 14046, 0, '0', 0, 0, 1708.2965087890625, 231.7843780517578125, -41.2570877075195312, 1.675513744354248046, 0, 0, 0.743144035339355468, 0.669131457805633544, 120, 255, 1, 53262), -- Rose Vase (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+43, 181019, 0, 1497, 0, '0', 0, 0, 1605.6944580078125, 276.23785400390625, -54.2526283264160156, 6.003933906555175781, 0, 0, -0.13917255401611328, 0.990268170833587646, 120, 255, 1, 53262), -- Rose Vase (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+44, 181019, 0, 1497, 0, '0', 0, 0, 1590.3524169921875, 206.828125, -54.266571044921875, 2.914689540863037109, 0, 0, 0.993571281433105468, 0.113208353519439697, 120, 255, 1, 53262), -- Rose Vase (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+45, 181019, 0, 1497, 0, '0', 0, 0, 1586.315185546875, 277.427825927734375, -54.2526359558105468, 1.134462952613830566, 0, 0, 0.537299156188964843, 0.843391716480255126, 120, 255, 1, 53262), -- Rose Vase (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+46, 181025, 0, 14046, 14046, '0', 0, 0, 2293.401123046875, 297.498260498046875, 37.52321624755859375, 3.036838293075561523, 0, 0, 0.998628616333007812, 0.052353221923112869, 120, 255, 1, 53262), -- Huge Ribbon (Area: Tirisfal Glades - Difficulty: 0) CreateObject1 +(@OGUID+47, 181025, 0, 14046, 14046, '0', 0, 0, 1783.2021484375, 237.7364959716796875, -50.62408447265625, 3.159062385559082031, 0, 0, -0.99996185302734375, 0.008734640665352344, 120, 255, 1, 53262), -- Huge Ribbon (Area: Tirisfal Glades - Difficulty: 0) CreateObject1 +(@OGUID+48, 181025, 0, 14046, 14046, '0', 0, 0, 1702.953125, 531.1961669921875, -3.7574169635772705, 3.874631166458129882, 0, 0, -0.93358039855957031, 0.358368009328842163, 120, 255, 1, 53262), -- Huge Ribbon (Area: Tirisfal Glades - Difficulty: 0) CreateObject1 +(@OGUID+49, 181025, 0, 14046, 14046, '0', 0, 0, 1719.1656494140625, 239.08837890625, -24.510965347290039, 0, 0, 0, 0, 1, 120, 255, 1, 53262), -- Huge Ribbon (Area: Tirisfal Glades - Difficulty: 0) CreateObject1 +(@OGUID+50, 181025, 0, 14046, 14046, '0', 0, 0, 2286.732666015625, 266.9913330078125, 37.52883148193359375, 2.932138919830322265, 0, 0, 0.994521141052246093, 0.104535527527332305, 120, 255, 1, 53262), -- Huge Ribbon (Area: Tirisfal Glades - Difficulty: 0) CreateObject1 +(@OGUID+51, 181025, 0, 14046, 14046, '0', 0, 0, 1696.1666259765625, 524.71875, -3.46358394622802734, 0.767943859100341796, 0, 0, 0.374606132507324218, 0.927184045314788818, 120, 255, 1, 53262), -- Huge Ribbon (Area: Tirisfal Glades - Difficulty: 0) CreateObject1 +(@OGUID+52, 181025, 0, 85, 153, '0', 0, 0, 1594.3900146484375, 52.9281005859375, -50.7142982482910156, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 53262), -- Huge Ribbon (Area: Ruins of Lordaeron - Difficulty: 0) CreateObject1 +(@OGUID+53, 181025, 0, 14046, 0, '0', 0, 0, 1408.340087890625, 241.41070556640625, -50.6635971069335937, 0.017452461645007133, 0, 0, 0.008726119995117187, 0.999961912631988525, 120, 255, 1, 53262), -- Huge Ribbon (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+54, 181027, 0, 14046, 0, '0', 0, 0, 1757.701416015625, 242.39410400390625, -64.4785614013671875, 4.241150379180908203, 0, 0, -0.85264015197753906, 0.522498607635498046, 120, 255, 1, 53262), -- Floating Wreath (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+55, 181027, 0, 14046, 0, '0', 0, 0, 1751.6961669921875, 277.83160400390625, -64.4785614013671875, 0.802850961685180664, 0, 0, 0.390730857849121093, 0.920504987239837646, 120, 255, 1, 53262), -- Floating Wreath (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+56, 181027, 0, 14046, 0, '0', 0, 0, 1743.01220703125, 196.17535400390625, -64.4785614013671875, 3.717553615570068359, 0, 0, -0.95881938934326171, 0.284016460180282592, 120, 255, 1, 53262), -- Floating Wreath (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+57, 181027, 0, 14046, 0, '0', 0, 0, 1735.892333984375, 157.373260498046875, -64.4785614013671875, 4.59021615982055664, 0, 0, -0.74895572662353515, 0.662620067596435546, 120, 255, 1, 53262), -- Floating Wreath (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+58, 181027, 0, 14046, 0, '0', 0, 0, 1720.8299560546875, 336.019012451171875, -67.5817031860351562, 0.645771682262420654, 0, 0, 0.317304611206054687, 0.948323667049407958, 120, 255, 1, 53262), -- Floating Wreath (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+59, 181027, 0, 1497, 0, '0', 0, 0, 1609.729248046875, 208.7392120361328125, -64.4785614013671875, 4.991643905639648437, 0, 0, -0.60181427001953125, 0.798636078834533691, 120, 255, 1, 53262), -- Floating Wreath (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+60, 181027, 0, 1497, 0, '0', 0, 0, 1581.261962890625, 208.7772979736328125, -64.4785614013671875, 5.619962215423583984, 0, 0, -0.32556724548339843, 0.945518851280212402, 120, 255, 1, 53262), -- Floating Wreath (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+61, 181027, 0, 1497, 0, '0', 0, 0, 1582.8155517578125, 270.91943359375, -64.4785614013671875, 1.186823248863220214, 0, 0, 0.559192657470703125, 0.829037725925445556, 120, 255, 1, 53262), -- Floating Wreath (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+62, 181027, 0, 1497, 0, '0', 0, 0, 1611.554931640625, 269.952301025390625, -64.4785614013671875, 3.752462387084960937, 0, 0, -0.95371627807617187, 0.300707906484603881, 120, 255, 1, 53262), -- Floating Wreath (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+63, 181027, 0, 1497, 4617, '0', 0, 0, 1634.06005859375, 90.87000274658203125, -64.4785614013671875, 2.234017848968505859, 0, 0, 0.898793220520019531, 0.438372820615768432, 120, 255, 1, 53262), -- Floating Wreath (Area: Elevator - Difficulty: 0) CreateObject1 +(@OGUID+64, 181027, 0, 1497, 4617, '0', 0, 0, 1594.96533203125, 77.49826812744140625, -64.4785614013671875, 6.108653545379638671, 0, 0, -0.08715534210205078, 0.996194720268249511, 120, 255, 1, 53262), -- Floating Wreath (Area: Elevator - Difficulty: 0) CreateObject1 +(@OGUID+65, 181027, 0, 1497, 4617, '0', 0, 0, 1667.69970703125, 107.447906494140625, -64.4785614013671875, 5.026549339294433593, 0, 0, -0.5877847671508789, 0.809017360210418701, 120, 255, 1, 53262), -- Floating Wreath (Area: Elevator - Difficulty: 0) CreateObject1 +(@OGUID+66, 181027, 0, 1497, 4617, '0', 0, 0, 1556.19970703125, 83.13541412353515625, -64.4785614013671875, 3.769911527633666992, 0, 0, -0.95105648040771484, 0.309017121791839599, 120, 255, 1, 53262), -- Floating Wreath (Area: Elevator - Difficulty: 0) CreateObject1 +(@OGUID+67, 181027, 0, 1497, 0, '0', 0, 0, 1596.826416015625, 392.0069580078125, -64.4785614013671875, 5.93412017822265625, 0, 0, -0.17364788055419921, 0.984807789325714111, 120, 255, 1, 53262), -- Floating Wreath (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+68, 181027, 0, 1497, 0, '0', 0, 0, 1554.5572509765625, 396.56597900390625, -64.4785614013671875, 4.223697185516357421, 0, 0, -0.85716724395751953, 0.515038192272186279, 120, 255, 1, 53262), -- Floating Wreath (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+69, 181027, 0, 1497, 0, '0', 0, 0, 1636.529541015625, 389.251739501953125, -64.4785614013671875, 0.383971005678176879, 0, 0, 0.190808296203613281, 0.981627285480499267, 120, 255, 1, 53262), -- Floating Wreath (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+70, 181027, 0, 1497, 0, '0', 0, 0, 1686.798583984375, 364.626739501953125, -64.4785614013671875, 0.907570242881774902, 0, 0, 0.438370704650878906, 0.898794233798980712, 120, 255, 1, 53262), -- Floating Wreath (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+71, 181027, 0, 1497, 0, '0', 0, 0, 1704.9322509765625, 125.1614608764648437, -67.8613357543945312, 4.188792228698730468, 0, 0, -0.86602497100830078, 0.50000077486038208, 120, 255, 1, 53262), -- Floating Wreath (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+72, 181027, 0, 1497, 0, '0', 0, 0, 1481.61328125, 127.7064132690429687, -64.4785614013671875, 1.308995485305786132, 0, 0, 0.608760833740234375, 0.793353796005249023, 120, 255, 1, 53262), -- Floating Wreath (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+73, 181027, 0, 1497, 0, '0', 0, 0, 1452.7066650390625, 187.1041717529296875, -64.4785614013671875, 4.660029888153076171, 0, 0, -0.72537422180175781, 0.688354730606079101, 120, 255, 1, 53262), -- Floating Wreath (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+74, 181027, 0, 1497, 0, '0', 0, 0, 1453.279541015625, 159.7118072509765625, -64.4785614013671875, 3.857182979583740234, 0, 0, -0.93667125701904296, 0.350209832191467285, 120, 255, 1, 53262), -- Floating Wreath (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+75, 181027, 0, 1497, 0, '0', 0, 0, 1442.8680419921875, 242.888885498046875, -64.4785614013671875, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 120, 255, 1, 53262), -- Floating Wreath (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+76, 181027, 0, 1497, 0, '0', 0, 0, 1452.1944580078125, 294.993072509765625, -64.4785614013671875, 3.996806621551513671, 0, 0, -0.90996074676513671, 0.414694398641586303, 120, 255, 1, 53262), -- Floating Wreath (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+77, 181027, 0, 1497, 0, '0', 0, 0, 1455.0382080078125, 322.291656494140625, -64.4785614013671875, 1.291541695594787597, 0, 0, 0.60181427001953125, 0.798636078834533691, 120, 255, 1, 53262), -- Floating Wreath (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+78, 181027, 0, 1497, 0, '0', 0, 0, 1480.517333984375, 358.368072509765625, -64.4785614013671875, 1.48352813720703125, 0, 0, 0.675589561462402343, 0.737277925014495849, 120, 255, 1, 53262), -- Floating Wreath (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+79, 181027, 0, 1497, 0, '0', 0, 0, 1515.90625, 382.6632080078125, -64.4785614013671875, 0.296705186367034912, 0, 0, 0.147809028625488281, 0.989015936851501464, 120, 255, 1, 53262), -- Floating Wreath (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+80, 181027, 0, 1497, 0, '0', 0, 0, 1513.7083740234375, 100.5572891235351562, -64.4785614013671875, 0.453785061836242675, 0, 0, 0.224950790405273437, 0.974370121955871582, 120, 255, 1, 53262), -- Floating Wreath (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+81, 181060, 0, 85, 153, '0', 0, 0, 1827.87158203125, 216.46875, 60.4936065673828125, 0, 0, 0, 0, 1, 120, 255, 1, 53262), -- Lovely Candle (Area: Ruins of Lordaeron - Difficulty: 0) CreateObject1 +(@OGUID+82, 181060, 0, 85, 153, '0', 0, 0, 1832.8819580078125, 216.4635467529296875, 60.28544235229492187, 0, 0, 0, 0, 1, 120, 255, 1, 53262), -- Lovely Candle (Area: Ruins of Lordaeron - Difficulty: 0) CreateObject1 +(@OGUID+83, 181060, 0, 85, 153, '0', 0, 0, 1827.6910400390625, 221.34722900390625, 60.64540481567382812, 0, 0, 0, 0, 1, 120, 255, 1, 53262), -- Lovely Candle (Area: Ruins of Lordaeron - Difficulty: 0) CreateObject1 +(@OGUID+84, 181060, 0, 85, 153, '0', 0, 0, 1832.5711669921875, 221.4427032470703125, 60.46759033203125, 0, 0, 0, 0, 1, 120, 255, 1, 53262), -- Lovely Candle (Area: Ruins of Lordaeron - Difficulty: 0) CreateObject1 +(@OGUID+85, 181060, 0, 14046, 0, '0', 0, 0, 1636.1007080078125, 244.3541717529296875, -34.8122482299804687, 3.385940074920654296, 0, 0, -0.99254608154296875, 0.121869951486587524, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+86, 181060, 0, 14046, 0, '0', 0, 0, 1636.0260009765625, 235.576385498046875, -34.8121871948242187, 2.827429771423339843, 0, 0, 0.987688064575195312, 0.156436234712600708, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+87, 181060, 0, 14046, 0, '0', 0, 0, 1636.8072509765625, 230.7916717529296875, -40.6942138671875, 5.986480236053466796, 0, 0, -0.14780902862548828, 0.989015936851501464, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+88, 181060, 0, 14046, 0, '0', 0, 0, 1625.3663330078125, 266.015625, -34.8114051818847656, 3.735006093978881835, 0, 0, -0.95630455017089843, 0.292372345924377441, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+89, 181060, 0, 14046, 0, '0', 0, 0, 1630.38720703125, 221.2916717529296875, -34.8106613159179687, 0.925023794174194335, 0, 0, 0.446197509765625, 0.894934535026550292, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+90, 181060, 0, 14046, 0, '0', 0, 0, 1630.6875, 258.633697509765625, -34.811614990234375, 3.717553615570068359, 0, 0, -0.95881938934326171, 0.284016460180282592, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+91, 181060, 0, 14046, 0, '0', 0, 0, 1633.423583984375, 227.125, -34.8087158203125, 2.844882726669311523, 0, 0, 0.989015579223632812, 0.147811368107795715, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+92, 181060, 0, 14046, 0, '0', 0, 0, 1633.6458740234375, 252.861114501953125, -34.8087959289550781, 3.420850038528442382, 0, 0, -0.99026775360107421, 0.139175355434417724, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+93, 181060, 0, 14046, 0, '0', 0, 0, 1629.8004150390625, 263.55035400390625, -40.6943588256835937, 3.769911527633666992, 0, 0, -0.95105648040771484, 0.309017121791839599, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+94, 181060, 0, 14046, 0, '0', 0, 0, 1636.967041015625, 249.140625, -40.6942634582519531, 3.403396368026733398, 0, 0, -0.99144458770751953, 0.130528271198272705, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+95, 181060, 0, 14046, 0, '0', 0, 0, 1629.359375, 216.486114501953125, -40.6939468383789062, 5.637413978576660156, 0, 0, -0.31730461120605468, 0.948323667049407958, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+96, 181060, 0, 1497, 0, '0', 0, 0, 1621.21533203125, 270.211822509765625, -34.8408279418945312, 4.101525306701660156, 0, 0, -0.88701057434082031, 0.461749136447906494, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+97, 181060, 0, 1497, 0, '0', 0, 0, 1624.9305419921875, 214.1336822509765625, -34.8113288879394531, 2.513273954391479492, 0, 0, 0.951056480407714843, 0.309017121791839599, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+98, 181060, 0, 1497, 0, '0', 0, 0, 1590.3629150390625, 223.3343353271484375, 60.1515045166015625, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+99, 181060, 0, 1497, 0, '0', 0, 0, 1590.423583984375, 256.86651611328125, 60.15149688720703125, 6.230826377868652343, 0, 0, -0.02617645263671875, 0.999657332897186279, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+100, 181060, 0, 1497, 0, '0', 0, 0, 1613.23095703125, 204.8854217529296875, -34.8433265686035156, 3.665196180343627929, 0, 0, -0.96592521667480468, 0.258821308612823486, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+101, 181060, 0, 1497, 0, '0', 0, 0, 1608.07470703125, 278.2413330078125, -34.844512939453125, 4.433136463165283203, 0, 0, -0.79863548278808593, 0.60181504487991333, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+102, 181060, 0, 1497, 0, '0', 0, 0, 1620.7291259765625, 209.984375, -34.84014892578125, 2.181660413742065429, 0, 0, 0.887010574340820312, 0.461749136447906494, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+103, 181060, 0, 1497, 0, '0', 0, 0, 1601.556396484375, 256.76666259765625, 60.15149688720703125, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+104, 181060, 0, 1497, 0, '0', 0, 0, 1607.40625, 202.19097900390625, -34.8443832397460937, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+105, 181060, 0, 1497, 0, '0', 0, 0, 1613.7899169921875, 275.435760498046875, -34.8438453674316406, 4.101525306701660156, 0, 0, -0.88701057434082031, 0.461749136447906494, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+106, 181060, 0, 1497, 0, '0', 0, 0, 1578.8707275390625, 234.809326171875, 60.1515045166015625, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+107, 181060, 0, 1497, 0, '0', 0, 0, 1618.0833740234375, 205.6163177490234375, -40.7263679504394531, 5.305802345275878906, 0, 0, -0.46947097778320312, 0.882947921752929687, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+108, 181060, 0, 1497, 0, '0', 0, 0, 1618.75, 274.61285400390625, -40.726959228515625, 4.101525306701660156, 0, 0, -0.88701057434082031, 0.461749136447906494, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+109, 181060, 0, 1497, 0, '0', 0, 0, 1579.1903076171875, 245.8570098876953125, 60.15149688720703125, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+110, 181060, 0, 1497, 0, '0', 0, 0, 1600.7476806640625, 223.210479736328125, 60.1515045166015625, 3.106652259826660156, 0, 0, 0.999847412109375, 0.017469281330704689, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+111, 181060, 0, 1497, 0, '0', 0, 0, 1603.578125, 198.9774322509765625, -40.7299537658691406, 1.832594871520996093, 0, 0, 0.793353080749511718, 0.608761727809906005, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+112, 181060, 0, 1497, 0, '0', 0, 0, 1604.2847900390625, 281.520843505859375, -40.72979736328125, 4.433136463165283203, 0, 0, -0.79863548278808593, 0.60181504487991333, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+113, 181060, 0, 1497, 0, '0', 0, 0, 1583.9896240234375, 278.458343505859375, -34.8444709777832031, 4.991643905639648437, 0, 0, -0.60181427001953125, 0.798636078834533691, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+114, 181060, 0, 1497, 0, '0', 0, 0, 1583.3228759765625, 202.3871612548828125, -34.8442459106445312, 4.415683269500732421, 0, 0, -0.80385684967041015, 0.594822824001312255, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+115, 181060, 0, 1497, 0, '0', 0, 0, 1577.5816650390625, 205.1840362548828125, -34.8433837890625, 4.136432647705078125, 0, 0, -0.87881660461425781, 0.477159708738327026, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+116, 181060, 0, 1497, 0, '0', 0, 0, 1578.1978759765625, 275.744781494140625, -34.8436012268066406, 5.270895957946777343, 0, 0, -0.48480892181396484, 0.87462007999420166, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+117, 181060, 0, 1497, 0, '0', 0, 0, 1587.720458984375, 281.642364501953125, -40.7300148010253906, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+118, 181060, 0, 1497, 0, '0', 0, 0, 1587.1319580078125, 199.11285400390625, -40.72998046875, 1.32644820213317871, 0, 0, 0.615660667419433593, 0.788011372089385986, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+119, 181060, 0, 1497, 0, '0', 0, 0, 1557.9566650390625, 253.513885498046875, -34.8083381652832031, 5.986480236053466796, 0, 0, -0.14780902862548828, 0.989015936851501464, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+120, 181060, 0, 1497, 0, '0', 0, 0, 1570.1666259765625, 210.420135498046875, -34.8405036926269531, 4.084071159362792968, 0, 0, -0.8910064697265625, 0.453990638256072998, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+121, 181060, 0, 1497, 0, '0', 0, 0, 1566.03125, 214.640625, -34.8114433288574218, 3.769911527633666992, 0, 0, -0.95105648040771484, 0.309017121791839599, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+122, 181060, 0, 1497, 0, '0', 0, 0, 1566.4305419921875, 266.50347900390625, -34.8109512329101562, 5.637413978576660156, 0, 0, -0.31730461120605468, 0.948323667049407958, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+123, 181060, 0, 1497, 0, '0', 0, 0, 1561.0347900390625, 259.25, -34.8115119934082031, 5.637413978576660156, 0, 0, -0.31730461120605468, 0.948323667049407958, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+124, 181060, 0, 1497, 0, '0', 0, 0, 1573.295166015625, 275.01910400390625, -40.7265434265136718, 5.253442287445068359, 0, 0, -0.49242305755615234, 0.870355963706970214, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+125, 181060, 0, 1497, 0, '0', 0, 0, 1557.7691650390625, 227.7708282470703125, -34.8091163635253906, 0.27925160527229309, 0, 0, 0.139172554016113281, 0.990268170833587646, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+126, 181060, 0, 1497, 0, '0', 0, 0, 1560.71533203125, 222, -34.8123359680175781, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+127, 181060, 0, 1497, 0, '0', 0, 0, 1572.717041015625, 205.9913177490234375, -40.7268295288085937, 0.959929943084716796, 0, 0, 0.461748123168945312, 0.887011110782623291, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+128, 181060, 0, 1497, 0, '0', 0, 0, 1570.6805419921875, 270.711822509765625, -34.8390159606933593, 5.305802345275878906, 0, 0, -0.46947097778320312, 0.882947921752929687, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+129, 181060, 0, 1497, 0, '0', 0, 0, 1554.5885009765625, 249.8211822509765625, -40.6941413879394531, 6.003933906555175781, 0, 0, -0.13917255401611328, 0.990268170833587646, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+130, 181060, 0, 1497, 0, '0', 0, 0, 1554.4410400390625, 231.47222900390625, -40.6943588256835937, 0.314158439636230468, 0, 0, 0.156434059143066406, 0.987688362598419189, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+131, 181060, 0, 1497, 0, '0', 0, 0, 1561.6666259765625, 217.0260467529296875, -40.6939964294433593, 0.645771682262420654, 0, 0, 0.317304611206054687, 0.948323667049407958, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+132, 181060, 0, 1497, 0, '0', 0, 0, 1562.029541015625, 264.161468505859375, -40.6943092346191406, 5.637413978576660156, 0, 0, -0.31730461120605468, 0.948323667049407958, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+133, 181060, 0, 1497, 0, '0', 0, 0, 1772.4000244140625, 72.19210052490234375, -45.2444992065429687, 4.677483558654785156, 0, 0, -0.71933937072753906, 0.694658815860748291, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+134, 181060, 0, 1497, 0, '0', 0, 0, 1765.550048828125, 68.70510101318359375, -45.2478981018066406, 5.480334281921386718, 0, 0, -0.39073085784912109, 0.920504987239837646, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+135, 181060, 0, 1497, 0, '0', 0, 0, 1762, 61.73509979248046875, -45.2444992065429687, 0.034906249493360519, 0, 0, 0.017452239990234375, 0.999847710132598876, 120, 255, 1, 53262), -- Lovely Candle (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+136, 187266, 0, 85, 153, '0', 0, 0, 1830.2430419921875, 218.9774322509765625, 60.5967559814453125, 0.020547021180391311, 0.018082618713378906, 0.018438339233398437, 0.009936332702636718, 0.99961709976196289, 120, 255, 1, 53262), -- Romantic Blanket (Area: Ruins of Lordaeron - Difficulty: 0) CreateObject1 +(@OGUID+137, 187575, 0, 14046, 14046, '0', 0, 0, 1980.00439453125, 248.892547607421875, 37.28323745727539062, 3.665196180343627929, 0, 0, -0.96592521667480468, 0.258821308612823486, 120, 255, 1, 53262), -- Lovely Wreath (Area: Tirisfal Glades - Difficulty: 0) CreateObject1 +(@OGUID+138, 411551, 0, 14046, 14046, '0', 0, 0, 1829.2100830078125, 258.873260498046875, 59.60354995727539062, 3.621100425720214843, 0, 0, -0.97139644622802734, 0.237463504076004028, 120, 255, 1, 53262), -- Scenic Getaway Portal (Area: Tirisfal Glades - Difficulty: 0) CreateObject1 +(@OGUID+139, 416381, 0, 14046, 14046, '0', 0, 0, 1829.2100830078125, 258.873260498046875, 59.60354995727539062, 3.621100425720214843, 0, 0, -0.97139644622802734, 0.237463504076004028, 120, 255, 1, 53262); -- Portal Arch (Area: Tirisfal Glades - Difficulty: 0) CreateObject1 + +-- Event spawns +DELETE FROM `game_event_creature` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @CGUID+0 AND @CGUID+5; +INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES +(@EVENT, @CGUID+0), +(@EVENT, @CGUID+1), +(@EVENT, @CGUID+2), +(@EVENT, @CGUID+3), +(@EVENT, @CGUID+4), +(@EVENT, @CGUID+5); + +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @OGUID+0 AND @OGUID+139; +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), +(@EVENT, @OGUID+121), +(@EVENT, @OGUID+122), +(@EVENT, @OGUID+123), +(@EVENT, @OGUID+124), +(@EVENT, @OGUID+125), +(@EVENT, @OGUID+126), +(@EVENT, @OGUID+127), +(@EVENT, @OGUID+128), +(@EVENT, @OGUID+129), +(@EVENT, @OGUID+130), +(@EVENT, @OGUID+131), +(@EVENT, @OGUID+132), +(@EVENT, @OGUID+133), +(@EVENT, @OGUID+134), +(@EVENT, @OGUID+135), +(@EVENT, @OGUID+136), +(@EVENT, @OGUID+137), +(@EVENT, @OGUID+138), +(@EVENT, @OGUID+139); |