diff options
| -rw-r--r-- | sql/updates/world/master/2024_11_06_04_world.sql | 56 |
1 files changed, 56 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_11_06_04_world.sql b/sql/updates/world/master/2024_11_06_04_world.sql new file mode 100644 index 00000000000..8e20c9cfe71 --- /dev/null +++ b/sql/updates/world/master/2024_11_06_04_world.sql @@ -0,0 +1,56 @@ +SET @OGUID := 4800048; + +-- Gameobject templates +UPDATE `gameobject_template_addon` SET `faction`=1735 WHERE `entry`=215875; -- Candy Bucket +UPDATE `gameobject_template_addon` SET `faction`=1732 WHERE `entry`=215915; -- Candy Bucket +UPDATE `gameobject_template_addon` SET `faction`=35 WHERE `entry`=215903; -- Candy Bucket + +-- Quests +DELETE FROM `quest_offer_reward` WHERE `ID` IN (32022, 32052, 32044); +INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES +(32022, 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 +(32052, 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 +(32044, 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` IN (215875, 215915, 215903); +INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(215875, 32022, 51886), +(215915, 32052, 51886), +(215903, 32044, 51886); + +DELETE FROM `gameobject_questender` WHERE `id` IN (215875, 215915, 215903); +INSERT INTO `gameobject_questender` (`id`, `quest`, `VerifiedBuild`) VALUES +(215875, 32022, 51886), +(215915, 32052, 51886), +(215903, 32044, 51886); + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+9; +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 +-- Shrine of Two Moons +(@OGUID+0, 180405, 870, 6554, 6554, '0', 0, 0, 1675.2760009765625, 903.560791015625, 490.689300537109375, 2.511412620544433593, 0, 0, 0.950768470764160156, 0.309902071952819824, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Shrine of Two Moons - Difficulty: 0) CreateObject1 +(@OGUID+1, 215875, 870, 6554, 6554, '0', 0, 0, 1673.5416259765625, 911.04864501953125, 490.689239501953125, 5.287477970123291015, 0, 0, -0.47754096984863281, 0.87860947847366333, 120, 255, 1, 51886), -- Candy Bucket (Area: Shrine of Two Moons - Difficulty: 0) CreateObject1 +-- Shrine of Seven Stars +(@OGUID+2, 180405, 870, 6142, 6142, '0', 0, 0, 781.80206298828125, 292.09027099609375, 508.124725341796875, 0.998298346996307373, 0, 0, 0.478678703308105468, 0.877990126609802246, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Shrine of Seven Stars - Difficulty: 0) CreateObject1 +(@OGUID+3, 180406, 870, 6142, 6142, '0', 0, 0, 785.9444580078125, 295.17535400390625, 508.121917724609375, 1.055283308029174804, 0, 0, 0.503497123718261718, 0.863996922969818115, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Shrine of Seven Stars - Difficulty: 0) CreateObject1 +(@OGUID+4, 180407, 870, 6142, 6142, '0', 0, 0, 788.5225830078125, 280.111114501953125, 503.418182373046875, 3.32104349136352539, 0, 0, -0.99597740173339843, 0.089604929089546203, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Shrine of Seven Stars - Difficulty: 0) CreateObject1 +(@OGUID+5, 215915, 870, 6142, 6142, '0', 0, 0, 785.45660400390625, 276.588531494140625, 503.419158935546875, 4.718334197998046875, 0, 0, -0.7050018310546875, 0.709205508232116699, 120, 255, 1, 51886), -- Candy Bucket (Area: Shrine of Seven Stars - Difficulty: 0) CreateObject1 +-- Mistfall Village +(@OGUID+6, 180405, 870, 5840, 6031, '0', 0, 0, 681.545166015625, 1595.1146240234375, 387.092071533203125, 1.526481986045837402, 0, 0, 0.691267013549804687, 0.722599446773529052, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Mistfall Village - Difficulty: 0) CreateObject1 +(@OGUID+7, 180406, 870, 5840, 6031, '0', 0, 0, 682.0555419921875, 1581.1336669921875, 387.092437744140625, 2.501868724822998046, 0, 0, 0.949278831481933593, 0.314435482025146484, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Mistfall Village - Difficulty: 0) CreateObject1 +(@OGUID+8, 180407, 870, 5840, 6031, '0', 0, 0, 673.39239501953125, 1595.513916015625, 389.208099365234375, 0.368232548236846923, 0, 0, 0.183077812194824218, 0.983098447322845458, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Mistfall Village - Difficulty: 0) CreateObject1 +(@OGUID+9, 215903, 870, 5840, 6031, '0', 0, 0, 635.34375, 1591.154541015625, 387.681304931640625, 2.292711257934570312, 0, 0, 0.911269187927246093, 0.41181117296218872, 120, 255, 1, 51886); -- Candy Bucket (Area: Mistfall Village - Difficulty: 0) CreateObject1 + +-- Event spawns +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+9; +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); |