Template:Drop enabled unique item table: Difference between revisions

Revision as of 21:05, 2 January 2018

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>{{#if: {{{conditions|}}}|[[Category:Broken item tables]]|
-|conditions={{#if: {{{item_class|}}}|[[Has item class::{{{item_class|}}}]]|}}
+{{#if: {{{extra_conditions|}}}|[[Category:Broken item tables]]|
- [[Concept:Acquirable unique items]]
+{{Item table
- {{#if: {{{extra_conditions|}}}|<q>{{{extra_conditions|}}}</q>|}}
+|q_tables=versions
-|q_sort=Has level requirement, Has name
+|q_join=items.release_version=versions.version
-}}--></includeonly><noinclude>{{documentation}}</noinclude>
+|q_where=items.rarity = "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|}}}|}}
+|q_orderBy={{{q_orderBy|items.required_level_range_maximum,items.name}}}
+}}
+}}
+}}</includeonly><noinclude>{{documentation}}</noinclude>