From 06c7849aa182cc5a2353cb218b81fda0e6ad23a0 Mon Sep 17 00:00:00 2001 From: SnapperRy Date: Sat, 16 Jul 2016 21:10:54 +0200 Subject: Core/Conditions: implement CONDITION_DAILY_QUEST_DONE to check whether or not a daily quest has been completed by a player in that day. Also use it to fix two quest chains broken in commit 7905651. Should be the only ones of their kind. (cherry picked from commit b4b3c10c69f73a0fd1e8efe4fd8684676f33948d) --- .../world/master/2017_02_05_30_world_2016_07_16_08_world.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 sql/updates/world/master/2017_02_05_30_world_2016_07_16_08_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/master/2017_02_05_30_world_2016_07_16_08_world.sql b/sql/updates/world/master/2017_02_05_30_world_2016_07_16_08_world.sql new file mode 100644 index 00000000000..af4db3f1567 --- /dev/null +++ b/sql/updates/world/master/2017_02_05_30_world_2016_07_16_08_world.sql @@ -0,0 +1,8 @@ +-- +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID` IN (12692, 12695); +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19, 20) AND `SourceEntry` IN (12692, 12695); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(19, 0, 12692, 0, 0, 43, 0, 12582, 0, 0, 0, 0, 0, "", "Quest 'Return of the Lich Hunter' can be accepted if daily quest 'Frenzyheart Champion' hsa been turned in"), +(20, 0, 12692, 0, 0, 43, 0, 12582, 0, 0, 0, 0, 0, "", "Quest mark for 'Return of the Lich Hunter' can be seen if daily quest 'Frenzyheart Champion' hsa been turned in"), +(19, 0, 12695, 0, 0, 43, 0, 12689, 0, 0, 0, 0, 0, "", "Quest 'Return of the Friendly Dryskin' can be accepted if daily quest 'Hand of the Oracles' has been turned in"), +(20, 0, 12695, 0, 0, 43, 0, 12689, 0, 0, 0, 0, 0, "", "Quest mark for 'Return of the Friendly Dryskin' can be accepted if daily quest 'Hand of the Oracles' has been turned in"); -- cgit v1.2.3