User:Aramachus/Sandbox: Difference between revisions

From Horizon Wiki Mirror
← Older edit
imported>Aramachus
Content deleted Content added
imported>Aramachus
No edit summary
imported>Aramachus
No edit summary
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:

===Fish===
*Replace the <nowiki>{{Fishing|Recommended}}</nowiki> and similar calls inside the template with the helper templates <nowiki>{{Fishing/Recommended}}</nowiki> for all fish, otherwise this doesn't work.
*create a phantom template to try to force the list on a newline for the first element so it renders correctly.
*When getting by category, take Category:Fish and Category:Fishing (there is also Fish that is clammed only and there are objects in Category:Fishing that are not fish like rusty buckets).

{{#dpl:
{{#dpl:
⚫
|category=Windurst/Quests
|title=Phanauet Newt
|include={Fishing}:skill cap:location:bait:rods
|include={Quest}:startnpc,{Quest Header}:Start
|table=class="horizon-table fishing-table table-sm",Name,Cap,Location,Bait,Rods
|table=class="horizon-table npc-table",name,startnpc,Start
}}
}}
==Windurst Woods==

{{Zone/Quests|Windurst Woods}}
===Subcraft pages lists===
==Windurst Waters (North)==
* would need an elaborate phantom template to get it right.
{{Zone/Quests|Windurst Waters (North)}}
**first column has the name and adds the required crafts
==Windurst Waters (South)==
**crystal
{{Zone/Quests|Windurst Waters (South)}}
**all ingredients and their quantities
==Windurst Walls==
**HQs and their yields
{{Zone/Quests|Windurst Walls}}
**cap
==Port Windurst==
*Not sure if even possible when some items have multiple recipes on their page and only some of those are related to the craft in question. See [[Frog Lure]], only one recipe has smithing as subcraft. Result should look like e.g.: [[:Category:Goldsmithing/Apprentice]]
{{Zone/Quests|Port Windurst}}
*big problem is that the list cannot so far distinguish between synthesis and desynthesis recipes because they use the same template. Maybe if the phantom template outputs nothing if <nowiki>{{{result}}}</nowiki> is equal to <nowiki>%TITLE%</nowiki> or 'this'? Would probably need an extra css class that can collapse an empty row to 0 height. Can the phantom template assign a class to the row?

{{#dpl:
⚫
|category=Smithing/Subcraft
|category=Goldsmithing
|notcategory=Goldsmithing/Subcraft <!--exclude because the recipe will show up at its main craft again-->
|notcategory=High Quality
|include={Synthesis Recipe}:craft:crystal:ingredient:hq result:cap
|table=class="horizon-table smithing-table-alt table-sm",Name,Craft,Crystal,Ingredients,HQ,Cap
}}

===All NPCs (commented out)===
<!--{{#dpl:
|category=NPCs
|include={NPC}:type:occupation:location
|table=class="horizon-table sortable",Name,Type,Occupation,Location
|notnamespace=Category
|notnamespace=Template
}}-->

Latest revision as of 16:45, 26 June 2025

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

Windurst Woods

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

Windurst Waters (North)

Extension:DynamicPageList4 (DPL4), version 4.0.0: Error: MediaWiki\Extension\DynamicPageList4\Query::buildAndSelect - User:Aramachus-Sandbox: 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 - User:Aramachus-Sandbox 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 = 'Windurst_Waters_(North)/Quests'))) WHERE p.page_is_redirect = 0 LIMIT 500 </code>

Windurst Waters (South)

Extension:DynamicPageList4 (DPL4), version 4.0.0: Error: MediaWiki\Extension\DynamicPageList4\Query::buildAndSelect - User:Aramachus-Sandbox: 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 - User:Aramachus-Sandbox 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 = 'Windurst_Waters_(South)/Quests'))) WHERE p.page_is_redirect = 0 LIMIT 500 </code>

Windurst Walls

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

Port Windurst

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

Retrieved from "http://horizonwiki.lol/index.php?title=User:Aramachus/Sandbox&oldid=62559"