Template:Drop enabled unique item table: Difference between revisions
Jump to navigation
Jump to search
>OmegaK2 No edit summary |
m (26 revisions imported) |
||
(16 intermediate revisions by 5 users not shown) | |||
Line 1: | Line 1: | ||
<includeonly>{{# | <includeonly>{{#invoke: Item table|item_table | ||
{{#if: {{{ | |mode=item | ||
{{ | |q_tables = versions{{#if: {{{tables|}}}|, {{{tables}}}}} | ||
|q_join = items.release_version=versions.version{{#if: {{{join|}}}|, {{{join}}}}} | |||
|q_join=items.release_version=versions.version | |q_where = items.drop_enabled = true | ||
|q_where= | AND (items.release_version IS NULL | ||
|q_orderBy={{{ | OR items.release_version IS NOT NULL | ||
}} | AND versions.release_date < {{CURRENTTIMESTAMP}} | ||
}} | ) AND items.rarity_id = "unique" | ||
}}</includeonly><noinclude>{{ | {{#if: {{{where|}}} | ||
|AND ({{{where}}}) | |||
}} | |||
|q_orderBy = {{{orderby|items.required_level_range_maximum}}}, items.name | |||
}}{{#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}} | |||
</noinclude> |
Latest revision as of 03:34, 30 September 2024
Overview
This template queries for unique items based on a item class.
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 | Extra tables |
join | str | Extra joins |
where | str | Extra conditions |
orderby | str | Can be used to specify the primary field to order the results by. Default: items.required_level_range_maximum .
|
See also
The above documentation is transcluded from Template:Drop enabled unique item 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.