diff options
| author | MrSmite <bull@deadmines.cave> | 2017-03-31 23:55:35 +0200 |
|---|---|---|
| committer | tkrokli <tkrokli@users.noreply.github.com> | 2017-03-31 23:56:14 +0200 |
| commit | 751b554ce6bab9b7f53b1c74a4ec9c6802110d91 (patch) | |
| tree | 7a1a5cc27bd9823ca8753bb9c553d3b59560adb8 | |
| parent | f3d795d8ddd54c7def3e2119cec1abe5c69b43f9 (diff) | |
DB/Quests: The Left/Right Piece of Lord Valthalak's Amulet
Fix class restrictions for Dungeon Set 2 armor quests
- The Left Piece of Lord Valthalak's Amulet (8966,8967,8968,8969)
- The Right Piece of Lord Valthalak's Amulet (8989,8990,8991,8992)
Closes #19375
| -rw-r--r-- | sql/updates/world/3.3.5/2017_03_31_01_world_335.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_03_31_01_world_335.sql b/sql/updates/world/3.3.5/2017_03_31_01_world_335.sql new file mode 100644 index 00000000000..c1918289dc4 --- /dev/null +++ b/sql/updates/world/3.3.5/2017_03_31_01_world_335.sql @@ -0,0 +1,11 @@ +-- The Left Piece of Lord Valthalak's Amulet: class restrictions for Dungeon Set 2 armor quests +UPDATE `quest_template_addon` SET `AllowableClasses`= 129 WHERE `ID`= 8966; -- Warrior / Mage +UPDATE `quest_template_addon` SET `AllowableClasses`= 1280 WHERE `ID`= 8967; -- Druid / Warlock +UPDATE `quest_template_addon` SET `AllowableClasses`= 12 WHERE `ID`= 8968; -- Hunter / Rogue +UPDATE `quest_template_addon` SET `AllowableClasses`= 82 WHERE `ID`= 8969; -- Priest / Paladin / Shaman + +-- The Right Piece of Lord Valthalak's Amulet: class restrictions for Dungeon Set 2 armor quests +UPDATE `quest_template_addon` SET `AllowableClasses`= 9 WHERE `ID`= 8990; -- Warrior / Rogue +UPDATE `quest_template_addon` SET `AllowableClasses`= 1090 WHERE `ID`= 8989; -- Druid / Paladin / Shaman +UPDATE `quest_template_addon` SET `AllowableClasses`= 144 WHERE `ID`= 8991; -- Priest / Mage +UPDATE `quest_template_addon` SET `AllowableClasses`= 260 WHERE `ID`= 8992; -- Hunter / Warlock |