DB/NorthernBarrens: Added Pilgrim's Bounty spawns

1 files changed, 184 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_12_07_05_world.sql b/sql/updates/world/master/2022_12_07_05_world.sql
new file mode 100644
index 00000000000..ac5340a1154
--- /dev/null
+++ b/sql/updates/world/master/2022_12_07_05_world.sql
@@ -0,0 +1,184 @@
+SET @CGUID := 396540;
+SET @OGUID := 249233;
+SET @EVENT := 26;
+
+-- Creature spawns
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+6;
+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
+-- The Crossroads
+(@CGUID+0, 32823, 1, 17, 380, '0', 0, 0, 0, 0, -382.864593505859375, -2597.588623046875, 95.77704620361328125, 0, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: The Crossroads - Difficulty: 0) (Auras: )
+(@CGUID+1, 32823, 1, 17, 380, '0', 0, 0, 0, 0, -375.822906494140625, -2607.59375, 95.74503326416015625, 0, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: The Crossroads - Difficulty: 0)
+(@CGUID+2, 34654, 1, 17, 380, '0', 0, 0, 0, 0, -387.576385498046875, -2590.7275390625, 95.756805419921875, 2.129301786422729492, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Feast Hostess (Area: The Crossroads - Difficulty: 0)
+-- Ratchet
+(@CGUID+3, 32823, 1, 17, 392, '0', 0, 0, 0, 0, -970.40972900390625, -3708.798583984375, 5.289239406585693359, 0, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Ratchet - Difficulty: 0)
+(@CGUID+4, 32823, 1, 17, 392, '0', 0, 0, 0, 0, -971.31427001953125, -3724.51220703125, 6.115543365478515625, 0, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Ratchet - Difficulty: 0)
+(@CGUID+5, 34653, 1, 17, 392, '0', 0, 0, 0, 0, -976.23614501953125, -3718.045166015625, 5.943660259246826171, 1.797689080238342285, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table Hostess (Area: Ratchet - Difficulty: 0)
+(@CGUID+6, 34654, 1, 17, 392, '0', 0, 0, 0, 0, -975.0399169921875, -3713.069580078125, 5.638696670532226562, 4.904375076293945312, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741); -- Bountiful Feast Hostess (Area: Ratchet - Difficulty: 0)
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+73;
+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
+-- The Crossroads
+(@OGUID+0, 179968, 1, 17, 380, '0', 0, 0, -388.708343505859375, -2597.350830078125, 95.71353912353515625, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 46741), -- Haystack 01 (Area: The Crossroads - Difficulty: 0)
+(@OGUID+1, 179968, 1, 17, 380, '0', 0, 0, -382.524322509765625, -2606.7744140625, 95.8680572509765625, 0.628316879272460937, 0, 0, 0.309016227722167968, 0.95105677843093872, 120, 255, 1, 46741), -- Haystack 01 (Area: The Crossroads - Difficulty: 0)
+(@OGUID+2, 179968, 1, 17, 380, '0', 0, 0, -388.020843505859375, -2599.692626953125, 95.8993072509765625, 0.628316879272460937, 0, 0, 0.309016227722167968, 0.95105677843093872, 120, 255, 1, 46741), -- Haystack 01 (Area: The Crossroads - Difficulty: 0)
+(@OGUID+3, 179968, 1, 17, 380, '0', 0, 0, -383.916656494140625, -2604.947998046875, 96.01041412353515625, 0.645771682262420654, 0, 0, 0.317304611206054687, 0.948323667049407958, 120, 255, 1, 46741), -- Haystack 01 (Area: The Crossroads - Difficulty: 0)
+(@OGUID+4, 179968, 1, 17, 380, '0', 0, 0, -384.208343505859375, -2590.802001953125, 95.67534637451171875, 5.253442287445068359, 0, 0, -0.49242305755615234, 0.870355963706970214, 120, 255, 1, 46741), -- Haystack 01 (Area: The Crossroads - Difficulty: 0)
+(@OGUID+5, 179968, 1, 17, 380, '0', 0, 0, -372.201385498046875, -2597.28125, 96.22916412353515625, 3.752462387084960937, 0, 0, -0.95371627807617187, 0.300707906484603881, 120, 255, 1, 46741), -- Haystack 01 (Area: The Crossroads - Difficulty: 0)
+(@OGUID+6, 179968, 1, 17, 380, '0', 0, 0, -370.076385498046875, -2611.942626953125, 96.15451812744140625, 2.216565132141113281, 0, 0, 0.894933700561523437, 0.44619917869567871, 120, 255, 1, 46741), -- Haystack 01 (Area: The Crossroads - Difficulty: 0)
+(@OGUID+7, 179968, 1, 17, 380, '0', 0, 0, -377.548614501953125, -2590.857666015625, 96.111114501953125, 4.293513298034667968, 0, 0, -0.8386697769165039, 0.544640243053436279, 120, 255, 1, 46741), -- Haystack 01 (Area: The Crossroads - Difficulty: 0)
+(@OGUID+8, 179968, 1, 17, 380, '0', 0, 0, -366.28125, -2606.467041015625, 95.7118072509765625, 3.368495941162109375, 0, 0, -0.99357128143310546, 0.113208353519439697, 120, 255, 1, 46741), -- Haystack 01 (Area: The Crossroads - Difficulty: 0)
+(@OGUID+9, 179968, 1, 17, 380, '0', 0, 0, -386.260406494140625, -2592.07470703125, 95.67534637451171875, 5.288348197937011718, 0, 0, -0.4771585464477539, 0.878817260265350341, 120, 255, 1, 46741), -- Haystack 01 (Area: The Crossroads - Difficulty: 0)
+(@OGUID+10, 179968, 1, 17, 380, '0', 0, 0, -367.2257080078125, -2604.598876953125, 95.66146087646484375, 3.752462387084960937, 0, 0, -0.95371627807617187, 0.300707906484603881, 120, 255, 1, 46741), -- Haystack 01 (Area: The Crossroads - Difficulty: 0)
+(@OGUID+11, 179968, 1, 17, 380, '0', 0, 0, -371, -2598.9462890625, 95.98784637451171875, 3.682650327682495117, 0, 0, -0.96362972259521484, 0.26724100112915039, 120, 255, 1, 46741), -- Haystack 01 (Area: The Crossroads - Difficulty: 0)
+(@OGUID+12, 179968, 1, 17, 380, '0', 0, 0, -375.87152099609375, -2592.0712890625, 96.3055572509765625, 3.682650327682495117, 0, 0, -0.96362972259521484, 0.26724100112915039, 120, 255, 1, 46741), -- Haystack 01 (Area: The Crossroads - Difficulty: 0)
+(@OGUID+13, 179968, 1, 17, 380, '0', 0, 0, -378.71527099609375, -2612.48779296875, 95.68360137939453125, 3.892086982727050781, 0, 0, -0.93041706085205078, 0.366502493619918823, 120, 255, 1, 46741), -- Haystack 01 (Area: The Crossroads - Difficulty: 0)
+(@OGUID+14, 179968, 1, 17, 380, '0', 0, 0, -371.65277099609375, -2612.90625, 96.15103912353515625, 2.181660413742065429, 0, 0, 0.887010574340820312, 0.461749136447906494, 120, 255, 1, 46741), -- Haystack 01 (Area: The Crossroads - Difficulty: 0)
+(@OGUID+15, 179968, 1, 17, 380, '0', 0, 0, -377.06597900390625, -2613.890625, 95.765625, 1.274088263511657714, 0, 0, 0.594821929931640625, 0.80385744571685791, 120, 255, 1, 46741), -- Haystack 01 (Area: The Crossroads - Difficulty: 0)
+(@OGUID+16, 180353, 1, 17, 380, '0', 0, 0, -383.135406494140625, -2605.713623046875, 95.7140960693359375, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: The Crossroads - Difficulty: 0)
+(@OGUID+17, 180353, 1, 17, 380, '0', 0, 0, -388.6319580078125, -2598.632080078125, 95.5890960693359375, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: The Crossroads - Difficulty: 0)
+(@OGUID+18, 180353, 1, 17, 380, '0', 0, 0, -371.711822509765625, -2598.192626953125, 95.88423919677734375, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: The Crossroads - Difficulty: 0)
+(@OGUID+19, 180353, 1, 17, 380, '0', 0, 0, -377.9757080078125, -2613.185791015625, 95.5127105712890625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: The Crossroads - Difficulty: 0)
+(@OGUID+20, 180353, 1, 17, 380, '0', 0, 0, -385.19097900390625, -2591.411376953125, 95.46930694580078125, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: The Crossroads - Difficulty: 0)
+(@OGUID+21, 180353, 1, 17, 380, '0', 0, 0, -366.618072509765625, -2605.413330078125, 95.48319244384765625, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: The Crossroads - Difficulty: 0)
+(@OGUID+22, 180353, 1, 17, 380, '0', 0, 0, -370.87847900390625, -2612.307373046875, 95.97104644775390625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: The Crossroads - Difficulty: 0)
+(@OGUID+23, 180353, 1, 17, 380, '0', 0, 0, -376.541656494140625, -2591.142333984375, 96.0196533203125, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: The Crossroads - Difficulty: 0)
+(@OGUID+24, 195164, 1, 17, 380, '0', 0, 0, -383.94097900390625, -2604.9931640625, 96.71381378173828125, 0.663223206996917724, 0, 0, 0.325567245483398437, 0.945518851280212402, 120, 255, 1, 46741), -- Pumpkin (Area: The Crossroads - Difficulty: 0)
+(@OGUID+25, 195164, 1, 17, 380, '0', 0, 0, -377.6875, -2591, 96.80062103271484375, 4.310965538024902343, 0, 0, -0.83388519287109375, 0.55193793773651123, 120, 255, 1, 46741), -- Pumpkin (Area: The Crossroads - Difficulty: 0)
+(@OGUID+26, 195164, 1, 17, 380, '0', 0, 0, -382.427093505859375, -2606.819580078125, 96.56624603271484375, 0.663223206996917724, 0, 0, 0.325567245483398437, 0.945518851280212402, 120, 255, 1, 46741), -- Pumpkin (Area: The Crossroads - Difficulty: 0)
+(@OGUID+27, 195164, 1, 17, 380, '0', 0, 0, -378.666656494140625, -2612.442626953125, 96.38394927978515625, 3.892086982727050781, 0, 0, -0.93041706085205078, 0.366502493619918823, 120, 255, 1, 46741), -- Pumpkin (Area: The Crossroads - Difficulty: 0)
+(@OGUID+28, 195164, 1, 17, 380, '0', 0, 0, -371.0625, -2598.928955078125, 96.6929779052734375, 3.43830275535583496, 0, 0, -0.98901557922363281, 0.147811368107795715, 120, 255, 1, 46741), -- Pumpkin (Area: The Crossroads - Difficulty: 0)
+(@OGUID+29, 195164, 1, 17, 380, '0', 0, 0, -366.34375, -2606.44970703125, 96.4134674072265625, 3.368495941162109375, 0, 0, -0.99357128143310546, 0.113208353519439697, 120, 255, 1, 46741), -- Pumpkin (Area: The Crossroads - Difficulty: 0)
+(@OGUID+30, 195164, 1, 17, 380, '0', 0, 0, -386.399322509765625, -2592.217041015625, 96.37700653076171875, 5.305802345275878906, 0, 0, -0.46947097778320312, 0.882947921752929687, 120, 255, 1, 46741), -- Pumpkin (Area: The Crossroads - Difficulty: 0)
+(@OGUID+31, 195164, 1, 17, 380, '0', 0, 0, -388.732635498046875, -2597.395751953125, 96.41693878173828125, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 46741), -- Pumpkin (Area: The Crossroads - Difficulty: 0)
+(@OGUID+32, 195164, 1, 17, 380, '0', 0, 0, -375.96527099609375, -2592.098876953125, 96.99853515625, 3.682650327682495117, 0, 0, -0.96362972259521484, 0.26724100112915039, 120, 255, 1, 46741), -- Pumpkin (Area: The Crossroads - Difficulty: 0)
+(@OGUID+33, 195164, 1, 17, 380, '0', 0, 0, -377.135406494140625, -2613.8212890625, 96.46381378173828125, 1.256635904312133789, 0, 0, 0.587784767150878906, 0.809017360210418701, 120, 255, 1, 46741), -- Pumpkin (Area: The Crossroads - Difficulty: 0)
+(@OGUID+34, 195164, 1, 17, 380, '0', 0, 0, -384.302093505859375, -2590.829833984375, 96.37700653076171875, 5.253442287445068359, 0, 0, -0.49242305755615234, 0.870355963706970214, 120, 255, 1, 46741), -- Pumpkin (Area: The Crossroads - Difficulty: 0)
+(@OGUID+35, 195164, 1, 17, 380, '0', 0, 0, -367.263885498046875, -2604.692626953125, 96.36312103271484375, 3.735006093978881835, 0, 0, -0.95630455017089843, 0.292372345924377441, 120, 255, 1, 46741), -- Pumpkin (Area: The Crossroads - Difficulty: 0)
+(@OGUID+36, 195164, 1, 17, 380, '0', 0, 0, -387.923614501953125, -2599.73779296875, 96.60617828369140625, 0.663223206996917724, 0, 0, 0.325567245483398437, 0.945518851280212402, 120, 255, 1, 46741), -- Pumpkin (Area: The Crossroads - Difficulty: 0)
+(@OGUID+37, 195164, 1, 17, 380, '0', 0, 0, -371.701385498046875, -2612.8369140625, 96.84575653076171875, 2.181660413742065429, 0, 0, 0.887010574340820312, 0.461749136447906494, 120, 255, 1, 46741), -- Pumpkin (Area: The Crossroads - Difficulty: 0)
+(@OGUID+38, 195164, 1, 17, 380, '0', 0, 0, -369.9375, -2611.82470703125, 96.8509674072265625, 2.286378860473632812, 0, 0, 0.909960746765136718, 0.414694398641586303, 120, 255, 1, 46741), -- Pumpkin (Area: The Crossroads - Difficulty: 0)
+(@OGUID+39, 195164, 1, 17, 380, '0', 0, 0, -372.243072509765625, -2597.375, 96.91693878173828125, 3.735006093978881835, 0, 0, -0.95630455017089843, 0.292372345924377441, 120, 255, 1, 46741), -- Pumpkin (Area: The Crossroads - Difficulty: 0)
+(@OGUID+40, 195664, 1, 17, 380, '0', 0, 0, -382.864990234375, -2597.590087890625, 95.69370269775390625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- [DND] Collision Thanksgiving Table Size (Area: The Crossroads - Difficulty: 0)
+(@OGUID+41, 195664, 1, 17, 380, '0', 0, 0, -375.822998046875, -2607.590087890625, 95.6616973876953125, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- [DND] Collision Thanksgiving Table Size (Area: The Crossroads - Difficulty: 0)
+-- Ratchet
+(@OGUID+42, 179968, 1, 17, 392, '0', 0, 0, -972.94268798828125, -3710.770751953125, 5.490809917449951171, 0.558503925800323486, 0, 0, 0.275636672973632812, 0.961261868476867675, 120, 255, 1, 46741), -- Haystack 01 (Area: Ratchet - Difficulty: 0)
+(@OGUID+43, 179968, 1, 17, 392, '0', 0, 0, -968.45831298828125, -3712.385498046875, 5.467013835906982421, 1.954769015312194824, 0, 0, 0.829037666320800781, 0.559192776679992675, 120, 255, 1, 46741), -- Haystack 01 (Area: Ratchet - Difficulty: 0)
+(@OGUID+44, 179968, 1, 17, 392, '0', 0, 0, -968.84893798828125, -3720.401123046875, 5.98310708999633789, 4.241150379180908203, 0, 0, -0.85264015197753906, 0.522498607635498046, 120, 255, 1, 46741), -- Haystack 01 (Area: Ratchet - Difficulty: 0)
+(@OGUID+45, 179968, 1, 17, 392, '0', 0, 0, -965.576416015625, -3708.69970703125, 5.128471851348876953, 3.159062385559082031, 0, 0, -0.99996185302734375, 0.008734640665352344, 120, 255, 1, 46741), -- Haystack 01 (Area: Ratchet - Difficulty: 0)
+(@OGUID+46, 179968, 1, 17, 392, '0', 0, 0, -973.5711669921875, -3726.717041015625, 6.526041984558105468, 0.610863447189331054, 0, 0, 0.3007049560546875, 0.953717231750488281, 120, 255, 1, 46741), -- Haystack 01 (Area: Ratchet - Difficulty: 0)
+(@OGUID+47, 179968, 1, 17, 392, '0', 0, 0, -969.25, -3728.395751953125, 6.489583015441894531, 1.85004889965057373, 0, 0, 0.798635482788085937, 0.60181504487991333, 120, 255, 1, 46741), -- Haystack 01 (Area: Ratchet - Difficulty: 0)
+(@OGUID+48, 179968, 1, 17, 392, '0', 0, 0, -973.02081298828125, -3706.046875, 5.171875, 5.585053920745849609, 0, 0, -0.34202003479003906, 0.939692676067352294, 120, 255, 1, 46741), -- Haystack 01 (Area: Ratchet - Difficulty: 0)
+(@OGUID+49, 179968, 1, 17, 392, '0', 0, 0, -968.1649169921875, -3704.760498046875, 5.230903148651123046, 4.258606910705566406, 0, 0, -0.84804725646972656, 0.529920578002929687, 120, 255, 1, 46741), -- Haystack 01 (Area: Ratchet - Difficulty: 0)
+(@OGUID+50, 179968, 1, 17, 392, '0', 0, 0, -974.1336669921875, -3721.5869140625, 6.223958015441894531, 5.637413978576660156, 0, 0, -0.31730461120605468, 0.948323667049407958, 120, 255, 1, 46741), -- Haystack 01 (Area: Ratchet - Difficulty: 0)
+(@OGUID+51, 179968, 1, 17, 392, '0', 0, 0, -966.12847900390625, -3724.767333984375, 6.00868082046508789, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46741), -- Haystack 01 (Area: Ratchet - Difficulty: 0)
+(@OGUID+52, 180353, 1, 17, 392, '0', 0, 0, -968.01043701171875, -3713.475830078125, 5.502905845642089843, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Ratchet - Difficulty: 0)
+(@OGUID+53, 180353, 1, 17, 392, '0', 0, 0, -968.373291015625, -3719.579833984375, 5.895988941192626953, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Ratchet - Difficulty: 0)
+(@OGUID+54, 180353, 1, 17, 392, '0', 0, 0, -973.86285400390625, -3711.170166015625, 5.46749114990234375, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Ratchet - Difficulty: 0)
+(@OGUID+55, 180353, 1, 17, 392, '0', 0, 0, -964.31427001953125, -3708.630126953125, 5.185822010040283203, 3.263772249221801757, 0, 0, -0.99813461303710937, 0.061051756143569946, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Ratchet - Difficulty: 0)
+(@OGUID+56, 180353, 1, 17, 392, '0', 0, 0, -973.967041015625, -3705.19970703125, 5.312120914459228515, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Ratchet - Difficulty: 0)
+(@OGUID+57, 180353, 1, 17, 392, '0', 0, 0, -974.4617919921875, -3727.421875, 6.358452796936035156, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Ratchet - Difficulty: 0)
+(@OGUID+58, 180353, 1, 17, 392, '0', 0, 0, -968.8038330078125, -3729.73095703125, 6.456596851348876953, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Ratchet - Difficulty: 0)
+(@OGUID+59, 180353, 1, 17, 392, '0', 0, 0, -965.22918701171875, -3724.81591796875, 5.946554183959960937, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Ratchet - Difficulty: 0)
+(@OGUID+60, 180353, 1, 17, 392, '0', 0, 0, -974.89581298828125, -3720.80029296875, 6.163195133209228515, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Ratchet - Difficulty: 0)
+(@OGUID+61, 180353, 1, 17, 392, '0', 0, 0, -967.89410400390625, -3703.720458984375, 5.349818229675292968, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Ratchet - Difficulty: 0)
+(@OGUID+62, 195164, 1, 17, 392, '0', 0, 0, -968.5, -3712.479248046875, 6.180469989776611328, 1.937312245368957519, 0, 0, 0.824125289916992187, 0.566407561302185058, 120, 255, 1, 46741), -- Pumpkin (Area: Ratchet - Difficulty: 0)
+(@OGUID+63, 195164, 1, 17, 392, '0', 0, 0, -973.11456298828125, -3706.07470703125, 5.880798816680908203, 5.602506637573242187, 0, 0, -0.33380699157714843, 0.942641437053680419, 120, 255, 1, 46741), -- Pumpkin (Area: Ratchet - Difficulty: 0)
+(@OGUID+64, 195164, 1, 17, 392, '0', 0, 0, -966.17706298828125, -3724.697998046875, 6.707069873809814453, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 46741), -- Pumpkin (Area: Ratchet - Difficulty: 0)
+(@OGUID+65, 195164, 1, 17, 392, '0', 0, 0, -965.71527099609375, -3708.842041015625, 5.82867288589477539, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 46741), -- Pumpkin (Area: Ratchet - Difficulty: 0)
+(@OGUID+66, 195164, 1, 17, 392, '0', 0, 0, -973.640625, -3726.647705078125, 7.219224929809570312, 0.610863447189331054, 0, 0, 0.3007049560546875, 0.953717231750488281, 120, 255, 1, 46741), -- Pumpkin (Area: Ratchet - Difficulty: 0)
+(@OGUID+67, 195164, 1, 17, 392, '0', 0, 0, -968.2586669921875, -3704.788330078125, 5.936355113983154296, 4.276057243347167968, 0, 0, -0.84339141845703125, 0.537299633026123046, 120, 255, 1, 46741), -- Pumpkin (Area: Ratchet - Difficulty: 0)
+(@OGUID+68, 195164, 1, 17, 392, '0', 0, 0, -973.08160400390625, -3710.913330078125, 6.200242996215820312, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 46741), -- Pumpkin (Area: Ratchet - Difficulty: 0)
+(@OGUID+69, 195164, 1, 17, 392, '0', 0, 0, -969.15277099609375, -3728.44091796875, 7.184504032135009765, 1.884953022003173828, 0, 0, 0.809016227722167968, 0.587786316871643066, 120, 255, 1, 46741), -- Pumpkin (Area: Ratchet - Difficulty: 0)
+(@OGUID+70, 195164, 1, 17, 392, '0', 0, 0, -968.873291015625, -3720.4462890625, 6.689709186553955078, 4.241150379180908203, 0, 0, -0.85264015197753906, 0.522498607635498046, 120, 255, 1, 46741), -- Pumpkin (Area: Ratchet - Difficulty: 0)
+(@OGUID+71, 195164, 1, 17, 392, '0', 0, 0, -974.03643798828125, -3721.632080078125, 6.929293155670166015, 5.637413978576660156, 0, 0, -0.31730461120605468, 0.948323667049407958, 120, 255, 1, 46741), -- Pumpkin (Area: Ratchet - Difficulty: 0)
+(@OGUID+72, 195664, 1, 17, 392, '0', 0, 0, -971.31427001953125, -3724.51220703125, 6.03220987319946289, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- [DND] Collision Thanksgiving Table Size (Area: Ratchet - Difficulty: 0)
+(@OGUID+73, 195664, 1, 17, 392, '0', 0, 0, -970.40972900390625, -3708.798583984375, 5.205905914306640625, 0, 0, 0, 0, 1, 120, 255, 1, 46741); -- [DND] Collision Thanksgiving Table Size (Area: Ratchet - Difficulty: 0)
+
+-- Event spawns
+DELETE FROM `game_event_creature` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @CGUID+0 AND @CGUID+6;
+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);
+
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @OGUID+0 AND @OGUID+73;
+INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES
+(@EVENT, @OGUID+0),
+(@EVENT, @OGUID+1),
+(@EVENT, @OGUID+2),
+(@EVENT, @OGUID+3),
+(@EVENT, @OGUID+4),
+(@EVENT, @OGUID+5),
+(@EVENT, @OGUID+6),
+(@EVENT, @OGUID+7),
+(@EVENT, @OGUID+8),
+(@EVENT, @OGUID+9),
+(@EVENT, @OGUID+10),
+(@EVENT, @OGUID+11),
+(@EVENT, @OGUID+12),
+(@EVENT, @OGUID+13),
+(@EVENT, @OGUID+14),
+(@EVENT, @OGUID+15),
+(@EVENT, @OGUID+16),
+(@EVENT, @OGUID+17),
+(@EVENT, @OGUID+18),
+(@EVENT, @OGUID+19),
+(@EVENT, @OGUID+20),
+(@EVENT, @OGUID+21),
+(@EVENT, @OGUID+22),
+(@EVENT, @OGUID+23),
+(@EVENT, @OGUID+24),
+(@EVENT, @OGUID+25),
+(@EVENT, @OGUID+26),
+(@EVENT, @OGUID+27),
+(@EVENT, @OGUID+28),
+(@EVENT, @OGUID+29),
+(@EVENT, @OGUID+30),
+(@EVENT, @OGUID+31),
+(@EVENT, @OGUID+32),
+(@EVENT, @OGUID+33),
+(@EVENT, @OGUID+34),
+(@EVENT, @OGUID+35),
+(@EVENT, @OGUID+36),
+(@EVENT, @OGUID+37),
+(@EVENT, @OGUID+38),
+(@EVENT, @OGUID+39),
+(@EVENT, @OGUID+40),
+(@EVENT, @OGUID+41),
+(@EVENT, @OGUID+42),
+(@EVENT, @OGUID+43),
+(@EVENT, @OGUID+44),
+(@EVENT, @OGUID+45),
+(@EVENT, @OGUID+46),
+(@EVENT, @OGUID+47),
+(@EVENT, @OGUID+48),
+(@EVENT, @OGUID+49),
+(@EVENT, @OGUID+50),
+(@EVENT, @OGUID+51),
+(@EVENT, @OGUID+52),
+(@EVENT, @OGUID+53),
+(@EVENT, @OGUID+54),
+(@EVENT, @OGUID+55),
+(@EVENT, @OGUID+56),
+(@EVENT, @OGUID+57),
+(@EVENT, @OGUID+58),
+(@EVENT, @OGUID+59),
+(@EVENT, @OGUID+60),
+(@EVENT, @OGUID+61),
+(@EVENT, @OGUID+62),
+(@EVENT, @OGUID+63),
+(@EVENT, @OGUID+64),
+(@EVENT, @OGUID+65),
+(@EVENT, @OGUID+66),
+(@EVENT, @OGUID+67),
+(@EVENT, @OGUID+68),
+(@EVENT, @OGUID+69),
+(@EVENT, @OGUID+70),
+(@EVENT, @OGUID+71),
+(@EVENT, @OGUID+72),
+(@EVENT, @OGUID+73);