Template:DeconstructionTableQueryDisplay: Difference between revisions
No edit summary |
No edit summary |
||
| Line 16: | Line 16: | ||
|fields=id, name, level, GROUP_CONCAT(" ", component, " (", min_amount=min_amount, "-", max_amount=max_amount, ")")=components | |fields=id, name, level, GROUP_CONCAT(" ", component, " (", min_amount=min_amount, "-", max_amount=max_amount, ")")=components | ||
|group by=id, name, level | |group by=id, name, level | ||
|where= | |where=components LIKE {{{energy|"Blacksmith"}}} | ||
|format=template | |format=template | ||
|template=DeconstructionTableQueryDisplay/Row | |template=DeconstructionTableQueryDisplay/Row | ||
Revision as of 04:50, 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 'components' in 'where 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` WHERE components LIKE "Blacksmith" GROUP BY id, name, level ORDER BY `level` LIMIT 600 |
|---|