Template:Drop enabled gem table: Difference between revisions
Jump to navigation
Jump to search
m (Vinifera7 moved page Template:Query skill gems to Template:Drop enabled gem table) |
No edit summary |
||
Line 1: | Line 1: | ||
<includeonly>{{#invoke: Item table|item_table | <includeonly><onlyinclude>{{#invoke: Item table|item_table | ||
|mode=skill | |mode=skill | ||
|q_tables=versions | |q_tables=versions,{{{tables|}}} | ||
|q_join=items.release_version=versions.version{{#if: {{{join|}}}|,{{{join | |q_join=items.release_version=versions.version{{#if: {{{join|}}} | ,{{{join}}} }} | ||
|q_where=items.drop_enabled = true AND (items.release_version IS NULL OR items.release_version IS NOT NULL AND versions.release_date < {{CURRENTTIMESTAMP}}) | |q_where=items.class_id IN ("Active Skill Gem", "Support Skill Gem") AND items.drop_enabled = true AND (items.release_version IS NULL OR (items.release_version IS NOT NULL AND versions.release_date < {{CURRENTTIMESTAMP}})) {{#if: {{{where|}}} | AND ({{{where}}}) }} | ||
|q_orderBy={{{orderby|skill_gems.primary_attribute}}},items.name | |q_orderBy={{{orderby|skill_gems.primary_attribute}}},items.name | ||
|level=yes | |level={{{level|yes}}} | ||
| | |str={{{str|yes}}} | ||
|dex=yes | |dex={{{dex|yes}}} | ||
| | |int={{{int|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]]}}</ | }}{{#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]] }}</onlyinclude></includeonly> | ||
{{Documentation}} | {{Documentation}} | ||
Revision as of 21:59, 28 July 2024
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
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.