diff options
| -rw-r--r-- | sql/updates/world/master/2022_12_29_02_world.sql | 286 |
1 files changed, 286 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_12_29_02_world.sql b/sql/updates/world/master/2022_12_29_02_world.sql new file mode 100644 index 00000000000..1228c30ff85 --- /dev/null +++ b/sql/updates/world/master/2022_12_29_02_world.sql @@ -0,0 +1,286 @@ +SET @CGUID := 396681; +SET @OGUID := 252801; +SET @EVENT := 2; + +-- Creature templates +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70 WHERE `entry`=13431; -- Whulwert Copperpinch +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70 WHERE `entry`=13432; -- Seersa 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 (15789, 15793); -- Tauren Winter Reveler + +DELETE FROM `creature_template_addon` WHERE `entry` IN (13431, 13432); +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(13431, 0, 0, 0, 257, 0, 0, 0, 0, 0, ''), -- 13431 (Whulwert Copperpinch) +(13432, 0, 0, 0, 257, 0, 0, 0, 0, 0, ''); -- 13432 (Seersa Copperpinch) + +-- Scaling +DELETE FROM `creature_template_scaling` WHERE (`DifficultyID`=0 AND `Entry` IN (13432,13431)); +INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES +(13432, 0, 0, 0, 865, 47213), +(13431, 0, 0, 0, 865, 47213); + +UPDATE `creature_template_scaling` SET `VerifiedBuild`=47213 WHERE (`DifficultyID`=0 AND `Entry` IN (153285,118512,96470,62462,61143,61141,52658,52657,52655,52651,51640,51639,51638,51503,51372,51143,50483,49750,47589,47572,43892,43883,43881,43870,43796,43795,43004,43001,36648,34978,34976,34766,31146,30724,30709,19176,15760,15164,14442,14441,14440,12383,11084,11071,11051,11047,10881,10278,10086,10054,9087,9076,8722,8674,8664,8401,8398,8364,8363,8362,8361,8360,8359,8358,8357,8356,7089,6746,6410,6393,5957,5906,5770,5769,5599,5543,5189,5054,4943,4721,4166,3978,3566,3447,3441,3419,3095,3093,3092,3084,3083,3050,3049,3048,3047,3046,3045,3044,3043,3042,3041,3040,3039,3038,3037,3036,3035,3034,3033,3029,3028,3027,3026,3025,3024,3023,3022,3021,3020,3019,3018,3017,3016,3015,3014,3013,3012,3011,3010,3009,3008,3007,3005,3004,3003,3002,3001,2999,2998,2997,2996,2995,2971,2969,2965,2964,2960,2959,2957,2956,2798,2620,721)); + +-- Vendor data +DELETE FROM `npc_vendor` WHERE (`entry`=13432 AND `item`=17344 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=13432 AND `item`=34413 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=13432 AND `item`=34262 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=13432 AND `item`=34261 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=13432 AND `item`=188680 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=13432 AND `item`=70923 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=13431 AND `item`=21215 AND `ExtendedCost`=0 AND `type`=1); +INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `ExtendedCost`, `type`, `PlayerConditionID`, `IgnoreFiltering`, `VerifiedBuild`) VALUES +(13432, 13, 34413, 0, 0, 1, 0, 0, 47213), -- Recipe: Hot Apple Cider +(13432, 12, 34262, 0, 0, 1, 0, 0, 47213), -- Pattern: Winter Boots +(13432, 11, 34261, 0, 0, 1, 0, 0, 47213), -- Pattern: Green Winter Clothes +(13432, 8, 188680, 0, 0, 1, 0, 0, 47213), -- Winter Veil Chorus Book +(13432, 7, 70923, 0, 0, 1, 0, 0, 47213), -- Gaudy Winter Veil Sweater +(13431, 1, 21215, 0, 0, 1, 0, 0, 47213); -- Graccu's Mince Meat Fruitcake + +UPDATE `npc_vendor` SET `slot`=10, `VerifiedBuild`=47213 WHERE (`entry`=13432 AND `item`=17201 AND `ExtendedCost`=0 AND `type`=1); -- Recipe: Winter Veil Egg Nog +UPDATE `npc_vendor` SET `slot`=9, `VerifiedBuild`=47213 WHERE (`entry`=13432 AND `item`=17200 AND `ExtendedCost`=0 AND `type`=1); -- Recipe: Gingerbread Cookie +UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=47213 WHERE (`entry`=13432 AND `item`=17196 AND `ExtendedCost`=0 AND `type`=1); -- Holiday Spirits +UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=47213 WHERE (`entry`=13432 AND `item`=17194 AND `ExtendedCost`=0 AND `type`=1); -- Holiday Spices +UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=47213 WHERE (`entry`=13432 AND `item`=17307 AND `ExtendedCost`=0 AND `type`=1); -- Purple Ribboned Wrapping Paper +UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=47213 WHERE (`entry`=13432 AND `item`=17304 AND `ExtendedCost`=0 AND `type`=1); -- Green Ribboned Wrapping Paper +UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=47213 WHERE (`entry`=13432 AND `item`=17303 AND `ExtendedCost`=0 AND `type`=1); -- Blue Ribboned Wrapping Paper +UPDATE `npc_vendor` SET `slot`=1, `VerifiedBuild`=47213 WHERE (`entry`=13432 AND `item`=17202 AND `ExtendedCost`=0 AND `type`=1); -- Snowball +UPDATE `npc_vendor` SET `slot`=10, `VerifiedBuild`=47213 WHERE (`entry`=13431 AND `item`=17402 AND `ExtendedCost`=0 AND `type`=1); -- Greatfather's Winter Ale +UPDATE `npc_vendor` SET `slot`=9, `VerifiedBuild`=47213 WHERE (`entry`=13431 AND `item`=17403 AND `ExtendedCost`=0 AND `type`=1); -- Steamwheedle Fizzy Spirits +UPDATE `npc_vendor` SET `slot`=8, `VerifiedBuild`=47213 WHERE (`entry`=13431 AND `item`=34410 AND `ExtendedCost`=0 AND `type`=1); -- Honeyed Holiday Ham +UPDATE `npc_vendor` SET `slot`=7, `VerifiedBuild`=47213 WHERE (`entry`=13431 AND `item`=17408 AND `ExtendedCost`=0 AND `type`=1); -- Spicy Beefstick +UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=47213 WHERE (`entry`=13431 AND `item`=17407 AND `ExtendedCost`=0 AND `type`=1); -- Graccu's Homemade Meat Pie +UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=47213 WHERE (`entry`=13431 AND `item`=17406 AND `ExtendedCost`=0 AND `type`=1); -- Holiday Cheesewheel +UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=47213 WHERE (`entry`=13431 AND `item`=34412 AND `ExtendedCost`=0 AND `type`=1); -- Sparkling Apple Cider +UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=47213 WHERE (`entry`=13431 AND `item`=17405 AND `ExtendedCost`=0 AND `type`=1); -- Green Garden Tea +UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=47213 WHERE (`entry`=13431 AND `item`=17404 AND `ExtendedCost`=0 AND `type`=1); -- Blended Bean Brew + +-- Quests +DELETE FROM `quest_poi` WHERE (`QuestID`=7061 AND `BlobIndex`=1 AND `Idx1`=2) OR (`QuestID`=7061 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=7061 AND `BlobIndex`=0 AND `Idx1`=0); +INSERT INTO `quest_poi` (`QuestID`, `BlobIndex`, `Idx1`, `ObjectiveIndex`, `QuestObjectiveID`, `QuestObjectID`, `MapID`, `UiMapID`, `Priority`, `Flags`, `WorldEffectID`, `PlayerConditionID`, `NavigationPlayerConditionID`, `SpawnTrackingID`, `AlwaysAllowMergingBlobs`, `VerifiedBuild`) VALUES +(7061, 1, 2, 32, 0, 0, 1, 85, 0, 0, 0, 0, 0, 1104414, 0, 47213), -- The Feast of Winter Veil +(7061, 0, 1, 32, 0, 0, 1, 85, 0, 0, 0, 0, 0, 74055, 0, 47213), -- The Feast of Winter Veil +(7061, 0, 0, -1, 0, 0, 1, 88, 0, 1, 0, 0, 0, 0, 0, 47213); -- The Feast of Winter Veil + +UPDATE `quest_offer_reward` SET `RewardText`='The legends and lore surrounding the Winter Veil are ones that have faded from the forefront of public thought over the years. Yes, I know that the goblins are helping to revive the season for their own ends, the fact that our people reflect upon it at least in some form does good to keep such lore alive.$B$BYour desire to go beyond the material and learn about our past is an admirable trait, young $c. I salute your wisdom.', `VerifiedBuild`=47213 WHERE `ID`=7061; -- The Feast of Winter Veil + +UPDATE `creature_questender` SET `VerifiedBuild`=47213 WHERE (`id`=36648 AND `quest`=7061); + +-- Old creature spawns +DELETE FROM `creature` WHERE `guid` IN (61698, 61699); +DELETE FROM `game_event_creature` WHERE `guid` IN (61698, 61699); + +-- Creature spawns +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+3; +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, 13431, 1, 1638, 5345, '0', 0, 0, 0, 0, -1234.5078125, 73.45285797119140625, 129.5908050537109375, 2.809980154037475585, 120, 0, 0, 118565, 0, 0, 0, 0, 0, 47213), -- Whulwert Copperpinch (Area: Thunder Bluff - Difficulty: 0) +(@CGUID+1, 13432, 1, 1638, 5345, '0', 0, 0, 0, 0, -1232.3828125, 75.34830474853515625, 129.8591461181640625, 2.652900457382202148, 120, 0, 0, 118565, 0, 0, 0, 0, 0, 47213), -- Seersa Copperpinch (Area: Thunder Bluff - Difficulty: 0) +(@CGUID+2, 15760, 1, 1638, 5345, '0', 0, 0, 0, 1, -1294.273681640625, 45.58859634399414062, 129.291839599609375, 0.575958669185638427, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 47213), -- Winter Reveler (Area: Thunder Bluff - Difficulty: 0) (Auras: ) +(@CGUID+3, 15760, 1, 1638, 5345, '0', 0, 0, 0, 1, -1291.804443359375, 46.94460678100585937, 129.291839599609375, 3.630284786224365234, 120, 0, 0, 112919, 0, 0, 0, 0, 0, 47213); -- Winter Reveler (Area: Thunder Bluff - Difficulty: 0) (Auras: ) + +DELETE FROM `creature_addon` WHERE `guid` IN (@CGUID+2, @CGUID+3); +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+2, 0, 0, 0, 257, 0, 0, 0, 0, 0, '26249'), -- 15760 (Winter Reveler) +(@CGUID+3, 0, 0, 0, 257, 0, 0, 0, 0, 0, '26250'); -- 15760 (Winter Reveler) + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+96; +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, 178426, 1, 1638, 5345, '0', 0, 0, -1231.4849853515625, 66.82866668701171875, 129.1611175537109375, 1.884953022003173828, 0, 0, 0.809016227722167968, 0.587786316871643066, 120, 255, 1, 47213), -- XMasTreeLargeHorde01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+1, 178426, 1, 1638, 5345, '0', 0, 0, -1207.68359375, -44.7899856567382812, 161.1519927978515625, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 47213), -- XMasTreeLargeHorde01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+2, 178426, 1, 1638, 1639, '0', 0, 0, -1056.7296142578125, -303.275665283203125, 159.0303497314453125, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 47213), -- XMasTreeLargeHorde01 (Area: Elder Rise - Difficulty: 0) +(@OGUID+3, 178428, 1, 1638, 5345, '0', 0, 0, -1230.665771484375, 68.1175689697265625, 129.3195343017578125, 3.298687219619750976, 0, 0, -0.99691677093505859, 0.078466430306434631, 120, 255, 1, 47213), -- XMasGift01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+4, 178428, 1, 1638, 5345, '0', 0, 0, -1232.9613037109375, 67.05023956298828125, 129.0037078857421875, 3.647741317749023437, 0, 0, -0.96814727783203125, 0.250381410121917724, 120, 255, 1, 47213), -- XMasGift01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+5, 178428, 1, 1638, 5345, '0', 0, 0, -1231.1805419921875, 65.68619537353515625, 129.7714385986328125, 0.314158439636230468, 0, 0, 0.156434059143066406, 0.987688362598419189, 120, 255, 1, 47213), -- XMasGift01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+6, 178428, 1, 1638, 5345, '0', 0, 0, -1232.5670166015625, 68.05571746826171875, 129.1608428955078125, 1.343901276588439941, 0, 0, 0.622513771057128906, 0.78260880708694458, 120, 255, 1, 47213), -- XMasGift01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+7, 178428, 1, 1638, 5345, '0', 0, 0, -1208.1668701171875, -46.8872642517089843, 160.8873291015625, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 47213), -- XMasGift01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+8, 178428, 1, 1638, 5345, '0', 0, 0, -1207.9521484375, -46.1829948425292968, 161.4409027099609375, 6.195919513702392578, 0, 0, -0.04361915588378906, 0.999048233032226562, 120, 255, 1, 47213), -- XMasGift01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+9, 178428, 1, 1638, 5345, '0', 0, 0, -1209.6024169921875, -44.4536895751953125, 161.2857208251953125, 4.101525306701660156, 0, 0, -0.88701057434082031, 0.461749136447906494, 120, 255, 1, 47213), -- XMasGift01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+10, 178428, 1, 1638, 5345, '0', 0, 0, -1207.0660400390625, -44.3132591247558593, 161.20111083984375, 4.171337604522705078, 0, 0, -0.87035560607910156, 0.492423713207244873, 120, 255, 1, 47213), -- XMasGift01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+11, 178428, 1, 1638, 5345, '0', 0, 0, -1206.12744140625, -46.0560455322265625, 161.0058135986328125, 5.759587764739990234, 0, 0, -0.25881862640380859, 0.965925931930541992, 120, 255, 1, 47213), -- XMasGift01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+12, 178428, 1, 1638, 5345, '0', 0, 0, -1207.03125, -42.600189208984375, 161.4060211181640625, 6.003933906555175781, 0, 0, -0.13917255401611328, 0.990268170833587646, 120, 255, 1, 47213), -- XMasGift01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+13, 178428, 1, 1638, 1639, '0', 0, 0, -1057.47216796875, -302.5635986328125, 159.0303497314453125, 2.181660413742065429, 0, 0, 0.887010574340820312, 0.461749136447906494, 120, 255, 1, 47213), -- XMasGift01 (Area: Elder Rise - Difficulty: 0) +(@OGUID+14, 178428, 1, 1638, 1639, '0', 0, 0, -1058.8240966796875, -302.10595703125, 159.0303497314453125, 1.692969322204589843, 0, 0, 0.748955726623535156, 0.662620067596435546, 120, 255, 1, 47213), -- XMasGift01 (Area: Elder Rise - Difficulty: 0) +(@OGUID+15, 178428, 1, 1638, 1639, '0', 0, 0, -1056.6363525390625, -301.032012939453125, 159.0303497314453125, 0.610863447189331054, 0, 0, 0.3007049560546875, 0.953717231750488281, 120, 255, 1, 47213), -- XMasGift01 (Area: Elder Rise - Difficulty: 0) +(@OGUID+16, 178428, 1, 1638, 1639, '0', 0, 0, -1055.6673583984375, -301.664703369140625, 159.3636932373046875, 0.314158439636230468, 0, 0, 0.156434059143066406, 0.987688362598419189, 120, 255, 1, 47213), -- XMasGift01 (Area: Elder Rise - Difficulty: 0) +(@OGUID+17, 178428, 1, 1638, 1639, '0', 0, 0, -1057.0201416015625, -305.199920654296875, 159.0303497314453125, 4.502951622009277343, 0, 0, -0.7771453857421875, 0.629321098327636718, 120, 255, 1, 47213), -- XMasGift01 (Area: Elder Rise - Difficulty: 0) +(@OGUID+18, 178428, 1, 1638, 1639, '0', 0, 0, -1054.9232177734375, -305.087554931640625, 159.0303497314453125, 6.056293010711669921, 0, 0, -0.11320304870605468, 0.993571877479553222, 120, 255, 1, 47213), -- XMasGift01 (Area: Elder Rise - Difficulty: 0) +(@OGUID+19, 178428, 1, 1638, 1639, '0', 0, 0, -1058.0699462890625, -305.13873291015625, 159.0303497314453125, 3.333590030670166015, 0, 0, -0.99539566040039062, 0.095851235091686248, 120, 255, 1, 47213), -- XMasGift01 (Area: Elder Rise - Difficulty: 0) +(@OGUID+20, 178429, 1, 1638, 5345, '0', 0, 0, -1230.2393798828125, 66.40120697021484375, 129.1126251220703125, 0.331610709428787231, 0, 0, 0.16504669189453125, 0.986285746097564697, 120, 255, 1, 47213), -- XMasGift02 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+21, 178429, 1, 1638, 5345, '0', 0, 0, -1232.094482421875, 66.12255859375, 128.927581787109375, 4.520402908325195312, 0, 0, -0.77162456512451171, 0.636078238487243652, 120, 255, 1, 47213), -- XMasGift02 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+22, 178429, 1, 1638, 5345, '0', 0, 0, -1233.18408203125, 66.14800262451171875, 128.8398590087890625, 4.276057243347167968, 0, 0, -0.84339141845703125, 0.537299633026123046, 120, 255, 1, 47213), -- XMasGift02 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+23, 178429, 1, 1638, 5345, '0', 0, 0, -1205.18603515625, -43.5796089172363281, 161.2712554931640625, 0.418878614902496337, 0, 0, 0.207911491394042968, 0.978147625923156738, 120, 255, 1, 47213), -- XMasGift02 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+24, 178429, 1, 1638, 5345, '0', 0, 0, -1208.0760498046875, -44.2820663452148437, 161.21868896484375, 3.595378875732421875, 0, 0, -0.97437000274658203, 0.224951311945915222, 120, 255, 1, 47213), -- XMasGift02 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+25, 178429, 1, 1638, 5345, '0', 0, 0, -1207.0924072265625, -45.8859825134277343, 161.3196258544921875, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 120, 255, 1, 47213), -- XMasGift02 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+26, 178429, 1, 1638, 5345, '0', 0, 0, -1205.2896728515625, -46.2159233093261718, 160.9850311279296875, 5.462882041931152343, 0, 0, -0.39874839782714843, 0.917060375213623046, 120, 255, 1, 47213), -- XMasGift02 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+27, 178429, 1, 1638, 1639, '0', 0, 0, -1056.5416259765625, -302.139801025390625, 159.0303497314453125, 1.378809213638305664, 0, 0, 0.636077880859375, 0.771624863147735595, 120, 255, 1, 47213), -- XMasGift02 (Area: Elder Rise - Difficulty: 0) +(@OGUID+28, 178429, 1, 1638, 1639, '0', 0, 0, -1058.2760009765625, -302.982574462890625, 159.0303497314453125, 3.24634718894958496, 0, 0, -0.99862861633300781, 0.052353221923112869, 120, 255, 1, 47213), -- XMasGift02 (Area: Elder Rise - Difficulty: 0) +(@OGUID+29, 178429, 1, 1638, 1639, '0', 0, 0, -1055.4422607421875, -304.287872314453125, 159.0303497314453125, 1.082102894783020019, 0, 0, 0.51503753662109375, 0.857167601585388183, 120, 255, 1, 47213), -- XMasGift02 (Area: Elder Rise - Difficulty: 0) +(@OGUID+30, 178430, 1, 1638, 5345, '0', 0, 0, -1229.9581298828125, 67.31760406494140625, 129.264984130859375, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 47213), -- XMasGift03 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+31, 178430, 1, 1638, 5345, '0', 0, 0, -1231.5347900390625, 68.69358062744140625, 129.3289947509765625, 3.019413232803344726, 0, 0, 0.998134613037109375, 0.061051756143569946, 120, 255, 1, 47213), -- XMasGift03 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+32, 178430, 1, 1638, 5345, '0', 0, 0, -1233.5284423828125, 68.06684112548828125, 129.070953369140625, 5.742135047912597656, 0, 0, -0.26723766326904296, 0.96363067626953125, 120, 255, 1, 47213), -- XMasGift03 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+33, 178430, 1, 1638, 5345, '0', 0, 0, -1207.228515625, -46.1965446472167968, 160.987701416015625, 5.602506637573242187, 0, 0, -0.33380699157714843, 0.942641437053680419, 120, 255, 1, 47213), -- XMasGift03 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+34, 178430, 1, 1638, 5345, '0', 0, 0, -1209.9654541015625, -45.3821640014648437, 161.1890716552734375, 3.78736734390258789, 0, 0, -0.94832324981689453, 0.317305892705917358, 120, 255, 1, 47213), -- XMasGift03 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+35, 178430, 1, 1638, 5345, '0', 0, 0, -1209.04296875, -43.5423088073730468, 161.3586273193359375, 2.426007747650146484, 0, 0, 0.936672210693359375, 0.350207358598709106, 120, 255, 1, 47213), -- XMasGift03 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+36, 178430, 1, 1638, 5345, '0', 0, 0, -1205.744140625, -44.7677879333496093, 161.1488494873046875, 0.15707901120185852, 0, 0, 0.078458786010742187, 0.996917366981506347, 120, 255, 1, 47213), -- XMasGift03 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+37, 178430, 1, 1638, 1639, '0', 0, 0, -1056.3485107421875, -303.89447021484375, 159.0303497314453125, 5.148722648620605468, 0, 0, -0.53729915618896484, 0.843391716480255126, 120, 255, 1, 47213), -- XMasGift03 (Area: Elder Rise - Difficulty: 0) +(@OGUID+38, 178430, 1, 1638, 1639, '0', 0, 0, -1055.5064697265625, -301.716705322265625, 159.0303497314453125, 0.698131442070007324, 0, 0, 0.342020034790039062, 0.939692676067352294, 120, 255, 1, 47213), -- XMasGift03 (Area: Elder Rise - Difficulty: 0) +(@OGUID+39, 178430, 1, 1638, 1639, '0', 0, 0, -1057.691650390625, -301.5743408203125, 159.0303497314453125, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 120, 255, 1, 47213), -- XMasGift03 (Area: Elder Rise - Difficulty: 0) +(@OGUID+40, 178431, 1, 1638, 5345, '0', 0, 0, -1232.5174560546875, 69.2039947509765625, 129.3052520751953125, 4.084071159362792968, 0, 0, -0.8910064697265625, 0.453990638256072998, 120, 255, 1, 47213), -- XMasGift04 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+41, 178431, 1, 1638, 5345, '0', 0, 0, -1232.3135986328125, 68.070587158203125, 129.5667877197265625, 3.612837791442871093, 0, 0, -0.97236919403076171, 0.233448356389999389, 120, 255, 1, 47213), -- XMasGift04 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+42, 178431, 1, 1638, 5345, '0', 0, 0, -1234.10595703125, 66.9599609375, 128.85272216796875, 0.488691210746765136, 0, 0, 0.241921424865722656, 0.970295846462249755, 120, 255, 1, 47213), -- XMasGift04 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+43, 178431, 1, 1638, 5345, '0', 0, 0, -1230.6380615234375, 69.31103515625, 129.4600830078125, 6.03883981704711914, 0, 0, -0.12186908721923828, 0.9925462007522583, 120, 255, 1, 47213), -- XMasGift04 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+44, 178431, 1, 1638, 5345, '0', 0, 0, -1209.7039794921875, -45.4058265686035156, 161.5247650146484375, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 120, 255, 1, 47213), -- XMasGift04 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+45, 178431, 1, 1638, 5345, '0', 0, 0, -1207.3792724609375, -47.4854316711425781, 160.812042236328125, 4.97418975830078125, 0, 0, -0.60876083374023437, 0.793353796005249023, 120, 255, 1, 47213), -- XMasGift04 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+46, 178431, 1, 1638, 5345, '0', 0, 0, -1208.095458984375, -45.8046455383300781, 161.037933349609375, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 120, 255, 1, 47213), -- XMasGift04 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+47, 178431, 1, 1638, 5345, '0', 0, 0, -1206.89599609375, -44.1168136596679687, 161.6461029052734375, 0.733038187026977539, 0, 0, 0.358367919921875, 0.933580458164215087, 120, 255, 1, 47213), -- XMasGift04 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+48, 178431, 1, 1638, 5345, '0', 0, 0, -1205.850830078125, -44.5671539306640625, 161.4828643798828125, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 47213), -- XMasGift04 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+49, 178431, 1, 1638, 1639, '0', 0, 0, -1055.111328125, -303.31207275390625, 159.0303497314453125, 0.383971005678176879, 0, 0, 0.190808296203613281, 0.981627285480499267, 120, 255, 1, 47213), -- XMasGift04 (Area: Elder Rise - Difficulty: 0) +(@OGUID+50, 178432, 1, 1638, 5345, '0', 0, 0, -1229.53076171875, 68.36767578125, 129.41314697265625, 2.72271275520324707, 0, 0, 0.978147506713867187, 0.207912087440490722, 120, 255, 1, 47213), -- XMasGift05 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+51, 178432, 1, 1638, 5345, '0', 0, 0, -1231.19189453125, 65.61605072021484375, 128.9117889404296875, 5.323255538940429687, 0, 0, -0.46174812316894531, 0.887011110782623291, 120, 255, 1, 47213), -- XMasGift05 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+52, 178432, 1, 1638, 5345, '0', 0, 0, -1229.1783447265625, 66.44602203369140625, 129.1980743408203125, 5.480334281921386718, 0, 0, -0.39073085784912109, 0.920504987239837646, 120, 255, 1, 47213), -- XMasGift05 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+53, 178432, 1, 1638, 5345, '0', 0, 0, -1208.8746337890625, -46.2314300537109375, 161.006317138671875, 2.024578809738159179, 0, 0, 0.848047256469726562, 0.529920578002929687, 120, 255, 1, 47213), -- XMasGift05 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+54, 178432, 1, 1638, 5345, '0', 0, 0, -1207.6513671875, -43.3609848022460937, 161.3240966796875, 3.001946926116943359, 0, 0, 0.997563362121582031, 0.069766148924827575, 120, 255, 1, 47213), -- XMasGift05 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+55, 178432, 1, 1638, 5345, '0', 0, 0, -1206.5478515625, -45.1776885986328125, 161.1049957275390625, 2.338739633560180664, 0, 0, 0.920504570007324218, 0.3907318115234375, 120, 255, 1, 47213), -- XMasGift05 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+56, 178432, 1, 1638, 1639, '0', 0, 0, -1057.4564208984375, -303.54010009765625, 159.0303497314453125, 3.735006093978881835, 0, 0, -0.95630455017089843, 0.292372345924377441, 120, 255, 1, 47213), -- XMasGift05 (Area: Elder Rise - Difficulty: 0) +(@OGUID+57, 178432, 1, 1638, 1639, '0', 0, 0, -1055.758544921875, -302.703460693359375, 159.0303497314453125, 0.767943859100341796, 0, 0, 0.374606132507324218, 0.927184045314788818, 120, 255, 1, 47213), -- XMasGift05 (Area: Elder Rise - Difficulty: 0) +(@OGUID+58, 178432, 1, 1638, 1639, '0', 0, 0, -1056.0379638671875, -304.75628662109375, 159.0303497314453125, 4.066620349884033203, 0, 0, -0.89493370056152343, 0.44619917869567871, 120, 255, 1, 47213), -- XMasGift05 (Area: Elder Rise - Difficulty: 0) +(@OGUID+59, 178433, 1, 1638, 5345, '0', 0, 0, -1232.864013671875, 67.09375, 129.412811279296875, 3.52557229995727539, 0, 0, -0.98162651062011718, 0.190812408924102783, 120, 255, 1, 47213), -- XMasGift06 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+60, 178433, 1, 1638, 5345, '0', 0, 0, -1230.1085205078125, 67.42350006103515625, 129.5665740966796875, 5.393068790435791015, 0, 0, -0.43051052093505859, 0.902585566043853759, 120, 255, 1, 47213), -- XMasGift06 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+61, 178433, 1, 1638, 5345, '0', 0, 0, -1231.9539794921875, 65.1976470947265625, 128.783203125, 4.363324165344238281, 0, 0, -0.81915187835693359, 0.573576688766479492, 120, 255, 1, 47213), -- XMasGift06 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+62, 178433, 1, 1638, 5345, '0', 0, 0, -1231.53662109375, 68.89507293701171875, 129.6520233154296875, 3.43830275535583496, 0, 0, -0.98901557922363281, 0.147811368107795715, 120, 255, 1, 47213), -- XMasGift06 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+63, 178433, 1, 1638, 5345, '0', 0, 0, -1208.720703125, -45.0676345825195312, 161.1530609130859375, 5.026549339294433593, 0, 0, -0.5877847671508789, 0.809017360210418701, 120, 255, 1, 47213), -- XMasGift06 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+64, 178433, 1, 1638, 5345, '0', 0, 0, -1206.3795166015625, -43.4489021301269531, 161.29541015625, 1.169368624687194824, 0, 0, 0.551936149597167968, 0.833886384963989257, 120, 255, 1, 47213), -- XMasGift06 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+65, 178433, 1, 1638, 5345, '0', 0, 0, -1206.5831298828125, -47.0896720886230468, 160.871856689453125, 0.087265998125076293, 0, 0, 0.043619155883789062, 0.999048233032226562, 120, 255, 1, 47213), -- XMasGift06 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+66, 178433, 1, 1638, 1639, '0', 0, 0, -1057.4947509765625, -302.5201416015625, 159.4400787353515625, 6.12610626220703125, 0, 0, -0.07845878601074218, 0.996917366981506347, 120, 255, 1, 47213), -- XMasGift06 (Area: Elder Rise - Difficulty: 0) +(@OGUID+67, 178433, 1, 1638, 1639, '0', 0, 0, -1057.9342041015625, -301.66754150390625, 159.35675048828125, 2.687806606292724609, 0, 0, 0.974370002746582031, 0.224951311945915222, 120, 255, 1, 47213), -- XMasGift06 (Area: Elder Rise - Difficulty: 0) +(@OGUID+68, 178433, 1, 1638, 1639, '0', 0, 0, -1056.717529296875, -304.122894287109375, 159.35675048828125, 0.034906249493360519, 0, 0, 0.017452239990234375, 0.999847710132598876, 120, 255, 1, 47213), -- XMasGift06 (Area: Elder Rise - Difficulty: 0) +(@OGUID+69, 178434, 1, 1638, 5345, '0', 0, 0, -1296.4732666015625, 43.35758590698242187, 134.5643463134765625, 4.747295856475830078, 0, 0, -0.69465827941894531, 0.719339847564697265, 120, 255, 1, 47213), -- XMasStocking01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+70, 178434, 1, 1638, 5345, '0', 0, 0, -1254.3673095703125, 19.51736068725585937, 132.7402801513671875, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 47213), -- XMasStocking01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+71, 178434, 1, 1638, 5345, '0', 0, 0, -1309.8822021484375, 29.8671875, 134.5406036376953125, 2.164205789566040039, 0, 0, 0.882946968078613281, 0.469472706317901611, 120, 255, 1, 47213), -- XMasStocking01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+72, 178434, 1, 1638, 5345, '0', 0, 0, -1264.5106201171875, 24.11333656311035156, 132.636810302734375, 0.331610709428787231, 0, 0, 0.16504669189453125, 0.986285746097564697, 120, 255, 1, 47213), -- XMasStocking01 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+73, 178435, 1, 1638, 5345, '0', 0, 0, -1292.80224609375, 36.66650390625, 134.495941162109375, 2.059488296508789062, 0, 0, 0.857167243957519531, 0.515038192272186279, 120, 255, 1, 47213), -- XMasStocking02 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+74, 178435, 1, 1638, 5345, '0', 0, 0, -1305.4371337890625, 37.99723434448242187, 134.17742919921875, 5.515241622924804687, 0, 0, -0.37460613250732421, 0.927184045314788818, 120, 255, 1, 47213), -- XMasStocking02 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+75, 178435, 1, 1638, 5345, '0', 0, 0, -1260.705322265625, 18.86073112487792968, 132.7528839111328125, 1.466075778007507324, 0, 0, 0.669130325317382812, 0.74314504861831665, 120, 255, 1, 47213), -- XMasStocking02 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+76, 178436, 1, 1638, 5345, '0', 0, 0, -1313.032958984375, 34.49365234375, 134.238250732421875, 5.201082706451416015, 0, 0, -0.51503753662109375, 0.857167601585388183, 120, 255, 1, 47213), -- XMasStocking03 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+77, 178436, 1, 1638, 5345, '0', 0, 0, -1251.480712890625, 25.30875587463378906, 132.7217864990234375, 3.333590030670166015, 0, 0, -0.99539566040039062, 0.095851235091686248, 120, 255, 1, 47213), -- XMasStocking03 (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+78, 178437, 1, 1638, 5345, '0', 0, 0, -1206.3489990234375, 133.65972900390625, 145.060333251953125, 3.822272777557373046, 0, 0, -0.94264125823974609, 0.333807557821273803, 120, 255, 1, 47213), -- Wreath (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+79, 178437, 1, 1638, 5345, '0', 0, 0, -1276.955322265625, 50.09505081176757812, 139.5738983154296875, 0.506144583225250244, 0, 0, 0.250379562377929687, 0.968147754669189453, 120, 255, 1, 47213), -- Wreath (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+80, 178437, 1, 1638, 5345, '0', 0, 0, -1124.169677734375, 64.28081512451171875, 153.5550079345703125, 4.48549652099609375, 0, 0, -0.7826080322265625, 0.622514784336090087, 120, 255, 1, 47213), -- Wreath (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+81, 178437, 1, 1638, 5345, '0', 0, 0, -1235.702880859375, -89.8300247192382812, 173.2365264892578125, 0.488691210746765136, 0, 0, 0.241921424865722656, 0.970295846462249755, 120, 255, 1, 47213), -- Wreath (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+82, 178437, 1, 1638, 5345, '0', 0, 0, -1181.2864990234375, -91.986114501953125, 172.9793243408203125, 2.530723094940185546, 0, 0, 0.953716278076171875, 0.300707906484603881, 120, 255, 1, 47213), -- Wreath (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+83, 178554, 1, 1638, 5345, '0', 0, 0, -1198.9896240234375, 139.265625, 141.1496734619140625, 5.480334281921386718, 0, 0, -0.39073085784912109, 0.920504987239837646, 120, 255, 1, 47213), -- Mistletoe (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+84, 178554, 1, 1638, 5345, '0', 0, 0, -1285.3177490234375, 45.69140625, 135.616790771484375, 6.14356088638305664, 0, 0, -0.06975555419921875, 0.997564136981964111, 120, 255, 1, 47213), -- Mistletoe (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+85, 178554, 1, 1638, 5345, '0', 0, 0, -1244.138671875, -94.2062149047851562, 169.5185546875, 1.658061861991882324, 0, 0, 0.737277030944824218, 0.67559051513671875, 120, 255, 1, 47213), -- Mistletoe (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+86, 178554, 1, 1638, 5345, '0', 0, 0, -1173.3472900390625, -97.7847213745117187, 168.9624176025390625, 3.508116960525512695, 0, 0, -0.98325443267822265, 0.182238012552261352, 120, 255, 1, 47213), -- Mistletoe (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+87, 178556, 1, 1638, 1641, '0', 0, 0, -1420.32470703125, -111.116317749023437, 181.05413818359375, 5.672322273254394531, 0, 0, -0.3007049560546875, 0.953717231750488281, 120, 255, 1, 47213), -- Wreath scale 1.20 (Area: Hunter Rise - Difficulty: 0) +(@OGUID+88, 178746, 1, 1638, 5345, '0', 0, 0, -1233.3277587890625, 74.29312896728515625, 129.665008544921875, 2.181660413742065429, 0, 0, 0.887010574340820312, 0.461749136447906494, 120, 255, 1, 47213), -- Smokywood Pastures (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+89, 180715, 1, 1638, 5345, '0', 0, 0, -1227.8699951171875, 70.1361236572265625, 129.7169342041015625, 4.188792228698730468, 0, 0, -0.86602497100830078, 0.50000077486038208, 120, 255, 1, 47213), -- Holly Preserver (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+90, 180844, 1, 1638, 5345, '0', 0, 0, -1293.0867919921875, 46.46007156372070312, 136.81268310546875, 0.314158439636230468, 0, 0, 0.156434059143066406, 0.987688362598419189, 120, 255, 1, 47213), -- Mistletoe (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+91, 187235, 1, 1638, 5345, '0', 0, 0, -1059.8780517578125, 187.7550201416015625, 107.2493667602539062, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+92, 187235, 1, 1638, 5345, '0', 0, 0, -1069.7593994140625, 187.88482666015625, 107.7155838012695312, 1.064649581909179687, 0, 0, 0.507537841796875, 0.861629426479339599, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: Thunder Bluff - Difficulty: 0) +(@OGUID+93, 187235, 1, 1638, 1640, '0', 0, 0, -956.91461181640625, 267.94720458984375, 104.9567337036132812, 3.543023586273193359, 0, 0, -0.97992420196533203, 0.199370384216308593, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: Spirit Rise - Difficulty: 0) +(@OGUID+94, 187235, 1, 1638, 1640, '0', 0, 0, -998.57305908203125, 280.934417724609375, 111.9098663330078125, 0.15707901120185852, 0, 0, 0.078458786010742187, 0.996917366981506347, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: Spirit Rise - Difficulty: 0) +(@OGUID+95, 187235, 1, 1638, 1640, '0', 0, 0, -938.90625, 278.451385498046875, 111.7419204711914062, 2.426007747650146484, 0, 0, 0.936672210693359375, 0.350207358598709106, 120, 255, 1, 47213), -- Standing, Exterior, Medium - Xmas (Area: Spirit Rise - Difficulty: 0) +(@OGUID+96, 187567, 1, 1638, 5345, '0', 0, 0, -1259.4410400390625, 39.81076431274414062, 133.9119720458984375, 1.623155713081359863, 0, 0, 0.725374221801757812, 0.688354730606079101, 120, 255, 1, 47213); -- Hanging, Streamer - Xmas (Area: Thunder Bluff - Difficulty: 0) + +-- Event spawns +DELETE FROM `game_event_creature` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @CGUID+0 AND @CGUID+3; +INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES +(@EVENT, @CGUID+0), +(@EVENT, @CGUID+1), +(@EVENT, @CGUID+2), +(@EVENT, @CGUID+3); + +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @OGUID+0 AND @OGUID+96; +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); |