Template:Drop enabled item table: Difference between revisions
		
		
		
		Jump to navigation
		Jump to search
		
m (Vinifera7 moved page Template:Query items to Template:Drop enabled item table)  | 
				No edit summary  | 
				||
| Line 1: | Line 1: | ||
<includeonly>{{#invoke: Item table|item_table  | <includeonly>{{#invoke: Item table|item_table  | ||
|mode=item  | |mode=item  | ||
|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.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  | ||
|q_orderBy={{{orderby|items.required_level_range_maximum}}},items.name  |   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|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>  | }}{{#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>  | </noinclude>  | ||
Revision as of 16:35, 11 May 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 | 
|---|---|---|
| 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 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.