Template:ArmorTable

Usage

Wrapper Template to generate lists of armor based on categories.

Syntax:

{{ArmorTable|cat1|...|notcat1|...|title1|...job|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
• (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{{!}}Artifact Armor +1|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}}

Will give out all body pieces equippable by BLM.

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

• https://help.fandom.com/wiki/Extension:DPL3/Parameters:_Criteria_for_page_selection
• https://help.fandom.com/wiki/Extension:DPL3/Parameters:_Controlling_output_format
• https://help.fandom.com/wiki/Extension:DPL3/Parameters:_Controlling_output_volume