From 16b23213eb5eadc59e688ee6dba13d0c120453b9 Mon Sep 17 00:00:00 2001 From: ZenoX92 Date: Mon, 19 Feb 2018 19:45:00 +0100 Subject: DB/Quest: The Corruption Abroad (Breadcrumb quest) Closes #21449 --- sql/updates/world/3.3.5/2018_02_19_09_world_335.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/world/3.3.5/2018_02_19_09_world_335.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2018_02_19_09_world_335.sql b/sql/updates/world/3.3.5/2018_02_19_09_world_335.sql new file mode 100644 index 00000000000..88647b9d81a --- /dev/null +++ b/sql/updates/world/3.3.5/2018_02_19_09_world_335.sql @@ -0,0 +1,6 @@ +-- Breadcrumb Quest "The Corruption Abroad" +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=1275; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=19 AND `SourceEntry` IN (3765,1275); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(19,0,3765,0,0,14,0,1275,0,0,0,0,0,"","Quest 'The Corruption Abroad' can only be taken if quest 'Researching the Corruption' is not taken"), +(19,0,1275,0,0,28,0,3765,0,0,1,0,0,"","Quest 'Researching the Corruption' can only be taken if quest 'The Corruption Abroad' is not completed"); -- cgit v1.2.3