diff options
author | ZenoX92 <ZenoX92@users.noreply.github.com> | 2018-12-08 09:02:13 +0100 |
---|---|---|
committer | Shauren <shauren.trinity@gmail.com> | 2021-11-16 14:07:20 +0100 |
commit | 94a8b5e45015bbc9a271b5de3cdb69d248282af8 (patch) | |
tree | 52d0f03712e8b85dc3e2477773dfc96de3d00308 | |
parent | 44faa93264a3420ca480763ed66a2bed2249ab3c (diff) |
DB/Quest: Fire Sapta & Water Sapta
Closes #22703
(cherry picked from commit 87318d6ada8d74a2fce19cd38c04450a19c0f1f9)
-rw-r--r-- | sql/updates/world/master/2021_11_16_02_world_2018_12_08_06_world_335.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_11_16_02_world_2018_12_08_06_world_335.sql b/sql/updates/world/master/2021_11_16_02_world_2018_12_08_06_world_335.sql new file mode 100644 index 00000000000..c36191014db --- /dev/null +++ b/sql/updates/world/master/2021_11_16_02_world_2018_12_08_06_world_335.sql @@ -0,0 +1,10 @@ +-- Quest "Fire Sapta" +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=19 AND `SourceEntry`=1464 AND `ConditionTypeOrReference`=2; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(19,0,1464,0,0,2,0,6636,1,1,1,0,0,"","Quest 'Fire Sapta' can only be taken if player does not have item 'Fire Sapta'"); + +-- Quest "Water Sapta" +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=19 AND `SourceEntry`=972; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(19,0,972,0,0,14,0,96,0,0,0,0,0,"","Quest 'Water Sapta' can only be taken if quest 'Call of Water (Part 9)' is not taken"), +(19,0,972,0,0,2,0,6637,1,1,1,0,0,"","Quest 'Water Sapta' can only be taken if player does not have item 'Water Sapta'"); |