Template:FishTable

From Horizon Wiki Mirror
Revision as of 21:06, 4 September 2024 by imported>Aramachus (Created page with "<includeonly><onlyinclude> {{#dpl: |category = {{{1|}}} |category = {{{2|}}} |category = {{{3|}}} |notcategory = {{{notcat1|}}} |notcategory = {{{notcat2|}}} |notcategory = {{{notcat3|}}} |title = {{{title1|}}} |title = {{{title2|}}} |title = {{{title3|}}} |title = {{{title4|}}} |title = {{{title5|}}} |title = {{{title6|}}} |include={Fishing¦FishTable.dpl} |table=class="horizon-table fishing-table table-sm center-col-2",Name,Cap,Location,Bait,Rods |tablesortcol=2 }} </o...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Usage

Generates tables of fish.

  • Use the unnamed parameters 1, 2 and 3 to 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
{{FishTable|Fishing/Amateur}}

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