Template:Drop enabled unique item table: Difference between revisions
Jump to navigation
Jump to search
>OmegaK2 No edit summary |
>Illviljan m (If should close properly) |
||
| Line 4: | Line 4: | ||
|q_tables=versions{{#if: {{{tables|}}}|,{{{tables|}}}|}} | |q_tables=versions{{#if: {{{tables|}}}|,{{{tables|}}}|}} | ||
|q_join=items.release_version=versions.version{{#if: {{{join|}}}|,{{{join|}}}|}} | |q_join=items.release_version=versions.version{{#if: {{{join|}}}|,{{{join|}}}|}} | ||
|q_where=items.rarity = "Unique" 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| | |q_where=items.rarity = "Unique" 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={{{q_orderBy|items.required_level_range_maximum,items.name}}} | |q_orderBy={{{q_orderBy|items.required_level_range_maximum,items.name}}} | ||
}} | }} | ||
}} | }} | ||
}}</includeonly><noinclude>{{documentation}}</noinclude> | }}</includeonly><noinclude>{{documentation}}</noinclude> | ||
Revision as of 00:26, 7 January 2018
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.