diff options
| author | offl <offl@users.noreply.github.com> | 2021-01-15 03:57:41 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-03-06 00:09:51 +0100 |
| commit | 81c7fa3ffb4d21279392fc18484c3d7540d7f0c1 (patch) | |
| tree | 31cd8e6db3c3c5de641040a7595e135d1ddf18b6 | |
| parent | 280d0fa9c0a70a671aad4ccc7109e8b6738dc8a9 (diff) | |
DB/Quest: Arathi Basin quests
Closes #25845
(cherry picked from commit 0ca031559fdc379112d3e572478c5e478db0d539)
| -rw-r--r-- | sql/updates/world/master/2022_03_05_80_world_2021_01_15_04_world.sql | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_05_80_world_2021_01_15_04_world.sql b/sql/updates/world/master/2022_03_05_80_world_2021_01_15_04_world.sql new file mode 100644 index 00000000000..9127f80dbd2 --- /dev/null +++ b/sql/updates/world/master/2022_03_05_80_world_2021_01_15_04_world.sql @@ -0,0 +1,18 @@ +-- +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 19 AND `SourceEntry` IN (8166,8167,8168,8169,8170,8171); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(19,0,8171,0,0,27,0,30,2,0,0,0,0,"","Group 0: Quest 'The Battle for Arathi Basin!' requires level lower than 30"), +(19,0,8168,0,0,27,0,30,2,0,0,0,0,"","Group 0: Quest 'The Battle for Arathi Basin!' requires level lower than 30"), +(19,0,8167,0,0,27,0,40,2,0,0,0,0,"","Group 0: Quest 'The Battle for Arathi Basin!' requires level lower than 40"), +(19,0,8170,0,0,27,0,40,2,0,0,0,0,"","Group 0: Quest 'The Battle for Arathi Basin!' requires level lower than 40"), +(19,0,8169,0,0,27,0,50,2,0,0,0,0,"","Group 0: Quest 'The Battle for Arathi Basin!' requires level lower than 50"), +(19,0,8166,0,0,27,0,50,2,0,0,0,0,"","Group 0: Quest 'The Battle for Arathi Basin!' requires level lower than 50"); + +-- Disabled in 2.4.0 +DELETE FROM `disables` WHERE `sourceType` = 1 AND `entry` IN (8080,8154,8155,8156,8297); +INSERT INTO `disables` (`sourceType`,`entry`,`flags`,`params_0`,`params_1`,`comment`) VALUES +(1,8080,0,'','','Deprecated quest: Arathi Basin Resources!'), +(1,8154,0,'','','Deprecated quest: Arathi Basin Resources!'), +(1,8155,0,'','','Deprecated quest: Arathi Basin Resources!'), +(1,8156,0,'','','Deprecated quest: Arathi Basin Resources!'), +(1,8297,0,'','','Deprecated quest: Arathi Basin Resources!'); |