diff options
| author | souler <souler@trinity.contrib> | 2012-01-19 08:45:58 +0100 |
|---|---|---|
| committer | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2012-01-19 08:45:58 +0100 |
| commit | cef65cbdab5e216cfa593cd3fbe9865fc7f108c3 (patch) | |
| tree | c933a7d8ffa1f5bb756a902f2bf7e9f57eee8bfd | |
| parent | 58ee668e92eeab6cb3557e951e111c5b29b29a57 (diff) | |
DB/Quest: set RequiredClasses for A Victory for The... quests
closes #4815
| -rw-r--r-- | sql/updates/world/2012_01_19_00_world_quest_template.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/sql/updates/world/2012_01_19_00_world_quest_template.sql b/sql/updates/world/2012_01_19_00_world_quest_template.sql new file mode 100644 index 00000000000..f1af6e7eedd --- /dev/null +++ b/sql/updates/world/2012_01_19_00_world_quest_template.sql @@ -0,0 +1,17 @@ +-- Non sword wielders quests +UPDATE `quest_template` SET `RequiredClasses`=`RequiredClasses` +|16 -- Priest +|64 -- Shaman +|1024 -- Druid +WHERE `Id` IN (24795,24798,24798); + +-- Sword wielders quests +UPDATE `quest_template` SET `RequiredClasses`=`RequiredClasses` +|1 -- Warrior +|2 -- Paladin +|4 -- Hunter +|8 -- Rouge +|32 -- Death Kinght +|128 -- Mage +|256 -- Warlock +WHERE `Id` IN (24796,24800,24801); |