Template:Items that can be built with: Difference between revisions

Jump to navigation Jump to search
m
re-include grenades in tinker item tables
m (Update to use new Cargo table)
m (re-include grenades in tinker item tables)
Line 1: Line 1:
{{#vardefine:ITEMCOUNT|{{#cargo_query:table=ArtifactData=AD
{{#vardefine:ITEMCOUNT|{{#cargo_query:table=ArtifactData=AD
|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" OR UnidentifiedAltNameStripped = 'grenade')
|no html}} }}
|no html}} }}
{{#ifexpr:{{#var:ITEMCOUNT}} < 10 | {{#cargo_query:table=ArtifactData=AD, GeneralData=GD
{{#ifexpr:{{#var:ITEMCOUNT}} < 10 | {{#cargo_query:table=ArtifactData=AD, GeneralData=GD
|join on=AD.JoinKey=GD.JoinKey
|join on=AD.JoinKey=GD.JoinKey
|fields=CONCAT('{{((}}favilink{{!}}', AD._pageName,'{{))}}')=Item, CONCAT("{{((}}Bits{{!}}", Bits, "{{))}}")=Bits
|fields=CONCAT('{{((}}favilink{{!}}', AD._pageName,'{{))}}')=Item, CONCAT("{{((}}Bits{{!}}", Bits, "{{))}}")=Bits
|where=CanBuild='1' AND TinkerTier = '{{{1|Tinker II}}}' AND AD._pageNamespace ='0'
|where=CanBuild='1' AND TinkerTier = '{{{1|Tinker II}}}' AND (AD._pageNamespace="0" OR AD.UnidentifiedAltNameStripped = 'grenade')
|format=table}} |
|format=table}} |
<div style="display:inline-table; vertical-align:top;">
<div style="display:inline-table; vertical-align:top;">
Line 12: Line 12:
|join on=AD.JoinKey=GD.JoinKey
|join on=AD.JoinKey=GD.JoinKey
|fields=CONCAT('{{((}}favilink{{!}}',AD._pageName,'{{))}}')=Item,CONCAT("{{((}}Bits{{!}}", Bits, "{{))}}")=Bits
|fields=CONCAT('{{((}}favilink{{!}}',AD._pageName,'{{))}}')=Item,CONCAT("{{((}}Bits{{!}}", Bits, "{{))}}")=Bits
|where=CanBuild='1' AND TinkerTier = '{{{1|Tinker II}}}' AND AD._pageNamespace ='0'
|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}}
Line 19: Line 19:
|join on=AD.JoinKey=GD.JoinKey
|join on=AD.JoinKey=GD.JoinKey
|fields=CONCAT('{{((}}favilink{{!}}',AD._pageName,'{{))}}')=Item,CONCAT("{{((}}Bits{{!}}", Bits, "{{))}}")=Bits
|fields=CONCAT('{{((}}favilink{{!}}',AD._pageName,'{{))}}')=Item,CONCAT("{{((}}Bits{{!}}", Bits, "{{))}}")=Bits
|where=CanBuild='1' AND TinkerTier = '{{{1|Tinker II}}}' AND AD._pageNamespace ='0'
|where=CanBuild='1' AND TinkerTier = '{{{1|Tinker II}}}' AND (AD._pageNamespace="0" OR AD.UnidentifiedAltNameStripped = 'grenade')
|format=table
|format=table
|offset={{#var:ITEMCOUNT}}
|offset={{#var:ITEMCOUNT}}

Navigation menu