diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2024-03-31 11:45:03 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2024-03-31 11:45:03 +0200 |
| commit | d5f9b11e8c9b338a41625ec44d80ba957d8f123e (patch) | |
| tree | f79dccfd49901a276044e83d7c8ea7556d6da804 | |
| parent | aa9477940be5bf6a8103903701c8abf869c92f48 (diff) | |
DB/Quest: Quests in Tranquillien
closes #29862 by Jonne733
| -rw-r--r-- | sql/updates/world/3.3.5/2024_03_31_02_world.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2024_03_31_02_world.sql b/sql/updates/world/3.3.5/2024_03_31_02_world.sql new file mode 100644 index 00000000000..fc5454b1098 --- /dev/null +++ b/sql/updates/world/3.3.5/2024_03_31_02_world.sql @@ -0,0 +1,15 @@ +-- These quests requires friendly reputation with Tranquillien (922) to be available +DELETE FROM `quest_template_addon` WHERE `ID` IN (9145,9150,9155,9160,9171,9192,9207); +INSERT INTO `quest_template_addon` (`ID`,`RequiredMinRepFaction`,`RequiredMinRepValue`,`SpecialFlags`) VALUES +(9145,922,3000,0), +(9150,922,3000,0), +(9155,922,3000,0), +(9160,922,3000,2), +(9171,922,3000,0), +(9207,922,3000,0), +(9192,922,3000,0); + +-- Quest "Retaking Windrunner Spire" requires honored reputation with Tranquillien to be available +DELETE FROM `quest_template_addon` WHERE `ID`=9173; +INSERT INTO `quest_template_addon` (`ID`,`RequiredMinRepFaction`,`RequiredMinRepValue`) VALUES +(9173,922,9000); |