List of modifiers affecting socketed gems: Difference between revisions
Neokowloon (talk | contribs) No edit summary |
Neokowloon (talk | contribs) (if Haku is in the list, then lede and query should be changed) |
||
| Line 1: | Line 1: | ||
<onlyinclude> | <onlyinclude> | ||
List of [[modifier]]s that increase the level of [[gem]]s. | List of [[modifier]]s that increase the level of [[gem]]s or increase the quality of the gems. | ||
Note that the modifiers with the weighting of 0 can still be obtained: | Note that the modifiers with the weighting of 0 can still be obtained: | ||
| Line 11: | Line 11: | ||
|q_tables=spawn_weights | |q_tables=spawn_weights | ||
|q_join=mods._pageID=spawn_weights._pageID | |q_join=mods._pageID=spawn_weights._pageID | ||
|q_where=(mods.mod_group="IncreaseSocketedGemLevel" OR mods.mod_group="IncreaseSpecificSocketedGemLevel" OR mods.mod_group="SupportGemQuality" OR mods.mod_group="SupportSpecificGemQuality" OR mods.mod_group LIKE "%LocalSocketed%GemLevel%" OR mods.mod_group LIKE "%IncreaseSocketed%GemLevel%" ) | |q_where=(mods.mod_group="IncreaseSocketedGemLevel" OR mods.mod_group="IncreaseSpecificSocketedGemLevel" OR mods.mod_group="SupportGemQuality" OR mods.mod_group="SupportSpecificGemQuality" OR mods.mod_group = "SocketedGemQuality" OR mods.mod_group LIKE "%LocalSocketed%GemLevel%" OR mods.mod_group LIKE "%IncreaseSocketed%GemLevel%" ) | ||
AND mods.generation_type!=3 | AND mods.generation_type!=3 | ||
AND mods.id NOT IN ("GemLevelCorruption", "JunMasterLocalIncreaseSocketedSupportGemLevel1", "JunMasterLocalIncreaseSocketedSupportGemLevel2", "LocalIncreaseSocketedSupportGemLevelIntMasterVendorItem", "LocalIncreaseSocketedMinionGemLevelEnhancedMod", "LocalIncreaseSocketedTrapGemLevelEnhancedMod_", "SocketedGemQualityStrMasterVendorItem", "SocketedVaalGemsIncreaseCorrupted") | AND mods.id NOT IN ("GemLevelCorruption", "JunMasterLocalIncreaseSocketedSupportGemLevel1", "JunMasterLocalIncreaseSocketedSupportGemLevel2", "LocalIncreaseSocketedSupportGemLevelIntMasterVendorItem", "LocalIncreaseSocketedMinionGemLevelEnhancedMod", "LocalIncreaseSocketedTrapGemLevelEnhancedMod_", "SocketedGemQualityStrMasterVendorItem", "SocketedVaalGemsIncreaseCorrupted", "JunMaster2SocketedGemQuality1_") | ||
AND mods.id NOT LIKE "%JunMasterSocketed%" | |||
|q_orderBy = mods.id | |q_orderBy = mods.id | ||
|q_limit=1000 | |q_limit=1000 | ||
| Line 27: | Line 28: | ||
|q_tables=spawn_weights | |q_tables=spawn_weights | ||
|q_join=mods._pageID=spawn_weights._pageID | |q_join=mods._pageID=spawn_weights._pageID | ||
|q_where=(mods.mod_group="IncreaseSocketedGemLevel" OR mods.mod_group="IncreaseSpecificSocketedGemLevel" OR mods.mod_group="SupportGemQuality" OR mods.mod_group="SupportSpecificGemQuality") AND mods.generation_type!=3 AND mods.name NOT IN ( "Subterranean", "of the Essence", "of the Underground", "Competitor's") AND mods.id NOT IN ("LocalIncreaseSocketedMinionGemLevelEnhancedLevel50Mod") | |q_where=(mods.mod_group="IncreaseSocketedGemLevel" OR mods.mod_group="IncreaseSpecificSocketedGemLevel" OR mods.mod_group="SupportGemQuality" OR mods.mod_group="SupportSpecificGemQuality" OR mods.mod_group = "SocketedGemQuality") AND mods.generation_type!=3 AND mods.name NOT IN ( "Subterranean", "of the Essence", "of the Underground", "Competitor's") AND mods.id NOT IN ("LocalIncreaseSocketedMinionGemLevelEnhancedLevel50Mod") | ||
|q_having = SUM(spawn_weights.weight) = 0 | |q_having = SUM(spawn_weights.weight) = 0 | ||
|q_groupBy = spawn_weights._pageID | |q_groupBy = spawn_weights._pageID | ||
Revision as of 16:45, 10 October 2021
List of modifiers that increase the level of gems or increase the quality of the gems.
Note that the modifiers with the weighting of 0 can still be obtained:
- Competitor's: Some race starting items have this modifier.
- Citaqualotl's: drop only mod from Temple of Atzoatl (note that the required level = 1 versions are exclusive to Incursion league which cannot be obtained, except trading with players in permanent leagues).
- Subterranean or of the Underground (those from "Item" modifiers domain only): Drop-only mod in the Azurite Mine.
- of the Essence:
Essence of DeliriumEssence of DeliriumStack Size: 9
Essence Tier: 8Upgrades a normal item to rare or reforges a rare item, guaranteeing one property
Weapon: Your Hits inflict Decay, dealing 700 Chaos Damage per second for 8 seconds
Gloves: Socketed Gems deal 30% more Damage over Time
Boots: Cannot be Poisoned
Body Armour: 25% reduced Chaos Damage taken over time
Helmet: +2 to Level of Socketed Aura Gems
Shield: +15% Chance to Block Spell Damage while on Low Life
Quiver: 25% increased Effect of your Marks
Amulet: (6-7)% Chance to Block Spell Damage
Ring: +(12-15)% to Damage over Time Multiplier
Belt: +50% to Chaos Resistance during any Flask EffectRight click this item then left click a normal or rare item to apply it.
or 
Glyphic FossilGlyphic FossilStack Size: 10Has a Corrupt Essence modifierPlace in a Resonator to influence item crafting.
. - The mod from mod domain = Delve can be obtained from
Faceted FossilFaceted FossilStack Size: 10More Gem modifiersPlace in a Resonator to influence item crafting.
or 
Tangled FossilTangled FossilStack Size: 10Makes a random modifier type much more likely and prevents
another random modifier type
Effects revealed once resonator is fully socketedPlace in a Resonator to influence item crafting.
only.
Lua error: Error 1054: Unknown column 'cargo__mods.mod_group' in 'where clause' Function: CargoSQLQuery::run Query: SELECT `cargo__mods`.`_pageID` AS `mods._pageID`,`cargo__mods`.`_pageName` AS `mods._pageName`,`cargo__mods`.`id` AS `mods.id`,`cargo__mods`.`name` AS `mods.name`,`cargo__mods`.`domain` AS `mods.domain`,`cargo__mods`.`required_level` AS `mods.required_level`,`cargo__mods`.`stat_text` AS `mods.stat_text` FROM `cargo__mods` LEFT OUTER JOIN `cargo__spawn_weights` ON ((`cargo__mods`.`_pageID`=`cargo__spawn_weights`.`_pageID`)) WHERE (`cargo__mods`.`mod_group`="IncreaseSocketedGemLevel" OR `cargo__mods`.`mod_group`="IncreaseSpecificSocketedGemLevel" OR `cargo__mods`.`mod_group`="SupportGemQuality" OR `cargo__mods`.`mod_group`="SupportSpecificGemQuality" OR `cargo__mods`.`mod_group` = "SocketedGemQuality" OR `cargo__mods`.`mod_group` LIKE "%LocalSocketed%GemLevel%" OR `cargo__mods`.`mod_group` LIKE "%IncreaseSocketed%GemLevel%" )
AND `cargo__mods`.`generation_type`!=3
AND `cargo__mods`.`id` NOT IN ("GemLevelCorruption", "JunMasterLocalIncreaseSocketedSupportGemLevel1", "JunMasterLocalIncreaseSocketedSupportGemLevel2", "LocalIncreaseSocketedSupportGemLevelIntMasterVendorItem", "LocalIncreaseSocketedMinionGemLevelEnhancedMod", "LocalIncreaseSocketedTrapGemLevelEnhancedMod_", "SocketedGemQualityStrMasterVendorItem", "SocketedVaalGemsIncreaseCorrupted", "JunMaster2SocketedGemQuality1_")
AND `cargo__mods`.`id` NOT LIKE "%JunMasterSocketed%" GROUP BY `cargo__mods`.`_pageID` ORDER BY `cargo__mods`.`id` LIMIT 1000
.
Legacy
Lua error: Error 1054: Unknown column 'cargo__mods.mod_group' in 'where clause' Function: CargoSQLQuery::run Query: SELECT `cargo__mods`.`_pageID` AS `mods._pageID`,`cargo__mods`.`_pageName` AS `mods._pageName`,`cargo__mods`.`id` AS `mods.id`,`cargo__mods`.`name` AS `mods.name`,`cargo__mods`.`domain` AS `mods.domain`,`cargo__mods`.`required_level` AS `mods.required_level`,`cargo__mods`.`stat_text` AS `mods.stat_text` FROM `cargo__mods` LEFT OUTER JOIN `cargo__spawn_weights` ON ((`cargo__mods`.`_pageID`=`cargo__spawn_weights`.`_pageID`)) WHERE (`cargo__mods`.`mod_group`="IncreaseSocketedGemLevel" OR `cargo__mods`.`mod_group`="IncreaseSpecificSocketedGemLevel" OR `cargo__mods`.`mod_group`="SupportGemQuality" OR `cargo__mods`.`mod_group`="SupportSpecificGemQuality" OR `cargo__mods`.`mod_group` = "SocketedGemQuality") AND `cargo__mods`.`generation_type`!=3 AND `cargo__mods`.`name` NOT IN ( "Subterranean", "of the Essence", "of the Underground", "Competitor's") AND `cargo__mods`.`id` NOT IN ("LocalIncreaseSocketedMinionGemLevelEnhancedLevel50Mod") GROUP BY `cargo__spawn_weights`.`_pageID` HAVING SUM(`cargo__spawn_weights`.`weight`) = 0 ORDER BY `cargo__mods`.`id` LIMIT 1000 .