User:Aramachus/Sandbox: Difference between revisions
imported>Aramachus mNo edit summary |
imported>Aramachus No edit summary |
||
| (6 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
===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 <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: |
{{#dpl: |
||
|category= |
|category=Windurst/Quests |
||
|include={Quest}:startnpc,{Quest Header}:Start |
|||
|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 |
|||
}} |
}} |
||
==Windurst Woods== |
|||
{{Zone/Quests|Windurst Woods}} |
|||
===All NPCs (commented out)=== |
|||
==Windurst Waters (North)== |
|||
<!--{{#dpl: |
|||
{{Zone/Quests|Windurst Waters (North)}} |
|||
|category=NPCs |
|||
==Windurst Waters (South)== |
|||
|include={NPC}:type:occupation:location |
|||
{{Zone/Quests|Windurst Waters (South)}} |
|||
| ⚫ | |||
==Windurst Walls== |
|||
|notnamespace=Category |
|||
{{Zone/Quests|Windurst Walls}} |
|||
|notnamespace=Template |
|||
==Port Windurst== |
|||
}}--> |
|||
{{Zone/Quests|Port Windurst}} |
|||
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>
