8,290
edits
(fix query) |
m (Update to use new Cargo table) |
||
Line 4: | Line 4: | ||
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 == | == Scrap == | ||
{{#cargo_query:tables = | {{#cargo_query:tables = ArtifactData=AD, GeneralData=GD | ||
|join on= | |join on=AD.JoinKey = GD.JoinKey | ||
| fields = CONCAT("{{favilink id{{!}}", | | fields = CONCAT("{{favilink id{{!}}", AD.ObjectID, "}}") = Scrap, CONCAT("{{Bits{{!}}", AD.Bits, "}}")=Bits | ||
| where= | | where=AD._pageNamespace='0' AND AD.Bits <> '' AND GD.ParentObject WITHIN 'Scrap' AND NOT GD.ObjectID LIKE 'Med%' | ||
| order by=Bits}} | | order by=AD.Bits}} | ||
== Medical Scrap == | == Medical Scrap == | ||
{{#cargo_query:tables = | {{#cargo_query:tables = ArtifactData=AD, GeneralData=GD | ||
|join on= | |join on=AD.JoinKey = GD.JoinKey | ||
| fields = CONCAT("{{favilink id{{!}}", | | fields = CONCAT("{{favilink id{{!}}", AD.ObjectID, "}}") = Scrap, CONCAT("{{Bits{{!}}", AD.Bits, "}}")=Bits | ||
| where= | | where=AD._pageNamespace='0' AND AD.Bits <> '' AND GD.ParentObject WITHIN 'Scrap' AND GD.ObjectID LIKE 'Med%' | ||
| order by=Bits}} | | order by=AD.Bits}} |