Template:ArmorTable

From Horizon Wiki Mirror
Revision as of 17:20, 30 August 2023 by imported>Aramachus (Created page with "<includeonly><onlyinclude><!-- -->{{#dpl: |category = {{{cat1}}} |category = {{{cat2|}}} |category = {{{cat3|}}} |notcategory = {{{notcat1|}}} |notcategory = {{{notcat2|}}} |notcategory = {{{notcat3|}}} |count = {{{count|}}} |include={Item Statistics¦ArmorTable.dpl},{HorizonChangesBox} |table=class="wikitable sortable",Name,Level,Slot,Stats,Horizon Changes {{changes}} |tablesortcol=2 }}<!-- --></onlyinclude></includeonly> <!-- --> ==Usage== Wrapper Template to generate...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Usage

Wrapper Template to generate lists of armor based on categories.

Syntax:

{{ArmorTable|cat1|...|notcat1|...}}
  • Use cat1, cat2, cat3 to include required categories
  • Use notcat1, notcat2, notcat2 to exclude categories

Examples

Example tables have been limited to output only 5 items (through the optional parameter count=5) because they serve only as examples. The syntax shown in the examples would generate the full tables.

Example 1

Syntax:

{{ArmorTable|cat1=Artifact Armor|cat2=Feet|notcat1=White Mage}}

Will give out all pieces of armor which are categorized as "Artifact Armor" and "Feet" while excluding those, which are categorized as "White Mage". ("All AF Feet except WHM feet")

Extension:DynamicPageList4 (DPL4), version 4.0.0: Error: MediaWiki\Extension\DynamicPageList4\Query::buildAndSelect - Template:ArmorTable: The DynamicPageList4 extension (version 4.0.0) produced a SQL statement which led to a Database error.<br/>The reason may be an internal error of DynamicPageList4 or an error that you made; especially when using parameters like 'categoryregexp' or 'titleregexp'. Usage of non-greedy <code>*?</code> matching patterns are not supported.<br/>The error message was:<br/><code>Error 1054: Unknown column 'ecl1.cl_to' in 'WHERE' Function: MediaWiki\Extension\DynamicPageList4\Query::buildAndSelect - Template:ArmorTable Query: SET STATEMENT max_statement_time=10 FOR SELECT DISTINCT p.page_namespace AS `page_namespace`,p.page_id AS `page_id`,p.page_title AS `page_title` FROM `page` `p` JOIN `categorylinks` `cl1` ON (((p.page_id = cl1.cl_from) AND (cl1.cl_to = 'Artifact_Armor'))) JOIN `categorylinks` `cl2` ON (((p.page_id = cl2.cl_from) AND (cl2.cl_to = 'Feet'))) LEFT JOIN `categorylinks` `ecl1` ON (((p.page_id = ecl1.cl_from) AND (ecl1.cl_to = 'White_Mage'))) WHERE p.page_is_redirect = 0 AND ecl1.cl_to IS NULL LIMIT 5 </code>