aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2023_01_12_27_world_2022_11_07_00_world.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_01_12_27_world_2022_11_07_00_world.sql b/sql/updates/world/master/2023_01_12_27_world_2022_11_07_00_world.sql
new file mode 100644
index 00000000000..daf7f53fe84
--- /dev/null
+++ b/sql/updates/world/master/2023_01_12_27_world_2022_11_07_00_world.sql
@@ -0,0 +1,5 @@
+-- Make 2 quests repeatable
+DELETE FROM `quest_template_addon` WHERE `ID` IN (9211, 9213);
+INSERT INTO `quest_template_addon` (`ID`, `MaxLevel`, `AllowableClasses`, `SourceSpellID`, `PrevQuestID`, `NextQuestID`, `ExclusiveGroup`, `BreadcrumbForQuestId`, `RewardMailTemplateID`, `RewardMailDelay`, `RequiredSkillID`, `RequiredSkillPoints`, `RequiredMinRepFaction`, `RequiredMaxRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepValue`, `ProvidedItemCount`, `SpecialFlags`) VALUES
+(9211, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1),
+(9213, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);