diff options
| -rw-r--r-- | sql/updates/world/master/2022_12_06_00_world.sql | 211 |
1 files changed, 211 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_12_06_00_world.sql b/sql/updates/world/master/2022_12_06_00_world.sql new file mode 100644 index 00000000000..4fe5e72d9d0 --- /dev/null +++ b/sql/updates/world/master/2022_12_06_00_world.sql @@ -0,0 +1,211 @@ +SET @CGUID := 396469; +SET @OGUID := 248631; +SET @EVENT := 26; + +-- Gossips +UPDATE `gossip_menu` SET `VerifiedBuild`=46702 WHERE (`MenuID`=10575 AND `TextID`=14633) OR (`MenuID`=12520 AND `TextID`=17608) OR (`MenuID`=10589 AND `TextID`=14648); + +UPDATE `gossip_menu_option` SET `VerifiedBuild`=46702 WHERE (`MenuID`=10575 AND `OptionID`=0); + +-- Equipments +UPDATE `creature_equip_template` SET `VerifiedBuild`=46702 WHERE (`ID`=1 AND `CreatureID` IN (175135,168459,150131,149626,149270,148795,148770,148263,148250,148242,133186,89830,88703,88702,88701,74228,72559,71100,62195,58155,54870,51346,50304,49750,49622,47571,47253,46556,46555,46359,46358,46357,46142,46140,45339,45337,44878,44877,44876,44872,44871,44851,42637,37072,35068,34723,34721,34719,34718,34717,34715,34713,34679,31727,31726,31725,31724,31723,31720,23128,14720,14392,6929,6566,6466,5817,5614,5613,5611,5610,5609,5606,5188,4311,4047,3370,3342,3323,3314,3313,3312,3296,3144,3084)) OR (`ID`=2 AND `CreatureID` IN (74228,3296)); + +-- Scaling +UPDATE `creature_template_scaling` SET `VerifiedBuild`=46702 WHERE (`DifficultyID`=0 AND `Entry` IN (188656,188655,188157,187758,175135,173548,168459,155739,151937,150131,149626,149523,149522,149371,149297,149296,149279,149270,149258,148795,148770,148263,148250,148242,143622,137762,135202,135201,133186,121541,89830,88703,88702,88701,74228,72654,72559,71163,71100,62822,62821,62195,62116,62115,62114,58155,54870,52034,51346,51195,50304,49837,49750,49743,49622,49131,47571,47253,46572,46556,46555,46512,46359,46358,46357,46142,46140,45339,45337,44878,44877,44876,44872,44871,44868,44867,44866,44865,44856,44854,44853,44852,44851,44338,43499,42859,42637,42504,40891,39380,39379,38821,37072,35342,35068,34824,34823,34822,34819,34812,34730,34723,34721,34719,34718,34717,34715,34713,34685,34679,34654,32840,32839,32831,32830,32829,32827,32825,32824,32823,31727,31726,31725,31724,31723,31720,28960,27489,25075,24935,24934,23128,19175,17098,14720,14392,6929,6566,6466,5951,5817,5614,5613,5611,5610,5609,5606,5188,4311,4047,3370,3342,3323,3319,3314,3313,3312,3296,3144,3084)); + +-- Trainer +DELETE FROM `creature_trainer` WHERE `CreatureID`=34713; +INSERT INTO `creature_trainer` (`CreatureID`, `TrainerID`, `MenuID`, `OptionID`) VALUES +(34713, 136, 10569, 0); + +-- Quests +UPDATE `quest_poi` SET `VerifiedBuild`=46702 WHERE (`QuestID`=14036 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=14062 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=14062 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=14061 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=14061 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=14065 AND `BlobIndex`=11 AND `Idx1`=55) OR (`QuestID`=14065 AND `BlobIndex`=10 AND `Idx1`=54) OR (`QuestID`=14065 AND `BlobIndex`=9 AND `Idx1`=53) OR (`QuestID`=14065 AND `BlobIndex`=8 AND `Idx1`=52) OR (`QuestID`=14065 AND `BlobIndex`=7 AND `Idx1`=51) OR (`QuestID`=14065 AND `BlobIndex`=6 AND `Idx1`=50) OR (`QuestID`=14065 AND `BlobIndex`=5 AND `Idx1`=49) OR (`QuestID`=14065 AND `BlobIndex`=4 AND `Idx1`=48) OR (`QuestID`=14065 AND `BlobIndex`=3 AND `Idx1`=47) OR (`QuestID`=14065 AND `BlobIndex`=2 AND `Idx1`=46) OR (`QuestID`=14065 AND `BlobIndex`=1 AND `Idx1`=45) OR (`QuestID`=14065 AND `BlobIndex`=0 AND `Idx1`=44) OR (`QuestID`=14065 AND `BlobIndex`=43 AND `Idx1`=43) OR (`QuestID`=14065 AND `BlobIndex`=42 AND `Idx1`=42) OR (`QuestID`=14065 AND `BlobIndex`=41 AND `Idx1`=41) OR (`QuestID`=14065 AND `BlobIndex`=40 AND `Idx1`=40) OR (`QuestID`=14065 AND `BlobIndex`=39 AND `Idx1`=39) OR (`QuestID`=14065 AND `BlobIndex`=38 AND `Idx1`=38) OR (`QuestID`=14065 AND `BlobIndex`=37 AND `Idx1`=37) OR (`QuestID`=14065 AND `BlobIndex`=36 AND `Idx1`=36) OR (`QuestID`=14065 AND `BlobIndex`=35 AND `Idx1`=35) OR (`QuestID`=14065 AND `BlobIndex`=34 AND `Idx1`=34) OR (`QuestID`=14065 AND `BlobIndex`=33 AND `Idx1`=33) OR (`QuestID`=14065 AND `BlobIndex`=32 AND `Idx1`=32) OR (`QuestID`=14065 AND `BlobIndex`=31 AND `Idx1`=31) OR (`QuestID`=14065 AND `BlobIndex`=30 AND `Idx1`=30) OR (`QuestID`=14065 AND `BlobIndex`=29 AND `Idx1`=29) OR (`QuestID`=14065 AND `BlobIndex`=28 AND `Idx1`=28) OR (`QuestID`=14065 AND `BlobIndex`=27 AND `Idx1`=27) OR (`QuestID`=14065 AND `BlobIndex`=26 AND `Idx1`=26) OR (`QuestID`=14065 AND `BlobIndex`=25 AND `Idx1`=25) OR (`QuestID`=14065 AND `BlobIndex`=24 AND `Idx1`=24) OR (`QuestID`=14065 AND `BlobIndex`=23 AND `Idx1`=23) OR (`QuestID`=14065 AND `BlobIndex`=22 AND `Idx1`=22) OR (`QuestID`=14065 AND `BlobIndex`=21 AND `Idx1`=21) OR (`QuestID`=14065 AND `BlobIndex`=20 AND `Idx1`=20) OR (`QuestID`=14065 AND `BlobIndex`=19 AND `Idx1`=19) OR (`QuestID`=14065 AND `BlobIndex`=18 AND `Idx1`=18) OR (`QuestID`=14065 AND `BlobIndex`=17 AND `Idx1`=17) OR (`QuestID`=14065 AND `BlobIndex`=16 AND `Idx1`=16) OR (`QuestID`=14065 AND `BlobIndex`=15 AND `Idx1`=15) OR (`QuestID`=14065 AND `BlobIndex`=14 AND `Idx1`=14) OR (`QuestID`=14065 AND `BlobIndex`=13 AND `Idx1`=13) OR (`QuestID`=14065 AND `BlobIndex`=12 AND `Idx1`=12) OR (`QuestID`=14065 AND `BlobIndex`=11 AND `Idx1`=11) OR (`QuestID`=14065 AND `BlobIndex`=10 AND `Idx1`=10) OR (`QuestID`=14065 AND `BlobIndex`=9 AND `Idx1`=9) OR (`QuestID`=14065 AND `BlobIndex`=8 AND `Idx1`=8) OR (`QuestID`=14065 AND `BlobIndex`=7 AND `Idx1`=7) OR (`QuestID`=14065 AND `BlobIndex`=6 AND `Idx1`=6) OR (`QuestID`=14065 AND `BlobIndex`=5 AND `Idx1`=5) OR (`QuestID`=14065 AND `BlobIndex`=4 AND `Idx1`=4) OR (`QuestID`=14065 AND `BlobIndex`=3 AND `Idx1`=3) OR (`QuestID`=14065 AND `BlobIndex`=2 AND `Idx1`=2) OR (`QuestID`=14065 AND `BlobIndex`=1 AND `Idx1`=1) OR (`QuestID`=14065 AND `BlobIndex`=0 AND `Idx1`=0); + +UPDATE `quest_poi_points` SET `VerifiedBuild`=46702 WHERE (`QuestID`=14036 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=14062 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=14062 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=14061 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=14061 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=55 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=54 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=53 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=52 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=51 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=50 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=49 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=48 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=47 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=46 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=45 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=44 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=43 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=42 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=41 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=40 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=39 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=38 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=37 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=36 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=35 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=34 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=33 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=32 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=31 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=30 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=29 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=28 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=27 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=26 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=25 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=24 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=23 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=22 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=21 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=20 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=19 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=18 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=17 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=16 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=15 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=14 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=13 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=12 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=11 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=10 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=9 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=8 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=7 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=6 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=5 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=4 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=3 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=14065 AND `Idx1`=0 AND `Idx2`=0); + +DELETE FROM `quest_details` WHERE `ID` IN (14036 /*Pilgrim's Bounty*/, 14062 /*Don't Forget The Stuffing!*/, 14061 /*Can't Get Enough Turkey*/, 14065 /*Sharing a Bountiful Feast*/); +INSERT INTO `quest_details` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `VerifiedBuild`) VALUES +(14036, 1, 1, 0, 0, 0, 0, 0, 0, 46702), -- Pilgrim's Bounty +(14061, 1, 1, 0, 0, 0, 0, 0, 0, 46702), -- Can't Get Enough Turkey +(14062, 1, 1, 0, 0, 0, 0, 0, 0, 46702), -- Don't Forget The Stuffing! +(14065, 1, 0, 0, 0, 0, 0, 0, 0, 46702); -- Sharing a Bountiful Feast + +UPDATE `quest_request_items` SET `EmoteOnIncomplete`=1 WHERE `ID`=14061; +UPDATE `quest_request_items` SET `EmoteOnComplete`=1, `EmoteOnIncomplete`=1, `VerifiedBuild`=46702 WHERE `ID`=14062; -- Don't Forget The Stuffing! +UPDATE `quest_request_items` SET `VerifiedBuild`=46702 WHERE `ID`=14065; + +UPDATE `quest_offer_reward` SET `Emote1`=1, `VerifiedBuild`=46702 WHERE `ID`=14065; -- Sharing a Bountiful Feast +UPDATE `quest_offer_reward` SET `Emote1`=5, `Emote2`=1, `VerifiedBuild`=46702 WHERE `ID`=14062; -- Don't Forget The Stuffing! + +UPDATE `creature_queststarter` SET `VerifiedBuild`=46702 WHERE (`id`=34713 AND `quest` IN (14062,14061)) OR (`id`=34654 AND `quest`=14065); + +UPDATE `creature_questender` SET `VerifiedBuild`=46702 WHERE (`id`=34654 AND `quest`=14065) OR (`id`=34713 AND `quest` IN (14062,14061)); + +-- Creature spawns +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+10; +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, 32823, 1, 14, 4982, '0', 0, 0, 0, 0, 1276.8472900390625, -4415.20166015625, 26.49131965637207031, 1.274090290069580078, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46702), -- Bountiful Table (Area: The Dranosh'ar Blockade - Difficulty: 0) (Auras: ) +(@CGUID+1, 32823, 1, 14, 4982, '0', 0, 0, 0, 0, 1295.0086669921875, -4412.328125, 26.67513656616210937, 2.042035102844238281, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46702), -- Bountiful Table (Area: The Dranosh'ar Blockade - Difficulty: 0) (Auras: ) +(@CGUID+2, 32823, 1, 14, 4982, '0', 0, 0, 0, 0, 1293.576416015625, -4428.80224609375, 26.9217681884765625, 0, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46702), -- Bountiful Table (Area: The Dranosh'ar Blockade - Difficulty: 0) (Auras: ) +(@CGUID+3, 32823, 1, 14, 4982, '0', 0, 0, 0, 0, 1279.30908203125, -4430.4130859375, 26.98611259460449218, 2.042035102844238281, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46702), -- Bountiful Table (Area: The Dranosh'ar Blockade - Difficulty: 0) (Auras: ) +(@CGUID+4, 34654, 1, 14, 4982, '0', 0, 0, 0, 0, 1304.060791015625, -4407.546875, 26.32804298400878906, 6.038839340209960937, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46702), -- Bountiful Feast Hostess (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@CGUID+5, 34679, 1, 14, 4982, '0', 0, 0, 0, 1, 1321.890625, -4425.7412109375, 25.1535797119140625, 3.455751895904541015, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46702), -- Francis Eaton (Area: The Dranosh'ar Blockade - Difficulty: 0) (Auras: ) +(@CGUID+6, 34685, 1, 14, 4982, '0', 0, 0, 0, 0, 1322.2239990234375, -4427.3212890625, 25.11901473999023437, 3.368485450744628906, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46702), -- Dalni Tallgrass (Area: The Dranosh'ar Blockade - Difficulty: 0) (Auras: ) +(@CGUID+7, 34713, 1, 14, 4982, '0', 0, 0, 0, 1, 1319.8697509765625, -4414.03125, 25.01573371887207031, 3.228859186172485351, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46702), -- Ondani Greatmill (Area: The Dranosh'ar Blockade - Difficulty: 0) (Auras: ) +(@CGUID+8, 35342, 1, 14, 4982, '0', 0, 0, 0, 0, 1323.5069580078125, -4428.765625, 24.54776954650878906, 0, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46702), -- Bountiful Barrel (Area: The Dranosh'ar Blockade - Difficulty: 0) (Auras: ) +(@CGUID+9, 35342, 1, 14, 4982, '0', 0, 0, 0, 0, 1323.4132080078125, -4425.939453125, 24.53654861450195312, 4.817108631134033203, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46702), -- Bountiful Barrel (Area: The Dranosh'ar Blockade - Difficulty: 0) (Auras: ) +(@CGUID+10, 35342, 1, 14, 4982, '0', 0, 0, 0, 0, 1324.1910400390625, -4427.68408203125, 24.53653526306152343, 5.375614166259765625, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46702); -- Bountiful Barrel (Area: The Dranosh'ar Blockade - Difficulty: 0) (Auras: ) + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+65; +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, 179968, 1, 14, 4982, '0', 0, 0, 1277.3802490234375, -4405.548828125, 26.31678581237792968, 1.518436193466186523, 0, 0, 0.6883544921875, 0.725374460220336914, 120, 255, 1, 46702), -- Haystack 01 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+1, 179968, 1, 14, 4982, '0', 0, 0, 1304.9410400390625, -4425.04150390625, 25.04649925231933593, 0.017452461645007133, 0, 0, 0.008726119995117187, 0.999961912631988525, 120, 255, 1, 46702), -- Haystack 01 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+2, 179968, 1, 14, 4982, '0', 0, 0, 1320.2447509765625, -4414.15625, 24.23568344116210937, 3.106652259826660156, 0, 0, 0.999847412109375, 0.017469281330704689, 120, 255, 1, 46702), -- Haystack 01 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+3, 179968, 1, 14, 4982, '0', 0, 0, 1302.9410400390625, -4409.1494140625, 26.33159828186035156, 0.383971005678176879, 0, 0, 0.190808296203613281, 0.981627285480499267, 120, 255, 1, 46702), -- Haystack 01 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+4, 179968, 1, 14, 4982, '0', 0, 0, 1295.66845703125, -4402.92724609375, 26.57817840576171875, 1.605701684951782226, 0, 0, 0.719339370727539062, 0.694658815860748291, 120, 255, 1, 46702), -- Haystack 01 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+5, 179968, 1, 14, 4982, '0', 0, 0, 1293.263916015625, -4402.76220703125, 26.54281044006347656, 4.625123500823974609, 0, 0, -0.73727703094482421, 0.67559051513671875, 120, 255, 1, 46702), -- Haystack 01 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+6, 179968, 1, 14, 4982, '0', 0, 0, 1292.7396240234375, -4442.40625, 27.61631965637207031, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 120, 255, 1, 46702), -- Haystack 01 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+7, 179968, 1, 14, 4982, '0', 0, 0, 1295.013916015625, -4442.3525390625, 27.46701431274414062, 1.623155713081359863, 0, 0, 0.725374221801757812, 0.688354730606079101, 120, 255, 1, 46702), -- Haystack 01 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+8, 179968, 1, 14, 4982, '0', 0, 0, 1319.48095703125, -4414.1494140625, 24.40517616271972656, 3.211419343948364257, 0, 0, -0.9993906021118164, 0.034906134009361267, 120, 255, 1, 46702), -- Haystack 01 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+9, 179968, 1, 14, 4982, '0', 0, 0, 1321.967041015625, -4425.72900390625, 24.45289039611816406, 3.124123096466064453, 0, 0, 0.99996185302734375, 0.008734640665352344, 120, 255, 1, 46702), -- Haystack 01 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+10, 179968, 1, 14, 4982, '0', 0, 0, 1271.736083984375, -4422.87841796875, 26.55555534362792968, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 46702), -- Haystack 01 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+11, 179968, 1, 14, 4982, '0', 0, 0, 1303.5989990234375, -4411.70849609375, 26.16232109069824218, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 46702), -- Haystack 01 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+12, 179968, 1, 14, 4982, '0', 0, 0, 1271.82470703125, -4425.33837890625, 26.68402862548828125, 3.194002151489257812, 0, 0, -0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46702), -- Haystack 01 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+13, 179968, 1, 14, 4982, '0', 0, 0, 1280.3055419921875, -4441.1962890625, 27.30381965637207031, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 46702), -- Haystack 01 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+14, 179968, 1, 14, 4982, '0', 0, 0, 1320.96875, -4423.70654296875, 24.46972084045410156, 3.78736734390258789, 0, 0, -0.94832324981689453, 0.317305892705917358, 120, 255, 1, 46702), -- Haystack 01 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+15, 179968, 1, 14, 4982, '0', 0, 0, 1322.6336669921875, -4427.44775390625, 24.38968849182128906, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 46702), -- Haystack 01 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+16, 179968, 1, 14, 4982, '0', 0, 0, 1305.0555419921875, -4427.5087890625, 24.90009307861328125, 0.034906249493360519, 0, 0, 0.017452239990234375, 0.999847710132598876, 120, 255, 1, 46702), -- Haystack 01 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+17, 179968, 1, 14, 4982, '0', 0, 0, 1279.6475830078125, -4405.84033203125, 26.4991607666015625, 1.448621988296508789, 0, 0, 0.662619590759277343, 0.748956084251403808, 120, 255, 1, 46702), -- Haystack 01 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+18, 179968, 1, 14, 4982, '0', 0, 0, 1277.920166015625, -4441.05908203125, 27.13855934143066406, 1.605701684951782226, 0, 0, 0.719339370727539062, 0.694658815860748291, 120, 255, 1, 46702), -- Haystack 01 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+19, 179968, 1, 14, 4982, '0', 0, 0, 1321.763916015625, -4427.3837890625, 24.46640396118164062, 3.194002151489257812, 0, 0, -0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46702), -- Haystack 01 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+20, 179968, 1, 14, 4982, '0', 0, 0, 1321.03125, -4430.08154296875, 24.5333099365234375, 2.111847877502441406, 0, 0, 0.870355606079101562, 0.492423713207244873, 120, 255, 1, 46702), -- Haystack 01 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+21, 180353, 1, 14, 4982, '0', 0, 0, 1323.3836669921875, -4411.408203125, 25.90285301208496093, 0, 0, 0, 0, 1, 120, 255, 1, 46702), -- Freestanding Torch 01 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+22, 180353, 1, 14, 4982, '0', 0, 0, 1294.404541015625, -4402.734375, 26.55142021179199218, 0, 0, 0, 0, 1, 120, 255, 1, 46702), -- Freestanding Torch 01 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+23, 180353, 1, 14, 4982, '0', 0, 0, 1322.4427490234375, -4429.18603515625, 24.48129844665527343, 0, 0, 0, 0, 1, 120, 255, 1, 46702), -- Freestanding Torch 01 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+24, 180353, 1, 14, 4982, '0', 0, 0, 1322.21533203125, -4424.501953125, 24.45236015319824218, 0, 0, 0, 0, 1, 120, 255, 1, 46702), -- Freestanding Torch 01 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+25, 180353, 1, 14, 4982, '0', 0, 0, 1279.064208984375, -4441.02978515625, 27.21180534362792968, 0, 0, 0, 0, 1, 120, 255, 1, 46702), -- Freestanding Torch 01 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+26, 180353, 1, 14, 4982, '0', 0, 0, 1323.5694580078125, -4415.953125, 25.89385795593261718, 0, 0, 0, 0, 1, 120, 255, 1, 46702), -- Freestanding Torch 01 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+27, 180353, 1, 14, 4982, '0', 0, 0, 1303.2274169921875, -4410.27978515625, 26.31661033630371093, 0, 0, 0, 0, 1, 120, 255, 1, 46702), -- Freestanding Torch 01 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+28, 180353, 1, 14, 4982, '0', 0, 0, 1271.8992919921875, -4424.1494140625, 26.68923568725585937, 0, 0, 0, 0, 1, 120, 255, 1, 46702), -- Freestanding Torch 01 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+29, 180353, 1, 14, 4982, '0', 0, 0, 1278.5382080078125, -4405.64599609375, 26.39136695861816406, 0, 0, 0, 0, 1, 120, 255, 1, 46702), -- Freestanding Torch 01 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+30, 180353, 1, 14, 4982, '0', 0, 0, 1294.0399169921875, -4442.3193359375, 27.52743339538574218, 0, 0, 0, 0, 1, 120, 255, 1, 46702), -- Freestanding Torch 01 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+31, 180353, 1, 14, 4982, '0', 0, 0, 1305.1007080078125, -4426.37841796875, 24.96751022338867187, 0, 0, 0, 0, 1, 120, 255, 1, 46702), -- Freestanding Torch 01 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+32, 195164, 1, 14, 4982, '0', 0, 0, 1280.4444580078125, -4441.07666015625, 27.97844886779785156, 4.642575740814208984, 0, 0, -0.731353759765625, 0.681998312473297119, 120, 255, 1, 46702), -- Pumpkin (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+33, 195164, 1, 14, 4982, '0', 0, 0, 1294.8785400390625, -4442.49853515625, 28.1468505859375, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 46702), -- Pumpkin (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+34, 195164, 1, 14, 4982, '0', 0, 0, 1277.4774169921875, -4405.59375, 27.00274085998535156, 1.553341388702392578, 0, 0, 0.700908660888671875, 0.713251054286956787, 120, 255, 1, 46702), -- Pumpkin (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+35, 195164, 1, 14, 4982, '0', 0, 0, 1271.5989990234375, -4422.890625, 27.20762062072753906, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 46702), -- Pumpkin (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+36, 195164, 1, 14, 4982, '0', 0, 0, 1295.532958984375, -4403.0712890625, 27.26003837585449218, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 46702), -- Pumpkin (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+37, 195164, 1, 14, 4982, '0', 0, 0, 1303.54345703125, -4411.64599609375, 26.83146286010742187, 3.176533222198486328, 0, 0, -0.999847412109375, 0.017469281330704689, 120, 255, 1, 46702), -- Pumpkin (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+38, 195164, 1, 14, 4982, '0', 0, 0, 1277.829833984375, -4441.0869140625, 27.79824638366699218, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 46702), -- Pumpkin (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+39, 195164, 1, 14, 4982, '0', 0, 0, 1321.001708984375, -4423.63916015625, 25.15823173522949218, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 46702), -- Pumpkin (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+40, 195164, 1, 14, 4982, '0', 0, 0, 1305.1510009765625, -4427.5537109375, 25.55774497985839843, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 46702), -- Pumpkin (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+41, 195164, 1, 14, 4982, '0', 0, 0, 1303.0069580078125, -4409.17724609375, 27.0159912109375, 0.418878614902496337, 0, 0, 0.207911491394042968, 0.978147625923156738, 120, 255, 1, 46702), -- Pumpkin (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+42, 195164, 1, 14, 4982, '0', 0, 0, 1322.263916015625, -4428.4755859375, 24.47579383850097656, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 46702), -- Pumpkin (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+43, 195164, 1, 14, 4982, '0', 0, 0, 1279.626708984375, -4405.88525390625, 27.18757057189941406, 1.448621988296508789, 0, 0, 0.662619590759277343, 0.748956084251403808, 120, 255, 1, 46702), -- Pumpkin (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+44, 195164, 1, 14, 4982, '0', 0, 0, 1271.7847900390625, -4425.43408203125, 27.351470947265625, 3.176533222198486328, 0, 0, -0.999847412109375, 0.017469281330704689, 120, 255, 1, 46702), -- Pumpkin (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+45, 195164, 1, 14, 4982, '0', 0, 0, 1305.0382080078125, -4425.0869140625, 25.703125, 0.052358884364366531, 0, 0, 0.02617645263671875, 0.999657332897186279, 120, 255, 1, 46702), -- Pumpkin (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+46, 195164, 1, 14, 4982, '0', 0, 0, 1321.1146240234375, -4412.3212890625, 25.35983467102050781, 6.178466320037841796, 0, 0, -0.05233573913574218, 0.998629570007324218, 120, 255, 1, 46702), -- Pumpkin (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+47, 195164, 1, 14, 4982, '0', 0, 0, 1292.6822509765625, -4442.3369140625, 28.28226661682128906, 1.518436193466186523, 0, 0, 0.6883544921875, 0.725374460220336914, 120, 255, 1, 46702), -- Pumpkin (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+48, 195164, 1, 14, 4982, '0', 0, 0, 1293.2066650390625, -4402.69091796875, 27.22710990905761718, 4.642575740814208984, 0, 0, -0.731353759765625, 0.681998312473297119, 120, 255, 1, 46702), -- Pumpkin (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+49, 195164, 1, 14, 4982, '0', 0, 0, 1321.829833984375, -4428.1650390625, 24.47648048400878906, 2.426007747650146484, 0, 0, 0.936672210693359375, 0.350207358598709106, 120, 255, 1, 46702), -- Pumpkin (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+50, 195164, 1, 14, 4982, '0', 0, 0, 1321.0833740234375, -4430.080078125, 25.24030876159667968, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 46702), -- Pumpkin (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+51, 195191, 1, 14, 4982, '0', 0, 0, 1321.6510009765625, -4413.78466796875, 24.50566291809082031, 3.176533222198486328, 0, 0, -0.999847412109375, 0.017469281330704689, 120, 255, 1, 46702), -- Dwarven Table Simple 05 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+52, 195192, 1, 14, 4982, '0', 0, 0, 1321.920166015625, -4412.10400390625, 25.39811515808105468, 5.777040958404541015, 0, 0, -0.25037956237792968, 0.968147754669189453, 120, 255, 1, 46702), -- Basket of Corn (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+53, 195194, 1, 14, 4982, '0', 0, 0, 1322.1163330078125, -4413.01904296875, 25.38296127319335937, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 46702), -- Small Basket 01 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+54, 195195, 1, 14, 4982, '0', 0, 0, 1322.1353759765625, -4415.234375, 25.38079261779785156, 3.298687219619750976, 0, 0, -0.99691677093505859, 0.078466430306434631, 120, 255, 1, 46702), -- Cranberry Masher (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+55, 195196, 1, 14, 4982, '0', 0, 0, 1320.6754150390625, -4410.63037109375, 24.57164382934570312, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 46702), -- Large Basket 03 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+56, 195197, 1, 14, 4982, '0', 0, 0, 1320.470458984375, -4412.17529296875, 24.44214248657226562, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 120, 255, 1, 46702), -- Grain Sack 02 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+57, 195198, 1, 14, 4982, '0', 0, 0, 1320.6319580078125, -4419.82470703125, 24.53960990905761718, 5.811946868896484375, 0, 0, -0.2334451675415039, 0.972369968891143798, 120, 255, 1, 46702), -- Crate 01 (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+58, 195199, 1, 14, 4982, '0', 0, 0, 1320.0086669921875, -4409.3212890625, 24.68540191650390625, 6.09120035171508789, 0, 0, -0.09584522247314453, 0.995396256446838378, 120, 255, 1, 46702), -- Cranberry Bush (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+59, 195199, 1, 14, 4982, '0', 0, 0, 1322.046875, -4409.5224609375, 25.32001686096191406, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 120, 255, 1, 46702), -- Cranberry Bush (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+60, 195199, 1, 14, 4982, '0', 0, 0, 1321.0728759765625, -4408.86279296875, 24.87704086303710937, 6.09120035171508789, 0, 0, -0.09584522247314453, 0.995396256446838378, 120, 255, 1, 46702), -- Cranberry Bush (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+61, 195200, 1, 14, 4982, '0', 0, 0, 1321.7413330078125, -4417.61962890625, 24.569793701171875, 0, 0, 0, 0, 1, 120, 255, 1, 46702), -- Pilgrim's Bounty Cooking Fire (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+62, 195664, 1, 14, 4982, '0', 0, 0, 1295.0086669921875, -4412.328125, 26.59180259704589843, 2.042035102844238281, 0, 0, 0.852640151977539062, 0.522498607635498046, 120, 255, 1, 46702), -- [DND] Collision Thanksgiving Table Size (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+63, 195664, 1, 14, 4982, '0', 0, 0, 1293.576416015625, -4428.80224609375, 26.83843421936035156, 0, 0, 0, 0, 1, 120, 255, 1, 46702), -- [DND] Collision Thanksgiving Table Size (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+64, 195664, 1, 14, 4982, '0', 0, 0, 1279.30908203125, -4430.4130859375, 26.90277862548828125, 2.042035102844238281, 0, 0, 0.852640151977539062, 0.522498607635498046, 120, 255, 1, 46702), -- [DND] Collision Thanksgiving Table Size (Area: The Dranosh'ar Blockade - Difficulty: 0) +(@OGUID+65, 195664, 1, 14, 4982, '0', 0, 0, 1276.8472900390625, -4415.20166015625, 26.40798568725585937, 1.274088263511657714, 0, 0, 0.594821929931640625, 0.80385744571685791, 120, 255, 1, 46702); -- [DND] Collision Thanksgiving Table Size (Area: The Dranosh'ar Blockade - Difficulty: 0) + +-- Event spawns +DELETE FROM `game_event_creature` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @CGUID+0 AND @CGUID+10; +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), +(@EVENT, @CGUID+9), +(@EVENT, @CGUID+10); + +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @OGUID+0 AND @OGUID+65; +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); |