diff options
| author | Kelpiesklubhouse <151824209+Kelpiesklubhouse@users.noreply.github.com> | 2024-02-22 01:17:26 +0100 |
|---|---|---|
| committer | Naddley <NaddleyTC@gmail.com> | 2024-02-22 01:17:30 +0100 |
| commit | 1db940bc174d4feb95f19c8de52cb2b08057e021 (patch) | |
| tree | 7740726e63dd1872cbb2f2b4ccdc4e0d6664b354 | |
| parent | c8bd6f5da3d03007a9be9bda30aadddb5573ec9d (diff) | |
DB/Mulgore: Update questchains for Camp Narache
Closes #29661
| -rw-r--r-- | sql/updates/world/master/2024_02_22_00_world.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_02_22_00_world.sql b/sql/updates/world/master/2024_02_22_00_world.sql new file mode 100644 index 00000000000..4b9c2cbff96 --- /dev/null +++ b/sql/updates/world/master/2024_02_22_00_world.sql @@ -0,0 +1,14 @@ +-- Conditions +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=19 AND `SourceGroup`=0 AND `SourceEntry`=14461; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ConditionStringValue1`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(19,0,14461,0,0,47,0,14455,64,0,'',0,0,0,'','Feed of Evil available if quest Stop the Thorncallers is rewarded'), +(19,0,14461,0,0,47,0,14456,64,0,'',0,0,0,'','Feed of Evil available if quest Rite of Courage is rewarded'); +-- Camp Narache Quests +DELETE FROM `quest_template_addon` WHERE `ID` IN (14449,14455,14456,14460); +INSERT INTO `quest_template_addon` (`ID`,`MaxLevel`,`AllowableClasses`,`SourceSpellID`,`PrevQuestID`,`NextQuestID`,`ExclusiveGroup`,`BreadcrumbForQuestId`,`RewardMailTemplateID`,`RewardMailDelay`,`RequiredSkillID`,`RequiredSkillPoints`,`RequiredMinRepFaction`,`RequiredMaxRepFaction`,`RequiredMinRepValue`,`RequiredMaxRepValue`,`ProvidedItemCount`,`SpecialFlags`,`ScriptName`) VALUES +(14455,0,0,0,14458,14459,-14455,0,0,0,0,0,0,0,0,0,0,0,''), -- Stop the Thorncallers +(14456,0,0,0,14458,14459,-14455,0,0,0,0,0,0,0,0,0,0,0,''); -- Rite of Courage +-- Unnecessary NextQuestIDs +UPDATE `quest_template_addon` SET `NextQuestID`=0 WHERE `ID` IN (14452,23733,24852,24861); +-- The Battleboars and Feed of Evil ExclusiveGroup +UPDATE `quest_template_addon` SET `ExclusiveGroup`=-14459 WHERE `ID` IN (14459,14461); |