DB/DunMorogh: Added Pilgrim's Bounty spawns

1 files changed, 122 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_12_05_03_world.sql b/sql/updates/world/master/2022_12_05_03_world.sql
new file mode 100644
index 00000000000..4ca9d17e851
--- /dev/null
+++ b/sql/updates/world/master/2022_12_05_03_world.sql
@@ -0,0 +1,122 @@
+SET @CGUID := 396441;
+SET @OGUID := 248362;
+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
+(@CGUID+0, 32823, 0, 1, 131, '0', 0, 0, 0, 0, -5615.43603515625, -472.838531494140625, 397.118072509765625, 0, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Kharanos - Difficulty: 0) (Auras: )
+(@CGUID+1, 32823, 0, 1, 131, '0', 0, 0, 0, 0, -5687.1875, -495.3350830078125, 396.381591796875, 5.916666030883789062, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Kharanos - Difficulty: 0)
+(@CGUID+2, 32823, 0, 1, 131, '0', 0, 0, 0, 0, -5697.0380859375, -497.515625, 396.72802734375, 0, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Kharanos - Difficulty: 0)
+(@CGUID+3, 34653, 0, 1, 131, '0', 0, 0, 0, 0, -5619.97900390625, -478.279510498046875, 397.0635986328125, 4.537856101989746093, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741); -- Bountiful Table Hostess (Area: Kharanos - Difficulty: 0)
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+47;
+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, 1, 131, '0', 0, 0, -5617.85595703125, -477.04339599609375, 396.980255126953125, 1.029743075370788574, 0, 0, 0.492423057556152343, 0.870355963706970214, 120, 255, 1, 46741), -- Haystack 01 (Area: Kharanos - Difficulty: 0)
+(@OGUID+1, 179968, 0, 1, 131, '0', 0, 0, -5619.13037109375, -475.204864501953125, 396.980255126953125, 3.403396368026733398, 0, 0, -0.99144458770751953, 0.130528271198272705, 120, 255, 1, 46741), -- Haystack 01 (Area: Kharanos - Difficulty: 0)
+(@OGUID+2, 179968, 0, 1, 131, '0', 0, 0, -5611.64404296875, -478.067718505859375, 396.980255126953125, 1.989672422409057617, 0, 0, 0.838669776916503906, 0.544640243053436279, 120, 255, 1, 46741), -- Haystack 01 (Area: Kharanos - Difficulty: 0)
+(@OGUID+3, 179968, 0, 1, 131, '0', 0, 0, -5614.29345703125, -478.513885498046875, 396.980255126953125, 1.48352813720703125, 0, 0, 0.675589561462402343, 0.737277925014495849, 120, 255, 1, 46741), -- Haystack 01 (Area: Kharanos - Difficulty: 0)
+(@OGUID+4, 179968, 0, 1, 131, '0', 0, 0, -5613.421875, -467.37152099609375, 398.1632080078125, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 46741), -- Haystack 01 (Area: Kharanos - Difficulty: 0)
+(@OGUID+5, 179968, 0, 1, 131, '0', 0, 0, -5608.890625, -471.6788330078125, 397.21875, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Haystack 01 (Area: Kharanos - Difficulty: 0)
+(@OGUID+6, 179968, 0, 1, 131, '0', 0, 0, -5608.861328125, -474.03472900390625, 397.017364501953125, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 120, 255, 1, 46741), -- Haystack 01 (Area: Kharanos - Difficulty: 0)
+(@OGUID+7, 179968, 0, 1, 131, '0', 0, 0, -5618.17529296875, -468.51910400390625, 397.560760498046875, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 46741), -- Haystack 01 (Area: Kharanos - Difficulty: 0)
+(@OGUID+8, 179968, 0, 1, 131, '0', 0, 0, -5620.09033203125, -470.654510498046875, 397.291656494140625, 6.09120035171508789, 0, 0, -0.09584522247314453, 0.995396256446838378, 120, 255, 1, 46741), -- Haystack 01 (Area: Kharanos - Difficulty: 0)
+(@OGUID+9, 179968, 0, 1, 131, '0', 0, 0, -5611.33154296875, -467.982635498046875, 398.1475830078125, 4.1538848876953125, 0, 0, -0.8746194839477539, 0.484810054302215576, 120, 255, 1, 46741), -- Haystack 01 (Area: Kharanos - Difficulty: 0)
+(@OGUID+10, 179968, 0, 1, 131, '0', 0, 0, -5678.47021484375, -489.404998779296875, 395.944000244140625, 4.747295856475830078, 0, 0, -0.69465827941894531, 0.719339847564697265, 120, 255, 1, 46741), -- Haystack 01 (Area: Kharanos - Difficulty: 0)
+(@OGUID+11, 179968, 0, 1, 131, '0', 0, 0, -5680.8193359375, -489.517364501953125, 396.004852294921875, 1.623155713081359863, 0, 0, 0.725374221801757812, 0.688354730606079101, 120, 255, 1, 46741), -- Haystack 01 (Area: Kharanos - Difficulty: 0)
+(@OGUID+12, 179968, 0, 1, 131, '0', 0, 0, -5691.68017578125, -490.0830078125, 396.290985107421875, 1.762782454490661621, 0, 0, 0.771624565124511718, 0.636078238487243652, 120, 255, 1, 46741), -- Haystack 01 (Area: Kharanos - Difficulty: 0)
+(@OGUID+13, 179968, 0, 1, 131, '0', 0, 0, -5688.31005859375, -503.707000732421875, 396.311004638671875, 1.658061861991882324, 0, 0, 0.737277030944824218, 0.67559051513671875, 120, 255, 1, 46741), -- Haystack 01 (Area: Kharanos - Difficulty: 0)
+(@OGUID+14, 179968, 0, 1, 131, '0', 0, 0, -5693.85986328125, -490.62200927734375, 396.281005859375, 4.904376029968261718, 0, 0, -0.636077880859375, 0.771624863147735595, 120, 255, 1, 46741), -- Haystack 01 (Area: Kharanos - Difficulty: 0)
+(@OGUID+15, 179968, 0, 1, 131, '0', 0, 0, -5708.25, -502.625, 396.60699462890625, 2.303830623626708984, 0, 0, 0.913544654846191406, 0.406738430261611938, 120, 255, 1, 46741), -- Haystack 01 (Area: Kharanos - Difficulty: 0)
+(@OGUID+16, 179968, 0, 1, 131, '0', 0, 0, -5705.2900390625, -500.06298828125, 396.4110107421875, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 120, 255, 1, 46741), -- Haystack 01 (Area: Kharanos - Difficulty: 0)
+(@OGUID+17, 179968, 0, 1, 131, '0', 0, 0, -5691.740234375, -504.281005859375, 396.334991455078125, 1.640606880187988281, 0, 0, 0.731352806091308593, 0.6819993257522583, 120, 255, 1, 46741), -- Haystack 01 (Area: Kharanos - Difficulty: 0)
+(@OGUID+18, 180353, 0, 1, 131, '0', 0, 0, -5612.84375, -478.260406494140625, 396.980255126953125, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Kharanos - Difficulty: 0)
+(@OGUID+19, 180353, 0, 1, 131, '0', 0, 0, -5618.74658203125, -476.130218505859375, 396.980255126953125, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Kharanos - Difficulty: 0)
+(@OGUID+20, 180353, 0, 1, 131, '0', 0, 0, -5619.390625, -469.427093505859375, 397.40625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Kharanos - Difficulty: 0)
+(@OGUID+21, 180353, 0, 1, 131, '0', 0, 0, -5608.828125, -472.795135498046875, 397.12847900390625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Kharanos - Difficulty: 0)
+(@OGUID+22, 180353, 0, 1, 131, '0', 0, 0, -5612.41845703125, -467.532989501953125, 398.23089599609375, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Kharanos - Difficulty: 0)
+(@OGUID+23, 180353, 0, 1, 131, '0', 0, 0, -5679.580078125, -489.506988525390625, 395.967987060546875, 4.747295856475830078, 0, 0, -0.69465827941894531, 0.719339847564697265, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Kharanos - Difficulty: 0)
+(@OGUID+24, 180353, 0, 1, 131, '0', 0, 0, -5689.85009765625, -504.040008544921875, 396.324005126953125, 0.034906249493360519, 0, 0, 0.017452239990234375, 0.999847710132598876, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Kharanos - Difficulty: 0)
+(@OGUID+25, 180353, 0, 1, 131, '0', 0, 0, -5692.759765625, -490.332000732421875, 396.2860107421875, 0.174532130360603332, 0, 0, 0.087155342102050781, 0.996194720268249511, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Kharanos - Difficulty: 0)
+(@OGUID+26, 180353, 0, 1, 131, '0', 0, 0, -5706.7001953125, -501.343994140625, 396.3179931640625, 0.715584874153137207, 0, 0, 0.350207328796386718, 0.936672210693359375, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Kharanos - Difficulty: 0)
+(@OGUID+27, 195164, 0, 1, 131, '0', 0, 0, -5617.923828125, -476.97222900390625, 397.641998291015625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Kharanos - Difficulty: 0)
+(@OGUID+28, 195164, 0, 1, 131, '0', 0, 0, -5614.34912109375, -478.442718505859375, 397.641998291015625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Kharanos - Difficulty: 0)
+(@OGUID+29, 195164, 0, 1, 131, '0', 0, 0, -5619.078125, -475.161468505859375, 397.641998291015625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Kharanos - Difficulty: 0)
+(@OGUID+30, 195164, 0, 1, 131, '0', 0, 0, -5608.99853515625, -474.1788330078125, 397.654815673828125, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Kharanos - Difficulty: 0)
+(@OGUID+31, 195164, 0, 1, 131, '0', 0, 0, -5611.46875, -467.994781494140625, 398.8006591796875, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Kharanos - Difficulty: 0)
+(@OGUID+32, 195164, 0, 1, 131, '0', 0, 0, -5618.1943359375, -468.564239501953125, 398.21209716796875, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Kharanos - Difficulty: 0)
+(@OGUID+33, 195164, 0, 1, 131, '0', 0, 0, -5619.9931640625, -470.69964599609375, 397.94647216796875, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Kharanos - Difficulty: 0)
+(@OGUID+34, 195164, 0, 1, 131, '0', 0, 0, -5613.4619140625, -467.467010498046875, 398.788482666015625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Kharanos - Difficulty: 0)
+(@OGUID+35, 195164, 0, 1, 131, '0', 0, 0, -5608.98095703125, -471.70660400390625, 397.871826171875, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Kharanos - Difficulty: 0)
+(@OGUID+36, 195164, 0, 1, 131, '0', 0, 0, -5611.50537109375, -477.947906494140625, 397.641998291015625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Kharanos - Difficulty: 0)
+(@OGUID+37, 195164, 0, 1, 131, '0', 0, 0, -5678.5, -489.313995361328125, 396.634002685546875, 4.747295856475830078, 0, 0, -0.69465827941894531, 0.719339847564697265, 120, 255, 1, 46741), -- Pumpkin (Area: Kharanos - Difficulty: 0)
+(@OGUID+38, 195164, 0, 1, 131, '0', 0, 0, -5680.96875, -489.385406494140625, 396.6871337890625, 4.747295856475830078, 0, 0, -0.69465827941894531, 0.719339847564697265, 120, 255, 1, 46741), -- Pumpkin (Area: Kharanos - Difficulty: 0)
+(@OGUID+39, 195164, 0, 1, 131, '0', 0, 0, -5691.60009765625, -489.959991455078125, 396.990997314453125, 0.174532130360603332, 0, 0, 0.087155342102050781, 0.996194720268249511, 120, 255, 1, 46741), -- Pumpkin (Area: Kharanos - Difficulty: 0)
+(@OGUID+40, 195164, 0, 1, 131, '0', 0, 0, -5688.2099609375, -503.670013427734375, 396.97698974609375, 1.710421562194824218, 0, 0, 0.754709243774414062, 0.656059443950653076, 120, 255, 1, 46741), -- Pumpkin (Area: Kharanos - Difficulty: 0)
+(@OGUID+41, 195164, 0, 1, 131, '0', 0, 0, -5691.68994140625, -504.302001953125, 397.00201416015625, 1.710421562194824218, 0, 0, 0.754709243774414062, 0.656059443950653076, 120, 255, 1, 46741), -- Pumpkin (Area: Kharanos - Difficulty: 0)
+(@OGUID+42, 195164, 0, 1, 131, '0', 0, 0, -5708.14990234375, -502.566009521484375, 397.26300048828125, 2.373644113540649414, 0, 0, 0.927183151245117187, 0.37460830807685852, 120, 255, 1, 46741), -- Pumpkin (Area: Kharanos - Difficulty: 0)
+(@OGUID+43, 195164, 0, 1, 131, '0', 0, 0, -5705.18017578125, -500.12200927734375, 397.121002197265625, 2.373644113540649414, 0, 0, 0.927183151245117187, 0.37460830807685852, 120, 255, 1, 46741), -- Pumpkin (Area: Kharanos - Difficulty: 0)
+(@OGUID+44, 195164, 0, 1, 131, '0', 0, 0, -5693.97998046875, -490.572998046875, 396.97698974609375, 0.174532130360603332, 0, 0, 0.087155342102050781, 0.996194720268249511, 120, 255, 1, 46741), -- Pumpkin (Area: Kharanos - Difficulty: 0)
+(@OGUID+45, 195664, 0, 1, 131, '0', 0, 0, -5615.43994140625, -472.8389892578125, 397.035003662109375, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- [DND] Collision Thanksgiving Table Size (Area: Kharanos - Difficulty: 0)
+(@OGUID+46, 195664, 0, 1, 131, '0', 0, 0, -5687.1875, -495.3350830078125, 396.298248291015625, 5.916667938232421875, 0, 0, -0.18223476409912109, 0.98325502872467041, 120, 255, 1, 46741), -- [DND] Collision Thanksgiving Table Size (Area: Kharanos - Difficulty: 0)
+(@OGUID+47, 195664, 0, 1, 131, '0', 0, 0, -5697.0380859375, -497.515625, 396.624176025390625, 0, 0, 0, 0, 1, 120, 255, 1, 46741); -- [DND] Collision Thanksgiving Table Size (Area: Kharanos - 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+47;
+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);