Template:Zone/NPCs: Difference between revisions
imported>Aramachus m sorting output based on location |
imported>Aramachus m added sortable class so npcs can be sorted by name which might be relevant for long tables |
||
| Line 2: | Line 2: | ||
| category={{{1|{{PAGENAME}}}}}/NPCs |
| category={{{1|{{PAGENAME}}}}}/NPCs |
||
| include={NPC¦Zone/NPCs.dpl} |
| include={NPC¦Zone/NPCs.dpl} |
||
| table=class="horizon-table npc-table table-sm center-col-2",-,Name,Location,Type |
| table=class="horizon-table npc-table table-sm center-col-2 sortable",-,Name,Location,Type |
||
| skipthispage=no |
| skipthispage=no |
||
| tablesortcol=2 |
| tablesortcol=2 |
||
Revision as of 10:21, 5 June 2025
Usage
Template which returns a table of all NPCs in a given area
Examples
{{Zone/NPCs|Valkurm Dunes}}
Extension:DynamicPageList4 (DPL4), version 4.0.0: Error: MediaWiki\Extension\DynamicPageList4\Query::buildAndSelect - Template:Zone-NPCs: 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:Zone-NPCs 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 = 'Valkurm_Dunes/NPCs'))) WHERE p.page_is_redirect = 0 LIMIT 500 </code>
{{Zone/NPCs|Lower Jeuno}}
Extension:DynamicPageList4 (DPL4), version 4.0.0: Error: MediaWiki\Extension\DynamicPageList4\Query::buildAndSelect - Template:Zone-NPCs: 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:Zone-NPCs 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 = 'Lower_Jeuno/NPCs'))) WHERE p.page_is_redirect = 0 LIMIT 500 </code>
