List of gems rewarded from quests: Difference between revisions
>Techhead7890 (rewrite intro and avoid too many hatnotes) |
>Techhead7890 (reword vendor para to be much less awkward to read) |
||
| Line 1: | Line 1: | ||
This is a list of every [[skill gem|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 [[class]]es are initially offered the gem as a [[quest reward]]. | This is a list of every [[skill gem|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 [[class]]es are initially offered the gem as a [[quest reward]]. | ||
Players can also purchase the gem from [[vendor]]s afterwards for a small amount of [[currency]]. | Players can also purchase the gem from [[vendor]]s 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 [[list of drop-only gems|Drop Only Gems]]. | ||
==Gems== | ==Gems== | ||
Revision as of 13:02, 20 April 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
Lua error: Error 1054: Unknown column 'cargo__vendor_rewards.reward' in 'where clause' Function: CargoSQLQuery::run Query: SELECT `cargo__items`.`_pageID` AS `items._pageID`,`cargo__items`.`_pageName` AS `items._pageName`,`cargo__items`.`name` AS `items.name`,`cargo__items`.`inventory_icon` AS `items.inventory_icon`,`cargo__items`.`html` AS `items.html`,`cargo__items`.`size_x` AS `items.size_x`,`cargo__items`.`size_y` AS `items.size_y` FROM `cargo__items` LEFT OUTER JOIN `cargo__versions` ON ((`cargo__items`.`release_version`=`cargo__versions`.`version`)) LEFT OUTER JOIN `cargo__vendor_rewards` ON ((`cargo__items`.`_pageName`=`cargo__vendor_rewards`.`reward`)) LEFT OUTER JOIN `cargo__quest_rewards` ON ((`cargo__items`.`_pageName`=`cargo__quest_rewards`.`reward`)) LEFT OUTER JOIN `cargo__skill_gems` ON ((`cargo__items`.`_pageName`=`cargo__skill_gems`.`_pageName`)) WHERE (`cargo__items`.`drop_enabled` = true
AND (`cargo__items`.`release_version` IS NULL OR `cargo__items`.`release_version` IS NOT NULL AND `cargo__versions`.`release_date` < 20240601134324 ) AND `cargo__items`.`base_item` IS NULL AND `cargo__items`.`base_item_id` IS NULL AND `cargo__items`.`base_item_page` IS NULL AND ((`cargo__vendor_rewards`.`reward` IS NOT NULL OR `cargo__quest_rewards`.`reward` IS NOT NULL) AND (`cargo__items`.`class`="Active Skill Gems" OR `cargo__items`.`class` = "Support Skill Gems"))) AND `cargo__items`.`_pageNamespace` IN (0,10016) GROUP BY `cargo__items`.`_pageID` ORDER BY `cargo__items`.`required_level_range_maximum`,`cargo__items`.`name` LIMIT 5000
.