Template:DeconstructionTableQueryDisplay: Difference between revisions

Revision as of 04:46, 17 April 2025

USAGE: {{DeconstructionTableQueryDisplay|energy=Blacksmith}}, where Blacksmith is the energy name.

TODO: Make it so all energies the item creates are included BUG: Iron tools for some reason dont get ordered properly

Image	Name	Level	Component	Amount Error 1054: Unknown column 'component' in 'having clause' Function: CargoSQLQuery::run Query: SELECT `id` AS `id`,`name` AS `name`,`level` AS `level`,GROUP_CONCAT(" ", component, " (", min_amount=min_amount, "-", max_amount=max_amount, ")") AS `components` FROM `cargo__DeconstructionTable` GROUP BY id, name, level HAVING component="Blacksmith" ORDER BY `level` LIMIT 600

@@ Line 16: / Line 16: @@
 |fields=id, name, level, GROUP_CONCAT(" ", component, " (", min_amount=min_amount, "-", max_amount=max_amount, ")")=components
 |group by=id, name, level
-|where=component={{{energy|Blacksmith}}}
+|having=component={{{energy|"Blacksmith"}}}
 |format=template
 |template=DeconstructionTableQueryDisplay/Row