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

m
no edit summary
(same over here)
mNo edit summary
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{#vardefine:ITEMCOUNT|{{#cargo_query:table=ItemsTable
{{#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=ItemsTable=IT, GeneralData=GD
{{#ifexpr:{{#var:ITEMCOUNT}} < 10 | {{#cargo_query:table=ArtifactData=AD, GeneralData=GD
|join on=IT.JoinKey=GD.JoinKey
|join on=AD.JoinKey=GD.JoinKey
|fields=CONCAT('{{((}}favilink{{!}}', IT._pageName,'{{))}}')=Item, CONCAT("{{((}}Bits{{!}}", Bits, "{{))}}")=Bits
|fields=CONCAT('{{((}}favilink id{{!}}', AD.ObjectID,'{{))}}')=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 (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;">
{{#cargo_query:table=ItemsTable=IT, GeneralData=GD
{{#cargo_query:table=ArtifactData=AD, GeneralData=GD
|join on=IT.JoinKey=GD.JoinKey
|join on=AD.JoinKey=GD.JoinKey
|fields=CONCAT('{{((}}favilink{{!}}',IT._pageName,'{{))}}')=Item,CONCAT("{{((}}Bits{{!}}", Bits, "{{))}}")=Bits
|fields=CONCAT('{{((}}favilink id{{!}}',AD.ObjectID,'{{))}}')=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 (AD._pageNamespace="0" OR AD.UnidentifiedAltNameStripped = 'grenade')
|format=table
|format=table
|limit={{#var:ITEMCOUNT}}
|limit={{#var:ITEMCOUNT}}
|more results text=}}</div><div style="display:inline-table; vertical-align:top;">
|more results text=}}</div><div style="display:inline-table; vertical-align:top;">
{{#cargo_query:table=ItemsTable=IT, GeneralData=GD
{{#cargo_query:table=ArtifactData=AD, GeneralData=GD
|join on=IT.JoinKey=GD.JoinKey
|join on=AD.JoinKey=GD.JoinKey
|fields=CONCAT('{{((}}favilink{{!}}',IT._pageName,'{{))}}')=Item,CONCAT("{{((}}Bits{{!}}", Bits, "{{))}}")=Bits
|fields=CONCAT('{{((}}favilink id{{!}}',AD.ObjectID,'{{))}}')=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 (AD._pageNamespace="0" OR AD.UnidentifiedAltNameStripped = 'grenade')
|format=table
|format=table
|offset={{#var:ITEMCOUNT}}
|offset={{#var:ITEMCOUNT}}