Template:Drop enabled gem table: Difference between revisions

From Path of Exile 2 Wiki
Jump to navigation Jump to search
>OmegaK2
(Created page with "<includeonly>{{#invoke: Item table|item_table |mode=skill |q_tables=versions{{#if: {{{tables|}}}|,{{{tables|}}}|}} |q_join=items.release_version=versions.version{{#if: {{{join...")
 
No edit summary
(13 intermediate revisions by 4 users not shown)
Line 1: Line 1:
<includeonly>{{#invoke: Item table|item_table
<includeonly>{{#invoke:Item table|item_table
|mode=skill
|mode = skill
|q_tables=versions{{#if: {{{tables|}}}|,{{{tables|}}}|}}
|tables = versions{{#if: {{{tables|}}}|, {{{tables}}}}}
|q_join=items.release_version=versions.version{{#if: {{{join|}}}|,{{{join|}}}|}}
|join = items.release_version=versions.version{{#if: {{{join|}}}|, {{{join|}}}|}}
|q_where=items.rarity = "Normal" AND 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 = "Active Skill Gems" OR items.class = "Support Skill Gems") {{#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") {{#if: {{{where|}}}|AND ({{{where|}}})|}}  
|q_orderBy={{{q_orderBy|skill_gems.primary_attribute,items.name}}}
|orderBy = {{{orderBy|{{{orderby|skill_gems.primary_attribute}}}}}}, items.name
|level=yes
|level=yes
|int=yes
|int=yes
|dex=yes
|dex=yes
|str=yes
|str=yes
}}</includeonly><noinclude>{{documentation}}</noinclude>
}}{{#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>
{{Documentation}}
</noinclude>

Revision as of 22:41, 26 October 2024

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:Skill 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

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 (create | mirror) 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=8908"