Template:DeconstructionTableQueryDisplay: Difference between revisions
No edit summary |
No edit summary |
||
| Line 14: | Line 14: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=DeconstructionTable | tables=DeconstructionTable | ||
|fields=id, name, level, GROUP_CONCAT(component, min_amount=min_amount, max_amount=max_amount)=component | |fields=id, name, level, GROUP_CONCAT(component, " (", min_amount=min_amount, "-", max_amount=max_amount")")=component | ||
|group by=id, name, level | |group by=id, name, level | ||
|format=template | |format=template | ||
Revision as of 04:42, 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 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '")") AS `component` FROM `cargo__DeconstructionTable` GROUP BY id, name, le' at line 1
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 `component` FROM `cargo__DeconstructionTable` GROUP BY id, name, level ORDER BY `level` LIMIT 600 |
|---|