Template:Items that can be built with: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
(favilink items and better alignment) |
||
| Line 1: | Line 1: | ||
{{#vardefine:ITEMCOUNT|{{#cargo_query:table=ItemsTable | {{#vardefine:ITEMCOUNT|{{#cargo_query:table=ItemsTable | ||
|fields=COUNT(*)/2 | |fields=COUNT(*)/2 | ||
|where=CanBuild='1' AND TinkerTier = '{{{1|Tinker | |where=CanBuild='1' AND TinkerTier = '{{{1|Tinker II}}}' AND _pageNamespace ='0' AND _pageName <> '' | ||
|no html}} }} | |no html}} }} | ||
{| style="vertical-align:top;" | {| | ||
|{{#cargo_query:table=ItemsTable=IT, GeneralData=GD | |style="vertical-align:top;"|{{#cargo_query:table=ItemsTable=IT, GeneralData=GD | ||
|join on=IT.JoinKey=GD.JoinKey | |join on=IT.JoinKey=GD.JoinKey | ||
|fields=CONCAT(' | |fields=CONCAT('{{((}}favilink{{!}}',IT._pageName,'{{))}}')=Item,CONCAT("{{((}}Bits{{!}}", Bits, "{{))}}")=Bits | ||
|where=CanBuild='1' AND TinkerTier = '{{{1|Tinker | |where=CanBuild='1' AND TinkerTier = '{{{1|Tinker II}}}' AND IT._pageNamespace ='0' AND IT._pageName <> '' | ||
|format=table | |format=table | ||
|limit={{#var:ITEMCOUNT}} | |limit={{#var:ITEMCOUNT}} | ||
|more results text=}} | |more results text=}} | ||
|{{#cargo_query:table=ItemsTable=IT, GeneralData=GD | |style="vertical-align:top;"|{{#cargo_query:table=ItemsTable=IT, GeneralData=GD | ||
|join on=IT.JoinKey=GD.JoinKey | |join on=IT.JoinKey=GD.JoinKey | ||
|fields=CONCAT(' | |fields=CONCAT('{{((}}favilink{{!}}',IT._pageName,'{{))}}')=Item,CONCAT("{{((}}Bits{{!}}", Bits, "{{))}}")=Bits | ||
|where=CanBuild='1' AND TinkerTier = '{{{1|Tinker | |where=CanBuild='1' AND TinkerTier = '{{{1|Tinker II}}}' AND IT._pageNamespace ='0' AND IT._pageName <> '' | ||
|format=table | |format=table | ||
|offset={{#var:ITEMCOUNT}} | |offset={{#var:ITEMCOUNT}} | ||
Revision as of 00:58, 16 August 2020
Error: the string "SELECT" cannot be used within #cargo_query.
|
Error: the string "SELECT" cannot be used within #cargo_query.
|