Template:Drop enabled gem table: Difference between revisions
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...") |
>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. | |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_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:00, 3 February 2019
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
| 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 enabled base item table}} | Query and display a table of drop enabled base items |
| {{Drop enabled unique item table}} | Query and display a table of drop enabled 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.