Template:DeconstructionTableQueryDisplay: Difference between revisions
No edit summary |
No edit summary |
||
| Line 13: | Line 13: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=DeconstructionTable | tables=DeconstructionTable | ||
|fields=id, name, level, GROUP_CONCAT(CONCAT(IF(component= | |fields=id, name, level, GROUP_CONCAT(CONCAT(IF(component={{{energy}}}, "'''", ""), component, IF(component={{{energy}}}, "'''", ""), ' (', min_amount,'-', max_amount, ')'))=components | ||
|group by=id, name, level | |group by=id, name, level | ||
|having=components like '%{{{energy|Blacksmith}}}%' | |having=components like '%{{{energy|Blacksmith}}}%' | ||
Revision as of 05:14, 17 April 2025
USAGE: {{DeconstructionTableQueryDisplay|energy=Blacksmith}}, where Blacksmith is the energy name.
TODO: Make the energy you look for bold BUG: Iron tools for some reason dont get ordered properly
| Image | Name | Level | Energies
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 '{{energy}}}, "", ""), component, IF(component={{{energy}}}, "", ""), ' (',' at line 1
Function: CargoSQLQuery::run Query: SELECT `id` AS `id`,`name` AS `name`,`level` AS `level`,GROUP_CONCAT(CONCAT(IF(component={{{energy}}}, "", ""), component, IF(component={{{energy}}}, "", ""), ' (', min_amount,'-', max_amount, ')')) AS `components` FROM `cargo__DeconstructionTable` GROUP BY id, name, level HAVING components like '%Blacksmith%' ORDER BY `level` LIMIT 600 |
|---|