DB/DustwallowMarsh: Added Hallows End spawns

Ref #28449

3 files changed, 201 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_11_12_00_world_dustwallow_marsh_brackenwall_village.sql b/sql/updates/world/master/2022_11_12_00_world_dustwallow_marsh_brackenwall_village.sql
new file mode 100644
index 00000000000..2ff2547fcf4
--- /dev/null
+++ b/sql/updates/world/master/2022_11_12_00_world_dustwallow_marsh_brackenwall_village.sql
@@ -0,0 +1,33 @@
+SET @OGUID := 247489;
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=46366 WHERE `entry`=190085; -- Candy Bucket
+
+UPDATE `gameobject_template_addon` SET `faction`=1735 WHERE `entry`=190085; -- Candy Bucket
+
+-- Quests
+UPDATE `quest_offer_reward` SET `VerifiedBuild`=46366 WHERE `ID`=12383;
+
+DELETE FROM `gameobject_queststarter` WHERE `id`=190085;
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(190085, 12383, 46366);
+
+UPDATE `gameobject_questender` SET `VerifiedBuild`=46366 WHERE (`id`=190085 AND `quest`=12383);
+
+DELETE FROM `game_event_gameobject_quest` WHERE `id`=190085;
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+3;
+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, 180407, 1, 15, 496, '0', 0, 0, -3169.844482421875, -2901.30712890625, 39.4384307861328125, 1.710421562194824218, 0, 0, 0.754709243774414062, 0.656059443950653076, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Brackenwall Village - Difficulty: 0)
+(@OGUID+1, 180472, 1, 15, 496, '0', 0, 0, -3170.10498046875, -2909.896484375, 43.365447998046875, 0.645771682262420654, 0, 0, 0.317304611206054687, 0.948323667049407958, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Brackenwall Village - Difficulty: 0)
+(@OGUID+2, 180523, 1, 15, 496, '0', 0, 0, -3166.025390625, -2903.937744140625, 35.84684371948242187, 0.593410074710845947, 0, 0, 0.292370796203613281, 0.95630502700805664, 120, 255, 1, 46366), -- Apple Bob (Area: Brackenwall Village - Difficulty: 0)
+(@OGUID+3, 190085, 1, 15, 496, '0', 0, 0, -3168.76220703125, -2905.763916015625, 35.33940887451171875, 0.925023794174194335, 0, 0, 0.446197509765625, 0.894934535026550292, 120, 255, 1, 46366); -- Candy Bucket (Area: Brackenwall Village - Difficulty: 0)
+
+-- Event spawns
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+3;
+INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES
+(12, @OGUID+0),
+(12, @OGUID+1),
+(12, @OGUID+2),
+(12, @OGUID+3);
diff --git a/sql/updates/world/master/2022_11_12_01_world_dustwallow_marsh_theramore_isle.sql b/sql/updates/world/master/2022_11_12_01_world_dustwallow_marsh_theramore_isle.sql
new file mode 100644
index 00000000000..611a3192a5a
--- /dev/null
+++ b/sql/updates/world/master/2022_11_12_01_world_dustwallow_marsh_theramore_isle.sql
@@ -0,0 +1,123 @@
+SET @OGUID := 247493;
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=46366 WHERE `entry`=190052; -- Candy Bucket
+
+UPDATE `gameobject_template_addon` SET `faction`=1732 WHERE `entry`=190052; -- Candy Bucket
+
+-- Quests
+UPDATE `quest_offer_reward` SET `VerifiedBuild`=46366 WHERE `ID`=12349;
+
+DELETE FROM `gameobject_queststarter` WHERE `id`=190052;
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(190052, 12349, 46366);
+
+UPDATE `gameobject_questender` SET `VerifiedBuild`=46366 WHERE (`id`=190052 AND `quest`=12349);
+
+DELETE FROM `game_event_gameobject_quest` WHERE `id`=190052;
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+48;
+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, 15, 513, '0', 0, 0, -3631.729248046875, -4453.3525390625, 21.10228538513183593, 1.919861555099487304, 0, 0, 0.819151878356933593, 0.573576688766479492, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+1, 180405, 1, 15, 513, '0', 0, 0, -3612.563232421875, -4437.96240234375, 13.83451175689697265, 4.555310726165771484, 0, 0, -0.76040554046630859, 0.649448513984680175, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+2, 180405, 1, 15, 513, '0', 0, 0, -3611.4375, -4452.595703125, 14.24792003631591796, 5.131268978118896484, 0, 0, -0.54463863372802734, 0.838670849800109863, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+3, 180406, 1, 15, 513, '0', 0, 0, -3627.020751953125, -4444.7412109375, 15.35119438171386718, 3.560472726821899414, 0, 0, -0.97814750671386718, 0.207912087440490722, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+4, 180406, 1, 15, 513, '0', 0, 0, -3630.625, -4473.578125, 17.46675872802734375, 2.775068521499633789, 0, 0, 0.983254432678222656, 0.182238012552261352, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+5, 180407, 1, 15, 513, '0', 0, 0, -3642.072021484375, -4431.75244140625, 14.47140884399414062, 4.45059061050415039, 0, 0, -0.79335308074951171, 0.608761727809906005, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+6, 180407, 1, 15, 513, '0', 0, 0, -3625.09375, -4453.6025390625, 14.24792003631591796, 2.949595451354980468, 0, 0, 0.995395660400390625, 0.095851235091686248, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+7, 180410, 1, 15, 513, '0', 0, 0, -3632.208251953125, -4450.99853515625, 14.87111759185791015, 0.034906249493360519, 0, 0, 0.017452239990234375, 0.999847710132598876, 120, 255, 1, 46366), -- G_HangingSkeleton_01 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+8, 180410, 1, 15, 513, '0', 0, 0, -3623.673583984375, -4458.66162109375, 21.92173004150390625, 4.817109584808349609, 0, 0, -0.66913032531738281, 0.74314504861831665, 120, 255, 1, 46366), -- G_HangingSkeleton_01 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+9, 180410, 1, 15, 513, '0', 0, 0, -3608.30908203125, -4483.74462890625, 21.50506401062011718, 3.298687219619750976, 0, 0, -0.99691677093505859, 0.078466430306434631, 120, 255, 1, 46366), -- G_HangingSkeleton_01 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+10, 180411, 1, 15, 513, '0', 0, 0, -3627.19970703125, -4441.5693359375, 22.95201301574707031, 4.59021615982055664, 0, 0, -0.74895572662353515, 0.662620067596435546, 120, 255, 1, 46366), -- G_Ghost_01 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+11, 180411, 1, 15, 513, '0', 0, 0, -3626.59716796875, -4479.90283203125, 23.12809944152832031, 1.151916384696960449, 0, 0, 0.544638633728027343, 0.838670849800109863, 120, 255, 1, 46366), -- G_Ghost_01 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+12, 180411, 1, 15, 513, '0', 0, 0, -3612.854248046875, -4497.21875, 23.22773551940917968, 0.802850961685180664, 0, 0, 0.390730857849121093, 0.920504987239837646, 120, 255, 1, 46366), -- G_Ghost_01 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+13, 180415, 1, 15, 513, '0', 0, 0, -3620.71533203125, -4448.095703125, 22.00506210327148437, 4.852017402648925781, 0, 0, -0.65605831146240234, 0.754710197448730468, 120, 255, 1, 46366), -- CandleBlack01 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+14, 180415, 1, 15, 513, '0', 0, 0, -3623.03125, -4464.484375, 15.02731037139892578, 3.94444584846496582, 0, 0, -0.92050457000732421, 0.3907318115234375, 120, 255, 1, 46366), -- CandleBlack01 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+15, 180415, 1, 15, 513, '0', 0, 0, -3620.875, -4456.04541015625, 21.99117469787597656, 3.001946926116943359, 0, 0, 0.997563362121582031, 0.069766148924827575, 120, 255, 1, 46366), -- CandleBlack01 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+16, 180415, 1, 15, 513, '0', 0, 0, -3616.420166015625, -4458.5244140625, 14.29485797882080078, 5.410521507263183593, 0, 0, -0.42261791229248046, 0.906307935714721679, 120, 255, 1, 46366), -- CandleBlack01 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+17, 180415, 1, 15, 513, '0', 0, 0, -3627.55908203125, -4465.17041015625, 15.80945873260498046, 2.548179388046264648, 0, 0, 0.956304550170898437, 0.292372345924377441, 120, 255, 1, 46366), -- CandleBlack01 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+18, 180415, 1, 15, 513, '0', 0, 0, -3619.2744140625, -4464.470703125, 15.06637954711914062, 3.90954136848449707, 0, 0, -0.92718315124511718, 0.37460830807685852, 120, 255, 1, 46366), -- CandleBlack01 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+19, 180415, 1, 15, 513, '0', 0, 0, -3626.8056640625, -4471.50537109375, 18.72242546081542968, 1.134462952613830566, 0, 0, 0.537299156188964843, 0.843391716480255126, 120, 255, 1, 46366), -- CandleBlack01 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+20, 180425, 1, 15, 513, '0', 0, 0, -3630.8369140625, -4447.3212890625, 22.03284072875976562, 5.602506637573242187, 0, 0, -0.33380699157714843, 0.942641437053680419, 120, 255, 1, 46366), -- SkullCandle01 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+21, 180425, 1, 15, 513, '0', 0, 0, -3616.21875, -4460.80029296875, 14.32957935333251953, 2.740161895751953125, 0, 0, 0.979924201965332031, 0.199370384216308593, 120, 255, 1, 46366), -- SkullCandle01 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+22, 180425, 1, 15, 513, '0', 0, 0, -3624.5244140625, -4464.28466796875, 14.51707935333251953, 1.256635904312133789, 0, 0, 0.587784767150878906, 0.809017360210418701, 120, 255, 1, 46366), -- SkullCandle01 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+23, 180425, 1, 15, 513, '0', 0, 0, -3610.62841796875, -4457.09228515625, 22.19256210327148437, 2.740161895751953125, 0, 0, 0.979924201965332031, 0.199370384216308593, 120, 255, 1, 46366), -- SkullCandle01 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+24, 180471, 1, 15, 513, '0', 0, 0, -3636.017333984375, -4451.34033203125, 29.70451164245605468, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+25, 180471, 1, 15, 513, '0', 0, 0, -3619.197998046875, -4439.44287109375, 17.25803756713867187, 2.70525527000427246, 0, 0, 0.97629547119140625, 0.216442063450813293, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+26, 180471, 1, 15, 513, '0', 0, 0, -3635.140625, -4443.2412109375, 23.30061531066894531, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+27, 180471, 1, 15, 513, '0', 0, 0, -3635.920166015625, -4461.31591796875, 29.67303466796875, 4.834563255310058593, 0, 0, -0.66261959075927734, 0.748956084251403808, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+28, 180471, 1, 15, 513, '0', 0, 0, -3606.032958984375, -4443.96728515625, 23.21757316589355468, 2.740161895751953125, 0, 0, 0.979924201965332031, 0.199370384216308593, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+29, 180471, 1, 15, 513, '0', 0, 0, -3635.75, -4471.283203125, 29.63786888122558593, 4.834563255310058593, 0, 0, -0.66261959075927734, 0.748956084251403808, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+30, 180471, 1, 15, 513, '0', 0, 0, -3611.604248046875, -4439.25537109375, 17.27192115783691406, 3.194002151489257812, 0, 0, -0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+31, 180471, 1, 15, 513, '0', 0, 0, -3634.49658203125, -4478.5380859375, 23.29503059387207031, 5.305802345275878906, 0, 0, -0.46947097778320312, 0.882947921752929687, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+32, 180471, 1, 15, 513, '0', 0, 0, -3613.31591796875, -4472.37158203125, 27.64303970336914062, 2.775068521499633789, 0, 0, 0.983254432678222656, 0.182238012552261352, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+33, 180471, 1, 15, 513, '0', 0, 0, -3605.663330078125, -4476.21875, 23.28409767150878906, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+34, 180471, 1, 15, 513, '0', 0, 0, -3622.1806640625, -4495.97216796875, 23.23548698425292968, 5.340708732604980468, 0, 0, -0.45398998260498046, 0.891006767749786376, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+35, 180471, 1, 15, 513, '0', 0, 0, -3605.166748046875, -4495.48779296875, 23.25239753723144531, 0.593410074710845947, 0, 0, 0.292370796203613281, 0.95630502700805664, 120, 255, 1, 46366), -- HangingSkullLight01 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+36, 180472, 1, 15, 513, '0', 0, 0, -3615.40625, -4439.52783203125, 20.75999832153320312, 1.605701684951782226, 0, 0, 0.719339370727539062, 0.694658815860748291, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+37, 180472, 1, 15, 513, '0', 0, 0, -3634.829833984375, -4461.12158203125, 23.88734626770019531, 3.316144466400146484, 0, 0, -0.99619388580322265, 0.087165042757987976, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+38, 180472, 1, 15, 513, '0', 0, 0, -3619.921875, -4443.080078125, 23.87246131896972656, 1.623155713081359863, 0, 0, 0.725374221801757812, 0.688354730606079101, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+39, 180472, 1, 15, 513, '0', 0, 0, -3634.97216796875, -4448.7900390625, 23.87202262878417968, 3.263772249221801757, 0, 0, -0.99813461303710937, 0.061051756143569946, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+40, 180472, 1, 15, 513, '0', 0, 0, -3634.583251953125, -4472.9775390625, 23.87825202941894531, 3.43830275535583496, 0, 0, -0.98901557922363281, 0.147811368107795715, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+41, 180472, 1, 15, 513, '0', 0, 0, -3610.8681640625, -4442.9443359375, 23.86497688293457031, 1.675513744354248046, 0, 0, 0.743144035339355468, 0.669131457805633544, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+42, 180472, 1, 15, 513, '0', 0, 0, -3610.975830078125, -4460.67724609375, 18.439849853515625, 3.22885894775390625, 0, 0, -0.99904823303222656, 0.043619260191917419, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+43, 180472, 1, 15, 513, '0', 0, 0, -3622.447998046875, -4480.1494140625, 23.89584732055664062, 3.194002151489257812, 0, 0, -0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+44, 180472, 1, 15, 513, '0', 0, 0, -3606.166748046875, -4480.03125, 23.84830665588378906, 0.104719325900077819, 0, 0, 0.052335739135742187, 0.998629570007324218, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+45, 180472, 1, 15, 513, '0', 0, 0, -3605.4150390625, -4487.40478515625, 23.87982940673828125, 0.122172988951206207, 0, 0, 0.061048507690429687, 0.998134791851043701, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+46, 180472, 1, 15, 513, '0', 0, 0, -3622.314208984375, -4489.05224609375, 23.89744949340820312, 3.351046562194824218, 0, 0, -0.99452114105224609, 0.104535527527332305, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+47, 180523, 1, 15, 513, '0', 0, 0, -3612.083251953125, -4469.29345703125, 14.7999725341796875, 3.560472726821899414, 0, 0, -0.97814750671386718, 0.207912087440490722, 120, 255, 1, 46366), -- Apple Bob (Area: Theramore Isle - Difficulty: 0)
+(@OGUID+48, 190052, 1, 15, 513, '0', 0, 0, -3617.986083984375, -4471.408203125, 14.24441719055175781, 3.595378875732421875, 0, 0, -0.97437000274658203, 0.224951311945915222, 120, 255, 1, 46366); -- Candy Bucket (Area: Theramore Isle - Difficulty: 0)
+
+-- Event spawns
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+48;
+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);
diff --git a/sql/updates/world/master/2022_11_12_02_world_dustwallow_marsh_mudsprocket.sql b/sql/updates/world/master/2022_11_12_02_world_dustwallow_marsh_mudsprocket.sql
new file mode 100644
index 00000000000..89f11ab0cb2
--- /dev/null
+++ b/sql/updates/world/master/2022_11_12_02_world_dustwallow_marsh_mudsprocket.sql
@@ -0,0 +1,45 @@
+SET @OGUID := 247542;
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=46366 WHERE `entry`=190104; -- Candy Bucket
+
+UPDATE `gameobject_template_addon` SET `faction`=35 WHERE `entry`=190104; -- Candy Bucket
+
+-- Quests
+UPDATE `quest_offer_reward` SET `VerifiedBuild`=46366 WHERE `ID`=12398;
+
+DELETE FROM `gameobject_queststarter` WHERE `id`=190104;
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(190104, 12398, 46366);
+
+UPDATE `gameobject_questender` SET `VerifiedBuild`=46366 WHERE (`id`=190104 AND `quest`=12398);
+
+DELETE FROM `game_event_gameobject_quest` WHERE `id`=190104;
+
+-- Old gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 227389 AND 227396;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 227389 AND 227396;
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+7;
+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, 15, 4010, '0', 0, 0, -4568.92626953125, -3176.9208984375, 39.69365310668945312, 2.251473426818847656, 0, 0, 0.902585029602050781, 0.430511653423309326, 120, 255, 1, 46366), -- G_Pumpkin_01 (Area: Mudsprocket - Difficulty: 0)
+(@OGUID+1, 180406, 1, 15, 4010, '0', 0, 0, -4598.62939453125, -3176.501708984375, 38.29652786254882812, 1.954769015312194824, 0, 0, 0.829037666320800781, 0.559192776679992675, 120, 255, 1, 46366), -- G_Pumpkin_02 (Area: Mudsprocket - Difficulty: 0)
+(@OGUID+2, 180407, 1, 15, 4010, '0', 0, 0, -4598.18896484375, -3170.33984375, 38.37108993530273437, 1.902408957481384277, 0, 0, 0.814115524291992187, 0.580702960491180419, 120, 255, 1, 46366), -- G_Pumpkin_03 (Area: Mudsprocket - Difficulty: 0)
+(@OGUID+3, 180411, 1, 15, 4010, '0', 0, 0, -4623.16650390625, -3167.2421875, 42.21464920043945312, 3.106652259826660156, 0, 0, 0.999847412109375, 0.017469281330704689, 120, 255, 1, 46366), -- G_Ghost_01 (Area: Mudsprocket - Difficulty: 0)
+(@OGUID+4, 180472, 1, 15, 4010, '0', 0, 0, -4602.04541015625, -3172.749267578125, 47.08140945434570312, 3.194002151489257812, 0, 0, -0.99965667724609375, 0.026201646775007247, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Mudsprocket - Difficulty: 0)
+(@OGUID+5, 180472, 1, 15, 4010, '0', 0, 0, -4586.39794921875, -3186.8603515625, 41.13997268676757812, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 46366), -- HangingSkullLight02 (Area: Mudsprocket - Difficulty: 0)
+(@OGUID+6, 180523, 1, 15, 4010, '0', 0, 0, -4628.17822265625, -3169.177001953125, 35.2819976806640625, 4.939284324645996093, 0, 0, -0.6225137710571289, 0.78260880708694458, 120, 255, 1, 46366), -- Apple Bob (Area: Mudsprocket - Difficulty: 0)
+(@OGUID+7, 190104, 1, 15, 4010, '0', 0, 0, -4626.43603515625, -3172.865966796875, 41.2522125244140625, 0.925023794174194335, 0, 0, 0.446197509765625, 0.894934535026550292, 120, 255, 1, 46366); -- Candy Bucket (Area: Mudsprocket - Difficulty: 0)
+
+-- Event spawns
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+7;
+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);