From 05020ff42e94e694246e623c05732174a2d30c18 Mon Sep 17 00:00:00 2001 From: MrSmite Date: Thu, 30 Mar 2017 18:35:50 +0200 Subject: DB/Quests: (More) Components of Importance Fix class restrictions for Dungeon Set 2 armor quests - Components of Importance (8962,8963,8964,8965) - More Components of Importance (8985,8986,8987,8988) Updates issue #19375 --- sql/updates/world/3.3.5/2017_03_30_02_world_335.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 sql/updates/world/3.3.5/2017_03_30_02_world_335.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2017_03_30_02_world_335.sql b/sql/updates/world/3.3.5/2017_03_30_02_world_335.sql new file mode 100644 index 00000000000..4c279f3a7a8 --- /dev/null +++ b/sql/updates/world/3.3.5/2017_03_30_02_world_335.sql @@ -0,0 +1,10 @@ +-- Components of Importance: class restrictions for Dungeon Set 2 armor quests +UPDATE `quest_template_addon` SET `AllowableClasses`=129 WHERE `ID`=8962; -- Warrior / Mage +UPDATE `quest_template_addon` SET `AllowableClasses`=1280 WHERE `ID`=8963; -- Druid / Warlock +UPDATE `quest_template_addon` SET `AllowableClasses`=12 WHERE `ID`=8964; -- Hunter / Rogue +UPDATE `quest_template_addon` SET `AllowableClasses`=82 WHERE `ID`=8965; -- Priest / Paladin / Shaman +-- More Components of Importance +UPDATE `quest_template_addon` SET `AllowableClasses`=9 WHERE `ID`=8985; -- Warrior / Rogue +UPDATE `quest_template_addon` SET `AllowableClasses`=1090 WHERE `ID`=8986; -- Druid / Paladin / Shaman +UPDATE `quest_template_addon` SET `AllowableClasses`=144 WHERE `ID`=8987; -- Priest / Mage +UPDATE `quest_template_addon` SET `AllowableClasses`=260 WHERE `ID`=8988; -- Hunter / Warlock -- cgit v1.2.3