From 3c69a40c100f49bb7a348cb729d483e1e8f22947 Mon Sep 17 00:00:00 2001 From: Naddley Date: Tue, 3 Dec 2024 14:49:12 +0100 Subject: DB/IsleOfDorn: Readded conditions for Phase 23936 & 24032 --- sql/updates/world/master/2024_12_03_01_world.sql | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) create mode 100644 sql/updates/world/master/2024_12_03_01_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/master/2024_12_03_01_world.sql b/sql/updates/world/master/2024_12_03_01_world.sql new file mode 100644 index 00000000000..7901397605d --- /dev/null +++ b/sql/updates/world/master/2024_12_03_01_world.sql @@ -0,0 +1,20 @@ +-- Phase 23936 +DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId`=26 AND `SourceGroup` = 23936 AND `SourceEntry` = 0); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `Comment`) VALUE +(26, 23936, 0, 0, 0, 47, 0, 82797, 2|8|64, 0, 0, 'Apply Phase 23936 if Quest 82797 is taken | complete | rewarded'), +(26, 23936, 0, 0, 0, 47, 0, 82799, 2|8|64, 0, 1, 'Apply Phase 23936 if Quest 82799 is not taken | complete | rewarded'), +(26, 23936, 0, 0, 0, 47, 0, 82798, 2|8|64, 0, 1, 'Apply Phase 23936 if Quest 82798 is not taken | complete | rewarded'), +-- +(26, 23936, 0, 0, 1, 47, 0, 82797, 2|8|64, 0, 0, 'Apply Phase 23936 if Quest 82797 is taken | complete | rewarded'), +(26, 23936, 0, 0, 1, 47, 0, 82799, 2|8|64, 0, 0, 'Apply Phase 23936 if Quest 82799 is taken | complete | rewarded'), +(26, 23936, 0, 0, 1, 47, 0, 82798, 2|8|64, 0, 1, 'Apply Phase 23936 if Quest 82798 is not taken | complete | rewarded'), +-- +(26, 23936, 0, 0, 2, 47, 0, 82797, 2|8|64, 0, 0, 'Apply Phase 23936 if Quest 82797 is taken | complete | rewarded'), +(26, 23936, 0, 0, 2, 47, 0, 82799, 2|8|64, 0, 1, 'Apply Phase 23936 if Quest 82799 is not taken | complete | rewarded'), +(26, 23936, 0, 0, 2, 47, 0, 82798, 2|8|64, 0, 0, 'Apply Phase 23936 if Quest 82798 is taken | complete | rewarded'); + +-- Phase 24032 +DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId`=26 AND `SourceGroup` = 24032 AND `SourceEntry` = 0); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `Comment`) VALUE +(26, 24032, 0, 0, 0, 47, 0, 82799, 2|8|64, 0, 0, 'Apply Phase 24032 if Quest 82799 is taken | complete | rewarded'), +(26, 24032, 0, 0, 0, 47, 0, 82798, 2|8|64, 0, 0, 'Apply Phase 24032 if Quest 82798 is taken | complete | rewarded'); -- cgit v1.2.3