diff options
| author | Dr-J <daniel.jarrott0@gmail.com> | 2017-10-06 22:17:15 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2017-10-06 22:17:15 +0100 |
| commit | 186be3714f8a9a71c2f1506cb4a853b3bb829387 (patch) | |
| tree | 95e526fbea18324fddc6927d41855cf9ae43380e /sql/updates | |
| parent | 67795685bae686094840c8805fefbe2cf0835009 (diff) | |
DB/Quest: Alchemy Specialisation Breadcrumbs (3.3.5)
The first quest to learn alchemy specialisations should be optional but should not be available if player has already taken the quest it leads to
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/3.3.5/2017_10_06_09_world335.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_10_06_09_world335.sql b/sql/updates/world/3.3.5/2017_10_06_09_world335.sql new file mode 100644 index 00000000000..85f940df7c1 --- /dev/null +++ b/sql/updates/world/3.3.5/2017_10_06_09_world335.sql @@ -0,0 +1,8 @@ +UPDATE `quest_template_addon` SET `PrevQuestID` =0 WHERE `ID`IN(10899,10902,10897); +UPDATE `quest_template_addon` SET `NextQuestID` =0 WHERE `ID`IN(10907,10906,10905); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` =19 AND `SourceEntry`IN(10907,10906,10905) AND `ConditionTypeOrReference`=14 AND `ConditionValue1`IN(10899,10902,10897); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(19, 0, 10907, 0, 0, 14, 0, 10899, 0, 0, 0, 0, 0, '', 'Master of Transmutation 1/2 is Optional BreadCrumb Quest'), +(19, 0, 10906, 0, 0, 14, 0, 10902, 0, 0, 0, 0, 0, '', 'Master of Elixirs 1/2 is Optional BreadCrumb Quest'), +(19, 0, 10905, 0, 0, 14, 0, 10897, 0, 0, 0, 0, 0, '', 'Master of Potions 1/2 is Optional BreadCrumb Quest'); |