diff options
| -rw-r--r-- | sql/updates/world/master/2022_12_06_04_world.sql | 218 |
1 files changed, 218 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_12_06_04_world.sql b/sql/updates/world/master/2022_12_06_04_world.sql new file mode 100644 index 00000000000..d8934655439 --- /dev/null +++ b/sql/updates/world/master/2022_12_06_04_world.sql @@ -0,0 +1,218 @@ +SET @CGUID := 396497; +SET @OGUID := 248850; +SET @EVENT := 26; + +-- Creature templates +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=34677; -- Miles Standish +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=34683; -- Rose Standish +UPDATE `creature_template` SET `gossip_menu_id`=10569, `minlevel`=60, `maxlevel`=60 WHERE `entry`=34712; -- Roberta Carter +UPDATE `creature_template` SET `gossip_menu_id`=10571, `minlevel`=60, `maxlevel`=60, `npcflag`=3 WHERE `entry`=34768; -- William Mullins +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `unit_flags`=2147746560 WHERE `entry`=35341; -- Bountiful Barrel + +-- Gossips +DELETE FROM `gossip_menu` WHERE `MenuID`=10571; +INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES +(10571, 14630, 46741); -- 34768 (William Mullins) + +-- Equipments +UPDATE `creature_equip_template` SET `VerifiedBuild`=46741 WHERE (`ID`=1 AND `CreatureID` IN (34768,34712,34677,5754,5705,5702,5670,5669,5668,4603,4570)) OR (`ID`=2 AND `CreatureID`=5697); + +-- Scaling +DELETE FROM `creature_template_scaling` WHERE `DifficultyID`=0 AND `Entry` IN (34677, 34683, 34712, 34768, 35341); +INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES +(34677, 0, 0, 0, 389, 46741), +(34683, 0, 0, 0, 389, 46741), +(34712, 0, 0, 0, 389, 46741), +(34768, 0, 0, 0, 389, 46741), +(35341, 0, 0, 0, 389, 46741); + +UPDATE `creature_template_scaling` SET `VerifiedBuild`=46741 WHERE (`DifficultyID`=0 AND `Entry` IN (153285,61905,61829,61753,61366,53591,53517,51384,43359,37574,37543,36213,23103,20725,16030,5754,5705,5702,5697,5674,5670,5669,5668,4603,4570,4075)); + +-- Trainer +DELETE FROM `creature_trainer` WHERE `CreatureID`=34712; +INSERT INTO `creature_trainer` (`CreatureID`, `TrainerID`, `MenuID`, `OptionID`) VALUES +(34712, 136, 10569, 0); + +-- Quests +UPDATE `quest_poi_points` SET `VerifiedBuild`=46741 WHERE (`QuestID`=14059 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=14059 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=14059 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=14058 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=14058 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=14058 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=14037 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=14037 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=14037 AND `Idx1`=0 AND `Idx2`=0); + +DELETE FROM `quest_details` WHERE `ID` IN (14059 /*We're Out of Cranberry Chutney Again?*/, 14058 /*She Says Potato*/, 14037 /*Spice Bread Stuffing*/); +INSERT INTO `quest_details` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `VerifiedBuild`) VALUES +(14059, 1, 1, 0, 0, 0, 0, 0, 0, 46741), -- We're Out of Cranberry Chutney Again? +(14058, 1, 1, 0, 0, 0, 0, 0, 0, 46741), -- She Says Potato +(14037, 1, 1, 0, 0, 0, 0, 0, 0, 46741); -- Spice Bread Stuffing + +UPDATE `quest_request_items` SET `EmoteOnIncomplete`=1 WHERE `ID` IN (14037, 14058); + +DELETE FROM `creature_queststarter` WHERE (`id` IN (34677, 34768) AND `quest`=14037); +INSERT INTO `creature_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(34677, 14037, 46741); -- Spice Bread Stuffing offered Miles Standish + +UPDATE `creature_queststarter` SET `VerifiedBuild`=46741 WHERE (`id`=34712 AND `quest`=14059) OR (`id`=34768 AND `quest`=14058); + +UPDATE `creature_questender` SET `VerifiedBuild`=46741 WHERE (`id`=34712 AND `quest`=14059) OR (`id`=34768 AND `quest` IN (14058,14037)); + +-- Creature spawns +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+11; +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, 0, 14046, 14046, '0', 0, 0, 0, 0, 1786.5260009765625, 257.307281494140625, 59.595458984375, 1.274090290069580078, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Tirisfal Glades - Difficulty: 0) (Auras: ) +(@CGUID+1, 32823, 0, 14046, 14046, '0', 0, 0, 0, 0, 1827.96875, 254.7256927490234375, 59.84268951416015625, 2.042035102844238281, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Tirisfal Glades - Difficulty: 0) +(@CGUID+2, 32823, 0, 14046, 14046, '0', 0, 0, 0, 0, 1785.795166015625, 222.6788177490234375, 59.59212875366210937, 0, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Tirisfal Glades - Difficulty: 0) +(@CGUID+3, 32823, 0, 14046, 14046, '0', 0, 0, 0, 0, 1827.8836669921875, 220.3229217529296875, 60.71599578857421875, 2.042035102844238281, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Tirisfal Glades - Difficulty: 0) +(@CGUID+4, 34654, 0, 14046, 14046, '0', 0, 0, 0, 0, 1825.876708984375, 244.28472900390625, 60.24924087524414062, 4.97418832778930664, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Feast Hostess (Area: Tirisfal Glades - Difficulty: 0) +(@CGUID+5, 34677, 0, 14046, 14046, '0', 0, 0, 0, 1, 1804.59375, 259.78472900390625, 61.64423751831054687, 4.904375076293945312, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Miles Standish (Area: Tirisfal Glades - Difficulty: 0) (Auras: ) +(@CGUID+6, 34683, 0, 14046, 14046, '0', 0, 0, 0, 0, 1806.9427490234375, 260.09375, 61.66677474975585937, 4.729842185974121093, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Rose Standish (Area: Tirisfal Glades - Difficulty: 0) (Auras: ) +(@CGUID+7, 34712, 0, 14046, 14046, '0', 0, 0, 0, 1, 1820.8160400390625, 266.868072509765625, 60.82830047607421875, 4.572762489318847656, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Roberta Carter (Area: Tirisfal Glades - Difficulty: 0) +(@CGUID+8, 34768, 0, 14046, 14046, '0', 0, 0, 0, 1, 1786.7882080078125, 247.3819427490234375, 60.4293060302734375, 2.094395160675048828, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- William Mullins (Area: Tirisfal Glades - Difficulty: 0) +(@CGUID+9, 35341, 0, 14046, 14046, '0', 0, 0, 0, 0, 1813.10595703125, 259.274322509765625, 60.2708587646484375, 1.780235767364501953, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Barrel (Area: Tirisfal Glades - Difficulty: 0) (Auras: ) +(@CGUID+10, 35341, 0, 14046, 14046, '0', 0, 0, 0, 0, 1809.951416015625, 257.578125, 60.28329086303710937, 0, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Barrel (Area: Tirisfal Glades - Difficulty: 0) (Auras: ) +(@CGUID+11, 35341, 0, 14046, 14046, '0', 0, 0, 0, 0, 1811.90283203125, 257.81597900390625, 60.01216506958007812, 1.274090290069580078, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741); -- Bountiful Barrel (Area: Tirisfal Glades - Difficulty: 0) (Auras: ) + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+62; +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, 0, 14046, 14046, '0', 0, 0, 1806.9635009765625, 262.40972900390625, 65.39959716796875, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 120, 255, 1, 46741), -- Haystack 01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+1, 179968, 0, 14046, 14046, '0', 0, 0, 1808.454833984375, 259.322906494140625, 60.93755340576171875, 3.961898565292358398, 0, 0, -0.91705989837646484, 0.398749500513076782, 120, 255, 1, 46741), -- Haystack 01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+2, 179968, 0, 14046, 14046, '0', 0, 0, 1803.2725830078125, 259.21875, 60.92121124267578125, 5.445427894592285156, 0, 0, -0.40673637390136718, 0.913545548915863037, 120, 255, 1, 46741), -- Haystack 01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+3, 179968, 0, 14046, 14046, '0', 0, 0, 1804.63720703125, 259.8975830078125, 60.96956253051757812, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 120, 255, 1, 46741), -- Haystack 01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+4, 179968, 0, 14046, 14046, '0', 0, 0, 1806.9097900390625, 260.020843505859375, 60.95785140991210937, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 46741), -- Haystack 01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+5, 179968, 0, 14046, 14046, '0', 0, 0, 1804.9010009765625, 262.541656494140625, 65.39959716796875, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 46741), -- Haystack 01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+6, 179968, 0, 14046, 14046, '0', 0, 0, 1781.326416015625, 244.70660400390625, 59.95488739013671875, 1.518436193466186523, 0, 0, 0.6883544921875, 0.725374460220336914, 120, 255, 1, 46741), -- Haystack 01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+7, 179968, 0, 14046, 14046, '0', 0, 0, 1830.015625, 233.0243072509765625, 60.22722244262695312, 1.605701684951782226, 0, 0, 0.719339370727539062, 0.694658815860748291, 120, 255, 1, 46741), -- Haystack 01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+8, 179968, 0, 14046, 14046, '0', 0, 0, 1827.611083984375, 233.189239501953125, 60.32691192626953125, 4.625123500823974609, 0, 0, -0.73727703094482421, 0.67559051513671875, 120, 255, 1, 46741), -- Haystack 01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+9, 179968, 0, 14046, 14046, '0', 0, 0, 1830.1597900390625, 243.9913177490234375, 60.06359100341796875, 4.59021615982055664, 0, 0, -0.74895572662353515, 0.662620067596435546, 120, 255, 1, 46741), -- Haystack 01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+10, 179968, 0, 14046, 14046, '0', 0, 0, 1782.0816650390625, 232.90972900390625, 59.88092041015625, 4.764749526977539062, 0, 0, -0.6883544921875, 0.725374460220336914, 120, 255, 1, 46741), -- Haystack 01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+11, 179968, 0, 14046, 14046, '0', 0, 0, 1784.25, 233.1163177490234375, 59.85076141357421875, 4.834563255310058593, 0, 0, -0.66261959075927734, 0.748956084251403808, 120, 255, 1, 46741), -- Haystack 01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+12, 179968, 0, 14046, 14046, '0', 0, 0, 1783.59375, 244.4149322509765625, 59.88451004028320312, 1.448621988296508789, 0, 0, 0.662619590759277343, 0.748956084251403808, 120, 255, 1, 46741), -- Haystack 01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+13, 179968, 0, 14046, 14046, '0', 0, 0, 1820.7742919921875, 266.69964599609375, 60.05088424682617187, 4.625123500823974609, 0, 0, -0.73727703094482421, 0.67559051513671875, 120, 255, 1, 46741), -- Haystack 01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+14, 179968, 0, 14046, 14046, '0', 0, 0, 1786.78125, 247.236114501953125, 59.72076416015625, 5.445427894592285156, 0, 0, -0.40673637390136718, 0.913545548915863037, 120, 255, 1, 46741), -- Haystack 01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+15, 179968, 0, 14046, 14046, '0', 0, 0, 1828.12158203125, 244.1996612548828125, 60.13411331176757812, 1.500982880592346191, 0, 0, 0.681998252868652343, 0.731353819370269775, 120, 255, 1, 46741), -- Haystack 01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+16, 179968, 0, 14046, 14046, '0', 0, 0, 1806.3646240234375, 216.751739501953125, 60.63610076904296875, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 46741), -- Haystack 01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+17, 179968, 0, 14046, 14046, '0', 0, 0, 1806.5242919921875, 214.4149322509765625, 65.39959716796875, 1.623155713081359863, 0, 0, 0.725374221801757812, 0.688354730606079101, 120, 255, 1, 46741), -- Haystack 01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+18, 179968, 0, 14046, 14046, '0', 0, 0, 1804.25, 214.361114501953125, 65.39959716796875, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 120, 255, 1, 46741), -- Haystack 01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+19, 179968, 0, 14046, 14046, '0', 0, 0, 1803.9791259765625, 216.888885498046875, 60.62489700317382812, 1.605701684951782226, 0, 0, 0.719339370727539062, 0.694658815860748291, 120, 255, 1, 46741), -- Haystack 01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+20, 180353, 0, 14046, 14046, '0', 0, 0, 1805.673583984375, 259.9288330078125, 60.97239303588867187, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+21, 180353, 0, 14046, 14046, '0', 0, 0, 1805.9271240234375, 262.359375, 65.39959716796875, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+22, 180353, 0, 14046, 14046, '0', 0, 0, 1823.1822509765625, 269.916656494140625, 60.2144775390625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+23, 180353, 0, 14046, 14046, '0', 0, 0, 1828.751708984375, 233.217010498046875, 60.32651901245117187, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+24, 180353, 0, 14046, 14046, '0', 0, 0, 1783.1978759765625, 233.1684112548828125, 59.84886932373046875, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+25, 180353, 0, 14046, 14046, '0', 0, 0, 1829.18408203125, 244.1527862548828125, 60.11936569213867187, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+26, 180353, 0, 14046, 14046, '0', 0, 0, 1782.484375, 244.609375, 59.89130401611328125, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+27, 180353, 0, 14046, 14046, '0', 0, 0, 1818.515625, 270.19097900390625, 60.13330841064453125, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+28, 180353, 0, 14046, 14046, '0', 0, 0, 1805.123291015625, 216.9184112548828125, 60.62131881713867187, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+29, 180353, 0, 14046, 14046, '0', 0, 0, 1805.5504150390625, 214.4479217529296875, 65.39959716796875, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+30, 195164, 0, 14046, 14046, '0', 0, 0, 1804.99658203125, 262.49652099609375, 66.10984039306640625, 1.675513744354248046, 0, 0, 0.743144035339355468, 0.669131457805633544, 120, 255, 1, 46741), -- Pumpkin (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+31, 195164, 0, 14046, 14046, '0', 0, 0, 1808.375, 259.289947509765625, 61.63667678833007812, 4.904376029968261718, 0, 0, -0.636077880859375, 0.771624863147735595, 120, 255, 1, 46741), -- Pumpkin (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+32, 195164, 0, 14046, 14046, '0', 0, 0, 1807.060791015625, 262.364593505859375, 66.10984039306640625, 4.607671737670898437, 0, 0, -0.74314403533935546, 0.669131457805633544, 120, 255, 1, 46741), -- Pumpkin (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+33, 195164, 0, 14046, 14046, '0', 0, 0, 1803.310791015625, 259.16839599609375, 61.6376495361328125, 4.764749526977539062, 0, 0, -0.6883544921875, 0.725374460220336914, 120, 255, 1, 46741), -- Pumpkin (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+34, 195164, 0, 14046, 14046, '0', 0, 0, 1827.5538330078125, 233.2604217529296875, 61.03870391845703125, 4.642575740814208984, 0, 0, -0.731353759765625, 0.681998312473297119, 120, 255, 1, 46741), -- Pumpkin (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+35, 195164, 0, 14046, 14046, '0', 0, 0, 1782.0416259765625, 232.814239501953125, 60.59503936767578125, 4.782202720642089843, 0, 0, -0.68199825286865234, 0.731353819370269775, 120, 255, 1, 46741), -- Pumpkin (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+36, 195164, 0, 14046, 14046, '0', 0, 0, 1783.5728759765625, 244.3697967529296875, 60.59868240356445312, 1.448621988296508789, 0, 0, 0.662619590759277343, 0.748956084251403808, 120, 255, 1, 46741), -- Pumpkin (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+37, 195164, 0, 14046, 14046, '0', 0, 0, 1819.095458984375, 267.989593505859375, 61.02001190185546875, 6.178466320037841796, 0, 0, -0.05233573913574218, 0.998629570007324218, 120, 255, 1, 46741), -- Pumpkin (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+38, 195164, 0, 14046, 14046, '0', 0, 0, 1830.0972900390625, 243.9496612548828125, 60.77983474731445312, 4.625123500823974609, 0, 0, -0.73727703094482421, 0.67559051513671875, 120, 255, 1, 46741), -- Pumpkin (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+39, 195164, 0, 14046, 14046, '0', 0, 0, 1821.6754150390625, 266.883697509765625, 60.09093093872070312, 6.178466320037841796, 0, 0, -0.05233573913574218, 0.998629570007324218, 120, 255, 1, 46741), -- Pumpkin (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+40, 195164, 0, 14046, 14046, '0', 0, 0, 1829.8802490234375, 232.8802032470703125, 60.94774627685546875, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 46741), -- Pumpkin (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+41, 195164, 0, 14046, 14046, '0', 0, 0, 1784.1129150390625, 233.1041717529296875, 60.5592041015625, 4.904376029968261718, 0, 0, -0.636077880859375, 0.771624863147735595, 120, 255, 1, 46741), -- Pumpkin (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+42, 195164, 0, 14046, 14046, '0', 0, 0, 1828.173583984375, 244.2447967529296875, 60.84135818481445312, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 120, 255, 1, 46741), -- Pumpkin (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+43, 195164, 0, 14046, 14046, '0', 0, 0, 1781.423583984375, 244.6614532470703125, 60.6585693359375, 1.553341388702392578, 0, 0, 0.700908660888671875, 0.713251054286956787, 120, 255, 1, 46741), -- Pumpkin (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+44, 195164, 0, 14046, 14046, '0', 0, 0, 1803.888916015625, 216.861114501953125, 61.33761978149414062, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 46741), -- Pumpkin (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+45, 195164, 0, 14046, 14046, '0', 0, 0, 1804.1927490234375, 214.4305572509765625, 66.10984039306640625, 1.518436193466186523, 0, 0, 0.6883544921875, 0.725374460220336914, 120, 255, 1, 46741), -- Pumpkin (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+46, 195164, 0, 14046, 14046, '0', 0, 0, 1806.5035400390625, 216.8715362548828125, 61.33487319946289062, 4.642575740814208984, 0, 0, -0.731353759765625, 0.681998312473297119, 120, 255, 1, 46741), -- Pumpkin (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+47, 195164, 0, 14046, 14046, '0', 0, 0, 1806.388916015625, 214.26910400390625, 66.10984039306640625, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 46741), -- Pumpkin (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+48, 195191, 0, 14046, 14046, '0', 0, 0, 1820.732666015625, 268.411468505859375, 60.13565444946289062, 4.642575740814208984, 0, 0, -0.731353759765625, 0.681998312473297119, 120, 255, 1, 46741), -- Dwarven Table Simple 05 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+49, 195192, 0, 14046, 14046, '0', 0, 0, 1819.123291015625, 269.217010498046875, 61.04339599609375, 5.777040958404541015, 0, 0, -0.25037956237792968, 0.968147754669189453, 120, 255, 1, 46741), -- Basket of Corn (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+50, 195194, 0, 14046, 14046, '0', 0, 0, 1821.9461669921875, 267.869781494140625, 61.04545974731445312, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 46741), -- Small Basket 01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+51, 195195, 0, 14046, 14046, '0', 0, 0, 1822.298583984375, 268.651031494140625, 60.97147750854492187, 3.298687219619750976, 0, 0, -0.99691677093505859, 0.078466430306434631, 120, 255, 1, 46741), -- Cranberry Masher (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+52, 195196, 0, 14046, 14046, '0', 0, 0, 1821.986083984375, 271.258697509765625, 60.19820785522460937, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 46741), -- Large Basket 03 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+53, 195197, 0, 14046, 14046, '0', 0, 0, 1817.75, 268.765625, 60.27058792114257812, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 120, 255, 1, 46741), -- Grain Sack 02 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+54, 195198, 0, 14046, 14046, '0', 0, 0, 1819.9114990234375, 270.765625, 60.15500259399414062, 5.811946868896484375, 0, 0, -0.2334451675415039, 0.972369968891143798, 120, 255, 1, 46741), -- Crate 01 (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+55, 195200, 0, 14046, 14046, '0', 0, 0, 1824.7725830078125, 268.177093505859375, 60.24002456665039062, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pilgrim's Bounty Cooking Fire (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+56, 195212, 0, 14046, 14046, '0', 0, 0, 1818.5660400390625, 273.307281494140625, 60.29869842529296875, 6.09120035171508789, 0, 0, -0.09584522247314453, 0.995396256446838378, 120, 255, 1, 46741), -- Pumpkin (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+57, 195212, 0, 14046, 14046, '0', 0, 0, 1818.0052490234375, 271.72222900390625, 60.1640167236328125, 2.949595451354980468, 0, 0, 0.995395660400390625, 0.095851235091686248, 120, 255, 1, 46741), -- Pumpkin (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+58, 195212, 0, 14046, 14046, '0', 0, 0, 1815.517333984375, 271.482635498046875, 60.22672653198242187, 1.937312245368957519, 0, 0, 0.824125289916992187, 0.566407561302185058, 120, 255, 1, 46741), -- Pumpkin (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+59, 195664, 0, 14046, 14046, '0', 0, 0, 1786.530029296875, 257.3070068359375, 59.5121002197265625, 1.274088263511657714, 0, 0, 0.594821929931640625, 0.80385744571685791, 120, 255, 1, 46741), -- [DND] Collision Thanksgiving Table Size (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+60, 195664, 0, 14046, 14046, '0', 0, 0, 1827.969970703125, 254.7259979248046875, 59.7593994140625, 2.042035102844238281, 0, 0, 0.852640151977539062, 0.522498607635498046, 120, 255, 1, 46741), -- [DND] Collision Thanksgiving Table Size (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+61, 195664, 0, 14046, 14046, '0', 0, 0, 1827.8800048828125, 220.322998046875, 60.63270187377929687, 2.042035102844238281, 0, 0, 0.852640151977539062, 0.522498607635498046, 120, 255, 1, 46741), -- [DND] Collision Thanksgiving Table Size (Area: Tirisfal Glades - Difficulty: 0) +(@OGUID+62, 195664, 0, 14046, 14046, '0', 0, 0, 1785.800048828125, 222.6790008544921875, 59.50880050659179687, 0, 0, 0, 0, 1, 120, 255, 1, 46741); -- [DND] Collision Thanksgiving Table Size (Area: Tirisfal Glades - Difficulty: 0) + +-- Event spawns +DELETE FROM `game_event_creature` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @CGUID+0 AND @CGUID+11; +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), +(@EVENT, @CGUID+11); + +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @OGUID+0 AND @OGUID+62; +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); |