Template:Regional Goods

Usage

Template that allows to display the goods from Category:Regional Merchants.

For details on the row formatting, look into the dpl phantom template Template:Regional Goods.dpl

• First parameter is mandatory and is the Region
• Optional parameter insert can be specified to format the table without headings and a surrounding box so it can fit into a table cell.
• Optional parameter cssclasses can be used to specify further css classes to format the table.

Examples

Usage as ordinary table

{{Regional Goods|Elshimo Uplands}}

Extension:DynamicPageList4 (DPL4), version 4.0.0: Error: MediaWiki\Extension\DynamicPageList4\Query::buildAndSelect - Template:Regional_Goods: 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:Regional_Goods 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 = 'Elshimo_Uplands/Regional_Goods'))) WHERE p.page_is_redirect = 0 LIMIT 500 </code>

Usage as inserted table into a surrounding table

{| class="horizon-table npc-table table-sm"
! Goods
|-
| {{Regional Goods|Elshimo Uplands|insert=true}}
|}

Goods

Extension:DynamicPageList4 (DPL4), version 4.0.0: Error: MediaWiki\Extension\DynamicPageList4\Query::buildAndSelect - Template:Regional_Goods: 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:Regional_Goods 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 = 'Elshimo_Uplands/Regional_Goods'))) WHERE p.page_is_redirect = 0 LIMIT 500 </code>