diff options
| author | Kelpiesklubhouse <151824209+Kelpiesklubhouse@users.noreply.github.com> | 2024-02-26 00:49:15 +0100 |
|---|---|---|
| committer | Naddley <NaddleyTC@gmail.com> | 2024-02-26 00:49:18 +0100 |
| commit | f8ab334a3311ca4124c46a9ffecefc639512f1f0 (patch) | |
| tree | fa67b3436775ea2dc4ec14e9f2bd42db354cd2de | |
| parent | 38730ee2721ec06db03333b4b6f638db69bfaf2a (diff) | |
DB/DunMorogh: Update questchain for New Tinkertown
Closes #29716
| -rw-r--r-- | sql/updates/world/master/2024_02_26_03_world.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_02_26_03_world.sql b/sql/updates/world/master/2024_02_26_03_world.sql new file mode 100644 index 00000000000..4e226991203 --- /dev/null +++ b/sql/updates/world/master/2024_02_26_03_world.sql @@ -0,0 +1,13 @@ +-- Unneeded Conditions +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=19 AND `SourceGroup`=0 AND `SourceEntry` IN (26316,26318,26339); +-- Unneeded SpecialFlags +UPDATE `quest_template_addon` SET `SpecialFlags`=0 WHERE `ID` IN (26197,26199,26202,26203,26206,26264,26333,26373,26421,26422,26423,26424,26425,27635,27671,27674,28167,28169,31135,31137,41217,41218); +-- A Job for the Multibot, What's Left Behind, Dealing With the Fallout ExclusiveGroup +UPDATE `quest_template_addon` SET `ExclusiveGroup`=-26205 WHERE `ID` IN (26205,26264,26265); +UPDATE `quest_template_addon` SET `NextQuestID`=26316 WHERE `ID` IN (26205,26264,26265); +-- Missing In Action and Get Me Explosives Back ExclusiveGroup +UPDATE `quest_template_addon` SET `ExclusiveGroup`=-26284 WHERE `ID` IN (26284,26285); +UPDATE `quest_template_addon` SET `NextQuestID`=26318 WHERE `ID` IN (26284,26285); +-- Crushcog's Minions and No Tanks ExclusiveGroup +UPDATE `quest_template_addon` SET `ExclusiveGroup`=-26331 WHERE `ID` IN (26331,26333); +UPDATE `quest_template_addon` SET `NextQuestID`=26339 WHERE `ID` IN (26331,26333); |