diff options
| -rw-r--r-- | sql/updates/world/master/2022_10_25_03_world.sql | 326 |
1 files changed, 326 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_10_25_03_world.sql b/sql/updates/world/master/2022_10_25_03_world.sql new file mode 100644 index 00000000000..65233439039 --- /dev/null +++ b/sql/updates/world/master/2022_10_25_03_world.sql @@ -0,0 +1,326 @@ +SET @CGUID := 395773; +SET @OGUID := 242308; + +-- Creature templates +UPDATE `creature_template` SET `gossip_menu_id`=6589, `minlevel`=60, `maxlevel`=60 WHERE `entry`=15353; -- Katrina Shimmerstar + +DELETE FROM `creature_template_addon` WHERE `entry`=15353; +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(15353, 0, 0, 0, 1, 0, 0, 0, 0, 0, ''); -- 15353 (Katrina Shimmerstar) + +-- Gossips +DELETE FROM `gossip_menu` WHERE (`MenuID`=6589 AND `TextID`=7805) OR (`MenuID`=6594 AND `TextID`=7813); +INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES +(6589, 7805, 45745), -- 15353 (Katrina Shimmerstar) +(6594, 7813, 45745); -- 15353 (Katrina Shimmerstar) + +DELETE FROM `gossip_menu_option` WHERE `MenuID`=6589; +INSERT INTO `gossip_menu_option` (`MenuID`, `OptionID`, `OptionNpc`, `OptionText`, `OptionBroadcastTextId`, `Language`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES +(6589, 0, 1, 'What Hallow''s End candy do you have for sale?', 10815, 0, 0, 0, 0, 0, NULL, 0, 45745), +(6589, 1, 0, 'What is there to do on Hallow''s End?', 10816, 0, 6594, 0, 0, 0, NULL, 0, 45745); + +-- Scaling +DELETE FROM `creature_template_scaling` WHERE (`Entry`=15353 AND `DifficultyID`=0); +INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES +(15353, 0, 0, 0, 425, 45745); + +-- Vendor data +UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=45745 WHERE (`entry`=15353 AND `item`=18633 AND `ExtendedCost`=0 AND `type`=1); -- Styleen's Sour Suckerpop +UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=45745 WHERE (`entry`=15353 AND `item`=18632 AND `ExtendedCost`=0 AND `type`=1); -- Moonbrook Riot Taffy +UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=45745 WHERE (`entry`=15353 AND `item`=7228 AND `ExtendedCost`=0 AND `type`=1); -- Tigule's Strawberry Ice Cream +UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=45745 WHERE (`entry`=15353 AND `item`=18635 AND `ExtendedCost`=0 AND `type`=1); -- Bellara's Nutterbar +UPDATE `npc_vendor` SET `slot`=1, `VerifiedBuild`=45745 WHERE (`entry`=15353 AND `item`=20557 AND `ExtendedCost`=0 AND `type`=1); -- Hallow's End Pumpkin Treat + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=23 AND `SourceGroup`=15353; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(23,15353,20557,0,0,47,0,8311,64,0,0,0,0,'','Item Hallow''s End Pumpkin Treat sold by Katrina Shimmerstar requires quest 8311 rewarded'); + +-- Gameobject templates +UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=45745 WHERE `entry`=189303; -- Candy Bucket +UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=45745 WHERE `entry`=190039; -- Candy Bucket + +UPDATE `gameobject_template_addon` SET `faction`=1732 WHERE `entry`=189303; -- Candy Bucket +UPDATE `gameobject_template_addon` SET `faction`=1732 WHERE `entry`=190039; -- Candy Bucket + +-- Quests +UPDATE `quest_template` SET `ContentTuningID`=426, `Expansion`=8, `VerifiedBuild`=45745 WHERE `ID`=8355; -- Incoming Gumdrop +UPDATE `quest_template` SET `ContentTuningID`=426, `Expansion`=8, `VerifiedBuild`=45745 WHERE `ID`=8357; -- Dancing for Marzipan +UPDATE `quest_template` SET `VerifiedBuild`=45745 WHERE `ID` IN (8353, 8356); + +UPDATE `quest_poi` SET `VerifiedBuild`=45745 WHERE (`QuestID`=8353 AND `BlobIndex`=0 AND `Idx1`=2) OR (`QuestID`=8353 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=8353 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=8355 AND `BlobIndex`=0 AND `Idx1`=2) OR (`QuestID`=8355 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=8355 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=8357 AND `BlobIndex`=0 AND `Idx1`=2) OR (`QuestID`=8357 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=8357 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=8356 AND `BlobIndex`=0 AND `Idx1`=2) OR (`QuestID`=8356 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=8356 AND `BlobIndex`=0 AND `Idx1`=0); + +UPDATE `quest_poi_points` SET `VerifiedBuild`=45745 WHERE (`QuestID`=8353 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=8353 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=8353 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=8355 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=8355 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=8355 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=8357 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=8357 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=8357 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=8356 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=8356 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=8356 AND `Idx1`=0 AND `Idx2`=0); + +DELETE FROM `quest_details` WHERE `ID` IN (8353, 8355, 8356, 8357); +INSERT INTO `quest_details` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `VerifiedBuild`) VALUES +(8353, 5, 1, 0, 0, 0, 0, 0, 0, 45745), -- Chicken Clucking for a Mint +(8355, 5, 1, 0, 0, 0, 0, 0, 0, 45745), -- Incoming Gumdrop +(8356, 1, 1, 0, 0, 0, 0, 0, 0, 45745), -- Flexing for Nougat +(8357, 5, 1, 0, 0, 0, 0, 0, 0, 45745); -- Dancing for Marzipan + +DELETE FROM `quest_request_items` WHERE `ID`=8353; +INSERT INTO `quest_request_items` (`ID`, `EmoteOnComplete`, `EmoteOnIncomplete`, `EmoteOnCompleteDelay`, `EmoteOnIncompleteDelay`, `CompletionText`, `VerifiedBuild`) VALUES +(8353, 0, 25, 0, 0, 'I''m waiting...', 45745); -- Chicken Clucking for a Mint + +UPDATE `quest_request_items` SET `EmoteOnIncomplete`=6, `CompletionText`='You know how to dance, don''t you? Try by putting your right foot in... then your right foot out... your right foot in... shake it all about...', `VerifiedBuild`=45745 WHERE `ID`=8357; -- Dancing for Marzipan +UPDATE `quest_request_items` SET `EmoteOnIncomplete`=1, `CompletionText`='No candy until you flex for me, $n...', `VerifiedBuild`=45745 WHERE `ID`=8356; -- Flexing for Nougat +UPDATE `quest_request_items` SET `EmoteOnIncomplete`=11, `VerifiedBuild`=45745 WHERE `ID`=8355; -- Incoming Gumdrop +UPDATE `quest_request_items` SET `VerifiedBuild`=45745 WHERE `ID`=8311; + +UPDATE `quest_offer_reward` SET `Emote1`=4, `RewardText`='Wow, you got them all! You''re awesome!$B$BThank you for trick-or-treating for me. Here, take these pumpkin treats - I think you''ll like them a lot!$B$BHappy Hallow''s End, $n!', `VerifiedBuild`=45745 WHERE `ID`=8311; -- Hallow's End Treats for Jesper! +UPDATE `quest_offer_reward` SET `RewardText`='Too funny! Well done, $n! Here''s your treat.$B$BHappy Hallow''s End!', `VerifiedBuild`=45745 WHERE `ID`=8353; -- Chicken Clucking for a Mint +UPDATE `quest_offer_reward` SET `Emote1`=4, `Emote2`=1, `RewardText`='Woo-woo! Well done, $n! Here''s your treat.$B$BHappy Hallow''s End!', `VerifiedBuild`=45745 WHERE `ID`=8355; -- Incoming Gumdrop +UPDATE `quest_offer_reward` SET `Emote1`=4, `Emote2`=1, `RewardText`='You''re quite the dancing machine, $n!$B$BHere''s your treat for being such a good sport. Happy Hallow''s End, and give my best to your sick little friend! I hope they get better soon.', `VerifiedBuild`=45745 WHERE `ID`=8357; -- Dancing for Marzipan +UPDATE `quest_offer_reward` SET `VerifiedBuild`=45745 WHERE `ID`=8356; + +UPDATE `quest_offer_reward` SET `VerifiedBuild`=45745 WHERE `ID`=12335; +UPDATE `quest_offer_reward` SET `VerifiedBuild`=45745 WHERE `ID`=12286; + +DELETE FROM `creature_queststarter` WHERE `quest`=29074 AND `id` IN (19172,19148); +INSERT INTO `creature_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(19172, 29074, 45745), -- A Season for Celebration offered Gnome Commoner +(19148, 29074, 45745); -- A Season for Celebration offered Dwarf Commoner + +DELETE FROM `game_event_creature_quest` WHERE `id` IN (19148, 19172) AND `quest`=29074; + +UPDATE `gameobject_questender` SET `VerifiedBuild`=45745 WHERE `id`=190039 AND `quest`=12335; +UPDATE `gameobject_questender` SET `VerifiedBuild`=45745 WHERE `id`=189303 AND `quest`=12286; + +-- Old creature spawns +DELETE FROM `creature` WHERE `guid`=91799; +DELETE FROM `game_event_creature` WHERE `guid`=91799; + +-- Creature spawns +DELETE FROM `creature` WHERE `guid` IN (@CGUID+0, @CGUID+1); +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(@CGUID+0, 15353, 0, 1537, 5719, '0', 0, 0, 0, 1, -4918.63671875, -983.14117431640625, 501.53759765625, 2.268928050994873046, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Katrina Shimmerstar (Area: The Commons - Difficulty: 0) +(@CGUID+1, 40435, 0, 1537, 1537, '0', 0, 0, 0, 0, -4939.44775390625, -937.36981201171875, 502.2398681640625, 0.767944872379302978, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745); -- Headless Ghost (Area: Ironforge - Difficulty: 0) (Auras: 33900 - Shroud of Death) + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+103; +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, 180405, 0, 1537, 1537, '0', 0, 0, -5028.53076171875, -835.8565673828125, 505.492523193359375, 3.508116960525512695, 0, 0, -0.98325443267822265, 0.182238012552261352, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ironforge - Difficulty: 0) +(@OGUID+1, 180405, 0, 1537, 1537, '0', 0, 0, -4956.92822265625, -921.64093017578125, 504.260650634765625, 4.206246376037597656, 0, 0, -0.86162853240966796, 0.50753939151763916, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ironforge - Difficulty: 0) +(@OGUID+2, 180405, 0, 1537, 1537, '0', 0, 0, -4957.27197265625, -928.35333251953125, 514.70294189453125, 1.117009282112121582, 0, 0, 0.529918670654296875, 0.84804844856262207, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ironforge - Difficulty: 0) +(@OGUID+3, 180405, 0, 1537, 1537, '0', 0, 0, -4901.64697265625, -904.99554443359375, 503.59613037109375, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ironforge - Difficulty: 0) +(@OGUID+4, 180405, 0, 1537, 1537, '0', 0, 0, -4936.35791015625, -943.3858642578125, 503.58935546875, 1.029743075370788574, 0, 0, 0.492423057556152343, 0.870355963706970214, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ironforge - Difficulty: 0) +(@OGUID+5, 180405, 0, 1537, 1537, '0', 0, 0, -4938.49755859375, -927.9288330078125, 503.59613037109375, 4.223697185516357421, 0, 0, -0.85716724395751953, 0.515038192272186279, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ironforge - Difficulty: 0) +(@OGUID+6, 180405, 0, 1537, 1537, '0', 0, 0, -4888.81005859375, -913.69891357421875, 503.58935546875, 0.820303261280059814, 0, 0, 0.398748397827148437, 0.917060375213623046, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ironforge - Difficulty: 0) +(@OGUID+7, 180405, 0, 1537, 1537, '0', 0, 0, -4978.9833984375, -971.4383544921875, 503.59613037109375, 4.502951622009277343, 0, 0, -0.7771453857421875, 0.629321098327636718, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ironforge - Difficulty: 0) +(@OGUID+8, 180405, 0, 1537, 1537, '0', 0, 0, -4853.765625, -880.60284423828125, 501.6593017578125, 0.541050612926483154, 0, 0, 0.267237663269042968, 0.96363067626953125, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ironforge - Difficulty: 0) +(@OGUID+9, 180405, 0, 1537, 1537, '0', 0, 0, -4842.84033203125, -874.50225830078125, 511.13970947265625, 0.436331570148468017, 0, 0, 0.216439247131347656, 0.976296067237854003, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ironforge - Difficulty: 0) +(@OGUID+10, 180405, 0, 1537, 1537, '0', 0, 0, -4875.7529296875, -948.45355224609375, 503.399261474609375, 3.874631166458129882, 0, 0, -0.93358039855957031, 0.358368009328842163, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: Ironforge - Difficulty: 0) +(@OGUID+11, 180405, 0, 1537, 5719, '0', 0, 0, -4900.6884765625, -971.5928955078125, 503.59967041015625, 4.834563255310058593, 0, 0, -0.66261959075927734, 0.748956084251403808, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: The Commons - Difficulty: 0) +(@OGUID+12, 180405, 0, 1537, 5719, '0', 0, 0, -4915.74072265625, -980.40765380859375, 501.446014404296875, 4.1538848876953125, 0, 0, -0.8746194839477539, 0.484810054302215576, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: The Commons - Difficulty: 0) +(@OGUID+13, 180405, 0, 1537, 5719, '0', 0, 0, -4926.08447265625, -996.48114013671875, 509.854888916015625, 4.398232460021972656, 0, 0, -0.80901622772216796, 0.587786316871643066, 120, 255, 1, 45745), -- G_Pumpkin_01 (Area: The Commons - Difficulty: 0) +(@OGUID+14, 180406, 0, 1537, 1537, '0', 0, 0, -4949.3046875, -921.61480712890625, 514.82037353515625, 1.099556446075439453, 0, 0, 0.522498130798339843, 0.852640450000762939, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Ironforge - Difficulty: 0) +(@OGUID+15, 180406, 0, 1537, 1537, '0', 0, 0, -4946.80859375, -913.25390625, 504.265350341796875, 4.276057243347167968, 0, 0, -0.84339141845703125, 0.537299633026123046, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Ironforge - Difficulty: 0) +(@OGUID+16, 180406, 0, 1537, 1537, '0', 0, 0, -4930.08251953125, -938.236328125, 503.58935546875, 1.029743075370788574, 0, 0, 0.492423057556152343, 0.870355963706970214, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Ironforge - Difficulty: 0) +(@OGUID+17, 180406, 0, 1537, 1537, '0', 0, 0, -4894.27880859375, -901.64935302734375, 503.59613037109375, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Ironforge - Difficulty: 0) +(@OGUID+18, 180406, 0, 1537, 1537, '0', 0, 0, -4974.2509765625, -964.82855224609375, 503.59613037109375, 4.468043327331542968, 0, 0, -0.7880105972290039, 0.615661680698394775, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Ironforge - Difficulty: 0) +(@OGUID+19, 180406, 0, 1537, 1537, '0', 0, 0, -4968.23681640625, -979.19378662109375, 503.58935546875, 1.378809213638305664, 0, 0, 0.636077880859375, 0.771624863147735595, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Ironforge - Difficulty: 0) +(@OGUID+20, 180406, 0, 1537, 1537, '0', 0, 0, -4842.47265625, -876.994140625, 503.18011474609375, 1.082102894783020019, 0, 0, 0.51503753662109375, 0.857167601585388183, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Ironforge - Difficulty: 0) +(@OGUID+21, 180406, 0, 1537, 1537, '0', 0, 0, -4836.2900390625, -873.71954345703125, 511.13970947265625, 0.453785061836242675, 0, 0, 0.224950790405273437, 0.974370121955871582, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Ironforge - Difficulty: 0) +(@OGUID+22, 180406, 0, 1537, 1537, '0', 0, 0, -4835.505859375, -860.6971435546875, 501.913787841796875, 5.794494152069091796, 0, 0, -0.24192142486572265, 0.970295846462249755, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Ironforge - Difficulty: 0) +(@OGUID+23, 180406, 0, 1537, 1537, '0', 0, 0, -4882.04052734375, -958.47637939453125, 505.988189697265625, 3.769911527633666992, 0, 0, -0.95105648040771484, 0.309017121791839599, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: Ironforge - Difficulty: 0) +(@OGUID+24, 180406, 0, 1537, 5719, '0', 0, 0, -4876.5732421875, -998.62762451171875, 506.957855224609375, 4.188792228698730468, 0, 0, -0.86602497100830078, 0.50000077486038208, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: The Commons - Difficulty: 0) +(@OGUID+25, 180406, 0, 1537, 5719, '0', 0, 0, -4939.24609375, -999.1815185546875, 503.487640380859375, 4.363324165344238281, 0, 0, -0.81915187835693359, 0.573576688766479492, 120, 255, 1, 45745), -- G_Pumpkin_02 (Area: The Commons - Difficulty: 0) +(@OGUID+26, 180407, 0, 1537, 1537, '0', 0, 0, -5018.09130859375, -827.22796630859375, 505.487213134765625, 4.834563255310058593, 0, 0, -0.66261959075927734, 0.748956084251403808, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Ironforge - Difficulty: 0) +(@OGUID+27, 180407, 0, 1537, 1537, '0', 0, 0, -4940.6220703125, -914.50823974609375, 514.966064453125, 1.082102894783020019, 0, 0, 0.51503753662109375, 0.857167601585388183, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Ironforge - Difficulty: 0) +(@OGUID+28, 180407, 0, 1537, 1537, '0', 0, 0, -4944.7734375, -933.1199951171875, 503.59613037109375, 4.206246376037597656, 0, 0, -0.86162853240966796, 0.50753939151763916, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Ironforge - Difficulty: 0) +(@OGUID+29, 180407, 0, 1537, 1537, '0', 0, 0, -4896.19677734375, -917.08355712890625, 503.58935546875, 0.820303261280059814, 0, 0, 0.398748397827148437, 0.917060375213623046, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Ironforge - Difficulty: 0) +(@OGUID+30, 180407, 0, 1537, 1537, '0', 0, 0, -4963.49853515625, -972.52911376953125, 503.58935546875, 1.343901276588439941, 0, 0, 0.622513771057128906, 0.78260880708694458, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Ironforge - Difficulty: 0) +(@OGUID+31, 180407, 0, 1537, 1537, '0', 0, 0, -4835.7294921875, -860.53656005859375, 510.247833251953125, 5.166176319122314453, 0, 0, -0.52991867065429687, 0.84804844856262207, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Ironforge - Difficulty: 0) +(@OGUID+32, 180407, 0, 1537, 1537, '0', 0, 0, -4839.59033203125, -874.0457763671875, 511.13970947265625, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Ironforge - Difficulty: 0) +(@OGUID+33, 180407, 0, 1537, 1537, '0', 0, 0, -4881.75634765625, -950.1873779296875, 503.399261474609375, 3.839725255966186523, 0, 0, -0.93969249725341796, 0.34202045202255249, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: Ironforge - Difficulty: 0) +(@OGUID+34, 180407, 0, 1537, 5719, '0', 0, 0, -4909.0869140625, -978.534423828125, 503.59967041015625, 3.403396368026733398, 0, 0, -0.99144458770751953, 0.130528271198272705, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: The Commons - Difficulty: 0) +(@OGUID+35, 180407, 0, 1537, 5719, '0', 0, 0, -4922.03759765625, -985.384765625, 501.451324462890625, 4.188792228698730468, 0, 0, -0.86602497100830078, 0.50000077486038208, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: The Commons - Difficulty: 0) +(@OGUID+36, 180407, 0, 1537, 5719, '0', 0, 0, -4936.35498046875, -995.56488037109375, 503.487640380859375, 4.345870018005371093, 0, 0, -0.82412624359130859, 0.566406130790710449, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: The Commons - Difficulty: 0) +(@OGUID+37, 180407, 0, 1537, 5719, '0', 0, 0, -4886.5703125, -1007.10821533203125, 506.957855224609375, 4.136432647705078125, 0, 0, -0.87881660461425781, 0.477159708738327026, 120, 255, 1, 45745), -- G_Pumpkin_03 (Area: The Commons - Difficulty: 0) +(@OGUID+38, 180411, 0, 1537, 1537, '0', 0, 0, -4849.771484375, -878.50732421875, 506.66607666015625, 1.221729278564453125, 0, 0, 0.573575973510742187, 0.819152355194091796, 120, 255, 1, 45745), -- G_Ghost_01 (Area: Ironforge - Difficulty: 0) +(@OGUID+39, 180411, 0, 1537, 5719, '0', 0, 0, -4883.40625, -1001.21881103515625, 508.31005859375, 4.991643905639648437, 0, 0, -0.60181427001953125, 0.798636078834533691, 120, 255, 1, 45745), -- G_Ghost_01 (Area: The Commons - Difficulty: 0) +(@OGUID+40, 180415, 0, 1537, 1537, '0', 0, 0, -4957.9287109375, -928.28179931640625, 505.37689208984375, 4.834563255310058593, 0, 0, -0.66261959075927734, 0.748956084251403808, 120, 255, 1, 45745), -- CandleBlack01 (Area: Ironforge - Difficulty: 0) +(@OGUID+41, 180415, 0, 1537, 1537, '0', 0, 0, -4941.94775390625, -915.01739501953125, 505.37689208984375, 5.183629035949707031, 0, 0, -0.52249813079833984, 0.852640450000762939, 120, 255, 1, 45745), -- CandleBlack01 (Area: Ironforge - Difficulty: 0) +(@OGUID+42, 180415, 0, 1537, 1537, '0', 0, 0, -4943.302734375, -916.166259765625, 505.37689208984375, 6.161012649536132812, 0, 0, -0.06104850769042968, 0.998134791851043701, 120, 255, 1, 45745), -- CandleBlack01 (Area: Ironforge - Difficulty: 0) +(@OGUID+43, 180415, 0, 1537, 1537, '0', 0, 0, -4955.7431640625, -896.0538330078125, 505.200958251953125, 1.047197580337524414, 0, 0, 0.5, 0.866025388240814208, 120, 255, 1, 45745), -- CandleBlack01 (Area: Ironforge - Difficulty: 0) +(@OGUID+44, 180415, 0, 1537, 1537, '0', 0, 0, -4959.265625, -929.35577392578125, 505.37689208984375, 4.136432647705078125, 0, 0, -0.87881660461425781, 0.477159708738327026, 120, 255, 1, 45745), -- CandleBlack01 (Area: Ironforge - Difficulty: 0) +(@OGUID+45, 180415, 0, 1537, 1537, '0', 0, 0, -4955.1982421875, -926.044189453125, 505.37689208984375, 6.178466320037841796, 0, 0, -0.05233573913574218, 0.998629570007324218, 120, 255, 1, 45745), -- CandleBlack01 (Area: Ironforge - Difficulty: 0) +(@OGUID+46, 180415, 0, 1537, 1537, '0', 0, 0, -4960.6396484375, -930.4656982421875, 505.37689208984375, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 45745), -- CandleBlack01 (Area: Ironforge - Difficulty: 0) +(@OGUID+47, 180415, 0, 1537, 1537, '0', 0, 0, -4956.62841796875, -927.19097900390625, 505.37689208984375, 0.471238493919372558, 0, 0, 0.233445167541503906, 0.972369968891143798, 120, 255, 1, 45745), -- CandleBlack01 (Area: Ironforge - Difficulty: 0) +(@OGUID+48, 180415, 0, 1537, 1537, '0', 0, 0, -4940.43994140625, -913.79864501953125, 505.37689208984375, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 120, 255, 1, 45745), -- CandleBlack01 (Area: Ironforge - Difficulty: 0) +(@OGUID+49, 180415, 0, 1537, 1537, '0', 0, 0, -4937.15625, -911.08538818359375, 505.37689208984375, 4.363324165344238281, 0, 0, -0.81915187835693359, 0.573576688766479492, 120, 255, 1, 45745), -- CandleBlack01 (Area: Ironforge - Difficulty: 0) +(@OGUID+50, 180415, 0, 1537, 1537, '0', 0, 0, -4955.5537109375, -896.262939453125, 505.04833984375, 5.619962215423583984, 0, 0, -0.32556724548339843, 0.945518851280212402, 120, 255, 1, 45745), -- CandleBlack01 (Area: Ironforge - Difficulty: 0) +(@OGUID+51, 180415, 0, 1537, 1537, '0', 0, 0, -4938.955078125, -912.55645751953125, 505.37689208984375, 4.869470596313476562, 0, 0, -0.64944744110107421, 0.760406434535980224, 120, 255, 1, 45745), -- CandleBlack01 (Area: Ironforge - Difficulty: 0) +(@OGUID+52, 180415, 0, 1537, 1537, '0', 0, 0, -4846.251953125, -865.09375, 502.74017333984375, 2.70525527000427246, 0, 0, 0.97629547119140625, 0.216442063450813293, 120, 255, 1, 45745), -- CandleBlack01 (Area: Ironforge - Difficulty: 0) +(@OGUID+53, 180415, 0, 1537, 1537, '0', 0, 0, -4849.1953125, -865.3992919921875, 511.16314697265625, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 45745), -- CandleBlack01 (Area: Ironforge - Difficulty: 0) +(@OGUID+54, 180415, 0, 1537, 1537, '0', 0, 0, -4837.81591796875, -867.01214599609375, 502.8790283203125, 4.206246376037597656, 0, 0, -0.86162853240966796, 0.50753939151763916, 120, 255, 1, 45745), -- CandleBlack01 (Area: Ironforge - Difficulty: 0) +(@OGUID+55, 180425, 0, 1537, 1537, '0', 0, 0, -4958.61474609375, -928.82183837890625, 505.37689208984375, 5.410521507263183593, 0, 0, -0.42261791229248046, 0.906307935714721679, 120, 255, 1, 45745), -- SkullCandle01 (Area: Ironforge - Difficulty: 0) +(@OGUID+56, 180425, 0, 1537, 1537, '0', 0, 0, -4955.93701171875, -926.625244140625, 505.37689208984375, 5.410521507263183593, 0, 0, -0.42261791229248046, 0.906307935714721679, 120, 255, 1, 45745), -- SkullCandle01 (Area: Ironforge - Difficulty: 0) +(@OGUID+57, 180425, 0, 1537, 1537, '0', 0, 0, -4942.63330078125, -915.615234375, 505.37689208984375, 5.393068790435791015, 0, 0, -0.43051052093505859, 0.902585566043853759, 120, 255, 1, 45745), -- SkullCandle01 (Area: Ironforge - Difficulty: 0) +(@OGUID+58, 180425, 0, 1537, 1537, '0', 0, 0, -4959.98681640625, -929.9571533203125, 505.37689208984375, 5.462882041931152343, 0, 0, -0.39874839782714843, 0.917060375213623046, 120, 255, 1, 45745), -- SkullCandle01 (Area: Ironforge - Difficulty: 0) +(@OGUID+59, 180425, 0, 1537, 1537, '0', 0, 0, -4957.25341796875, -927.7078857421875, 505.37689208984375, 5.462882041931152343, 0, 0, -0.39874839782714843, 0.917060375213623046, 120, 255, 1, 45745), -- SkullCandle01 (Area: Ironforge - Difficulty: 0) +(@OGUID+60, 180425, 0, 1537, 1537, '0', 0, 0, -4955.84814453125, -896.46124267578125, 505.221954345703125, 5.096362113952636718, 0, 0, -0.55919265747070312, 0.829037725925445556, 120, 255, 1, 45745), -- SkullCandle01 (Area: Ironforge - Difficulty: 0) +(@OGUID+61, 180425, 0, 1537, 1537, '0', 0, 0, -4938.1318359375, -911.855712890625, 505.37689208984375, 5.427974700927734375, 0, 0, -0.41469287872314453, 0.909961462020874023, 120, 255, 1, 45745), -- SkullCandle01 (Area: Ironforge - Difficulty: 0) +(@OGUID+62, 180425, 0, 1537, 1537, '0', 0, 0, -4939.71044921875, -913.1580810546875, 505.37689208984375, 5.427974700927734375, 0, 0, -0.41469287872314453, 0.909961462020874023, 120, 255, 1, 45745), -- SkullCandle01 (Area: Ironforge - Difficulty: 0) +(@OGUID+63, 180425, 0, 1537, 1537, '0', 0, 0, -4941.24072265625, -914.404296875, 505.37689208984375, 5.480334281921386718, 0, 0, -0.39073085784912109, 0.920504987239837646, 120, 255, 1, 45745), -- SkullCandle01 (Area: Ironforge - Difficulty: 0) +(@OGUID+64, 180425, 0, 1537, 1537, '0', 0, 0, -4846.0537109375, -864.82464599609375, 502.87213134765625, 5.218535900115966796, 0, 0, -0.507537841796875, 0.861629426479339599, 120, 255, 1, 45745), -- SkullCandle01 (Area: Ironforge - Difficulty: 0) +(@OGUID+65, 180425, 0, 1537, 1537, '0', 0, 0, -4849.30029296875, -866.21875, 511.211822509765625, 0.837757468223571777, 0, 0, 0.406736373901367187, 0.913545548915863037, 120, 255, 1, 45745), -- SkullCandle01 (Area: Ironforge - Difficulty: 0) +(@OGUID+66, 180425, 0, 1537, 1537, '0', 0, 0, -4837.330078125, -865.61456298828125, 502.879119873046875, 2.949595451354980468, 0, 0, 0.995395660400390625, 0.095851235091686248, 120, 255, 1, 45745), -- SkullCandle01 (Area: Ironforge - Difficulty: 0) +(@OGUID+67, 180426, 0, 1537, 1537, '0', 0, 0, -4931.57666015625, -947.78472900390625, 513.38287353515625, 0.645771682262420654, 0, 0, 0.317304611206054687, 0.948323667049407958, 120, 255, 1, 45745), -- Bat01 (Area: Ironforge - Difficulty: 0) +(@OGUID+68, 180426, 0, 1537, 1537, '0', 0, 0, -4927.861328125, -945.00518798828125, 515.46136474609375, 0.27925160527229309, 0, 0, 0.139172554016113281, 0.990268170833587646, 120, 255, 1, 45745), -- Bat01 (Area: Ironforge - Difficulty: 0) +(@OGUID+69, 180426, 0, 1537, 1537, '0', 0, 0, -4928.8525390625, -947.6180419921875, 509.7388916015625, 0.977383077144622802, 0, 0, 0.469470977783203125, 0.882947921752929687, 120, 255, 1, 45745), -- Bat01 (Area: Ironforge - Difficulty: 0) +(@OGUID+70, 180426, 0, 1537, 1537, '0', 0, 0, -4928.72216796875, -947.59893798828125, 511.9814453125, 0.331610709428787231, 0, 0, 0.16504669189453125, 0.986285746097564697, 120, 255, 1, 45745), -- Bat01 (Area: Ironforge - Difficulty: 0) +(@OGUID+71, 180426, 0, 1537, 1537, '0', 0, 0, -4928.7412109375, -947.609375, 514.09259033203125, 5.881760597229003906, 0, 0, -0.19936752319335937, 0.979924798011779785, 120, 255, 1, 45745), -- Bat01 (Area: Ironforge - Difficulty: 0) +(@OGUID+72, 180426, 0, 1537, 1537, '0', 0, 0, -4928.96337890625, -950.28302001953125, 515.3365478515625, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 120, 255, 1, 45745), -- Bat01 (Area: Ironforge - Difficulty: 0) +(@OGUID+73, 180426, 0, 1537, 1537, '0', 0, 0, -4928.69091796875, -947.43927001953125, 521.35711669921875, 2.181660413742065429, 0, 0, 0.887010574340820312, 0.461749136447906494, 120, 255, 1, 45745), -- Bat01 (Area: Ironforge - Difficulty: 0) +(@OGUID+74, 180426, 0, 1537, 1537, '0', 0, 0, -4928.671875, -947.66839599609375, 514.348876953125, 5.619962215423583984, 0, 0, -0.32556724548339843, 0.945518851280212402, 120, 255, 1, 45745), -- Bat01 (Area: Ironforge - Difficulty: 0) +(@OGUID+75, 180426, 0, 1537, 1537, '0', 0, 0, -4925.87841796875, -947.7586669921875, 516.1114501953125, 1.134462952613830566, 0, 0, 0.537299156188964843, 0.843391716480255126, 120, 255, 1, 45745), -- Bat01 (Area: Ironforge - Difficulty: 0) +(@OGUID+76, 180426, 0, 1537, 1537, '0', 0, 0, -4928.8681640625, -947.52606201171875, 517.66998291015625, 0.052358884364366531, 0, 0, 0.02617645263671875, 0.999657332897186279, 120, 255, 1, 45745), -- Bat01 (Area: Ironforge - Difficulty: 0) +(@OGUID+77, 180427, 0, 1537, 1537, '0', 0, 0, -4928.73779296875, -947.52777099609375, 511.884674072265625, 4.206246376037597656, 0, 0, -0.86162853240966796, 0.50753939151763916, 120, 255, 1, 45745), -- Bat02 (Area: Ironforge - Difficulty: 0) +(@OGUID+78, 180427, 0, 1537, 1537, '0', 0, 0, -4928.8193359375, -947.4757080078125, 510.558929443359375, 2.251473426818847656, 0, 0, 0.902585029602050781, 0.430511653423309326, 120, 255, 1, 45745), -- Bat02 (Area: Ironforge - Difficulty: 0) +(@OGUID+79, 180427, 0, 1537, 1537, '0', 0, 0, -4928.8662109375, -947.6319580078125, 511.35693359375, 2.164205789566040039, 0, 0, 0.882946968078613281, 0.469472706317901611, 120, 255, 1, 45745), -- Bat02 (Area: Ironforge - Difficulty: 0) +(@OGUID+80, 180427, 0, 1537, 1537, '0', 0, 0, -4928.9462890625, -947.83331298828125, 512.134033203125, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 120, 255, 1, 45745), -- Bat02 (Area: Ironforge - Difficulty: 0) +(@OGUID+81, 180427, 0, 1537, 1537, '0', 0, 0, -4926.798828125, -946.28643798828125, 512.2135009765625, 1.029743075370788574, 0, 0, 0.492423057556152343, 0.870355963706970214, 120, 255, 1, 45745), -- Bat02 (Area: Ironforge - Difficulty: 0) +(@OGUID+82, 180427, 0, 1537, 1537, '0', 0, 0, -4928.751953125, -947.8507080078125, 511.09136962890625, 3.577930212020874023, 0, 0, -0.97629547119140625, 0.216442063450813293, 120, 255, 1, 45745), -- Bat02 (Area: Ironforge - Difficulty: 0) +(@OGUID+83, 180427, 0, 1537, 1537, '0', 0, 0, -4927.2880859375, -949.342041015625, 513.88909912109375, 0.977383077144622802, 0, 0, 0.469470977783203125, 0.882947921752929687, 120, 255, 1, 45745), -- Bat02 (Area: Ironforge - Difficulty: 0) +(@OGUID+84, 180427, 0, 1537, 1537, '0', 0, 0, -4928.5869140625, -947.76214599609375, 513.11883544921875, 4.59021615982055664, 0, 0, -0.74895572662353515, 0.662620067596435546, 120, 255, 1, 45745), -- Bat02 (Area: Ironforge - Difficulty: 0) +(@OGUID+85, 180427, 0, 1537, 1537, '0', 0, 0, -4928.41162109375, -947.6007080078125, 513.528564453125, 3.001946926116943359, 0, 0, 0.997563362121582031, 0.069766148924827575, 120, 255, 1, 45745), -- Bat02 (Area: Ironforge - Difficulty: 0) +(@OGUID+86, 180427, 0, 1537, 1537, '0', 0, 0, -4930.28662109375, -948.92364501953125, 509.870819091796875, 0.366517573595046997, 0, 0, 0.182234764099121093, 0.98325502872467041, 120, 255, 1, 45745), -- Bat02 (Area: Ironforge - Difficulty: 0) +(@OGUID+87, 180471, 0, 1537, 1537, '0', 0, 0, -4934.767578125, -910.578125, 510.15924072265625, 0.628316879272460937, 0, 0, 0.309016227722167968, 0.95105677843093872, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ironforge - Difficulty: 0) +(@OGUID+88, 180471, 0, 1537, 1537, '0', 0, 0, -4960.97216796875, -932.6805419921875, 509.7530517578125, 0.593410074710845947, 0, 0, 0.292370796203613281, 0.95630502700805664, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ironforge - Difficulty: 0) +(@OGUID+89, 180471, 0, 1537, 1537, '0', 0, 0, -4947.46533203125, -920.88543701171875, 509.991363525390625, 0.750490784645080566, 0, 0, 0.3665008544921875, 0.93041771650314331, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ironforge - Difficulty: 0) +(@OGUID+90, 180471, 0, 1537, 1537, '0', 0, 0, -4955.48095703125, -928.0555419921875, 509.8668212890625, 0.628316879272460937, 0, 0, 0.309016227722167968, 0.95105677843093872, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ironforge - Difficulty: 0) +(@OGUID+91, 180471, 0, 1537, 1537, '0', 0, 0, -4937.27783203125, -912.6632080078125, 510.1572265625, 0.383971005678176879, 0, 0, 0.190808296203613281, 0.981627285480499267, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ironforge - Difficulty: 0) +(@OGUID+92, 180471, 0, 1537, 1537, '0', 0, 0, -4952.8056640625, -925.55035400390625, 509.851287841796875, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ironforge - Difficulty: 0) +(@OGUID+93, 180471, 0, 1537, 1537, '0', 0, 0, -4945.0712890625, -918.95831298828125, 509.975799560546875, 0.872663915157318115, 0, 0, 0.422617912292480468, 0.906307935714721679, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ironforge - Difficulty: 0) +(@OGUID+94, 180471, 0, 1537, 1537, '0', 0, 0, -4950.1962890625, -923.3194580078125, 509.88177490234375, 0.715584874153137207, 0, 0, 0.350207328796386718, 0.936672210693359375, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ironforge - Difficulty: 0) +(@OGUID+95, 180471, 0, 1537, 1537, '0', 0, 0, -4942.47900390625, -916.8350830078125, 509.991851806640625, 0.698131442070007324, 0, 0, 0.342020034790039062, 0.939692676067352294, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ironforge - Difficulty: 0) +(@OGUID+96, 180471, 0, 1537, 1537, '0', 0, 0, -4939.85595703125, -914.72222900390625, 510.08544921875, 0.680676698684692382, 0, 0, 0.333806037902832031, 0.942641794681549072, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ironforge - Difficulty: 0) +(@OGUID+97, 180471, 0, 1537, 1537, '0', 0, 0, -4958.2744140625, -930.33856201171875, 509.757476806640625, 0.837757468223571777, 0, 0, 0.406736373901367187, 0.913545548915863037, 120, 255, 1, 45745), -- HangingSkullLight01 (Area: Ironforge - Difficulty: 0) +(@OGUID+98, 180472, 0, 1537, 1537, '0', 0, 0, -4842.5693359375, -857.8194580078125, 506.665313720703125, 4.782202720642089843, 0, 0, -0.68199825286865234, 0.731353819370269775, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: Ironforge - Difficulty: 0) +(@OGUID+99, 180472, 0, 1537, 5719, '0', 0, 0, -4896.71875, -1003.2882080078125, 508.574493408203125, 2.303830623626708984, 0, 0, 0.913544654846191406, 0.406738430261611938, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: The Commons - Difficulty: 0) +(@OGUID+100, 180472, 0, 1537, 5719, '0', 0, 0, -4887.74853515625, -995.8497314453125, 508.6065673828125, 2.530723094940185546, 0, 0, 0.953716278076171875, 0.300707906484603881, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: The Commons - Difficulty: 0) +(@OGUID+101, 180472, 0, 1537, 5719, '0', 0, 0, -4878.736328125, -988.529541015625, 508.603424072265625, 2.303830623626708984, 0, 0, 0.913544654846191406, 0.406738430261611938, 120, 255, 1, 45745), -- HangingSkullLight02 (Area: The Commons - Difficulty: 0) +(@OGUID+102, 180523, 0, 1537, 1537, '0', 0, 0, -4839.1806640625, -863.86456298828125, 510.518280029296875, 2.862335443496704101, 0, 0, 0.990267753601074218, 0.139175355434417724, 120, 255, 1, 45745), -- Apple Bob (Area: Ironforge - Difficulty: 0) +(@OGUID+103, 190039, 0, 1537, 1537, '0', 0, 0, -4838.04443359375, -858.582275390625, 502.78167724609375, 5.829400539398193359, 0, 0, -0.22495079040527343, 0.974370121955871582, 120, 255, 1, 45745); -- Candy Bucket (Area: Ironforge - Difficulty: 0) + +-- Dwarf/Gnome Commoner spawns +DELETE FROM `game_event_creature` WHERE `eventEntry`=12 AND `guid` BETWEEN 850277 AND 850280; +INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES +(12, 850277), +(12, 850278), +(12, 850279), +(12, 850280); + +-- Event spawns +DELETE FROM `game_event_creature` WHERE `eventEntry`=12 AND `guid` IN (@CGUID+0, @CGUID+1); +INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES +(12, @CGUID+0), +(12, @CGUID+1); + +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+103; +INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES +(12, @OGUID+0), +(12, @OGUID+1), +(12, @OGUID+2), +(12, @OGUID+3), +(12, @OGUID+4), +(12, @OGUID+5), +(12, @OGUID+6), +(12, @OGUID+7), +(12, @OGUID+8), +(12, @OGUID+9), +(12, @OGUID+10), +(12, @OGUID+11), +(12, @OGUID+12), +(12, @OGUID+13), +(12, @OGUID+14), +(12, @OGUID+15), +(12, @OGUID+16), +(12, @OGUID+17), +(12, @OGUID+18), +(12, @OGUID+19), +(12, @OGUID+20), +(12, @OGUID+21), +(12, @OGUID+22), +(12, @OGUID+23), +(12, @OGUID+24), +(12, @OGUID+25), +(12, @OGUID+26), +(12, @OGUID+27), +(12, @OGUID+28), +(12, @OGUID+29), +(12, @OGUID+30), +(12, @OGUID+31), +(12, @OGUID+32), +(12, @OGUID+33), +(12, @OGUID+34), +(12, @OGUID+35), +(12, @OGUID+36), +(12, @OGUID+37), +(12, @OGUID+38), +(12, @OGUID+39), +(12, @OGUID+40), +(12, @OGUID+41), +(12, @OGUID+42), +(12, @OGUID+43), +(12, @OGUID+44), +(12, @OGUID+45), +(12, @OGUID+46), +(12, @OGUID+47), +(12, @OGUID+48), +(12, @OGUID+49), +(12, @OGUID+50), +(12, @OGUID+51), +(12, @OGUID+52), +(12, @OGUID+53), +(12, @OGUID+54), +(12, @OGUID+55), +(12, @OGUID+56), +(12, @OGUID+57), +(12, @OGUID+58), +(12, @OGUID+59), +(12, @OGUID+60), +(12, @OGUID+61), +(12, @OGUID+62), +(12, @OGUID+63), +(12, @OGUID+64), +(12, @OGUID+65), +(12, @OGUID+66), +(12, @OGUID+67), +(12, @OGUID+68), +(12, @OGUID+69), +(12, @OGUID+70), +(12, @OGUID+71), +(12, @OGUID+72), +(12, @OGUID+73), +(12, @OGUID+74), +(12, @OGUID+75), +(12, @OGUID+76), +(12, @OGUID+77), +(12, @OGUID+78), +(12, @OGUID+79), +(12, @OGUID+80), +(12, @OGUID+81), +(12, @OGUID+82), +(12, @OGUID+83), +(12, @OGUID+84), +(12, @OGUID+85), +(12, @OGUID+86), +(12, @OGUID+87), +(12, @OGUID+88), +(12, @OGUID+89), +(12, @OGUID+90), +(12, @OGUID+91), +(12, @OGUID+92), +(12, @OGUID+93), +(12, @OGUID+94), +(12, @OGUID+95), +(12, @OGUID+96), +(12, @OGUID+97), +(12, @OGUID+98), +(12, @OGUID+99), +(12, @OGUID+100), +(12, @OGUID+101), +(12, @OGUID+102), +(12, @OGUID+103); |