Template:Synthesis Recipe.RecipeList: Difference between revisions
imported>Aramachus filtering desynth recipes and HQs by categories |
imported>Aramachus mNo edit summary |
||
| Line 20: | Line 20: | ||
{{{cap}}} |
{{{cap}}} |
||
| |
| |
||
[[{{{crystal}}}]] |
[[{{{crystal}}} Crystal|{{Color|{{{crystal}}}|{{{crystal}}}}}]] |
||
|<!-- first ingredient always exists, there is no recipe with zero ingredients. quantities are optional with 1 being implied if none is given by the synthesis recipe template. Subsequent ingredients are checked if they exist, in a nested fashion --> |
|<!-- first ingredient always exists, there is no recipe with zero ingredients. quantities are optional with 1 being implied if none is given by the synthesis recipe template. Subsequent ingredients are checked if they exist, in a nested fashion --> |
||
<ul><li>[[{{{ingredient}}}]]{{#if:{{{ingredient quantity|}}}| x {{{ingredient quantity}}}}}</li><!-- |
<ul><li>[[{{{ingredient}}}]]{{#if:{{{ingredient quantity|}}}| x {{{ingredient quantity}}}}}</li><!-- |
||
| Line 33: | Line 33: | ||
-->}}}}|''none''}} |
-->}}}}|''none''}} |
||
</onlyinclude></includeonly> |
</onlyinclude></includeonly> |
||
| ⚫ | |||
{{#dpl: |
|||
| ⚫ | |||
|notcategory=Alchemy/Subcraft |
|||
|notcategory=Alchemy/Desynthesis |
|||
|notcategory=High Quality |
|||
|include={Synthesis Recipe¦RecipeList.dpl} |
|||
|table=class="horizon-table alchemy-table center-col-2 center-col-3",-,Item,Cap,Crystal,Ingredients,HQ |
|||
|tablesortcol=3<!-- need to use +1 here because the additional linebreak at the beginning of the phantom template that is used to apply classes and styles to the rows somehow counts as a column here --> |
|||
}} |
|||
Revision as of 11:50, 28 October 2024
Extension:DynamicPageList4 (DPL4), version 4.0.0: Error: MediaWiki\Extension\DynamicPageList4\Query::buildAndSelect - Template:Synthesis_Recipe.RecipeList: 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 - Template:Synthesis_Recipe.RecipeList 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 = 'Alchemy/Apprentice'))) LEFT JOIN `categorylinks` `ecl1` ON (((p.page_id = ecl1.cl_from) AND (ecl1.cl_to = 'Alchemy/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>
