Template:Items that can be built with: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
(same over here) |
||
| 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 II}}}' AND _pageNamespace ='0 | |where=CanBuild='1' AND TinkerTier = '{{{1|Tinker II}}}' AND _pageNamespace ='0' | ||
|no html}} }} | |no html}} }} | ||
{| style="display:inline-table; vertical-align:top;" | {{#ifexpr:{{#var:ITEMCOUNT}} < 10 | {{#cargo_query:table=ItemsTable=IT, GeneralData=GD | ||
|join on=IT.JoinKey=GD.JoinKey | |||
|fields=CONCAT('{{((}}favilink{{!}}', IT._pageName,'{{))}}')=Item, CONCAT("{{((}}Bits{{!}}", Bits, "{{))}}")=Bits | |||
|where=CanBuild='1' AND TinkerTier = '{{{1|Tinker II}}}' AND IT._pageNamespace ='0' | |||
|format=table}} | | |||
<div style="display:inline-table; vertical-align:top;"> | |||
{{#cargo_query:table=ItemsTable=IT, GeneralData=GD | |||
|join on=IT.JoinKey=GD.JoinKey | |join on=IT.JoinKey=GD.JoinKey | ||
|fields=CONCAT('{{((}}favilink{{!}}',IT._pageName,'{{))}}')=Item,CONCAT("{{((}}Bits{{!}}", Bits, "{{))}}")=Bits | |fields=CONCAT('{{((}}favilink{{!}}',IT._pageName,'{{))}}')=Item,CONCAT("{{((}}Bits{{!}}", Bits, "{{))}}")=Bits | ||
|where=CanBuild='1' AND TinkerTier = '{{{1|Tinker II}}}' AND IT._pageNamespace ='0 | |where=CanBuild='1' AND TinkerTier = '{{{1|Tinker II}}}' AND IT._pageNamespace ='0' | ||
|format=table | |format=table | ||
|limit={{#var:ITEMCOUNT}} | |limit={{#var:ITEMCOUNT}} | ||
|more results text=}} | |more results text=}}</div><div style="display:inline-table; vertical-align:top;"> | ||
{{#cargo_query:table=ItemsTable=IT, GeneralData=GD | |||
|join on=IT.JoinKey=GD.JoinKey | |join on=IT.JoinKey=GD.JoinKey | ||
|fields=CONCAT('{{((}}favilink{{!}}',IT._pageName,'{{))}}')=Item,CONCAT("{{((}}Bits{{!}}", Bits, "{{))}}")=Bits | |fields=CONCAT('{{((}}favilink{{!}}',IT._pageName,'{{))}}')=Item,CONCAT("{{((}}Bits{{!}}", Bits, "{{))}}")=Bits | ||
|where=CanBuild='1' AND TinkerTier = '{{{1|Tinker II}}}' AND IT._pageNamespace ='0 | |where=CanBuild='1' AND TinkerTier = '{{{1|Tinker II}}}' AND IT._pageNamespace ='0' | ||
|format=table | |format=table | ||
|offset={{#var:ITEMCOUNT}} | |offset={{#var:ITEMCOUNT}} | ||
|limit={{#var:ITEMCOUNT}} | |limit={{#var:ITEMCOUNT}} | ||
|more results text=}} | |more results text=}}</div> | ||
}}<noinclude>[[Category:Query Templates]]</noinclude> | |||
Revision as of 01:19, 16 August 2020
Expression error: Unexpected < operator.