diff options
| author | ZenoX92 <ZenoX92@users.noreply.github.com> | 2018-07-27 15:15:39 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-10-17 12:40:41 +0200 |
| commit | 845e4db789c3df3e578cf0828e2f208d93b9428f (patch) | |
| tree | 5a88b07bafd09f4941e8ea80da48e8aad6c65a41 | |
| parent | 3503e9dc929692bc9a8e9a23de2bae9cad24497f (diff) | |
DB/Quest: Replacement Phial
Closes #22189
(cherry picked from commit 42e12feceee31aaede48f564a97cc07a5bbf911c)
| -rw-r--r-- | sql/updates/world/master/2021_10_17_07_world_2018_07_27_01_world_335.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_10_17_07_world_2018_07_27_01_world_335.sql b/sql/updates/world/master/2021_10_17_07_world_2018_07_27_01_world_335.sql new file mode 100644 index 00000000000..8e728305f22 --- /dev/null +++ b/sql/updates/world/master/2021_10_17_07_world_2018_07_27_01_world_335.sql @@ -0,0 +1,12 @@ +-- +-- Quest "Replacement Phial" +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=19 AND `SourceEntry`=3375; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(19,0,3375,0,0,14,0,2200,0,0,1,0,0,"","Quest 'Replacement Phial' can only be taken if quest 'Back to Uldaman' is taken"), +(19,0,3375,0,0,28,0,2204,0,0,1,0,0,"","Quest 'Replacement Phial' can only be taken if quest 'Restoring the Necklace' is not completed"), +(19,0,3375,0,0,8,0,2204,0,0,1,0,0,"","Quest 'Replacement Phial' can only be taken if quest 'Restoring the Necklace' is not rewarded"), +(19,0,3375,0,0,2,0,7667,1,1,1,0,0,"","Quest 'Replacement Phial' can only be taken if player does not have item 'Talvash's Phial of Scrying'"); + +DELETE FROM `quest_template_addon` WHERE `ID`=3375; +INSERT INTO `quest_template_addon` (`ID`, `MaxLevel`, `AllowableClasses`, `SourceSpellID`, `PrevQuestID`, `NextQuestID`, `ExclusiveGroup`, `RewardMailTemplateID`, `RewardMailDelay`, `RequiredSkillID`, `RequiredSkillPoints`, `RequiredMinRepFaction`, `RequiredMaxRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepValue`, `ProvidedItemCount`, `SpecialFlags`) VALUES +(3375,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1); |