DB/Ashenvale: Added Pilgrim's Bounty spawns

1 files changed, 134 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_12_07_03_world.sql b/sql/updates/world/master/2022_12_07_03_world.sql
new file mode 100644
index 00000000000..1b8d83cb870
--- /dev/null
+++ b/sql/updates/world/master/2022_12_07_03_world.sql
@@ -0,0 +1,134 @@
+SET @CGUID := 396532;
+SET @OGUID := 249129;
+SET @EVENT := 26;
+
+-- Creature spawns
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+3;
+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
+-- Astranaar
+(@CGUID+0, 32823, 1, 331, 415, '0', 0, 0, 0, 0, 2750.56005859375, -437.07501220703125, 111.5633392333984375, 0, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Astranaar - Difficulty: 0) (Auras: )
+(@CGUID+1, 34653, 1, 331, 415, '0', 0, 0, 0, 0, 2759.2099609375, -438.204986572265625, 111.5443344116210937, 5.689773082733154296, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table Hostess (Area: Astranaar - Difficulty: 0)
+-- Splintertree Post
+(@CGUID+2, 32823, 1, 331, 431, '0', 0, 0, 0, 0, 2345.969970703125, -2561.659912109375, 103.1763381958007812, 5.358160972595214843, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Splintertree Post - Difficulty: 0)
+(@CGUID+3, 34654, 1, 331, 431, '0', 0, 0, 0, 0, 2340.929931640625, -2555.989990234375, 103.1763381958007812, 3.752457857131958007, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741); -- Bountiful Feast Hostess (Area: Splintertree Post - Difficulty: 0)
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+51;
+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
+-- Astranaar
+(@OGUID+0, 179968, 1, 331, 415, '0', 0, 0, 2748.139892578125, -441.2760009765625, 111.4789962768554687, 1.029743075370788574, 0, 0, 0.492423057556152343, 0.870355963706970214, 120, 255, 1, 46741), -- Haystack 01 (Area: Astranaar - Difficulty: 0)
+(@OGUID+1, 179968, 1, 331, 415, '0', 0, 0, 2752.570068359375, -431.605987548828125, 111.4800033569335937, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 46741), -- Haystack 01 (Area: Astranaar - Difficulty: 0)
+(@OGUID+2, 179968, 1, 331, 415, '0', 0, 0, 2757.1298828125, -438.269012451171875, 111.4670028686523437, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 120, 255, 1, 46741), -- Haystack 01 (Area: Astranaar - Difficulty: 0)
+(@OGUID+3, 179968, 1, 331, 415, '0', 0, 0, 2747.820068359375, -432.75201416015625, 111.4690017700195312, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 46741), -- Haystack 01 (Area: Astranaar - Difficulty: 0)
+(@OGUID+4, 179968, 1, 331, 415, '0', 0, 0, 2754.35009765625, -442.29998779296875, 111.4710006713867187, 1.989672422409057617, 0, 0, 0.838669776916503906, 0.544640243053436279, 120, 255, 1, 46741), -- Haystack 01 (Area: Astranaar - Difficulty: 0)
+(@OGUID+5, 179968, 1, 331, 415, '0', 0, 0, 2757.10009765625, -435.9110107421875, 111.4690017700195312, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Haystack 01 (Area: Astranaar - Difficulty: 0)
+(@OGUID+6, 179968, 1, 331, 415, '0', 0, 0, 2745.89990234375, -434.886993408203125, 111.464996337890625, 6.09120035171508789, 0, 0, -0.09584522247314453, 0.995396256446838378, 120, 255, 1, 46741), -- Haystack 01 (Area: Astranaar - Difficulty: 0)
+(@OGUID+7, 179968, 1, 331, 415, '0', 0, 0, 2746.8701171875, -439.438995361328125, 111.4729995727539062, 3.403396368026733398, 0, 0, -0.99144458770751953, 0.130528271198272705, 120, 255, 1, 46741), -- Haystack 01 (Area: Astranaar - Difficulty: 0)
+(@OGUID+8, 179968, 1, 331, 415, '0', 0, 0, 2751.699951171875, -442.7449951171875, 111.477996826171875, 1.48352813720703125, 0, 0, 0.675589561462402343, 0.737277925014495849, 120, 255, 1, 46741), -- Haystack 01 (Area: Astranaar - Difficulty: 0)
+(@OGUID+9, 179968, 1, 331, 415, '0', 0, 0, 2754.590087890625, -432.24700927734375, 111.4789962768554687, 4.1538848876953125, 0, 0, -0.8746194839477539, 0.484810054302215576, 120, 255, 1, 46741), -- Haystack 01 (Area: Astranaar - Difficulty: 0)
+(@OGUID+10, 180353, 1, 331, 415, '0', 0, 0, 2747.25, -440.363006591796875, 111.4749984741210937, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Astranaar - Difficulty: 0)
+(@OGUID+11, 180353, 1, 331, 415, '0', 0, 0, 2746.60009765625, -433.6610107421875, 111.46600341796875, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Astranaar - Difficulty: 0)
+(@OGUID+12, 180353, 1, 331, 415, '0', 0, 0, 2757.169921875, -437.0260009765625, 111.4680023193359375, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Astranaar - Difficulty: 0)
+(@OGUID+13, 180353, 1, 331, 415, '0', 0, 0, 2753.580078125, -431.7659912109375, 111.483001708984375, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Astranaar - Difficulty: 0)
+(@OGUID+14, 180353, 1, 331, 415, '0', 0, 0, 2753.14990234375, -442.4949951171875, 111.4739990234375, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Astranaar - Difficulty: 0)
+(@OGUID+15, 195164, 1, 331, 415, '0', 0, 0, 2757.010009765625, -435.938995361328125, 112.0970001220703125, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Astranaar - Difficulty: 0)
+(@OGUID+16, 195164, 1, 331, 415, '0', 0, 0, 2748.070068359375, -441.207000732421875, 112.1060028076171875, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Astranaar - Difficulty: 0)
+(@OGUID+17, 195164, 1, 331, 415, '0', 0, 0, 2746.919921875, -439.394012451171875, 112.1009979248046875, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Astranaar - Difficulty: 0)
+(@OGUID+18, 195164, 1, 331, 415, '0', 0, 0, 2747.800048828125, -432.7969970703125, 112.0970001220703125, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Astranaar - Difficulty: 0)
+(@OGUID+19, 195164, 1, 331, 415, '0', 0, 0, 2756.989990234375, -438.4110107421875, 112.095001220703125, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Astranaar - Difficulty: 0)
+(@OGUID+20, 195164, 1, 331, 415, '0', 0, 0, 2754.52001953125, -432.230987548828125, 112.1070022583007812, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Astranaar - Difficulty: 0)
+(@OGUID+21, 195164, 1, 331, 415, '0', 0, 0, 2751.64990234375, -442.67498779296875, 112.1060028076171875, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Astranaar - Difficulty: 0)
+(@OGUID+22, 195164, 1, 331, 415, '0', 0, 0, 2754.489990234375, -442.1820068359375, 112.0979995727539062, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Astranaar - Difficulty: 0)
+(@OGUID+23, 195164, 1, 331, 415, '0', 0, 0, 2746, -434.9320068359375, 112.0940017700195312, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Astranaar - Difficulty: 0)
+(@OGUID+24, 195164, 1, 331, 415, '0', 0, 0, 2752.530029296875, -431.70001220703125, 112.108001708984375, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Astranaar - Difficulty: 0)
+(@OGUID+25, 195664, 1, 331, 415, '0', 0, 0, 2750.56005859375, -437.07501220703125, 111.4800033569335937, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- [DND] Collision Thanksgiving Table Size (Area: Astranaar - Difficulty: 0)
+-- Splintertree Post
+(@OGUID+26, 179968, 1, 331, 431, '0', 0, 0, 2352.18994140625, -2560.860107421875, 103.0930023193359375, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 120, 255, 1, 46741), -- Haystack 01 (Area: Splintertree Post - Difficulty: 0)
+(@OGUID+27, 179968, 1, 331, 431, '0', 0, 0, 2342.7099609375, -2557.800048828125, 103.0930023193359375, 4.066620349884033203, 0, 0, -0.89493370056152343, 0.44619917869567871, 120, 255, 1, 46741), -- Haystack 01 (Area: Splintertree Post - Difficulty: 0)
+(@OGUID+28, 179968, 1, 331, 431, '0', 0, 0, 2349.72998046875, -2556.610107421875, 103.0930023193359375, 5.93412017822265625, 0, 0, -0.17364788055419921, 0.984807789325714111, 120, 255, 1, 46741), -- Haystack 01 (Area: Splintertree Post - Difficulty: 0)
+(@OGUID+29, 179968, 1, 331, 431, '0', 0, 0, 2343.320068359375, -2565.52001953125, 103.0930023193359375, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, 46741), -- Haystack 01 (Area: Splintertree Post - Difficulty: 0)
+(@OGUID+30, 179968, 1, 331, 431, '0', 0, 0, 2349.360107421875, -2566.719970703125, 103.0930023193359375, 0.506144583225250244, 0, 0, 0.250379562377929687, 0.968147754669189453, 120, 255, 1, 46741), -- Haystack 01 (Area: Splintertree Post - Difficulty: 0)
+(@OGUID+31, 179968, 1, 331, 431, '0', 0, 0, 2341.6298828125, -2559.139892578125, 103.0930023193359375, 4.014260292053222656, 0, 0, -0.90630722045898437, 0.422619491815567016, 120, 255, 1, 46741), -- Haystack 01 (Area: Splintertree Post - Difficulty: 0)
+(@OGUID+32, 179968, 1, 331, 431, '0', 0, 0, 2347.550048828125, -2567.35009765625, 103.0930023193359375, 0.366517573595046997, 0, 0, 0.182234764099121093, 0.98325502872467041, 120, 255, 1, 46741), -- Haystack 01 (Area: Splintertree Post - Difficulty: 0)
+(@OGUID+33, 179968, 1, 331, 431, '0', 0, 0, 2348.199951171875, -2556.199951171875, 103.0930023193359375, 2.897245407104492187, 0, 0, 0.99254608154296875, 0.121869951486587524, 120, 255, 1, 46741), -- Haystack 01 (Area: Splintertree Post - Difficulty: 0)
+(@OGUID+34, 179968, 1, 331, 431, '0', 0, 0, 2342.280029296875, -2564.02001953125, 103.0930023193359375, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, 46741), -- Haystack 01 (Area: Splintertree Post - Difficulty: 0)
+(@OGUID+35, 179968, 1, 331, 431, '0', 0, 0, 2352.030029296875, -2562.419921875, 103.0930023193359375, 4.747295856475830078, 0, 0, -0.69465827941894531, 0.719339847564697265, 120, 255, 1, 46741), -- Haystack 01 (Area: Splintertree Post - Difficulty: 0)
+(@OGUID+36, 180353, 1, 331, 431, '0', 0, 0, 2342.659912109375, -2564.949951171875, 103.0930023193359375, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Splintertree Post - Difficulty: 0)
+(@OGUID+37, 180353, 1, 331, 431, '0', 0, 0, 2348.56005859375, -2567.080078125, 103.0930023193359375, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Splintertree Post - Difficulty: 0)
+(@OGUID+38, 180353, 1, 331, 431, '0', 0, 0, 2341.9599609375, -2558.31005859375, 103.0930023193359375, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Splintertree Post - Difficulty: 0)
+(@OGUID+39, 180353, 1, 331, 431, '0', 0, 0, 2352.179931640625, -2561.639892578125, 103.0930023193359375, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Splintertree Post - Difficulty: 0)
+(@OGUID+40, 180353, 1, 331, 431, '0', 0, 0, 2348.989990234375, -2556.35009765625, 103.0930023193359375, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Splintertree Post - Difficulty: 0)
+(@OGUID+41, 195164, 1, 331, 431, '0', 0, 0, 2349.5, -2566.60009765625, 103.7350006103515625, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, 46741), -- Pumpkin (Area: Splintertree Post - Difficulty: 0)
+(@OGUID+42, 195164, 1, 331, 431, '0', 0, 0, 2342.68994140625, -2557.85009765625, 103.7350006103515625, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, 46741), -- Pumpkin (Area: Splintertree Post - Difficulty: 0)
+(@OGUID+43, 195164, 1, 331, 431, '0', 0, 0, 2348.159912109375, -2556.300048828125, 103.7350006103515625, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, 46741), -- Pumpkin (Area: Splintertree Post - Difficulty: 0)
+(@OGUID+44, 195164, 1, 331, 431, '0', 0, 0, 2347.669921875, -2567.1298828125, 103.7350006103515625, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, 46741), -- Pumpkin (Area: Splintertree Post - Difficulty: 0)
+(@OGUID+45, 195164, 1, 331, 431, '0', 0, 0, 2341.72998046875, -2559.18994140625, 103.7350006103515625, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, 46741), -- Pumpkin (Area: Splintertree Post - Difficulty: 0)
+(@OGUID+46, 195164, 1, 331, 431, '0', 0, 0, 2352.10009765625, -2560.889892578125, 103.7350006103515625, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, 46741), -- Pumpkin (Area: Splintertree Post - Difficulty: 0)
+(@OGUID+47, 195164, 1, 331, 431, '0', 0, 0, 2343.260009765625, -2565.449951171875, 103.7350006103515625, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, 46741), -- Pumpkin (Area: Splintertree Post - Difficulty: 0)
+(@OGUID+48, 195164, 1, 331, 431, '0', 0, 0, 2342.330078125, -2563.97998046875, 103.7350006103515625, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, 46741), -- Pumpkin (Area: Splintertree Post - Difficulty: 0)
+(@OGUID+49, 195164, 1, 331, 431, '0', 0, 0, 2351.889892578125, -2562.56005859375, 103.7350006103515625, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, 46741), -- Pumpkin (Area: Splintertree Post - Difficulty: 0)
+(@OGUID+50, 195164, 1, 331, 431, '0', 0, 0, 2349.669921875, -2556.590087890625, 103.7350006103515625, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, 46741), -- Pumpkin (Area: Splintertree Post - Difficulty: 0)
+(@OGUID+51, 195664, 1, 331, 431, '0', 0, 0, 2345.969970703125, -2561.659912109375, 103.0930023193359375, 0, 0, 0, 0, 1, 120, 255, 1, 46741); -- [DND] Collision Thanksgiving Table Size (Area: Splintertree Post - Difficulty: 0)
+
+-- Event spawns
+DELETE FROM `game_event_creature` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @CGUID+0 AND @CGUID+3;
+INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES
+(@EVENT, @CGUID+0), 
+(@EVENT, @CGUID+1),
+(@EVENT, @CGUID+2),
+(@EVENT, @CGUID+3);
+
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @OGUID+0 AND @OGUID+51;
+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);