Template:Drop enabled gem table: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
(7 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
<includeonly | <includeonly>{{#invoke:Item table|item_table | ||
|mode=skill | |mode = skill | ||
| | |tables = versions{{#if: {{{tables|}}}|, {{{tables}}}}} | ||
| | |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|}}})|}} | ||
| | |orderBy = {{{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]] }}</ | }}{{#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> |
Revision as of 22:41, 26 October 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
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.