User:Aramachus/Sandbox

Fish

• Replace the {{Fishing|Recommended}} and similar calls inside the template with the helper templates {{Fishing/Recommended}} 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).

Name	Cap	Location	Bait	Rods
Phanauet Newt	4	*Carpenters' Landing (Central Landing) Phanauet Channel (Emfea Waterway) Phanauet Channel (Newtpool) *	*Fly Lure * Frog Lure Lufaise Fly Shell Bug	*Carbon Fishing Rod Composite Fishing Rod Ebisu Fishing Rod Halcyon Rod Lu Shang's Fishing Rod

Subcraft pages lists

• would need an elaborate phantom template to get it right.
  • first column has the name and adds the required crafts
  • crystal
  • all ingredients and their quantities
  • HQs and their yields
  • cap
• 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
• 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 {{{result}}} is equal to %TITLE% 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?

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 'ecl1.cl_to' in 'WHERE' 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 = 'Smithing/Subcraft'))) JOIN `categorylinks` `cl2` ON (((p.page_id = cl2.cl_from) AND (cl2.cl_to = 'Goldsmithing'))) LEFT JOIN `categorylinks` `ecl1` ON (((p.page_id = ecl1.cl_from) AND (ecl1.cl_to = 'Goldsmithing/Subcraft'))) LEFT JOIN `categorylinks` `ecl2` ON (((p.page_id = ecl2.cl_from) AND (ecl2.cl_to = 'High_Quality'))) WHERE p.page_is_redirect = 0 AND ecl1.cl_to IS NULL AND ecl2.cl_to IS NULL LIMIT 500 </code>