DB/Silithus: Added Hallows End spawns

Ref #28449

1 files changed, 115 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_11_12_14_world_silithus_cenarion_hold.sql b/sql/updates/world/master/2022_11_12_14_world_silithus_cenarion_hold.sql
new file mode 100644
index 00000000000..f8007173bf7
--- /dev/null
+++ b/sql/updates/world/master/2022_11_12_14_world_silithus_cenarion_hold.sql
@@ -0,0 +1,115 @@
+SET @OGUID := 248064;
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=46366 WHERE `entry`=190107; -- Candy Bucket
+
+UPDATE `gameobject_template_addon` SET `faction`=35 WHERE `entry`=190107; -- Candy Bucket
+
+-- Quests
+UPDATE `quest_offer_reward` SET `VerifiedBuild`=46366 WHERE `ID`=12401;
+
+DELETE FROM `gameobject_queststarter` WHERE `id`=190107;
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(190107, 12401, 46366);
+
+UPDATE `gameobject_questender` SET `VerifiedBuild`=46366 WHERE (`id`=190107 AND `quest`=12401);
+
+DELETE FROM `game_event_gameobject_quest` WHERE `id`=190107;
+
+-- Old gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 227863 AND 227943;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 227863 AND 227943;
+
+-- 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, 180405, 1, 1377, 3425, '0', 0, 0, -6845.8662109375, 737.00347900390625, 45.3452911376953125, 2.321286916732788085, 0, 0, 0.917059898376464843, 0.398749500513076782, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+1, 180406, 1, 1377, 3425, '0', 0, 0, -6848.8994140625, 742.9132080078125, 45.3786163330078125, 2.460912704467773437, 0, 0, 0.942641258239746093, 0.333807557821273803, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+2, 180407, 1, 1377, 3425, '0', 0, 0, -6851.30224609375, 741.84375, 56.65892410278320312, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+3, 180407, 1, 1377, 3425, '0', 0, 0, -6848.44775390625, 735.88714599609375, 56.65433120727539062, 2.44346022605895996, 0, 0, 0.939692497253417968, 0.34202045202255249, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+4, 180410, 1, 1377, 3425, '0', 0, 0, -6860.06787109375, 719.546875, 47.32749176025390625, 2.076939344406127929, 0, 0, 0.861628532409667968, 0.50753939151763916, 120, 255, 1, 46366), -- G_HangingSkeleton_01 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+5, 180410, 1, 1377, 3425, '0', 0, 0, -6871.8349609375, 741.84027099609375, 47.25341033935546875, 5.201082706451416015, 0, 0, -0.51503753662109375, 0.857167601585388183, 120, 255, 1, 46366), -- G_HangingSkeleton_01 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+6, 180411, 1, 1377, 3425, '0', 0, 0, -6856.36474609375, 706.31427001953125, 63.8646392822265625, 3.717553615570068359, 0, 0, -0.95881938934326171, 0.284016460180282592, 120, 255, 1, 46366), -- G_Ghost_01 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+7, 180411, 1, 1377, 3425, '0', 0, 0, -6834.8037109375, 746.420166015625, 64.1032867431640625, 3.543023586273193359, 0, 0, -0.97992420196533203, 0.199370384216308593, 120, 255, 1, 46366), -- G_Ghost_01 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+8, 180411, 1, 1377, 3425, '0', 0, 0, -6879.99853515625, 753.092041015625, 64.5603790283203125, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 120, 255, 1, 46366), -- G_Ghost_01 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+9, 180426, 1, 1377, 3425, '0', 0, 0, -6868.28466796875, 729.45489501953125, 69.5771942138671875, 5.151032924652099609, 0, 0, -0.53632450103759765, 0.844011843204498291, 120, 255, 1, 46366), -- Bat01 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+10, 180426, 1, 1377, 3425, '0', 0, 0, -6868.2431640625, 729.6632080078125, 69.5742645263671875, 3.178854942321777343, 0, 0, -0.99982643127441406, 0.018630025908350944, 120, 255, 1, 46366), -- Bat01 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+11, 180426, 1, 1377, 3425, '0', 0, 0, -6868.36474609375, 729.29864501953125, 69.58489227294921875, 2.149065732955932617, 0, 0, 0.879367828369140625, 0.476143062114715576, 120, 255, 1, 46366), -- Bat01 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+12, 180426, 1, 1377, 3425, '0', 0, 0, -6868.35595703125, 729.3507080078125, 69.58284759521484375, 2.218876123428344726, 0, 0, 0.895448684692382812, 0.445164769887924194, 120, 255, 1, 46366), -- Bat01 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+13, 180426, 1, 1377, 3425, '0', 0, 0, -6868.36279296875, 729.420166015625, 69.58049774169921875, 3.876943111419677734, 0, 0, -0.93316555023193359, 0.359446883201599121, 120, 255, 1, 46366), -- Bat01 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+14, 180426, 1, 1377, 3425, '0', 0, 0, -6868.34912109375, 729.248291015625, 69.58638763427734375, 5.657180309295654296, 0, 0, -0.30791664123535156, 0.951413333415985107, 120, 255, 1, 46366), -- Bat01 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+15, 180426, 1, 1377, 3425, '0', 0, 0, -6868.50341796875, 729.36114501953125, 69.5898895263671875, 1.224040150642395019, 0, 0, 0.574522018432617187, 0.818489134311676025, 120, 255, 1, 46366), -- Bat01 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+16, 180426, 1, 1377, 3425, '0', 0, 0, -6868.470703125, 729.42706298828125, 69.5865936279296875, 2.428315162658691406, 0, 0, 0.937075614929199218, 0.349126458168029785, 120, 255, 1, 46366), -- Bat01 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+17, 180426, 1, 1377, 3425, '0', 0, 0, -6868.34716796875, 729.48614501953125, 69.58113861083984375, 3.301003456115722656, 0, 0, -0.99682521820068359, 0.079620920121669769, 120, 255, 1, 46366), -- Bat01 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+18, 180426, 1, 1377, 3425, '0', 0, 0, -6868.37158203125, 729.40106201171875, 69.58141326904296875, 6.250591278076171875, 0, 0, -0.01629638671875, 0.999867200851440429, 120, 255, 1, 46366), -- Bat01 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+19, 180427, 1, 1377, 3425, '0', 0, 0, -6868.13525390625, 729.467041015625, 69.5729217529296875, 0.909881889820098876, 0, 0, 0.439409255981445312, 0.898286998271942138, 120, 255, 1, 46366), -- Bat02 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+20, 180427, 1, 1377, 3425, '0', 0, 0, -6868.27978515625, 729.41668701171875, 69.5784149169921875, 1.398573517799377441, 0, 0, 0.643671989440917968, 0.765301465988159179, 120, 255, 1, 46366), -- Bat02 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+21, 180427, 1, 1377, 3425, '0', 0, 0, -6868.26025390625, 729.3663330078125, 69.57970428466796875, 5.081219673156738281, 0, 0, -0.56545352935791015, 0.824780166149139404, 120, 255, 1, 46366), -- Bat02 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+22, 180427, 1, 1377, 3425, '0', 0, 0, -6868.61474609375, 729.482666015625, 69.5918426513671875, 2.498130559921264648, 0, 0, 0.948689460754394531, 0.316209226846694946, 120, 255, 1, 46366), -- Bat02 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+23, 180427, 1, 1377, 3425, '0', 0, 0, -6868.3837890625, 729.09027099609375, 69.5912322998046875, 1.712731480598449707, 0, 0, 0.755466461181640625, 0.65518730878829956, 120, 255, 1, 46366), -- Bat02 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+24, 180427, 1, 1377, 3425, '0', 0, 0, -6868.40478515625, 729.4375, 69.5843963623046875, 2.026891708374023437, 0, 0, 0.848659515380859375, 0.528939545154571533, 120, 255, 1, 46366), -- Bat02 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+25, 180427, 1, 1377, 3425, '0', 0, 0, -6868.32666015625, 729.19793701171875, 69.58763885498046875, 4.156195640563964843, 0, 0, -0.87405872344970703, 0.485820263624191284, 120, 255, 1, 46366), -- Bat02 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+26, 180427, 1, 1377, 3425, '0', 0, 0, -6868.296875, 729.52606201171875, 69.5784149169921875, 2.672665357589721679, 0, 0, 0.972639083862304687, 0.232321321964263916, 120, 255, 1, 46366), -- Bat02 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+27, 180427, 1, 1377, 3425, '0', 0, 0, -6868.3662109375, 729.73956298828125, 69.57366180419921875, 5.133581161499023437, 0, 0, -0.54366874694824218, 0.83929985761642456, 120, 255, 1, 46366), -- Bat02 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+28, 180427, 1, 1377, 3425, '0', 0, 0, -6868.390625, 729.18231201171875, 69.5898895263671875, 0.525908589363098144, 0, 0, 0.259934425354003906, 0.965626239776611328, 120, 255, 1, 46366), -- Bat02 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+29, 180448, 1, 1377, 3425, '0', 0, 0, -6847.41162109375, 748.78643798828125, 42.53837966918945312, 0.610863447189331054, 0, 0, 0.3007049560546875, 0.953717231750488281, 120, 255, 1, 46366), -- Wanted Poster: Deathclasp (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+30, 180471, 1, 1377, 3425, '0', 0, 0, -6851.330078125, 722.14239501953125, 54.66414642333984375, 1.937312245368957519, 0, 0, 0.824125289916992187, 0.566407561302185058, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+31, 180471, 1, 1377, 3425, '0', 0, 0, -6872.171875, 711.654541015625, 54.71162033081054687, 5.131268978118896484, 0, 0, -0.54463863372802734, 0.838670849800109863, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+32, 180471, 1, 1377, 3425, '0', 0, 0, -6864.02587890625, 747.95489501953125, 54.58295440673828125, 2.007128477096557617, 0, 0, 0.84339141845703125, 0.537299633026123046, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+33, 180471, 1, 1377, 3425, '0', 0, 0, -6885.015625, 737.5086669921875, 54.5417022705078125, 5.113816738128662109, 0, 0, -0.55193614959716796, 0.833886384963989257, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+34, 180472, 1, 1377, 3425, '0', 0, 0, -6861.484375, 733.154541015625, 52.30553054809570312, 0.453785061836242675, 0, 0, 0.224950790405273437, 0.974370121955871582, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+35, 180472, 1, 1377, 3425, '0', 0, 0, -6852.83349609375, 717.2569580078125, 52.95908737182617187, 5.253442287445068359, 0, 0, -0.49242305755615234, 0.870355963706970214, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+36, 180472, 1, 1377, 3425, '0', 0, 0, -6867.30712890625, 709.94964599609375, 52.93153762817382812, 5.253442287445068359, 0, 0, -0.49242305755615234, 0.870355963706970214, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+37, 180472, 1, 1377, 3425, '0', 0, 0, -6869.41650390625, 750.47393798828125, 53.12325668334960937, 2.111847877502441406, 0, 0, 0.870355606079101562, 0.492423713207244873, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+38, 180472, 1, 1377, 3425, '0', 0, 0, -6886.4775390625, 732.58331298828125, 54.28470993041992187, 2.059488296508789062, 0, 0, 0.857167243957519531, 0.515038192272186279, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+39, 180472, 1, 1377, 3425, '0', 0, 0, -6876.86474609375, 713.35418701171875, 54.56313705444335937, 5.253442287445068359, 0, 0, -0.49242305755615234, 0.870355963706970214, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+40, 180472, 1, 1377, 3425, '0', 0, 0, -6883.94775390625, 743.28643798828125, 53.29156875610351562, 2.129300594329833984, 0, 0, 0.874619483947753906, 0.484810054302215576, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+41, 180523, 1, 1377, 3425, '0', 0, 0, -6863.6162109375, 725.828125, 46.06303787231445312, 3.996806621551513671, 0, 0, -0.90996074676513671, 0.414694398641586303, 120, 255, 1, 46366), -- Apple Bob (Area: Cenarion Hold - Difficulty: 0)
+(@OGUID+42, 190107, 1, 1377, 3425, '0', 0, 0, -6868.533203125, 732.15106201171875, 45.66207504272460937, 1.448621988296508789, 0, 0, 0.662619590759277343, 0.748956084251403808, 120, 255, 1, 46366); -- Candy Bucket (Area: Cenarion Hold - Difficulty: 0)
+
+-- Event spawns
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+42;
+INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES
+(12, @OGUID+0),
+(12, @OGUID+1),
+(12, @OGUID+2),
+(12, @OGUID+3),
+(12, @OGUID+4),
+(12, @OGUID+5),
+(12, @OGUID+6),
+(12, @OGUID+7),
+(12, @OGUID+8),
+(12, @OGUID+9),
+(12, @OGUID+10),
+(12, @OGUID+11),
+(12, @OGUID+12),
+(12, @OGUID+13),
+(12, @OGUID+14),
+(12, @OGUID+15),
+(12, @OGUID+16),
+(12, @OGUID+17),
+(12, @OGUID+18),
+(12, @OGUID+19),
+(12, @OGUID+20),
+(12, @OGUID+21),
+(12, @OGUID+22),
+(12, @OGUID+23),
+(12, @OGUID+24),
+(12, @OGUID+25),
+(12, @OGUID+26),
+(12, @OGUID+27),
+(12, @OGUID+28),
+(12, @OGUID+29),
+(12, @OGUID+30),
+(12, @OGUID+31),
+(12, @OGUID+32),
+(12, @OGUID+33),
+(12, @OGUID+34),
+(12, @OGUID+35),
+(12, @OGUID+36),
+(12, @OGUID+37),
+(12, @OGUID+38),
+(12, @OGUID+39),
+(12, @OGUID+40),
+(12, @OGUID+41),
+(12, @OGUID+42);