DB/Undercity: Added Pilgrim's Bounty spawns

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);