Template:Scrap Navbox: Difference between revisions

m
Update to use new Cargo table
m (Teamtoto moved page Template:Scrap navbox to Template:Scrap Navbox without leaving a redirect)
m (Update to use new Cargo table)
 
(2 intermediate revisions by one other user not shown)
Line 1: Line 1:
{{Navbox
{{Navbox
| name      = Scrap navbox
| name      = Scrap Navbox
| title      = List of Scrap
| title      = List of [[:Category:Scrap|Scrap]]
| listclass  = hlist
| listclass  = hlist
| state      = {{{state|autocollapse}}}
| state      = {{{state|autocollapse}}}
| group1    = Scrap
| group1    = Scrap
| list1      = {{#cargo_query:tables=ItemsTable=IT,GeneralData=GD
| list1      = {{#cargo_query:tables=ArtifactData=AD,GeneralData=GD
| join on=IT.JoinKey=GD.JoinKey
| join on=AD.JoinKey=GD.JoinKey
| where=GD.ParentObject WITHIN 'Scrap' AND GD.ObjectID NOT LIKE "Med%"
| where=GD.ParentObject WITHIN 'Scrap' AND GD.ObjectID NOT LIKE "Med%"
| fields= GD._pageName, CONCAT('{{((}}bits{{!}}',IT.Bits, '{{))}}')=
| fields=CONCAT('{{((}}favilink page{{!}}',GD._pageName,'{{))}}'), CONCAT('{{((}}bits{{!}}',AD.Bits, '{{))}}')=
| order by=IT.Bits
| order by=AD.Bits
| format=list
| format=list
| delimiter =  - 
}}
}}


| group2    = Medical Scrap
| group2    = Medical Scrap
| list2      = {{#cargo_query:tables=ItemsTable=IT,GeneralData=GD
| list2      = {{#cargo_query:tables=ArtifactData=AD,GeneralData=GD
| join on=IT.JoinKey=GD.JoinKey
| join on=AD.JoinKey=GD.JoinKey
| where=GD.ParentObject WITHIN 'Scrap' AND GD.ObjectID LIKE "Med%"
| where=GD.ParentObject WITHIN 'Scrap' AND GD.ObjectID LIKE "Med%"
| fields=GD._pageName, CONCAT('{{((}}bits{{!}}',IT.Bits, '{{))}}')=
| fields=CONCAT('{{((}}favilink page{{!}}',GD._pageName,'{{))}}'), CONCAT('{{((}}bits{{!}}',AD.Bits, '{{))}}')=
| order by=IT.Bits
| order by=AD.Bits
| format=list
| format=list
| delimiter =  - 
}}
}}
}}<noinclude>[[Category:Navigation]]</noinclude>
}}<noinclude>[[Category:Navigation]]</noinclude>