DB/ElwynnForest: Added Pilgrim's Bounty spawns

1 files changed, 82 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_12_05_01_world.sql b/sql/updates/world/master/2022_12_05_01_world.sql
new file mode 100644
index 00000000000..aaaecc3b6a3
--- /dev/null
+++ b/sql/updates/world/master/2022_12_05_01_world.sql
@@ -0,0 +1,82 @@
+SET @CGUID := 396427;
+SET @OGUID := 248274;
+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, 12, 87, '0', 0, 0, 0, 0, -9413.91015625, 73.215301513671875, 57.89853286743164062, 0, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Goldshire - Difficulty: 0) (Auras: )
+(@CGUID+1, 32823, 0, 12, 87, '0', 0, 0, 0, 0, -9423.0107421875, 94.3663177490234375, 57.43033599853515625, 0, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Goldshire - Difficulty: 0) (Auras: )
+(@CGUID+2, 32823, 0, 12, 87, '0', 0, 0, 0, 0, -9438.5, 28.53300094604492187, 57.8441314697265625, 4.677482128143310546, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Goldshire - Difficulty: 0) (Auras: )
+(@CGUID+3, 34653, 0, 12, 87, '0', 0, 0, 0, 0, -9422.4501953125, 69.09380340576171875, 57.20043182373046875, 2.076941728591918945, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741); -- Bountiful Table Hostess (Area: Goldshire - Difficulty: 0)
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+27;
+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, 12, 87, '0', 0, 0, -9422.7802734375, 70.68399810791015625, 57.03300094604492187, 5.218535900115966796, 0, 0, -0.507537841796875, 0.861629426479339599, 120, 255, 1, 46741), -- Haystack 01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+1, 179968, 0, 12, 87, '0', 0, 0, -9420.51953125, 71.972198486328125, 57.18579864501953125, 5.201082706451416015, 0, 0, -0.51503753662109375, 0.857167601585388183, 120, 255, 1, 46741), -- Haystack 01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+2, 179968, 0, 12, 87, '0', 0, 0, -9407.8203125, 81.19100189208984375, 57.65449905395507812, 2.146752834320068359, 0, 0, 0.878816604614257812, 0.477159708738327026, 120, 255, 1, 46741), -- Haystack 01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+3, 179968, 0, 12, 87, '0', 0, 0, -9439.75, 41.62670135498046875, 57.36460113525390625, 0.802850961685180664, 0, 0, 0.390730857849121093, 0.920504987239837646, 120, 255, 1, 46741), -- Haystack 01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+4, 179968, 0, 12, 87, '0', 0, 0, -9414.599609375, 98.8889007568359375, 58.3227996826171875, 2.286378860473632812, 0, 0, 0.909960746765136718, 0.414694398641586303, 120, 255, 1, 46741), -- Haystack 01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+5, 179968, 0, 12, 87, '0', 0, 0, -9416.330078125, 97.38719940185546875, 58.1510009765625, 2.268925428390502929, 0, 0, 0.906307220458984375, 0.422619491815567016, 120, 255, 1, 46741), -- Haystack 01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+6, 179968, 0, 12, 87, '0', 0, 0, -9405.9296875, 82.4582977294921875, 57.74480056762695312, 2.094393253326416015, 0, 0, 0.866024971008300781, 0.50000077486038208, 120, 255, 1, 46741), -- Haystack 01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+7, 179968, 0, 12, 87, '0', 0, 0, -9441.6201171875, 43.14929962158203125, 57.0269012451171875, 0.855210542678833007, 0, 0, 0.414692878723144531, 0.909961462020874023, 120, 255, 1, 46741), -- Haystack 01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+8, 179968, 0, 12, 87, '0', 0, 0, -9433.259765625, 34.90449905395507812, 57.12779998779296875, 0.558503925800323486, 0, 0, 0.275636672973632812, 0.961261868476867675, 120, 255, 1, 46741), -- Haystack 01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+9, 179968, 0, 12, 87, '0', 0, 0, -9434.83984375, 36.9010009765625, 57.23440170288085937, 3.769911527633666992, 0, 0, -0.95105648040771484, 0.309017121791839599, 120, 255, 1, 46741), -- Haystack 01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+10, 180353, 0, 12, 87, '0', 0, 0, -9421.58984375, 71.465301513671875, 57.105499267578125, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+11, 180353, 0, 12, 87, '0', 0, 0, -9406.919921875, 81.9167022705078125, 57.7238006591796875, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+12, 180353, 0, 12, 87, '0', 0, 0, -9440.650390625, 42.54510116577148437, 57.18920135498046875, 0.837757468223571777, 0, 0, 0.406736373901367187, 0.913545548915863037, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+13, 180353, 0, 12, 87, '0', 0, 0, -9415.5302734375, 98.1042022705078125, 57.99900054931640625, 4.1538848876953125, 0, 0, -0.8746194839477539, 0.484810054302215576, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+14, 180353, 0, 12, 87, '0', 0, 0, -9433.919921875, 35.96179962158203125, 57.17020034790039062, 4.764749526977539062, 0, 0, -0.6883544921875, 0.725374460220336914, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Goldshire - Difficulty: 0)
+(@OGUID+15, 195164, 0, 12, 87, '0', 0, 0, -9422.8203125, 70.5885009765625, 57.69390106201171875, 5.410521507263183593, 0, 0, -0.42261791229248046, 0.906307935714721679, 120, 255, 1, 46741), -- Pumpkin (Area: Goldshire - Difficulty: 0)
+(@OGUID+16, 195164, 0, 12, 87, '0', 0, 0, -9420.650390625, 71.9600982666015625, 57.84780120849609375, 5.305802345275878906, 0, 0, -0.46947097778320312, 0.882947921752929687, 120, 255, 1, 46741), -- Pumpkin (Area: Goldshire - Difficulty: 0)
+(@OGUID+17, 195164, 0, 12, 87, '0', 0, 0, -9407.7998046875, 81.1457977294921875, 58.33240127563476562, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Goldshire - Difficulty: 0)
+(@OGUID+18, 195164, 0, 12, 87, '0', 0, 0, -9416.400390625, 97.57289886474609375, 58.79890060424804687, 4.1538848876953125, 0, 0, -0.8746194839477539, 0.484810054302215576, 120, 255, 1, 46741), -- Pumpkin (Area: Goldshire - Difficulty: 0)
+(@OGUID+19, 195164, 0, 12, 87, '0', 0, 0, -9405.7900390625, 82.5764007568359375, 58.43539810180664062, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Goldshire - Difficulty: 0)
+(@OGUID+20, 195164, 0, 12, 87, '0', 0, 0, -9441.6201171875, 43.21879959106445312, 57.67399978637695312, 0.820303261280059814, 0, 0, 0.398748397827148437, 0.917060375213623046, 120, 255, 1, 46741), -- Pumpkin (Area: Goldshire - Difficulty: 0)
+(@OGUID+21, 195164, 0, 12, 87, '0', 0, 0, -9414.580078125, 98.9792022705078125, 58.9897003173828125, 2.373644113540649414, 0, 0, 0.927183151245117187, 0.37460830807685852, 120, 255, 1, 46741), -- Pumpkin (Area: Goldshire - Difficulty: 0)
+(@OGUID+22, 195164, 0, 12, 87, '0', 0, 0, -9439.83984375, 41.62329864501953125, 58.028900146484375, 0.767943859100341796, 0, 0, 0.374606132507324218, 0.927184045314788818, 120, 255, 1, 46741), -- Pumpkin (Area: Goldshire - Difficulty: 0)
+(@OGUID+23, 195164, 0, 12, 87, '0', 0, 0, -9434.8798828125, 36.7985992431640625, 57.855499267578125, 3.717553615570068359, 0, 0, -0.95881938934326171, 0.284016460180282592, 120, 255, 1, 46741), -- Pumpkin (Area: Goldshire - Difficulty: 0)
+(@OGUID+24, 195164, 0, 12, 87, '0', 0, 0, -9433.2998046875, 34.92010116577148437, 57.74959945678710937, 4.764749526977539062, 0, 0, -0.6883544921875, 0.725374460220336914, 120, 255, 1, 46741), -- Pumpkin (Area: Goldshire - Difficulty: 0)
+(@OGUID+25, 195664, 0, 12, 87, '0', 0, 0, -9413.91015625, 73.215301513671875, 57.8152008056640625, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- [DND] Collision Thanksgiving Table Size (Area: Goldshire - Difficulty: 0)
+(@OGUID+26, 195664, 0, 12, 87, '0', 0, 0, -9423.0107421875, 94.3663177490234375, 57.34700393676757812, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- [DND] Collision Thanksgiving Table Size (Area: Goldshire - Difficulty: 0)
+(@OGUID+27, 195664, 0, 12, 87, '0', 0, 0, -9438.5, 28.53300094604492187, 57.76079940795898437, 4.677483558654785156, 0, 0, -0.71933937072753906, 0.694658815860748291, 120, 255, 1, 46741); -- [DND] Collision Thanksgiving Table Size (Area: Goldshire - 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+27;
+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);