DB/EversongWoods: Added Pilgrim's Bounty spawns

1 files changed, 112 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_12_06_07_world.sql b/sql/updates/world/master/2022_12_06_07_world.sql
new file mode 100644
index 00000000000..a4ab8a8bfb6
--- /dev/null
+++ b/sql/updates/world/master/2022_12_06_07_world.sql
@@ -0,0 +1,112 @@
+SET @CGUID := 396520;
+SET @OGUID := 249002;
+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, 530, 3430, 3665, '0', 0, 0, 0, 0, 9499.5087890625, -6777.47216796875, 16.57567787170410156, 0, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Falconwing Square - Difficulty: 0) (Auras: )
+(@CGUID+1, 32823, 530, 3430, 3665, '0', 0, 0, 0, 0, 9488.8203125, -6775.6875, 16.57689857482910156, 0, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Falconwing Square - Difficulty: 0)
+(@CGUID+2, 32823, 530, 3430, 3665, '0', 0, 0, 0, 0, 9509.5908203125, -6778.6025390625, 16.57607078552246093, 0, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741), -- Bountiful Table (Area: Falconwing Square - Difficulty: 0)
+(@CGUID+3, 34654, 530, 3430, 3665, '0', 0, 0, 0, 0, 9485.875, -6782.515625, 16.57613563537597656, 4.502949237823486328, 120, 0, 0, 19343, 0, 0, 0, 0, 0, 46741); -- Bountiful Feast Hostess (Area: Falconwing Square - Difficulty: 0)
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+42;
+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, 530, 3430, 3665, '0', 0, 0, 9495.951171875, -6781.64599609375, 16.49193763732910156, 1.518436193466186523, 0, 0, 0.6883544921875, 0.725374460220336914, 120, 255, 1, 46741), -- Haystack 01 (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+1, 179968, 530, 3430, 3665, '0', 0, 0, 9503.7890625, -6783.171875, 16.491790771484375, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 120, 255, 1, 46741), -- Haystack 01 (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+2, 179968, 530, 3430, 3665, '0', 0, 0, 9493.3037109375, -6781.40283203125, 16.49275779724121093, 1.48352813720703125, 0, 0, 0.675589561462402343, 0.737277925014495849, 120, 255, 1, 46741), -- Haystack 01 (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+3, 179968, 530, 3430, 3665, '0', 0, 0, 9505.95703125, -6783.4150390625, 16.49179458618164062, 1.500982880592346191, 0, 0, 0.681998252868652343, 0.731353819370269775, 120, 255, 1, 46741), -- Haystack 01 (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+4, 179968, 530, 3430, 3665, '0', 0, 0, 9494.658203125, -6770.88916015625, 16.4935760498046875, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 46741), -- Haystack 01 (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+5, 179968, 530, 3430, 3665, '0', 0, 0, 9516.9052734375, -6782.64404296875, 16.49261665344238281, 3.071766138076782226, 0, 0, 0.999390602111816406, 0.034906134009361267, 120, 255, 1, 46741), -- Haystack 01 (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+6, 179968, 530, 3430, 3665, '0', 0, 0, 9516.8798828125, -6775.3994140625, 16.49353981018066406, 3.106652259826660156, 0, 0, 0.999847412109375, 0.017469281330704689, 120, 255, 1, 46741), -- Haystack 01 (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+7, 179968, 530, 3430, 3665, '0', 0, 0, 9484.80078125, -6779.5556640625, 16.49356269836425781, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 46741), -- Haystack 01 (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+8, 179968, 530, 3430, 3665, '0', 0, 0, 9504.6220703125, -6772.3125, 16.49357795715332031, 4.59021615982055664, 0, 0, -0.74895572662353515, 0.662620067596435546, 120, 255, 1, 46741), -- Haystack 01 (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+9, 179968, 530, 3430, 3665, '0', 0, 0, 9486.2041015625, -6771.05224609375, 16.49356460571289062, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 120, 255, 1, 46741), -- Haystack 01 (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+10, 179968, 530, 3430, 3665, '0', 0, 0, 9496.580078125, -6771.19287109375, 16.49357795715332031, 4.59021615982055664, 0, 0, -0.74895572662353515, 0.662620067596435546, 120, 255, 1, 46741), -- Haystack 01 (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+11, 179968, 530, 3430, 3665, '0', 0, 0, 9515.560546875, -6783.71728515625, 16.49218177795410156, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 120, 255, 1, 46741), -- Haystack 01 (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+12, 179968, 530, 3430, 3665, '0', 0, 0, 9484.87890625, -6772.55712890625, 16.49356460571289062, 6.248279094696044921, 0, 0, -0.01745223999023437, 0.999847710132598876, 120, 255, 1, 46741), -- Haystack 01 (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+13, 179968, 530, 3430, 3665, '0', 0, 0, 9507, -6772.55712890625, 16.49357795715332031, 4.59021615982055664, 0, 0, -0.74895572662353515, 0.662620067596435546, 120, 255, 1, 46741), -- Haystack 01 (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+14, 179968, 530, 3430, 3665, '0', 0, 0, 9515.48828125, -6774.171875, 16.49357795715332031, 4.59021615982055664, 0, 0, -0.74895572662353515, 0.662620067596435546, 120, 255, 1, 46741), -- Haystack 01 (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+15, 179968, 530, 3430, 3665, '0', 0, 0, 9486.443359375, -6780.5625, 16.49340057373046875, 1.500982880592346191, 0, 0, 0.681998252868652343, 0.731353819370269775, 120, 255, 1, 46741), -- Haystack 01 (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+16, 180353, 530, 3430, 3665, '0', 0, 0, 9494.7548828125, -6781.15283203125, 16.49226951599121093, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+17, 180353, 530, 3430, 3665, '0', 0, 0, 9504.78125, -6783.25, 16.491790771484375, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+18, 180353, 530, 3430, 3665, '0', 0, 0, 9516.8115234375, -6783.82275390625, 16.49230003356933593, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+19, 180353, 530, 3430, 3665, '0', 0, 0, 9505.7255859375, -6772.408203125, 16.49357795715332031, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+20, 180353, 530, 3430, 3665, '0', 0, 0, 9495.66015625, -6771.048828125, 16.49357795715332031, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+21, 180353, 530, 3430, 3665, '0', 0, 0, 9516.505859375, -6774.30029296875, 16.49357795715332031, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+22, 180353, 530, 3430, 3665, '0', 0, 0, 9484.8955078125, -6780.611328125, 16.49337577819824218, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+23, 180353, 530, 3430, 3665, '0', 0, 0, 9485.0419921875, -6771.19287109375, 16.49356460571289062, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Freestanding Torch 01 (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+24, 195164, 530, 3430, 3665, '0', 0, 0, 9503.6513671875, -6783.314453125, 16.491790771484375, 1.500982880592346191, 0, 0, 0.681998252868652343, 0.731353819370269775, 120, 255, 1, 46741), -- Pumpkin (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+25, 195164, 530, 3430, 3665, '0', 0, 0, 9496.091796875, -6781.52783203125, 16.49193763732910156, 1.553341388702392578, 0, 0, 0.700908660888671875, 0.713251054286956787, 120, 255, 1, 46741), -- Pumpkin (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+26, 195164, 530, 3430, 3665, '0', 0, 0, 9505.865234375, -6783.44287109375, 16.49179458618164062, 1.466075778007507324, 0, 0, 0.669130325317382812, 0.74314504861831665, 120, 255, 1, 46741), -- Pumpkin (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+27, 195164, 530, 3430, 3665, '0', 0, 0, 9493.25390625, -6781.33349609375, 16.49278831481933593, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- Pumpkin (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+28, 195164, 530, 3430, 3665, '0', 0, 0, 9506.86328125, -6772.69970703125, 16.49357795715332031, 4.625123500823974609, 0, 0, -0.73727703094482421, 0.67559051513671875, 120, 255, 1, 46741), -- Pumpkin (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+29, 195164, 530, 3430, 3665, '0', 0, 0, 9484.9755859375, -6772.6025390625, 16.49356460571289062, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 46741), -- Pumpkin (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+30, 195164, 530, 3430, 3665, '0', 0, 0, 9504.529296875, -6772.34033203125, 16.49355125427246093, 4.607671737670898437, 0, 0, -0.74314403533935546, 0.669131457805633544, 120, 255, 1, 46741), -- Pumpkin (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+31, 195164, 530, 3430, 3665, '0', 0, 0, 9486.3759765625, -6780.4931640625, 16.49343109130859375, 1.48352813720703125, 0, 0, 0.675589561462402343, 0.737277925014495849, 120, 255, 1, 46741), -- Pumpkin (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+32, 195164, 530, 3430, 3665, '0', 0, 0, 9516.7431640625, -6775.54150390625, 16.49356460571289062, 3.071766138076782226, 0, 0, 0.999390602111816406, 0.034906134009361267, 120, 255, 1, 46741), -- Pumpkin (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+33, 195164, 530, 3430, 3665, '0', 0, 0, 9515.3955078125, -6774.19970703125, 16.49357795715332031, 4.59021615982055664, 0, 0, -0.74895572662353515, 0.662620067596435546, 120, 255, 1, 46741), -- Pumpkin (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+34, 195164, 530, 3430, 3665, '0', 0, 0, 9516.814453125, -6782.671875, 16.49260330200195312, 3.054326534271240234, 0, 0, 0.999048233032226562, 0.043619260191917419, 120, 255, 1, 46741), -- Pumpkin (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+35, 195164, 530, 3430, 3665, '0', 0, 0, 9515.423828125, -6783.859375, 16.49214553833007812, 1.518436193466186523, 0, 0, 0.6883544921875, 0.725374460220336914, 120, 255, 1, 46741), -- Pumpkin (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+36, 195164, 530, 3430, 3665, '0', 0, 0, 9486.1845703125, -6771.09716796875, 16.49356460571289062, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 120, 255, 1, 46741), -- Pumpkin (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+37, 195164, 530, 3430, 3665, '0', 0, 0, 9484.8486328125, -6779.51025390625, 16.49356269836425781, 6.248279094696044921, 0, 0, -0.01745223999023437, 0.999847710132598876, 120, 255, 1, 46741), -- Pumpkin (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+38, 195164, 530, 3430, 3665, '0', 0, 0, 9496.51953125, -6771.17724609375, 16.49357795715332031, 4.59021615982055664, 0, 0, -0.74895572662353515, 0.662620067596435546, 120, 255, 1, 46741), -- Pumpkin (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+39, 195164, 530, 3430, 3665, '0', 0, 0, 9494.6162109375, -6770.98291015625, 16.4935760498046875, 4.223697185516357421, 0, 0, -0.85716724395751953, 0.515038192272186279, 120, 255, 1, 46741), -- Pumpkin (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+40, 195664, 530, 3430, 3665, '0', 0, 0, 9499.509765625, -6777.47021484375, 16.49230003356933593, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- [DND] Collision Thanksgiving Table Size (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+41, 195664, 530, 3430, 3665, '0', 0, 0, 9488.8203125, -6775.68994140625, 16.49360084533691406, 0, 0, 0, 0, 1, 120, 255, 1, 46741), -- [DND] Collision Thanksgiving Table Size (Area: Falconwing Square - Difficulty: 0)
+(@OGUID+42, 195664, 530, 3430, 3665, '0', 0, 0, 9509.58984375, -6778.60009765625, 16.49270057678222656, 0, 0, 0, 0, 1, 120, 255, 1, 46741); -- [DND] Collision Thanksgiving Table Size (Area: Falconwing Square - 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+42;
+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);