Template:Drop enabled gem table: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
m (Ugh, nevermind. Undo revision 1476744 by CrogenitorSeims (talk)) |
||
Line 5: | Line 5: | ||
|q_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_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={{{orderby|skill_gems.primary_attribute}}},items.name | |q_orderBy={{{orderby|skill_gems.primary_attribute}}},items.name | ||
|level= | |level=yes | ||
| | |int=yes | ||
|dex= | |dex=yes | ||
| | |str=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]]}}</includeonly><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}} | {{Documentation}} | ||
</noinclude> | </noinclude> |
Revision as of 22:01, 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.