diff options
| author | ZenoX92 <ZenoX92@users.noreply.github.com> | 2018-12-08 09:02:13 +0100 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2018-12-08 09:02:13 +0100 |
| commit | 87318d6ada8d74a2fce19cd38c04450a19c0f1f9 (patch) | |
| tree | fb8727a144dad88ea4f4cbffadfa209413265bce | |
| parent | fb7b9533058540ed62823f18b0123c53c1aff148 (diff) | |
DB/Quest: Fire Sapta & Water Sapta
Closes #22703
| -rw-r--r-- | sql/updates/world/3.3.5/2018_12_08_06_world_335.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_12_08_06_world_335.sql b/sql/updates/world/3.3.5/2018_12_08_06_world_335.sql new file mode 100644 index 00000000000..c36191014db --- /dev/null +++ b/sql/updates/world/3.3.5/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'"); |