diff options
| -rw-r--r-- | sql/updates/world/master/2022_12_19_18_world.sql | 362 |
1 files changed, 362 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_12_19_18_world.sql b/sql/updates/world/master/2022_12_19_18_world.sql new file mode 100644 index 00000000000..a88dba60aeb --- /dev/null +++ b/sql/updates/world/master/2022_12_19_18_world.sql @@ -0,0 +1,362 @@ +SET @CGUID := 396648; +SET @OGUID := 251621; +SET @EVENT := 2; + +-- Gameobject templates +UPDATE `gameobject_template` SET `Data1`=0, `Data30`=15540, `ContentTuningId`=417, `VerifiedBuild`=47187 WHERE `entry`=178609; -- Holiday Snow + +DELETE FROM `gameobject_loot_template` WHERE `Entry`=15540; +INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(15540, 17202, 0, 100, 0, 1, 0, 3, 6, 'Holiday Snow - Snowball'); + +-- 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`, `dynamicflags`, `VerifiedBuild`) VALUES +-- Kharanos +(@CGUID+0, 15760, 0, 1, 131, '0', 0, 0, 0, 1, -5581.23876953125, -525.34124755859375, 400.845855712890625, 1.518436431884765625, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 47187), -- Winter Reveler (Area: Kharanos - Difficulty: 0) +(@CGUID+1, 15760, 0, 1, 131, '0', 0, 0, 0, 1, -5581.06884765625, -523.10186767578125, 400.845794677734375, 4.625122547149658203, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 47187); -- Winter Reveler (Area: Kharanos - Difficulty: 0) + +DELETE FROM `creature_addon` WHERE `guid` IN (@CGUID+0, @CGUID+1); +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+0, 0, 0, 0, 257, 0, 0, 0, 0, 0, '26241'), -- 15760 (Winter Reveler) +(@CGUID+1, 0, 0, 0, 257, 0, 0, 0, 0, 0, '26242'); -- 15760 (Winter Reveler) + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+159; +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 +-- Kharanos +(@OGUID+0, 178428, 0, 1, 131, '0', 0, 0, -5618.61328125, -506.47259521484375, 403.72344970703125, 4.118979454040527343, 0, 0, -0.88294696807861328, 0.469472706317901611, 120, 255, 1, 47187), -- XMasGift01 (Area: Kharanos - Difficulty: 0) +(@OGUID+1, 178428, 0, 1, 131, '0', 0, 0, -5619.6337890625, -508.786468505859375, 404.03912353515625, 3.647741317749023437, 0, 0, -0.96814727783203125, 0.250381410121917724, 120, 255, 1, 47187), -- XMasGift01 (Area: Kharanos - Difficulty: 0) +(@OGUID+2, 178428, 0, 1, 131, '0', 0, 0, -5616.54443359375, -506.2501220703125, 403.673553466796875, 0.191985160112380981, 0, 0, 0.095845222473144531, 0.995396256446838378, 120, 255, 1, 47187), -- XMasGift01 (Area: Kharanos - Difficulty: 0) +(@OGUID+3, 178428, 0, 1, 131, '0', 0, 0, -5616.181640625, -508.1778564453125, 403.30902099609375, 3.560472726821899414, 0, 0, -0.97814750671386718, 0.207912087440490722, 120, 255, 1, 47187), -- XMasGift01 (Area: Kharanos - Difficulty: 0) +(@OGUID+4, 178429, 0, 1, 131, '0', 0, 0, -5618.392578125, -507.49652099609375, 403.752197265625, 2.862335443496704101, 0, 0, 0.990267753601074218, 0.139175355434417724, 120, 255, 1, 47187), -- XMasGift02 (Area: Kharanos - Difficulty: 0) +(@OGUID+5, 178429, 0, 1, 131, '0', 0, 0, -5616.330078125, -507.196929931640625, 403.30120849609375, 4.991643905639648437, 0, 0, -0.60181427001953125, 0.798636078834533691, 120, 255, 1, 47187), -- XMasGift02 (Area: Kharanos - Difficulty: 0) +(@OGUID+6, 178429, 0, 1, 131, '0', 0, 0, -5616.986328125, -508.508697509765625, 403.4100341796875, 5.044002056121826171, 0, 0, -0.58070278167724609, 0.814115643501281738, 120, 255, 1, 47187), -- XMasGift02 (Area: Kharanos - Difficulty: 0) +(@OGUID+7, 178430, 0, 1, 131, '0', 0, 0, -5615.88818359375, -505.479217529296875, 403.133880615234375, 3.94444584846496582, 0, 0, -0.92050457000732421, 0.3907318115234375, 120, 255, 1, 47187), -- XMasGift03 (Area: Kharanos - Difficulty: 0) +(@OGUID+8, 178430, 0, 1, 131, '0', 0, 0, -5619.064453125, -508.267364501953125, 403.889434814453125, 3.717553615570068359, 0, 0, -0.95881938934326171, 0.284016460180282592, 120, 255, 1, 47187), -- XMasGift03 (Area: Kharanos - Difficulty: 0) +(@OGUID+9, 178430, 0, 1, 131, '0', 0, 0, -5616.64697265625, -506.12164306640625, 403.352935791015625, 1.239183306694030761, 0, 0, 0.580702781677246093, 0.814115643501281738, 120, 255, 1, 47187), -- XMasGift03 (Area: Kharanos - Difficulty: 0) +(@OGUID+10, 178431, 0, 1, 131, '0', 0, 0, -5617.37744140625, -509.4893798828125, 403.658172607421875, 5.026549339294433593, 0, 0, -0.5877847671508789, 0.809017360210418701, 120, 255, 1, 47187), -- XMasGift04 (Area: Kharanos - Difficulty: 0) +(@OGUID+11, 178431, 0, 1, 131, '0', 0, 0, -5619.45166015625, -507.0216064453125, 403.849517822265625, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 120, 255, 1, 47187), -- XMasGift04 (Area: Kharanos - Difficulty: 0) +(@OGUID+12, 178431, 0, 1, 131, '0', 0, 0, -5615.5673828125, -506.63323974609375, 403.169952392578125, 1.902408957481384277, 0, 0, 0.814115524291992187, 0.580702960491180419, 120, 255, 1, 47187), -- XMasGift04 (Area: Kharanos - Difficulty: 0) +(@OGUID+13, 178431, 0, 1, 131, '0', 0, 0, -5617.76806640625, -505.853240966796875, 403.575042724609375, 2.478367090225219726, 0, 0, 0.94551849365234375, 0.325568377971649169, 120, 255, 1, 47187), -- XMasGift04 (Area: Kharanos - Difficulty: 0) +(@OGUID+14, 178432, 0, 1, 131, '0', 0, 0, -5620.14404296875, -507.78656005859375, 404.01141357421875, 4.468043327331542968, 0, 0, -0.7880105972290039, 0.615661680698394775, 120, 255, 1, 47187), -- XMasGift05 (Area: Kharanos - Difficulty: 0) +(@OGUID+15, 178432, 0, 1, 131, '0', 0, 0, -5617.6162109375, -506.733795166015625, 403.500579833984375, 0.471238493919372558, 0, 0, 0.233445167541503906, 0.972369968891143798, 120, 255, 1, 47187), -- XMasGift05 (Area: Kharanos - Difficulty: 0) +(@OGUID+16, 178432, 0, 1, 131, '0', 0, 0, -5617.98681640625, -508.639556884765625, 403.691558837890625, 4.241150379180908203, 0, 0, -0.85264015197753906, 0.522498607635498046, 120, 255, 1, 47187), -- XMasGift05 (Area: Kharanos - Difficulty: 0) +(@OGUID+17, 178432, 0, 1, 131, '0', 0, 0, -5618.533203125, -505.3603515625, 403.421051025390625, 4.572763919830322265, 0, 0, -0.75470924377441406, 0.656059443950653076, 120, 255, 1, 47187), -- XMasGift05 (Area: Kharanos - Difficulty: 0) +(@OGUID+18, 178433, 0, 1, 131, '0', 0, 0, -5618.45556640625, -509.385894775390625, 403.812469482421875, 4.066620349884033203, 0, 0, -0.89493370056152343, 0.44619917869567871, 120, 255, 1, 47187), -- XMasGift06 (Area: Kharanos - Difficulty: 0) +(@OGUID+19, 178433, 0, 1, 131, '0', 0, 0, -5617.28759765625, -505.012054443359375, 403.342803955078125, 1.797688722610473632, 0, 0, 0.7826080322265625, 0.622514784336090087, 120, 255, 1, 47187), -- XMasGift06 (Area: Kharanos - Difficulty: 0) +(@OGUID+20, 178433, 0, 1, 131, '0', 0, 0, -5619.35009765625, -506.15869140625, 403.647857666015625, 2.617989301681518554, 0, 0, 0.965925216674804687, 0.258821308612823486, 120, 255, 1, 47187), -- XMasGift06 (Area: Kharanos - Difficulty: 0) +(@OGUID+21, 178433, 0, 1, 131, '0', 0, 0, -5615.44775390625, -507.55902099609375, 403.148284912109375, 6.178466320037841796, 0, 0, -0.05233573913574218, 0.998629570007324218, 120, 255, 1, 47187), -- XMasGift06 (Area: Kharanos - Difficulty: 0) +(@OGUID+22, 178434, 0, 1, 131, '0', 0, 0, -5606.34228515625, -527.595947265625, 402.44805908203125, 6.248279094696044921, 0, 0, -0.01745223999023437, 0.999847710132598876, 120, 255, 1, 47187), -- XMasStocking01 (Area: Kharanos - Difficulty: 0) +(@OGUID+23, 178434, 0, 1, 131, '0', 0, 0, -5591.44482421875, -543.04925537109375, 401.308013916015625, 3.054326534271240234, 0, 0, 0.999048233032226562, 0.043619260191917419, 120, 255, 1, 47187), -- XMasStocking01 (Area: Kharanos - Difficulty: 0) +(@OGUID+24, 178435, 0, 1, 131, '0', 0, 0, -5606.47509765625, -526.992431640625, 402.24737548828125, 6.195919513702392578, 0, 0, -0.04361915588378906, 0.999048233032226562, 120, 255, 1, 47187), -- XMasStocking02 (Area: Kharanos - Difficulty: 0) +(@OGUID+25, 178435, 0, 1, 131, '0', 0, 0, -5591.4697265625, -544.15155029296875, 401.329071044921875, 2.897245407104492187, 0, 0, 0.99254608154296875, 0.121869951486587524, 120, 255, 1, 47187), -- XMasStocking02 (Area: Kharanos - Difficulty: 0) +(@OGUID+26, 178436, 0, 1, 131, '0', 0, 0, -5606.38525390625, -523.2806396484375, 402.28021240234375, 6.178466320037841796, 0, 0, -0.05233573913574218, 0.998629570007324218, 120, 255, 1, 47187), -- XMasStocking03 (Area: Kharanos - Difficulty: 0) +(@OGUID+27, 178436, 0, 1, 131, '0', 0, 0, -5591.458984375, -543.57598876953125, 401.326995849609375, 2.879789113998413085, 0, 0, 0.991444587707519531, 0.130528271198272705, 120, 255, 1, 47187), -- XMasStocking03 (Area: Kharanos - Difficulty: 0) +(@OGUID+28, 178438, 0, 1, 131, '0', 0, 0, -5588.36572265625, -459.783843994140625, 412.010345458984375, 2.984498262405395507, 0, 0, 0.996916770935058593, 0.078466430306434631, 120, 255, 1, 47187), -- Lights (Area: Kharanos - Difficulty: 0) +(@OGUID+29, 178438, 0, 1, 131, '0', 0, 0, -5592.97119140625, -510.876861572265625, 411.150665283203125, 3.124123096466064453, 0, 0, 0.99996185302734375, 0.008734640665352344, 120, 255, 1, 47187), -- Lights (Area: Kharanos - Difficulty: 0) +(@OGUID+30, 178438, 0, 1, 131, '0', 0, 0, -5637.21875, -497.6632080078125, 399.162261962890625, 5.305802345275878906, 0, 0, -0.46947097778320312, 0.882947921752929687, 120, 255, 1, 47187), -- Lights (Area: Kharanos - Difficulty: 0) +(@OGUID+31, 178438, 0, 1, 131, '0', 0, 0, -5595.16650390625, -513.29864501953125, 411.146697998046875, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 47187), -- Lights (Area: Kharanos - Difficulty: 0) +(@OGUID+32, 178438, 0, 1, 131, '0', 0, 0, -5588.1494140625, -456.5069580078125, 411.750274658203125, 3.124123096466064453, 0, 0, 0.99996185302734375, 0.008734640665352344, 120, 255, 1, 47187), -- Lights (Area: Kharanos - Difficulty: 0) +(@OGUID+33, 178438, 0, 1, 131, '0', 0, 0, -5609.55908203125, -513.09375, 411.457794189453125, 1.518436193466186523, 0, 0, 0.6883544921875, 0.725374460220336914, 120, 255, 1, 47187), -- Lights (Area: Kharanos - Difficulty: 0) +(@OGUID+34, 178438, 0, 1, 131, '0', 0, 0, -5592.8984375, -506.816558837890625, 411.253448486328125, 3.106652259826660156, 0, 0, 0.999847412109375, 0.017469281330704689, 120, 255, 1, 47187), -- Lights (Area: Kharanos - Difficulty: 0) +(@OGUID+35, 178438, 0, 1, 131, '0', 0, 0, -5586.27783203125, -462.68402099609375, 412.269989013671875, 4.747295856475830078, 0, 0, -0.69465827941894531, 0.719339847564697265, 120, 255, 1, 47187), -- Lights (Area: Kharanos - Difficulty: 0) +(@OGUID+36, 178438, 0, 1, 131, '0', 0, 0, -5569.94775390625, -456.755218505859375, 411.59478759765625, 0, 0, 0, 0, 1, 120, 255, 1, 47187), -- Lights (Area: Kharanos - Difficulty: 0) +(@OGUID+37, 178438, 0, 1, 131, '0', 0, 0, -5576.29345703125, -522.60418701171875, 411.214019775390625, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 47187), -- Lights (Area: Kharanos - Difficulty: 0) +(@OGUID+38, 178438, 0, 1, 131, '0', 0, 0, -5571.8349609375, -462.635406494140625, 411.933135986328125, 4.677483558654785156, 0, 0, -0.71933937072753906, 0.694658815860748291, 120, 255, 1, 47187), -- Lights (Area: Kharanos - Difficulty: 0) +(@OGUID+39, 178438, 0, 1, 131, '0', 0, 0, -5569.8994140625, -460.3946533203125, 411.7369384765625, 0.034906249493360519, 0, 0, 0.017452239990234375, 0.999847710132598876, 120, 255, 1, 47187), -- Lights (Area: Kharanos - Difficulty: 0) +(@OGUID+40, 178438, 0, 1, 131, '0', 0, 0, -5576.09228515625, -507.5205078125, 411.0941162109375, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 47187), -- Lights (Area: Kharanos - Difficulty: 0) +(@OGUID+41, 178554, 0, 1, 131, '0', 0, 0, -5586.6298828125, -510.126678466796875, 407.883392333984375, 4.066620349884033203, 0, 0, -0.89493370056152343, 0.44619917869567871, 120, 255, 1, 47187), -- Mistletoe (Area: Kharanos - Difficulty: 0) +(@OGUID+42, 178558, 0, 1, 131, '0', 0, 0, -5617.384765625, -507.91497802734375, 403.613616943359375, 1.117009282112121582, 0, 0, 0.529918670654296875, 0.84804844856262207, 120, 255, 1, 47187), -- Christmas Tree (Large Snowy) (Area: Kharanos - Difficulty: 0) +(@OGUID+43, 178645, 0, 1, 131, '0', 0, 0, -5582.88525390625, -503.8350830078125, 411.0889892578125, 1.553341388702392578, 0, 0, 0.700908660888671875, 0.713251054286956787, 120, 255, 1, 47187), -- Lights x3 (Area: Kharanos - Difficulty: 0) +(@OGUID+44, 178645, 0, 1, 131, '0', 0, 0, -5602.39697265625, -513.1947021484375, 411.181854248046875, 1.553341388702392578, 0, 0, 0.700908660888671875, 0.713251054286956787, 120, 255, 1, 47187), -- Lights x3 (Area: Kharanos - Difficulty: 0) +(@OGUID+45, 178645, 0, 1, 131, '0', 0, 0, -5612.03857421875, -519.24920654296875, 411.411407470703125, 3.124123096466064453, 0, 0, 0.99996185302734375, 0.008734640665352344, 120, 255, 1, 47187), -- Lights x3 (Area: Kharanos - Difficulty: 0) +(@OGUID+46, 178645, 0, 1, 131, '0', 0, 0, -5578.90625, -462.68402099609375, 411.960845947265625, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 47187), -- Lights x3 (Area: Kharanos - Difficulty: 0) +(@OGUID+47, 178645, 0, 1, 131, '0', 0, 0, -5576.1181640625, -514.99481201171875, 411.11444091796875, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 47187), -- Lights x3 (Area: Kharanos - Difficulty: 0) +(@OGUID+48, 178645, 0, 1, 131, '0', 0, 0, -5473.21728515625, -463.79840087890625, 403.051727294921875, 6.003933906555175781, 0, 0, -0.13917255401611328, 0.990268170833587646, 120, 255, 1, 47187), -- Lights x3 (Area: Kharanos - Difficulty: 0) +(@OGUID+49, 178645, 0, 1, 131, '0', 0, 0, -5514.76416015625, -658.71246337890625, 404.398101806640625, 0.401424884796142578, 0, 0, 0.199367523193359375, 0.979924798011779785, 120, 255, 1, 47187), -- Lights x3 (Area: Kharanos - Difficulty: 0) +(@OGUID+50, 178649, 0, 1, 131, '0', 0, 0, -5579.01025390625, -446.655426025390625, 427.896392822265625, 4.660029888153076171, 0, 0, -0.72537422180175781, 0.688354730606079101, 120, 255, 1, 47187), -- Wreath scale 0.75 (Area: Kharanos - Difficulty: 0) +(@OGUID+51, 180844, 0, 1, 131, '0', 0, 0, -5581.2451171875, -524.3232421875, 408.61663818359375, 2.234017848968505859, 0, 0, 0.898793220520019531, 0.438372820615768432, 120, 255, 1, 47187), -- Mistletoe (Area: Kharanos - Difficulty: 0) +(@OGUID+52, 187194, 0, 1, 131, '0', 0, 0, -5596.97705078125, -512.89947509765625, 411.596710205078125, 1.553341388702392578, 0, 0, 0.700908660888671875, 0.713251054286956787, 120, 255, 1, 47187), -- Hanging, Streamer x3 - Xmas (Area: Kharanos - Difficulty: 0) +(@OGUID+53, 187194, 0, 1, 131, '0', 0, 0, -5612.13818359375, -518.682373046875, 411.9815673828125, 3.124123096466064453, 0, 0, 0.99996185302734375, 0.008734640665352344, 120, 255, 1, 47187), -- Hanging, Streamer x3 - Xmas (Area: Kharanos - Difficulty: 0) +(@OGUID+54, 187194, 0, 1, 131, '0', 0, 0, -5582.82666015625, -503.69293212890625, 411.73980712890625, 1.553341388702392578, 0, 0, 0.700908660888671875, 0.713251054286956787, 120, 255, 1, 47187), -- Hanging, Streamer x3 - Xmas (Area: Kharanos - Difficulty: 0) +(@OGUID+55, 187194, 0, 1, 131, '0', 0, 0, -5593.0302734375, -509.22906494140625, 411.613677978515625, 3.106652259826660156, 0, 0, 0.999847412109375, 0.017469281330704689, 120, 255, 1, 47187), -- Hanging, Streamer x3 - Xmas (Area: Kharanos - Difficulty: 0) +(@OGUID+56, 187194, 0, 1, 131, '0', 0, 0, -5604.44775390625, -512.76007080078125, 411.590911865234375, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 120, 255, 1, 47187), -- Hanging, Streamer x3 - Xmas (Area: Kharanos - Difficulty: 0) +(@OGUID+57, 187194, 0, 1, 131, '0', 0, 0, -5578.94287109375, -461.7431640625, 409.891021728515625, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 120, 255, 1, 47187), -- Hanging, Streamer x3 - Xmas (Area: Kharanos - Difficulty: 0) +(@OGUID+58, 187194, 0, 1, 131, '0', 0, 0, -5576.13427734375, -520.75164794921875, 411.746185302734375, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 47187), -- Hanging, Streamer x3 - Xmas (Area: Kharanos - Difficulty: 0) +(@OGUID+59, 187194, 0, 1, 131, '0', 0, 0, -5575.9365234375, -509.47369384765625, 411.79248046875, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 47187), -- Hanging, Streamer x3 - Xmas (Area: Kharanos - Difficulty: 0) +(@OGUID+60, 187235, 0, 1, 131, '0', 0, 0, -5643.27978515625, -503.156005859375, 396.680999755859375, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Kharanos - Difficulty: 0) +(@OGUID+61, 187235, 0, 1, 131, '0', 0, 0, -5605.66064453125, -489.755035400390625, 397.5626220703125, 1.797688722610473632, 0, 0, 0.7826080322265625, 0.622514784336090087, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Kharanos - Difficulty: 0) +(@OGUID+62, 187235, 0, 1, 131, '0', 0, 0, -5568.5068359375, -501.36285400390625, 402.859588623046875, 1.362257122993469238, 0, 0, 0.629670143127441406, 0.776862621307373046, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Kharanos - Difficulty: 0) +(@OGUID+63, 187235, 0, 1, 131, '0', 0, 0, -5588.75634765625, -425.283660888671875, 397.32537841796875, 5.166176319122314453, 0, 0, -0.52991867065429687, 0.84804844856262207, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Kharanos - Difficulty: 0) +(@OGUID+64, 187235, 0, 1, 131, '0', 0, 0, -5535.453125, -476.932281494140625, 398.091217041015625, 5.619962215423583984, 0, 0, -0.32556724548339843, 0.945518851280212402, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Kharanos - Difficulty: 0) +(@OGUID+65, 187235, 0, 1, 131, '0', 0, 0, -5461.14892578125, -479.123748779296875, 396.699859619140625, 5.811946868896484375, 0, 0, -0.2334451675415039, 0.972369968891143798, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Kharanos - Difficulty: 0) +(@OGUID+66, 187235, 0, 1, 131, '0', 0, 0, -5483.44384765625, -669.21466064453125, 392.697967529296875, 0.226892471313476562, 0, 0, 0.113203048706054687, 0.993571877479553222, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Kharanos - Difficulty: 0) +(@OGUID+67, 187567, 0, 1, 131, '0', 0, 0, -5597.30029296875, -532.34722900390625, 403.071380615234375, 1.500982880592346191, 0, 0, 0.681998252868652343, 0.731353819370269775, 120, 255, 1, 47187), -- Hanging, Streamer - Xmas (Area: Kharanos - Difficulty: 0) +(@OGUID+68, 187567, 0, 1, 131, '0', 0, 0, -5480.08056640625, -461.806304931640625, 401.465240478515625, 6.003933906555175781, 0, 0, -0.13917255401611328, 0.990268170833587646, 120, 255, 1, 47187), -- Hanging, Streamer - Xmas (Area: Kharanos - Difficulty: 0) +(@OGUID+69, 187567, 0, 1, 131, '0', 0, 0, -5496.23291015625, -689.7177734375, 398.201934814453125, 1.029743075370788574, 0, 0, 0.492423057556152343, 0.870355963706970214, 120, 255, 1, 47187), -- Hanging, Streamer - Xmas (Area: Kharanos - Difficulty: 0) +(@OGUID+70, 187567, 0, 1, 131, '0', 0, 0, -5519.25927734375, -663.923828125, 403.041656494140625, 0.401424884796142578, 0, 0, 0.199367523193359375, 0.979924798011779785, 120, 255, 1, 47187), -- Hanging, Streamer - Xmas (Area: Kharanos - Difficulty: 0) +-- Ironforge Airfield +(@OGUID+71, 187567, 0, 1, 5115, '0', 0, 0, -4499.2099609375, -1579.71533203125, 512.2724609375, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 47187), -- Hanging, Streamer - Xmas (Area: Ironforge Airfield - Difficulty: 0) +-- Amberstill Ranch +(@OGUID+72, 187234, 0, 1, 803, '0', 0, 0, -5521.49853515625, -1330.484375, 403.426788330078125, 3.281238555908203125, 0, 0, -0.99756336212158203, 0.069766148924827575, 120, 255, 1, 47187), -- Tall/Thin Medium - Xmas (Area: Amberstill Ranch - Difficulty: 0) +(@OGUID+73, 187235, 0, 1, 803, '0', 0, 0, -5545.71337890625, -1323.4097900390625, 398.663818359375, 1.954769015312194824, 0, 0, 0.829037666320800781, 0.559192776679992675, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Amberstill Ranch - Difficulty: 0) +(@OGUID+74, 187567, 0, 1, 803, '0', 0, 0, -5514.765625, -1301.0625, 410.96099853515625, 4.241150379180908203, 0, 0, -0.85264015197753906, 0.522498607635498046, 120, 255, 1, 47187), -- Hanging, Streamer - Xmas (Area: Amberstill Ranch - Difficulty: 0) +(@OGUID+75, 187567, 0, 1, 803, '0', 0, 0, -5510.77587890625, -1302.984375, 410.96099853515625, 4.258606910705566406, 0, 0, -0.84804725646972656, 0.529920578002929687, 120, 255, 1, 47187), -- Hanging, Streamer - Xmas (Area: Amberstill Ranch - Difficulty: 0) +(@OGUID+76, 187567, 0, 1, 803, '0', 0, 0, -5518.87158203125, -1299.0052490234375, 410.96099853515625, 4.241150379180908203, 0, 0, -0.85264015197753906, 0.522498607635498046, 120, 255, 1, 47187), -- Hanging, Streamer - Xmas (Area: Amberstill Ranch - Difficulty: 0) +-- Gol'Bolar Quarry +(@OGUID+77, 187234, 0, 1, 134, '0', 0, 0, -5697.66845703125, -1584.34033203125, 386.297943115234375, 1.518436193466186523, 0, 0, 0.6883544921875, 0.725374460220336914, 120, 255, 1, 47187), -- Tall/Thin Medium - Xmas (Area: Gol'Bolar Quarry - Difficulty: 0) +(@OGUID+78, 187235, 0, 1, 134, '0', 0, 0, -5700.75537109375, -1584.751708984375, 383.557403564453125, 2.72271275520324707, 0, 0, 0.978147506713867187, 0.207912087440490722, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Gol'Bolar Quarry - Difficulty: 0) +(@OGUID+79, 187235, 0, 1, 134, '0', 0, 0, -5672.48779296875, -1599.392333984375, 383.204254150390625, 2.70525527000427246, 0, 0, 0.97629547119140625, 0.216442063450813293, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Gol'Bolar Quarry - Difficulty: 0) +(@OGUID+80, 187235, 0, 1, 134, '0', 0, 0, -5685.3193359375, -1542.0364990234375, 390.614013671875, 1.518436193466186523, 0, 0, 0.6883544921875, 0.725374460220336914, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Gol'Bolar Quarry - Difficulty: 0) +(@OGUID+81, 187567, 0, 1, 134, '0', 0, 0, -5672.44287109375, -1574.6441650390625, 386.455902099609375, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 120, 255, 1, 47187), -- Hanging, Streamer - Xmas (Area: Gol'Bolar Quarry - Difficulty: 0) +-- Coldridge Valley +(@OGUID+82, 187235, 0, 6176, 132, '0', 0, 0, -6166.1513671875, 374.551177978515625, 400.342132568359375, 2.635444164276123046, 0, 0, 0.96814727783203125, 0.250381410121917724, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Coldridge Valley - Difficulty: 0) +(@OGUID+83, 187235, 0, 6176, 132, '0', 0, 0, -6165.80322265625, 354.42425537109375, 400.114166259765625, 2.513273954391479492, 0, 0, 0.951056480407714843, 0.309017121791839599, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Coldridge Valley - Difficulty: 0) +(@OGUID+84, 187235, 0, 6176, 132, '0', 0, 0, -6218.93212890625, 345.33050537109375, 383.55712890625, 3.263772249221801757, 0, 0, -0.99813461303710937, 0.061051756143569946, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Coldridge Valley - Difficulty: 0) +(@OGUID+85, 187235, 0, 6176, 132, '0', 0, 0, -6357.033203125, 572.64581298828125, 386.16363525390625, 3.211419343948364257, 0, 0, -0.9993906021118164, 0.034906134009361267, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Coldridge Valley - Difficulty: 0) +(@OGUID+86, 187567, 0, 6176, 132, '0', 0, 0, -6144.27783203125, 384.02056884765625, 399.4749755859375, 3.071766138076782226, 0, 0, 0.999390602111816406, 0.034906134009361267, 120, 255, 1, 47187), -- Hanging, Streamer - Xmas (Area: Coldridge Valley - Difficulty: 0) +-- New Tinkertown +(@OGUID+87, 187234, 0, 6457, 133, '0', 0, 0, -5198.4306640625, 513.3524169921875, 393.387420654296875, 0.733038187026977539, 0, 0, 0.358367919921875, 0.933580458164215087, 120, 255, 1, 47187), -- Tall/Thin Medium - Xmas (Area: New Tinkertown - Difficulty: 0) +(@OGUID+88, 187234, 0, 6457, 133, '0', 0, 0, -5141.125, 444.576385498046875, 397.37457275390625, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 120, 255, 1, 47187), -- Tall/Thin Medium - Xmas (Area: New Tinkertown - Difficulty: 0) +(@OGUID+89, 187234, 0, 6457, 133, '0', 0, 0, -5083.09375, 480.447906494140625, 406.580169677734375, 4.171337604522705078, 0, 0, -0.87035560607910156, 0.492423713207244873, 120, 255, 1, 47187), -- Tall/Thin Medium - Xmas (Area: New Tinkertown - Difficulty: 0) +(@OGUID+90, 187234, 0, 6457, 133, '0', 0, 0, -5083.58349609375, 448.192718505859375, 415.743804931640625, 2.513273954391479492, 0, 0, 0.951056480407714843, 0.309017121791839599, 120, 255, 1, 47187), -- Tall/Thin Medium - Xmas (Area: New Tinkertown - Difficulty: 0) +(@OGUID+91, 187235, 0, 6457, 133, '0', 0, 0, -5196.37353515625, 528.73089599609375, 388.58392333984375, 5.480334281921386718, 0, 0, -0.39073085784912109, 0.920504987239837646, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: New Tinkertown - Difficulty: 0) +(@OGUID+92, 187235, 0, 6457, 211, '0', 0, 0, -5361.76513671875, 302.7154541015625, 394.794708251953125, 1.884953022003173828, 0, 0, 0.809016227722167968, 0.587786316871643066, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Iceflow Lake - Difficulty: 0) +(@OGUID+93, 187235, 0, 6457, 211, '0', 0, 0, -5342.88720703125, 265.9632568359375, 389.259613037109375, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Iceflow Lake - Difficulty: 0) +(@OGUID+94, 187235, 0, 6457, 137, '0', 0, 0, -5397.95166015625, 304.11285400390625, 394.615203857421875, 1.378809213638305664, 0, 0, 0.636077880859375, 0.771624863147735595, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Brewnall Village - Difficulty: 0) +(@OGUID+95, 187567, 0, 6457, 133, '0', 0, 0, -5146.11279296875, 502.23785400390625, 398.60888671875, 3.735006093978881835, 0, 0, -0.95630455017089843, 0.292372345924377441, 120, 255, 1, 47187), -- Hanging, Streamer - Xmas (Area: New Tinkertown - Difficulty: 0) +(@OGUID+96, 187567, 0, 6457, 133, '0', 0, 0, -5130.923828125, 486.164947509765625, 398.601348876953125, 4.118979454040527343, 0, 0, -0.88294696807861328, 0.469472706317901611, 120, 255, 1, 47187), -- Hanging, Streamer - Xmas (Area: New Tinkertown - Difficulty: 0) +-- Dun Morogh (Holiday Snow) +(@OGUID+97, 178609, 0, 6457, 211, '0', 0, 0, -5057.55712890625, 222.0416717529296875, 387.277740478515625, 2.565631866455078125, 0, 0, 0.958819389343261718, 0.284016460180282592, 120, 255, 1, 47187), -- Holiday Snow (Area: Iceflow Lake - Difficulty: 0) +(@OGUID+98, 178609, 0, 6457, 211, '0', 0, 0, -5138.0849609375, 239.1590728759765625, 398.923248291015625, 5.672322273254394531, 0, 0, -0.3007049560546875, 0.953717231750488281, 120, 255, 1, 47187), -- Holiday Snow (Area: Iceflow Lake - Difficulty: 0) +(@OGUID+99, 178609, 0, 6457, 211, '0', 0, 0, -5355.7744140625, 255.1927032470703125, 389.072509765625, 0.24434557557106018, 0, 0, 0.121869087219238281, 0.9925462007522583, 120, 255, 1, 47187), -- Holiday Snow (Area: Iceflow Lake - Difficulty: 0) +(@OGUID+100, 178609, 0, 1, 800, '0', 0, 0, -5884.9365234375, -38.0708541870117187, 368.705535888671875, 3.22885894775390625, 0, 0, -0.99904823303222656, 0.043619260191917419, 120, 255, 1, 47187), -- Holiday Snow (Area: Coldridge Pass - Difficulty: 0) +(@OGUID+101, 178609, 0, 1, 800, '0', 0, 0, -5841.34326171875, 49.65114974975585937, 357.397064208984375, 3.43830275535583496, 0, 0, -0.98901557922363281, 0.147811368107795715, 120, 255, 1, 47187), -- Holiday Snow (Area: Coldridge Pass - Difficulty: 0) +(@OGUID+102, 178609, 0, 1, 0, '0', 0, 0, -5878.52880859375, -185.567703247070312, 361.050537109375, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 120, 255, 1, 47187), -- Holiday Snow (Area: 0 - Difficulty: 0) +(@OGUID+103, 178609, 0, 1, 136, '0', 0, 0, -5720.7353515625, -284.94000244140625, 359.143402099609375, 4.660029888153076171, 0, 0, -0.72537422180175781, 0.688354730606079101, 120, 255, 1, 47187), -- Holiday Snow (Area: The Grizzled Den - Difficulty: 0) +(@OGUID+104, 178609, 0, 1, 136, '0', 0, 0, -5710.4677734375, -383.710723876953125, 365.9642333984375, 6.12610626220703125, 0, 0, -0.07845878601074218, 0.996917366981506347, 120, 255, 1, 47187), -- Holiday Snow (Area: The Grizzled Den - Difficulty: 0) +(@OGUID+105, 178609, 0, 1, 136, '0', 0, 0, -5825.376953125, -359.6905517578125, 372.53240966796875, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 47187), -- Holiday Snow (Area: The Grizzled Den - Difficulty: 0) +(@OGUID+106, 178609, 0, 1, 0, '0', 0, 0, -6042.6591796875, -285.898223876953125, 420.7862548828125, 1.431168079376220703, 0, 0, 0.656058311462402343, 0.754710197448730468, 120, 255, 1, 47187), -- Holiday Snow (Area: 0 - Difficulty: 0) +(@OGUID+107, 178609, 0, 1, 0, '0', 0, 0, -6030.70556640625, -390.80621337890625, 417.24737548828125, 0.820303261280059814, 0, 0, 0.398748397827148437, 0.917060375213623046, 120, 255, 1, 47187), -- Holiday Snow (Area: 0 - Difficulty: 0) +(@OGUID+108, 178609, 0, 1, 0, '0', 0, 0, -5904.033203125, -434.73089599609375, 424.363006591796875, 4.59021615982055664, 0, 0, -0.74895572662353515, 0.662620067596435546, 120, 255, 1, 47187), -- Holiday Snow (Area: 0 - Difficulty: 0) +(@OGUID+109, 178609, 0, 1, 5097, '0', 0, 0, -5980.0302734375, -548.8203125, 407.03009033203125, 6.03883981704711914, 0, 0, -0.12186908721923828, 0.9925462007522583, 120, 255, 1, 47187), -- Holiday Snow (Area: Frostmane Front - Difficulty: 0) +(@OGUID+110, 178609, 0, 1, 5097, '0', 0, 0, -5827.84326171875, -680.89239501953125, 398.2440185546875, 5.148722648620605468, 0, 0, -0.53729915618896484, 0.843391716480255126, 120, 255, 1, 47187), -- Holiday Snow (Area: Frostmane Front - Difficulty: 0) +(@OGUID+111, 178609, 0, 1, 0, '0', 0, 0, -5412.6181640625, -330.704864501953125, 399.71746826171875, 5.009094715118408203, 0, 0, -0.59482288360595703, 0.80385679006576538, 120, 255, 1, 47187), -- Holiday Snow (Area: 0 - Difficulty: 0) +(@OGUID+112, 178609, 0, 1, 802, '0', 0, 0, -5302.267578125, -213.274307250976562, 439.58587646484375, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 120, 255, 1, 47187), -- Holiday Snow (Area: Shimmer Ridge - Difficulty: 0) +(@OGUID+113, 178609, 0, 1, 802, '0', 0, 0, -5213.2919921875, -81.5321197509765625, 394.5169677734375, 4.293513298034667968, 0, 0, -0.8386697769165039, 0.544640243053436279, 120, 255, 1, 47187), -- Holiday Snow (Area: Shimmer Ridge - Difficulty: 0) +(@OGUID+114, 178609, 0, 1, 802, '0', 0, 0, -5163.45654296875, -271.586822509765625, 435.07708740234375, 0.034906249493360519, 0, 0, 0.017452239990234375, 0.999847710132598876, 120, 255, 1, 47187), -- Holiday Snow (Area: Shimmer Ridge - Difficulty: 0) +(@OGUID+115, 178609, 0, 6457, 5177, '0', 0, 0, -4946.77587890625, 121.9375, 387.105987548828125, 4.607671737670898437, 0, 0, -0.74314403533935546, 0.669131457805633544, 120, 255, 1, 47187), -- Holiday Snow (Area: Crushcog's Arsenal - Difficulty: 0) +(@OGUID+116, 178609, 0, 6457, 801, '0', 0, 0, -5264.51416015625, -20.0069446563720703, 389.28399658203125, 1.361356139183044433, 0, 0, 0.629320144653320312, 0.77714616060256958, 120, 255, 1, 47187), -- Holiday Snow (Area: Chill Breeze Valley - Difficulty: 0) +(@OGUID+117, 178609, 0, 6457, 801, '0', 0, 0, -5381.83837890625, -29.5208339691162109, 391.673309326171875, 4.468043327331542968, 0, 0, -0.7880105972290039, 0.615661680698394775, 120, 255, 1, 47187), -- Holiday Snow (Area: Chill Breeze Valley - Difficulty: 0) +(@OGUID+118, 178609, 0, 6457, 801, '0', 0, 0, -5451.19775390625, 155.6770782470703125, 396.69305419921875, 0.593410074710845947, 0, 0, 0.292370796203613281, 0.95630502700805664, 120, 255, 1, 47187), -- Holiday Snow (Area: Chill Breeze Valley - Difficulty: 0) +(@OGUID+119, 178609, 0, 6457, 801, '0', 0, 0, -5482.02783203125, 223.0625, 397.173553466796875, 0.872663915157318115, 0, 0, 0.422617912292480468, 0.906307935714721679, 120, 255, 1, 47187), -- Holiday Snow (Area: Chill Breeze Valley - Difficulty: 0) +(@OGUID+120, 178609, 0, 6457, 801, '0', 0, 0, -5625.220703125, 222.0550689697265625, 393.748931884765625, 2.286378860473632812, 0, 0, 0.909960746765136718, 0.414694398641586303, 120, 255, 1, 47187), -- Holiday Snow (Area: Chill Breeze Valley - Difficulty: 0) +(@OGUID+121, 178609, 0, 6457, 801, '0', 0, 0, -5603.22900390625, 351.1201171875, 387.46051025390625, 2.408554315567016601, 0, 0, 0.933580398559570312, 0.358368009328842163, 120, 255, 1, 47187), -- Holiday Snow (Area: Chill Breeze Valley - Difficulty: 0) +(@OGUID+122, 178609, 0, 6457, 135, '0', 0, 0, -5747.90283203125, 284.11285400390625, 388.21185302734375, 2.042035102844238281, 0, 0, 0.852640151977539062, 0.522498607635498046, 120, 255, 1, 47187), -- Holiday Snow (Area: Frostmane Hold - Difficulty: 0) +(@OGUID+123, 178609, 0, 6457, 135, '0', 0, 0, -5714.28515625, 525.415283203125, 390.317169189453125, 3.577930212020874023, 0, 0, -0.97629547119140625, 0.216442063450813293, 120, 255, 1, 47187), -- Holiday Snow (Area: Frostmane Hold - Difficulty: 0) +(@OGUID+124, 178609, 0, 6457, 135, '0', 0, 0, -5654.33837890625, 436.586822509765625, 384.10028076171875, 5.916667938232421875, 0, 0, -0.18223476409912109, 0.98325502872467041, 120, 255, 1, 47187), -- Holiday Snow (Area: Frostmane Hold - Difficulty: 0) +(@OGUID+125, 178609, 0, 6457, 801, '0', 0, 0, -5478.12353515625, 372.54339599609375, 393.94921875, 3.595378875732421875, 0, 0, -0.97437000274658203, 0.224951311945915222, 120, 255, 1, 47187), -- Holiday Snow (Area: Chill Breeze Valley - Difficulty: 0) +(@OGUID+126, 178609, 0, 6457, 5178, '0', 0, 0, -5484.5224609375, 539.09552001953125, 388.597564697265625, 6.248279094696044921, 0, 0, -0.01745223999023437, 0.999847710132598876, 120, 255, 1, 47187), -- Holiday Snow (Area: The Toxic Airfield - Difficulty: 0) +(@OGUID+127, 178609, 0, 6457, 5178, '0', 0, 0, -5386.2900390625, 545.2860107421875, 386.118988037109375, 1.605701684951782226, 0, 0, 0.719339370727539062, 0.694658815860748291, 120, 255, 1, 47187), -- Holiday Snow (Area: The Toxic Airfield - Difficulty: 0) +(@OGUID+128, 178609, 0, 6457, 5178, '0', 0, 0, -5212.9208984375, 542.2080078125, 389.437713623046875, 1.553341388702392578, 0, 0, 0.700908660888671875, 0.713251054286956787, 120, 255, 0, 47187), -- Holiday Snow (Area: The Toxic Airfield - Difficulty: 0) +(@OGUID+129, 178609, 0, 6457, 211, '0', 0, 0, -5158.37451171875, 275.91497802734375, 396.92523193359375, 2.967041015625, 0, 0, 0.996193885803222656, 0.087165042757987976, 120, 255, 1, 47187), -- Holiday Snow (Area: Iceflow Lake - Difficulty: 0) +(@OGUID+130, 178609, 0, 6457, 133, '0', 0, 0, -5252.1474609375, 419.758697509765625, 389.91766357421875, 2.303830623626708984, 0, 0, 0.913544654846191406, 0.406738430261611938, 120, 255, 1, 47187), -- Holiday Snow (Area: New Tinkertown - Difficulty: 0) +(@OGUID+131, 178609, 0, 1, 0, '0', 0, 0, -5237.296875, -421.55902099609375, 389.9508056640625, 2.530723094940185546, 0, 0, 0.953716278076171875, 0.300707906484603881, 120, 255, 1, 47187), -- Holiday Snow (Area: 0 - Difficulty: 0) +(@OGUID+132, 178609, 0, 1, 0, '0', 0, 0, -5226.89599609375, -573.154541015625, 404.715606689453125, 2.583080768585205078, 0, 0, 0.961260795593261718, 0.275640487670898437, 120, 255, 1, 47187), -- Holiday Snow (Area: 0 - Difficulty: 0) +(@OGUID+133, 178609, 0, 1, 0, '0', 0, 0, -5146.15625, -729.77777099609375, 456.0533447265625, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 47187), -- Holiday Snow (Area: 0 - Difficulty: 0) +(@OGUID+134, 178609, 0, 1, 0, '0', 0, 0, -5254.10498046875, -756.67340087890625, 390.618682861328125, 6.161012649536132812, 0, 0, -0.06104850769042968, 0.998134791851043701, 120, 255, 1, 47187), -- Holiday Snow (Area: 0 - Difficulty: 0) +(@OGUID+135, 178609, 0, 1, 0, '0', 0, 0, -5546.71923828125, -1085.05078125, 391.720733642578125, 5.393068790435791015, 0, 0, -0.43051052093505859, 0.902585566043853759, 120, 255, 1, 47187), -- Holiday Snow (Area: 0 - Difficulty: 0) +(@OGUID+136, 178609, 0, 1, 0, '0', 0, 0, -5485.08837890625, -781.1610107421875, 398.714385986328125, 0.122172988951206207, 0, 0, 0.061048507690429687, 0.998134791851043701, 120, 255, 1, 47187), -- Holiday Snow (Area: 0 - Difficulty: 0) +(@OGUID+137, 178609, 0, 1, 189, '0', 0, 0, -5549.8330078125, -691.1405029296875, 410.252044677734375, 4.572763919830322265, 0, 0, -0.75470924377441406, 0.656059443950653076, 120, 255, 1, 47187), -- Holiday Snow (Area: Steelgrill's Depot - Difficulty: 0) +(@OGUID+138, 178609, 0, 1, 5097, '0', 0, 0, -5749.21044921875, -889.4140625, 400.81298828125, 4.415683269500732421, 0, 0, -0.80385684967041015, 0.594822824001312255, 120, 255, 1, 47187), -- Holiday Snow (Area: Frostmane Front - Difficulty: 0) +(@OGUID+139, 178609, 0, 1, 5098, '0', 0, 0, -5815.68603515625, -979.01739501953125, 394.591705322265625, 5.969027042388916015, 0, 0, -0.1564340591430664, 0.987688362598419189, 120, 255, 1, 47187), -- Holiday Snow (Area: Frostmane Retreat - Difficulty: 0) +(@OGUID+140, 178609, 0, 1, 5098, '0', 0, 0, -5844.0595703125, -1111.941162109375, 382.044281005859375, 1.169368624687194824, 0, 0, 0.551936149597167968, 0.833886384963989257, 120, 255, 1, 47187), -- Holiday Snow (Area: Frostmane Retreat - Difficulty: 0) +(@OGUID+141, 178609, 0, 1, 5098, '0', 0, 0, -5769.2431640625, -1064.0113525390625, 385.514251708984375, 0.977383077144622802, 0, 0, 0.469470977783203125, 0.882947921752929687, 120, 255, 1, 47187), -- Holiday Snow (Area: Frostmane Retreat - Difficulty: 0) +(@OGUID+142, 178609, 0, 1, 5098, '0', 0, 0, -5692.23974609375, -1009.01910400390625, 394.833984375, 4.48549652099609375, 0, 0, -0.7826080322265625, 0.622514784336090087, 120, 255, 1, 47187), -- Holiday Snow (Area: Frostmane Retreat - Difficulty: 0) +(@OGUID+143, 178609, 0, 1, 5098, '0', 0, 0, -5659.76806640625, -957.59375, 403.15899658203125, 3.577930212020874023, 0, 0, -0.97629547119140625, 0.216442063450813293, 120, 255, 1, 47187), -- Holiday Snow (Area: Frostmane Retreat - Difficulty: 0) +(@OGUID+144, 178609, 0, 1, 0, '0', 0, 0, -5486.60009765625, -1269.9200439453125, 447.42999267578125, 5.89921426773071289, 0, 0, -0.19080829620361328, 0.981627285480499267, 120, 255, 1, 47187), -- Holiday Snow (Area: 0 - Difficulty: 0) +(@OGUID+145, 178609, 0, 1, 803, '0', 0, 0, -5517.8212890625, -1455.279541015625, 407.683746337890625, 5.84685373306274414, 0, 0, -0.21643924713134765, 0.976296067237854003, 120, 255, 1, 47187), -- Holiday Snow (Area: Amberstill Ranch - Difficulty: 0) +(@OGUID+146, 178609, 0, 1, 803, '0', 0, 0, -5661.1484375, -1469.6278076171875, 401.62286376953125, 4.555310726165771484, 0, 0, -0.76040554046630859, 0.649448513984680175, 120, 255, 1, 47187), -- Holiday Snow (Area: Amberstill Ranch - Difficulty: 0) +(@OGUID+147, 178609, 0, 1, 804, '0', 0, 0, -5852.72900390625, -1410.842041015625, 399.67852783203125, 0.24434557557106018, 0, 0, 0.121869087219238281, 0.9925462007522583, 120, 255, 1, 47187), -- Holiday Snow (Area: The Tundrid Hills - Difficulty: 0) +(@OGUID+148, 178609, 0, 1, 803, '0', 0, 0, -5594.15087890625, -1577.1417236328125, 399.404876708984375, 3.90954136848449707, 0, 0, -0.92718315124511718, 0.37460830807685852, 120, 255, 1, 47187), -- Holiday Snow (Area: Amberstill Ranch - Difficulty: 0) +(@OGUID+149, 178609, 0, 1, 134, '0', 0, 0, -5710.580078125, -1773.19970703125, 399.98388671875, 5.427974700927734375, 0, 0, -0.41469287872314453, 0.909961462020874023, 120, 255, 1, 47187), -- Holiday Snow (Area: Gol'Bolar Quarry - Difficulty: 0) +(@OGUID+150, 178609, 0, 1, 0, '0', 0, 0, -5509.0546875, -2086.320068359375, 400.603424072265625, 3.700104713439941406, 0, 0, -0.96126079559326171, 0.275640487670898437, 120, 255, 1, 47187), -- Holiday Snow (Area: 0 - Difficulty: 0) +(@OGUID+151, 178609, 0, 1, 807, '0', 0, 0, -5270.423828125, -2170.845458984375, 423.67816162109375, 2.583080768585205078, 0, 0, 0.961260795593261718, 0.275640487670898437, 120, 255, 1, 47187), -- Holiday Snow (Area: North Gate Pass - Difficulty: 0) +(@OGUID+152, 178609, 0, 1, 716, '0', 0, 0, -5881.171875, -1729.412109375, 408.062713623046875, 1.186823248863220214, 0, 0, 0.559192657470703125, 0.829037725925445556, 120, 255, 1, 47187), -- Holiday Snow (Area: Ironband's Compound - Difficulty: 0) +(@OGUID+153, 178609, 0, 1, 0, '0', 0, 0, -5648.4716796875, -1804.0133056640625, 400.80010986328125, 5.619962215423583984, 0, 0, -0.32556724548339843, 0.945518851280212402, 120, 255, 1, 47187), -- Holiday Snow (Area: 0 - Difficulty: 0) +(@OGUID+154, 178609, 0, 1, 212, '0', 0, 0, -5719.8681640625, -1891.5052490234375, 400.663238525390625, 4.9218292236328125, 0, 0, -0.62932014465332031, 0.77714616060256958, 120, 255, 1, 47187), -- Holiday Snow (Area: Helm's Bed Lake - Difficulty: 0) +(@OGUID+155, 178609, 0, 1, 5115, '0', 0, 0, -5312.9912109375, -1595.6649169921875, 499.477935791015625, 2.583080768585205078, 0, 0, 0.961260795593261718, 0.275640487670898437, 120, 255, 1, 47187), -- Holiday Snow (Area: Ironforge Airfield - Difficulty: 0) +(@OGUID+156, 178609, 0, 1, 5115, '0', 0, 0, -4991.0224609375, -1624.8177490234375, 505.51019287109375, 2.583080768585205078, 0, 0, 0.961260795593261718, 0.275640487670898437, 120, 255, 1, 47187), -- Holiday Snow (Area: Ironforge Airfield - Difficulty: 0) +(@OGUID+157, 178609, 0, 1, 5115, '0', 0, 0, -4856.5087890625, -1684.154541015625, 503.324066162109375, 2.583080768585205078, 0, 0, 0.961260795593261718, 0.275640487670898437, 120, 255, 1, 47187), -- Holiday Snow (Area: Ironforge Airfield - Difficulty: 0) +(@OGUID+158, 178609, 0, 1, 5115, '0', 0, 0, -4719.33154296875, -1663.6129150390625, 504.794708251953125, 2.583080768585205078, 0, 0, 0.961260795593261718, 0.275640487670898437, 120, 255, 1, 47187), -- Holiday Snow (Area: Ironforge Airfield - Difficulty: 0) +(@OGUID+159, 178609, 0, 1, 5115, '0', 0, 0, -4492.1787109375, -1549.064208984375, 509.005035400390625, 2.583080768585205078, 0, 0, 0.961260795593261718, 0.275640487670898437, 120, 255, 1, 47187); -- Holiday Snow (Area: Ironforge Airfield - Difficulty: 0) + +-- 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+159; +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), +(@EVENT, @OGUID+140), +(@EVENT, @OGUID+141), +(@EVENT, @OGUID+142), +(@EVENT, @OGUID+143), +(@EVENT, @OGUID+144), +(@EVENT, @OGUID+145), +(@EVENT, @OGUID+146), +(@EVENT, @OGUID+147), +(@EVENT, @OGUID+148), +(@EVENT, @OGUID+149), +(@EVENT, @OGUID+150), +(@EVENT, @OGUID+151), +(@EVENT, @OGUID+152), +(@EVENT, @OGUID+153), +(@EVENT, @OGUID+154), +(@EVENT, @OGUID+155), +(@EVENT, @OGUID+156), +(@EVENT, @OGUID+157), +(@EVENT, @OGUID+158), +(@EVENT, @OGUID+159); |