From 81c7fa3ffb4d21279392fc18484c3d7540d7f0c1 Mon Sep 17 00:00:00 2001 From: offl Date: Fri, 15 Jan 2021 03:57:41 +0200 Subject: DB/Quest: Arathi Basin quests Closes #25845 (cherry picked from commit 0ca031559fdc379112d3e572478c5e478db0d539) --- .../master/2022_03_05_80_world_2021_01_15_04_world.sql | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 sql/updates/world/master/2022_03_05_80_world_2021_01_15_04_world.sql (limited to 'sql') 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!'); -- cgit v1.2.3