diff options
| -rw-r--r-- | sql/updates/world/master/2022_12_19_16_world.sql | 334 |
1 files changed, 334 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_12_19_16_world.sql b/sql/updates/world/master/2022_12_19_16_world.sql new file mode 100644 index 00000000000..07d0840256d --- /dev/null +++ b/sql/updates/world/master/2022_12_19_16_world.sql @@ -0,0 +1,334 @@ +SET @CGUID := 396633; +SET @OGUID := 251228; +SET @EVENT := 2; + +-- 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 +-- Goldshire +(@CGUID+0, 15760, 0, 12, 18, '0', 0, 0, 0, 1, -9468.3271484375, 24.92952537536621093, 56.53693389892578125, 6.091198921203613281, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 47187), -- Winter Reveler (Area: Crystal Lake - Difficulty: 0) (Auras: ) +(@CGUID+1, 15760, 0, 12, 18, '0', 0, 0, 0, 1, -9465.9326171875, 24.93549346923828125, 56.612640380859375, 3.124139308929443359, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 47187); -- Winter Reveler (Area: Crystal Lake - Difficulty: 0) (Auras: ) + +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, '26239'), -- 15760 (Winter Reveler) +(@CGUID+1, 0, 0, 0, 257, 0, 0, 0, 0, 0, '26240'); -- 15760 (Winter Reveler) + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+149; +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 +-- Goldshire +(@OGUID+0, 178425, 0, 12, 18, '0', 0, 0, -9444.115234375, 39.89973831176757812, 57.90218734741210937, 1.954769015312194824, 0, 0, 0.829037666320800781, 0.559192776679992675, 120, 255, 1, 47187), -- Christmas Tree (Large) (Area: Crystal Lake - Difficulty: 0) +(@OGUID+1, 178428, 0, 12, 18, '0', 0, 0, -9445.1220703125, 38.32107162475585937, 58.06099319458007812, 0.331610709428787231, 0, 0, 0.16504669189453125, 0.986285746097564697, 120, 255, 1, 47187), -- XMasGift01 (Area: Crystal Lake - Difficulty: 0) +(@OGUID+2, 178428, 0, 12, 18, '0', 0, 0, -9443.720703125, 40.93901824951171875, 58.61510467529296875, 1.308995485305786132, 0, 0, 0.608760833740234375, 0.793353796005249023, 120, 255, 1, 47187), -- XMasGift01 (Area: Crystal Lake - Difficulty: 0) +(@OGUID+3, 178428, 0, 12, 18, '0', 0, 0, -9441.794921875, 37.98079299926757812, 57.97368240356445312, 4.45059061050415039, 0, 0, -0.79335308074951171, 0.608761727809906005, 120, 255, 1, 47187), -- XMasGift01 (Area: Crystal Lake - Difficulty: 0) +(@OGUID+4, 178428, 0, 12, 87, '0', 0, 0, -9445.4921875, 42.26931381225585937, 57.66164016723632812, 1.623155713081359863, 0, 0, 0.725374221801757812, 0.688354730606079101, 120, 255, 1, 47187), -- XMasGift01 (Area: Goldshire - Difficulty: 0) +(@OGUID+5, 178428, 0, 12, 87, '0', 0, 0, -9441.8916015625, 40.01020050048828125, 57.73328399658203125, 3.22885894775390625, 0, 0, -0.99904823303222656, 0.043619260191917419, 120, 255, 1, 47187), -- XMasGift01 (Area: Goldshire - Difficulty: 0) +(@OGUID+6, 178429, 0, 12, 18, '0', 0, 0, -9444.791015625, 40.95182418823242187, 57.820068359375, 4.014260292053222656, 0, 0, -0.90630722045898437, 0.422619491815567016, 120, 255, 1, 47187), -- XMasGift02 (Area: Crystal Lake - Difficulty: 0) +(@OGUID+7, 178429, 0, 12, 18, '0', 0, 0, -9446.751953125, 41.19015884399414062, 57.55978012084960937, 4.939284324645996093, 0, 0, -0.6225137710571289, 0.78260880708694458, 120, 255, 1, 47187), -- XMasGift02 (Area: Crystal Lake - Difficulty: 0) +(@OGUID+8, 178429, 0, 12, 18, '0', 0, 0, -9444.4658203125, 39.087890625, 57.90789031982421875, 6.14356088638305664, 0, 0, -0.06975555419921875, 0.997564136981964111, 120, 255, 1, 47187), -- XMasGift02 (Area: Crystal Lake - Difficulty: 0) +(@OGUID+9, 178429, 0, 12, 18, '0', 0, 0, -9442.6494140625, 40.95100784301757812, 57.66923904418945312, 5.026549339294433593, 0, 0, -0.5877847671508789, 0.809017360210418701, 120, 255, 1, 47187), -- XMasGift02 (Area: Crystal Lake - Difficulty: 0) +(@OGUID+10, 178429, 0, 12, 87, '0', 0, 0, -9443.8525390625, 40.98654556274414062, 57.74723434448242187, 5.759587764739990234, 0, 0, -0.25881862640380859, 0.965925931930541992, 120, 255, 1, 47187), -- XMasGift02 (Area: Goldshire - Difficulty: 0) +(@OGUID+11, 178430, 0, 12, 18, '0', 0, 0, -9445.2080078125, 38.51123046875, 57.73225784301757812, 0.15707901120185852, 0, 0, 0.078458786010742187, 0.996917366981506347, 120, 255, 1, 47187), -- XMasGift03 (Area: Crystal Lake - Difficulty: 0) +(@OGUID+12, 178430, 0, 12, 18, '0', 0, 0, -9443.3046875, 38.84299087524414062, 57.95232009887695312, 0.418878614902496337, 0, 0, 0.207911491394042968, 0.978147625923156738, 120, 255, 1, 47187), -- XMasGift03 (Area: Crystal Lake - Difficulty: 0) +(@OGUID+13, 178430, 0, 12, 18, '0', 0, 0, -9446.1923828125, 39.61859893798828125, 57.6081085205078125, 0.680676698684692382, 0, 0, 0.333806037902832031, 0.942641794681549072, 120, 255, 1, 47187), -- XMasGift03 (Area: Crystal Lake - Difficulty: 0) +(@OGUID+14, 178430, 0, 12, 18, '0', 0, 0, -9445.8212890625, 43.17936325073242187, 57.60425567626953125, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 47187), -- XMasGift03 (Area: Crystal Lake - Difficulty: 0) +(@OGUID+15, 178430, 0, 12, 18, '0', 0, 0, -9443.3984375, 41.89046096801757812, 57.55540847778320312, 1.134462952613830566, 0, 0, 0.537299156188964843, 0.843391716480255126, 120, 255, 1, 47187), -- XMasGift03 (Area: Crystal Lake - Difficulty: 0) +(@OGUID+16, 178431, 0, 12, 18, '0', 0, 0, -9442.8818359375, 37.73844528198242187, 57.92088699340820312, 1.989672422409057617, 0, 0, 0.838669776916503906, 0.544640243053436279, 120, 255, 1, 47187), -- XMasGift04 (Area: Crystal Lake - Difficulty: 0) +(@OGUID+17, 178431, 0, 12, 18, '0', 0, 0, -9442.5458984375, 39.36539840698242187, 57.84820556640625, 3.316144466400146484, 0, 0, -0.99619388580322265, 0.087165042757987976, 120, 255, 1, 47187), -- XMasGift04 (Area: Crystal Lake - Difficulty: 0) +(@OGUID+18, 178431, 0, 12, 18, '0', 0, 0, -9445.5908203125, 41.3056640625, 57.78420639038085937, 5.515241622924804687, 0, 0, -0.37460613250732421, 0.927184045314788818, 120, 255, 1, 47187), -- XMasGift04 (Area: Crystal Lake - Difficulty: 0) +(@OGUID+19, 178431, 0, 12, 18, '0', 0, 0, -9447.08984375, 43.00542449951171875, 57.74376296997070312, 2.757613182067871093, 0, 0, 0.981626510620117187, 0.190812408924102783, 120, 255, 1, 47187), -- XMasGift04 (Area: Crystal Lake - Difficulty: 0) +(@OGUID+20, 178431, 0, 12, 18, '0', 0, 0, -9441.9375, 41.13671875, 57.46078872680664062, 0.418878614902496337, 0, 0, 0.207911491394042968, 0.978147625923156738, 120, 255, 1, 47187), -- XMasGift04 (Area: Crystal Lake - Difficulty: 0) +(@OGUID+21, 178432, 0, 12, 18, '0', 0, 0, -9443.2548828125, 40.06526565551757812, 57.88167953491210937, 1.186823248863220214, 0, 0, 0.559192657470703125, 0.829037725925445556, 120, 255, 1, 47187), -- XMasGift05 (Area: Crystal Lake - Difficulty: 0) +(@OGUID+22, 178432, 0, 12, 18, '0', 0, 0, -9443.9912109375, 37.32942581176757812, 57.8717803955078125, 1.32644820213317871, 0, 0, 0.615660667419433593, 0.788011372089385986, 120, 255, 1, 47187), -- XMasGift05 (Area: Crystal Lake - Difficulty: 0) +(@OGUID+23, 178432, 0, 12, 18, '0', 0, 0, -9445.244140625, 39.79150390625, 57.81230926513671875, 1.745326757431030273, 0, 0, 0.766043663024902343, 0.642788589000701904, 120, 255, 1, 47187), -- XMasGift05 (Area: Crystal Lake - Difficulty: 0) +(@OGUID+24, 178432, 0, 12, 87, '0', 0, 0, -9444.392578125, 42.55767059326171875, 57.47611618041992187, 3.316144466400146484, 0, 0, -0.99619388580322265, 0.087165042757987976, 120, 255, 1, 47187), -- XMasGift05 (Area: Goldshire - Difficulty: 0) +(@OGUID+25, 178433, 0, 12, 18, '0', 0, 0, -9446.52734375, 42.18500518798828125, 57.67215347290039062, 2.199114561080932617, 0, 0, 0.8910064697265625, 0.453990638256072998, 120, 255, 1, 47187), -- XMasGift06 (Area: Crystal Lake - Difficulty: 0) +(@OGUID+26, 178433, 0, 12, 18, '0', 0, 0, -9442.9365234375, 36.89431381225585937, 57.9067535400390625, 4.852017402648925781, 0, 0, -0.65605831146240234, 0.754710197448730468, 120, 255, 1, 47187), -- XMasGift06 (Area: Crystal Lake - Difficulty: 0) +(@OGUID+27, 178433, 0, 12, 18, '0', 0, 0, -9441.66796875, 38.90093231201171875, 57.79515457153320312, 1.431168079376220703, 0, 0, 0.656058311462402343, 0.754710197448730468, 120, 255, 1, 47187), -- XMasGift06 (Area: Crystal Lake - Difficulty: 0) +(@OGUID+28, 178433, 0, 12, 18, '0', 0, 0, -9443.24609375, 38.65435028076171875, 58.2802886962890625, 2.600535154342651367, 0, 0, 0.963629722595214843, 0.26724100112915039, 120, 255, 1, 47187), -- XMasGift06 (Area: Crystal Lake - Difficulty: 0) +(@OGUID+29, 178433, 0, 12, 87, '0', 0, 0, -9444.4658203125, 41.58376693725585937, 57.6756744384765625, 1.064649581909179687, 0, 0, 0.507537841796875, 0.861629426479339599, 120, 255, 1, 47187), -- XMasGift06 (Area: Goldshire - Difficulty: 0) +(@OGUID+30, 178434, 0, 12, 87, '0', 0, 0, -9458.1533203125, 19.55902862548828125, 61.08723831176757812, 2.530723094940185546, 0, 0, 0.953716278076171875, 0.300707906484603881, 120, 255, 1, 47187), -- XMasStocking01 (Area: Goldshire - Difficulty: 0) +(@OGUID+31, 178434, 0, 12, 87, '0', 0, 0, -9457.912109375, 21.59608268737792968, 61.10231399536132812, 2.967041015625, 0, 0, 0.996193885803222656, 0.087165042757987976, 120, 255, 1, 47187), -- XMasStocking01 (Area: Goldshire - Difficulty: 0) +(@OGUID+32, 178434, 0, 12, 87, '0', 0, 0, -9457.4111328125, 25.05902862548828125, 61.0443878173828125, 3.054326534271240234, 0, 0, 0.999048233032226562, 0.043619260191917419, 120, 255, 1, 47187), -- XMasStocking01 (Area: Goldshire - Difficulty: 0) +(@OGUID+33, 178435, 0, 12, 87, '0', 0, 0, -9457.7705078125, 22.830078125, 61.08931350708007812, 2.914689540863037109, 0, 0, 0.993571281433105468, 0.113208353519439697, 120, 255, 1, 47187), -- XMasStocking02 (Area: Goldshire - Difficulty: 0) +(@OGUID+34, 178435, 0, 12, 18, '0', 0, 0, -9457.21484375, 27.03944206237792968, 61.03563308715820312, 3.036838293075561523, 0, 0, 0.998628616333007812, 0.052353221923112869, 120, 255, 1, 47187), -- XMasStocking02 (Area: Crystal Lake - Difficulty: 0) +(@OGUID+35, 178436, 0, 12, 87, '0', 0, 0, -9457.5380859375, 24.02191925048828125, 61.03033447265625, 2.879789113998413085, 0, 0, 0.991444587707519531, 0.130528271198272705, 120, 255, 1, 47187), -- XMasStocking03 (Area: Goldshire - Difficulty: 0) +(@OGUID+36, 178436, 0, 12, 87, '0', 0, 0, -9458.04296875, 20.61246681213378906, 61.11035919189453125, 2.827429771423339843, 0, 0, 0.987688064575195312, 0.156436234712600708, 120, 255, 1, 47187), -- XMasStocking03 (Area: Goldshire - Difficulty: 0) +(@OGUID+37, 178436, 0, 12, 18, '0', 0, 0, -9457.2548828125, 26.12326431274414062, 61.0227203369140625, 2.914689540863037109, 0, 0, 0.993571281433105468, 0.113208353519439697, 120, 255, 1, 47187), -- XMasStocking03 (Area: Crystal Lake - Difficulty: 0) +(@OGUID+38, 178437, 0, 12, 18, '0', 0, 0, -9471.3662109375, 42.11333465576171875, 66.616546630859375, 1.466075778007507324, 0, 0, 0.669130325317382812, 0.74314504861831665, 120, 255, 1, 47187), -- Wreath (Area: Crystal Lake - Difficulty: 0) +(@OGUID+39, 178438, 0, 12, 87, '0', 0, 0, -9477.2119140625, 10.90625, 62.08132553100585937, 4.59021615982055664, 0, 0, -0.74895572662353515, 0.662620067596435546, 120, 255, 1, 47187), -- Lights (Area: Goldshire - Difficulty: 0) +(@OGUID+40, 178438, 0, 12, 87, '0', 0, 0, -9471.181640625, 7.771593093872070312, 62.0532379150390625, 3.001946926116943359, 0, 0, 0.997563362121582031, 0.069766148924827575, 120, 255, 1, 47187), -- Lights (Area: Goldshire - Difficulty: 0) +(@OGUID+41, 178438, 0, 12, 87, '0', 0, 0, -9475.4658203125, 9.100694656372070312, 66.97652435302734375, 4.59021615982055664, 0, 0, -0.74895572662353515, 0.662620067596435546, 120, 255, 1, 47187), -- Lights (Area: Goldshire - Difficulty: 0) +(@OGUID+42, 178438, 0, 12, 87, '0', 0, 0, -9473.4345703125, 10.46180534362792968, 62.06031036376953125, 4.572763919830322265, 0, 0, -0.75470924377441406, 0.656059443950653076, 120, 255, 1, 47187), -- Lights (Area: Goldshire - Difficulty: 0) +(@OGUID+43, 178438, 0, 12, 87, '0', 0, 0, -9457.2080078125, -5.32090997695922851, 62.04668426513671875, 6.230826377868652343, 0, 0, -0.02617645263671875, 0.999657332897186279, 120, 255, 1, 47187), -- Lights (Area: Goldshire - Difficulty: 0) +(@OGUID+44, 178438, 0, 12, 87, '0', 0, 0, -9464.359375, -9.85763931274414062, 66.98303985595703125, 4.555310726165771484, 0, 0, -0.76040554046630859, 0.649448513984680175, 120, 255, 1, 47187), -- Lights (Area: Goldshire - Difficulty: 0) +(@OGUID+45, 178438, 0, 12, 18, '0', 0, 0, -9481.21875, 15.89930534362792968, 71.832427978515625, 3.036838293075561523, 0, 0, 0.998628616333007812, 0.052353221923112869, 120, 255, 1, 47187), -- Lights (Area: Crystal Lake - Difficulty: 0) +(@OGUID+46, 178438, 0, 12, 18, '0', 0, 0, -9480.92578125, 15.61561393737792968, 62.20647048950195312, 2.967041015625, 0, 0, 0.996193885803222656, 0.087165042757987976, 120, 255, 1, 47187), -- Lights (Area: Crystal Lake - Difficulty: 0) +(@OGUID+47, 178438, 0, 12, 18, '0', 0, 0, -9480, 25.80729103088378906, 71.7806243896484375, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 47187), -- Lights (Area: Crystal Lake - Difficulty: 0) +(@OGUID+48, 178438, 0, 12, 18, '0', 0, 0, -9471.1787109375, 43.68576431274414062, 72.56285858154296875, 1.448621988296508789, 0, 0, 0.662619590759277343, 0.748956084251403808, 120, 255, 1, 47187), -- Lights (Area: Crystal Lake - Difficulty: 0) +(@OGUID+49, 178438, 0, 12, 18, '0', 0, 0, -9478.7783203125, 35.68923568725585937, 71.836395263671875, 3.036838293075561523, 0, 0, 0.998628616333007812, 0.052353221923112869, 120, 255, 1, 47187), -- Lights (Area: Crystal Lake - Difficulty: 0) +(@OGUID+50, 178438, 0, 12, 18, '0', 0, 0, -9455.8056640625, 41.36458206176757812, 60.69182586669921875, 6.14356088638305664, 0, 0, -0.06975555419921875, 0.997564136981964111, 120, 255, 1, 47187), -- Lights (Area: Crystal Lake - Difficulty: 0) +(@OGUID+51, 178438, 0, 12, 18, '0', 0, 0, -9452.90625, 31.12847328186035156, 67.20818328857421875, 6.195919513702392578, 0, 0, -0.04361915588378906, 0.999048233032226562, 120, 255, 1, 47187), -- Lights (Area: Crystal Lake - Difficulty: 0) +(@OGUID+52, 178438, 0, 12, 18, '0', 0, 0, -9459.1025390625, 44.82465362548828125, 61.92403793334960937, 1.466075778007507324, 0, 0, 0.669130325317382812, 0.74314504861831665, 120, 255, 1, 47187), -- Lights (Area: Crystal Lake - Difficulty: 0) +(@OGUID+53, 178438, 0, 12, 18, '0', 0, 0, -9453.5615234375, 29.59027862548828125, 62.01165771484375, 6.161012649536132812, 0, 0, -0.06104850769042968, 0.998134791851043701, 120, 255, 1, 47187), -- Lights (Area: Crystal Lake - Difficulty: 0) +(@OGUID+54, 178438, 0, 12, 18, '0', 0, 0, -9462.9228515625, 41.98442840576171875, 60.77596664428710937, 2.984498262405395507, 0, 0, 0.996916770935058593, 0.078466430306434631, 120, 255, 1, 47187), -- Lights (Area: Crystal Lake - Difficulty: 0) +(@OGUID+55, 178438, 0, 12, 18, '0', 0, 0, -9452.984375, 33.56076431274414062, 62.03250503540039062, 6.178466320037841796, 0, 0, -0.05233573913574218, 0.998629570007324218, 120, 255, 1, 47187), -- Lights (Area: Crystal Lake - Difficulty: 0) +(@OGUID+56, 178438, 0, 12, 87, '0', 0, 0, -9468.419921875, 85.27951812744140625, 63.64431381225585937, 3.124123096466064453, 0, 0, 0.99996185302734375, 0.008734640665352344, 120, 255, 1, 47187), -- Lights (Area: Goldshire - Difficulty: 0) +(@OGUID+57, 178438, 0, 12, 87, '0', 0, 0, -9459.7392578125, 81.3819427490234375, 66.92340850830078125, 4.764749526977539062, 0, 0, -0.6883544921875, 0.725374460220336914, 120, 255, 1, 47187), -- Lights (Area: Goldshire - Difficulty: 0) +(@OGUID+58, 178438, 0, 12, 87, '0', 0, 0, -9451.2080078125, 85.734375, 63.67786407470703125, 0.034906249493360519, 0, 0, 0.017452239990234375, 0.999847710132598876, 120, 255, 1, 47187), -- Lights (Area: Goldshire - Difficulty: 0) +(@OGUID+59, 178438, 0, 12, 87, '0', 0, 0, -9460.25390625, 105.720489501953125, 67.09110260009765625, 1.727874636650085449, 0, 0, 0.760405540466308593, 0.649448513984680175, 120, 255, 1, 47187), -- Lights (Area: Goldshire - Difficulty: 0) +(@OGUID+60, 178438, 0, 12, 87, '0', 0, 0, -9468.8681640625, 102.126739501953125, 63.6341094970703125, 3.176533222198486328, 0, 0, -0.999847412109375, 0.017469281330704689, 120, 255, 1, 47187), -- Lights (Area: Goldshire - Difficulty: 0) +(@OGUID+61, 178551, 0, 12, 87, '0', 0, 0, -9454.7255859375, 14.89192676544189453, 67.18563079833984375, 3.071766138076782226, 0, 0, 0.999390602111816406, 0.034906134009361267, 120, 255, 1, 47187), -- Lights, Broken (Area: Goldshire - Difficulty: 0) +(@OGUID+62, 178554, 0, 12, 18, '0', 0, 0, -9465.2587890625, 36.70920181274414062, 61.55350112915039062, 2.460912704467773437, 0, 0, 0.942641258239746093, 0.333807557821273803, 120, 255, 1, 47187), -- Mistletoe (Area: Crystal Lake - Difficulty: 0) +(@OGUID+63, 178645, 0, 12, 87, '0', 0, 0, -9455.6142578125, 13.03347492218017578, 62.19212722778320312, 6.161012649536132812, 0, 0, -0.06104850769042968, 0.998134791851043701, 120, 255, 1, 47187), -- Lights x3 (Area: Goldshire - Difficulty: 0) +(@OGUID+64, 178645, 0, 12, 87, '0', 0, 0, -9465.451171875, -8.79166698455810546, 62.03969955444335937, 4.572763919830322265, 0, 0, -0.75470924377441406, 0.656059443950653076, 120, 255, 1, 47187), -- Lights x3 (Area: Goldshire - Difficulty: 0) +(@OGUID+65, 178645, 0, 12, 87, '0', 0, 0, -9456.5712890625, 1.872449994087219238, 61.99785614013671875, 6.195919513702392578, 0, 0, -0.04361915588378906, 0.999048233032226562, 120, 255, 1, 47187), -- Lights x3 (Area: Goldshire - Difficulty: 0) +(@OGUID+66, 178645, 0, 12, 87, '0', 0, 0, -9472.03125, 0.649305999279022216, 62.01851272583007812, 3.019413232803344726, 0, 0, 0.998134613037109375, 0.061051756143569946, 120, 255, 1, 47187), -- Lights x3 (Area: Goldshire - Difficulty: 0) +(@OGUID+67, 178645, 0, 12, 18, '0', 0, 0, -9480.021484375, 23.19140625, 62.07452392578125, 2.984498262405395507, 0, 0, 0.996916770935058593, 0.078466430306434631, 120, 255, 1, 47187), -- Lights x3 (Area: Crystal Lake - Difficulty: 0) +(@OGUID+68, 178645, 0, 12, 18, '0', 0, 0, -9478.65234375, 34.43852996826171875, 62.09535598754882812, 3.001946926116943359, 0, 0, 0.997563362121582031, 0.069766148924827575, 120, 255, 1, 47187), -- Lights x3 (Area: Crystal Lake - Difficulty: 0) +(@OGUID+69, 178645, 0, 12, 18, '0', 0, 0, -9469.841796875, 40.45903778076171875, 62.0731353759765625, 1.431168079376220703, 0, 0, 0.656058311462402343, 0.754710197448730468, 120, 255, 1, 47187), -- Lights x3 (Area: Crystal Lake - Difficulty: 0) +(@OGUID+70, 180844, 0, 12, 18, '0', 0, 0, -9467.17578125, 25.03097915649414062, 62.56212234497070312, 2.234017848968505859, 0, 0, 0.898793220520019531, 0.438372820615768432, 120, 255, 1, 47187), -- Mistletoe (Area: Crystal Lake - Difficulty: 0) +(@OGUID+71, 187194, 0, 12, 87, '0', 0, 0, -9451.4599609375, 22.55489921569824218, 72.5988006591796875, 6.161012649536132812, 0, 0, -0.06104850769042968, 0.998134791851043701, 120, 255, 1, 47187), -- Hanging, Streamer x3 - Xmas (Area: Goldshire - Difficulty: 0) +(@OGUID+72, 187194, 0, 12, 18, '0', 0, 0, -9481.6103515625, 26.20590019226074218, 66.60790252685546875, 3.019413232803344726, 0, 0, 0.998134613037109375, 0.061051756143569946, 120, 255, 1, 47187), -- Hanging, Streamer x3 - Xmas (Area: Crystal Lake - Difficulty: 0) +(@OGUID+73, 187194, 0, 12, 18, '0', 0, 0, -9471.4697265625, 42.14770126342773437, 68.3571014404296875, 1.48352813720703125, 0, 0, 0.675589561462402343, 0.737277925014495849, 120, 255, 1, 47187), -- Hanging, Streamer x3 - Xmas (Area: Crystal Lake - Difficulty: 0) +(@OGUID+74, 187235, 0, 12, 87, '0', 0, 0, -9378.759765625, -86.2715988159179687, 63.6305999755859375, 3.543023586273193359, 0, 0, -0.97992420196533203, 0.199370384216308593, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Goldshire - Difficulty: 0) +(@OGUID+75, 187235, 0, 12, 18, '0', 0, 0, -9461.5400390625, 46.40449905395507812, 56.60630035400390625, 0.925023794174194335, 0, 0, 0.446197509765625, 0.894934535026550292, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Crystal Lake - Difficulty: 0) +(@OGUID+76, 187235, 0, 12, 87, '0', 0, 0, -9464.5400390625, 79.2740020751953125, 57.22639846801757812, 4.764749526977539062, 0, 0, -0.6883544921875, 0.725374460220336914, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Goldshire - Difficulty: 0) +(@OGUID+77, 187235, 0, 12, 87, '0', 0, 0, -9440.6201171875, 83.82990264892578125, 57.34840011596679687, 6.09120035171508789, 0, 0, -0.09584522247314453, 0.995396256446838378, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Goldshire - Difficulty: 0) +(@OGUID+78, 187235, 0, 12, 87, '0', 0, 0, -9469.3798828125, 106.4739990234375, 57.42060089111328125, 2.303830623626708984, 0, 0, 0.913544654846191406, 0.406738430261611938, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Goldshire - Difficulty: 0) +(@OGUID+79, 187235, 0, 12, 87, '0', 0, 0, -9430.4404296875, 91.5625, 57.12900161743164062, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Goldshire - Difficulty: 0) +(@OGUID+80, 187567, 0, 12, 87, '0', 0, 0, -9382.3603515625, -82.4038009643554687, 68.33499908447265625, 4.188792228698730468, 0, 0, -0.86602497100830078, 0.50000077486038208, 120, 255, 1, 47187), -- Hanging, Streamer - Xmas (Area: Goldshire - Difficulty: 0) +(@OGUID+81, 187567, 0, 12, 18, '0', 0, 0, -9459.142578125, 44.43923568725585937, 62.14479446411132812, 1.431168079376220703, 0, 0, 0.656058311462402343, 0.754710197448730468, 120, 255, 1, 47187), -- Hanging, Streamer - Xmas (Area: Crystal Lake - Difficulty: 0) +(@OGUID+82, 187567, 0, 12, 87, '0', 0, 0, -9459.7197265625, 82.93920135498046875, 62.00790023803710937, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 47187), -- Hanging, Streamer - Xmas (Area: Goldshire - Difficulty: 0) +(@OGUID+83, 187567, 0, 12, 87, '0', 0, 0, -9464.4404296875, 104.3939971923828125, 61.94079971313476562, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 47187), -- Hanging, Streamer - Xmas (Area: Goldshire - Difficulty: 0) +-- Northshire Valley +(@OGUID+84, 187194, 0, 6170, 9, '0', 0, 0, -8845.4697265625, -193.106002807617187, 96.79720306396484375, 5.89921426773071289, 0, 0, -0.19080829620361328, 0.981627285480499267, 120, 255, 1, 47187), -- Hanging, Streamer x3 - Xmas (Area: Northshire Valley - Difficulty: 0) +(@OGUID+85, 187194, 0, 6170, 9, '0', 0, 0, -8883.8603515625, -145.600997924804687, 96.46559906005859375, 1.204277276992797851, 0, 0, 0.56640625, 0.824126183986663818, 120, 255, 1, 47187), -- Hanging, Streamer x3 - Xmas (Area: Northshire Valley - Difficulty: 0) +(@OGUID+86, 187194, 0, 6170, 9, '0', 0, 0, -8918.4697265625, -224.966995239257812, 96.75170135498046875, 4.328419685363769531, 0, 0, -0.82903671264648437, 0.559194147586822509, 120, 255, 1, 47187), -- Hanging, Streamer x3 - Xmas (Area: Northshire Valley - Difficulty: 0) +(@OGUID+87, 187194, 0, 6170, 9, '0', 0, 0, -8912.5, -139.917007446289062, 92.39129638671875, 1.972219824790954589, 0, 0, 0.83388519287109375, 0.55193793773651123, 120, 255, 1, 47187), -- Hanging, Streamer x3 - Xmas (Area: Northshire Valley - Difficulty: 0) +(@OGUID+88, 187194, 0, 6170, 9, '0', 0, 0, -8927.2900390625, -164.2239990234375, 96.701202392578125, 2.757613182067871093, 0, 0, 0.981626510620117187, 0.190812408924102783, 120, 255, 1, 47187), -- Hanging, Streamer x3 - Xmas (Area: Northshire Valley - Difficulty: 0) +(@OGUID+89, 187194, 0, 6170, 9, '0', 0, 0, -9045.75, -95.7647018432617187, 98.1027984619140625, 5.462882041931152343, 0, 0, -0.39874839782714843, 0.917060375213623046, 120, 255, 1, 47187), -- Hanging, Streamer x3 - Xmas (Area: Northshire Valley - Difficulty: 0) +(@OGUID+90, 187194, 0, 6170, 9, '0', 0, 0, -9056, -43.8862991333007812, 100.4219970703125, 0, 0, 0, 0, 1, 120, 255, 1, 47187), -- Hanging, Streamer x3 - Xmas (Area: Northshire Valley - Difficulty: 0) +(@OGUID+91, 187194, 0, 6170, 9, '0', 0, 0, -9031.66015625, 3.11560988426208496, 98.24410247802734375, 3.682650327682495117, 0, 0, -0.96362972259521484, 0.26724100112915039, 120, 255, 1, 47187), -- Hanging, Streamer x3 - Xmas (Area: Northshire Valley - Difficulty: 0) +(@OGUID+92, 187235, 0, 6170, 9, '0', 0, 0, -8861.1103515625, -225.384994506835937, 81.2628021240234375, 4.345870018005371093, 0, 0, -0.82412624359130859, 0.566406130790710449, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Northshire Valley - Difficulty: 0) +(@OGUID+93, 187235, 0, 6170, 9, '0', 0, 0, -8850.4697265625, -214.860992431640625, 81.22519683837890625, 5.95157480239868164, 0, 0, -0.16504669189453125, 0.986285746097564697, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Northshire Valley - Difficulty: 0) +(@OGUID+94, 187235, 0, 6170, 9, '0', 0, 0, -8873.830078125, -219.766006469726562, 81.5146026611328125, 4.345870018005371093, 0, 0, -0.82412624359130859, 0.566406130790710449, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Northshire Valley - Difficulty: 0) +(@OGUID+95, 187235, 0, 6170, 9, '0', 0, 0, -8839.1201171875, -179.1199951171875, 80.44170379638671875, 0.296705186367034912, 0, 0, 0.147809028625488281, 0.989015936851501464, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Northshire Valley - Difficulty: 0) +(@OGUID+96, 187235, 0, 6170, 9, '0', 0, 0, -8864.0595703125, -164.2239990234375, 80.132598876953125, 1.047197580337524414, 0, 0, 0.5, 0.866025388240814208, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Northshire Valley - Difficulty: 0) +(@OGUID+97, 187235, 0, 6170, 9, '0', 0, 0, -8895.2900390625, -178.140625, 81.57763671875, 2.023578643798828125, 0, 0, 0.847782135009765625, 0.530344665050506591, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Northshire Valley - Difficulty: 0) +(@OGUID+98, 187235, 0, 6170, 9, '0', 0, 0, -8919.03515625, -141.111114501953125, 80.81479644775390625, 1.832594871520996093, 0, 0, 0.793353080749511718, 0.608761727809906005, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Northshire Valley - Difficulty: 0) +(@OGUID+99, 187235, 0, 6170, 9, '0', 0, 0, -8906.701171875, -135.756942749023437, 80.57871246337890625, 2.216565132141113281, 0, 0, 0.894933700561523437, 0.44619917869567871, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Northshire Valley - Difficulty: 0) +(@OGUID+100, 187235, 0, 6170, 9, '0', 0, 0, -8892.1796875, -118.885002136230468, 81.95220184326171875, 3.961898565292358398, 0, 0, -0.91705989837646484, 0.398749500513076782, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Northshire Valley - Difficulty: 0) +(@OGUID+101, 187235, 0, 6170, 9, '0', 0, 0, -8916.98046875, -99.1634979248046875, 82.3654022216796875, 4.345870018005371093, 0, 0, -0.82412624359130859, 0.566406130790710449, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Northshire Valley - Difficulty: 0) +(@OGUID+102, 187235, 0, 6170, 9, '0', 0, 0, -9002.48046875, -95.6821975708007812, 85.86419677734375, 1.518436193466186523, 0, 0, 0.6883544921875, 0.725374460220336914, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Northshire Valley - Difficulty: 0) +(@OGUID+103, 187235, 0, 6170, 9, '0', 0, 0, -9039.75, -45.9766998291015625, 89.82129669189453125, 3.019413232803344726, 0, 0, 0.998134613037109375, 0.061051756143569946, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Northshire Valley - Difficulty: 0) +(@OGUID+104, 187567, 0, 6170, 9, '0', 0, 0, -8868.6201171875, -226.16900634765625, 85.459197998046875, 4.415683269500732421, 0, 0, -0.80385684967041015, 0.594822824001312255, 120, 255, 1, 47187), -- Hanging, Streamer - Xmas (Area: Northshire Valley - Difficulty: 0) +(@OGUID+105, 187567, 0, 6170, 9, '0', 0, 0, -8855.2099609375, -215.90899658203125, 86.65019989013671875, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 47187), -- Hanging, Streamer - Xmas (Area: Northshire Valley - Difficulty: 0) +(@OGUID+106, 187567, 0, 6170, 9, '0', 0, 0, -8887.2880859375, -160.319442749023437, 86.8572998046875, 4.337899684906005859, 0, 0, -0.82637691497802734, 0.563117384910583496, 120, 255, 1, 47187), -- Hanging, Streamer - Xmas (Area: Northshire Valley - Difficulty: 0) +(@OGUID+107, 187567, 0, 6170, 9, '0', 0, 0, -8914.59375, -172.024307250976562, 86.29061126708984375, 2.808602809906005859, 0, 0, 0.986171722412109375, 0.165726706385612487, 120, 255, 1, 47187), -- Hanging, Streamer - Xmas (Area: Northshire Valley - Difficulty: 0) +(@OGUID+108, 187567, 0, 6170, 9, '0', 0, 0, -8904.3798828125, -157.490997314453125, 89.565399169921875, 1.954769015312194824, 0, 0, 0.829037666320800781, 0.559192776679992675, 120, 255, 1, 47187), -- Hanging, Streamer - Xmas (Area: Northshire Valley - Difficulty: 0) +-- Eastvale Logging Camp +(@OGUID+109, 187194, 0, 12, 88, '0', 0, 0, -9443.73046875, -1401.3900146484375, 55.82149887084960937, 1.640606880187988281, 0, 0, 0.731352806091308593, 0.6819993257522583, 120, 255, 1, 47187), -- Hanging, Streamer x3 - Xmas (Area: Eastvale Logging Camp - Difficulty: 0) +(@OGUID+110, 187194, 0, 12, 88, '0', 0, 0, -9429.349609375, -1324.1400146484375, 57.23099899291992187, 2.495818138122558593, 0, 0, 0.948323249816894531, 0.317305892705917358, 120, 255, 1, 47187), -- Hanging, Streamer x3 - Xmas (Area: Eastvale Logging Camp - Difficulty: 0) +(@OGUID+111, 187194, 0, 12, 88, '0', 0, 0, -9479.7900390625, -1347.97998046875, 50.72320175170898437, 0.994837164878845214, 0, 0, 0.477158546447753906, 0.878817260265350341, 120, 255, 1, 47187), -- Hanging, Streamer x3 - Xmas (Area: Eastvale Logging Camp - Difficulty: 0) +(@OGUID+112, 187194, 0, 12, 88, '0', 0, 0, -9552.76953125, -1416.7099609375, 61.16500091552734375, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 47187), -- Hanging, Streamer x3 - Xmas (Area: Eastvale Logging Camp - Difficulty: 0) +(@OGUID+113, 187194, 0, 12, 88, '0', 0, 0, -9530.5400390625, -1220.030029296875, 51.85789871215820312, 5.672322273254394531, 0, 0, -0.3007049560546875, 0.953717231750488281, 120, 255, 1, 47187), -- Hanging, Streamer x3 - Xmas (Area: Eastvale Logging Camp - Difficulty: 0) +(@OGUID+114, 187194, 0, 12, 88, '0', 0, 0, -9493.740234375, -1201.6600341796875, 53.33589935302734375, 4.817109584808349609, 0, 0, -0.66913032531738281, 0.74314504861831665, 120, 255, 1, 47187), -- Hanging, Streamer x3 - Xmas (Area: Eastvale Logging Camp - Difficulty: 0) +(@OGUID+115, 187235, 0, 12, 88, '0', 0, 0, -9459.0498046875, -1373.6199951171875, 46.66510009765625, 1.623155713081359863, 0, 0, 0.725374221801757812, 0.688354730606079101, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Eastvale Logging Camp - Difficulty: 0) +(@OGUID+116, 187235, 0, 12, 88, '0', 0, 0, -9451.6904296875, -1371.3599853515625, 46.68970108032226562, 2.460912704467773437, 0, 0, 0.942641258239746093, 0.333807557821273803, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Eastvale Logging Camp - Difficulty: 0) +(@OGUID+117, 187235, 0, 12, 88, '0', 0, 0, -9427.8896484375, -1313.6500244140625, 49.64550018310546875, 2.583080768585205078, 0, 0, 0.961260795593261718, 0.275640487670898437, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Eastvale Logging Camp - Difficulty: 0) +(@OGUID+118, 187235, 0, 12, 88, '0', 0, 0, -9473.6396484375, -1348.72998046875, 46.18140029907226562, 1.169368624687194824, 0, 0, 0.551936149597167968, 0.833886384963989257, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Eastvale Logging Camp - Difficulty: 0) +(@OGUID+119, 187235, 0, 12, 88, '0', 0, 0, -9482.509765625, -1310.739990234375, 44.14960098266601562, 0.27925160527229309, 0, 0, 0.139172554016113281, 0.990268170833587646, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Eastvale Logging Camp - Difficulty: 0) +(@OGUID+120, 187235, 0, 12, 88, '0', 0, 0, -9521.6796875, -1368.3900146484375, 48.6118011474609375, 1.396261811256408691, 0, 0, 0.642786979675292968, 0.766044974327087402, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Eastvale Logging Camp - Difficulty: 0) +(@OGUID+121, 187235, 0, 12, 88, '0', 0, 0, -9475.76953125, -1300.4100341796875, 44.14329910278320312, 4.97418975830078125, 0, 0, -0.60876083374023437, 0.793353796005249023, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Eastvale Logging Camp - Difficulty: 0) +(@OGUID+122, 187235, 0, 12, 88, '0', 0, 0, -9549.58984375, -1415.6400146484375, 56.27159881591796875, 1.919861555099487304, 0, 0, 0.819151878356933593, 0.573576688766479492, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Eastvale Logging Camp - Difficulty: 0) +(@OGUID+123, 187235, 0, 12, 88, '0', 0, 0, -9653.3603515625, -1351.6199951171875, 49.97909927368164062, 2.199114561080932617, 0, 0, 0.8910064697265625, 0.453990638256072998, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Eastvale Logging Camp - Difficulty: 0) +(@OGUID+124, 187235, 0, 12, 88, '0', 0, 0, -9528.3095703125, -1220.0699462890625, 47.51200103759765625, 5.078907966613769531, 0, 0, -0.56640625, 0.824126183986663818, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Eastvale Logging Camp - Difficulty: 0) +(@OGUID+125, 187235, 0, 12, 88, '0', 0, 0, -9491.9501953125, -1202.6400146484375, 48.5446014404296875, 4.572763919830322265, 0, 0, -0.75470924377441406, 0.656059443950653076, 120, 255, 1, 47187), -- Standing, Exterior; Medium - Xmas (Area: Eastvale Logging Camp - Difficulty: 0) +-- Tower of Azora +(@OGUID+126, 187194, 0, 12, 91, '0', 0, 0, -9545.4697265625, -705.53802490234375, 98.1569976806640625, 0.750490784645080566, 0, 0, 0.3665008544921875, 0.93041771650314331, 120, 255, 1, 47187), -- Hanging, Streamer x3 - Xmas (Area: Tower of Azora - Difficulty: 0) +(@OGUID+127, 187194, 0, 12, 91, '0', 0, 0, -9575.3701171875, -732.1510009765625, 98.12110137939453125, 3.874631166458129882, 0, 0, -0.93358039855957031, 0.358368009328842163, 120, 255, 1, 47187), -- Hanging, Streamer x3 - Xmas (Area: Tower of Azora - Difficulty: 0) +(@OGUID+128, 187194, 0, 12, 91, '0', 0, 0, -9547.0400390625, -733.82598876953125, 98.138397216796875, 5.445427894592285156, 0, 0, -0.40673637390136718, 0.913545548915863037, 120, 255, 1, 47187), -- Hanging, Streamer x3 - Xmas (Area: Tower of Azora - Difficulty: 0) +(@OGUID+129, 187194, 0, 12, 91, '0', 0, 0, -9573.8896484375, -704.156005859375, 98.16500091552734375, 2.321286916732788085, 0, 0, 0.917059898376464843, 0.398749500513076782, 120, 255, 1, 47187), -- Hanging, Streamer x3 - Xmas (Area: Tower of Azora - Difficulty: 0) +(@OGUID+130, 187235, 0, 12, 91, '0', 0, 0, -9527.6298828125, -694.89898681640625, 61.82020187377929687, 0.715584874153137207, 0, 0, 0.350207328796386718, 0.936672210693359375, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Tower of Azora - Difficulty: 0) +(@OGUID+131, 187235, 0, 12, 91, '0', 0, 0, -9532.8603515625, -689.00299072265625, 61.83359909057617187, 0.802850961685180664, 0, 0, 0.390730857849121093, 0.920504987239837646, 120, 255, 1, 47187), -- Standing, Exterior; Medium - Xmas (Area: Tower of Azora - Difficulty: 0) +-- The Maclure Vineyards +(@OGUID+132, 187194, 0, 12, 64, '0', 0, 0, -9919.7900390625, 31.44790077209472656, 38.66180038452148437, 2.338739633560180664, 0, 0, 0.920504570007324218, 0.3907318115234375, 120, 255, 1, 47187), -- Hanging, Streamer x3 - Xmas (Area: The Maclure Vineyards - Difficulty: 0) +(@OGUID+133, 187235, 0, 12, 64, '0', 0, 0, -10005.599609375, 41.6510009765625, 34.57780075073242187, 1.047197580337524414, 0, 0, 0.5, 0.866025388240814208, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: The Maclure Vineyards - Difficulty: 0) +(@OGUID+134, 187567, 0, 12, 64, '0', 0, 0, -10008.5, 43.02080154418945312, 39.1305999755859375, 0.733038187026977539, 0, 0, 0.358367919921875, 0.933580458164215087, 120, 255, 1, 47187), -- Hanging; Streamer - Xmas (Area: The Maclure Vineyards - Difficulty: 0) +-- Westbrook Garrison +(@OGUID+135, 187194, 0, 12, 120, '0', 0, 0, -9658.1904296875, 661.2340087890625, 74.64630126953125, 2.740161895751953125, 0, 0, 0.979924201965332031, 0.199370384216308593, 120, 255, 1, 47187), -- Hanging, Streamer x3 - Xmas (Area: Westbrook Garrison - Difficulty: 0) +(@OGUID+136, 187194, 0, 12, 120, '0', 0, 0, -9640.6298828125, 701.77099609375, 74.75969696044921875, 2.72271275520324707, 0, 0, 0.978147506713867187, 0.207912087440490722, 120, 255, 1, 47187), -- Hanging, Streamer x3 - Xmas (Area: Westbrook Garrison - Difficulty: 0) +(@OGUID+137, 187235, 0, 12, 120, '0', 0, 0, -9681.8095703125, 687.28302001953125, 35.15980148315429687, 2.67034769058227539, 0, 0, 0.972369194030761718, 0.233448356389999389, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Westbrook Garrison - Difficulty: 0) +(@OGUID+138, 187235, 0, 12, 120, '0', 0, 0, -9678.900390625, 696.99102783203125, 35.19929885864257812, 3.24634718894958496, 0, 0, -0.99862861633300781, 0.052353221923112869, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Westbrook Garrison - Difficulty: 0) +(@OGUID+139, 187235, 0, 12, 120, '0', 0, 0, -9802.759765625, 690.33502197265625, 33.11209869384765625, 4.555310726165771484, 0, 0, -0.76040554046630859, 0.649448513984680175, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Westbrook Garrison - Difficulty: 0) +(@OGUID+140, 187235, 0, 12, 120, '0', 0, 0, -9813.3603515625, 694.8179931640625, 33.11209869384765625, 4.223697185516357421, 0, 0, -0.85716724395751953, 0.515038192272186279, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: Westbrook Garrison - Difficulty: 0) +(@OGUID+141, 187567, 0, 12, 120, '0', 0, 0, -9641.669921875, 678.03802490234375, 48.45780181884765625, 2.72271275520324707, 0, 0, 0.978147506713867187, 0.207912087440490722, 120, 255, 1, 47187), -- Hanging, Streamer - Xmas (Area: Westbrook Garrison - Difficulty: 0) +(@OGUID+142, 187567, 0, 12, 120, '0', 0, 0, -9789.5, 706.427001953125, 51.11819839477539062, 5.532694816589355468, 0, 0, -0.3665008544921875, 0.93041771650314331, 120, 255, 1, 47187), -- Hanging, Streamer - Xmas (Area: Westbrook Garrison - Difficulty: 0) +(@OGUID+143, 187567, 0, 12, 120, '0', 0, 0, -9789.6904296875, 724.62200927734375, 51.11819839477539062, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 120, 255, 1, 47187), -- Hanging, Streamer - Xmas (Area: Westbrook Garrison - Difficulty: 0) +(@OGUID+144, 187567, 0, 12, 120, '0', 0, 0, -9785.849609375, 715.656005859375, 51.11819839477539062, 0.017452461645007133, 0, 0, 0.008726119995117187, 0.999961912631988525, 120, 255, 1, 47187), -- Hanging, Streamer - Xmas (Area: Westbrook Garrison - Difficulty: 0) +(@OGUID+145, 187567, 0, 12, 120, '0', 0, 0, -9798.4697265625, 702.46502685546875, 51.11819839477539062, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 47187), -- Hanging, Streamer - Xmas (Area: Westbrook Garrison - Difficulty: 0) +(@OGUID+146, 187567, 0, 12, 120, '0', 0, 0, -9798.98046875, 728.34600830078125, 51.11819839477539062, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 47187), -- Hanging, Streamer - Xmas (Area: Westbrook Garrison - Difficulty: 0) +(@OGUID+147, 187567, 0, 12, 120, '0', 0, 0, -9807.91015625, 724.53802490234375, 51.11819839477539062, 2.338739633560180664, 0, 0, 0.920504570007324218, 0.3907318115234375, 120, 255, 1, 47187), -- Hanging, Streamer - Xmas (Area: Westbrook Garrison - Difficulty: 0) +(@OGUID+148, 187567, 0, 12, 120, '0', 0, 0, -9811.7099609375, 715.06097412109375, 51.11819839477539062, 3.176533222198486328, 0, 0, -0.999847412109375, 0.017469281330704689, 120, 255, 1, 47187), -- Hanging, Streamer - Xmas (Area: Westbrook Garrison - Difficulty: 0) +(@OGUID+149, 187567, 0, 12, 120, '0', 0, 0, -9807.830078125, 706.13897705078125, 51.11819839477539062, 3.94444584846496582, 0, 0, -0.92050457000732421, 0.3907318115234375, 120, 255, 1, 47187); -- Hanging, Streamer - Xmas (Area: Westbrook Garrison - 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+149; +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); |