From b33344c9d3f14e9d71c621495b0a213daf94082e Mon Sep 17 00:00:00 2001 From: nubqt Date: Thu, 16 Nov 2017 17:11:26 +0100 Subject: DB/Quest: Fix some Warchief's Command quest requirements Closes #18221 Closes #20849 --- sql/updates/world/master/2017_11_16_01_world.sql | 28 ++++++++++++++++++++++++ 1 file changed, 28 insertions(+) create mode 100644 sql/updates/world/master/2017_11_16_01_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/master/2017_11_16_01_world.sql b/sql/updates/world/master/2017_11_16_01_world.sql new file mode 100644 index 00000000000..9226e1a9b49 --- /dev/null +++ b/sql/updates/world/master/2017_11_16_01_world.sql @@ -0,0 +1,28 @@ +-- Removing unnecessary requirement: +-- Player should be able to get @QUEST_MURDER_WAS_THE_CASE_THEY_GAVE_ME without having to complete +-- @QUEST_HEROS_CALL_WESTFALL_OBTAINED_FROM_NPC or @QUEST_HEROS_CALL_WESTFALL_OBTAINED_FROM_HCB + +UPDATE `quest_template` SET `RewardNextQuest` = 0 WHERE `id` IN ( 26378, 28562 ); +UPDATE `quest_template_addon` SET `NextQuestId` = 0 WHERE `id` IN ( 26378, 28562 ); + +-- But Player should NOT be able to get either quest if he has already completed the quest 'Murder Was The Case They Gave Me' +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=19 AND `SourceEntry` IN (26378, 28562); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +( 19, 0, 26378, 0, 0, 8, 0, 26209, 0, 0, 1, 0, 0, '', 'Checks if Player has not been rewarded quest' ), +( 19, 0, 28562, 0, 0, 8, 0, 26209, 0, 0, 1, 0, 0, '', 'Checks if Player has not been rewarded quest' ); + +-- Fixing QuestType which was set incorrectly to '1' thus disabling the quest +UPDATE `quest_template` SET `QuestType` = 2 WHERE `id` = 28562; + +-- Removing unnecessary requirement. Player should be able to get the quests +-- @QUEST_THE_FORSAKEN_FROM_NPC and @QUEST_THE_FORSAKEN_FROM_WCB without having to complete @QUEST_WARCHIEFS_COMMAND_GHOSTLANDS beforehand. + +UPDATE `quest_template` SET `RewardNextQuest` = 0 WHERE `id` = 28560; +UPDATE `quest_template_addon` SET `PrevQuestId` = 0 WHERE `id` IN (9327, 9329); + +-- But the Player should NOT be able to get the quest @QUEST_WARCHIEFS_COMMAND_GHOSTLANDS +-- if he has already completed @QUEST_THE_FORSAKEN_FROM_NPC or @QUEST_THE_FORSAKEN_FROM_WCB +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=19 AND `SourceEntry` IN (28560); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(19, 0, 28560, 0, 0, 8, 0, 9327, 0, 0, 1, 0, 0, '', 'Makes quest available if-and-only-if Player has not completed another quest beforehand' ), +(19, 0, 28560, 0, 1, 8, 0, 9329, 0, 0, 1, 0, 0, '', 'Makes quest available if-and-only-if Player has not completed another quest beforehand' ); -- cgit v1.2.3