diff options
author | Meji <alvaro.megias@outlook.com> | 2022-12-19 20:31:39 +0100 |
---|---|---|
committer | Meji <alvaro.megias@outlook.com> | 2022-12-19 20:31:39 +0100 |
commit | ef511f704074140571b32044a68e81d8cab83ad0 (patch) | |
tree | 4d11546420d5c496c88dfb8cb442cea91fe42f34 | |
parent | 424c782d033cbb0d492c85ea62056e3ff6637997 (diff) |
DB/TheExodar: Added Winter Veil spawns
-rw-r--r-- | sql/updates/world/master/2022_12_19_21_world.sql | 305 |
1 files changed, 305 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_12_19_21_world.sql b/sql/updates/world/master/2022_12_19_21_world.sql new file mode 100644 index 00000000000..245fa745823 --- /dev/null +++ b/sql/updates/world/master/2022_12_19_21_world.sql @@ -0,0 +1,305 @@ +SET @CGUID := 396654; +SET @OGUID := 251805; +SET @EVENT := 2; + +-- Creature templates +UPDATE `creature_template` SET `gossip_menu_id`=5181, `minlevel`=70, `maxlevel`=70 WHERE `entry`=23009; -- Bessbi Jinglepocket +UPDATE `creature_template` SET `gossip_menu_id`=5181, `minlevel`=70, `maxlevel`=70 WHERE `entry`=23010; -- Wolgren Jinglepocket +UPDATE `creature_template` SET `gossip_menu_id`=6813, `minlevel`=70, `maxlevel`=70, `faction`=774, `speed_walk`=1, `npcflag`=1, `unit_flags`=32768 WHERE `entry` IN (23000, 23001); -- Draenei Winter Reveler + +DELETE FROM `creature_template_addon` WHERE `entry` IN (23009, 23010); +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(23009, 0, 0, 0, 257, 0, 0, 0, 0, 0, ''), -- 23009 (Bessbi Jinglepocket) +(23010, 0, 0, 0, 257, 0, 0, 0, 0, 0, ''); -- 23010 (Wolgren Jinglepocket) + +-- Scaling +DELETE FROM `creature_template_scaling` WHERE `DifficultyID`=0 AND `Entry` IN (23010,23009); +INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES +(23009, 0, 0, 0, 417, 47187), +(23010, 0, 0, 0, 417, 47187); + +UPDATE `creature_template_scaling` SET `VerifiedBuild`=47187 WHERE (`DifficultyID`=0 AND `Entry` IN (176650,141904,118895,118892,62464,62050,61143,61081,51501,50306,47586,47570,34987,34986,30732,30716,22905,22851,21376,21019,21018,21010,21008,20914,20850,20849,20848,20847,20846,20722,20674,20121,19778,19658,19171,19073,18985,18955,18924,18921,18919,18918,18917,18916,18915,18903,18902,18901,18900,18899,18896,18892,18815,18814,18813,18812,18800,18350,18349,18348,18038,17773,17614,17584,17555,17538,17530,17520,17519,17514,17513,17512,17511,17510,17509,17505,17504,17468,17436,17435,17431,17373,17219,17216,17204,17203,17202,17201,17200,17197,17122,17121,17120,16774,16771,16768,16767,16766,16765,16764,16763,16762,16761,16757,16756,16755,16753,16752,16751,16750,16749,16748,16747,16746,16745,16743,16742,16741,16740,16739,16738,16736,16735,16734,16733,16732,16731,16729,16728,16727,16726,16725,16724,16723,16722,16721,16719,16718,16716,16715,16714,16713,16712,16710,16709,16708,16707,16706,16705,16657,16632,15384,6145,1412,883)); + +-- Vendor data +DELETE FROM `npc_vendor` WHERE (`entry`=23010 AND `item`=17344 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=23009 AND `item`=21215 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=23010 AND `item`=34413 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=23010 AND `item`=34262 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=23010 AND `item`=34319 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=23010 AND `item`=188680 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=23010 AND `item`=70923 AND `ExtendedCost`=0 AND `type`=1); +INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `ExtendedCost`, `type`, `PlayerConditionID`, `IgnoreFiltering`, `VerifiedBuild`) VALUES +(23009, 1, 21215, 0, 0, 1, 0, 0, 47187), -- Graccu's Mince Meat Fruitcake +(23010, 13, 34413, 0, 0, 1, 0, 0, 47187), -- Recipe: Hot Apple Cider +(23010, 12, 34262, 0, 0, 1, 0, 0, 47187), -- Pattern: Winter Boots +(23010, 11, 34319, 0, 0, 1, 0, 0, 47187), -- Pattern: Red Winter Clothes +(23010, 8, 188680, 0, 0, 1, 0, 0, 47187), -- Winter Veil Chorus Book +(23010, 7, 70923, 0, 0, 1, 0, 0, 47187); -- Gaudy Winter Veil Sweater + +UPDATE `npc_vendor` SET `slot`=10, `VerifiedBuild`=47187 WHERE (`entry`=23009 AND `item`=17402 AND `ExtendedCost`=0 AND `type`=1); -- Greatfather's Winter Ale +UPDATE `npc_vendor` SET `slot`=9, `VerifiedBuild`=47187 WHERE (`entry`=23009 AND `item`=17403 AND `ExtendedCost`=0 AND `type`=1); -- Steamwheedle Fizzy Spirits +UPDATE `npc_vendor` SET `slot`=8, `VerifiedBuild`=47187 WHERE (`entry`=23009 AND `item`=34410 AND `ExtendedCost`=0 AND `type`=1); -- Honeyed Holiday Ham +UPDATE `npc_vendor` SET `slot`=7, `VerifiedBuild`=47187 WHERE (`entry`=23009 AND `item`=17408 AND `ExtendedCost`=0 AND `type`=1); -- Spicy Beefstick +UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=47187 WHERE (`entry`=23009 AND `item`=17407 AND `ExtendedCost`=0 AND `type`=1); -- Graccu's Homemade Meat Pie +UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=47187 WHERE (`entry`=23009 AND `item`=17406 AND `ExtendedCost`=0 AND `type`=1); -- Holiday Cheesewheel +UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=47187 WHERE (`entry`=23009 AND `item`=34412 AND `ExtendedCost`=0 AND `type`=1); -- Sparkling Apple Cider +UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=47187 WHERE (`entry`=23009 AND `item`=17405 AND `ExtendedCost`=0 AND `type`=1); -- Green Garden Tea +UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=47187 WHERE (`entry`=23009 AND `item`=17404 AND `ExtendedCost`=0 AND `type`=1); -- Blended Bean Brew +UPDATE `npc_vendor` SET `slot`=10, `VerifiedBuild`=47187 WHERE (`entry`=23010 AND `item`=17201 AND `ExtendedCost`=0 AND `type`=1); -- Recipe: Winter Veil Egg Nog +UPDATE `npc_vendor` SET `slot`=9, `VerifiedBuild`=47187 WHERE (`entry`=23010 AND `item`=17200 AND `ExtendedCost`=0 AND `type`=1); -- Recipe: Gingerbread Cookie +UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=47187 WHERE (`entry`=23010 AND `item`=17196 AND `ExtendedCost`=0 AND `type`=1); -- Holiday Spirits +UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=47187 WHERE (`entry`=23010 AND `item`=17194 AND `ExtendedCost`=0 AND `type`=1); -- Holiday Spices +UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=47187 WHERE (`entry`=23010 AND `item`=17307 AND `ExtendedCost`=0 AND `type`=1); -- Purple Ribboned Wrapping Paper +UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=47187 WHERE (`entry`=23010 AND `item`=17304 AND `ExtendedCost`=0 AND `type`=1); -- Green Ribboned Wrapping Paper +UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=47187 WHERE (`entry`=23010 AND `item`=17303 AND `ExtendedCost`=0 AND `type`=1); -- Blue Ribboned Wrapping Paper +UPDATE `npc_vendor` SET `slot`=1, `VerifiedBuild`=47187 WHERE (`entry`=23010 AND `item`=17202 AND `ExtendedCost`=0 AND `type`=1); -- Snowball + +-- Old creature spawns +DELETE FROM `creature` WHERE `guid` IN (52022, 52023, 61700, 61702, 89415); +DELETE FROM `game_event_creature` WHERE `guid` IN (52022, 52023, 61700, 61702, 89415); + +-- Creature spawns +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+6; +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 +(@CGUID+0, 15730, 530, 3557, 0, '0', 0, 0, 0, 0, -3997.807373046875, -11908.794921875, 0.83292931318283081, 4.78220224380493164, 120, 0, 0, 152441, 0, 0, 0, 0, 0, 47187), -- Pat's Snowcloud Guy (Area: 0 - Difficulty: 0) (Auras: 26000 - Snowball Cloud) +(@CGUID+1, 15730, 530, 3557, 0, '0', 0, 0, 0, 0, -3997.986083984375, -11908.3173828125, -1.41135561466217041, 0.261799395084381103, 120, 0, 0, 152441, 0, 0, 0, 0, 0, 47187), -- Pat's Snowcloud Guy (Area: 0 - Difficulty: 0) (Auras: 26000 - Snowball Cloud) +(@CGUID+2, 15732, 530, 3557, 0, '0', 0, 0, 0, 0, -3998.21826171875, -11904.18359375, -1.34010267257690429, 3.019419670104980468, 120, 0, 0, 118565, 0, 0, 0, 0, 0, 47187), -- Wonderform Operator (Area: 0 - Difficulty: 0) +(@CGUID+3, 15760, 530, 3557, 0, '0', 0, 0, 0, 1, -3756.291748046875, -11703.857421875, -105.938941955566406, 1.2042771577835083, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 47187), -- Winter Reveler (Area: 0 - Difficulty: 0) +(@CGUID+4, 15760, 530, 3557, 0, '0', 0, 0, 0, 1, -3755.911376953125, -11698.5576171875, -105.917922973632812, 5.096361160278320312, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 47187), -- Winter Reveler (Area: 0 - Difficulty: 0) +(@CGUID+5, 23009, 530, 3557, 0, '0', 0, 0, 0, 0, -3952.76904296875, -11654.4931640625, -138.586669921875, 2.216568231582641601, 120, 0, 0, 118565, 0, 0, 0, 0, 0, 47187), -- Bessbi Jinglepocket (Area: 0 - Difficulty: 0) +(@CGUID+6, 23010, 530, 3557, 0, '0', 0, 0, 0, 0, -3953.78125, -11656.20703125, -138.6075439453125, 2.722713708877563476, 120, 0, 0, 118565, 0, 0, 0, 0, 0, 47187); -- Wolgren Jinglepocket (Area: 0 - Difficulty: 0) + +DELETE FROM `creature_addon` WHERE `guid` IN (@CGUID+3, @CGUID+4); +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+3, 0, 0, 0, 257, 0, 0, 0, 0, 0, '39858'), -- 15760 (Winter Reveler) +(@CGUID+4, 0, 0, 0, 257, 0, 0, 0, 0, 0, '39859'); -- 15760 (Winter Reveler) + +-- Old gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN 41177 AND 41186; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 41765 AND 41782; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 41940 AND 41970; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 79522 AND 79541; +DELETE FROM `gameobject` WHERE `guid` BETWEEN 79555 AND 79583; +DELETE FROM `gameobject` WHERE `guid` IN (41580, 41581, 41582, 41685, 41686); +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 41177 AND 41186; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 41765 AND 41782; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 41940 AND 41970; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 79522 AND 79541; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 79555 AND 79583; +DELETE FROM `game_event_gameobject` WHERE `guid` IN (41580, 41581, 41582, 41685, 41686); + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+101; +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, 178425, 530, 3557, 0, '0', 0, 0, -3949.435791015625, -11658.671875, -138.710800170898437, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 47187), -- Christmas Tree (Large) (Area: 0 - Difficulty: 0) +(@OGUID+1, 178428, 530, 3557, 0, '0', 0, 0, -3951.486083984375, -11658.67578125, -138.743240356445312, 4.677483558654785156, 0, 0, -0.71933937072753906, 0.694658815860748291, 120, 255, 1, 47187), -- XMasGift01 (Area: 0 - Difficulty: 0) +(@OGUID+2, 178428, 530, 3557, 0, '0', 0, 0, -3951.37841796875, -11661.3076171875, -138.976959228515625, 0.750490784645080566, 0, 0, 0.3665008544921875, 0.93041771650314331, 120, 255, 1, 47187), -- XMasGift01 (Area: 0 - Difficulty: 0) +(@OGUID+3, 178428, 530, 3557, 0, '0', 0, 0, -3953.229248046875, -11658.6201171875, -138.758071899414062, 2.426007747650146484, 0, 0, 0.936672210693359375, 0.350207358598709106, 120, 255, 1, 47187), -- XMasGift01 (Area: 0 - Difficulty: 0) +(@OGUID+4, 178429, 530, 3557, 0, '0', 0, 0, -3950.010498046875, -11652.9443359375, -138.641632080078125, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, 47187), -- XMasGift02 (Area: 0 - Difficulty: 0) +(@OGUID+5, 178429, 530, 3557, 0, '0', 0, 0, -3950.755126953125, -11660.4013671875, -138.764480590820312, 5.654868602752685546, 0, 0, -0.30901622772216796, 0.95105677843093872, 120, 255, 1, 47187), -- XMasGift02 (Area: 0 - Difficulty: 0) +(@OGUID+6, 178430, 530, 3557, 0, '0', 0, 0, -3952.515625, -11660.607421875, -138.769058227539062, 3.385940074920654296, 0, 0, -0.99254608154296875, 0.121869951486587524, 120, 255, 1, 47187), -- XMasGift03 (Area: 0 - Difficulty: 0) +(@OGUID+7, 178430, 530, 3557, 0, '0', 0, 0, -3951.28466796875, -11659.09765625, -138.331558227539062, 1.047197580337524414, 0, 0, 0.5, 0.866025388240814208, 120, 255, 1, 47187), -- XMasGift03 (Area: 0 - Difficulty: 0) +(@OGUID+8, 178430, 530, 3557, 0, '0', 0, 0, -3949.48779296875, -11653.96875, -138.63409423828125, 1.954769015312194824, 0, 0, 0.829037666320800781, 0.559192776679992675, 120, 255, 1, 47187), -- XMasGift03 (Area: 0 - Difficulty: 0) +(@OGUID+9, 178431, 530, 3557, 0, '0', 0, 0, -3950.71533203125, -11659.357421875, -138.947341918945312, 1.134462952613830566, 0, 0, 0.537299156188964843, 0.843391716480255126, 120, 255, 1, 47187), -- XMasGift04 (Area: 0 - Difficulty: 0) +(@OGUID+10, 178431, 530, 3557, 0, '0', 0, 0, -3952.3994140625, -11660.720703125, -138.464859008789062, 2.426007747650146484, 0, 0, 0.936672210693359375, 0.350207358598709106, 120, 255, 1, 47187), -- XMasGift04 (Area: 0 - Difficulty: 0) +(@OGUID+11, 178432, 530, 3557, 0, '0', 0, 0, -3952.454833984375, -11658.9599609375, -138.753189086914062, 2.70525527000427246, 0, 0, 0.97629547119140625, 0.216442063450813293, 120, 255, 1, 47187), -- XMasGift05 (Area: 0 - Difficulty: 0) +(@OGUID+12, 178432, 530, 3557, 0, '0', 0, 0, -3951.251708984375, -11654.1982421875, -138.651809692382812, 4.468043327331542968, 0, 0, -0.7880105972290039, 0.615661680698394775, 120, 255, 1, 47187), -- XMasGift05 (Area: 0 - Difficulty: 0) +(@OGUID+13, 178432, 530, 3557, 0, '0', 0, 0, -3950.486083984375, -11661.65625, -138.97955322265625, 6.073746204376220703, 0, 0, -0.10452842712402343, 0.994521915912628173, 120, 255, 1, 47187), -- XMasGift05 (Area: 0 - Difficulty: 0) +(@OGUID+14, 178433, 530, 3557, 0, '0', 0, 0, -3949.59033203125, -11660.8974609375, -138.969482421875, 4.9218292236328125, 0, 0, -0.62932014465332031, 0.77714616060256958, 120, 255, 1, 47187), -- XMasGift06 (Area: 0 - Difficulty: 0) +(@OGUID+15, 178433, 530, 3557, 0, '0', 0, 0, -3950.470458984375, -11653.591796875, -138.64501953125, 4.014260292053222656, 0, 0, -0.90630722045898437, 0.422619491815567016, 120, 255, 1, 47187), -- XMasGift06 (Area: 0 - Difficulty: 0) +(@OGUID+16, 178433, 530, 3557, 0, '0', 0, 0, -3953.010498046875, -11659.6357421875, -138.761489868164062, 1.815141916275024414, 0, 0, 0.788010597229003906, 0.615661680698394775, 120, 255, 1, 47187), -- XMasGift06 (Area: 0 - Difficulty: 0) +(@OGUID+17, 178554, 530, 3557, 0, '0', 0, 0, -3761.439697265625, -11695.892578125, -96.2012710571289062, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 47187), -- Mistletoe (Area: 0 - Difficulty: 0) +(@OGUID+18, 178746, 530, 3557, 0, '0', 0, 0, -3954.361083984375, -11657.5869140625, -138.704437255859375, 2.513273954391479492, 0, 0, 0.951056480407714843, 0.309017121791839599, 120, 255, 1, 47187), -- Smokywood Pastures (Area: 0 - Difficulty: 0) +(@OGUID+19, 180715, 530, 3557, 0, '0', 0, 0, -3950.9150390625, -11656.361328125, -138.652175903320312, 2.042035102844238281, 0, 0, 0.852640151977539062, 0.522498607635498046, 120, 255, 1, 47187), -- Holly Preserver (Area: 0 - Difficulty: 0) +(@OGUID+20, 180796, 530, 3557, 0, '0', 0, 0, -3999.385009765625, -11909.5634765625, -1.49831795692443847, 2.879789113998413085, 0, 0, 0.991444587707519531, 0.130528271198272705, 120, 255, 1, 47187), -- PX-238 Winter Wondervolt (Area: 0 - Difficulty: 0) +(@OGUID+21, 180797, 530, 3557, 0, '0', 0, 0, -3998.807373046875, -11910.08203125, -1.47126102447509765, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 120, 255, 1, 47187), -- PX-238 Winter Wondervolt TRAP (Area: 0 - Difficulty: 0) +(@OGUID+22, 187193, 530, 3524, 0, '0', 0, 0, -4144.75341796875, -11423.6201171875, -130.6719970703125, 3.473210096359252929, 0, 0, -0.98628520965576171, 0.165049895644187927, 120, 255, 1, 47187), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+23, 187193, 530, 3524, 0, '0', 0, 0, -4127.2099609375, -11534.9384765625, -136.012664794921875, 0.628316879272460937, 0, 0, 0.309016227722167968, 0.95105677843093872, 120, 255, 1, 47187), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+24, 187193, 530, 3524, 0, '0', 0, 0, -4105.2216796875, -11544.513671875, -135.781646728515625, 1.605701684951782226, 0, 0, 0.719339370727539062, 0.694658815860748291, 120, 255, 1, 47187), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+25, 187193, 530, 3524, 0, '0', 0, 0, -4120.4951171875, -11437.0947265625, -130.379013061523437, 4.834563255310058593, 0, 0, -0.66261959075927734, 0.748956084251403808, 120, 255, 1, 47187), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+26, 187193, 530, 3524, 0, '0', 0, 0, -4157.99853515625, -11597.3251953125, -138.910385131835937, 4.834563255310058593, 0, 0, -0.66261959075927734, 0.748956084251403808, 120, 255, 1, 47187), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+27, 187193, 530, 3524, 0, '0', 0, 0, -4129.01123046875, -11606.8251953125, -139.120803833007812, 4.206246376037597656, 0, 0, -0.86162853240966796, 0.50753939151763916, 120, 255, 1, 47187), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+28, 187193, 530, 3557, 0, '0', 0, 0, -4016.01611328125, -11510.4658203125, -141.069549560546875, 2.879789113998413085, 0, 0, 0.991444587707519531, 0.130528271198272705, 120, 255, 1, 47187), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+29, 187193, 530, 3557, 0, '0', 0, 0, -4030.150146484375, -11520.591796875, -141.262283325195312, 1.658061861991882324, 0, 0, 0.737277030944824218, 0.67559051513671875, 120, 255, 1, 47187), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+30, 187193, 530, 3557, 0, '0', 0, 0, -3968.95654296875, -11453.91015625, -136.772018432617187, 1.692969322204589843, 0, 0, 0.748955726623535156, 0.662620067596435546, 120, 255, 1, 47187), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+31, 187193, 530, 3557, 0, '0', 0, 0, -3973.86279296875, -11427.123046875, -136.736160278320312, 3.839725255966186523, 0, 0, -0.93969249725341796, 0.34202045202255249, 120, 255, 1, 47187), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+32, 187193, 530, 3557, 0, '0', 0, 0, -4000.541748046875, -11392.84765625, -123.377090454101562, 3.159062385559082031, 0, 0, -0.99996185302734375, 0.008734640665352344, 120, 255, 1, 47187), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+33, 187193, 530, 3557, 0, '0', 0, 0, -4019.296875, -11367.580078125, -123.678451538085937, 4.555310726165771484, 0, 0, -0.76040554046630859, 0.649448513984680175, 120, 255, 1, 47187), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+34, 187193, 530, 3557, 0, '0', 0, 0, -3974.517333984375, -11624.7451171875, -138.87567138671875, 4.904376029968261718, 0, 0, -0.636077880859375, 0.771624863147735595, 120, 255, 1, 47187), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+35, 187193, 530, 3557, 0, '0', 0, 0, -3988.4775390625, -11651.169921875, -139.043380737304687, 0.383971005678176879, 0, 0, 0.190808296203613281, 0.981627285480499267, 120, 255, 1, 47187), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+36, 187193, 530, 3557, 0, '0', 0, 0, -3935.25341796875, -11599.67578125, -138.455047607421875, 5.654868602752685546, 0, 0, -0.30901622772216796, 0.95105677843093872, 120, 255, 1, 47187), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+37, 187193, 530, 3557, 0, '0', 0, 0, -3898.60888671875, -11445.353515625, -132.852264404296875, 0.104719325900077819, 0, 0, 0.052335739135742187, 0.998629570007324218, 120, 255, 1, 47187), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+38, 187193, 530, 3557, 0, '0', 0, 0, -3903.453125, -11420.75, -132.773666381835937, 0.191985160112380981, 0, 0, 0.095845222473144531, 0.995396256446838378, 120, 255, 1, 47187), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+39, 187193, 530, 3557, 0, '0', 0, 0, -3843.451416015625, -11503.50390625, -139.097488403320312, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 120, 255, 1, 47187), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+40, 187193, 530, 3557, 0, '0', 0, 0, -3753.63330078125, -11517.73046875, -134.326950073242187, 2.094393253326416015, 0, 0, 0.866024971008300781, 0.50000077486038208, 120, 255, 1, 47187), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+41, 187193, 530, 3557, 0, '0', 0, 0, -3732.544677734375, -11501.005859375, -134.029251098632812, 2.373644113540649414, 0, 0, 0.927183151245117187, 0.37460830807685852, 120, 255, 1, 47187), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+42, 187193, 530, 3557, 0, '0', 0, 0, -3821.1962890625, -11515.71875, -138.644241333007812, 1.518436193466186523, 0, 0, 0.6883544921875, 0.725374460220336914, 120, 255, 1, 47187), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+43, 187193, 530, 3557, 0, '0', 0, 0, -3903.50341796875, -11599.638671875, -137.785751342773437, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 120, 255, 1, 47187), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+44, 187193, 530, 3557, 0, '0', 0, 0, -3862.00341796875, -11617.357421875, -136.832565307617187, 4.939284324645996093, 0, 0, -0.6225137710571289, 0.78260880708694458, 120, 255, 1, 47187), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+45, 187193, 530, 3557, 0, '0', 0, 0, -3657.604736328125, -11491.41796875, -119.097312927246093, 1.989672422409057617, 0, 0, 0.838669776916503906, 0.544640243053436279, 120, 255, 1, 47187), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+46, 187193, 530, 3557, 0, '0', 0, 0, -3640.53271484375, -11468.5869140625, -118.808647155761718, 3.019413232803344726, 0, 0, 0.998134613037109375, 0.061051756143569946, 120, 255, 1, 47187), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+47, 187193, 530, 3557, 0, '0', 0, 0, -4122.1953125, -11707.25, -142.920608520507812, 1.832594871520996093, 0, 0, 0.793353080749511718, 0.608761727809906005, 120, 255, 1, 47187), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+48, 187193, 530, 3557, 0, '0', 0, 0, -4102.17138671875, -11696.2744140625, -142.664474487304687, 2.460912704467773437, 0, 0, 0.942641258239746093, 0.333807557821273803, 120, 255, 1, 47187), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+49, 187193, 530, 3557, 0, '0', 0, 0, -4210.17578125, -11796.1630859375, -133.245193481445312, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 47187), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+50, 187193, 530, 3557, 0, '0', 0, 0, -4186.2900390625, -11803.0126953125, -133.1741943359375, 0.610863447189331054, 0, 0, 0.3007049560546875, 0.953717231750488281, 120, 255, 1, 47187), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+51, 187193, 530, 3557, 0, '0', 0, 0, -3985.045166015625, -11695.9130859375, -139.365875244140625, 5.742135047912597656, 0, 0, -0.26723766326904296, 0.96363067626953125, 120, 255, 1, 47187), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+52, 187193, 530, 3557, 0, '0', 0, 0, -3970.779541015625, -11722.8818359375, -138.835647583007812, 1.518436193466186523, 0, 0, 0.6883544921875, 0.725374460220336914, 120, 255, 1, 47187), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+53, 187193, 530, 3557, 0, '0', 0, 0, -3929.12841796875, -11744.81640625, -138.612197875976562, 0.628316879272460937, 0, 0, 0.309016227722167968, 0.95105677843093872, 120, 255, 1, 47187), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+54, 187235, 530, 3524, 0, '0', 0, 0, -4150.38720703125, -11469.783203125, -130.922622680664062, 2.70525527000427246, 0, 0, 0.97629547119140625, 0.216442063450813293, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+55, 187235, 530, 3524, 0, '0', 0, 0, -4149.005859375, -11480.560546875, -130.89447021484375, 5.89921426773071289, 0, 0, -0.19080829620361328, 0.981627285480499267, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+56, 187235, 530, 3524, 0, '0', 0, 0, -4196.21484375, -11595.271484375, -125.408432006835937, 1.239183306694030761, 0, 0, 0.580702781677246093, 0.814115643501281738, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+57, 187235, 530, 3524, 0, '0', 0, 0, -4180.39453125, -11586.9951171875, -123.979927062988281, 5.619962215423583984, 0, 0, -0.32556724548339843, 0.945518851280212402, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+58, 187235, 530, 3524, 0, '0', 0, 0, -4200.80908203125, -11604.302734375, -125.620033264160156, 0.471238493919372558, 0, 0, 0.233445167541503906, 0.972369968891143798, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+59, 187235, 530, 3524, 0, '0', 0, 0, -4229.96484375, -11608.4189453125, -126.282623291015625, 0.837757468223571777, 0, 0, 0.406736373901367187, 0.913545548915863037, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+60, 187235, 530, 3524, 0, '0', 0, 0, -4207.48583984375, -11645.037109375, -143.676971435546875, 0.104719325900077819, 0, 0, 0.052335739135742187, 0.998629570007324218, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+61, 187235, 530, 3524, 0, '0', 0, 0, -4225.97265625, -11648.0830078125, -143.864120483398437, 5.881760597229003906, 0, 0, -0.19936752319335937, 0.979924798011779785, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+62, 187235, 530, 3524, 0, '0', 0, 0, -4155.24072265625, -11635.466796875, -98.1755752563476562, 5.375615119934082031, 0, 0, -0.4383707046508789, 0.898794233798980712, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+63, 187235, 530, 3524, 0, '0', 0, 0, -4185.56689453125, -11653.0595703125, -143.44879150390625, 5.044002056121826171, 0, 0, -0.58070278167724609, 0.814115643501281738, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+64, 187235, 530, 3524, 0, '0', 0, 0, -4167.5556640625, -11641.123046875, -98.3939971923828125, 1.134462952613830566, 0, 0, 0.537299156188964843, 0.843391716480255126, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+65, 187235, 530, 3524, 0, '0', 0, 0, -4244.82373046875, -11657.95703125, -143.624862670898437, 1.727874636650085449, 0, 0, 0.760405540466308593, 0.649448513984680175, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+66, 187235, 530, 3524, 0, '0', 0, 0, -4209.63818359375, -11675.4228515625, -143.244140625, 5.89921426773071289, 0, 0, -0.19080829620361328, 0.981627285480499267, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+67, 187235, 530, 3524, 0, '0', 0, 0, -4163.96484375, -11666.73828125, -143.258132934570312, 4.677483558654785156, 0, 0, -0.71933937072753906, 0.694658815860748291, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+68, 187235, 530, 3524, 0, '0', 0, 0, -4072.7314453125, -11547.6689453125, -138.704299926757812, 0.977383077144622802, 0, 0, 0.469470977783203125, 0.882947921752929687, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+69, 187235, 530, 3524, 0, '0', 0, 0, -4070.251220703125, -11542.4501953125, -138.655410766601562, 4.555310726165771484, 0, 0, -0.76040554046630859, 0.649448513984680175, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+70, 187235, 530, 3557, 0, '0', 0, 0, -4040.37158203125, -11581.4111328125, -138.451919555664062, 0.680676698684692382, 0, 0, 0.333806037902832031, 0.942641794681549072, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+71, 187235, 530, 3557, 0, '0', 0, 0, -3987.21484375, -11495.4736328125, -137.14398193359375, 2.251473426818847656, 0, 0, 0.902585029602050781, 0.430511653423309326, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+72, 187235, 530, 3557, 0, '0', 0, 0, -3979.7587890625, -11500.7841796875, -137.076507568359375, 6.248279094696044921, 0, 0, -0.01745223999023437, 0.999847710132598876, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+73, 187235, 530, 3557, 0, '0', 0, 0, -4006.56689453125, -11572.7314453125, -138.041900634765625, 2.67034769058227539, 0, 0, 0.972369194030761718, 0.233448356389999389, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+74, 187235, 530, 3557, 0, '0', 0, 0, -3988.78125, -11386.52734375, -122.711898803710937, 5.305802345275878906, 0, 0, -0.46947097778320312, 0.882947921752929687, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+75, 187235, 530, 3557, 0, '0', 0, 0, -3979.865966796875, -11369.396484375, -122.542320251464843, 1.378809213638305664, 0, 0, 0.636077880859375, 0.771624863147735595, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+76, 187235, 530, 3557, 0, '0', 0, 0, -3990.306884765625, -11353.0830078125, -122.603202819824218, 5.480334281921386718, 0, 0, -0.39073085784912109, 0.920504987239837646, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+77, 187235, 530, 3557, 0, '0', 0, 0, -4008.92529296875, -11350.9833984375, -122.813980102539062, 4.206246376037597656, 0, 0, -0.86162853240966796, 0.50753939151763916, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+78, 187235, 530, 3557, 0, '0', 0, 0, -4065.592041015625, -11664.1513671875, -142.100540161132812, 0.226892471313476562, 0, 0, 0.113203048706054687, 0.993571877479553222, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+79, 187235, 530, 3557, 0, '0', 0, 0, -3905.642822265625, -11638.7509765625, -134.663406372070312, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+80, 187235, 530, 3557, 0, '0', 0, 0, -3891.189208984375, -11640.6484375, -134.49072265625, 1.291541695594787597, 0, 0, 0.60181427001953125, 0.798636078834533691, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+81, 187235, 530, 3557, 0, '0', 0, 0, -4204.8212890625, -11678.4853515625, -143.191604614257812, 0.401424884796142578, 0, 0, 0.199367523193359375, 0.979924798011779785, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+82, 187235, 530, 3557, 0, '0', 0, 0, -4178.04052734375, -11713.5400390625, -143.601715087890625, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+83, 187235, 530, 3557, 0, '0', 0, 0, -4194.7353515625, -11728.541015625, -143.45147705078125, 3.24634718894958496, 0, 0, -0.99862861633300781, 0.052353221923112869, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+84, 187235, 530, 3557, 0, '0', 0, 0, -4253.185546875, -11675.283203125, -143.764739990234375, 4.677483558654785156, 0, 0, -0.71933937072753906, 0.694658815860748291, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+85, 187235, 530, 3557, 0, '0', 0, 0, -4154.533203125, -11704.791015625, -143.31939697265625, 5.986480236053466796, 0, 0, -0.14780902862548828, 0.989015936851501464, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+86, 187235, 530, 3557, 0, '0', 0, 0, -4185.51513671875, -11746.03515625, -132.272537231445312, 3.036838293075561523, 0, 0, 0.998628616333007812, 0.052353221923112869, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+87, 187235, 530, 3557, 0, '0', 0, 0, -4228.94873046875, -11818.9404296875, -115.934478759765625, 0.802850961685180664, 0, 0, 0.390730857849121093, 0.920504987239837646, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+88, 187235, 530, 3557, 0, '0', 0, 0, -4221.80712890625, -11830.91796875, -115.895927429199218, 5.305802345275878906, 0, 0, -0.46947097778320312, 0.882947921752929687, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+89, 187235, 530, 3557, 0, '0', 0, 0, -4161.400390625, -11800.5830078125, -132.195220947265625, 4.555310726165771484, 0, 0, -0.76040554046630859, 0.649448513984680175, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+90, 187235, 530, 3557, 0, '0', 0, 0, -4065.432861328125, -11688.7900390625, -142.187881469726562, 0.383971005678176879, 0, 0, 0.190808296203613281, 0.981627285480499267, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+91, 187235, 530, 3557, 0, '0', 0, 0, -3943.486572265625, -11689.103515625, -135.289199829101562, 0.610863447189331054, 0, 0, 0.3007049560546875, 0.953717231750488281, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+92, 187235, 530, 3557, 0, '0', 0, 0, -3943.940673828125, -11674.0791015625, -135.238632202148437, 3.595378875732421875, 0, 0, -0.97437000274658203, 0.224951311945915222, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+93, 187235, 530, 3557, 0, '0', 0, 0, -3931.237060546875, -11649.388671875, -135.003005981445312, 1.710421562194824218, 0, 0, 0.754709243774414062, 0.656059443950653076, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+94, 187235, 530, 3557, 0, '0', 0, 0, -3938.107177734375, -11702.048828125, -135.276275634765625, 1.500982880592346191, 0, 0, 0.681998252868652343, 0.731353819370269775, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+95, 187235, 530, 3557, 0, '0', 0, 0, -3939.97998046875, -11660.91796875, -135.145401000976562, 3.874631166458129882, 0, 0, -0.93358039855957031, 0.358368009328842163, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+96, 187235, 530, 3557, 0, '0', 0, 0, -3919.52001953125, -11641.96875, -134.831253051757812, 0.209439441561698913, 0, 0, 0.104528427124023437, 0.994521915912628173, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+97, 187235, 530, 3557, 0, '0', 0, 0, -3928.3095703125, -11712.5419921875, -135.2059326171875, 5.148722648620605468, 0, 0, -0.53729915618896484, 0.843391716480255126, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+98, 187235, 530, 3557, 0, '0', 0, 0, -3877.953125, -11647.3515625, -134.367874145507812, 4.677483558654785156, 0, 0, -0.71933937072753906, 0.694658815860748291, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+99, 187235, 530, 3557, 0, '0', 0, 0, -4025.3291015625, -11590.40234375, -138.327667236328125, 1.762782454490661621, 0, 0, 0.771624565124511718, 0.636078238487243652, 120, 255, 1, 47187), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+100, 187567, 530, 3557, 0, '0', 0, 0, -4213.72900390625, -11685.4033203125, -130.823410034179687, 0.942476630210876464, 0, 0, 0.453989982604980468, 0.891006767749786376, 120, 255, 1, 47187), -- Hanging, Streamer - Xmas (Area: 0 - Difficulty: 0) +(@OGUID+101, 187567, 530, 3557, 0, '0', 0, 0, -4145.79931640625, -11745.6220703125, -124.152946472167968, 2.024578809738159179, 0, 0, 0.848047256469726562, 0.529920578002929687, 120, 255, 1, 47187); -- Hanging, Streamer - Xmas (Area: 0 - Difficulty: 0) + +-- Event spawns +DELETE FROM `game_event_creature` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @CGUID+0 AND @CGUID+6; +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), +(@EVENT, @CGUID+6); + +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @OGUID+0 AND @OGUID+101; +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); |