Tinker III: Difference between revisions

From Caves of Qud Wiki
Jump to navigation Jump to search
m (add missing info template)
(update query)
Line 1: Line 1:
{{Missing info|The query used to generate the list of items that can be built with this skill is incorrect, because it includes {{Favilink|nullray pistol}}, which it is sufficient to have [[Tinker II]] in order to build. We should research the actual requirements and not only update the table to reflect them but also explicate them plainly here.}}
{{Skill
{{Skill
| class=Tinkering
| class=Tinkering
Line 9: Line 8:
}}
}}
==Items that can be built using Tinker III==
==Items that can be built using Tinker III==
{{#cargo_query:table=ItemsTable,GeneralData|join on=ItemsTable._pageName=GeneralData._pageName|fields=CONCAT('[[File:',Image,'|16px]]')=Image,ItemsTable._pageName=Item,CONCAT("{{((}}Bits{{!}}", Bits, "{{))}}")=Bits|where=CanBuild='1' AND GeneralData.Tier > '6' AND ItemsTable._pageNamespace ='0'|order by=ItemsTable._pageName|format=table}}
{{#cargo_query:table=ItemsTable,GeneralData|join on=ItemsTable._pageName=GeneralData._pageName|fields=CONCAT('[[File:',Image,'|16px]]')=Image,ItemsTable._pageName=Item,CONCAT("{{((}}Bits{{!}}", Bits, "{{))}}")=Bits|where=CanBuild='1' AND TinkerTier = 'Tinker III' AND ItemsTable._pageNamespace ='0'|order by=ItemsTable._pageName|format=table}}
{{Skills and Powers Navbox}}
{{Skills and Powers Navbox}}

Revision as of 23:12, 22 January 2020

Tinker III
Skill Tree

Tinkering

Prerequisite Skills

Tinker II

Cost

300 sp

Requirements

29 Intelligence

ID

Tinkering_Tinker3

You may build items from high-tier schematics and you get 1 free schematic.

Items that can be built using Tinker III

Error 1054: Unknown column 'Bits' in 'field list' (localhost)

Function: CargoSQLQuery::run Query: SELECT CONCAT('File:',Image,'') AS `Image`,`ItemsTable`.`_pageName` AS `Item`,CONCAT("{{Bits|", Bits, "}}") AS `Bits` FROM `ItemsTable` LEFT OUTER JOIN `GeneralData` ON ((`ItemsTable`.`_pageName`=`GeneralData`.`_pageName`)) WHERE CanBuild='1' AND TinkerTier = 'Tinker III' AND `ItemsTable`.`_pageNamespace` ='0' ORDER BY `ItemsTable`.`_pageName` LIMIT 100