8,290
edits
Template:Items that can be built with: Difference between revisions
Jump to navigation
Jump to search
m
Template:Items that can be built with (view source)
Revision as of 19:59, 16 December 2021
, 19:59, 16 December 2021no edit summary
mNo edit summary |
mNo edit summary |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
{{#vardefine:ITEMCOUNT|{{#cargo_query:table= | {{#vardefine:ITEMCOUNT|{{#cargo_query:table=ArtifactData=AD | ||
|fields=COUNT(*)/2 | |fields=COUNT(*)/2 | ||
|where=CanBuild='1' AND TinkerTier = '{{{1|Tinker II}}}' AND _pageNamespace = | |where=CanBuild='1' AND TinkerTier = '{{{1|Tinker II}}}' AND (_pageNamespace="0" OR UnidentifiedAltNameStripped = 'grenade') | ||
|no html}} }} | |no html}} }} | ||
{| style="display:inline-table; vertical-align:top;" | {{#ifexpr:{{#var:ITEMCOUNT}} < 10 | {{#cargo_query:table=ArtifactData=AD, GeneralData=GD | ||
|join on=AD.JoinKey=GD.JoinKey | |||
|join on= | |fields=CONCAT('{{((}}favilink id{{!}}', AD.ObjectID,'{{))}}')=Item, CONCAT("{{((}}Bits{{!}}", Bits, "{{))}}")=Bits | ||
|fields=CONCAT('{{((}}favilink{{!}}', | |where=CanBuild='1' AND TinkerTier = '{{{1|Tinker II}}}' AND (AD._pageNamespace="0" OR AD.UnidentifiedAltNameStripped = 'grenade') | ||
|where=CanBuild='1' AND TinkerTier = '{{{1|Tinker II}}}' AND | |format=table}} | | ||
<div style="display:inline-table; vertical-align:top;"> | |||
{{#cargo_query:table=ArtifactData=AD, GeneralData=GD | |||
|join on=AD.JoinKey=GD.JoinKey | |||
|fields=CONCAT('{{((}}favilink id{{!}}',AD.ObjectID,'{{))}}')=Item,CONCAT("{{((}}Bits{{!}}", Bits, "{{))}}")=Bits | |||
|where=CanBuild='1' AND TinkerTier = '{{{1|Tinker II}}}' AND (AD._pageNamespace="0" OR AD.UnidentifiedAltNameStripped = 'grenade') | |||
|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=ArtifactData=AD, GeneralData=GD | |||
|join on=AD.JoinKey=GD.JoinKey | |||
|fields=CONCAT('{{((}}favilink id{{!}}',AD.ObjectID,'{{))}}')=Item,CONCAT("{{((}}Bits{{!}}", Bits, "{{))}}")=Bits | |||
|join on= | |where=CanBuild='1' AND TinkerTier = '{{{1|Tinker II}}}' AND (AD._pageNamespace="0" OR AD.UnidentifiedAltNameStripped = 'grenade') | ||
|fields=CONCAT('{{((}}favilink{{!}}', | |||
|where=CanBuild='1' AND TinkerTier = '{{{1|Tinker II}}}' AND | |||
|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> | |||