DB/Desolace: Added Pilgrim's Bounty spawns

1 files changed, 124 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_12_07_06_world.sql b/sql/updates/world/master/2022_12_07_06_world.sql
new file mode 100644
index 00000000000..9738cf1f227
--- /dev/null
+++ b/sql/updates/world/master/2022_12_07_06_world.sql
@@ -0,0 +1,124 @@
+SET @CGUID := 396547;
+SET @OGUID := 249307;
+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
+-- Nijel's Point
+(@CGUID+0, 32823, 1, 405, 608, '0', 0, 0, 0, 0, 189.3246612548828125, 1302.40625, 190.2981719970703125, 0, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Nijel's Point - Difficulty: 0) (Auras: )
+(@CGUID+1, 34653, 1, 405, 608, '0', 0, 0, 0, 0, 180.203125, 1303.8663330078125, 189.9722137451171875, 2.600540637969970703, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table Hostess (Area: Nijel's Point - Difficulty: 0)
+-- Shadowprey Village
+(@CGUID+2, 32823, 1, 405, 2408, '0', 0, 0, 0, 0, -1709.9478759765625, 3091.11279296875, 33.81567764282226562, 0, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Shadowprey Village - Difficulty: 0)
+(@CGUID+3, 34654, 1, 405, 2408, '0', 0, 0, 0, 0, -1707.859375, 3098.8671875, 33.56597137451171875, 2.513274192810058593, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741); -- Bountiful Feast Hostess (Area: Shadowprey Village - Difficulty: 0)
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+46;
+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
+-- Nijel's Point
+(@OGUID+0, 179968, 1, 405, 608, '0', 0, 0, 182.4583282470703125, 1301.875, 189.9530181884765625, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 46741), -- Haystack 01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+1, 179968, 1, 405, 608, '0', 0, 0, 182.3489532470703125, 1303.920166015625, 189.9664154052734375, 3.124123096466064453, 0, 0, 0.99996185302734375, 0.008734640665352344, 120, 255, 1, 46741), -- Haystack 01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+2, 179968, 1, 405, 608, '0', 0, 0, 196.8715362548828125, 1302.85595703125, 190.37847900390625, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 120, 255, 1, 46741), -- Haystack 01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+3, 179968, 1, 405, 608, '0', 0, 0, 195.2881927490234375, 1297.44970703125, 190.9243927001953125, 2.286378860473632812, 0, 0, 0.909960746765136718, 0.414694398641586303, 120, 255, 1, 46741), -- Haystack 01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+4, 179968, 1, 405, 608, '0', 0, 0, 193.5555572509765625, 1296.185791015625, 190.8506927490234375, 2.094393253326416015, 0, 0, 0.866024971008300781, 0.50000077486038208, 120, 255, 1, 46741), -- Haystack 01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+5, 179968, 1, 405, 608, '0', 0, 0, 186.84375, 1296.2396240234375, 190.3350677490234375, 1.378809213638305664, 0, 0, 0.636077880859375, 0.771624863147735595, 120, 255, 1, 46741), -- Haystack 01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+6, 179968, 1, 405, 608, '0', 0, 0, 197.0364532470703125, 1304.41845703125, 190.3156280517578125, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Haystack 01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+7, 179968, 1, 405, 608, '0', 0, 0, 185.345489501953125, 1297.2882080078125, 190.2118072509765625, 3.752462387084960937, 0, 0, -0.95371627807617187, 0.300707906484603881, 120, 255, 1, 46741), -- Haystack 01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+8, 180353, 1, 405, 608, '0', 0, 0, 182.5520782470703125, 1302.7691650390625, 189.9608917236328125, 0.261798173189163208, 0, 0, 0.130525588989257812, 0.991444945335388183, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+9, 180353, 1, 405, 608, '0', 0, 0, 186.017364501953125, 1296.5504150390625, 190.28125, 0.349065244197845458, 0, 0, 0.173647880554199218, 0.984807789325714111, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+10, 180353, 1, 405, 608, '0', 0, 0, 194.626739501953125, 1296.8646240234375, 190.9166717529296875, 0.296705186367034912, 0, 0, 0.147809028625488281, 0.989015936851501464, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+11, 180353, 1, 405, 608, '0', 0, 0, 197.0243072509765625, 1303.6336669921875, 190.34063720703125, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+12, 195164, 1, 405, 608, '0', 0, 0, 182.37847900390625, 1303.8785400390625, 190.6326446533203125, 1.047197580337524414, 0, 0, 0.5, 0.866025388240814208, 120, 255, 1, 46741), -- Pumpkin (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+13, 195164, 1, 405, 608, '0', 0, 0, 182.564239501953125, 1301.857666015625, 190.624359130859375, 0.261798173189163208, 0, 0, 0.130525588989257812, 0.991444945335388183, 120, 255, 1, 46741), -- Pumpkin (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+14, 195164, 1, 405, 608, '0', 0, 0, 185.375, 1297.3472900390625, 190.877838134765625, 0.349065244197845458, 0, 0, 0.173647880554199218, 0.984807789325714111, 120, 255, 1, 46741), -- Pumpkin (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+15, 195164, 1, 405, 608, '0', 0, 0, 186.7552032470703125, 1296.28125, 190.9958953857421875, 0.349065244197845458, 0, 0, 0.173647880554199218, 0.984807789325714111, 120, 255, 1, 46741), -- Pumpkin (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+16, 195164, 1, 405, 608, '0', 0, 0, 196.9427032470703125, 1304.390625, 190.9824981689453125, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+17, 195164, 1, 405, 608, '0', 0, 0, 193.4895782470703125, 1296.2379150390625, 191.5045928955078125, 0.296705186367034912, 0, 0, 0.147809028625488281, 0.989015936851501464, 120, 255, 1, 46741), -- Pumpkin (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+18, 195164, 1, 405, 608, '0', 0, 0, 195.3854217529296875, 1297.6024169921875, 191.5827178955078125, 0.296705186367034912, 0, 0, 0.147809028625488281, 0.989015936851501464, 120, 255, 1, 46741), -- Pumpkin (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+19, 195164, 1, 405, 608, '0', 0, 0, 196.732635498046875, 1302.7135009765625, 191.0566558837890625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Nijel's Point - Difficulty: 0)
+(@OGUID+20, 195664, 1, 405, 608, '0', 0, 0, 189.3246612548828125, 1302.40625, 190.21484375, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- [DND] Collision Thanksgiving Table Size (Area: Nijel's Point - Difficulty: 0)
+-- Shadowprey Village
+(@OGUID+21, 179968, 1, 405, 2408, '0', 0, 0, -1712.592041015625, 3087.248291015625, 34.20486068725585937, 1.029743075370788574, 0, 0, 0.492423057556152343, 0.870355963706970214, 120, 255, 1, 46741), -- Haystack 01 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+22, 179968, 1, 405, 2408, '0', 0, 0, -1707.71875, 3096.5712890625, 33.73821258544921875, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 46741), -- Haystack 01 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+23, 179968, 1, 405, 2408, '0', 0, 0, -1703.7257080078125, 3091.9150390625, 33.4827880859375, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Haystack 01 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+24, 179968, 1, 405, 2408, '0', 0, 0, -1706.5538330078125, 3086.057373046875, 33.84766769409179687, 1.989672422409057617, 0, 0, 0.838669776916503906, 0.544640243053436279, 120, 255, 1, 46741), -- Haystack 01 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+25, 179968, 1, 405, 2408, '0', 0, 0, -1713.638916015625, 3088.748291015625, 34.17534637451171875, 3.403396368026733398, 0, 0, -0.99144458770751953, 0.130528271198272705, 120, 255, 1, 46741), -- Haystack 01 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+26, 179968, 1, 405, 2408, '0', 0, 0, -1714.282958984375, 3093.626708984375, 34.05902862548828125, 6.09120035171508789, 0, 0, -0.09584522247314453, 0.995396256446838378, 120, 255, 1, 46741), -- Haystack 01 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+27, 179968, 1, 405, 2408, '0', 0, 0, -1708.1944580078125, 3085.5712890625, 34.0086822509765625, 1.48352813720703125, 0, 0, 0.675589561462402343, 0.737277925014495849, 120, 255, 1, 46741), -- Haystack 01 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+28, 179968, 1, 405, 2408, '0', 0, 0, -1713.203125, 3094.970458984375, 34.00173568725585937, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 46741), -- Haystack 01 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+29, 179968, 1, 405, 2408, '0', 0, 0, -1703.890625, 3090.3525390625, 33.47401046752929687, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 120, 255, 1, 46741), -- Haystack 01 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+30, 179968, 1, 405, 2408, '0', 0, 0, -1706.189208984375, 3096.1650390625, 33.57986068725585937, 4.1538848876953125, 0, 0, -0.8746194839477539, 0.484810054302215576, 120, 255, 1, 46741), -- Haystack 01 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+31, 180353, 1, 405, 2408, '0', 0, 0, -1707.357666015625, 3085.692626953125, 33.9375, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+32, 180353, 1, 405, 2408, '0', 0, 0, -1713.2603759765625, 3087.82470703125, 34.1875, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+33, 180353, 1, 405, 2408, '0', 0, 0, -1713.954833984375, 3094.463623046875, 34.02083206176757812, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+34, 180353, 1, 405, 2408, '0', 0, 0, -1703.7379150390625, 3091.130126953125, 33.47048568725585937, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+35, 180353, 1, 405, 2408, '0', 0, 0, -1706.9305419921875, 3096.421875, 33.65277862548828125, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+36, 195164, 1, 405, 2408, '0', 0, 0, -1706.4149169921875, 3086.17529296875, 34.50072097778320312, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+37, 195164, 1, 405, 2408, '0', 0, 0, -1707.7603759765625, 3096.4775390625, 34.43422698974609375, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+38, 195164, 1, 405, 2408, '0', 0, 0, -1714.185791015625, 3093.58154296875, 34.73978424072265625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+39, 195164, 1, 405, 2408, '0', 0, 0, -1713.59033203125, 3088.79345703125, 34.852630615234375, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+40, 195164, 1, 405, 2408, '0', 0, 0, -1706.251708984375, 3096.182373046875, 34.26513290405273437, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+41, 195164, 1, 405, 2408, '0', 0, 0, -1704.029541015625, 3090.210205078125, 34.17554855346679687, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+42, 195164, 1, 405, 2408, '0', 0, 0, -1703.8194580078125, 3091.88720703125, 34.179168701171875, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+43, 195164, 1, 405, 2408, '0', 0, 0, -1708.2430419921875, 3085.640625, 34.69117355346679687, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+44, 195164, 1, 405, 2408, '0', 0, 0, -1713.2257080078125, 3094.92529296875, 34.68249130249023437, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+45, 195164, 1, 405, 2408, '0', 0, 0, -1712.6614990234375, 3087.317626953125, 34.87520217895507812, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Shadowprey Village - Difficulty: 0)
+(@OGUID+46, 195664, 1, 405, 2408, '0', 0, 0, -1709.949951171875, 3091.110107421875, 33.7322998046875, 0, 0, 0, 0, 1, 120, 255, 1, 46741); -- [DND] Collision Thanksgiving Table Size (Area: Shadowprey Village - 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+46;
+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);