DB/Durotar: Added Pilgrim's Bounty spawns

1 files changed, 108 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_12_06_01_world.sql b/sql/updates/world/master/2022_12_06_01_world.sql
new file mode 100644
index 00000000000..0d397fcbb81
--- /dev/null
+++ b/sql/updates/world/master/2022_12_06_01_world.sql
@@ -0,0 +1,108 @@
+SET @CGUID := 396480;
+SET @OGUID := 248697;
+SET @EVENT := 26;
+
+-- Creature spawns
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+2;
+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, 1, 14, 362, '0', 0, 0, 0, 0, 253.087005615234375, -4762.85986328125, 12.20313262939453125, 4.956735134124755859, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Razor Hill - Difficulty: 0) (Auras: )
+(@CGUID+1, 32823, 1, 14, 362, '0', 0, 0, 0, 0, 256.266998291015625, -4774.66015625, 11.46393299102783203, 4.956735134124755859, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Razor Hill - Difficulty: 0)
+(@CGUID+2, 34654, 1, 14, 362, '0', 0, 0, 0, 0, 253.337005615234375, -4753.85986328125, 11.8663330078125, 1.082104086875915527, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741); -- Bountiful Feast Hostess (Area: Razor Hill - Difficulty: 0)
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+41;
+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, 1, 14, 362, '0', 0, 0, 259.9639892578125, -4768.60009765625, 11.68229961395263671, 3.473210096359252929, 0, 0, -0.98628520965576171, 0.165049895644187927, 120, 255, 1, 46741), -- Haystack 01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+1, 179968, 1, 14, 362, '0', 0, 0, 259.269012451171875, -4766.7099609375, 11.7239999771118164, 3.43830275535583496, 0, 0, -0.98901557922363281, 0.147811368107795715, 120, 255, 1, 46741), -- Haystack 01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+2, 179968, 1, 14, 362, '0', 0, 0, 252.3260040283203125, -4783.22998046875, 10.75049972534179687, 1.239183306694030761, 0, 0, 0.580702781677246093, 0.814115643501281738, 120, 255, 1, 46741), -- Haystack 01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+3, 179968, 1, 14, 362, '0', 0, 0, 244.281005859375, -4759.740234375, 12.91839981079101562, 2.565631866455078125, 0, 0, 0.958819389343261718, 0.284016460180282592, 120, 255, 1, 46741), -- Haystack 01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+4, 179968, 1, 14, 362, '0', 0, 0, 247.8130035400390625, -4772.830078125, 11.55210018157958984, 0.226892471313476562, 0, 0, 0.113203048706054687, 0.993571877479553222, 120, 255, 1, 46741), -- Haystack 01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+5, 179968, 1, 14, 362, '0', 0, 0, 247.188995361328125, -4770.81005859375, 11.82989978790283203, 0.314158439636230468, 0, 0, 0.156434059143066406, 0.987688362598419189, 120, 255, 1, 46741), -- Haystack 01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+6, 179968, 1, 14, 362, '0', 0, 0, 255.417999267578125, -4754.35986328125, 11.48390007019042968, 4.555310726165771484, 0, 0, -0.76040554046630859, 0.649448513984680175, 120, 255, 1, 46741), -- Haystack 01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+7, 179968, 1, 14, 362, '0', 0, 0, 260.24798583984375, -4783.5400390625, 10.90050029754638671, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 46741), -- Haystack 01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+8, 179968, 1, 14, 362, '0', 0, 0, 243.787994384765625, -4762.06005859375, 12.84720039367675781, 0.261798173189163208, 0, 0, 0.130525588989257812, 0.991444945335388183, 120, 255, 1, 46741), -- Haystack 01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+9, 179968, 1, 14, 362, '0', 0, 0, 258.14801025390625, -4784.60009765625, 10.82269954681396484, 2.007128477096557617, 0, 0, 0.84339141845703125, 0.537299633026123046, 120, 255, 1, 46741), -- Haystack 01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+10, 179968, 1, 14, 362, '0', 0, 0, 263.99700927734375, -4777.0400390625, 11.27089977264404296, 3.543023586273193359, 0, 0, -0.97992420196533203, 0.199370384216308593, 120, 255, 1, 46741), -- Haystack 01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+11, 179968, 1, 14, 362, '0', 0, 0, 250.9499969482421875, -4782, 10.77779960632324218, 0.418878614902496337, 0, 0, 0.207911491394042968, 0.978147625923156738, 120, 255, 1, 46741), -- Haystack 01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+12, 179968, 1, 14, 362, '0', 0, 0, 257.235992431640625, -4755.9599609375, 11.48270034790039062, 3.595378875732421875, 0, 0, -0.97437000274658203, 0.224951311945915222, 120, 255, 1, 46741), -- Haystack 01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+13, 179968, 1, 14, 362, '0', 0, 0, 250.037994384765625, -4754.72021484375, 12.27779960632324218, 4.991643905639648437, 0, 0, -0.60181427001953125, 0.798636078834533691, 120, 255, 1, 46741), -- Haystack 01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+14, 179968, 1, 14, 362, '0', 0, 0, 263.587005615234375, -4779.3798828125, 11.1436004638671875, 2.44346022605895996, 0, 0, 0.939692497253417968, 0.34202045202255249, 120, 255, 1, 46741), -- Haystack 01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+15, 179968, 1, 14, 362, '0', 0, 0, 247.8390045166015625, -4755.58984375, 12.57989978790283203, 5.061456203460693359, 0, 0, -0.57357597351074218, 0.819152355194091796, 120, 255, 1, 46741), -- Haystack 01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+16, 180353, 1, 14, 362, '0', 0, 0, 259.635009765625, -4767.75, 11.70489978790283203, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+17, 180353, 1, 14, 362, '0', 0, 0, 247.3679962158203125, -4771.85986328125, 11.6875, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+18, 180353, 1, 14, 362, '0', 0, 0, 256.365997314453125, -4755.2001953125, 11.47570037841796875, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+19, 180353, 1, 14, 362, '0', 0, 0, 264.1199951171875, -4778.2998046875, 11.20139980316162109, 2.164205789566040039, 0, 0, 0.882946968078613281, 0.469472706317901611, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+20, 180353, 1, 14, 362, '0', 0, 0, 248.8300018310546875, -4755.16015625, 12.43920040130615234, 5.026549339294433593, 0, 0, -0.5877847671508789, 0.809017360210418701, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+21, 180353, 1, 14, 362, '0', 0, 0, 251.7449951171875, -4782.56982421875, 10.77079963684082031, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+22, 180353, 1, 14, 362, '0', 0, 0, 243.688995361328125, -4760.85009765625, 12.92879962921142578, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+23, 180353, 1, 14, 362, '0', 0, 0, 259.1610107421875, -4784.16015625, 10.85449981689453125, 1.937312245368957519, 0, 0, 0.824125289916992187, 0.566407561302185058, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Razor Hill - Difficulty: 0)
+(@OGUID+24, 195164, 1, 14, 362, '0', 0, 0, 259.092010498046875, -4766.60986328125, 12.37390041351318359, 3.473210096359252929, 0, 0, -0.98628520965576171, 0.165049895644187927, 120, 255, 1, 46741), -- Pumpkin (Area: Razor Hill - Difficulty: 0)
+(@OGUID+25, 195164, 1, 14, 362, '0', 0, 0, 259.907989501953125, -4768.52001953125, 12.32880020141601562, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 120, 255, 1, 46741), -- Pumpkin (Area: Razor Hill - Difficulty: 0)
+(@OGUID+26, 195164, 1, 14, 362, '0', 0, 0, 252.4720001220703125, -4783.330078125, 11.39480018615722656, 1.274088263511657714, 0, 0, 0.594821929931640625, 0.80385744571685791, 120, 255, 1, 46741), -- Pumpkin (Area: Razor Hill - Difficulty: 0)
+(@OGUID+27, 195164, 1, 14, 362, '0', 0, 0, 244.3350067138671875, -4759.77001953125, 13.55970001220703125, 2.565631866455078125, 0, 0, 0.958819389343261718, 0.284016460180282592, 120, 255, 1, 46741), -- Pumpkin (Area: Razor Hill - Difficulty: 0)
+(@OGUID+28, 195164, 1, 14, 362, '0', 0, 0, 243.8329925537109375, -4761.97021484375, 13.49370002746582031, 0.24434557557106018, 0, 0, 0.121869087219238281, 0.9925462007522583, 120, 255, 1, 46741), -- Pumpkin (Area: Razor Hill - Difficulty: 0)
+(@OGUID+29, 195164, 1, 14, 362, '0', 0, 0, 263.587005615234375, -4779.31982421875, 11.79129981994628906, 2.460912704467773437, 0, 0, 0.942641258239746093, 0.333807557821273803, 120, 255, 1, 46741), -- Pumpkin (Area: Razor Hill - Difficulty: 0)
+(@OGUID+30, 195164, 1, 14, 362, '0', 0, 0, 250.9980010986328125, -4781.93994140625, 11.42599964141845703, 0.418878614902496337, 0, 0, 0.207911491394042968, 0.978147625923156738, 120, 255, 1, 46741), -- Pumpkin (Area: Razor Hill - Difficulty: 0)
+(@OGUID+31, 195164, 1, 14, 362, '0', 0, 0, 247.1349945068359375, -4770.7998046875, 12.47809982299804687, 0.314158439636230468, 0, 0, 0.156434059143066406, 0.987688362598419189, 120, 255, 1, 46741), -- Pumpkin (Area: Razor Hill - Difficulty: 0)
+(@OGUID+32, 195164, 1, 14, 362, '0', 0, 0, 249.985992431640625, -4754.7099609375, 12.92770004272460937, 4.991643905639648437, 0, 0, -0.60181427001953125, 0.798636078834533691, 120, 255, 1, 46741), -- Pumpkin (Area: Razor Hill - Difficulty: 0)
+(@OGUID+33, 195164, 1, 14, 362, '0', 0, 0, 260.14599609375, -4783.52978515625, 11.54430007934570312, 2.059488296508789062, 0, 0, 0.857167243957519531, 0.515038192272186279, 120, 255, 1, 46741), -- Pumpkin (Area: Razor Hill - Difficulty: 0)
+(@OGUID+34, 195164, 1, 14, 362, '0', 0, 0, 258.14801025390625, -4784.52978515625, 11.47039985656738281, 2.007128477096557617, 0, 0, 0.84339141845703125, 0.537299633026123046, 120, 255, 1, 46741), -- Pumpkin (Area: Razor Hill - Difficulty: 0)
+(@OGUID+35, 195164, 1, 14, 362, '0', 0, 0, 247.8260040283203125, -4755.7001953125, 13.22980022430419921, 5.061456203460693359, 0, 0, -0.57357597351074218, 0.819152355194091796, 120, 255, 1, 46741), -- Pumpkin (Area: Razor Hill - Difficulty: 0)
+(@OGUID+36, 195164, 1, 14, 362, '0', 0, 0, 255.2469940185546875, -4754.27001953125, 12.14570045471191406, 4.59021615982055664, 0, 0, -0.74895572662353515, 0.662620067596435546, 120, 255, 1, 46741), -- Pumpkin (Area: Razor Hill - Difficulty: 0)
+(@OGUID+37, 195164, 1, 14, 362, '0', 0, 0, 257.180999755859375, -4755.8798828125, 12.11520004272460937, 3.612837791442871093, 0, 0, -0.97236919403076171, 0.233448356389999389, 120, 255, 1, 46741), -- Pumpkin (Area: Razor Hill - Difficulty: 0)
+(@OGUID+38, 195164, 1, 14, 362, '0', 0, 0, 263.89801025390625, -4777.02978515625, 11.91609954833984375, 3.560472726821899414, 0, 0, -0.97814750671386718, 0.207912087440490722, 120, 255, 1, 46741), -- Pumpkin (Area: Razor Hill - Difficulty: 0)
+(@OGUID+39, 195164, 1, 14, 362, '0', 0, 0, 247.7969970703125, -4772.93994140625, 12.18120002746582031, 0.24434557557106018, 0, 0, 0.121869087219238281, 0.9925462007522583, 120, 255, 1, 46741), -- Pumpkin (Area: Razor Hill - Difficulty: 0)
+(@OGUID+40, 195664, 1, 14, 362, '0', 0, 0, 253.087005615234375, -4762.85986328125, 12.11979961395263671, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 46741), -- [DND] Collision Thanksgiving Table Size (Area: Razor Hill - Difficulty: 0)
+(@OGUID+41, 195664, 1, 14, 362, '0', 0, 0, 256.266998291015625, -4774.66015625, 11.3805999755859375, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 46741); -- [DND] Collision Thanksgiving Table Size (Area: Razor Hill - Difficulty: 0)
+
+-- Event spawns
+DELETE FROM `game_event_creature` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @CGUID+0 AND @CGUID+2;
+INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES
+(@EVENT, @CGUID+0), 
+(@EVENT, @CGUID+1),
+(@EVENT, @CGUID+2);
+
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=@EVENT AND `guid` BETWEEN @OGUID+0 AND @OGUID+41;
+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);