aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorZenoX92 <ZenoX92@users.noreply.github.com>2018-12-08 09:02:13 +0100
committerShauren <shauren.trinity@gmail.com>2021-11-16 14:07:20 +0100
commit94a8b5e45015bbc9a271b5de3cdb69d248282af8 (patch)
tree52d0f03712e8b85dc3e2477773dfc96de3d00308
parent44faa93264a3420ca480763ed66a2bed2249ab3c (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.sql10
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'");