Template:ArmorTable

From Horizon Wiki Mirror
Revision as of 11:11, 9 September 2023 by imported>Aramachus (added parameter to collapse tables)

Usage

Wrapper Template to generate lists of armor based on categories.

Syntax:

{{ArmorTable|cat1|...|notcat1|...|title1|...|job|collapse|count}}
  • Use cat1, cat2, cat3 to include required categories
(note: you can use {{!}} to use a logical OR in a category)
  • Use notcat1, notcat2, notcat2 to exclude categories
  • Use title1, title2, ..., title6 to include specific pages
  • Use job to include only gear by job XXX
  • Use collapse to make the table collapsible. collapse=collapsed makes it collapsed by default. collapse=expand to make it expanded by default. (collapsed is also the default when entering anything else for the collapse parameter).
  • (The count parameter is mainly used for testing)
    • Also: count does not work with job parameter since the job parameter seems to filter after generating the list and after the count parameter cropped the list.

Examples

Some 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>

Example 2

Syntax:

{{ArmorTable|cat1=Artifact Armor|job=WHM}}

Will give out all pieces of armor which are categorized as "Artifact Armor" and have "WHM" (or "all") in their job list.


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 'cl1.cl_to' in 'ON' 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'))) WHERE p.page_is_redirect = 0 LIMIT 500 </code>


Example 3

Syntax:

{{ArmorTable|cat1=Body|job=BLM|collapse=collapsed}}

Will give out all body pieces equippable by BLM in a collapsible table that is collapsed by default.


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 'cl1.cl_to' in 'ON' 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 = 'Body'))) WHERE p.page_is_redirect = 0 LIMIT 500 </code>


Example 4

Syntax:

{{ArmorTable|title1=Evoker's Spats|title2=Evoker's Horn}}

Will give out a list of those two specified items


Name Level Slot Jobs Stats Horizon Changes HorizonXI specific changes
Evoker's Spats 52 Legs {{#replace:{{#replace:{{#replace:SMN|
| }}|
| }}|]]/|]]/}}
{{#replace:{{#replace:DEF: 25 MP +15 Evasion skill +10
Avatar: Enhances accuracy
Enmity -2|
| }}|
| }}
none
Evoker's Horn 60 Head {{#replace:{{#replace:{{#replace:SMN|
| }}|
| }}|]]/|]]/}}
{{#replace:{{#replace:DEF: 15 MP +20 INT +3
Summoning Magic Skill +5
Avatar: Enmity -3|
| }}|
| }}
none

Further Information on dpl3 Usage