diff options
| author | MrSmite <bull@deadmines.cave> | 2017-03-30 18:35:50 +0200 |
|---|---|---|
| committer | tkrokli <tkrokli@users.noreply.github.com> | 2017-03-30 18:44:02 +0200 |
| commit | 05020ff42e94e694246e623c05732174a2d30c18 (patch) | |
| tree | 9cef22cf9af76995f3a2671db42611e29b0a75b2 | |
| parent | ae624c7d8189e7964a69425a9edde05724d51f72 (diff) | |
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
| -rw-r--r-- | sql/updates/world/3.3.5/2017_03_30_02_world_335.sql | 10 |
1 files changed, 10 insertions, 0 deletions
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 |