The wiki is currently a work in progress. If you'd like to help out, please check the Community Portal and our getting started guide. Also, check out our sister project on poewiki.net.

Template:Drop enabled gem table: Difference between revisions

From Path of Exile 2 Wiki
Jump to navigation Jump to search
>OmegaK2
No edit summary
>OmegaK2
No edit summary
Line 3: Line 3:
|q_tables=versions{{#if: {{{tables|}}}|,{{{tables|}}}|}}
|q_tables=versions{{#if: {{{tables|}}}|,{{{tables|}}}|}}
|q_join=items.release_version=versions.version{{#if: {{{join|}}}|,{{{join|}}}|}}
|q_join=items.release_version=versions.version{{#if: {{{join|}}}|,{{{join|}}}|}}
|q_where=items.rarity_id = "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|}}})|}}  
|q_where=items.rarity_id = "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_id = "Active Skill Gem" OR items.class_id = "Support Skill Gem") {{#if: {{{where|}}}|AND ({{{where|}}})|}}  
|q_orderBy={{{q_orderBy|skill_gems.primary_attribute,items.name}}}
|q_orderBy={{{q_orderBy|skill_gems.primary_attribute,items.name}}}
|level=yes
|level=yes

Revision as of 16:05, 3 February 2019

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

See also

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