List of gems rewarded from quests: Difference between revisions
>Techhead7890 (reword vendor para to be much less awkward to read) |
>Illviljan (Fix the errors due changes in the cargo tables.) |
||
| Line 6: | Line 6: | ||
{{Query base items | {{Query base items | ||
|tables = vendor_rewards, quest_rewards, skill_gems | |tables = vendor_rewards, quest_rewards, skill_gems | ||
|join = items._pageName=vendor_rewards. | |join = items._pageName=vendor_rewards._pageName, items._pageName=quest_rewards._pageName, items._pageName=skill_gems._pageName | ||
|where = | |where = | ||
(items.class="Active Skill Gems" OR items.class = "Support Skill Gems") | |||
AND (vendor_rewards.quest_id IS NOT NULL OR quest_rewards.quest_id IS NOT NULL) | |||
|q_orderBy=skill_gems.primary_attribute, items.name | |q_orderBy=skill_gems.primary_attribute, items.name | ||
|q_limit = 5000 | |q_limit = 5000 | ||
Revision as of 16:49, 6 December 2020
This is a list of every gem in the game related to a quest and the related quests when they become available. Once the required quest is cleared, it shows which classes are initially offered the gem as a quest reward.
Players can also purchase the gem from vendors afterwards for a small amount of currency. Depending on the gem, initially only a limited variety of classes (usually including the classes that could choose it as a reward, and those classes from their neighbouring stats) can buy it. However two certain vendors will sell these gems to all classes after completing a quest for them: Siosa will also sell all gems from Acts 1-3, and Lilly Roth will sell all gems in the game (Acts 1-10). There are a few gems in the game that are not quest-related, and all these exceptions are listed at Drop Only Gems.
Gems
| Item | Quest rewards | Vendor rewards |
|---|