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

Jump to navigation Jump to search
m
no edit summary
m (re-include grenades in tinker item tables)
mNo edit summary
 
Line 5: Line 5:
{{#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 id{{!}}', AD.ObjectID,'{{))}}')=Item, CONCAT("{{((}}Bits{{!}}", Bits, "{{))}}")=Bits
|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 (AD._pageNamespace="0" OR AD.UnidentifiedAltNameStripped = 'grenade')
|format=table}} |
|format=table}} |
Line 11: Line 11:
{{#cargo_query:table=ArtifactData=AD, GeneralData=GD
{{#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 id{{!}}',AD.ObjectID,'{{))}}')=Item,CONCAT("{{((}}Bits{{!}}", Bits, "{{))}}")=Bits
|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 (AD._pageNamespace="0" OR AD.UnidentifiedAltNameStripped = 'grenade')
|format=table
|format=table
Line 18: Line 18:
{{#cargo_query:table=ArtifactData=AD, GeneralData=GD
{{#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 id{{!}}',AD.ObjectID,'{{))}}')=Item,CONCAT("{{((}}Bits{{!}}", Bits, "{{))}}")=Bits
|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 (AD._pageNamespace="0" OR AD.UnidentifiedAltNameStripped = 'grenade')
|format=table
|format=table

Navigation menu