Template:Items that can be built with: Difference between revisions
Jump to navigation
Jump to search
(Created page with "{{#vardefine:ITEMCOUNT|{{#cargo_query:table=ItemsTable |fields=COUNT(*)/2 |where=CanBuild='1' AND TinkerTier = '{{{1|Tinker I}}}' AND _pageNamespace ='0' |no html}} }} {| styl...") |
mNo edit summary |
||
(6 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 | |where=CanBuild='1' AND TinkerTier = '{{{1|Tinker II}}}' AND (_pageNamespace="0" OR UnidentifiedAltNameStripped = 'grenade') | ||
|no html}} }} | |no html}} }} | ||
{| style=inline-table;" | {{#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(' | |where=CanBuild='1' AND TinkerTier = '{{{1|Tinker II}}}' AND (AD._pageNamespace="0" OR AD.UnidentifiedAltNameStripped = 'grenade') | ||
|where=CanBuild='1' AND TinkerTier = '{{{1|Tinker | |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= | |join on=AD.JoinKey=GD.JoinKey | ||
|fields=CONCAT(' | |fields=CONCAT('{{((}}favilink id{{!}}',AD.ObjectID,'{{))}}')=Item,CONCAT("{{((}}Bits{{!}}", Bits, "{{))}}")=Bits | ||
|where=CanBuild='1' AND TinkerTier = '{{{1|Tinker | |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}} | ||
|limit={{#var:ITEMCOUNT}} | |limit={{#var:ITEMCOUNT}} | ||
|more results text=}} | |more results text=}}</div> | ||
}}<noinclude>[[Category:Query Templates]]</noinclude> |
Latest revision as of 19:59, 16 December 2021
Item | Bits |
---|---|
arc winder | <0245> |
bio-scanning bracelet | <0024> |
biodynamic cell | <035> |
blood-gradient hand vacuum | <0456> |
carbine | <0014> |
chain laser | <0005> |
chain pistol | <0014> |
chaingun | <004> |
combat shotgun | <0014> |
defoliant pump | <0024> |
di-thermo beam | <0246> |
displacer bracelet | <0046> |
eigenpistol | <0005> |
eigenrifle | <0005> |
electrobow | <0024> |
spring-turret grenade mk II | <024> |
spring-turret grenade mk III | <045> |
flamethrower | <0004> |
force bracelet | <0034> |
freeze ray | <12345> |
fungicide pump | <0024> |
gas tumbler | <00456> |
gaslight chisel | <0004> |
gaslight kris | <0004> |
gaslight flyssa | <0004> |
geomagnetic disc | <00126> |
grappling gun | <024> |
gravity grenade mk II | <024> |
gravity grenade mk III | <356> |
gyrocopter backpack | <0045> |
hand rail | <00006> |
high-powered magnet | <0056> |
hologram bracelet | <0034> |
hoversled | <0034> |
hypertractor | <23456> |
laser pistol | <0004> |
laser rifle | <0004> |
light rail | <0006> |
maghammer | <0345> |
magnetic bottle | <0246> |
Item | Bits |
---|---|
♂ scoped masterwork carbine | <0014> |
♂ chain pistol | <0014> |
missile launcher | <0004> |
Eaters' nectar injector | <06> |
ninefold boots | <012346> |
normality gas pump | <0005> |
nuclear cell | <006> |
nullray pistol | <0056> |
ontological anchor | <0246> |
plasma grenade mk II | <024> |
plasma grenade mk III | <356> |
point-defense drone | <0256> |
portable wall | <0034> |
prayer rod | <004> |
precinct navigator | <0B24> |
programmable recoiler | <12234> |
recycling suit | <0034> |
reprogrammable recoiler | <12346> |
rocket skates | <0025> |
random-point recoiler | <1234> |
slip ring | <0035> |
sniper rifle | <0014> |
sphynx salt injector | <05> |
spiral borer | <0034> |
Spray-a-Brain | <0056> |
step sowers | <012345> |
powered exoskeleton | <006> |
structural scanning bracelet | <0024> |
syphon baton | <00445> |
telemetric visor | <0005> |
thermo cask | <0046> |
thermoelectric cell | <024> |
time dilation grenade mk II | <024> |
time dilation grenade mk III | <046> |
turbow | <00245> |
ubernostrum injector | <05> |
vibro blade | <0015> |
vibro dagger | <0004> |
VISAGE | <001246> |
wrist calc | <0124> |