Template:Drop enabled base item table: Difference between revisions

Latest revision as of 17:14, 26 October 2024

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

This template queries for base 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
- [[Concept:Base items]]
+|tables = versions{{#if: {{{tables|}}}|, {{{tables}}}}}
- {{#if: {{{extra_conditions|}}}|<q>{{{extra_conditions|}}}</q>|}}
+|join = items.release_version=versions.version{{#if: {{{join|}}}|, {{{join}}}}}
-|q_sort=Has level requirement, Has name
+|where = items.drop_enabled = true
-}}--></includeonly><noinclude>{{documentation}}</noinclude>
+  AND (items.release_version IS NULL
+    OR items.release_version IS NOT NULL
+    AND versions.release_date < {{CURRENTTIMESTAMP}}
+  ) AND items.base_item IS NULL
+  AND items.base_item_id IS NULL
+  AND items.base_item_page IS NULL
+  {{#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>