Scrap: Difference between revisions
mNo edit summary |
(fix query) |
||
Line 3: | Line 3: | ||
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. | 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. | ||
== Scrap == | |||
{{#cargo_query:tables = ItemsTable=IT, GeneralData=GD | |||
|join on=IT.ObjectID = GD.ObjectID | |||
| fields = CONCAT("{{favilink id{{!}}", IT.ObjectID, "}}") = Scrap, CONCAT("{{Bits{{!}}", Bits, "}}")=Bits | |||
| where=IT._pageNamespace='0' AND IT.Bits <> '' AND GD.ParentObject WITHIN 'Scrap' AND NOT GD.ObjectID LIKE 'Med%' | |||
| order by=Bits}} | |||
{{#cargo_query:tables=ItemsTable=IT, | == Medical Scrap == | ||
|join on=IT. | {{#cargo_query:tables = ItemsTable=IT, GeneralData=GD | ||
|fields=CONCAT("{{favilink id{{!}}", IT.ObjectID, "}}") = Scrap, CONCAT("{{Bits{{!}}", Bits, "}}")=Bits | |join on=IT.ObjectID = GD.ObjectID | ||
|where=IT._pageNamespace='0' AND IT.Bits <> '' AND | | fields = CONCAT("{{favilink id{{!}}", IT.ObjectID, "}}") = Scrap, CONCAT("{{Bits{{!}}", Bits, "}}")=Bits | ||
| where=IT._pageNamespace='0' AND IT.Bits <> '' AND GD.ParentObject WITHIN 'Scrap' AND GD.ObjectID LIKE 'Med%' | |||
| order by=Bits}} |
Revision as of 16:22, 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.
Scrap
Function: CargoSQLQuery::run Query: SELECT CONCAT("{{favilink id|", `IT`.`ObjectID`, "}}") AS `Scrap`,CONCAT("{{Bits|", Bits, "}}") AS `Bits` FROM `ItemsTable` `IT` LEFT OUTER JOIN `GeneralData` `GD` ON ((`IT`.`ObjectID`=`GD`.`ObjectID`)) WHERE `IT`.`_pageNamespace`='0' AND `IT`.`Bits` <> AND ParentObject IN ( SELECT `_value` FROM `GeneralData__ParentObject__hierarchy` WHERE `_left` >= ( SELECT `_left` FROM `GeneralData__ParentObject__hierarchy` WHERE `_value` = 'Scrap' ) AND `_right` <= ( SELECT `_right` FROM `GeneralData__ParentObject__hierarchy` WHERE `_value` = 'Scrap' ) ) AND NOT `GD`.`ObjectID` LIKE 'Med%' ORDER BY `Bits` LIMIT 100
Medical Scrap
Function: CargoSQLQuery::run Query: SELECT CONCAT("{{favilink id|", `IT`.`ObjectID`, "}}") AS `Scrap`,CONCAT("{{Bits|", Bits, "}}") AS `Bits` FROM `ItemsTable` `IT` LEFT OUTER JOIN `GeneralData` `GD` ON ((`IT`.`ObjectID`=`GD`.`ObjectID`)) WHERE `IT`.`_pageNamespace`='0' AND `IT`.`Bits` <> AND ParentObject IN ( SELECT `_value` FROM `GeneralData__ParentObject__hierarchy` WHERE `_left` >= ( SELECT `_left` FROM `GeneralData__ParentObject__hierarchy` WHERE `_value` = 'Scrap' ) AND `_right` <= ( SELECT `_right` FROM `GeneralData__ParentObject__hierarchy` WHERE `_value` = 'Scrap' ) ) AND `GD`.`ObjectID` LIKE 'Med%' ORDER BY `Bits` LIMIT 100