Template:Drop enabled unique item table: Difference between revisions

From Path of Exile 2 Wiki
Jump to navigation Jump to search
No edit summary
(Default value)
(6 intermediate revisions by 2 users not shown)
Line 1: Line 1:
<includeonly>{{#invoke: Item table|item_table
<includeonly>{{#invoke:Item table|item_table
|q_tables=versions{{#if: {{{tables|}}}|,{{{tables|}}}|}}
|mode = item
|q_join=items.release_version=versions.version{{#if: {{{join|}}}|,{{{join|}}}|}}
|tables = versions{{#if: {{{tables|}}}|, {{{tables}}}}}
|q_where=items.rarity_id = "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|}}})|}}  
|join = items.release_version=versions.version{{#if: {{{join|}}}|, {{{join}}}}}
|q_orderBy={{{orderby|items.required_level_range_maximum}}},items.name
|where = items.drop_enabled = true
  AND (items.release_version IS NULL  
    OR items.release_version IS NOT NULL
    AND versions.release_date < {{CURRENTTIMESTAMP}}
  ) AND items.rarity_id = "unique"
  {{#if: {{{where|}}}
  |AND ({{{where}}})
  }}
|orderBy = {{{orderBy|{{{orderby|items.required_level_range_maximum}}}}}}, items.name
|default = No results found [[Category:Item tables without results]]
}}{{#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 17:36, 11 November 2024

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


Lua logo

This template uses the following modules:

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

This table:
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 unique item table/doc. (edit | history)
Editors can experiment in this template's sandbox (create | mirror) and testcases (create) pages.
Please add categories to the /doc subpage. Subpages of this template.
Retrieved from "https://www.poe2wiki.net/index.php?title=Template:Drop_enabled_unique_item_table&oldid=9408"