DB/Vashjir: Added Hallows End spawns

author: Meji <alvaro.megias@outlook.com> 2023-11-22 20:42:58 +0100
committer: Meji <alvaro.megias@outlook.com> 2023-11-22 20:42:58 +0100
commit: 1776e74ddb18e285b8ac55a7df0cbdc5a9f5d29f (patch)
tree: 184ede4776515826626b66cdfaf2fedbcf748e17
parent: be599c48ed891add91488a6bd6c26c2270f602a6 (diff)
6 files changed, 694 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_11_22_07_world_kelpthar_forest_deepmist_grotto.sql b/sql/updates/world/master/2023_11_22_07_world_kelpthar_forest_deepmist_grotto.sql
new file mode 100644
index 00000000000..c21bf7159cf
--- /dev/null
+++ b/sql/updates/world/master/2023_11_22_07_world_kelpthar_forest_deepmist_grotto.sql
@@ -0,0 +1,61 @@
+SET @OGUID := 3005998;
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=51886 WHERE `entry`=208141; -- Candy Bucket
+
+UPDATE `gameobject_template_addon` SET `faction`=35 WHERE `entry`=208141; -- Candy Bucket
+
+-- Quests
+DELETE FROM `quest_offer_reward` WHERE `ID`=28981;
+INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES
+(28981, 0, 0, 0, 0, 0, 0, 0, 0, 'Candy buckets like this are located in inns throughout the realms. Go ahead... take some!', 51886); -- Candy Bucket
+
+DELETE FROM `gameobject_queststarter` WHERE `id`=208141;
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(208141, 28981, 51886);
+
+UPDATE `gameobject_questender` SET `VerifiedBuild`=51886 WHERE (`id`=208141 AND `quest`=28981);
+
+DELETE FROM `game_event_gameobject_quest` WHERE `id`=208141;
+
+-- Old gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 231976 AND 231990;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 231976 AND 231990;
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+14;
+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, 0, 4815, 5058, '0', 0, 0, -5140.9755859375, 3301.190185546875, -118.638153076171875, 4.817109584808349609, 0, 0, -0.66913032531738281, 0.74314504861831665, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Deepmist Grotto - Difficulty: 0) CreateObject1
+(@OGUID+1, 180406, 0, 4815, 5058, '0', 0, 0, -5128.27587890625, 3276.7109375, -118.262252807617187, 4.328419685363769531, 0, 0, -0.82903671264648437, 0.559194147586822509, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Deepmist Grotto - Difficulty: 0) CreateObject1
+(@OGUID+2, 180407, 0, 4815, 5058, '0', 0, 0, -5154.8056640625, 3284.842041015625, -118.572822570800781, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Deepmist Grotto - Difficulty: 0) CreateObject1
+(@OGUID+3, 180411, 0, 4815, 5058, '0', 0, 0, -5144.44775390625, 3277.48779296875, -113.983566284179687, 4.206246376037597656, 0, 0, -0.86162853240966796, 0.50753939151763916, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Deepmist Grotto - Difficulty: 0) CreateObject1
+(@OGUID+4, 180415, 0, 4815, 5058, '0', 0, 0, -5142.25537109375, 3302.0009765625, -118.863853454589843, 1.85004889965057373, 0, 0, 0.798635482788085937, 0.60181504487991333, 120, 255, 1, 51886), -- CandleBlack01 (Area: Deepmist Grotto - Difficulty: 0) CreateObject1
+(@OGUID+5, 180415, 0, 4815, 5058, '0', 0, 0, -5142.52978515625, 3302.4140625, -118.856613159179687, 1.815141916275024414, 0, 0, 0.788010597229003906, 0.615661680698394775, 120, 255, 1, 51886), -- CandleBlack01 (Area: Deepmist Grotto - Difficulty: 0) CreateObject1
+(@OGUID+6, 180415, 0, 4815, 5058, '0', 0, 0, -5145.5400390625, 3289.786376953125, -117.817031860351562, 4.537858963012695312, 0, 0, -0.76604366302490234, 0.642788589000701904, 120, 255, 1, 51886), -- CandleBlack01 (Area: Deepmist Grotto - Difficulty: 0) CreateObject1
+(@OGUID+7, 180415, 0, 4815, 5058, '0', 0, 0, -5143.34716796875, 3289.389892578125, -111.512001037597656, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 120, 255, 1, 51886), -- CandleBlack01 (Area: Deepmist Grotto - Difficulty: 0) CreateObject1
+(@OGUID+8, 180415, 0, 4815, 5058, '0', 0, 0, -5142.04150390625, 3302.447998046875, -118.633956909179687, 1.884953022003173828, 0, 0, 0.809016227722167968, 0.587786316871643066, 120, 255, 1, 51886), -- CandleBlack01 (Area: Deepmist Grotto - Difficulty: 0) CreateObject1
+(@OGUID+9, 180415, 0, 4815, 5058, '0', 0, 0, -5141.125, 3290.96875, -115.1085205078125, 1.85004889965057373, 0, 0, 0.798635482788085937, 0.60181504487991333, 120, 255, 1, 51886), -- CandleBlack01 (Area: Deepmist Grotto - Difficulty: 0) CreateObject1
+(@OGUID+10, 180415, 0, 4815, 5058, '0', 0, 0, -5144.45166015625, 3290.58251953125, -117.813331604003906, 0.872663915157318115, 0, 0, 0.422617912292480468, 0.906307935714721679, 120, 255, 1, 51886), -- CandleBlack01 (Area: Deepmist Grotto - Difficulty: 0) CreateObject1
+(@OGUID+11, 180425, 0, 4815, 5058, '0', 0, 0, -5155.673828125, 3286.34033203125, -118.482032775878906, 1.553341388702392578, 0, 0, 0.700908660888671875, 0.713251054286956787, 120, 255, 1, 51886), -- SkullCandle01 (Area: Deepmist Grotto - Difficulty: 0) CreateObject1
+(@OGUID+12, 180523, 0, 4815, 5058, '0', 0, 0, -5145.40283203125, 3286.828125, -118.987159729003906, 3.52557229995727539, 0, 0, -0.98162651062011718, 0.190812408924102783, 120, 255, 1, 51886), -- Apple Bob (Area: Deepmist Grotto - Difficulty: 0) CreateObject1
+(@OGUID+13, 185437, 0, 4815, 5058, '0', 0, 0, -5140.75, 3300.479248046875, -118.887657165527343, 1.797688722610473632, 0, 0, 0.7826080322265625, 0.622514784336090087, 120, 255, 1, 51886), -- Laying Skeleton 01 (Area: Deepmist Grotto - Difficulty: 0) CreateObject1
+(@OGUID+14, 208141, 0, 4815, 5058, '0', 0, 0, -5143.12158203125, 3291.525146484375, -119.164093017578125, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 120, 255, 1, 51886); -- Candy Bucket (Area: Deepmist Grotto - Difficulty: 0) CreateObject1
+
+-- Event spawns
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+14;
+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);
diff --git a/sql/updates/world/master/2023_11_22_08_world_shimmering_expanse_silver_tide_hollow.sql b/sql/updates/world/master/2023_11_22_08_world_shimmering_expanse_silver_tide_hollow.sql
new file mode 100644
index 00000000000..f738d459553
--- /dev/null
+++ b/sql/updates/world/master/2023_11_22_08_world_shimmering_expanse_silver_tide_hollow.sql
@@ -0,0 +1,91 @@
+SET @OGUID := 3006013;
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=51886 WHERE `entry`=208142; -- Candy Bucket
+
+UPDATE `gameobject_template_addon` SET `faction`=35 WHERE `entry`=208142; -- Candy Bucket
+
+-- Quests
+DELETE FROM `quest_offer_reward` WHERE `ID`=28982;
+INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES
+(28982, 0, 0, 0, 0, 0, 0, 0, 0, 'Candy buckets like this are located in inns throughout the realms. Go ahead... take some!', 51886); -- Candy Bucket
+
+DELETE FROM `gameobject_queststarter` WHERE `id`=208142;
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(208142, 28982, 51886);
+
+UPDATE `gameobject_questender` SET `VerifiedBuild`=51886 WHERE (`id`=208142 AND `quest`=28982);
+
+DELETE FROM `game_event_gameobject_quest` WHERE `id`=208142;
+
+-- Old gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 231800 AND 231829;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 231800 AND 231829;
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+29;
+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, 180406, 0, 5144, 5005, '0', 0, 0, -6144.44091796875, 4290.32666015625, -347.984771728515625, 1.605701684951782226, 0, 0, 0.719339370727539062, 0.694658815860748291, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Silver Tide Hollow - Difficulty: 0) CreateObject1
+(@OGUID+1, 180407, 0, 5144, 5005, '0', 0, 0, -6138.8125, 4306.08837890625, -347.75445556640625, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Silver Tide Hollow - Difficulty: 0) CreateObject1
+(@OGUID+2, 180411, 0, 5144, 5005, '0', 0, 0, -6107.95849609375, 4300.85595703125, -346.072479248046875, 1.256635904312133789, 0, 0, 0.587784767150878906, 0.809017360210418701, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Silver Tide Hollow - Difficulty: 0) CreateObject1
+(@OGUID+3, 180415, 0, 5144, 5005, '0', 0, 0, -6145.1943359375, 4300.970703125, -344.564849853515625, 6.195919513702392578, 0, 0, -0.04361915588378906, 0.999048233032226562, 120, 255, 1, 51886), -- CandleBlack01 (Area: Silver Tide Hollow - Difficulty: 0) CreateObject1
+(@OGUID+4, 180415, 0, 5144, 5005, '0', 0, 0, -6143.15283203125, 4297.56005859375, -347.13958740234375, 0.15707901120185852, 0, 0, 0.078458786010742187, 0.996917366981506347, 120, 255, 1, 51886), -- CandleBlack01 (Area: Silver Tide Hollow - Difficulty: 0) CreateObject1
+(@OGUID+5, 180415, 0, 5144, 5005, '0', 0, 0, -6143.11279296875, 4297.22998046875, -347.1011962890625, 4.520402908325195312, 0, 0, -0.77162456512451171, 0.636078238487243652, 120, 255, 1, 51886), -- CandleBlack01 (Area: Silver Tide Hollow - Difficulty: 0) CreateObject1
+(@OGUID+6, 180415, 0, 5144, 5005, '0', 0, 0, -6104.96337890625, 4299.21728515625, -346.190338134765625, 4.101525306701660156, 0, 0, -0.88701057434082031, 0.461749136447906494, 120, 255, 1, 51886), -- CandleBlack01 (Area: Silver Tide Hollow - Difficulty: 0) CreateObject1
+(@OGUID+7, 180415, 0, 5144, 5005, '0', 0, 0, -6145.8818359375, 4293.13720703125, -345.156402587890625, 0.15707901120185852, 0, 0, 0.078458786010742187, 0.996917366981506347, 120, 255, 1, 51886), -- CandleBlack01 (Area: Silver Tide Hollow - Difficulty: 0) CreateObject1
+(@OGUID+8, 180415, 0, 5144, 5005, '0', 0, 0, -6106.67041015625, 4295.884765625, -348.025115966796875, 0.087265998125076293, 0, 0, 0.043619155883789062, 0.999048233032226562, 120, 255, 1, 51886), -- CandleBlack01 (Area: Silver Tide Hollow - Difficulty: 0) CreateObject1
+(@OGUID+9, 180415, 0, 5144, 5005, '0', 0, 0, -6104.8974609375, 4296.7568359375, -346.190338134765625, 3.403396368026733398, 0, 0, -0.99144458770751953, 0.130528271198272705, 120, 255, 1, 51886), -- CandleBlack01 (Area: Silver Tide Hollow - Difficulty: 0) CreateObject1
+(@OGUID+10, 180415, 0, 5144, 5005, '0', 0, 0, -6143.14599609375, 4301.703125, -342.964019775390625, 2.565631866455078125, 0, 0, 0.958819389343261718, 0.284016460180282592, 120, 255, 1, 51886), -- CandleBlack01 (Area: Silver Tide Hollow - Difficulty: 0) CreateObject1
+(@OGUID+11, 180415, 0, 5144, 5005, '0', 0, 0, -6144.8662109375, 4292.81689453125, -345.90850830078125, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 120, 255, 1, 51886), -- CandleBlack01 (Area: Silver Tide Hollow - Difficulty: 0) CreateObject1
+(@OGUID+12, 180415, 0, 5144, 5005, '0', 0, 0, -6101.0869140625, 4294.24560546875, -345.081085205078125, 3.717553615570068359, 0, 0, -0.95881938934326171, 0.284016460180282592, 120, 255, 1, 51886), -- CandleBlack01 (Area: Silver Tide Hollow - Difficulty: 0) CreateObject1
+(@OGUID+13, 180415, 0, 5144, 5005, '0', 0, 0, -6108.283203125, 4297.7099609375, -344.280670166015625, 3.665196180343627929, 0, 0, -0.96592521667480468, 0.258821308612823486, 120, 255, 1, 51886), -- CandleBlack01 (Area: Silver Tide Hollow - Difficulty: 0) CreateObject1
+(@OGUID+14, 180415, 0, 5144, 5005, '0', 0, 0, -6101.4150390625, 4293.20751953125, -346.654449462890625, 3.682650327682495117, 0, 0, -0.96362972259521484, 0.26724100112915039, 120, 255, 1, 51886), -- CandleBlack01 (Area: Silver Tide Hollow - Difficulty: 0) CreateObject1
+(@OGUID+15, 180415, 0, 5144, 5005, '0', 0, 0, -6146.1943359375, 4300.265625, -343.88470458984375, 6.12610626220703125, 0, 0, -0.07845878601074218, 0.996917366981506347, 120, 255, 1, 51886), -- CandleBlack01 (Area: Silver Tide Hollow - Difficulty: 0) CreateObject1
+(@OGUID+16, 180415, 0, 5144, 5005, '0', 0, 0, -6146.97900390625, 4291.50341796875, -344.685333251953125, 0.15707901120185852, 0, 0, 0.078458786010742187, 0.996917366981506347, 120, 255, 1, 51886), -- CandleBlack01 (Area: Silver Tide Hollow - Difficulty: 0) CreateObject1
+(@OGUID+17, 180415, 0, 5144, 5005, '0', 0, 0, -6140.13037109375, 4304.68310546875, -347.604339599609375, 0.959929943084716796, 0, 0, 0.461748123168945312, 0.887011110782623291, 120, 255, 1, 51886), -- CandleBlack01 (Area: Silver Tide Hollow - Difficulty: 0) CreateObject1
+(@OGUID+18, 180415, 0, 5144, 5005, '0', 0, 0, -6140.5068359375, 4310.53466796875, -345.58282470703125, 4.729844093322753906, 0, 0, -0.70090866088867187, 0.713251054286956787, 120, 255, 1, 51886), -- CandleBlack01 (Area: Silver Tide Hollow - Difficulty: 0) CreateObject1
+(@OGUID+19, 180415, 0, 5144, 5005, '0', 0, 0, -6107.2900390625, 4297.236328125, -345.842681884765625, 3.281238555908203125, 0, 0, -0.99756336212158203, 0.069766148924827575, 120, 255, 1, 51886), -- CandleBlack01 (Area: Silver Tide Hollow - Difficulty: 0) CreateObject1
+(@OGUID+20, 180415, 0, 5144, 5005, '0', 0, 0, -6142.33349609375, 4301.017578125, -344.49517822265625, 1.343901276588439941, 0, 0, 0.622513771057128906, 0.78260880708694458, 120, 255, 1, 51886), -- CandleBlack01 (Area: Silver Tide Hollow - Difficulty: 0) CreateObject1
+(@OGUID+21, 180415, 0, 5144, 5005, '0', 0, 0, -6103.9931640625, 4296.009765625, -346.61578369140625, 3.717553615570068359, 0, 0, -0.95881938934326171, 0.284016460180282592, 120, 255, 1, 51886), -- CandleBlack01 (Area: Silver Tide Hollow - Difficulty: 0) CreateObject1
+(@OGUID+22, 180415, 0, 5144, 5005, '0', 0, 0, -6106.53466796875, 4299.64599609375, -346.190338134765625, 4.48549652099609375, 0, 0, -0.7826080322265625, 0.622514784336090087, 120, 255, 1, 51886), -- CandleBlack01 (Area: Silver Tide Hollow - Difficulty: 0) CreateObject1
+(@OGUID+23, 180415, 0, 5144, 5005, '0', 0, 0, -6139.6181640625, 4311.69091796875, -344.61572265625, 2.478367090225219726, 0, 0, 0.94551849365234375, 0.325568377971649169, 120, 255, 1, 51886), -- CandleBlack01 (Area: Silver Tide Hollow - Difficulty: 0) CreateObject1
+(@OGUID+24, 180415, 0, 5144, 5005, '0', 0, 0, -6102.23779296875, 4296.8212890625, -346.190338134765625, 2.303830623626708984, 0, 0, 0.913544654846191406, 0.406738430261611938, 120, 255, 1, 51886), -- CandleBlack01 (Area: Silver Tide Hollow - Difficulty: 0) CreateObject1
+(@OGUID+25, 180415, 0, 5144, 5005, '0', 0, 0, -6145.7412109375, 4290.7578125, -343.474945068359375, 1.989672422409057617, 0, 0, 0.838669776916503906, 0.544640243053436279, 120, 255, 1, 51886), -- CandleBlack01 (Area: Silver Tide Hollow - Difficulty: 0) CreateObject1
+(@OGUID+26, 180425, 0, 5144, 5005, '0', 0, 0, -6105.22412109375, 4293.994140625, -348.282012939453125, 3.961898565292358398, 0, 0, -0.91705989837646484, 0.398749500513076782, 120, 255, 1, 51886), -- SkullCandle01 (Area: Silver Tide Hollow - Difficulty: 0) CreateObject1
+(@OGUID+27, 180523, 0, 5144, 5005, '0', 0, 0, -6116.1650390625, 4298.72412109375, -348.054351806640625, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Apple Bob (Area: Silver Tide Hollow - Difficulty: 0) CreateObject1
+(@OGUID+28, 208078, 0, 5144, 5005, '0', 0, 0, -6108.40087890625, 4296.0927734375, -346.877838134765625, 0.034906249493360519, 0, 0, 0.017452239990234375, 0.999847710132598876, 120, 255, 1, 51886), -- G_Pumpkin_01 scale 0.5 (Area: Silver Tide Hollow - Difficulty: 0) CreateObject1
+(@OGUID+29, 208142, 0, 5144, 5005, '0', 0, 0, -6110.24853515625, 4295.8662109375, -348.335113525390625, 5.724681377410888671, 0, 0, -0.27563667297363281, 0.961261868476867675, 120, 255, 1, 51886); -- Candy Bucket (Area: Silver Tide Hollow - Difficulty: 0) CreateObject1
+
+-- Event spawns
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+29;
+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);
diff --git a/sql/updates/world/master/2023_11_22_09_world_shimmering_expanse_legions_rest.sql b/sql/updates/world/master/2023_11_22_09_world_shimmering_expanse_legions_rest.sql
new file mode 100644
index 00000000000..8be88f5a4ba
--- /dev/null
+++ b/sql/updates/world/master/2023_11_22_09_world_shimmering_expanse_legions_rest.sql
@@ -0,0 +1,141 @@
+SET @OGUID := 3006043;
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=51886 WHERE `entry`=208154; -- Candy Bucket
+
+UPDATE `gameobject_template_addon` SET `faction`=1735 WHERE `entry`=208154; -- Candy Bucket
+
+-- Quests
+DELETE FROM `quest_offer_reward` WHERE `ID`=28984;
+INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES
+(28984, 0, 0, 0, 0, 0, 0, 0, 0, 'Candy buckets like this are located in inns throughout the realms. Go ahead... take some!', 51886); -- Candy Bucket
+
+DELETE FROM `gameobject_queststarter` WHERE `id`=208154;
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(208154, 28984, 51886);
+
+UPDATE `gameobject_questender` SET `VerifiedBuild`=51886 WHERE (`id`=208154 AND `quest`=28984);
+
+DELETE FROM `game_event_gameobject_quest` WHERE `id`=208154;
+
+-- Old gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 231868 AND 231922;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 231868 AND 231922;
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+54;
+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, 0, 5144, 4970, '0', 0, 0, -6766.76416015625, 4187.67724609375, -478.58978271484375, 4.834563255310058593, 0, 0, -0.66261959075927734, 0.748956084251403808, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+1, 180406, 0, 5144, 4970, '0', 0, 0, -6795.21875, 4193.59912109375, -478.2265625, 2.932138919830322265, 0, 0, 0.994521141052246093, 0.104535527527332305, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+2, 180407, 0, 5144, 4970, '0', 0, 0, -6781.34375, 4210.0791015625, -479.217193603515625, 4.764749526977539062, 0, 0, -0.6883544921875, 0.725374460220336914, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+3, 180408, 0, 5144, 4970, '0', 0, 0, -6766.82666015625, 4187.73095703125, -476.982818603515625, 4.48549652099609375, 0, 0, -0.7826080322265625, 0.622514784336090087, 120, 255, 1, 51886), -- G_WitchHat_01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+4, 180411, 0, 5144, 4970, '0', 0, 0, -6806.31787109375, 4220.09228515625, -479.48443603515625, 2.44346022605895996, 0, 0, 0.939692497253417968, 0.34202045202255249, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+5, 180415, 0, 5144, 4970, '0', 0, 0, -6797.439453125, 4193.55908203125, -475.8536376953125, 1.361356139183044433, 0, 0, 0.629320144653320312, 0.77714616060256958, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+6, 180415, 0, 5144, 4970, '0', 0, 0, -6790.939453125, 4185.89599609375, -478.103851318359375, 0.715584874153137207, 0, 0, 0.350207328796386718, 0.936672210693359375, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+7, 180415, 0, 5144, 4970, '0', 0, 0, -6799.87353515625, 4192.88916015625, -477.78662109375, 3.874631166458129882, 0, 0, -0.93358039855957031, 0.358368009328842163, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+8, 180415, 0, 5144, 4970, '0', 0, 0, -6801.98974609375, 4197.60693359375, -477.726287841796875, 1.396261811256408691, 0, 0, 0.642786979675292968, 0.766044974327087402, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+9, 180415, 0, 5144, 4970, '0', 0, 0, -6797.98095703125, 4194.548828125, -477.44146728515625, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+10, 180415, 0, 5144, 4970, '0', 0, 0, -6786.9375, 4200.91845703125, -479.2984619140625, 1.954769015312194824, 0, 0, 0.829037666320800781, 0.559192776679992675, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+11, 180415, 0, 5144, 4970, '0', 0, 0, -6784.9755859375, 4197.6171875, -479.575469970703125, 0.261798173189163208, 0, 0, 0.130525588989257812, 0.991444945335388183, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+12, 180415, 0, 5144, 4970, '0', 0, 0, -6786.05224609375, 4199.6083984375, -473.149749755859375, 2.373644113540649414, 0, 0, 0.927183151245117187, 0.37460830807685852, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+13, 180415, 0, 5144, 4970, '0', 0, 0, -6788.16845703125, 4200.22412109375, -479.383514404296875, 1.85004889965057373, 0, 0, 0.798635482788085937, 0.60181504487991333, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+14, 180415, 0, 5144, 4970, '0', 0, 0, -6802.28125, 4196.5390625, -476.1734619140625, 2.111847877502441406, 0, 0, 0.870355606079101562, 0.492423713207244873, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+15, 180415, 0, 5144, 4970, '0', 0, 0, -6800.75, 4201.0869140625, -478.20953369140625, 2.007128477096557617, 0, 0, 0.84339141845703125, 0.537299633026123046, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+16, 180415, 0, 5144, 4970, '0', 0, 0, -6799.72900390625, 4196.16064453125, -477.684356689453125, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+17, 180415, 0, 5144, 4970, '0', 0, 0, -6800.24462890625, 4197.4619140625, -477.951019287109375, 1.605701684951782226, 0, 0, 0.719339370727539062, 0.694658815860748291, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+18, 180415, 0, 5144, 4970, '0', 0, 0, -6786.31591796875, 4197.21630859375, -479.6787109375, 5.93412017822265625, 0, 0, -0.17364788055419921, 0.984807789325714111, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+19, 180415, 0, 5144, 4970, '0', 0, 0, -6790.2744140625, 4187.0791015625, -478.0460205078125, 0.820303261280059814, 0, 0, 0.398748397827148437, 0.917060375213623046, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+20, 180415, 0, 5144, 4970, '0', 0, 0, -6801.611328125, 4200.3896484375, -476.683502197265625, 1.710421562194824218, 0, 0, 0.754709243774414062, 0.656059443950653076, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+21, 180415, 0, 5144, 4970, '0', 0, 0, -6790.05712890625, 4189.49658203125, -477.702789306640625, 4.206246376037597656, 0, 0, -0.86162853240966796, 0.50753939151763916, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+22, 180415, 0, 5144, 4970, '0', 0, 0, -6789.59375, 4190.509765625, -476.149688720703125, 0.698131442070007324, 0, 0, 0.342020034790039062, 0.939692676067352294, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+23, 180415, 0, 5144, 4970, '0', 0, 0, -6801.06103515625, 4194.11474609375, -477.68603515625, 1.902408957481384277, 0, 0, 0.814115524291992187, 0.580702960491180419, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+24, 180415, 0, 5144, 4970, '0', 0, 0, -6772.658203125, 4182.861328125, -477.896148681640625, 1.762782454490661621, 0, 0, 0.771624565124511718, 0.636078238487243652, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+25, 180415, 0, 5144, 4970, '0', 0, 0, -6770.484375, 4207.38037109375, -477.3897705078125, 1.361356139183044433, 0, 0, 0.629320144653320312, 0.77714616060256958, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+26, 180415, 0, 5144, 4970, '0', 0, 0, -6772.13720703125, 4181.89599609375, -476.476226806640625, 1.151916384696960449, 0, 0, 0.544638633728027343, 0.838670849800109863, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+27, 180415, 0, 5144, 4970, '0', 0, 0, -6773.41845703125, 4204.85791015625, -478.119293212890625, 1.221729278564453125, 0, 0, 0.573575973510742187, 0.819152355194091796, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+28, 180415, 0, 5144, 4970, '0', 0, 0, -6778.27978515625, 4212.7197265625, -477.827911376953125, 1.85004889965057373, 0, 0, 0.798635482788085937, 0.60181504487991333, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+29, 180415, 0, 5144, 4970, '0', 0, 0, -6781.640625, 4212.92431640625, -476.98583984375, 1.500982880592346191, 0, 0, 0.681998252868652343, 0.731353819370269775, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+30, 180415, 0, 5144, 4970, '0', 0, 0, -6773.65478515625, 4206.1953125, -478.12548828125, 1.169368624687194824, 0, 0, 0.551936149597167968, 0.833886384963989257, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+31, 180415, 0, 5144, 4970, '0', 0, 0, -6787.533203125, 4188.96533203125, -477.977935791015625, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+32, 180415, 0, 5144, 4970, '0', 0, 0, -6789.96875, 4184.38525390625, -477.929962158203125, 0.802850961685180664, 0, 0, 0.390730857849121093, 0.920504987239837646, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+33, 180415, 0, 5144, 4970, '0', 0, 0, -6769.7880859375, 4206.484375, -475.877166748046875, 1.937312245368957519, 0, 0, 0.824125289916992187, 0.566407561302185058, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+34, 180415, 0, 5144, 4970, '0', 0, 0, -6771.17529296875, 4183.84912109375, -478.125213623046875, 1.361356139183044433, 0, 0, 0.629320144653320312, 0.77714616060256958, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+35, 180415, 0, 5144, 4970, '0', 0, 0, -6783.6025390625, 4200.6787109375, -476.353912353515625, 1.361356139183044433, 0, 0, 0.629320144653320312, 0.77714616060256958, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+36, 180415, 0, 5144, 4970, '0', 0, 0, -6777.94091796875, 4214.07666015625, -477.865936279296875, 1.675513744354248046, 0, 0, 0.743144035339355468, 0.669131457805633544, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+37, 180415, 0, 5144, 4970, '0', 0, 0, -6787.783203125, 4187.29248046875, -478.040374755859375, 5.777040958404541015, 0, 0, -0.25037956237792968, 0.968147754669189453, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+38, 180415, 0, 5144, 4970, '0', 0, 0, -6781.90625, 4214.0634765625, -475.571197509765625, 1.919861555099487304, 0, 0, 0.819151878356933593, 0.573576688766479492, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+39, 180415, 0, 5144, 4970, '0', 0, 0, -6788.96875, 4184.83349609375, -476.36468505859375, 0.401424884796142578, 0, 0, 0.199367523193359375, 0.979924798011779785, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+40, 180415, 0, 5144, 4970, '0', 0, 0, -6770.408203125, 4172.5166015625, -476.14544677734375, 0.925023794174194335, 0, 0, 0.446197509765625, 0.894934535026550292, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+41, 180415, 0, 5144, 4970, '0', 0, 0, -6761.3681640625, 4178.0791015625, -476.235198974609375, 1.099556446075439453, 0, 0, 0.522498130798339843, 0.852640450000762939, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+42, 180415, 0, 5144, 4970, '0', 0, 0, -6769.99462890625, 4183.17431640625, -478.0299072265625, 2.181660413742065429, 0, 0, 0.887010574340820312, 0.461749136447906494, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+43, 180415, 0, 5144, 4970, '0', 0, 0, -6763.1650390625, 4177.21337890625, -476.58990478515625, 0.558503925800323486, 0, 0, 0.275636672973632812, 0.961261868476867675, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+44, 180415, 0, 5144, 4970, '0', 0, 0, -6777.44287109375, 4165.9697265625, -476.377593994140625, 1.134462952613830566, 0, 0, 0.537299156188964843, 0.843391716480255126, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+45, 180415, 0, 5144, 4970, '0', 0, 0, -6763.939453125, 4178.14306640625, -477.42584228515625, 0.890116631984710693, 0, 0, 0.430510520935058593, 0.902585566043853759, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+46, 180415, 0, 5144, 4970, '0', 0, 0, -6767.9755859375, 4171.046875, -476.08599853515625, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+47, 180415, 0, 5144, 4970, '0', 0, 0, -6762.05712890625, 4179.36376953125, -475.001800537109375, 1.151916384696960449, 0, 0, 0.544638633728027343, 0.838670849800109863, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+48, 180415, 0, 5144, 4970, '0', 0, 0, -6770.1474609375, 4171.51025390625, -474.396636962890625, 1.361356139183044433, 0, 0, 0.629320144653320312, 0.77714616060256958, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+49, 180415, 0, 5144, 4970, '0', 0, 0, -6766.77783203125, 4171.0712890625, -475.462188720703125, 1.361356139183044433, 0, 0, 0.629320144653320312, 0.77714616060256958, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+50, 180415, 0, 5144, 4970, '0', 0, 0, -6778.7587890625, 4165.48974609375, -475.193145751953125, 1.745326757431030273, 0, 0, 0.766043663024902343, 0.642788589000701904, 120, 255, 1, 51886), -- CandleBlack01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+51, 180425, 0, 5144, 4970, '0', 0, 0, -6795.1025390625, 4199.18994140625, -479.449981689453125, 0.453785061836242675, 0, 0, 0.224950790405273437, 0.974370121955871582, 120, 255, 1, 51886), -- SkullCandle01 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+52, 180523, 0, 5144, 4970, '0', 0, 0, -6774.9150390625, 4172.43994140625, -479.581756591796875, 5.742135047912597656, 0, 0, -0.26723766326904296, 0.96363067626953125, 120, 255, 1, 51886), -- Apple Bob (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+53, 208069, 0, 5144, 4970, '0', 0, 0, -6778.54150390625, 4169.9052734375, -479.773773193359375, 3.508116960525512695, 0, 0, -0.98325443267822265, 0.182238012552261352, 120, 255, 1, 51886), -- G_Pumpkin_02 Scale 0.5 (Area: Legion's Rest - Difficulty: 0) CreateObject1
+(@OGUID+54, 208154, 0, 5144, 4970, '0', 0, 0, -6773.4931640625, 4184.2724609375, -479.865447998046875, 4.049167633056640625, 0, 0, -0.89879322052001953, 0.438372820615768432, 120, 255, 1, 51886); -- Candy Bucket (Area: Legion's Rest - Difficulty: 0) CreateObject1
+
+-- Event spawns
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+54;
+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),
+(12, @OGUID+43),
+(12, @OGUID+44),
+(12, @OGUID+45),
+(12, @OGUID+46),
+(12, @OGUID+47),
+(12, @OGUID+48),
+(12, @OGUID+49),
+(12, @OGUID+50),
+(12, @OGUID+51),
+(12, @OGUID+52),
+(12, @OGUID+53),
+(12, @OGUID+54);
diff --git a/sql/updates/world/master/2023_11_22_10_world_shimmering_expanse_tranquil_wash.sql b/sql/updates/world/master/2023_11_22_10_world_shimmering_expanse_tranquil_wash.sql
new file mode 100644
index 00000000000..d2fce5185ac
--- /dev/null
+++ b/sql/updates/world/master/2023_11_22_10_world_shimmering_expanse_tranquil_wash.sql
@@ -0,0 +1,109 @@
+SET @OGUID := 3006098;
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=51886 WHERE `entry`=208133; -- Candy Bucket
+
+UPDATE `gameobject_template_addon` SET `faction`=1732 WHERE `entry`=208133; -- Candy Bucket
+
+-- Quests
+UPDATE `quest_template` SET `Expansion`=9, `VerifiedBuild`=51886 WHERE `ID`=28983; -- Candy Bucket
+
+DELETE FROM `quest_offer_reward` WHERE `ID`=28983;
+INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES
+(28983, 0, 0, 0, 0, 0, 0, 0, 0, 'Candy buckets like this are located in inns throughout the realms. Go ahead... take some!', 51886); -- Candy Bucket
+
+DELETE FROM `gameobject_queststarter` WHERE `id`=208133;
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(208133, 28983, 51886);
+
+UPDATE `gameobject_questender` SET `VerifiedBuild`=51886 WHERE (`id`=208133 AND `quest`=28983);
+
+DELETE FROM `game_event_gameobject_quest` WHERE `id`=208133;
+
+-- Old gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 231830 AND 231867;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 231830 AND 231867;
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+37;
+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, 0, 5144, 4969, '0', 0, 0, -6619.2431640625, 4295.06591796875, -562.93927001953125, 1.762782454490661621, 0, 0, 0.771624565124511718, 0.636078238487243652, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+1, 180406, 0, 5144, 4969, '0', 0, 0, -6620.171875, 4274.6953125, -563.09600830078125, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+2, 180407, 0, 5144, 4969, '0', 0, 0, -6591.96728515625, 4294.52099609375, -562.802734375, 5.567600727081298828, 0, 0, -0.35020732879638671, 0.936672210693359375, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+3, 180411, 0, 5144, 4969, '0', 0, 0, -6599.01025390625, 4268.10400390625, -559.11181640625, 4.852017402648925781, 0, 0, -0.65605831146240234, 0.754710197448730468, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+4, 180411, 0, 5144, 4969, '0', 0, 0, -6607.923828125, 4330.24658203125, -507.861602783203125, 3.665196180343627929, 0, 0, -0.96592521667480468, 0.258821308612823486, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+5, 180414, 0, 5144, 4969, '0', 0, 0, -6614.52978515625, 4270.01220703125, -563.0760498046875, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Cauldron (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+6, 180415, 0, 5144, 4969, '0', 0, 0, -6623.22900390625, 4300.8046875, -560.7392578125, 5.218535900115966796, 0, 0, -0.507537841796875, 0.861629426479339599, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+7, 180415, 0, 5144, 4969, '0', 0, 0, -6620.58154296875, 4303.12353515625, -560.88092041015625, 0.349065244197845458, 0, 0, 0.173647880554199218, 0.984807789325714111, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+8, 180415, 0, 5144, 4969, '0', 0, 0, -6622.7900390625, 4303.46630859375, -559.10736083984375, 5.218535900115966796, 0, 0, -0.507537841796875, 0.861629426479339599, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+9, 180415, 0, 5144, 4969, '0', 0, 0, -6620.96337890625, 4301.79443359375, -560.7564697265625, 5.89921426773071289, 0, 0, -0.19080829620361328, 0.981627285480499267, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+10, 180415, 0, 5144, 4969, '0', 0, 0, -6620.080078125, 4306.29541015625, -559.6754150390625, 2.042035102844238281, 0, 0, 0.852640151977539062, 0.522498607635498046, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+11, 180415, 0, 5144, 4969, '0', 0, 0, -6596.16845703125, 4306.81005859375, -558.45343017578125, 1.378809213638305664, 0, 0, 0.636077880859375, 0.771624863147735595, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+12, 180415, 0, 5144, 4969, '0', 0, 0, -6620.43408203125, 4298.3681640625, -558.839111328125, 4.817109584808349609, 0, 0, -0.66913032531738281, 0.74314504861831665, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+13, 180415, 0, 5144, 4969, '0', 0, 0, -6622.921875, 4299.140625, -560.642578125, 5.218535900115966796, 0, 0, -0.507537841796875, 0.861629426479339599, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+14, 180415, 0, 5144, 4969, '0', 0, 0, -6622.03466796875, 4304.24658203125, -560.60321044921875, 2.495818138122558593, 0, 0, 0.948323249816894531, 0.317305892705917358, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+15, 180415, 0, 5144, 4969, '0', 0, 0, -6595.3125, 4298.4619140625, -561.453125, 6.03883981704711914, 0, 0, -0.12186908721923828, 0.9925462007522583, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+16, 180415, 0, 5144, 4969, '0', 0, 0, -6595.27099609375, 4298.2119140625, -561.56134033203125, 0.349065244197845458, 0, 0, 0.173647880554199218, 0.984807789325714111, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+17, 180415, 0, 5144, 4969, '0', 0, 0, -6619.08349609375, 4306.45849609375, -561.12225341796875, 1.937312245368957519, 0, 0, 0.824125289916992187, 0.566407561302185058, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+18, 180415, 0, 5144, 4969, '0', 0, 0, -6593.90625, 4303.5244140625, -560.73883056640625, 0.349065244197845458, 0, 0, 0.173647880554199218, 0.984807789325714111, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+19, 180415, 0, 5144, 4969, '0', 0, 0, -6620.33349609375, 4299.42529296875, -560.41162109375, 4.817109584808349609, 0, 0, -0.66913032531738281, 0.74314504861831665, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+20, 180415, 0, 5144, 4969, '0', 0, 0, -6596.595703125, 4305.783203125, -559.9893798828125, 6.056293010711669921, 0, 0, -0.11320304870605468, 0.993571877479553222, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+21, 180415, 0, 5144, 4969, '0', 0, 0, -6601.33837890625, 4266.8056640625, -560.396484375, 5.777040958404541015, 0, 0, -0.25037956237792968, 0.968147754669189453, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+22, 180415, 0, 5144, 4969, '0', 0, 0, -6616.6650390625, 4272.68994140625, -561.654541015625, 4.782202720642089843, 0, 0, -0.68199825286865234, 0.731353819370269775, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+23, 180415, 0, 5144, 4969, '0', 0, 0, -6609.88037109375, 4265.8056640625, -559.00201416015625, 4.101525306701660156, 0, 0, -0.88701057434082031, 0.461749136447906494, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+24, 180415, 0, 5144, 4969, '0', 0, 0, -6606.23095703125, 4266.69287109375, -561.5162353515625, 3.420850038528442382, 0, 0, -0.99026775360107421, 0.139175355434417724, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+25, 180415, 0, 5144, 4969, '0', 0, 0, -6592.8193359375, 4304.49462890625, -560.7247314453125, 2.216565132141113281, 0, 0, 0.894933700561523437, 0.44619917869567871, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+26, 180415, 0, 5144, 4969, '0', 0, 0, -6610.1806640625, 4264.783203125, -557.5001220703125, 5.113816738128662109, 0, 0, -0.55193614959716796, 0.833886384963989257, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+27, 180415, 0, 5144, 4969, '0', 0, 0, -6599.328125, 4265.33154296875, -559.1348876953125, 4.380776405334472656, 0, 0, -0.81411552429199218, 0.580702960491180419, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+28, 180415, 0, 5144, 4969, '0', 0, 0, -6599.13525390625, 4266.77685546875, -557.92669677734375, 5.410521507263183593, 0, 0, -0.42261791229248046, 0.906307935714721679, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+29, 180415, 0, 5144, 4969, '0', 0, 0, -6607.6806640625, 4262.56005859375, -558.48443603515625, 5.445427894592285156, 0, 0, -0.40673637390136718, 0.913545548915863037, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+30, 180415, 0, 5144, 4969, '0', 0, 0, -6601.25341796875, 4265.6884765625, -559.55621337890625, 4.206246376037597656, 0, 0, -0.86162853240966796, 0.50753939151763916, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+31, 180415, 0, 5144, 4969, '0', 0, 0, -6608.78466796875, 4263.26318359375, -559.04827880859375, 4.817109584808349609, 0, 0, -0.66913032531738281, 0.74314504861831665, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+32, 180425, 0, 5144, 4969, '0', 0, 0, -6598.58349609375, 4298.5693359375, -561.74395751953125, 4.468043327331542968, 0, 0, -0.7880105972290039, 0.615661680698394775, 120, 255, 1, 51886), -- SkullCandle01 (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+33, 180425, 0, 5144, 4969, '0', 0, 0, -6617.9599609375, 4273.48779296875, -562.1207275390625, 0.994837164878845214, 0, 0, 0.477158546447753906, 0.878817260265350341, 120, 255, 1, 51886), -- SkullCandle01 (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+34, 180523, 0, 5144, 4969, '0', 0, 0, -6608.58154296875, 4268.98779296875, -562.1094970703125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Apple Bob (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+35, 185436, 0, 5144, 4969, '0', 0, 0, -6614.57275390625, 4269.75537109375, -562.52203369140625, 1.169368624687194824, 0, 0, 0.551936149597167968, 0.833886384963989257, 120, 255, 1, 51886), -- Sitting Skeleton 03 (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+36, 208078, 0, 5144, 4969, '0', 0, 0, -6591.79150390625, 4270.40478515625, -562.73712158203125, 4.031712055206298828, 0, 0, -0.90258502960205078, 0.430511653423309326, 120, 255, 1, 51886), -- G_Pumpkin_01 scale 0.5 (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+(@OGUID+37, 208133, 0, 5144, 4969, '0', 0, 0, -6611.76220703125, 4269.68310546875, -562.73992919921875, 2.44346022605895996, 0, 0, 0.939692497253417968, 0.34202045202255249, 120, 255, 1, 51886); -- Candy Bucket (Area: Tranquil Wash - Difficulty: 0) CreateObject1
+
+-- Event spawns
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+37;
+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);
diff --git a/sql/updates/world/master/2023_11_22_11_world_abyssal_depths_tenebrous_cavern.sql b/sql/updates/world/master/2023_11_22_11_world_abyssal_depths_tenebrous_cavern.sql
new file mode 100644
index 00000000000..02428b4dd7e
--- /dev/null
+++ b/sql/updates/world/master/2023_11_22_11_world_abyssal_depths_tenebrous_cavern.sql
@@ -0,0 +1,139 @@
+SET @OGUID := 3006136;
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `Data6`=0, `ContentTuningId`=425, `VerifiedBuild`=51886 WHERE `entry`=208155; -- Candy Bucket
+
+UPDATE `gameobject_template_addon` SET `faction`=1735 WHERE `entry`=208155; -- Candy Bucket
+
+-- Quests
+DELETE FROM `quest_offer_reward` WHERE `ID`=28986;
+INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES
+(28986, 0, 0, 0, 0, 0, 0, 0, 0, 'Candy buckets like this are located in inns throughout the realms. Go ahead... take some!', 51886); -- Candy Bucket
+
+DELETE FROM `gameobject_queststarter` WHERE `id`=208155;
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(208155, 28986, 51886);
+
+UPDATE `gameobject_questender` SET `VerifiedBuild`=51886 WHERE (`id`=208155 AND `quest`=28986);
+
+DELETE FROM `game_event_gameobject_quest` WHERE `id`=208155;
+
+-- Old gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 231923 AND 231975;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 231923 AND 231975;
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+53;
+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, 0, 5145, 4975, '0', 0, 0, -6537.3681640625, 6138.8603515625, -664.37237548828125, 5.619962215423583984, 0, 0, -0.32556724548339843, 0.945518851280212402, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+1, 180406, 0, 5145, 4975, '0', 0, 0, -6528.1181640625, 6122.91748046875, -669.38629150390625, 5.881760597229003906, 0, 0, -0.19936752319335937, 0.979924798011779785, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+2, 180407, 0, 5145, 4975, '0', 0, 0, -6522.07275390625, 6112.830078125, -669.76763916015625, 5.515241622924804687, 0, 0, -0.37460613250732421, 0.927184045314788818, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+3, 180407, 0, 5145, 4975, '0', 0, 0, -6555.9912109375, 6149.58935546875, -669.9681396484375, 5.742135047912597656, 0, 0, -0.26723766326904296, 0.96363067626953125, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+4, 180414, 0, 5145, 4975, '0', 0, 0, -6516.93212890625, 6108.38720703125, -671.24530029296875, 0.296705186367034912, 0, 0, 0.147809028625488281, 0.989015936851501464, 120, 255, 1, 51886), -- Cauldron (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+5, 180415, 0, 5145, 4975, '0', 0, 0, -6498.126953125, 6078.650390625, -659.81494140625, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+6, 180415, 0, 5145, 4975, '0', 0, 0, -6507.09716796875, 6100.77587890625, -664.7452392578125, 1.239183306694030761, 0, 0, 0.580702781677246093, 0.814115643501281738, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+7, 180415, 0, 5145, 4975, '0', 0, 0, -6494.5869140625, 6074.15087890625, -664.43487548828125, 0.087265998125076293, 0, 0, 0.043619155883789062, 0.999048233032226562, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+8, 180415, 0, 5145, 4975, '0', 0, 0, -6492.94287109375, 6071.703125, -664.59820556640625, 1.047197580337524414, 0, 0, 0.5, 0.866025388240814208, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+9, 180415, 0, 5145, 4975, '0', 0, 0, -6495.767578125, 6078.3681640625, -663.119384765625, 1.029743075370788574, 0, 0, 0.492423057556152343, 0.870355963706970214, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+10, 180415, 0, 5145, 4975, '0', 0, 0, -6503.40625, 6100.7734375, -664.12646484375, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+11, 180415, 0, 5145, 4975, '0', 0, 0, -6532.47900390625, 6130.9453125, -665.811767578125, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+12, 180415, 0, 5145, 4975, '0', 0, 0, -6529.408203125, 6131.62939453125, -661.8270263671875, 4.468043327331542968, 0, 0, -0.7880105972290039, 0.615661680698394775, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+13, 180415, 0, 5145, 4975, '0', 0, 0, -6529.5380859375, 6131.96875, -661.721923828125, 0.593410074710845947, 0, 0, 0.292370796203613281, 0.95630502700805664, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+14, 180415, 0, 5145, 4975, '0', 0, 0, -6529.6962890625, 6132.66162109375, -661.9068603515625, 4.014260292053222656, 0, 0, -0.90630722045898437, 0.422619491815567016, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+15, 180415, 0, 5145, 4975, '0', 0, 0, -6538.02587890625, 6141.44775390625, -662.50518798828125, 0.401424884796142578, 0, 0, 0.199367523193359375, 0.979924798011779785, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+16, 180415, 0, 5145, 4975, '0', 0, 0, -6537.88720703125, 6141.11962890625, -662.64923095703125, 5.131268978118896484, 0, 0, -0.54463863372802734, 0.838670849800109863, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+17, 180415, 0, 5145, 4975, '0', 0, 0, -6534.35400390625, 6137.9521484375, -663.92254638671875, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+18, 180415, 0, 5145, 4975, '0', 0, 0, -6533.908203125, 6137.609375, -663.73126220703125, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+19, 180415, 0, 5145, 4975, '0', 0, 0, -6533.955078125, 6138.5, -663.60986328125, 4.276057243347167968, 0, 0, -0.84339141845703125, 0.537299633026123046, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+20, 180415, 0, 5145, 4975, '0', 0, 0, -6550.52099609375, 6161.72119140625, -663.31768798828125, 0.314158439636230468, 0, 0, 0.156434059143066406, 0.987688362598419189, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+21, 180415, 0, 5145, 4975, '0', 0, 0, -6553.23974609375, 6164.2734375, -658.9351806640625, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+22, 180415, 0, 5145, 4975, '0', 0, 0, -6553.3505859375, 6160.984375, -663.11309814453125, 5.113816738128662109, 0, 0, -0.55193614959716796, 0.833886384963989257, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+23, 180415, 0, 5145, 4975, '0', 0, 0, -6565.18603515625, 6167.91650390625, -661.31365966796875, 0.802850961685180664, 0, 0, 0.390730857849121093, 0.920504987239837646, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+24, 180415, 0, 5145, 4975, '0', 0, 0, -6585.58154296875, 6147.17529296875, -662.13604736328125, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+25, 180415, 0, 5145, 4975, '0', 0, 0, -6564.986328125, 6166.55810546875, -665.005126953125, 1.867502212524414062, 0, 0, 0.803856849670410156, 0.594822824001312255, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+26, 180415, 0, 5145, 4975, '0', 0, 0, -6563.455078125, 6167.7880859375, -662.96044921875, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+27, 180415, 0, 5145, 4975, '0', 0, 0, -6586.6787109375, 6149.72216796875, -665.13165283203125, 0.907570242881774902, 0, 0, 0.438370704650878906, 0.898794233798980712, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+28, 180415, 0, 5145, 4975, '0', 0, 0, -6584.73974609375, 6156.0859375, -665.5667724609375, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+29, 180415, 0, 5145, 4975, '0', 0, 0, -6587.04150390625, 6154.1162109375, -665.72259521484375, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+30, 180415, 0, 5145, 4975, '0', 0, 0, -6599.16162109375, 6177.1552734375, -665.08990478515625, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+31, 180415, 0, 5145, 4975, '0', 0, 0, -6598.5693359375, 6174.1962890625, -662.38214111328125, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+32, 180415, 0, 5145, 4975, '0', 0, 0, -6606.6943359375, 6177.51416015625, -665.96893310546875, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+33, 180415, 0, 5145, 4975, '0', 0, 0, -6607.73095703125, 6174.736328125, -666.4322509765625, 0.820303261280059814, 0, 0, 0.398748397827148437, 0.917060375213623046, 120, 255, 1, 51886), -- CandleBlack01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+34, 180425, 0, 5145, 4975, '0', 0, 0, -6532.82666015625, 6131.2734375, -665.67559814453125, 3.996806621551513671, 0, 0, -0.90996074676513671, 0.414694398641586303, 120, 255, 1, 51886), -- SkullCandle01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+35, 180425, 0, 5145, 4975, '0', 0, 0, -6555.84033203125, 6131.15478515625, -669.60369873046875, 2.111847877502441406, 0, 0, 0.870355606079101562, 0.492423713207244873, 120, 255, 1, 51886), -- SkullCandle01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+36, 180425, 0, 5145, 4975, '0', 0, 0, -6620.41162109375, 6145.96875, -855.353515625, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- SkullCandle01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+37, 180471, 0, 5145, 4975, '0', 0, 0, -6531.17041015625, 6123.44970703125, -667.81915283203125, 5.340708732604980468, 0, 0, -0.45398998260498046, 0.891006767749786376, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+38, 180471, 0, 5145, 4975, '0', 0, 0, -6524.66650390625, 6115.43505859375, -665.9256591796875, 5.323255538940429687, 0, 0, -0.46174812316894531, 0.887011110782623291, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+39, 180471, 0, 5145, 4975, '0', 0, 0, -6527.0849609375, 6119.66650390625, -666.04913330078125, 5.445427894592285156, 0, 0, -0.40673637390136718, 0.913545548915863037, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+40, 180471, 0, 5145, 4975, '0', 0, 0, -6522.4931640625, 6108.9521484375, -668.03985595703125, 5.340708732604980468, 0, 0, -0.45398998260498046, 0.891006767749786376, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+41, 180471, 0, 5145, 4975, '0', 0, 0, -6555.78125, 6145.68505859375, -665.516845703125, 5.445427894592285156, 0, 0, -0.40673637390136718, 0.913545548915863037, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+42, 180471, 0, 5145, 4975, '0', 0, 0, -6563.12158203125, 6150.09814453125, -666.88897705078125, 6.108653545379638671, 0, 0, -0.08715534210205078, 0.996194720268249511, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+43, 180471, 0, 5145, 4975, '0', 0, 0, -6548.609375, 6140.20751953125, -665.22711181640625, 5.532694816589355468, 0, 0, -0.3665008544921875, 0.93041771650314331, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+44, 180471, 0, 5145, 4975, '0', 0, 0, -6573.375, 6151.32470703125, -666.88897705078125, 0.24434557557106018, 0, 0, 0.121869087219238281, 0.9925462007522583, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+45, 180523, 0, 5145, 4975, '0', 0, 0, -6552.25537109375, 6138.05224609375, -669.76947021484375, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Apple Bob (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+46, 185438, 0, 5145, 4975, '0', 0, 0, -6516.78125, 6108.4150390625, -670.69744873046875, 3.333590030670166015, 0, 0, -0.99539566040039062, 0.095851235091686248, 120, 255, 1, 51886), -- Sitting Skeleton 04 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+47, 208061, 0, 5145, 4975, '0', 0, 0, -6513.72216796875, 6081.68212890625, -666.72698974609375, 4.537858963012695312, 0, 0, -0.76604366302490234, 0.642788589000701904, 120, 255, 1, 51886), -- G_Pumpkin_02 Scale 2.0 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+48, 208069, 0, 5145, 4975, '0', 0, 0, -6535.55908203125, 6136.7744140625, -666.30828857421875, 5.672322273254394531, 0, 0, -0.3007049560546875, 0.953717231750488281, 120, 255, 1, 51886), -- G_Pumpkin_02 Scale 0.5 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+49, 208069, 0, 5145, 4975, '0', 0, 0, -6575.06103515625, 6148.42626953125, -664.3446044921875, 0.27925160527229309, 0, 0, 0.139172554016113281, 0.990268170833587646, 120, 255, 1, 51886), -- G_Pumpkin_02 Scale 0.5 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+50, 208072, 0, 5145, 4975, '0', 0, 0, -6530.18603515625, 6131.29150390625, -665.70684814453125, 6.213373661041259765, 0, 0, -0.03489875793457031, 0.999390840530395507, 120, 255, 1, 51886), -- G_Pumpkin_03 Scale 0.5 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+51, 208078, 0, 5145, 4975, '0', 0, 0, -6531.5537109375, 6134.955078125, -660.0418701171875, 5.916667938232421875, 0, 0, -0.18223476409912109, 0.98325502872467041, 120, 255, 1, 51886), -- G_Pumpkin_01 scale 0.5 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+52, 208078, 0, 5145, 4975, '0', 0, 0, -6550.3193359375, 6137.33056640625, -663.10137939453125, 6.03883981704711914, 0, 0, -0.12186908721923828, 0.9925462007522583, 120, 255, 1, 51886), -- G_Pumpkin_01 scale 0.5 (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+(@OGUID+53, 208155, 0, 5145, 4975, '0', 0, 0, -6551.15283203125, 6140.9755859375, -669.81085205078125, 4.904376029968261718, 0, 0, -0.636077880859375, 0.771624863147735595, 120, 255, 1, 51886); -- Candy Bucket (Area: Tenebrous Cavern - Difficulty: 0) CreateObject1
+
+-- Event spawns
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+53;
+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),
+(12, @OGUID+43),
+(12, @OGUID+44),
+(12, @OGUID+45),
+(12, @OGUID+46),
+(12, @OGUID+47),
+(12, @OGUID+48),
+(12, @OGUID+49),
+(12, @OGUID+50),
+(12, @OGUID+51),
+(12, @OGUID+52),
+(12, @OGUID+53);
diff --git a/sql/updates/world/master/2023_11_22_12_world_abyssal_depths_darkbreak_cove.sql b/sql/updates/world/master/2023_11_22_12_world_abyssal_depths_darkbreak_cove.sql
new file mode 100644
index 00000000000..c00febbf892
--- /dev/null
+++ b/sql/updates/world/master/2023_11_22_12_world_abyssal_depths_darkbreak_cove.sql
@@ -0,0 +1,153 @@
+SET @OGUID := 3006190;
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=51886 WHERE `entry`=208132; -- Candy Bucket
+
+UPDATE `gameobject_template_addon` SET `faction`=1732 WHERE `entry`=208132; -- Candy Bucket
+
+-- Quests
+UPDATE `quest_template` SET `Expansion`=9, `VerifiedBuild`=51886 WHERE `ID`=28985; -- Candy Bucket
+
+DELETE FROM `quest_offer_reward` WHERE `ID`=28985;
+INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES
+(28985, 0, 0, 0, 0, 0, 0, 0, 0, 'Candy buckets like this are located in inns throughout the realms. Go ahead... take some!', 51886); -- Candy Bucket
+
+DELETE FROM `gameobject_queststarter` WHERE `id`=208132;
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(208132, 28985, 51886);
+
+UPDATE `gameobject_questender` SET `VerifiedBuild`=51886 WHERE (`id`=208132 AND `quest`=28985);
+
+DELETE FROM `game_event_gameobject_quest` WHERE `id`=208132;
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+61;
+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, 0, 5145, 4976, '0', 0, 0, -6880.1005859375, 5941.791015625, -760.52716064453125, 4.468043327331542968, 0, 0, -0.7880105972290039, 0.615661680698394775, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+1, 180405, 0, 5145, 4976, '0', 0, 0, -6856.60791015625, 5998.84716796875, -762.5745849609375, 4.852017402648925781, 0, 0, -0.65605831146240234, 0.754710197448730468, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+2, 180406, 0, 5145, 4976, '0', 0, 0, -6848.3505859375, 6013.109375, -757.63861083984375, 5.113816738128662109, 0, 0, -0.55193614959716796, 0.833886384963989257, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+3, 180406, 0, 5145, 4976, '0', 0, 0, -6858.60791015625, 5994.21875, -762.6826171875, 4.48549652099609375, 0, 0, -0.7826080322265625, 0.622514784336090087, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+4, 180407, 0, 5145, 4976, '0', 0, 0, -6874.2099609375, 5945.28564453125, -760.05792236328125, 4.223697185516357421, 0, 0, -0.85716724395751953, 0.515038192272186279, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+5, 180407, 0, 5145, 4976, '0', 0, 0, -6860.83154296875, 5989.8818359375, -763.06903076171875, 4.223697185516357421, 0, 0, -0.85716724395751953, 0.515038192272186279, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+6, 180408, 0, 5145, 4976, '0', 0, 0, -6848.35791015625, 6013.04931640625, -755.968994140625, 4.904376029968261718, 0, 0, -0.636077880859375, 0.771624863147735595, 120, 255, 1, 51886), -- G_WitchHat_01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+7, 180414, 0, 5145, 4976, '0', 0, 0, -6852.859375, 6004.859375, -762.453125, 5.759587764739990234, 0, 0, -0.25881862640380859, 0.965925931930541992, 120, 255, 1, 51886), -- Cauldron (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+8, 180415, 0, 5145, 4976, '0', 0, 0, -6881.08154296875, 5942.38916015625, -763.26019287109375, 5.969027042388916015, 0, 0, -0.1564340591430664, 0.987688362598419189, 120, 255, 1, 51886), -- CandleBlack01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+9, 180415, 0, 5145, 4976, '0', 0, 0, -6881.73095703125, 5941.8359375, -763.05743408203125, 5.375615119934082031, 0, 0, -0.4383707046508789, 0.898794233798980712, 120, 255, 1, 51886), -- CandleBlack01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+10, 180415, 0, 5145, 4976, '0', 0, 0, -6880.26025390625, 5942.93408203125, -763.04815673828125, 5.218535900115966796, 0, 0, -0.507537841796875, 0.861629426479339599, 120, 255, 1, 51886), -- CandleBlack01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+11, 180415, 0, 5145, 4976, '0', 0, 0, -6886.375, 5930.30029296875, -757.18292236328125, 0.104719325900077819, 0, 0, 0.052335739135742187, 0.998629570007324218, 120, 255, 1, 51886), -- CandleBlack01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+12, 180415, 0, 5145, 4976, '0', 0, 0, -6877.54541015625, 5946.126953125, -764.1541748046875, 4.328419685363769531, 0, 0, -0.82903671264648437, 0.559194147586822509, 120, 255, 1, 51886), -- CandleBlack01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+13, 180415, 0, 5145, 4976, '0', 0, 0, -6876.65966796875, 5946.67529296875, -764.27911376953125, 5.6897735595703125, 0, 0, -0.29237174987792968, 0.956304728984832763, 120, 255, 1, 51886), -- CandleBlack01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+14, 180415, 0, 5145, 4976, '0', 0, 0, -6877.126953125, 5945.796875, -763.40313720703125, 4.014260292053222656, 0, 0, -0.90630722045898437, 0.422619491815567016, 120, 255, 1, 51886), -- CandleBlack01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+15, 180415, 0, 5145, 4976, '0', 0, 0, -6889.83837890625, 5927.44287109375, -758.4693603515625, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+16, 180415, 0, 5145, 4976, '0', 0, 0, -6887.35595703125, 5932.46533203125, -753.97503662109375, 0.104719325900077819, 0, 0, 0.052335739135742187, 0.998629570007324218, 120, 255, 1, 51886), -- CandleBlack01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+17, 180415, 0, 5145, 4976, '0', 0, 0, -6871.392578125, 5948.69189453125, -758.208984375, 0.628316879272460937, 0, 0, 0.309016227722167968, 0.95105677843093872, 120, 255, 1, 51886), -- CandleBlack01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+18, 180415, 0, 5145, 4976, '0', 0, 0, -6891.1337890625, 5924.6552734375, -758.7484130859375, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- CandleBlack01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+19, 180415, 0, 5145, 4976, '0', 0, 0, -6873.43408203125, 5951.84228515625, -758.93560791015625, 6.056293010711669921, 0, 0, -0.11320304870605468, 0.993571877479553222, 120, 255, 1, 51886), -- CandleBlack01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+20, 180415, 0, 5145, 4976, '0', 0, 0, -6849.546875, 6012.6162109375, -759.173095703125, 5.166176319122314453, 0, 0, -0.52991867065429687, 0.84804844856262207, 120, 255, 1, 51886), -- CandleBlack01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+21, 180415, 0, 5145, 4976, '0', 0, 0, -6849.6962890625, 6013.39501953125, -760.3284912109375, 4.817109584808349609, 0, 0, -0.66913032531738281, 0.74314504861831665, 120, 255, 1, 51886), -- CandleBlack01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+22, 180415, 0, 5145, 4976, '0', 0, 0, -6846.21337890625, 6005.1474609375, -757.23077392578125, 0.104719325900077819, 0, 0, 0.052335739135742187, 0.998629570007324218, 120, 255, 1, 51886), -- CandleBlack01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+23, 180415, 0, 5145, 4976, '0', 0, 0, -6845.00341796875, 6020.8505859375, -757.28350830078125, 5.794494152069091796, 0, 0, -0.24192142486572265, 0.970295846462249755, 120, 255, 1, 51886), -- CandleBlack01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+24, 180415, 0, 5145, 4976, '0', 0, 0, -6843.95849609375, 6007.22900390625, -757.2421875, 5.881760597229003906, 0, 0, -0.19936752319335937, 0.979924798011779785, 120, 255, 1, 51886), -- CandleBlack01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+25, 180415, 0, 5145, 4976, '0', 0, 0, -6849.4150390625, 6012.0068359375, -759.0504150390625, 3.385940074920654296, 0, 0, -0.99254608154296875, 0.121869951486587524, 120, 255, 1, 51886), -- CandleBlack01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+26, 180415, 0, 5145, 4976, '0', 0, 0, -6850.29150390625, 6014.587890625, -761.8104248046875, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 120, 255, 1, 51886), -- CandleBlack01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+27, 180415, 0, 5145, 4976, '0', 0, 0, -6849.6318359375, 6012.93310546875, -758.98516845703125, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 51886), -- CandleBlack01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+28, 180415, 0, 5145, 4976, '0', 0, 0, -6841.68408203125, 6026.02685546875, -756.010009765625, 5.585053920745849609, 0, 0, -0.34202003479003906, 0.939692676067352294, 120, 255, 1, 51886), -- CandleBlack01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+29, 180415, 0, 5145, 4976, '0', 0, 0, -6844.14599609375, 6024.6884765625, -752.98663330078125, 5.794494152069091796, 0, 0, -0.24192142486572265, 0.970295846462249755, 120, 255, 1, 51886), -- CandleBlack01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+30, 180415, 0, 5145, 4976, '0', 0, 0, -6847.345703125, 6022.90869140625, -757.312744140625, 0.104719325900077819, 0, 0, 0.052335739135742187, 0.998629570007324218, 120, 255, 1, 51886), -- CandleBlack01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+31, 180415, 0, 5145, 4976, '0', 0, 0, -6874.3037109375, 6045.244140625, -759.26385498046875, 0.628316879272460937, 0, 0, 0.309016227722167968, 0.95105677843093872, 120, 255, 1, 51886), -- CandleBlack01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+32, 180415, 0, 5145, 4976, '0', 0, 0, -6848.6181640625, 6035.88037109375, -759.16961669921875, 0.139624491333961486, 0, 0, 0.06975555419921875, 0.997564136981964111, 120, 255, 1, 51886), -- CandleBlack01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+33, 180415, 0, 5145, 4976, '0', 0, 0, -6857.1787109375, 6040.15966796875, -765.3016357421875, 5.026549339294433593, 0, 0, -0.5877847671508789, 0.809017360210418701, 120, 255, 1, 51886), -- CandleBlack01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+34, 180415, 0, 5145, 4976, '0', 0, 0, -6875.89404296875, 6042.96337890625, -756.33758544921875, 0.122172988951206207, 0, 0, 0.061048507690429687, 0.998134791851043701, 120, 255, 1, 51886), -- CandleBlack01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+35, 180415, 0, 5145, 4976, '0', 0, 0, -6847.40283203125, 6036.75, -755.3746337890625, 5.794494152069091796, 0, 0, -0.24192142486572265, 0.970295846462249755, 120, 255, 1, 51886), -- CandleBlack01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+36, 180415, 0, 5145, 4976, '0', 0, 0, -6867.642578125, 6046.9287109375, -759.85614013671875, 0.104719325900077819, 0, 0, 0.052335739135742187, 0.998629570007324218, 120, 255, 1, 51886), -- CandleBlack01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+37, 180415, 0, 5145, 4976, '0', 0, 0, -6870.59912109375, 6047.806640625, -760.02178955078125, 5.759587764739990234, 0, 0, -0.25881862640380859, 0.965925931930541992, 120, 255, 1, 51886), -- CandleBlack01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+38, 180415, 0, 5145, 4976, '0', 0, 0, -6859.85400390625, 6068.291015625, -756.64923095703125, 5.532694816589355468, 0, 0, -0.3665008544921875, 0.93041771650314331, 120, 255, 1, 51886), -- CandleBlack01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+39, 180415, 0, 5145, 4976, '0', 0, 0, -6860.9599609375, 6077.087890625, -760.18280029296875, 0.104719325900077819, 0, 0, 0.052335739135742187, 0.998629570007324218, 120, 255, 1, 51886), -- CandleBlack01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+40, 180415, 0, 5145, 4976, '0', 0, 0, -6857.6474609375, 6070.41650390625, -759.28509521484375, 5.881760597229003906, 0, 0, -0.19936752319335937, 0.979924798011779785, 120, 255, 1, 51886), -- CandleBlack01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+41, 180415, 0, 5145, 4976, '0', 0, 0, -6863.91650390625, 6076.30712890625, -760.61090087890625, 0.104719325900077819, 0, 0, 0.052335739135742187, 0.998629570007324218, 120, 255, 1, 51886), -- CandleBlack01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+42, 180425, 0, 5145, 4976, '0', 0, 0, -6880.61474609375, 5942.69091796875, -762.90997314453125, 3.159062385559082031, 0, 0, -0.99996185302734375, 0.008734640665352344, 120, 255, 1, 51886), -- SkullCandle01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+43, 180425, 0, 5145, 4976, '0', 0, 0, -6876.90625, 5945.97412109375, -763.02923583984375, 2.44346022605895996, 0, 0, 0.939692497253417968, 0.34202045202255249, 120, 255, 1, 51886), -- SkullCandle01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+44, 180425, 0, 5145, 4976, '0', 0, 0, -6891.4150390625, 5967.6474609375, -763.99566650390625, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- SkullCandle01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+45, 180425, 0, 5145, 4976, '0', 0, 0, -6849.98095703125, 6012.0390625, -761.28399658203125, 3.700104713439941406, 0, 0, -0.96126079559326171, 0.275640487670898437, 120, 255, 1, 51886), -- SkullCandle01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+46, 180425, 0, 5145, 4976, '0', 0, 0, -6857.88720703125, 6040.61181640625, -765.0418701171875, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 120, 255, 1, 51886), -- SkullCandle01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+47, 180471, 0, 5145, 4976, '0', 0, 0, -6859.80712890625, 5994.99853515625, -760.16778564453125, 4.258606910705566406, 0, 0, -0.84804725646972656, 0.529920578002929687, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+48, 180471, 0, 5145, 4976, '0', 0, 0, -6857.7744140625, 5999.00341796875, -760.08441162109375, 4.502951622009277343, 0, 0, -0.7771453857421875, 0.629321098327636718, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+49, 180471, 0, 5145, 4976, '0', 0, 0, -6866.15478515625, 6007.68310546875, -761.50079345703125, 5.881760597229003906, 0, 0, -0.19936752319335937, 0.979924798011779785, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+50, 180471, 0, 5145, 4976, '0', 0, 0, -6862.046875, 5991.046875, -760.49261474609375, 3.94444584846496582, 0, 0, -0.92050457000732421, 0.3907318115234375, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+51, 180471, 0, 5145, 4976, '0', 0, 0, -6863.02783203125, 6004.7177734375, -761.384033203125, 5.427974700927734375, 0, 0, -0.41469287872314453, 0.909961462020874023, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+52, 180471, 0, 5145, 4976, '0', 0, 0, -6858.74462890625, 6030.0390625, -763.69207763671875, 4.642575740814208984, 0, 0, -0.731353759765625, 0.681998312473297119, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+53, 180472, 0, 5145, 4976, '0', 0, 0, -6862.64404296875, 6035.67529296875, -761.94061279296875, 4.625123500823974609, 0, 0, -0.73727703094482421, 0.67559051513671875, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+54, 180523, 0, 5145, 4976, '0', 0, 0, -6863.68603515625, 5997.23681640625, -762.946533203125, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- Apple Bob (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+55, 208069, 0, 5145, 4976, '0', 0, 0, -6880.15966796875, 5946.98876953125, -764.90069580078125, 4.502951622009277343, 0, 0, -0.7771453857421875, 0.629321098327636718, 120, 255, 1, 51886), -- G_Pumpkin_02 Scale 0.5 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+56, 208069, 0, 5145, 4976, '0', 0, 0, -6859.42041015625, 6038.330078125, -766.0528564453125, 0.139624491333961486, 0, 0, 0.06975555419921875, 0.997564136981964111, 120, 255, 1, 51886), -- G_Pumpkin_02 Scale 0.5 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+57, 208072, 0, 5145, 4976, '0', 0, 0, -6884.57275390625, 5940.3349609375, -763.77313232421875, 4.520402908325195312, 0, 0, -0.77162456512451171, 0.636078238487243652, 120, 255, 1, 51886), -- G_Pumpkin_03 Scale 0.5 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+58, 208072, 0, 5145, 4976, '0', 0, 0, -6848.40087890625, 6011.34033203125, -758.751220703125, 5.253442287445068359, 0, 0, -0.49242305755615234, 0.870355963706970214, 120, 255, 1, 51886), -- G_Pumpkin_03 Scale 0.5 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+59, 208078, 0, 5145, 4976, '0', 0, 0, -6874.64404296875, 5952.31787109375, -765.11865234375, 4.223697185516357421, 0, 0, -0.85716724395751953, 0.515038192272186279, 120, 255, 1, 51886), -- G_Pumpkin_01 scale 0.5 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+60, 208078, 0, 5145, 4976, '0', 0, 0, -6848.828125, 6014.31005859375, -758.8798828125, 4.991643905639648437, 0, 0, -0.60181427001953125, 0.798636078834533691, 120, 255, 1, 51886), -- G_Pumpkin_01 scale 0.5 (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+(@OGUID+61, 208132, 0, 5145, 4976, '0', 0, 0, -6865.40283203125, 6005.45556640625, -763.8397216796875, 5.480334281921386718, 0, 0, -0.39073085784912109, 0.920504987239837646, 120, 255, 1, 51886); -- Candy Bucket (Area: Darkbreak Cove - Difficulty: 0) CreateObject1
+
+-- Event spawns
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+61;
+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),
+(12, @OGUID+43),
+(12, @OGUID+44),
+(12, @OGUID+45),
+(12, @OGUID+46),
+(12, @OGUID+47),
+(12, @OGUID+48),
+(12, @OGUID+49),
+(12, @OGUID+50),
+(12, @OGUID+51),
+(12, @OGUID+52),
+(12, @OGUID+53),
+(12, @OGUID+54),
+(12, @OGUID+55),
+(12, @OGUID+56),
+(12, @OGUID+57),
+(12, @OGUID+58),
+(12, @OGUID+59),
+(12, @OGUID+60),
+(12, @OGUID+61);
author	Meji <alvaro.megias@outlook.com>	2023-11-22 20:42:58 +0100
committer	Meji <alvaro.megias@outlook.com>	2023-11-22 20:42:58 +0100
commit	1776e74ddb18e285b8ac55a7df0cbdc5a9f5d29f (patch)
tree	184ede4776515826626b66cdfaf2fedbcf748e17
parent	be599c48ed891add91488a6bd6c26c2270f602a6 (diff)