Scrap: Difference between revisions
(Removed redirect to Category:Scrap) |
mNo edit summary |
||
Line 7: | Line 7: | ||
|join on=IT._pageName = PD._pageName | |join on=IT._pageName = PD._pageName | ||
|fields=CONCAT("{{favilink id{{!}}", IT.ObjectID, "}}") = Scrap, CONCAT("{{Bits{{!}}", Bits, "}}")=Bits | |fields=CONCAT("{{favilink id{{!}}", IT.ObjectID, "}}") = Scrap, CONCAT("{{Bits{{!}}", Bits, "}}")=Bits | ||
|where=IT._pageNamespace='0' AND IT.Bits <> '' AND PD._categories HOLDS 'Scrap'|order by= | |where=IT._pageNamespace='0' AND IT.Bits <> '' AND PD._categories HOLDS 'Scrap'|order by=Bits}} | ||
For the category, see [[:Category:Scrap]]. | For the category, see [[:Category:Scrap]]. |
Revision as of 16:11, 5 August 2021
This article is a stub. You can help Caves of Qud Wiki by expanding it. |
This information is reliable as of patch 2.0.202.22. If this is no longer the current patch, you can help by updating it. |
Scrap are items that generally have one or two guaranteed type of bits. There is regular scrap, and medical scrap. Medical scrap is much rarer.
Scrap can be obtained as random loot, by using Scavenger to rifle through piles of trash, or by having said skill and killing robots. Legendary Barathrumites and tinkers will also sell scrap.
Function: CargoSQLQuery::run Query: SELECT CONCAT("{{favilink id|", `IT`.`ObjectID`, "}}") AS `Scrap`,CONCAT("{{Bits|", Bits, "}}") AS `Bits` FROM `ItemsTable` `IT` LEFT OUTER JOIN `_pageData` `PD` ON ((`IT`.`_pageName`=`PD`.`_pageName`)) WHERE `IT`.`_pageNamespace`='0' AND `IT`.`Bits` <> AND `PD`.`_ID` IN (SELECT `_rowID` FROM `_pageData___categories` WHERE `_value`= 'Scrap') ORDER BY `Bits` LIMIT 100
For the category, see Category:Scrap.