Template:Query items: Difference between revisions
Jump to navigation
Jump to search
>Illviljan (Created page with "<includeonly>{{#invoke: Item table|item_table |q_tables=versions{{#if: {{{tables|}}}|,{{{tables|}}}|}} |q_join=items.release_version=versions.version{{#if: {{{join|}}}|,{{{joi...") |
No edit summary |
||
| (2 intermediate revisions by one other user not shown) | |||
| Line 3: | Line 3: | ||
|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}}) {{#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}}) {{#if: {{{where|}}}|AND ({{{where|}}})|}} | ||
|q_orderBy={{{ | |q_orderBy={{{orderby|items.required_level_range_maximum}}},items.name | ||
}}</includeonly><noinclude>{{ | }}{{#if:{{{q_tables|}}}{{{q_join|}}}{{{q_where|}}}{{{q_orderBy|}}}|[[Category:Pages incorrectly using item table templates]]}}</includeonly><noinclude> | ||
{{Documentation}} | |||
</noinclude> | |||
Latest revision as of 16:40, 11 April 2024
Overview
This template queries for drop enabled items.
For more information, see Template:Item table.
Parameters
Parameters that can be specified in addition to the default {{item table}} parameters.
| Parameter | Value | Description |
|---|---|---|
| tables | str | Any extra tables. This should be used instead of q_tables to avoid overriding the defaults from this template.
|
| where | str | Any extra conditions. This should be used instead of q_where to avoid overriding the defaults from this template.
|
| join | str | any extra joins. This should be used instead of q_join to avoid overriding the defaults from this template.
|
The above documentation is transcluded from Template:Query items/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.