[dismiss]
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/sandbox: Difference between revisions
Jump to navigation
Jump to search
Mefisto1029 (talk | contribs) (Replaced level with gem_tier) |
Mefisto1029 (talk | contribs) (Allow to query meta gems) |
||
| Line 3: | Line 3: | ||
|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") {{#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=yes | ||
Latest revision as of 16:49, 21 January 2025
This is the template sandbox page for Template:Drop enabled gem table (diff).
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 |
The above documentation is transcluded from Template:Drop enabled gem table/doc.
Editors can experiment in this template's sandbox and testcases pages.
Please add categories to the /doc subpage. Subpages of this template.
Editors can experiment in this template's sandbox and testcases pages.
Please add categories to the /doc subpage. Subpages of this template.