From 2db9c9e83834b7456a823fef5ca719ffbaa7791a Mon Sep 17 00:00:00 2001 From: Aokromes Date: Fri, 1 Oct 2021 09:48:41 +0200 Subject: DB/Quest: Felendren the Banished closes #26980 by osleyder85 --- sql/updates/world/master/2021_10_01_02_world.sql | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 sql/updates/world/master/2021_10_01_02_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2021_10_01_02_world.sql b/sql/updates/world/master/2021_10_01_02_world.sql new file mode 100644 index 00000000000..6231c208205 --- /dev/null +++ b/sql/updates/world/master/2021_10_01_02_world.sql @@ -0,0 +1,17 @@ +-- Felendren the Banished +UPDATE `quest_offer_reward` SET `Emote1`=0, `Emote2`=0, `VerifiedBuild`=40120 WHERE `ID`=8335; + +UPDATE `quest_poi` SET `VerifiedBuild`=40120 WHERE (`QuestID`=8335 AND `BlobIndex`=0 AND `Idx1` IN (0,1,2,3,4)); + +UPDATE `quest_poi_points` SET `VerifiedBuild`=40120 WHERE (`QuestID`=8335 AND `Idx1` IN (3,4) AND `Idx2`=0); +UPDATE `quest_poi_points` SET `VerifiedBuild`=40120 WHERE (`QuestID`=8335 AND `Idx1`=2 AND `Idx2` IN (0,1,2)); +UPDATE `quest_poi_points` SET `VerifiedBuild`=40120 WHERE (`QuestID`=8335 AND `Idx1`=1 AND `Idx2` IN (0,1,2,3,4,5,6,7,8,9)); +UPDATE `quest_poi_points` SET `VerifiedBuild`=40120 WHERE (`QuestID`=8335 AND `Idx1`=0 AND `Idx2`=0); + +UPDATE `quest_details` SET `VerifiedBuild`=40120 WHERE `ID`=8335; + +UPDATE `quest_request_items` SET `EmoteOnIncomplete`=1, `VerifiedBuild`=40120 WHERE `ID`=8335; + +UPDATE `quest_template` SET `RewardMoney`=720, `RewardBonusMoney`=450, `VerifiedBuild`=40120 WHERE `ID`=8335; + +UPDATE `quest_objectives` SET `VerifiedBuild`=40120 WHERE `ID` IN (256930,256931,256932); -- cgit v1.2.3