Template:Drop enabled unique item table: Difference between revisions

Latest revision as of 17:36, 11 November 2024

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

This template queries for unique items based on a item class.

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`.

@@ Line 1: / Line 1: @@
-<includeonly>{{#invoke: Item2|item_table
+<includeonly>{{#invoke:Item table|item_table
-|conditions={{#if: {{{item_class|}}}|[[Has item class::{{{item_class|}}}]]|}}
+|mode = item
- [[Has rarity::Unique]]
+|tables = versions{{#if: {{{tables|}}}|, {{{tables}}}}}
- [[Is drop enabled::true]]
+|join = items.release_version=versions.version{{#if: {{{join|}}}|, {{{join}}}}}
- <q>{{{extra_conditions|}}}</q>
+|where = items.drop_enabled = true
-|q_sort=Has level requirement, Has name
+  AND (items.release_version IS NULL
-}}</includeonly><noinclude>{{documentation}}</noinclude>
+    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>
+{{Documentation}}
+</noinclude>