DB/Mulgore: Added Pilgrim's Bounty spawns

1 files changed, 108 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_12_06_03_world.sql b/sql/updates/world/master/2022_12_06_03_world.sql
new file mode 100644
index 00000000000..7a4f2ad8ea0
--- /dev/null
+++ b/sql/updates/world/master/2022_12_06_03_world.sql
@@ -0,0 +1,108 @@
+SET @CGUID := 396494;
+SET @OGUID := 248808;
+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, 215, 222, '0', 0, 0, 0, 0, -2313.96533203125, -337.289947509765625, -9.34159278869628906, 0, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Bloodhoof Village - Difficulty: 0) (Auras: )
+(@CGUID+1, 32823, 1, 215, 222, '0', 0, 0, 0, 0, -2321.0087890625, -327.28472900390625, -9.34159278869628906, 0, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Bloodhoof Village - Difficulty: 0)
+(@CGUID+2, 34654, 1, 215, 222, '0', 0, 0, 0, 0, -2316.842041015625, -344.295135498046875, -9.34159278869628906, 3.944444179534912109, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741); -- Bountiful Feast Hostess (Area: Bloodhoof Village - 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, 215, 222, '0', 0, 0, -2322.060791015625, -334.64410400390625, -9.42492580413818359, 0.645771682262420654, 0, 0, 0.317304611206054687, 0.948323667049407958, 120, 255, 1, 46741), -- Haystack 01 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+1, 179968, 1, 215, 222, '0', 0, 0, -2316.857666015625, -342.18402099609375, -9.42492580413818359, 3.892086982727050781, 0, 0, -0.93041706085205078, 0.366502493619918823, 120, 255, 1, 46741), -- Haystack 01 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+2, 179968, 1, 215, 222, '0', 0, 0, -2320.666748046875, -336.470489501953125, -9.42492580413818359, 0.628316879272460937, 0, 0, 0.309016227722167968, 0.95105677843093872, 120, 255, 1, 46741), -- Haystack 01 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+3, 179968, 1, 215, 222, '0', 0, 0, -2304.42529296875, -336.1632080078125, -9.42492580413818359, 3.368495941162109375, 0, 0, -0.99357128143310546, 0.113208353519439697, 120, 255, 1, 46741), -- Haystack 01 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+4, 179968, 1, 215, 222, '0', 0, 0, -2310.345458984375, -326.977447509765625, -9.42492580413818359, 3.752462387084960937, 0, 0, -0.95371627807617187, 0.300707906484603881, 120, 255, 1, 46741), -- Haystack 01 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+5, 179968, 1, 215, 222, '0', 0, 0, -2309.14404296875, -328.642364501953125, -9.42492580413818359, 3.682650327682495117, 0, 0, -0.96362972259521484, 0.26724100112915039, 120, 255, 1, 46741), -- Haystack 01 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+6, 179968, 1, 215, 222, '0', 0, 0, -2315.208251953125, -343.586822509765625, -9.42492580413818359, 1.274088263511657714, 0, 0, 0.594821929931640625, 0.80385744571685791, 120, 255, 1, 46741), -- Haystack 01 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+7, 179968, 1, 215, 222, '0', 0, 0, -2314.015625, -321.767364501953125, -9.42492580413818359, 3.682650327682495117, 0, 0, -0.96362972259521484, 0.26724100112915039, 120, 255, 1, 46741), -- Haystack 01 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+8, 179968, 1, 215, 222, '0', 0, 0, -2309.795166015625, -342.602447509765625, -9.42492580413818359, 2.181660413742065429, 0, 0, 0.887010574340820312, 0.461749136447906494, 120, 255, 1, 46741), -- Haystack 01 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+9, 179968, 1, 215, 222, '0', 0, 0, -2305.3681640625, -334.295135498046875, -9.42492580413818359, 3.752462387084960937, 0, 0, -0.95371627807617187, 0.300707906484603881, 120, 255, 1, 46741), -- Haystack 01 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+10, 179968, 1, 215, 222, '0', 0, 0, -2326.163330078125, -329.388885498046875, -9.38439369201660156, 0.628316879272460937, 0, 0, 0.309016227722167968, 0.95105677843093872, 120, 255, 1, 46741), -- Haystack 01 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+11, 179968, 1, 215, 222, '0', 0, 0, -2308.21875, -341.638885498046875, -9.42492580413818359, 2.216565132141113281, 0, 0, 0.894933700561523437, 0.44619917869567871, 120, 255, 1, 46741), -- Haystack 01 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+12, 179968, 1, 215, 222, '0', 0, 0, -2324.404541015625, -321.770843505859375, -9.42492580413818359, 5.288348197937011718, 0, 0, -0.4771585464477539, 0.878817260265350341, 120, 255, 1, 46741), -- Haystack 01 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+13, 179968, 1, 215, 222, '0', 0, 0, -2326.8525390625, -327.046875, -9.42361164093017578, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 46741), -- Haystack 01 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+14, 179968, 1, 215, 222, '0', 0, 0, -2315.692626953125, -320.5538330078125, -9.42492580413818359, 4.293513298034667968, 0, 0, -0.8386697769165039, 0.544640243053436279, 120, 255, 1, 46741), -- Haystack 01 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+15, 179968, 1, 215, 222, '0', 0, 0, -2322.350830078125, -320.498260498046875, -9.42492580413818359, 5.253442287445068359, 0, 0, -0.49242305755615234, 0.870355963706970214, 120, 255, 1, 46741), -- Haystack 01 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+16, 180353, 1, 215, 222, '0', 0, 0, -2321.27783203125, -335.40972900390625, -9.42492580413818359, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+17, 180353, 1, 215, 222, '0', 0, 0, -2309.854248046875, -327.888885498046875, -9.42492580413818359, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+18, 180353, 1, 215, 222, '0', 0, 0, -2304.760498046875, -335.109375, -9.42492580413818359, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+19, 180353, 1, 215, 222, '0', 0, 0, -2309.022705078125, -342.00347900390625, -9.42492580413818359, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+20, 180353, 1, 215, 222, '0', 0, 0, -2326.7744140625, -328.328125, -9.38826847076416015, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+21, 180353, 1, 215, 222, '0', 0, 0, -2316.1181640625, -342.8819580078125, -9.42492580413818359, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+22, 180353, 1, 215, 222, '0', 0, 0, -2323.335205078125, -321.107635498046875, -9.42492580413818359, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+23, 180353, 1, 215, 222, '0', 0, 0, -2314.68408203125, -320.838531494140625, -9.42492580413818359, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+24, 195164, 1, 215, 222, '0', 0, 0, -2320.569580078125, -336.515625, -8.74858474731445312, 0.663223206996917724, 0, 0, 0.325567245483398437, 0.945518851280212402, 120, 255, 1, 46741), -- Pumpkin (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+25, 195164, 1, 215, 222, '0', 0, 0, -2322.083251953125, -334.689239501953125, -8.74858474731445312, 0.663223206996917724, 0, 0, 0.325567245483398437, 0.945518851280212402, 120, 255, 1, 46741), -- Pumpkin (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+26, 195164, 1, 215, 222, '0', 0, 0, -2314.109375, -321.795135498046875, -8.74858474731445312, 3.682650327682495117, 0, 0, -0.96362972259521484, 0.26724100112915039, 120, 255, 1, 46741), -- Pumpkin (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+27, 195164, 1, 215, 222, '0', 0, 0, -2304.48779296875, -336.145843505859375, -8.74858474731445312, 3.368495941162109375, 0, 0, -0.99357128143310546, 0.113208353519439697, 120, 255, 1, 46741), -- Pumpkin (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+28, 195164, 1, 215, 222, '0', 0, 0, -2324.54345703125, -321.9132080078125, -8.74858474731445312, 5.305802345275878906, 0, 0, -0.46947097778320312, 0.882947921752929687, 120, 255, 1, 46741), -- Pumpkin (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+29, 195164, 1, 215, 222, '0', 0, 0, -2305.407958984375, -334.388885498046875, -8.74858474731445312, 3.735006093978881835, 0, 0, -0.95630455017089843, 0.292372345924377441, 120, 255, 1, 46741), -- Pumpkin (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+30, 195164, 1, 215, 222, '0', 0, 0, -2326.875, -327.092010498046875, -8.74727058410644531, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 46741), -- Pumpkin (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+31, 195164, 1, 215, 222, '0', 0, 0, -2309.84375, -342.532989501953125, -8.74858474731445312, 2.181660413742065429, 0, 0, 0.887010574340820312, 0.461749136447906494, 120, 255, 1, 46741), -- Pumpkin (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+32, 195164, 1, 215, 222, '0', 0, 0, -2310.385498046875, -327.071197509765625, -8.74858474731445312, 3.735006093978881835, 0, 0, -0.95630455017089843, 0.292372345924377441, 120, 255, 1, 46741), -- Pumpkin (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+33, 195164, 1, 215, 222, '0', 0, 0, -2308.079833984375, -341.520843505859375, -8.74858474731445312, 2.286378860473632812, 0, 0, 0.909960746765136718, 0.414694398641586303, 120, 255, 1, 46741), -- Pumpkin (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+34, 195164, 1, 215, 222, '0', 0, 0, -2315.27783203125, -343.517364501953125, -8.74858474731445312, 1.256635904312133789, 0, 0, 0.587784767150878906, 0.809017360210418701, 120, 255, 1, 46741), -- Pumpkin (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+35, 195164, 1, 215, 222, '0', 0, 0, -2316.80908203125, -342.138885498046875, -8.74858474731445312, 3.892086982727050781, 0, 0, -0.93041706085205078, 0.366502493619918823, 120, 255, 1, 46741), -- Pumpkin (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+36, 195164, 1, 215, 222, '0', 0, 0, -2309.20654296875, -328.625, -8.74858474731445312, 3.43830275535583496, 0, 0, -0.98901557922363281, 0.147811368107795715, 120, 255, 1, 46741), -- Pumpkin (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+37, 195164, 1, 215, 222, '0', 0, 0, -2326.06591796875, -329.43402099609375, -8.71288204193115234, 0.663223206996917724, 0, 0, 0.325567245483398437, 0.945518851280212402, 120, 255, 1, 46741), -- Pumpkin (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+38, 195164, 1, 215, 222, '0', 0, 0, -2315.83154296875, -320.696197509765625, -8.74858474731445312, 4.310965538024902343, 0, 0, -0.83388519287109375, 0.55193793773651123, 120, 255, 1, 46741), -- Pumpkin (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+39, 195164, 1, 215, 222, '0', 0, 0, -2322.444580078125, -320.526031494140625, -8.74858474731445312, 5.253442287445068359, 0, 0, -0.49242305755615234, 0.870355963706970214, 120, 255, 1, 46741), -- Pumpkin (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+40, 195664, 1, 215, 222, '0', 0, 0, -2313.969970703125, -337.290008544921875, -9.42492961883544921, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- [DND] Collision Thanksgiving Table Size (Area: Bloodhoof Village - Difficulty: 0)
+(@OGUID+41, 195664, 1, 215, 222, '0', 0, 0, -2321.010009765625, -327.285003662109375, -9.42492961883544921, 0, 0, 0, 0, 1, 120, 255, 1, 46741); -- [DND] Collision Thanksgiving Table Size (Area: Bloodhoof Village - 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);