Template:Drop enabled base item table: Difference between revisions

From Path of Exile 2 Wiki
Jump to navigation Jump to search
>Vinifera7
No edit summary
m (Does this fix anything?)
Line 2: Line 2:
|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 (datalength(items.release_version)=0 OR 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
|q_orderBy={{{orderby|items.required_level_range_maximum}}},items.name
}}</includeonly><noinclude>
}}</includeonly><noinclude>
{{Documentation}}
{{Documentation}}
</noinclude>
</noinclude>

Revision as of 10:29, 1 September 2021

Template documentation[view] [edit] [history] [purge]


Lua logo

This template uses the following modules:

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:Item table templates