List of modifiers affecting socketed gems: Difference between revisions
Neokowloon (talk | contribs) m (Neokowloon moved page List of modifiers affecting socketed skill gems to List of modifiers affecting socketed gems: skill gem is now a subset that contains active skill gem, but this list include support gem, thus rename) |
Neokowloon (talk | contribs) (add extraaaaa code to separate legacy mod) |
||
| Line 2: | Line 2: | ||
List of [[modifier]]s that increase the level of [[gem]]s. | List of [[modifier]]s that increase the level of [[gem]]s. | ||
Note that the | Note that the modifiers with the weighting of 0 can still be obtained: | ||
* | * {{c|mod|Competitor's}}: Some [[race]] starting items have this modifier. | ||
* {{c|mod|Citaqualotl's}}: drop only mod from [[Temple of Atzoatl]] (note that the required level = 1 versions are exclusive to [[Incursion league]]). | |||
* {{c|mod|Subterranean}} or {{c|mod|of the Underground}} (those from "Item" (or 1) [[Modifiers|Domain]] only): Drop-only mod in the [[Azurite Mine]]. | |||
* {{c|mod|of the Essence}}: {{il|Essence of Delirium}} or {{il|Glyphic Fossil}}. | |||
* The mod from mod domain = Delve can be obtained from {{il|Faceted Fossil}} or {{il|Tangled Fossil}} only. | |||
{{Modifier table | |||
|q_tables=spawn_weights | |||
|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%" ) | |||
AND mods.generation_type!=3 | |||
AND mods.id NOT IN ("GemLevelCorruption", "JunMasterLocalIncreaseSocketedSupportGemLevel1", "JunMasterLocalIncreaseSocketedSupportGemLevel2", "LocalIncreaseSocketedSupportGemLevelIntMasterVendorItem", "LocalIncreaseSocketedMinionGemLevelEnhancedMod", "LocalIncreaseSocketedTrapGemLevelEnhancedMod_", "SocketedGemQualityStrMasterVendorItem", "SocketedVaalGemsIncreaseCorrupted") | |||
|q_orderBy = mods.id | |||
|q_limit=1000 | |||
|level =1 | |||
|stat_text=1 | |||
|spawn_weights=1 | |||
|domain=1 | |||
}} | |||
</onlyinclude> | |||
==Legacy== | |||
{{Modifier table | {{Modifier table | ||
|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 | |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_having = SUM(spawn_weights.weight) = 0 | |||
|q_groupBy = spawn_weights._pageID | |||
|q_orderBy = mods.id | |q_orderBy = mods.id | ||
|q_limit=1000 | |q_limit=1000 | ||
| Line 14: | Line 35: | ||
|stat_text=1 | |stat_text=1 | ||
|spawn_weights=1 | |spawn_weights=1 | ||
|domain=1 | |||
}} | }} | ||
[[Category:Mod lists]] | [[Category:Mod lists]] | ||
Revision as of 16:32, 10 October 2021
List of modifiers that increase the level of 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).
- Subterranean or of the Underground (those from "Item" (or 1) 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` 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") 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") 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 .