Template:Drop enabled gem table: Difference between revisions

From Path of Exile 2 Wiki
Jump to navigation Jump to search
(Allow to query meta gems)
(Option to turn off gem_tier column for lineage supports (all have 0))
 
(One intermediate revision by one other user not shown)
Line 2: Line 2:
|mode = skill
|mode = skill
|tables = versions{{#if: {{{tables|}}}|, {{{tables}}}}}
|tables = versions{{#if: {{{tables|}}}|, {{{tables}}}}}
|join = items.release_version=versions.version{{#if: {{{join|}}}|, {{{join|}}}|}}
|join = items.release_version=versions.version{{#if: {{{join|}}}|, {{{join}}}}}
|where = items.drop_enabled = true AND (items.release_version IS NULL OR items.release_version IS NOT NULL AND versions.release_date < {{CURRENTTIMESTAMP}}) AND items.class_id IN ("Active Skill Gem", "Support Skill Gem", "Meta Skill Gem") {{#if: {{{where|}}}|AND ({{{where|}}})|}}  
|where = items.drop_enabled = true
  AND (items.release_version IS NULL  
    OR items.release_version IS NOT NULL
    AND versions.release_date < {{CURRENTTIMESTAMP}}
  )
  AND items.class_id IN ("Active Skill Gem", "Support Skill Gem", "Meta Skill Gem")
  {{#if: {{{where|}}}
  |AND ({{{where}}})
  }}
|orderBy = {{{orderBy|{{{orderby|skill_gems.primary_attribute}}}}}}, items.name
|orderBy = {{{orderBy|{{{orderby|skill_gems.primary_attribute}}}}}}, items.name
|gem_tier=yes
|gem_tier={{{gem_tier|yes}}}
|int=yes
|int=yes
|dex=yes
|dex=yes
|str=yes
|str=yes
}}{{#if:{{{q_tables|}}}{{{q_fields|}}}{{{q_join|}}}{{{q_where|}}}{{{q_groupBy|}}}{{{q_having|}}}{{{q_orderBy|}}}{{{q_limit|}}}{{{q_offset|}}}|[[Category:Pages incorrectly using item table templates]]}}</includeonly><noinclude>
}}</includeonly><noinclude>
{{Documentation}}
{{Documentation}}
</noinclude>
</noinclude>

Latest revision as of 15:26, 31 August 2025

Template documentation[view] [edit] [history] [purge]


Lua logo

This template uses the following modules:

Overview

This template queries for skill gems, ignoring drop disabled and future skill gems.

For more information, see Template:Gem table.

Parameters

Parameters that can be specified in addition to the default {{item table}} parameters.

Parameter Value Description
tables str Extra tables
join str Extra joins
where str Extra conditions
gem_tier bool Wheter to show gem tier column (default: true)

See also

This table:
Template Purpose
{{Item table}} Query and display a table of items
{{Drop enabled item table}} Query and display a table of drop-enabled items
{{Drop disabled item table}} Query and display a table of drop-disabled items
{{Drop enabled base item table}} Query and display a table of drop-enabled base items
{{Drop disabled base item table}} Query and display a table of drop-disabled base items
{{Drop enabled unique item table}} Query and display a table of drop-enabled unique items
{{Drop disabled unique item table}} Query and display a table of drop-disabled unique items
{{Gem table}} Query and display a table of gems
{{Drop enabled gem table}} Query and display a table of drop enabled gems
The above documentation is transcluded from Template:Drop enabled gem table/doc. (edit | history)
Editors can experiment in this template's sandbox (edit | diff) and testcases (create) pages.
Please add categories to the /doc subpage. Subpages of this template.
Retrieved from "https://www.poe2wiki.net/index.php?title=Template:Drop_enabled_gem_table&oldid=51331"