Template:ArmorTable: Difference between revisions

From Horizon Wiki Mirror
Content deleted Content added
imported>Aramachus
mNo edit summary
imported>Aramachus
added parameter to collapse tables
Line 1: Line 1:
<includeonly><onlyinclude><!--
<includeonly><onlyinclude><!--
-->{{#if:{{{collapse|}}}|<div class="mw-collapsible {{#switch: {{{collapse}}}|expanded=|collapsed=mw-collapsed|#default=mw-collapsed}}"><br>|}}
-->{{#dpl:
{{#dpl:
|category = {{{cat1}}}
|category = {{{cat1}}}
|category = {{{cat2|}}}
|category = {{{cat2|}}}
Line 18: Line 19:
|table=class="wikitable sortable",Name,Level,Slot,Jobs,Stats,Horizon Changes {{changes}}
|table=class="wikitable sortable",Name,Level,Slot,Jobs,Stats,Horizon Changes {{changes}}
|tablesortcol=2
|tablesortcol=2
}}{{#if:{{{collapse|}}}|</div><br>}}<!--
}}<!--
--></onlyinclude></includeonly>
--></onlyinclude></includeonly>
==Usage==
==Usage==
Line 24: Line 25:


Syntax:
Syntax:
<pre>{{ArmorTable|cat1|...|notcat1|...|title1|...|job|count}}</pre>
<pre>{{ArmorTable|cat1|...|notcat1|...|title1|...|job|collapse|count}}</pre>


*Use cat1, cat2, cat3 to include required categories
*Use cat1, cat2, cat3 to include required categories
Line 31: Line 32:
*Use title1, title2, ..., title6 to include specific pages
*Use title1, title2, ..., title6 to include specific pages
*Use job to include only gear by job XXX
*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)
*(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.
**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.
Line 51: Line 53:
Will give out all pieces of armor which are categorized as "Artifact Armor" and have "WHM" (or "all") in their job list.
Will give out all pieces of armor which are categorized as "Artifact Armor" and have "WHM" (or "all") in their job list.


{{ArmorTable|cat1=Artifact Armor|job=WHM}}
{{ArmorTable|cat1=Artifact Armor|job=WHM|classes=mw-collapsible}}




===Example 3===
===Example 3===
Syntax:
Syntax:
<pre>{{ArmorTable|cat1=Body|job=BLM}}</pre>
<pre>{{ArmorTable|cat1=Body|job=BLM|collapse=collapsed}}</pre>


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


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


===Example 4===
===Example 4===

Revision as of 11:11, 9 September 2023

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