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

From Caves of Qud Wiki
Jump to navigation Jump to search
(favilink items and better alignment)
mNo edit summary
 
(4 intermediate revisions by 2 users 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' AND _pageName <> ''
|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
|style="vertical-align:top;"|{{#cargo_query:table=ItemsTable=IT, GeneralData=GD
|join on=AD.JoinKey=GD.JoinKey
|join on=IT.JoinKey=GD.JoinKey
|fields=CONCAT('{{((}}favilink id{{!}}', AD.ObjectID,'{{))}}')=Item, CONCAT("{{((}}Bits{{!}}", Bits, "{{))}}")=Bits
|fields=CONCAT('{{((}}favilink{{!}}',IT._pageName,'{{))}}')=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 IT._pageNamespace ='0' AND IT._pageName <> ''
|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;">
|style="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' AND IT._pageName <> ''
|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>
}}<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>
Retrieved from "https://wiki.cavesofqud.com/index.php?title=Template:Items_that_can_be_built_with&oldid=65283"