aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorZenoX92 <ZenoX92@users.noreply.github.com>2018-02-19 19:45:00 +0100
committerKillyana <morphone1@gmail.com>2018-02-19 19:45:00 +0100
commit16b23213eb5eadc59e688ee6dba13d0c120453b9 (patch)
tree2036e44628bc2682a7589158a26c361fedd77860
parentd25f8d6a41258fce584ac33972b4b6cc53d72cfb (diff)
DB/Quest: The Corruption Abroad (Breadcrumb quest)
Closes #21449
-rw-r--r--sql/updates/world/3.3.5/2018_02_19_09_world_335.sql6
1 files changed, 6 insertions, 0 deletions
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");