aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat
-rw-r--r--sql/updates/world/master/2022_11_12_06_world_feralas_camp_ataya.sql85
-rw-r--r--sql/updates/world/master/2022_11_12_07_world_feralas_camp_mojache.sql107
-rw-r--r--sql/updates/world/master/2022_11_12_08_world_feralas_stonemaul_hold.sql117
-rw-r--r--sql/updates/world/master/2022_11_12_09_world_feralas_dreamers_rest.sql93
-rw-r--r--sql/updates/world/master/2022_11_12_10_world_feralas_feathermoon_stronghold.sql185
5 files changed, 587 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_11_12_06_world_feralas_camp_ataya.sql b/sql/updates/world/master/2022_11_12_06_world_feralas_camp_ataya.sql
new file mode 100644
index 00000000000..fde9b4a14ca
--- /dev/null
+++ b/sql/updates/world/master/2022_11_12_06_world_feralas_camp_ataya.sql
@@ -0,0 +1,85 @@
+SET @CGUID := 396412;
+SET @OGUID := 247694;
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `Data6`=0, `ContentTuningId`=425, `VerifiedBuild`=46366 WHERE `entry`=208160; -- Candy Bucket
+
+UPDATE `gameobject_template_addon` SET `faction`=1735 WHERE `entry`=208160; -- Candy Bucket
+
+-- Quests
+DELETE FROM `quest_offer_reward` WHERE `ID`=28996;
+INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES
+(28996, 0, 0, 0, 0, 0, 0, 0, 0, 'Candy buckets like this are located in inns throughout the realms. Go ahead... take some!', 46366); -- Candy Bucket
+
+DELETE FROM `gameobject_queststarter` WHERE `id`=208160;
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(208160, 28996, 46366);
+
+UPDATE `gameobject_questender` SET `VerifiedBuild`=46366 WHERE (`id`=208160 AND `quest`=28996);
+
+DELETE FROM `game_event_gameobject_quest` WHERE `id`=208160;
+
+-- Creature spawns
+DELETE FROM `creature` WHERE `guid`=@CGUID+0;
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+(@CGUID+0, 22816, 1, 357, 5002, '0', 0, 0, 0, 0, -3076.993408203125, 2583.047607421875, 56.78761672973632812, 4.667431831359863281, 120, 10, 0, 188, 0, 1, 0, 0, 0, 46366); -- Black Cat (Area: Camp Ataya - Difficulty: 0)
+
+-- Old gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 227678 AND 227698;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 227678 AND 227698;
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+21;
+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, 357, 5002, '0', 0, 0, -3099.138916015625, 2568.799560546875, 50.17909622192382812, 2.844882726669311523, 0, 0, 0.989015579223632812, 0.147811368107795715, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Camp Ataya - Difficulty: 0)
+(@OGUID+1, 180406, 1, 357, 5002, '0', 0, 0, -3090.01904296875, 2553.565185546875, 60.36992645263671875, 2.72271275520324707, 0, 0, 0.978147506713867187, 0.207912087440490722, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Camp Ataya - Difficulty: 0)
+(@OGUID+2, 180406, 1, 357, 5002, '0', 0, 0, -3041.9931640625, 2558.14501953125, 52.69311141967773437, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Camp Ataya - Difficulty: 0)
+(@OGUID+3, 180407, 1, 357, 5002, '0', 0, 0, -3068.015625, 2560.755126953125, 53.10766983032226562, 1.151916384696960449, 0, 0, 0.544638633728027343, 0.838670849800109863, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Camp Ataya - Difficulty: 0)
+(@OGUID+4, 180415, 1, 357, 5002, '0', 0, 0, -3094.828125, 2560.00439453125, 52.31954193115234375, 2.164205789566040039, 0, 0, 0.882946968078613281, 0.469472706317901611, 120, 255, 1, 46366), -- CandleBlack01 (Area: Camp Ataya - Difficulty: 0)
+(@OGUID+5, 180415, 1, 357, 5002, '0', 0, 0, -3098.9150390625, 2566.762939453125, 52.49582290649414062, 2.164205789566040039, 0, 0, 0.882946968078613281, 0.469472706317901611, 120, 255, 1, 46366), -- CandleBlack01 (Area: Camp Ataya - Difficulty: 0)
+(@OGUID+6, 180425, 1, 357, 5002, '0', 0, 0, -3083.697998046875, 2546.736083984375, 52.13373947143554687, 1.186823248863220214, 0, 0, 0.559192657470703125, 0.829037725925445556, 120, 255, 1, 46366), -- SkullCandle01 (Area: Camp Ataya - Difficulty: 0)
+(@OGUID+7, 180426, 1, 357, 5002, '0', 0, 0, -3086.510498046875, 2568.942626953125, 50.17909622192382812, 2.164205789566040039, 0, 0, 0.882946968078613281, 0.469472706317901611, 120, 255, 1, 46366), -- Bat01 (Area: Camp Ataya - Difficulty: 0)
+(@OGUID+8, 180426, 1, 357, 5002, '0', 0, 0, -3086.026123046875, 2572.739501953125, 55.876190185546875, 2.164205789566040039, 0, 0, 0.882946968078613281, 0.469472706317901611, 120, 255, 1, 46366), -- Bat01 (Area: Camp Ataya - Difficulty: 0)
+(@OGUID+9, 180426, 1, 357, 5002, '0', 0, 0, -3096.28125, 2577.775146484375, 50.17909622192382812, 2.164205789566040039, 0, 0, 0.882946968078613281, 0.469472706317901611, 120, 255, 1, 46366), -- Bat01 (Area: Camp Ataya - Difficulty: 0)
+(@OGUID+10, 180427, 1, 357, 5002, '0', 0, 0, -3102.5869140625, 2578.46435546875, 64.87989044189453125, 2.164205789566040039, 0, 0, 0.882946968078613281, 0.469472706317901611, 120, 255, 1, 46366), -- Bat02 (Area: Camp Ataya - Difficulty: 0)
+(@OGUID+11, 180427, 1, 357, 5002, '0', 0, 0, -3098.19970703125, 2590.7421875, 65.4478302001953125, 2.164205789566040039, 0, 0, 0.882946968078613281, 0.469472706317901611, 120, 255, 1, 46366), -- Bat02 (Area: Camp Ataya - Difficulty: 0)
+(@OGUID+12, 180427, 1, 357, 5002, '0', 0, 0, -3092.140625, 2576.9931640625, 59.86314010620117187, 2.164205789566040039, 0, 0, 0.882946968078613281, 0.469472706317901611, 120, 255, 1, 46366), -- Bat02 (Area: Camp Ataya - Difficulty: 0)
+(@OGUID+13, 180471, 1, 357, 5002, '0', 0, 0, -3065.642333984375, 2559.48095703125, 58.4449462890625, 1.047197580337524414, 0, 0, 0.5, 0.866025388240814208, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Camp Ataya - Difficulty: 0)
+(@OGUID+14, 180471, 1, 357, 5002, '0', 0, 0, -3065.642333984375, 2559.48095703125, 60.08661651611328125, 1.047197580337524414, 0, 0, 0.5, 0.866025388240814208, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Camp Ataya - Difficulty: 0)
+(@OGUID+15, 180471, 1, 357, 5002, '0', 0, 0, -3066.257080078125, 2558.65625, 60.17853546142578125, 1.169368624687194824, 0, 0, 0.551936149597167968, 0.833886384963989257, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Camp Ataya - Difficulty: 0)
+(@OGUID+16, 180471, 1, 357, 5002, '0', 0, 0, -3092.34375, 2554.709228515625, 54.05554580688476562, 2.408554315567016601, 0, 0, 0.933580398559570312, 0.358368009328842163, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Camp Ataya - Difficulty: 0)
+(@OGUID+17, 180471, 1, 357, 5002, '0', 0, 0, -3088.864501953125, 2550.724853515625, 54.05554580688476562, 2.408554315567016601, 0, 0, 0.933580398559570312, 0.358368009328842163, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Camp Ataya - Difficulty: 0)
+(@OGUID+18, 180472, 1, 357, 5002, '0', 0, 0, -3095.835205078125, 2559.58251953125, 55.12337493896484375, 0.733038187026977539, 0, 0, 0.358367919921875, 0.933580458164215087, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Camp Ataya - Difficulty: 0)
+(@OGUID+19, 180472, 1, 357, 5002, '0', 0, 0, -3076.232666015625, 2591.376708984375, 61.20790481567382812, 3.630291461944580078, 0, 0, -0.97029495239257812, 0.241925001144409179, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Camp Ataya - Difficulty: 0)
+(@OGUID+20, 180523, 1, 357, 5002, '0', 0, 0, -3098.897705078125, 2558.19189453125, 50.51286697387695312, 0, 0, 0, 0, 1, 120, 255, 1, 46366), -- Apple Bob (Area: Camp Ataya - Difficulty: 0)
+(@OGUID+21, 208160, 1, 357, 5002, '0', 0, 0, -3093.390625, 2561.03466796875, 50.17909622192382812, 2.530723094940185546, 0, 0, 0.953716278076171875, 0.300707906484603881, 120, 255, 1, 46366); -- Candy Bucket (Area: Camp Ataya - Difficulty: 0)
+
+-- Event spawns
+DELETE FROM `game_event_creature` WHERE `eventEntry`=12 AND `guid`=@CGUID+0;
+INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES
+(12, @CGUID+0);
+
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+21;
+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);
diff --git a/sql/updates/world/master/2022_11_12_07_world_feralas_camp_mojache.sql b/sql/updates/world/master/2022_11_12_07_world_feralas_camp_mojache.sql
new file mode 100644
index 00000000000..5d25e83198d
--- /dev/null
+++ b/sql/updates/world/master/2022_11_12_07_world_feralas_camp_mojache.sql
@@ -0,0 +1,107 @@
+SET @OGUID := 247716;
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=46366 WHERE `entry`=190088; -- Candy Bucket
+
+UPDATE `gameobject_template_addon` SET `faction`=1735 WHERE `entry`=190088; -- Candy Bucket
+
+-- Quests
+UPDATE `quest_offer_reward` SET `VerifiedBuild`=46366 WHERE `ID`=12386;
+
+DELETE FROM `gameobject_queststarter` WHERE `id`=190088;
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(190088, 12386, 46366);
+
+UPDATE `gameobject_questender` SET `VerifiedBuild`=46366 WHERE (`id`=190088 AND `quest`=12386);
+
+DELETE FROM `game_event_gameobject_quest` WHERE `id`=190088;
+
+-- Old gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 227599 AND 227637;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 227599 AND 227637;
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+38;
+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, 357, 1099, '0', 0, 0, -4431.82275390625, 269.430572509765625, 40.19013595581054687, 2.72271275520324707, 0, 0, 0.978147506713867187, 0.207912087440490722, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+1, 180405, 1, 357, 1099, '0', 0, 0, -4421.5380859375, 249.7777862548828125, 40.190765380859375, 2.146752834320068359, 0, 0, 0.878816604614257812, 0.477159708738327026, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+2, 180406, 1, 357, 1099, '0', 0, 0, -4434.0947265625, 250.373565673828125, 53.552032470703125, 2.426007747650146484, 0, 0, 0.936672210693359375, 0.350207358598709106, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+3, 180406, 1, 357, 1099, '0', 0, 0, -4477.54296875, 241.1378021240234375, 47.33536148071289062, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+4, 180407, 1, 357, 1099, '0', 0, 0, -4438.30517578125, 259.156005859375, 53.552032470703125, 2.44346022605895996, 0, 0, 0.939692497253417968, 0.34202045202255249, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+5, 180407, 1, 357, 1099, '0', 0, 0, -4412.91162109375, 206.7220916748046875, 26.282745361328125, 1.675513744354248046, 0, 0, 0.743144035339355468, 0.669131457805633544, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+6, 180411, 1, 357, 1099, '0', 0, 0, -4431.64599609375, 257.35589599609375, 64.89984130859375, 3.630291461944580078, 0, 0, -0.97029495239257812, 0.241925001144409179, 120, 255, 1, 46366), -- G_Ghost_01 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+7, 180426, 1, 357, 1099, '0', 0, 0, -4397.81103515625, 248.31597900390625, 36.8386993408203125, 6.213373661041259765, 0, 0, -0.03489875793457031, 0.999390840530395507, 120, 255, 1, 46366), -- Bat01 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+8, 180426, 1, 357, 1099, '0', 0, 0, -4400.06591796875, 257.92535400390625, 39.39876174926757812, 0.663223206996917724, 0, 0, 0.325567245483398437, 0.945518851280212402, 120, 255, 1, 46366), -- Bat01 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+9, 180426, 1, 357, 1099, '0', 0, 0, -4402.09912109375, 244.6927032470703125, 38.13518524169921875, 6.161012649536132812, 0, 0, -0.06104850769042968, 0.998134791851043701, 120, 255, 1, 46366), -- Bat01 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+10, 180426, 1, 357, 1099, '0', 0, 0, -4397.1787109375, 248.83160400390625, 35.07228469848632812, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 46366), -- Bat01 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+11, 180426, 1, 357, 1099, '0', 0, 0, -4396.57275390625, 248.6840362548828125, 34.7597198486328125, 5.986480236053466796, 0, 0, -0.14780902862548828, 0.989015936851501464, 120, 255, 1, 46366), -- Bat01 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+12, 180426, 1, 357, 1099, '0', 0, 0, -4396.28466796875, 248.170135498046875, 37.53192520141601562, 5.672322273254394531, 0, 0, -0.3007049560546875, 0.953717231750488281, 120, 255, 1, 46366), -- Bat01 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+13, 180426, 1, 357, 1099, '0', 0, 0, -4395.0087890625, 241.9913177490234375, 36.0612335205078125, 1.867502212524414062, 0, 0, 0.803856849670410156, 0.594822824001312255, 120, 255, 1, 46366), -- Bat01 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+14, 180426, 1, 357, 1099, '0', 0, 0, -4396.345703125, 248.62847900390625, 34.80261993408203125, 4.188792228698730468, 0, 0, -0.86602497100830078, 0.50000077486038208, 120, 255, 1, 46366), -- Bat01 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+15, 180426, 1, 357, 1099, '0', 0, 0, -4397.52587890625, 243.376739501953125, 34.41378402709960937, 4.433136463165283203, 0, 0, -0.79863548278808593, 0.60181504487991333, 120, 255, 1, 46366), -- Bat01 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+16, 180426, 1, 357, 1099, '0', 0, 0, -4395.18212890625, 227.407989501953125, 36.96889495849609375, 1.954769015312194824, 0, 0, 0.829037666320800781, 0.559192776679992675, 120, 255, 1, 46366), -- Bat01 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+17, 180427, 1, 357, 1099, '0', 0, 0, -4396.71337890625, 247.9027862548828125, 38.01698684692382812, 3.316144466400146484, 0, 0, -0.99619388580322265, 0.087165042757987976, 120, 255, 1, 46366), -- Bat02 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+18, 180427, 1, 357, 1099, '0', 0, 0, -4397.57666015625, 248.829864501953125, 35.73020553588867187, 2.251473426818847656, 0, 0, 0.902585029602050781, 0.430511653423309326, 120, 255, 1, 46366), -- Bat02 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+19, 180427, 1, 357, 1099, '0', 0, 0, -4397.390625, 248.453125, 37.29834747314453125, 4.433136463165283203, 0, 0, -0.79863548278808593, 0.60181504487991333, 120, 255, 1, 46366), -- Bat02 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+20, 180427, 1, 357, 1099, '0', 0, 0, -4396.671875, 248.201385498046875, 36.5920867919921875, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 120, 255, 1, 46366), -- Bat02 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+21, 180427, 1, 357, 1099, '0', 0, 0, -4396.62841796875, 248.3524322509765625, 36.66197967529296875, 2.495818138122558593, 0, 0, 0.948323249816894531, 0.317305892705917358, 120, 255, 1, 46366), -- Bat02 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+22, 180427, 1, 357, 1099, '0', 0, 0, -4396.8125, 248.7621612548828125, 39.26578903198242187, 1.378809213638305664, 0, 0, 0.636077880859375, 0.771624863147735595, 120, 255, 1, 46366), -- Bat02 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+23, 180427, 1, 357, 1099, '0', 0, 0, -4396.87841796875, 248.67535400390625, 34.41941452026367187, 4.223697185516357421, 0, 0, -0.85716724395751953, 0.515038192272186279, 120, 255, 1, 46366), -- Bat02 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+24, 180427, 1, 357, 1099, '0', 0, 0, -4396.6474609375, 248.642364501953125, 34.24795150756835937, 5.777040958404541015, 0, 0, -0.25037956237792968, 0.968147754669189453, 120, 255, 1, 46366), -- Bat02 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+25, 180427, 1, 357, 1099, '0', 0, 0, -4396.6318359375, 248.407989501953125, 35.87905502319335937, 0.645771682262420654, 0, 0, 0.317304611206054687, 0.948323667049407958, 120, 255, 1, 46366), -- Bat02 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+26, 180427, 1, 357, 1099, '0', 0, 0, -4395.5, 244.375, 33.37169647216796875, 0.767943859100341796, 0, 0, 0.374606132507324218, 0.927184045314788818, 120, 255, 1, 46366), -- Bat02 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+27, 180471, 1, 357, 1099, '0', 0, 0, -4434.3212890625, 252.4461822509765625, 44.89723587036132812, 2.234017848968505859, 0, 0, 0.898793220520019531, 0.438372820615768432, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+28, 180471, 1, 357, 1099, '0', 0, 0, -4453.4306640625, 253.092010498046875, 42.783599853515625, 1.186823248863220214, 0, 0, 0.559192657470703125, 0.829037725925445556, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+29, 180471, 1, 357, 1099, '0', 0, 0, -4437.2431640625, 258.039947509765625, 44.89723587036132812, 1.937312245368957519, 0, 0, 0.824125289916992187, 0.566407561302185058, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+30, 180471, 1, 357, 1099, '0', 0, 0, -4462.67529296875, 248.451385498046875, 42.78349685668945312, 6.14356088638305664, 0, 0, -0.06975555419921875, 0.997564136981964111, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+31, 180471, 1, 357, 1099, '0', 0, 0, -4470.38916015625, 245.09722900390625, 42.78286361694335937, 1.378809213638305664, 0, 0, 0.636077880859375, 0.771624863147735595, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+32, 180472, 1, 357, 1099, '0', 0, 0, -4433.830078125, 256.17535400390625, 46.35556793212890625, 0.558503925800323486, 0, 0, 0.275636672973632812, 0.961261868476867675, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+33, 180472, 1, 357, 1099, '0', 0, 0, -4441.4619140625, 263.36285400390625, 46.86680221557617187, 0.506144583225250244, 0, 0, 0.250379562377929687, 0.968147754669189453, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+34, 180472, 1, 357, 1099, '0', 0, 0, -4450.484375, 246.7708282470703125, 46.35454177856445312, 0.715584874153137207, 0, 0, 0.350207328796386718, 0.936672210693359375, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+35, 180472, 1, 357, 1099, '0', 0, 0, -4432.60400390625, 245.640625, 46.864013671875, 0.523597896099090576, 0, 0, 0.258818626403808593, 0.965925931930541992, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+36, 180472, 1, 357, 1099, '0', 0, 0, -4467.49072265625, 239.535400390625, 46.42402267456054687, 0.802850961685180664, 0, 0, 0.390730857849121093, 0.920504987239837646, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+37, 180523, 1, 357, 1099, '0', 0, 0, -4443.63525390625, 245.328125, 39.38525009155273437, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 120, 255, 1, 46366), -- Apple Bob (Area: Camp Mojache - Difficulty: 0)
+(@OGUID+38, 190088, 1, 357, 1099, '0', 0, 0, -4458.26318359375, 241.1407928466796875, 39.10747146606445312, 2.513273954391479492, 0, 0, 0.951056480407714843, 0.309017121791839599, 120, 255, 1, 46366); -- Candy Bucket (Area: Camp Mojache - Difficulty: 0)
+
+-- Event spawns
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+38;
+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);
diff --git a/sql/updates/world/master/2022_11_12_08_world_feralas_stonemaul_hold.sql b/sql/updates/world/master/2022_11_12_08_world_feralas_stonemaul_hold.sql
new file mode 100644
index 00000000000..5a93d24919e
--- /dev/null
+++ b/sql/updates/world/master/2022_11_12_08_world_feralas_stonemaul_hold.sql
@@ -0,0 +1,117 @@
+SET @CGUID := 396413;
+SET @OGUID := 247755;
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=46366 WHERE `entry`=208161; -- Candy Bucket
+
+UPDATE `gameobject_template_addon` SET `faction`=1735 WHERE `entry`=208161; -- Candy Bucket
+
+-- Quests
+UPDATE `quest_offer_reward` SET `VerifiedBuild`=46366 WHERE `ID`=28998;
+
+DELETE FROM `gameobject_queststarter` WHERE `id`=208161;
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(208161, 28998, 46366);
+
+UPDATE `gameobject_questender` SET `VerifiedBuild`=46366 WHERE (`id`=208161 AND `quest`=28998);
+
+DELETE FROM `game_event_gameobject_quest` WHERE `id`=208161;
+
+-- Creature spawns
+DELETE FROM `creature` WHERE `guid`=@CGUID+0;
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+(@CGUID+0, 22816, 1, 357, 5003, '0', 0, 0, 0, 0, -4542.94482421875, 1880.18115234375, 99.7766265869140625, 5.875472545623779296, 120, 10, 0, 188, 0, 1, 0, 0, 0, 46366); -- Black Cat (Area: Stonemaul Hold - Difficulty: 0) (possible waypoints or random movement)
+
+-- Old gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 227638 AND 227677;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 227638 AND 227677;
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+38;
+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, 357, 5003, '0', 0, 0, -4591.658203125, 1825.3958740234375, 91.31784820556640625, 4.9218292236328125, 0, 0, -0.62932014465332031, 0.77714616060256958, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+1, 180406, 1, 357, 5003, '0', 0, 0, -4590.88037109375, 1845.5972900390625, 91.43405914306640625, 5.009094715118408203, 0, 0, -0.59482288360595703, 0.80385679006576538, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+2, 180407, 1, 357, 5003, '0', 0, 0, -4604.9306640625, 1906.4896240234375, 107.8489837646484375, 1.396261811256408691, 0, 0, 0.642786979675292968, 0.766044974327087402, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+3, 180407, 1, 357, 5003, '0', 0, 0, -4598.8349609375, 1907.1614990234375, 107.8489837646484375, 5.84685373306274414, 0, 0, -0.21643924713134765, 0.976296067237854003, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+4, 180407, 1, 357, 5003, '0', 0, 0, -4602.29150390625, 1908.24658203125, 107.8489837646484375, 0.558503925800323486, 0, 0, 0.275636672973632812, 0.961261868476867675, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+5, 180407, 1, 357, 5003, '0', 0, 0, -4580.9443359375, 1806.470458984375, 91.63939666748046875, 5.811946868896484375, 0, 0, -0.2334451675415039, 0.972369968891143798, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+6, 180407, 1, 357, 5003, '0', 0, 0, -4575.92529296875, 1825.37158203125, 93.5705718994140625, 4.59021615982055664, 0, 0, -0.74895572662353515, 0.662620067596435546, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+7, 180408, 1, 357, 5003, '0', 0, 0, -4598.77978515625, 1907.24658203125, 109.4919891357421875, 6.12610626220703125, 0, 0, -0.07845878601074218, 0.996917366981506347, 120, 255, 1, 46366), -- G_WitchHat_01 (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+8, 180411, 1, 357, 5003, '0', 0, 0, -4576.39404296875, 1804.7603759765625, 96.112579345703125, 1.710421562194824218, 0, 0, 0.754709243774414062, 0.656059443950653076, 120, 255, 1, 46366), -- G_Ghost_01 (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+9, 180414, 1, 357, 5003, '0', 0, 0, -4601.42529296875, 1905.548583984375, 107.8489837646484375, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- Cauldron (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+10, 180415, 1, 357, 5003, '0', 0, 0, -4600.68408203125, 1902.79345703125, 107.8489837646484375, 1.902408957481384277, 0, 0, 0.814115524291992187, 0.580702960491180419, 120, 255, 1, 46366), -- CandleBlack01 (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+11, 180415, 1, 357, 5003, '0', 0, 0, -4597.9462890625, 1905.373291015625, 107.8489837646484375, 1.902408957481384277, 0, 0, 0.814115524291992187, 0.580702960491180419, 120, 255, 1, 46366), -- CandleBlack01 (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+12, 180415, 1, 357, 5003, '0', 0, 0, -4598.6943359375, 1903.8072509765625, 107.8489837646484375, 1.902408957481384277, 0, 0, 0.814115524291992187, 0.580702960491180419, 120, 255, 1, 46366), -- CandleBlack01 (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+13, 180415, 1, 357, 5003, '0', 0, 0, -4603.00341796875, 1903.1197509765625, 107.8489837646484375, 1.902408957481384277, 0, 0, 0.814115524291992187, 0.580702960491180419, 120, 255, 1, 46366), -- CandleBlack01 (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+14, 180415, 1, 357, 5003, '0', 0, 0, -4604.376953125, 1904.451416015625, 107.8489837646484375, 1.902408957481384277, 0, 0, 0.814115524291992187, 0.580702960491180419, 120, 255, 1, 46366), -- CandleBlack01 (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+15, 180426, 1, 357, 5003, '0', 0, 0, -4600.5224609375, 1907.09033203125, 107.8489837646484375, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- Bat01 (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+16, 180426, 1, 357, 5003, '0', 0, 0, -4599.515625, 1901.9097900390625, 104.3024215698242187, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- Bat01 (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+17, 180426, 1, 357, 5003, '0', 0, 0, -4605.9775390625, 1846.407958984375, 103.9200668334960937, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- Bat01 (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+18, 180426, 1, 357, 5003, '0', 0, 0, -4604.4443359375, 1834.3697509765625, 98.08591461181640625, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- Bat01 (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+19, 180426, 1, 357, 5003, '0', 0, 0, -4617.6630859375, 1821.4913330078125, 99.1563873291015625, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- Bat01 (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+20, 180427, 1, 357, 5003, '0', 0, 0, -4593.34033203125, 1897.4635009765625, 107.7414627075195312, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- Bat02 (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+21, 180427, 1, 357, 5003, '0', 0, 0, -4601.17724609375, 1905.6458740234375, 107.8489837646484375, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- Bat02 (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+22, 180427, 1, 357, 5003, '0', 0, 0, -4600.939453125, 1908.1978759765625, 107.8489837646484375, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- Bat02 (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+23, 180427, 1, 357, 5003, '0', 0, 0, -4627.77587890625, 1851.55908203125, 100.613037109375, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- Bat02 (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+24, 180427, 1, 357, 5003, '0', 0, 0, -4614.40087890625, 1836.5850830078125, 97.69387054443359375, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- Bat02 (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+25, 180427, 1, 357, 5003, '0', 0, 0, -4608.4130859375, 1819.1771240234375, 100.5956573486328125, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- Bat02 (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+26, 180471, 1, 357, 5003, '0', 0, 0, -4570.12353515625, 1830.69970703125, 95.80023956298828125, 5.305802345275878906, 0, 0, -0.46947097778320312, 0.882947921752929687, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+27, 180471, 1, 357, 5003, '0', 0, 0, -4571.9150390625, 1835.736083984375, 96.66376495361328125, 5.131268978118896484, 0, 0, -0.54463863372802734, 0.838670849800109863, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+28, 180471, 1, 357, 5003, '0', 0, 0, -4571.28466796875, 1834.2742919921875, 96.41864776611328125, 5.131268978118896484, 0, 0, -0.54463863372802734, 0.838670849800109863, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+29, 180471, 1, 357, 5003, '0', 0, 0, -4570.62158203125, 1832.4930419921875, 96.16712188720703125, 5.166176319122314453, 0, 0, -0.52991867065429687, 0.84804844856262207, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+30, 180471, 1, 357, 5003, '0', 0, 0, -4569.6943359375, 1829.32470703125, 95.34833526611328125, 5.235987663269042968, 0, 0, -0.5, 0.866025388240814208, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+31, 180472, 1, 357, 5003, '0', 0, 0, -4572.625, 1837.125, 98.009033203125, 3.612837791442871093, 0, 0, -0.97236919403076171, 0.233448356389999389, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+32, 180523, 1, 357, 5003, '0', 0, 0, -4575.033203125, 1836.626708984375, 89.51651763916015625, 5.759587764739990234, 0, 0, -0.25881862640380859, 0.965925931930541992, 120, 255, 1, 46366), -- Apple Bob (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+33, 185436, 1, 357, 5003, '0', 0, 0, -4601.0869140625, 1905.65283203125, 108.3902816772460937, 3.22885894775390625, 0, 0, -0.99904823303222656, 0.043619260191917419, 120, 255, 1, 46366), -- Sitting Skeleton 03 (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+34, 185437, 1, 357, 5003, '0', 0, 0, -4599.76416015625, 1905.2396240234375, 107.8489837646484375, 1.117009282112121582, 0, 0, 0.529918670654296875, 0.84804844856262207, 120, 255, 1, 46366), -- Laying Skeleton 01 (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+35, 185438, 1, 357, 5003, '0', 0, 0, -4601.46337890625, 1905.9097900390625, 108.3793869018554687, 6.003933906555175781, 0, 0, -0.13917255401611328, 0.990268170833587646, 120, 255, 1, 46366), -- Sitting Skeleton 04 (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+36, 185454, 1, 357, 5003, '0', 0, 0, -4603.91845703125, 1905.8541259765625, 108.213836669921875, 2.897245407104492187, 0, 0, 0.99254608154296875, 0.121869951486587524, 120, 255, 1, 46366), -- Laying Skeleton 02 (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+37, 185455, 1, 357, 5003, '0', 0, 0, -4601.94970703125, 1904.736083984375, 107.8489837646484375, 5.585053920745849609, 0, 0, -0.34202003479003906, 0.939692676067352294, 120, 255, 1, 46366), -- Laying Skeleton 03 (Area: Stonemaul Hold - Difficulty: 0)
+(@OGUID+38, 208161, 1, 357, 5003, '0', 0, 0, -4573.892578125, 1829.4791259765625, 89.5510406494140625, 4.258606910705566406, 0, 0, -0.84804725646972656, 0.529920578002929687, 120, 255, 1, 46366); -- Candy Bucket (Area: Stonemaul Hold - Difficulty: 0)
+
+-- Event spawns
+DELETE FROM `game_event_creature` WHERE `eventEntry`=12 AND `guid`=@CGUID+0;
+INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES
+(12, @CGUID+0);
+
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+38;
+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);
diff --git a/sql/updates/world/master/2022_11_12_09_world_feralas_dreamers_rest.sql b/sql/updates/world/master/2022_11_12_09_world_feralas_dreamers_rest.sql
new file mode 100644
index 00000000000..baed31f7593
--- /dev/null
+++ b/sql/updates/world/master/2022_11_12_09_world_feralas_dreamers_rest.sql
@@ -0,0 +1,93 @@
+SET @CGUID := 396414;
+SET @OGUID := 247794;
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=46366 WHERE `entry`=208116; -- Candy Bucket
+
+UPDATE `gameobject_template_addon` SET `faction`=1732 WHERE `entry`=208116; -- Candy Bucket
+
+-- Quests
+DELETE FROM `quest_offer_reward` WHERE `ID`=28952;
+INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES
+(28952, 0, 0, 0, 0, 0, 0, 0, 0, 'Candy buckets like this are located in inns throughout the realms. Go ahead... take some!', 46366); -- Candy Bucket
+
+DELETE FROM `gameobject_queststarter` WHERE `id`=208116;
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(208116, 28952, 46366);
+
+UPDATE `gameobject_questender` SET `VerifiedBuild`=46366 WHERE (`id`=208116 AND `quest`=28952);
+
+DELETE FROM `game_event_gameobject_quest` WHERE `id`=208116;
+
+-- Creature spawns
+DELETE FROM `creature` WHERE `guid`=@CGUID+0;
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+(@CGUID+0, 22816, 1, 357, 5024, '0', 0, 0, 0, 0, -3147.169921875, 1888.8602294921875, 41.98286819458007812, 3.564326763153076171, 120, 10, 0, 188, 0, 1, 0, 0, 0, 46366); -- Black Cat (Area: Dreamer's Rest - Difficulty: 0)
+
+-- Old gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 227517 AND 227541;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 227517 AND 227541;
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+25;
+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, 357, 5024, '0', 0, 0, -3170.104248046875, 1924.513916015625, 45.38033676147460937, 1.029743075370788574, 0, 0, 0.492423057556152343, 0.870355963706970214, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Dreamer's Rest - Difficulty: 0)
+(@OGUID+1, 180405, 1, 357, 5024, '0', 0, 0, -3147.42529296875, 1943.9896240234375, 42.31151199340820312, 2.879789113998413085, 0, 0, 0.991444587707519531, 0.130528271198272705, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Dreamer's Rest - Difficulty: 0)
+(@OGUID+2, 180406, 1, 357, 5024, '0', 0, 0, -3160.413330078125, 1904.9566650390625, 45.49956130981445312, 3.769911527633666992, 0, 0, -0.95105648040771484, 0.309017121791839599, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Dreamer's Rest - Difficulty: 0)
+(@OGUID+3, 180407, 1, 357, 5024, '0', 0, 0, -3153.8056640625, 1919.3524169921875, 45.37310409545898437, 5.288348197937011718, 0, 0, -0.4771585464477539, 0.878817260265350341, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Dreamer's Rest - Difficulty: 0)
+(@OGUID+4, 180407, 1, 357, 5024, '0', 0, 0, -3174.65966796875, 1911.4774169921875, 45.38034439086914062, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Dreamer's Rest - Difficulty: 0)
+(@OGUID+5, 180408, 1, 357, 5024, '0', 0, 0, -3151.109375, 1925.923583984375, 48.33165359497070312, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 120, 255, 1, 46366), -- G_WitchHat_01 (Area: Dreamer's Rest - Difficulty: 0)
+(@OGUID+6, 180408, 1, 357, 5024, '0', 0, 0, -3158.53125, 1931.4896240234375, 48.53600311279296875, 1.518436193466186523, 0, 0, 0.6883544921875, 0.725374460220336914, 120, 255, 1, 46366), -- G_WitchHat_01 (Area: Dreamer's Rest - Difficulty: 0)
+(@OGUID+7, 180415, 1, 357, 5024, '0', 0, 0, -3175.892333984375, 1880.3819580078125, 46.98336029052734375, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- CandleBlack01 (Area: Dreamer's Rest - Difficulty: 0)
+(@OGUID+8, 180415, 1, 357, 5024, '0', 0, 0, -3184.838623046875, 1884.3194580078125, 47.96312332153320312, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- CandleBlack01 (Area: Dreamer's Rest - Difficulty: 0)
+(@OGUID+9, 180415, 1, 357, 5024, '0', 0, 0, -3188.053955078125, 1880.8853759765625, 48.4252471923828125, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- CandleBlack01 (Area: Dreamer's Rest - Difficulty: 0)
+(@OGUID+10, 180415, 1, 357, 5024, '0', 0, 0, -3179.022705078125, 1879.84375, 47.74272537231445312, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- CandleBlack01 (Area: Dreamer's Rest - Difficulty: 0)
+(@OGUID+11, 180415, 1, 357, 5024, '0', 0, 0, -3180.866455078125, 1878.373291015625, 48.20755767822265625, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- CandleBlack01 (Area: Dreamer's Rest - Difficulty: 0)
+(@OGUID+12, 180415, 1, 357, 5024, '0', 0, 0, -3185.98779296875, 1879.8021240234375, 48.4252471923828125, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- CandleBlack01 (Area: Dreamer's Rest - Difficulty: 0)
+(@OGUID+13, 180415, 1, 357, 5024, '0', 0, 0, -3187.645751953125, 1884.8629150390625, 48.33615875244140625, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- CandleBlack01 (Area: Dreamer's Rest - Difficulty: 0)
+(@OGUID+14, 180415, 1, 357, 5024, '0', 0, 0, -3190.59375, 1885.513916015625, 48.90917205810546875, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- CandleBlack01 (Area: Dreamer's Rest - Difficulty: 0)
+(@OGUID+15, 180415, 1, 357, 5024, '0', 0, 0, -3193.39404296875, 1890.9305419921875, 50.51607131958007812, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 120, 255, 1, 46366), -- CandleBlack01 (Area: Dreamer's Rest - Difficulty: 0)
+(@OGUID+16, 180415, 1, 357, 5024, '0', 0, 0, -3194.835205078125, 1891.8819580078125, 50.68331146240234375, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- CandleBlack01 (Area: Dreamer's Rest - Difficulty: 0)
+(@OGUID+17, 180415, 1, 357, 5024, '0', 0, 0, -3193.578125, 1891.1822509765625, 50.51610946655273437, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- CandleBlack01 (Area: Dreamer's Rest - Difficulty: 0)
+(@OGUID+18, 180415, 1, 357, 5024, '0', 0, 0, -3190.802001953125, 1881.4010009765625, 48.71342849731445312, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- CandleBlack01 (Area: Dreamer's Rest - Difficulty: 0)
+(@OGUID+19, 180425, 1, 357, 5024, '0', 0, 0, -3199.4931640625, 1897.8663330078125, 51.62615966796875, 0.663223206996917724, 0, 0, 0.325567245483398437, 0.945518851280212402, 120, 255, 1, 46366), -- SkullCandle01 (Area: Dreamer's Rest - Difficulty: 0)
+(@OGUID+20, 180426, 1, 357, 5024, '0', 0, 0, -3147.08154296875, 1927.532958984375, 44.22612380981445312, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- Bat01 (Area: Dreamer's Rest - Difficulty: 0)
+(@OGUID+21, 180426, 1, 357, 5024, '0', 0, 0, -3201.84716796875, 1897.6302490234375, 49.33378982543945312, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- Bat01 (Area: Dreamer's Rest - Difficulty: 0)
+(@OGUID+22, 180426, 1, 357, 5024, '0', 0, 0, -3201.147705078125, 1890.095458984375, 56.04289627075195312, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- Bat01 (Area: Dreamer's Rest - Difficulty: 0)
+(@OGUID+23, 180427, 1, 357, 5024, '0', 0, 0, -3189.579833984375, 1892.361083984375, 57.13821029663085937, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- Bat02 (Area: Dreamer's Rest - Difficulty: 0)
+(@OGUID+24, 180427, 1, 357, 5024, '0', 0, 0, -3141.46875, 1940.5972900390625, 41.66498565673828125, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- Bat02 (Area: Dreamer's Rest - Difficulty: 0)
+(@OGUID+25, 208116, 1, 357, 5024, '0', 0, 0, -3192.08154296875, 1892.1614990234375, 49.33295822143554687, 2.408554315567016601, 0, 0, 0.933580398559570312, 0.358368009328842163, 120, 255, 1, 46366); -- Candy Bucket (Area: Dreamer's Rest - Difficulty: 0)
+
+-- Event spawns
+DELETE FROM `game_event_creature` WHERE `eventEntry`=12 AND `guid`=@CGUID+0;
+INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES
+(12, @CGUID+0);
+
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+25;
+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);
diff --git a/sql/updates/world/master/2022_11_12_10_world_feralas_feathermoon_stronghold.sql b/sql/updates/world/master/2022_11_12_10_world_feralas_feathermoon_stronghold.sql
new file mode 100644
index 00000000000..8ea29de46ac
--- /dev/null
+++ b/sql/updates/world/master/2022_11_12_10_world_feralas_feathermoon_stronghold.sql
@@ -0,0 +1,185 @@
+SET @OGUID := 247820;
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=46366 WHERE `entry`=190053; -- Candy Bucket
+
+UPDATE `gameobject_template_addon` SET `faction`=1732 WHERE `entry`=190053; -- Candy Bucket
+
+-- Quests
+UPDATE `quest_offer_reward` SET `VerifiedBuild`=46366 WHERE `ID`=12350;
+
+DELETE FROM `gameobject_queststarter` WHERE `id`=190053;
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(190053, 12350, 46366);
+
+UPDATE `gameobject_questender` SET `VerifiedBuild`=46366 WHERE (`id`=190053 AND `quest`=12350);
+
+DELETE FROM `game_event_gameobject_quest` WHERE `id`=190053;
+
+-- Old gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 227542 AND 227598;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 227542 AND 227598;
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+77;
+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, 357, 5072, '0', 0, 0, -4453.125, 2203.28466796875, 27.67428016662597656, 0.383971005678176879, 0, 0, 0.190808296203613281, 0.981627285480499267, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+1, 180405, 1, 357, 5072, '0', 0, 0, -4485.23095703125, 2214.37841796875, 30.59831428527832031, 5.131268978118896484, 0, 0, -0.54463863372802734, 0.838670849800109863, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+2, 180405, 1, 357, 5072, '0', 0, 0, -4444.283203125, 2227.057373046875, 30.59831428527832031, 2.024578809738159179, 0, 0, 0.848047256469726562, 0.529920578002929687, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+3, 180405, 1, 357, 5072, '0', 0, 0, -4443.15478515625, 2269.486083984375, 30.59831047058105468, 2.024578809738159179, 0, 0, 0.848047256469726562, 0.529920578002929687, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+4, 180405, 1, 357, 5072, '0', 0, 0, -4484.11474609375, 2256.807373046875, 30.59831428527832031, 5.131268978118896484, 0, 0, -0.54463863372802734, 0.838670849800109863, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+5, 180405, 1, 357, 5072, '0', 0, 0, -4261.2412109375, 2270.87841796875, 11.45969963073730468, 2.024578809738159179, 0, 0, 0.848047256469726562, 0.529920578002929687, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+6, 180405, 1, 357, 5072, '0', 0, 0, -4261.68603515625, 2260.98779296875, 11.48336124420166015, 2.024578809738159179, 0, 0, 0.848047256469726562, 0.529920578002929687, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+7, 180406, 1, 357, 5072, '0', 0, 0, -4443.77099609375, 2241.444580078125, 30.59831428527832031, 1.989672422409057617, 0, 0, 0.838669776916503906, 0.544640243053436279, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+8, 180406, 1, 357, 5072, '0', 0, 0, -4484.62353515625, 2242.423583984375, 30.59831428527832031, 5.096362113952636718, 0, 0, -0.55919265747070312, 0.829037725925445556, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+9, 180406, 1, 357, 5072, '0', 0, 0, -4443.16845703125, 2278.970458984375, 27.67427444458007812, 3.577930212020874023, 0, 0, -0.97629547119140625, 0.216442063450813293, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+10, 180406, 1, 357, 5072, '0', 0, 0, -4320.01025390625, 2279.197998046875, 9.409993171691894531, 1.675513744354248046, 0, 0, 0.743144035339355468, 0.669131457805633544, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+11, 180406, 1, 357, 5072, '0', 0, 0, -4287.38525390625, 2271.11279296875, 9.427296638488769531, 2.199114561080932617, 0, 0, 0.8910064697265625, 0.453990638256072998, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+12, 180407, 1, 357, 5072, '0', 0, 0, -4444.67041015625, 2202.947998046875, 27.67427635192871093, 0.314158439636230468, 0, 0, 0.156434059143066406, 0.987688362598419189, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+13, 180407, 1, 357, 5072, '0', 0, 0, -4444.37841796875, 2214.704833984375, 30.59831428527832031, 1.919861555099487304, 0, 0, 0.819151878356933593, 0.573576688766479492, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+14, 180407, 1, 357, 5072, '0', 0, 0, -4443.705078125, 2256.303955078125, 30.59831047058105468, 1.972219824790954589, 0, 0, 0.83388519287109375, 0.55193793773651123, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+15, 180407, 1, 357, 5072, '0', 0, 0, -4484.68212890625, 2227.56591796875, 30.59831428527832031, 5.078907966613769531, 0, 0, -0.56640625, 0.824126183986663818, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+16, 180407, 1, 357, 5072, '0', 0, 0, -4316.41162109375, 2233.302001953125, 9.409993171691894531, 3.316144466400146484, 0, 0, -0.99619388580322265, 0.087165042757987976, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+17, 180407, 1, 357, 5072, '0', 0, 0, -4451.6962890625, 2279.310791015625, 27.67428016662597656, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+18, 180407, 1, 357, 5072, '0', 0, 0, -4299.96728515625, 2213.692626953125, 9.409993171691894531, 3.490667104721069335, 0, 0, -0.98480701446533203, 0.173652306199073791, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+19, 180407, 1, 357, 5072, '0', 0, 0, -4484.0224609375, 2269.163330078125, 30.59831047058105468, 5.026549339294433593, 0, 0, -0.5877847671508789, 0.809017360210418701, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+20, 180411, 1, 357, 5072, '0', 0, 0, -4441.88037109375, 2202.59375, 28.79986190795898437, 1.745326757431030273, 0, 0, 0.766043663024902343, 0.642788589000701904, 120, 255, 1, 46366), -- G_Ghost_01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+21, 180411, 1, 357, 5072, '0', 0, 0, -4380.640625, 2224.911376953125, 19.1699066162109375, 5.445427894592285156, 0, 0, -0.40673637390136718, 0.913545548915863037, 120, 255, 1, 46366), -- G_Ghost_01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+22, 180411, 1, 357, 5072, '0', 0, 0, -4440.63037109375, 2279.54345703125, 29.11422348022460937, 4.084071159362792968, 0, 0, -0.8910064697265625, 0.453990638256072998, 120, 255, 1, 46366), -- G_Ghost_01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+23, 180415, 1, 357, 5072, '0', 0, 0, -4380.4375, 2229.67529296875, 9.981640815734863281, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- CandleBlack01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+24, 180415, 1, 357, 5072, '0', 0, 0, -4383.60400390625, 2224.28466796875, 11.67404556274414062, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- CandleBlack01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+25, 180415, 1, 357, 5072, '0', 0, 0, -4374.7900390625, 2222.15625, 14.13726520538330078, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- CandleBlack01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+26, 180415, 1, 357, 5072, '0', 0, 0, -4384.97412109375, 2226.182373046875, 14.65523624420166015, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- CandleBlack01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+27, 180415, 1, 357, 5072, '0', 0, 0, -4379.408203125, 2218.739501953125, 14.12955379486083984, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- CandleBlack01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+28, 180415, 1, 357, 5072, '0', 0, 0, -4377.19970703125, 2225.494873046875, 13.05966091156005859, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- CandleBlack01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+29, 180415, 1, 357, 5072, '0', 0, 0, -4379.07275390625, 2227.8525390625, 11.60944080352783203, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- CandleBlack01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+30, 180415, 1, 357, 5072, '0', 0, 0, -4381.8525390625, 2221.942626953125, 13.07179832458496093, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- CandleBlack01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+31, 180415, 1, 357, 5072, '0', 0, 0, -4364.86279296875, 2255.05029296875, 11.46012783050537109, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- CandleBlack01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+32, 180415, 1, 357, 5072, '0', 0, 0, -4366.330078125, 2262.814208984375, 11.33212757110595703, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- CandleBlack01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+33, 180415, 1, 357, 5072, '0', 0, 0, -4273.314453125, 2246.31591796875, 10.75973987579345703, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- CandleBlack01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+34, 180415, 1, 357, 5072, '0', 0, 0, -4272.63037109375, 2247.595458984375, 10.59279823303222656, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- CandleBlack01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+35, 180425, 1, 357, 5072, '0', 0, 0, -4281.4130859375, 2295.5869140625, 10.9051361083984375, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 120, 255, 1, 46366), -- SkullCandle01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+36, 180426, 1, 357, 5072, '0', 0, 0, -4439.59716796875, 2181.4775390625, 28.31475257873535156, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- Bat01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+37, 180426, 1, 357, 5072, '0', 0, 0, -4467.83349609375, 2176.427001953125, 24.14411354064941406, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- Bat01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+38, 180426, 1, 357, 5072, '0', 0, 0, -4403.34375, 2244.03466796875, 12.73984718322753906, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- Bat01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+39, 180426, 1, 357, 5072, '0', 0, 0, -4409.203125, 2248.611083984375, 12.73914527893066406, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- Bat01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+40, 180426, 1, 357, 5072, '0', 0, 0, -4408.203125, 2237.9775390625, 12.74163246154785156, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- Bat01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+41, 180426, 1, 357, 5072, '0', 0, 0, -4301.2255859375, 2246.19970703125, 9.409993171691894531, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- Bat01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+42, 180426, 1, 357, 5072, '0', 0, 0, -4301.02587890625, 2295.10595703125, 21.73912429809570312, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- Bat01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+43, 180426, 1, 357, 5072, '0', 0, 0, -4300.0869140625, 2271.10595703125, 31.24988746643066406, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- Bat01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+44, 180427, 1, 357, 5072, '0', 0, 0, -4472.5537109375, 2176.92529296875, 17.91554641723632812, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- Bat02 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+45, 180427, 1, 357, 5072, '0', 0, 0, -4457.65087890625, 2171.522705078125, 21.59903717041015625, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- Bat02 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+46, 180427, 1, 357, 5072, '0', 0, 0, -4467.6005859375, 2172.505126953125, 17.41539573669433593, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- Bat02 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+47, 180427, 1, 357, 5072, '0', 0, 0, -4390.75537109375, 2254.817626953125, 12.74164009094238281, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- Bat02 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+48, 180427, 1, 357, 5072, '0', 0, 0, -4400.265625, 2235.564208984375, 12.80641365051269531, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- Bat02 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+49, 180427, 1, 357, 5072, '0', 0, 0, -4370.609375, 2257.15625, 9.046797752380371093, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- Bat02 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+50, 180427, 1, 357, 5072, '0', 0, 0, -4300.67724609375, 2270.682373046875, 36.41701507568359375, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- Bat02 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+51, 180427, 1, 357, 5072, '0', 0, 0, -4300.4443359375, 2271.770751953125, 30.54913330078125, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- Bat02 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+52, 180427, 1, 357, 5072, '0', 0, 0, -4300.533203125, 2271.5869140625, 31.17810821533203125, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- Bat02 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+53, 180427, 1, 357, 5072, '0', 0, 0, -4300.04150390625, 2273.116455078125, 20.05820465087890625, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- Bat02 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+54, 180471, 1, 357, 5072, '0', 0, 0, -4461.7724609375, 2205.720458984375, 34.4166259765625, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+55, 180471, 1, 357, 5072, '0', 0, 0, -4451.64599609375, 2205.185791015625, 34.47686767578125, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+56, 180471, 1, 357, 5072, '0', 0, 0, -4458.16650390625, 2205.56591796875, 34.42998123168945312, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+57, 180471, 1, 357, 5072, '0', 0, 0, -4448.20654296875, 2205.475830078125, 35.03975296020507812, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+58, 180471, 1, 357, 5072, '0', 0, 0, -4466.5556640625, 2205.7744140625, 34.430633544921875, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+59, 180471, 1, 357, 5072, '0', 0, 0, -4454.830078125, 2205.317626953125, 34.49394607543945312, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+60, 180471, 1, 357, 5072, '0', 0, 0, -4473.25341796875, 2205.904541015625, 34.36895751953125, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+61, 180471, 1, 357, 5072, '0', 0, 0, -4479.87841796875, 2205.725830078125, 34.927734375, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+62, 180471, 1, 357, 5072, '0', 0, 0, -4470.109375, 2205.92529296875, 34.35744094848632812, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+63, 180471, 1, 357, 5072, '0', 0, 0, -4477.04541015625, 2205.7744140625, 34.56785964965820312, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+64, 180471, 1, 357, 5072, '0', 0, 0, -4449.7099609375, 2277.645751953125, 34.42377853393554687, 4.869470596313476562, 0, 0, -0.64944744110107421, 0.760406434535980224, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+65, 180471, 1, 357, 5072, '0', 0, 0, -4446.87353515625, 2277.765625, 34.42377853393554687, 4.869470596313476562, 0, 0, -0.64944744110107421, 0.760406434535980224, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+66, 180471, 1, 357, 5072, '0', 0, 0, -4464.97412109375, 2277.298583984375, 34.42377853393554687, 4.869470596313476562, 0, 0, -0.64944744110107421, 0.760406434535980224, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+67, 180471, 1, 357, 5072, '0', 0, 0, -4468.58154296875, 2277.36279296875, 34.42377853393554687, 4.869470596313476562, 0, 0, -0.64944744110107421, 0.760406434535980224, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+68, 180471, 1, 357, 5072, '0', 0, 0, -4460.1962890625, 2277.373291015625, 34.42377853393554687, 4.869470596313476562, 0, 0, -0.64944744110107421, 0.760406434535980224, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+69, 180471, 1, 357, 5072, '0', 0, 0, -4453.49462890625, 2277.411376953125, 34.42377853393554687, 4.869470596313476562, 0, 0, -0.64944744110107421, 0.760406434535980224, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+70, 180471, 1, 357, 5072, '0', 0, 0, -4471.91845703125, 2277.522705078125, 34.42377853393554687, 4.869470596313476562, 0, 0, -0.64944744110107421, 0.760406434535980224, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+71, 180471, 1, 357, 5072, '0', 0, 0, -4456.6337890625, 2277.3125, 34.42377853393554687, 4.869470596313476562, 0, 0, -0.64944744110107421, 0.760406434535980224, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+72, 180471, 1, 357, 5072, '0', 0, 0, -4475.11279296875, 2277.572998046875, 34.42377853393554687, 4.869470596313476562, 0, 0, -0.64944744110107421, 0.760406434535980224, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+73, 180471, 1, 357, 5072, '0', 0, 0, -4478.626953125, 2277.5625, 34.42377853393554687, 4.869470596313476562, 0, 0, -0.64944744110107421, 0.760406434535980224, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+74, 180472, 1, 357, 5072, '0', 0, 0, -4464.1787109375, 2206.029541015625, 35.48272705078125, 4.660029888153076171, 0, 0, -0.72537422180175781, 0.688354730606079101, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+75, 180472, 1, 357, 5072, '0', 0, 0, -4462.84033203125, 2276.890625, 35.4613800048828125, 1.762782454490661621, 0, 0, 0.771624565124511718, 0.636078238487243652, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+76, 190053, 1, 357, 5072, '0', 0, 0, -4460.68212890625, 2221.84375, 27.67427253723144531, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 120, 255, 1, 46366), -- Candy Bucket (Area: Feathermoon Stronghold - Difficulty: 0)
+(@OGUID+77, 207941, 1, 357, 5072, '0', 0, 0, -4300.67529296875, 2269.80908203125, 37.58877182006835937, 3.420850038528442382, 0, 0, -0.99026775360107421, 0.139175355434417724, 120, 255, 1, 46366); -- G_WitchHat_01 scale 2.0 (Area: Feathermoon Stronghold - Difficulty: 0)
+
+-- Event spawns
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+77;
+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),
+(12, @OGUID+62),
+(12, @OGUID+63),
+(12, @OGUID+64),
+(12, @OGUID+65),
+(12, @OGUID+66),
+(12, @OGUID+67),
+(12, @OGUID+68),
+(12, @OGUID+69),
+(12, @OGUID+70),
+(12, @OGUID+71),
+(12, @OGUID+72),
+(12, @OGUID+73),
+(12, @OGUID+74),
+(12, @OGUID+75),
+(12, @OGUID+76),
+(12, @OGUID+77);