Template:Drop enabled base item table/sandbox: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
Line 1: | Line 1: | ||
<includeonly>{{ | <includeonly>{{Item table/sandbox | ||
|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_id = "normal" 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_where=items.rarity_id = "normal" 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={{{orderby|{{{q_orderBy|items.required_level_range_maximum,items.name}}}}}} | |q_orderBy={{{orderby|{{{q_orderBy|items.required_level_range_maximum,items.name}}}}}} | ||
}}</includeonly><noinclude>{{ | }}</includeonly><noinclude> | ||
{{Documentation}} | |||
</noinclude> |
Revision as of 15:06, 16 July 2021
This is the template sandbox page for Template:Drop enabled base item table (diff).
Overview
This template queries for base 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
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 enabled base item table}} | Query and display a table of drop enabled base items |
{{Drop enabled unique item table}} | Query and display a table of drop enabled 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 base 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.