DB/SilvermoonCity: Added Winter Veil spawns

1 files changed, 380 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_12_29_06_world.sql b/sql/updates/world/master/2022_12_29_06_world.sql
new file mode 100644
index 00000000000..c5ea48225b3
--- /dev/null
+++ b/sql/updates/world/master/2022_12_29_06_world.sql
@@ -0,0 +1,380 @@
+SET @CGUID := 396696;
+SET @OGUID := 253068;
+SET @EVENT := 2;
+
+-- Creature templates
+UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70 WHERE `entry`=23011; -- Morshelz Copperpinch
+UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70 WHERE `entry`=23012; -- Hotoppik Copperpinch
+UPDATE `creature_template` SET `gossip_menu_id`=6813, `minlevel`=70, `maxlevel`=70, `faction`=775, `speed_walk`=1, `npcflag`=1, `unit_flags`=32768 WHERE `entry` IN (22998, 22999); -- Blood Elf Winter Reveler
+
+DELETE FROM `creature_template_addon` WHERE `entry` IN (23011, 23012);
+INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES
+(23011, 0, 0, 0, 257, 0, 0, 0, 0, 0, ''), -- 23011 (Morshelz Copperpinch)
+(23012, 0, 0, 0, 257, 0, 0, 0, 0, 0, ''); -- 23012 (Hotoppik Copperpinch)
+
+-- Scaling
+DELETE FROM `creature_template_scaling` WHERE (`DifficultyID`=0 AND `Entry` IN (23012,23011));
+INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES
+(23012, 0, 0, 0, 417, 47213),
+(23011, 0, 0, 0, 417, 47213);
+
+UPDATE `creature_template_scaling` SET `VerifiedBuild`=47213 WHERE (`DifficultyID`=0 AND `Entry` IN (185632,176825,175958,175954,175433,175432,118514,118510,68276,62463,62020,62019,61080,55370,51796,51502,50988,50977,50966,50484,47588,47362,47361,47346,44129,44128,43009,40413,40405,34973,30727,30710,27946,26400,25223,25207,25202,25200,25152,25151,25150,25149,25148,23988,22867,22866,20724,20672,20087,19882,19775,19169,18951,18799,18792,18790,18782,18781,18763,18761,18744,18743,18730,18727,18724,18722,18671,18669,18668,18629,18627,18626,18563,18560,18527,18507,18504,18347,18337,18336,18303,18277,18237,18232,18231,18230,18191,18190,18189,18188,18187,18175,18174,18147,18146,18103,17845,17769,17768,17718,17717,17633,17632,17631,17630,17629,17628,17627,17213,16899,16898,16897,16802,16801,16800,16782,16780,16703,16693,16692,16691,16690,16689,16688,16687,16686,16685,16684,16683,16681,16680,16679,16678,16677,16676,16675,16674,16673,16672,16671,16670,16669,16668,16667,16666,16664,16663,16662,16661,16660,16659,16658,16656,16655,16654,16653,16652,16651,16650,16649,16648,16647,16646,16644,16643,16642,16641,16640,16639,16638,16637,16636,16635,16634,16633,16631,16629,16628,16627,16626,16625,16624,16623,16620,16619,16618,16617,16616,16615,16613,16612,16611,16610,16568,16442,16278,16273,16222,16221,16192,16191,15971,15970,15732,15730,15649,6368,6271,6145,2334));
+
+-- Vendor data
+DELETE FROM `npc_vendor` WHERE (`entry`=23012 AND `item`=17344 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=23011 AND `item`=21215 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=23012 AND `item`=188680 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=23012 AND `item`=70923 AND `ExtendedCost`=0 AND `type`=1);
+INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `ExtendedCost`, `type`, `PlayerConditionID`, `IgnoreFiltering`, `VerifiedBuild`) VALUES
+(23011, 1, 21215, 0, 0, 1, 0, 0, 47213), -- Graccu's Mince Meat Fruitcake
+(23012, 8, 188680, 0, 0, 1, 0, 0, 47213), -- Winter Veil Chorus Book
+(23012, 7, 70923, 0, 0, 1, 0, 0, 47213); -- Gaudy Winter Veil Sweater
+
+UPDATE `npc_vendor` SET `slot`=10, `VerifiedBuild`=47213 WHERE (`entry`=23011 AND `item`=17402 AND `ExtendedCost`=0 AND `type`=1); -- Greatfather's Winter Ale
+UPDATE `npc_vendor` SET `slot`=9, `VerifiedBuild`=47213 WHERE (`entry`=23011 AND `item`=17403 AND `ExtendedCost`=0 AND `type`=1); -- Steamwheedle Fizzy Spirits
+UPDATE `npc_vendor` SET `slot`=8, `VerifiedBuild`=47213 WHERE (`entry`=23011 AND `item`=34410 AND `ExtendedCost`=0 AND `type`=1); -- Honeyed Holiday Ham
+UPDATE `npc_vendor` SET `slot`=7, `VerifiedBuild`=47213 WHERE (`entry`=23011 AND `item`=17408 AND `ExtendedCost`=0 AND `type`=1); -- Spicy Beefstick
+UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=47213 WHERE (`entry`=23011 AND `item`=17407 AND `ExtendedCost`=0 AND `type`=1); -- Graccu's Homemade Meat Pie
+UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=47213 WHERE (`entry`=23011 AND `item`=17406 AND `ExtendedCost`=0 AND `type`=1); -- Holiday Cheesewheel
+UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=47213 WHERE (`entry`=23011 AND `item`=34412 AND `ExtendedCost`=0 AND `type`=1); -- Sparkling Apple Cider
+UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=47213 WHERE (`entry`=23011 AND `item`=17405 AND `ExtendedCost`=0 AND `type`=1); -- Green Garden Tea
+UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=47213 WHERE (`entry`=23011 AND `item`=17404 AND `ExtendedCost`=0 AND `type`=1); -- Blended Bean Brew
+UPDATE `npc_vendor` SET `slot`=10, `VerifiedBuild`=47213 WHERE (`entry`=23012 AND `item`=17201 AND `ExtendedCost`=0 AND `type`=1); -- Recipe: Winter Veil Egg Nog
+UPDATE `npc_vendor` SET `slot`=9, `VerifiedBuild`=47213 WHERE (`entry`=23012 AND `item`=17200 AND `ExtendedCost`=0 AND `type`=1); -- Recipe: Gingerbread Cookie
+UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=47213 WHERE (`entry`=23012 AND `item`=17196 AND `ExtendedCost`=0 AND `type`=1); -- Holiday Spirits
+UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=47213 WHERE (`entry`=23012 AND `item`=17194 AND `ExtendedCost`=0 AND `type`=1); -- Holiday Spices
+UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=47213 WHERE (`entry`=23012 AND `item`=17307 AND `ExtendedCost`=0 AND `type`=1); -- Purple Ribboned Wrapping Paper
+UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=47213 WHERE (`entry`=23012 AND `item`=17304 AND `ExtendedCost`=0 AND `type`=1); -- Green Ribboned Wrapping Paper
+UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=47213 WHERE (`entry`=23012 AND `item`=17303 AND `ExtendedCost`=0 AND `type`=1); -- Blue Ribboned Wrapping Paper
+UPDATE `npc_vendor` SET `slot`=1, `VerifiedBuild`=47213 WHERE (`entry`=23012 AND `item`=17202 AND `ExtendedCost`=0 AND `type`=1); -- Snowball
+
+-- Old creature spawns
+DELETE FROM `creature` WHERE `guid` IN (12545, 12546, 61701, 61703, 89399, 89400, 89401, 89402, 89419);
+DELETE FROM `game_event_creature` WHERE `guid` IN (12545, 12546, 61701, 61703, 89399, 89400, 89401, 89402, 89419);
+
+-- Creature spawns
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+8;
+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, 3487, 0, '0', 0, 0, 0, 0, 9346.3955078125, -7265.28271484375, 20.67976760864257812, 6.021385669708251953, 120, 0, 0, 152441, 0, 0, 0, 0, 0, 47213), -- Pat's Snowcloud Guy (Area: 0 - Difficulty: 0)
+(@CGUID+1, 15730, 530, 3487, 0, '0', 0, 0, 0, 0, 9347.09765625, -7267.9609375, 20.69140243530273437, 3.263765573501586914, 120, 0, 0, 152441, 0, 0, 0, 0, 0, 47213), -- Pat's Snowcloud Guy (Area: 0 - Difficulty: 0)
+(@CGUID+2, 15732, 530, 3430, 0, '0', 0, 0, 0, 0, 9341.158203125, -7267.78173828125, 14.63161754608154296, 4.956735134124755859, 120, 0, 0, 118565, 0, 0, 0, 0, 0, 47213), -- Wonderform Operator (Area: 0 - Difficulty: 0)
+(@CGUID+3, 15760, 530, 3487, 0, '0', 0, 0, 0, 1, 9695.95703125, -7375.55224609375, 12.00520229339599609, 0.314159274101257324, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 47213), -- Winter Reveler (Area: 0 - Difficulty: 0) (Auras: 39860 - Winter Reveler - Blood Elf Female)
+(@CGUID+4, 15760, 530, 3487, 0, '0', 0, 0, 0, 1, 9697.5830078125, -7375.00537109375, 12.00390148162841796, 3.647738218307495117, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 47213), -- Winter Reveler (Area: 0 - Difficulty: 0) (Auras: 39861 - Winter Reveler - Blood Elf Male)
+(@CGUID+5, 15760, 530, 3487, 0, '0', 0, 0, 0, 1, 9575.1796875, -7220.5546875, 16.2211761474609375, 4.607669353485107421, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 47213), -- Winter Reveler (Area: 0 - Difficulty: 0) (Auras: 39861 - Winter Reveler - Blood Elf Male)
+(@CGUID+6, 15760, 530, 3487, 0, '0', 0, 0, 0, 1, 9575.2158203125, -7222.04150390625, 16.2204437255859375, 1.745329260826110839, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 47213), -- Winter Reveler (Area: 0 - Difficulty: 0) (Auras: 39861 - Winter Reveler - Blood Elf Male)
+(@CGUID+7, 23011, 530, 3487, 0, '0', 0, 0, 0, 0, 9513.501953125, -7168.80859375, 14.18372917175292968, 0.087266460061073303, 120, 0, 0, 118565, 0, 0, 0, 0, 0, 47213), -- Morshelz Copperpinch (Area: 0 - Difficulty: 0)
+(@CGUID+8, 23012, 530, 3487, 0, '0', 0, 0, 0, 0, 9513.8349609375, -7171.76171875, 14.19439601898193359, 0.541052043437957763, 120, 0, 0, 118565, 0, 0, 0, 0, 0, 47213); -- Hotoppik Copperpinch (Area: 0 - Difficulty: 0)
+
+DELETE FROM `creature_addon` WHERE `guid` IN (@CGUID+3, @CGUID+4, @CGUID+5, @CGUID+6);
+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, '39860'), -- 15760 (Winter Reveler)
+(@CGUID+4, 0, 0, 0, 257, 0, 0, 0, 0, 0, '39861'), -- 15760 (Winter Reveler)
+(@CGUID+5, 0, 0, 0, 257, 0, 0, 0, 0, 0, '39861'), -- 15760 (Winter Reveler)
+(@CGUID+6, 0, 0, 0, 257, 0, 0, 0, 0, 0, '39861'); -- 15760 (Winter Reveler)
+
+-- Old gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 41473 AND 41487;
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 41645 AND 41650;
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 41725 AND 41730;
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 41783 AND 41800;
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 41971 AND 42034;
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 66937 AND 66955;
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 66959 AND 66963;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 41473 AND 41487;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 41645 AND 41650;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 41725 AND 41730;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 41783 AND 41800;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 41971 AND 42034;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 66937 AND 66955;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 66959 AND 66963;
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+136;
+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, 3487, 0, '0', 0, 0, 9636.919921875, -7447.30126953125, 14.6204986572265625, 2.059488296508789062, 0, 0, 0.857167243957519531, 0.515038192272186279, 120, 255, 1, 47213), -- Christmas Tree (Large) (Area: 0 - Difficulty: 0)
+(@OGUID+1, 178425, 530, 3487, 0, '0', 0, 0, 9634.822265625, -7480.6552734375, 14.43206119537353515, 1.448621988296508789, 0, 0, 0.662619590759277343, 0.748956084251403808, 120, 255, 1, 47213), -- Christmas Tree (Large) (Area: 0 - Difficulty: 0)
+(@OGUID+2, 178425, 530, 3487, 0, '0', 0, 0, 9578.134765625, -7139.62646484375, 14.25265884399414062, 6.056293010711669921, 0, 0, -0.11320304870605468, 0.993571877479553222, 120, 255, 1, 47213), -- Christmas Tree (Large) (Area: 0 - Difficulty: 0)
+(@OGUID+3, 178428, 530, 3487, 0, '0', 0, 0, 9578.5869140625, -7141.05419921875, 14.57853031158447265, 2.932138919830322265, 0, 0, 0.994521141052246093, 0.104535527527332305, 120, 255, 1, 47213), -- XMasGift01 (Area: 0 - Difficulty: 0)
+(@OGUID+4, 178428, 530, 3487, 0, '0', 0, 0, 9579.169921875, -7139.3349609375, 14.25430107116699218, 0.296705186367034912, 0, 0, 0.147809028625488281, 0.989015936851501464, 120, 255, 1, 47213), -- XMasGift01 (Area: 0 - Difficulty: 0)
+(@OGUID+5, 178428, 530, 3487, 0, '0', 0, 0, 9509.40625, -7166.89013671875, 14.09372615814208984, 6.12610626220703125, 0, 0, -0.07845878601074218, 0.996917366981506347, 120, 255, 1, 47213), -- XMasGift01 (Area: 0 - Difficulty: 0)
+(@OGUID+6, 178429, 530, 3487, 0, '0', 0, 0, 9579.0146484375, -7140.49853515625, 14.25292778015136718, 1.064649581909179687, 0, 0, 0.507537841796875, 0.861629426479339599, 120, 255, 1, 47213), -- XMasGift02 (Area: 0 - Difficulty: 0)
+(@OGUID+7, 178429, 530, 3487, 0, '0', 0, 0, 9511.345703125, -7166.55712890625, 14.09232997894287109, 2.530723094940185546, 0, 0, 0.953716278076171875, 0.300707906484603881, 120, 255, 1, 47213), -- XMasGift02 (Area: 0 - Difficulty: 0)
+(@OGUID+8, 178429, 530, 3487, 0, '0', 0, 0, 9510.025390625, -7166.09765625, 14.09081935882568359, 5.323255538940429687, 0, 0, -0.46174812316894531, 0.887011110782623291, 120, 255, 1, 47213), -- XMasGift02 (Area: 0 - Difficulty: 0)
+(@OGUID+9, 178430, 530, 3487, 0, '0', 0, 0, 9577.501953125, -7138.08740234375, 14.24698543548583984, 0.802850961685180664, 0, 0, 0.390730857849121093, 0.920504987239837646, 120, 255, 1, 47213), -- XMasGift03 (Area: 0 - Difficulty: 0)
+(@OGUID+10, 178430, 530, 3487, 0, '0', 0, 0, 9578.5166015625, -7141.15283203125, 14.25192928314208984, 3.769911527633666992, 0, 0, -0.95105648040771484, 0.309017121791839599, 120, 255, 1, 47213), -- XMasGift03 (Area: 0 - Difficulty: 0)
+(@OGUID+11, 178430, 530, 3487, 0, '0', 0, 0, 9512.2314453125, -7167.1044921875, 14.09426403045654296, 6.03883981704711914, 0, 0, -0.12186908721923828, 0.9925462007522583, 120, 255, 1, 47213), -- XMasGift03 (Area: 0 - Difficulty: 0)
+(@OGUID+12, 178431, 530, 3487, 0, '0', 0, 0, 9578.9287109375, -7138.87939453125, 14.66150760650634765, 0.959929943084716796, 0, 0, 0.461748123168945312, 0.887011110782623291, 120, 255, 1, 47213), -- XMasGift04 (Area: 0 - Difficulty: 0)
+(@OGUID+13, 178431, 530, 3487, 0, '0', 0, 0, 9577.619140625, -7140.3486328125, 14.25026607513427734, 1.710421562194824218, 0, 0, 0.754709243774414062, 0.656059443950653076, 120, 255, 1, 47213), -- XMasGift04 (Area: 0 - Difficulty: 0)
+(@OGUID+14, 178431, 530, 3487, 0, '0', 0, 0, 9510.32421875, -7166.45703125, 14.95255184173583984, 0.017452461645007133, 0, 0, 0.008726119995117187, 0.999961912631988525, 120, 255, 1, 47213), -- XMasGift04 (Area: 0 - Difficulty: 0)
+(@OGUID+15, 178432, 530, 3487, 0, '0', 0, 0, 9579.7548828125, -7137.90087890625, 14.25198078155517578, 0.034906249493360519, 0, 0, 0.017452239990234375, 0.999847710132598876, 120, 255, 1, 47213), -- XMasGift05 (Area: 0 - Difficulty: 0)
+(@OGUID+16, 178432, 530, 3487, 0, '0', 0, 0, 9577.33984375, -7139.294921875, 14.24876594543457031, 5.881760597229003906, 0, 0, -0.19936752319335937, 0.979924798011779785, 120, 255, 1, 47213), -- XMasGift05 (Area: 0 - Difficulty: 0)
+(@OGUID+17, 178432, 530, 3487, 0, '0', 0, 0, 9510.4423828125, -7166.98828125, 14.08933544158935546, 0.733038187026977539, 0, 0, 0.358367919921875, 0.933580458164215087, 120, 255, 1, 47213), -- XMasGift05 (Area: 0 - Difficulty: 0)
+(@OGUID+18, 178433, 530, 3487, 0, '0', 0, 0, 9578.625, -7138.61669921875, 14.24976444244384765, 0.628316879272460937, 0, 0, 0.309016227722167968, 0.95105677843093872, 120, 255, 1, 47213), -- XMasGift06 (Area: 0 - Difficulty: 0)
+(@OGUID+19, 178433, 530, 3487, 0, '0', 0, 0, 9576.8134765625, -7141.44775390625, 14.25002765655517578, 3.769911527633666992, 0, 0, -0.95105648040771484, 0.309017121791839599, 120, 255, 1, 47213), -- XMasGift06 (Area: 0 - Difficulty: 0)
+(@OGUID+20, 178433, 530, 3487, 0, '0', 0, 0, 9511.0517578125, -7167.54833984375, 14.09591388702392578, 2.897245407104492187, 0, 0, 0.99254608154296875, 0.121869951486587524, 120, 255, 1, 47213), -- XMasGift06 (Area: 0 - Difficulty: 0)
+(@OGUID+21, 178554, 530, 3487, 0, '0', 0, 0, 9697.595703125, -7376.72509765625, 21.66535758972167968, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 47213), -- Mistletoe (Area: 0 - Difficulty: 0)
+(@OGUID+22, 178554, 530, 3487, 0, '0', 0, 0, 9575.1650390625, -7221.81103515625, 22.08156204223632812, 2.44346022605895996, 0, 0, 0.939692497253417968, 0.34202045202255249, 120, 255, 1, 47213), -- Mistletoe (Area: 0 - Difficulty: 0)
+(@OGUID+23, 178746, 530, 3487, 0, '0', 0, 0, 9514.3408203125, -7165.06103515625, 14.09638881683349609, 0.366517573595046997, 0, 0, 0.182234764099121093, 0.98325502872467041, 120, 255, 1, 47213), -- Smokywood Pastures (Area: 0 - Difficulty: 0)
+(@OGUID+24, 180715, 530, 3487, 0, '0', 0, 0, 9501.146484375, -7158.27197265625, 16.2982330322265625, 0.959929943084716796, 0, 0, 0.461748123168945312, 0.887011110782623291, 120, 255, 1, 47213), -- Holly Preserver (Area: 0 - Difficulty: 0)
+(@OGUID+25, 180796, 530, 3430, 0, '0', 0, 0, 9346.16796875, -7266.60302734375, 14.70077323913574218, 5.235987663269042968, 0, 0, -0.5, 0.866025388240814208, 120, 255, 1, 47213), -- PX-238 Winter Wondervolt (Area: 0 - Difficulty: 0)
+(@OGUID+26, 180797, 530, 3430, 0, '0', 0, 0, 9346.11328125, -7266.64404296875, 14.70138740539550781, 5.654868602752685546, 0, 0, -0.30901622772216796, 0.95105677843093872, 120, 255, 1, 47213), -- PX-238 Winter Wondervolt TRAP (Area: 0 - Difficulty: 0)
+(@OGUID+27, 185582, 530, 3487, 0, '0', 0, 0, 9698.2705078125, -7053.01806640625, 22.76447868347167968, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 47213), -- Hanging, Square, Large - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+28, 187193, 530, 3487, 10275, '0', 0, 0, 9866.908203125, -7124.31689453125, 30.87735366821289062, 3.420850038528442382, 0, 0, -0.99026775360107421, 0.139175355434417724, 120, 255, 1, 47213), -- Standing, Giant - Xmas (Area: Court of the Sun - Difficulty: 0)
+(@OGUID+29, 187193, 530, 3487, 10275, '0', 0, 0, 9943.3173828125, -7191.94287109375, 30.87523460388183593, 4.59021615982055664, 0, 0, -0.74895572662353515, 0.662620067596435546, 120, 255, 1, 47213), -- Standing, Giant - Xmas (Area: Court of the Sun - Difficulty: 0)
+(@OGUID+30, 187193, 530, 3487, 10275, '0', 0, 0, 9880.78125, -7153.5791015625, 30.95026397705078125, 3.752462387084960937, 0, 0, -0.95371627807617187, 0.300707906484603881, 120, 255, 1, 47213), -- Standing, Giant - Xmas (Area: Court of the Sun - Difficulty: 0)
+(@OGUID+31, 187193, 530, 3487, 10275, '0', 0, 0, 9913.193359375, -7182.16259765625, 31.00981712341308593, 4.328419685363769531, 0, 0, -0.82903671264648437, 0.559194147586822509, 120, 255, 1, 47213), -- Standing, Giant - Xmas (Area: Court of the Sun - Difficulty: 0)
+(@OGUID+32, 187193, 530, 3487, 10275, '0', 0, 0, 9828.2861328125, -7261.11181640625, 26.14580726623535156, 4.310965538024902343, 0, 0, -0.83388519287109375, 0.55193793773651123, 120, 255, 1, 47213), -- Standing, Giant - Xmas (Area: Court of the Sun - Difficulty: 0)
+(@OGUID+33, 187193, 530, 3487, 10275, '0', 0, 0, 9821.5205078125, -7255.11962890625, 26.146728515625, 3.665196180343627929, 0, 0, -0.96592521667480468, 0.258821308612823486, 120, 255, 1, 47213), -- Standing, Giant - Xmas (Area: Court of the Sun - Difficulty: 0)
+(@OGUID+34, 187193, 530, 3487, 10275, '0', 0, 0, 9850.2783203125, -7378.314453125, 18.61021232604980468, 4.677483558654785156, 0, 0, -0.71933937072753906, 0.694658815860748291, 120, 255, 1, 47213), -- Standing, Giant - Xmas (Area: Court of the Sun - Difficulty: 0)
+(@OGUID+35, 187193, 530, 3487, 0, '0', 0, 0, 9806.7666015625, -7407.1630859375, 13.62633800506591796, 0.610863447189331054, 0, 0, 0.3007049560546875, 0.953717231750488281, 120, 255, 1, 47213), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+36, 187193, 530, 3487, 0, '0', 0, 0, 9806.04296875, -7431.56689453125, 13.6186838150024414, 5.515241622924804687, 0, 0, -0.37460613250732421, 0.927184045314788818, 120, 255, 1, 47213), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+37, 187193, 530, 3487, 0, '0', 0, 0, 9488.0244140625, -7427.109375, 14.27377510070800781, 0.471238493919372558, 0, 0, 0.233445167541503906, 0.972369968891143798, 120, 255, 1, 47213), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+38, 187193, 530, 3487, 0, '0', 0, 0, 9538, -7348.09033203125, 14.33662223815917968, 2.251473426818847656, 0, 0, 0.902585029602050781, 0.430511653423309326, 120, 255, 1, 47213), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+39, 187193, 530, 3487, 8619, '0', 0, 0, 9689.5703125, -7286.3583984375, 14.27481937408447265, 2.391098499298095703, 0, 0, 0.930417060852050781, 0.366502493619918823, 120, 255, 1, 47213), -- Standing, Giant - Xmas (Area: Silvermoon City Inn - Difficulty: 0)
+(@OGUID+40, 187193, 530, 3487, 0, '0', 0, 0, 9490.1279296875, -7324.17041015625, 14.36572265625, 0.331610709428787231, 0, 0, 0.16504669189453125, 0.986285746097564697, 120, 255, 1, 47213), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+41, 187193, 530, 3487, 0, '0', 0, 0, 9491.392578125, -7265.119140625, 14.32604312896728515, 4.852017402648925781, 0, 0, -0.65605831146240234, 0.754710197448730468, 120, 255, 1, 47213), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+42, 187193, 530, 3487, 0, '0', 0, 0, 9477.5703125, -7303.158203125, 14.36950206756591796, 1.047197580337524414, 0, 0, 0.5, 0.866025388240814208, 120, 255, 1, 47213), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+43, 187193, 530, 3487, 0, '0', 0, 0, 9486.740234375, -7367.53466796875, 14.359893798828125, 0.191985160112380981, 0, 0, 0.095845222473144531, 0.995396256446838378, 120, 255, 1, 47213), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+44, 187193, 530, 3487, 0, '0', 0, 0, 9662.470703125, -7240.89306640625, 14.36361408233642578, 5.166176319122314453, 0, 0, -0.52991867065429687, 0.84804844856262207, 120, 255, 1, 47213), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+45, 187193, 530, 3487, 0, '0', 0, 0, 9688.67578125, -7243.61572265625, 14.21337890625, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 47213), -- Standing, Giant - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+46, 187194, 530, 3487, 10275, '0', 0, 0, 9952.4189453125, -7232.267578125, 43.902801513671875, 2.234017848968505859, 0, 0, 0.898793220520019531, 0.438372820615768432, 120, 255, 1, 47213), -- Hanging, Streamer x3 - Xmas (Area: Court of the Sun - Difficulty: 0)
+(@OGUID+47, 187194, 530, 3487, 10275, '0', 0, 0, 9945.498046875, -7242.048828125, 43.90578460693359375, 2.792518377304077148, 0, 0, 0.984807014465332031, 0.173652306199073791, 120, 255, 1, 47213), -- Hanging; Streamer x3 - Xmas (Area: Court of the Sun - Difficulty: 0)
+(@OGUID+48, 187194, 530, 3487, 10275, '0', 0, 0, 10010.6767578125, -7199.16650390625, 44.22095489501953125, 2.478367090225219726, 0, 0, 0.94551849365234375, 0.325568377971649169, 120, 255, 1, 47213), -- Hanging, Streamer x3 - Xmas (Area: Court of the Sun - Difficulty: 0)
+(@OGUID+49, 187194, 530, 3487, 3487, '0', 0, 0, 10007.3408203125, -7030.9033203125, 57.9728546142578125, 4.066620349884033203, 0, 0, -0.89493370056152343, 0.44619917869567871, 120, 255, 1, 47213), -- Hanging, Streamer x3 - Xmas (Area: Silvermoon City - Difficulty: 0)
+(@OGUID+50, 187194, 530, 3487, 3487, '0', 0, 0, 9954.9970703125, -7098.5712890625, 59.8618927001953125, 3.996806621551513671, 0, 0, -0.90996074676513671, 0.414694398641586303, 120, 255, 1, 47213), -- Hanging, Streamer x3 - Xmas (Area: Silvermoon City - Difficulty: 0)
+(@OGUID+51, 187194, 530, 3487, 10275, '0', 0, 0, 9992.330078125, -7205.0625, 44.06254959106445312, 2.181660413742065429, 0, 0, 0.887010574340820312, 0.461749136447906494, 120, 255, 1, 47213), -- Hanging, Streamer x3 - Xmas (Area: Court of the Sun - Difficulty: 0)
+(@OGUID+52, 187194, 530, 3487, 10275, '0', 0, 0, 10002.228515625, -7202.46728515625, 44.06781768798828125, 1.466075778007507324, 0, 0, 0.669130325317382812, 0.74314504861831665, 120, 255, 1, 47213), -- Hanging, Streamer x3 - Xmas (Area: Court of the Sun - Difficulty: 0)
+(@OGUID+53, 187235, 530, 3487, 3487, '0', 0, 0, 9987.1220703125, -7093.59716796875, 47.70498275756835937, 5.253442287445068359, 0, 0, -0.49242305755615234, 0.870355963706970214, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: Silvermoon City - Difficulty: 0)
+(@OGUID+54, 187235, 530, 3487, 3487, '0', 0, 0, 9982.9716796875, -7098.82666015625, 47.704986572265625, 6.056293010711669921, 0, 0, -0.11320304870605468, 0.993571877479553222, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: Silvermoon City - Difficulty: 0)
+(@OGUID+55, 187235, 530, 3487, 10275, '0', 0, 0, 9742.1064453125, -7191.63134765625, 14.32370185852050781, 3.700104713439941406, 0, 0, -0.96126079559326171, 0.275640487670898437, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: Court of the Sun - Difficulty: 0)
+(@OGUID+56, 187235, 530, 3487, 10275, '0', 0, 0, 9784.8740234375, -7302.953125, 24.72771644592285156, 2.164205789566040039, 0, 0, 0.882946968078613281, 0.469472706317901611, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: Court of the Sun - Difficulty: 0)
+(@OGUID+57, 187235, 530, 3487, 10275, '0', 0, 0, 9760.958984375, -7298.79150390625, 24.73137283325195312, 5.550147056579589843, 0, 0, -0.358367919921875, 0.933580458164215087, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: Court of the Sun - Difficulty: 0)
+(@OGUID+58, 187235, 530, 3487, 10275, '0', 0, 0, 9775.0908203125, -7288.94775390625, 24.73641777038574218, 5.148722648620605468, 0, 0, -0.53729915618896484, 0.843391716480255126, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: Court of the Sun - Difficulty: 0)
+(@OGUID+59, 187235, 530, 3487, 10275, '0', 0, 0, 9746.0869140625, -7307.125, 24.73264122009277343, 5.183629035949707031, 0, 0, -0.52249813079833984, 0.852640450000762939, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: Court of the Sun - Difficulty: 0)
+(@OGUID+60, 187235, 530, 3487, 10275, '0', 0, 0, 9770.453125, -7313.017578125, 24.73068809509277343, 2.007128477096557617, 0, 0, 0.84339141845703125, 0.537299633026123046, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: Court of the Sun - Difficulty: 0)
+(@OGUID+61, 187235, 530, 3487, 10275, '0', 0, 0, 9746.568359375, -7174.86083984375, 14.32372570037841796, 3.263772249221801757, 0, 0, -0.99813461303710937, 0.061051756143569946, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: Court of the Sun - Difficulty: 0)
+(@OGUID+62, 187235, 530, 3487, 10275, '0', 0, 0, 9752.1796875, -7323.43408203125, 24.72894668579101562, 1.762782454490661621, 0, 0, 0.771624565124511718, 0.636078238487243652, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: Court of the Sun - Difficulty: 0)
+(@OGUID+63, 187235, 530, 3487, 10275, '0', 0, 0, 9729.4326171875, -7314.13037109375, 24.73053359985351562, 5.270895957946777343, 0, 0, -0.48480892181396484, 0.87462007999420166, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: Court of the Sun - Difficulty: 0)
+(@OGUID+64, 187235, 530, 3487, 0, '0', 0, 0, 9812.853515625, -7410.41650390625, 13.62473392486572265, 1.884953022003173828, 0, 0, 0.809016227722167968, 0.587786316871643066, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+65, 187235, 530, 3487, 0, '0', 0, 0, 9825.4296875, -7410.53125, 13.62589073181152343, 0.837757468223571777, 0, 0, 0.406736373901367187, 0.913545548915863037, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+66, 187235, 530, 3487, 0, '0', 0, 0, 9875.0166015625, -7410.7431640625, 13.58318042755126953, 2.024578809738159179, 0, 0, 0.848047256469726562, 0.529920578002929687, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+67, 187235, 530, 3487, 0, '0', 0, 0, 9875.1689453125, -7428.6328125, 13.58898735046386718, 2.251473426818847656, 0, 0, 0.902585029602050781, 0.430511653423309326, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+68, 187235, 530, 3487, 0, '0', 0, 0, 9812.9736328125, -7428.5849609375, 13.61627769470214843, 1.710421562194824218, 0, 0, 0.754709243774414062, 0.656059443950653076, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+69, 187235, 530, 3487, 0, '0', 0, 0, 9825.056640625, -7428.28466796875, 13.61859130859375, 1.466075778007507324, 0, 0, 0.669130325317382812, 0.74314504861831665, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+70, 187235, 530, 3487, 0, '0', 0, 0, 9862.4326171875, -7450.90625, 13.64516162872314453, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+71, 187235, 530, 3487, 0, '0', 0, 0, 9839.5439453125, -7451.32568359375, 13.64577388763427734, 0.24434557557106018, 0, 0, 0.121869087219238281, 0.9925462007522583, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+72, 187235, 530, 3487, 0, '0', 0, 0, 9734.25390625, -7330.13916015625, 24.72733116149902343, 1.675513744354248046, 0, 0, 0.743144035339355468, 0.669131457805633544, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+73, 187235, 530, 3487, 0, '0', 0, 0, 9699.6103515625, -7414.82666015625, 13.69888019561767578, 5.009094715118408203, 0, 0, -0.59482288360595703, 0.80385679006576538, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+74, 187235, 530, 3487, 0, '0', 0, 0, 9679.7060546875, -7394.49658203125, 11.60496330261230468, 4.747295856475830078, 0, 0, -0.69465827941894531, 0.719339847564697265, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+75, 187235, 530, 3487, 0, '0', 0, 0, 9685.9638671875, -7394.53466796875, 11.60480499267578125, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+76, 187235, 530, 3487, 0, '0', 0, 0, 9665.251953125, -7413.47216796875, 13.61098194122314453, 4.241150379180908203, 0, 0, -0.85264015197753906, 0.522498607635498046, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+77, 187235, 530, 3487, 0, '0', 0, 0, 9708.0595703125, -7493.27978515625, 13.52356338500976562, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+78, 187235, 530, 3487, 0, '0', 0, 0, 9658.8994140625, -7492.705078125, 13.52244281768798828, 1.710421562194824218, 0, 0, 0.754709243774414062, 0.656059443950653076, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+79, 187235, 530, 3487, 0, '0', 0, 0, 9583.92578125, -7473.99853515625, 13.50734996795654296, 0.418878614902496337, 0, 0, 0.207911491394042968, 0.978147625923156738, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+80, 187235, 530, 3487, 0, '0', 0, 0, 9644.8466796875, -7399.78466796875, 15.69899845123291015, 4.747295856475830078, 0, 0, -0.69465827941894531, 0.719339847564697265, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+81, 187235, 530, 3487, 0, '0', 0, 0, 9583.6611328125, -7444.984375, 13.5060577392578125, 4.642575740814208984, 0, 0, -0.731353759765625, 0.681998312473297119, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+82, 187235, 530, 3487, 0, '0', 0, 0, 9583.83984375, -7455.04150390625, 13.50669002532958984, 4.084071159362792968, 0, 0, -0.8910064697265625, 0.453990638256072998, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+83, 187235, 530, 3487, 0, '0', 0, 0, 9631.81640625, -7399.67041015625, 15.69536018371582031, 4.834563255310058593, 0, 0, -0.66261959075927734, 0.748956084251403808, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+84, 187235, 530, 3487, 0, '0', 0, 0, 9583.6904296875, -7425.88037109375, 13.51032161712646484, 4.468043327331542968, 0, 0, -0.7880105972290039, 0.615661680698394775, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+85, 187235, 530, 3487, 0, '0', 0, 0, 9520.5283203125, -7415.19970703125, 14.31464481353759765, 4.345870018005371093, 0, 0, -0.82412624359130859, 0.566406130790710449, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+86, 187235, 530, 3487, 0, '0', 0, 0, 9520.46484375, -7378.72509765625, 14.30250358581542968, 1.466075778007507324, 0, 0, 0.669130325317382812, 0.74314504861831665, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+87, 187235, 530, 3487, 0, '0', 0, 0, 9586.677734375, -7358.111328125, 13.69828605651855468, 0.558503925800323486, 0, 0, 0.275636672973632812, 0.961261868476867675, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+88, 187235, 530, 3487, 0, '0', 0, 0, 9604.375, -7358.49658203125, 13.72878932952880859, 2.548179388046264648, 0, 0, 0.956304550170898437, 0.292372345924377441, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+89, 187235, 530, 3487, 0, '0', 0, 0, 9517.861328125, -7309.908203125, 14.45531177520751953, 2.530723094940185546, 0, 0, 0.953716278076171875, 0.300707906484603881, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+90, 187235, 530, 3487, 0, '0', 0, 0, 9614.275390625, -7254.57275390625, 16.49079704284667968, 5.078907966613769531, 0, 0, -0.56640625, 0.824126183986663818, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+91, 187235, 530, 3487, 0, '0', 0, 0, 9628.28515625, -7254.4462890625, 16.49515724182128906, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+92, 187235, 530, 3487, 0, '0', 0, 0, 9542.544921875, -7251.2275390625, 16.40246009826660156, 4.136432647705078125, 0, 0, -0.87881660461425781, 0.477159708738327026, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+93, 187235, 530, 3487, 0, '0', 0, 0, 9543.12890625, -7261.28125, 14.36259269714355468, 3.996806621551513671, 0, 0, -0.90996074676513671, 0.414694398641586303, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+94, 187235, 530, 3487, 0, '0', 0, 0, 9518.1044921875, -7290.619140625, 14.38553714752197265, 3.630291461944580078, 0, 0, -0.97029495239257812, 0.241925001144409179, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+95, 187235, 530, 3487, 0, '0', 0, 0, 9520.9365234375, -7261.12158203125, 14.36340141296386718, 5.288348197937011718, 0, 0, -0.4771585464477539, 0.878817260265350341, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+96, 187235, 530, 3487, 0, '0', 0, 0, 9495.396484375, -7337.35400390625, 14.37012958526611328, 6.195919513702392578, 0, 0, -0.04361915588378906, 0.999048233032226562, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+97, 187235, 530, 3487, 0, '0', 0, 0, 9495.330078125, -7353.62353515625, 14.36368465423583984, 0.191985160112380981, 0, 0, 0.095845222473144531, 0.995396256446838378, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+98, 187235, 530, 3487, 0, '0', 0, 0, 9535.3359375, -7241.6005859375, 16.39830970764160156, 4.764749526977539062, 0, 0, -0.6883544921875, 0.725374460220336914, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+99, 187235, 530, 3487, 0, '0', 0, 0, 9521.8310546875, -7251.0400390625, 16.40246009826660156, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+100, 187235, 530, 3487, 0, '0', 0, 0, 9529.3564453125, -7241.4443359375, 16.40562248229980468, 4.747295856475830078, 0, 0, -0.69465827941894531, 0.719339847564697265, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+101, 187235, 530, 3487, 0, '0', 0, 0, 9579.7216796875, -7178.490234375, 14.23274421691894531, 1.500982880592346191, 0, 0, 0.681998252868652343, 0.731353819370269775, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+102, 187235, 530, 3487, 0, '0', 0, 0, 9556.4091796875, -7178.681640625, 14.25354385375976562, 0.261798173189163208, 0, 0, 0.130525588989257812, 0.991444945335388183, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+103, 187235, 530, 3487, 0, '0', 0, 0, 9667.486328125, -7205.58447265625, 14.31570625305175781, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+104, 187235, 530, 3487, 0, '0', 0, 0, 9687.7353515625, -7206.65673828125, 14.31048583984375, 1.692969322204589843, 0, 0, 0.748955726623535156, 0.662620067596435546, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+105, 187235, 530, 3487, 0, '0', 0, 0, 9642.193359375, -7165.24072265625, 14.32293891906738281, 1.902408957481384277, 0, 0, 0.814115524291992187, 0.580702960491180419, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+106, 187235, 530, 3487, 0, '0', 0, 0, 9654.5126953125, -7165.1171875, 14.32293701171875, 1.553341388702392578, 0, 0, 0.700908660888671875, 0.713251054286956787, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+107, 187235, 530, 3487, 0, '0', 0, 0, 9678.7958984375, -7142.30126953125, 14.32304573059082031, 5.602506637573242187, 0, 0, -0.33380699157714843, 0.942641437053680419, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+108, 187235, 530, 3487, 0, '0', 0, 0, 9678.8076171875, -7129.61181640625, 14.32299613952636718, 3.403396368026733398, 0, 0, -0.99144458770751953, 0.130528271198272705, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+109, 187235, 530, 3487, 0, '0', 0, 0, 9618.2314453125, -7141.75244140625, 14.32299327850341796, 1.413715124130249023, 0, 0, 0.649447441101074218, 0.760406434535980224, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+110, 187235, 530, 3487, 0, '0', 0, 0, 9655.0517578125, -7106.3759765625, 14.32301521301269531, 2.897245407104492187, 0, 0, 0.99254608154296875, 0.121869951486587524, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+111, 187235, 530, 3487, 0, '0', 0, 0, 9618.2001953125, -7129.26806640625, 14.32340812683105468, 4.363324165344238281, 0, 0, -0.81915187835693359, 0.573576688766479492, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+112, 187235, 530, 3487, 0, '0', 0, 0, 9642.6875, -7106.29296875, 14.32301521301269531, 5.288348197937011718, 0, 0, -0.4771585464477539, 0.878817260265350341, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+113, 187235, 530, 3487, 0, '0', 0, 0, 9720.84765625, -7098.16748046875, 14.37493610382080078, 3.298687219619750976, 0, 0, -0.99691677093505859, 0.078466430306434631, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+114, 187235, 530, 3487, 0, '0', 0, 0, 9716.240234375, -7078.56103515625, 14.36649894714355468, 1.151916384696960449, 0, 0, 0.544638633728027343, 0.838670849800109863, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+115, 187235, 530, 3487, 0, '0', 0, 0, 9688.9345703125, -7057.634765625, 14.38304996490478515, 3.874631166458129882, 0, 0, -0.93358039855957031, 0.358368009328842163, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+116, 187235, 530, 3487, 0, '0', 0, 0, 9707.404296875, -7059.029296875, 14.43247795104980468, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+117, 187235, 530, 3487, 0, '0', 0, 0, 9589.4140625, -7081.6513671875, 16.54935836791992187, 5.183629035949707031, 0, 0, -0.52249813079833984, 0.852640450000762939, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+118, 187235, 530, 3487, 0, '0', 0, 0, 9571.572265625, -7081.52490234375, 16.54362678527832031, 4.101525306701660156, 0, 0, -0.88701057434082031, 0.461749136447906494, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+119, 187567, 530, 3487, 10275, '0', 0, 0, 9757.14453125, -7186.15478515625, 23.50617790222167968, 2.897245407104492187, 0, 0, 0.99254608154296875, 0.121869951486587524, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: Court of the Sun - Difficulty: 0)
+(@OGUID+120, 187567, 530, 3487, 10275, '0', 0, 0, 9790.9453125, -7316.39306640625, 35.23556137084960937, 2.234017848968505859, 0, 0, 0.898793220520019531, 0.438372820615768432, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: Court of the Sun - Difficulty: 0)
+(@OGUID+121, 187567, 530, 3487, 10275, '0', 0, 0, 9799.123046875, -7310.60791015625, 35.23363494873046875, 2.199114561080932617, 0, 0, 0.8910064697265625, 0.453990638256072998, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: Court of the Sun - Difficulty: 0)
+(@OGUID+122, 187567, 530, 3487, 10275, '0', 0, 0, 9752.513671875, -7336.51416015625, 34.97600555419921875, 1.919861555099487304, 0, 0, 0.819151878356933593, 0.573576688766479492, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: Court of the Sun - Difficulty: 0)
+(@OGUID+123, 187567, 530, 3487, 0, '0', 0, 0, 9734.0302734375, -7343.01904296875, 35.02362060546875, 1.902408957481384277, 0, 0, 0.814115524291992187, 0.580702960491180419, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+124, 187567, 530, 3487, 0, '0', 0, 0, 9743.40234375, -7339.74853515625, 34.94566726684570312, 1.902408957481384277, 0, 0, 0.814115524291992187, 0.580702960491180419, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+125, 187567, 530, 3487, 0, '0', 0, 0, 9724.4990234375, -7346.24755859375, 34.95547103881835937, 1.919861555099487304, 0, 0, 0.819151878356933593, 0.573576688766479492, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+126, 187567, 530, 3487, 0, '0', 0, 0, 9767.3818359375, -7480.580078125, 28.18163681030273437, 3.194002151489257812, 0, 0, -0.99965667724609375, 0.026201646775007247, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+127, 187567, 530, 3487, 0, '0', 0, 0, 9683.361328125, -7495.40625, 26.99794769287109375, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+128, 187567, 530, 3487, 0, '0', 0, 0, 9631.1376953125, -7135.57470703125, 23.11801338195800781, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+129, 187567, 530, 3487, 0, '0', 0, 0, 9485.029296875, -7132.4052734375, 24.43082618713378906, 0, 0, 0, 0, 1, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+130, 187567, 530, 3487, 0, '0', 0, 0, 9767.3828125, -7495.05224609375, 28.28905677795410156, 3.054326534271240234, 0, 0, 0.999048233032226562, 0.043619260191917419, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+131, 187567, 530, 3487, 0, '0', 0, 0, 9694.3681640625, -7495.95654296875, 25.62032508850097656, 1.605701684951782226, 0, 0, 0.719339370727539062, 0.694658815860748291, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+132, 187567, 530, 3487, 0, '0', 0, 0, 9672.3876953125, -7495.9912109375, 25.67016029357910156, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+133, 187567, 530, 3487, 0, '0', 0, 0, 9638.369140625, -7397.27880859375, 22.68563079833984375, 4.782202720642089843, 0, 0, -0.68199825286865234, 0.731353819370269775, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+134, 187567, 530, 3487, 0, '0', 0, 0, 9648.3857421875, -7152.3037109375, 23.26343536376953125, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+135, 187567, 530, 3487, 0, '0', 0, 0, 9665.8671875, -7135.83056640625, 23.16021537780761718, 3.106652259826660156, 0, 0, 0.999847412109375, 0.017469281330704689, 120, 255, 1, 47213), -- Hanging, Streamer - Xmas (Area: 0 - Difficulty: 0)
+(@OGUID+136, 187567, 530, 3487, 0, '0', 0, 0, 9648.5283203125, -7119.0869140625, 23.29839515686035156, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 47213); -- Hanging, Streamer - Xmas (Area: 0 - Difficulty: 0)
+
+-- Event spawns
+DELETE FROM `game_event_creature` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @CGUID+0 AND @CGUID+8;
+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),
+(@EVENT, @CGUID+7),
+(@EVENT, @CGUID+8);
+
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @OGUID+0 AND @OGUID+136;
+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);