Scrap: Difference between revisions

From Caves of Qud Wiki
Jump to navigation Jump to search
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, _pageData=PD
== Medical Scrap ==
|join on=IT._pageName = PD._pageName
{{#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 PD._categories HOLDS 'Scrap'|order by=Bits}}
| fields = CONCAT("{{favilink id{{!}}", IT.ObjectID, "}}") = Scrap, CONCAT("{{Bits{{!}}", Bits, "}}")=Bits
For the category, see [[:Category:Scrap]].
| 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

AmboxStub.png This article is a stub. You can help Caves of Qud Wiki by expanding it.
This article is a stub. You can help Caves of Qud Wiki by expanding it.
This article is a stub. You can help Caves of Qud Wiki by expanding it.

As of Patch 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.
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.
As of Patch This information is reliable as of patch 2.0.202.22.

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

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

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

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

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

Retrieved from "https://wiki.cavesofqud.com/index.php?title=Scrap&oldid=50979"