Scrap: Difference between revisions

Scrap (view source)

356 bytes added , 16:22, 5 August 2021

fix query

8,756

edits

@@ 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 ==
+{{#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}}