diff options
| author | nelegalno <nelegalno@yopmail.com> | 2012-08-10 03:18:04 +0100 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2012-08-10 03:18:04 +0100 |
| commit | 76f0e87263a17d648f37be727954066ad6055f0a (patch) | |
| tree | 0f4d16cdb7d7990c71e17506679374a7ecb8523e | |
| parent | 41682b59a39a6645c85098ec49fce29fba5a4f42 (diff) | |
DB/Quests: Zandalar Tribe Quests Required Class/Race FIX
Closes #7322
| -rw-r--r-- | sql/updates/world/2012_08_10_03_world_quest_template.sql | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/sql/updates/world/2012_08_10_03_world_quest_template.sql b/sql/updates/world/2012_08_10_03_world_quest_template.sql new file mode 100644 index 00000000000..c4aebf5ba16 --- /dev/null +++ b/sql/updates/world/2012_08_10_03_world_quest_template.sql @@ -0,0 +1,18 @@ +-- Zandalar Tribe Quests Required Class/Race fix by nelegalno + +-- Maywiki of Zuldazar Quests Required Class +UPDATE `quest_template` SET `RequiredClasses` = 64 WHERE `Id` IN (8056,8074,8075,8116,8117,8118,8119); -- Shaman +UPDATE `quest_template` SET `RequiredClasses` = 1024 WHERE `Id` IN (8057,8064,8065,8110,8111,8112,8113); -- Druid + +-- Al'tabim the All-Seeing Quests Required Class +UPDATE `quest_template` SET `RequiredClasses` = 16 WHERE `Id` IN (8049,8050,8051,8052,8061,8070,8071); -- Priest +UPDATE `quest_template` SET `RequiredClasses` = 128 WHERE `Id` IN (8060,8068,8069,8101,8102,8103,8104); -- Mage +UPDATE `quest_template` SET `RequiredClasses` = 256 WHERE `Id` IN (8059,8076,8077,8106,8107,8108,8109); -- Warlock + +-- Falthir the Sightless Quests Required Class +UPDATE `quest_template` SET `RequiredClasses` = 4 WHERE `Id` IN (8062,8066,8067,8145,8146,8147,8148); -- Hunter +UPDATE `quest_template` SET `RequiredClasses` = 8 WHERE `Id` IN (8063,8072,8073,8141,8142,8143,8144); -- Rogue +UPDATE `quest_template` SET `RequiredRaces` = 152 WHERE `Id` = 8144; -- Night Elf, Undead and Troll + +-- Jin'rokh the Breaker +UPDATE `quest_template` SET `RequiredRaces` = 513 WHERE `Id` = 8048; -- Human and Blood Elf |