Scrap: Difference between revisions

12 bytes added ,  16:23, 7 October 2021
m
Update to use new Cargo table
(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 = ItemsTable=IT, GeneralData=GD
{{#cargo_query:tables = ArtifactData=AD, GeneralData=GD
|join on=IT.ObjectID = GD.ObjectID
|join on=AD.JoinKey = GD.JoinKey
| fields = CONCAT("{{favilink id{{!}}", IT.ObjectID, "}}") = Scrap, CONCAT("{{Bits{{!}}", Bits, "}}")=Bits
| fields = CONCAT("{{favilink id{{!}}", AD.ObjectID, "}}") = Scrap, CONCAT("{{Bits{{!}}", AD.Bits, "}}")=Bits
| where=IT._pageNamespace='0' AND IT.Bits <> '' AND GD.ParentObject WITHIN 'Scrap' AND NOT GD.ObjectID LIKE 'Med%'
| 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 = ItemsTable=IT, GeneralData=GD
{{#cargo_query:tables = ArtifactData=AD, GeneralData=GD
|join on=IT.ObjectID = GD.ObjectID
|join on=AD.JoinKey = GD.JoinKey
| fields = CONCAT("{{favilink id{{!}}", IT.ObjectID, "}}") = Scrap, CONCAT("{{Bits{{!}}", Bits, "}}")=Bits
| fields = CONCAT("{{favilink id{{!}}", AD.ObjectID, "}}") = Scrap, CONCAT("{{Bits{{!}}", AD.Bits, "}}")=Bits
| where=IT._pageNamespace='0' AND IT.Bits <> '' AND GD.ParentObject WITHIN 'Scrap' AND GD.ObjectID LIKE 'Med%'
| where=AD._pageNamespace='0' AND AD.Bits <> '' AND GD.ParentObject WITHIN 'Scrap' AND GD.ObjectID LIKE 'Med%'
| order by=Bits}}
| order by=AD.Bits}}