diff options
Diffstat (limited to 'sql')
-rw-r--r-- | sql/updates/world/master/2025_09_24_00_world.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/world/master/2025_09_24_00_world.sql b/sql/updates/world/master/2025_09_24_00_world.sql new file mode 100644 index 00000000000..9e193b6d69a --- /dev/null +++ b/sql/updates/world/master/2025_09_24_00_world.sql @@ -0,0 +1,14 @@ + +DELETE FROM `quest_template` WHERE `ID` IN (92078 /*92078*/, 91489 /*91489*/, 91487 /*91487*/); +INSERT INTO `quest_template` (`ID`, `QuestType`, `QuestPackageID`, `ContentTuningID`, `QuestSortID`, `QuestInfoID`, `SuggestedGroupNum`, `RewardNextQuest`, `RewardXPDifficulty`, `RewardXPMultiplier`, `RewardMoneyDifficulty`, `RewardMoneyMultiplier`, `RewardSpell`, `RewardHonor`, `RewardKillHonor`, `StartItem`, `RewardArtifactXPDifficulty`, `RewardArtifactXPMultiplier`, `RewardArtifactCategoryID`, `Flags`, `FlagsEx`, `FlagsEx2`, `FlagsEx3`, `RewardSkillLineID`, `RewardNumSkillUps`, `PortraitGiver`, `PortraitGiverMount`, `PortraitGiverModelSceneID`, `PortraitTurnIn`, `RewardItem1`, `RewardItem2`, `RewardItem3`, `RewardItem4`, `RewardAmount1`, `RewardAmount2`, `RewardAmount3`, `RewardAmount4`, `ItemDrop1`, `ItemDrop2`, `ItemDrop3`, `ItemDrop4`, `ItemDropQuantity1`, `ItemDropQuantity2`, `ItemDropQuantity3`, `ItemDropQuantity4`, `RewardChoiceItemID1`, `RewardChoiceItemID2`, `RewardChoiceItemID3`, `RewardChoiceItemID4`, `RewardChoiceItemID5`, `RewardChoiceItemID6`, `RewardChoiceItemQuantity1`, `RewardChoiceItemQuantity2`, `RewardChoiceItemQuantity3`, `RewardChoiceItemQuantity4`, `RewardChoiceItemQuantity5`, `RewardChoiceItemQuantity6`, `RewardChoiceItemDisplayID1`, `RewardChoiceItemDisplayID2`, `RewardChoiceItemDisplayID3`, `RewardChoiceItemDisplayID4`, `RewardChoiceItemDisplayID5`, `RewardChoiceItemDisplayID6`, `POIContinent`, `POIx`, `POIy`, `POIPriority`, `RewardTitle`, `RewardArenaPoints`, `RewardFactionID1`, `RewardFactionID2`, `RewardFactionID3`, `RewardFactionID4`, `RewardFactionID5`, `RewardFactionValue1`, `RewardFactionValue2`, `RewardFactionValue3`, `RewardFactionValue4`, `RewardFactionValue5`, `RewardFactionCapIn1`, `RewardFactionCapIn2`, `RewardFactionCapIn3`, `RewardFactionCapIn4`, `RewardFactionCapIn5`, `RewardFactionOverride1`, `RewardFactionOverride2`, `RewardFactionOverride3`, `RewardFactionOverride4`, `RewardFactionOverride5`, `RewardFactionFlags`, `AreaGroupID`, `TimeAllowed`, `AllowableRaces`, `Expansion`, `ManagedWorldStateID`, `QuestSessionBonus`, `LogTitle`, `LogDescription`, `QuestDescription`, `AreaDescription`, `QuestCompletionLog`, `RewardCurrencyID1`, `RewardCurrencyID2`, `RewardCurrencyID3`, `RewardCurrencyID4`, `RewardCurrencyQty1`, `RewardCurrencyQty2`, `RewardCurrencyQty3`, `RewardCurrencyQty4`, `PortraitGiverText`, `PortraitGiverName`, `PortraitTurnInText`, `PortraitTurnInName`, `AcceptedSoundKitID`, `CompleteSoundKitID`, `VerifiedBuild`) VALUES +(92078, 0, 0, 2832, 16178, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x2280000, 0x80, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 249701, 249703, 249705, 249709, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 10, 0, 0, 'A New Recipe!', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 63305), -- 92078 +(91489, 0, 0, 2888, 16178, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x380000, 0x80, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 246694, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 10, 0, 0, 'A Curious Companion', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 63305), -- 91489 +(91487, 0, 0, 2832, 16178, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x2280000, 0x80, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 186640, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 10, 0, 0, 'Welcome to the Team', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 63305); -- 91487 + +DELETE FROM `quest_offer_reward` WHERE `ID` IN (85109 /*85109*/, 92078 /*92078*/, 91489 /*91489*/, 91487 /*91487*/, 91526 /*91526*/); +INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES +(85109, 6, 0, 0, 0, 0, 0, 0, 0, 'Our thanks, traveler. May this serve you well.', 63305), -- 85109 +(92078, 0, 0, 0, 0, 0, 0, 0, 0, 'You''re back already! I believe I''ve found a use for the Manaforged Instruments you may have found within Araz''s possession. Each are pieces of machinery that, if extracted properly, would yield a unique energy signal not dissimilar to the magic used to bind Ethereals. If you or anyone you know are particularly well-versed in Enchantmenting or Inscription, take these! They may hold secrets, or at the very least a novel experience for you. Good luck!', 63305), -- 92078 +(91489, 0, 0, 0, 0, 0, 0, 0, 0, '<The purrkin looks at you warmly. For the first time since you''ve arrived in K''aresh, it seems to actually *enjoy* your attention. As it pushes closer, its soft mew confirms your suspicions - she seems to want to join you. At least for now.>', 63305), -- 91489 +(91487, 0, 0, 0, 0, 0, 0, 0, 0, 'My friend, we have made much progress together in bringing down the Shadowguard. For your sacrifices and efforts, my colleagues and I consider you one of us. Please, take this modified Gearglider as a show of our gratitiude - may it carry you safely to your next mission.', 63305), -- 91487 +(91526, 0, 0, 0, 0, 0, 0, 0, 0, '$n... I should have seen that coming. His devotion to Dimensius knew no bounds, and he certainly had contingencies in place to make sure the ritual would be completed. We''ll have to attack from another angle. We found some debris from his inner sanctum that made its way here - if you have the skill, we can teach you how to use it for your own ends.', 63305); -- 91526 |