Template:Machinery Navbox: Difference between revisions

no edit summary
(Created page with "<includeonly>{{Navbox | name = Machinery Navbox | title = List of Machinery | below = <div style="text-align:right;font-size:100%; font...")
 
No edit summary
Line 9: Line 9:
| innerstyle = font-family:Source Code Pro;
| innerstyle = font-family:Source Code Pro;


| group1 = Manual Machinery
| group1 = Power Generation<br>and Conversion
| list1 = {{#cargo_query:
| list1 = {{#cargo_query:
   | tables    = GeneralData=GD, ItemsTable=IT, Characters=C, ArtifactData=AD
   | tables    = GeneralData=GD, ItemsTable=IT, Characters=C, ArtifactData=AD
   | join on  = GD.ObjectID=IT.ObjectID, GD.ObjectID=C.ObjectID, GD.JoinKey=AD.JoinKey
   | join on  = GD.ObjectID=IT.ObjectID, GD.ObjectID=C.ObjectID, GD.JoinKey=AD.JoinKey
   | fields    = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page
   | fields    = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page
   | where    = GD.Categories = 'Machinery' AND GD._pageNamespace='0' AND COALESCE(AD.ChargeUsed,0)=0
   | where    = GD.Categories='Machinery' AND GD._pageNamespace='0' AND (AD.ChargeProduceBroadcast IS NOT NULL OR AD.ChargeProduceElectric IS NOT NULL OR AD.ChargeProduceHydraulic IS NOT NULL OR AD.ChargeProduceMechanical IS NOT NULL)
   | format    = list
   | format    = list
   | order by  = GD.PlainName
   | order by  = GD.PlainName
Line 24: Line 24:
| list1style = border-bottom:1px solid rgba(77,110,122,0.3);padding-bottom: 5px;
| list1style = border-bottom:1px solid rgba(77,110,122,0.3);padding-bottom: 5px;


| group2 = Powered Machinery
| group2 = Power Transmission
| list2 = {{#cargo_query:
| list2 = {{#cargo_query:
   | tables    = GeneralData=GD, ItemsTable=IT, Characters=C, ArtifactData=AD
   | tables    = GeneralData=GD, ItemsTable=IT, Characters=C
   | join on  = GD.ObjectID=IT.ObjectID, GD.ObjectID=C.ObjectID, GD.JoinKey=AD.JoinKey
   | join on  = GD.ObjectID=IT.ObjectID, GD.ObjectID=C.ObjectID
   | fields    = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page
   | fields    = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page
   | where    = GD.Categories = 'Machinery' AND GD._pageNamespace='0' AND COALESCE(AD.ChargeUsed,0) > 0
   | where    = (GD.Categories='Conduits' OR GD.Categories='Gearboxes' OR GD.ObjectID='ConveyorDrive') AND GD._pageNamespace='0'
   | format    = list
   | format    = list
   | order by  = GD.PlainName
   | order by  = GD.PlainName
Line 39: Line 39:
| list2style = border-bottom:1px solid rgba(77,110,122,0.3);padding-bottom: 5px;
| list2style = border-bottom:1px solid rgba(77,110,122,0.3);padding-bottom: 5px;


| group3 = Power Generation<br>and Conversion
| group3 = Power Switches
| list3 = {{#cargo_query:
| list3 = {{#cargo_query:
   | tables    = GeneralData=GD, ItemsTable=IT, Characters=C, ArtifactData=AD
   | tables    = GeneralData=GD, ItemsTable=IT, Characters=C
   | join on  = GD.ObjectID=IT.ObjectID, GD.ObjectID=C.ObjectID, GD.JoinKey=AD.JoinKey
   | join on  = GD.ObjectID=IT.ObjectID, GD.ObjectID=C.ObjectID
   | fields    = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page
   | fields    = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{!}}{{(}}lc:',GD._pageName,'{{)}}{{)}}')=Page
   | where    = GD.Categories='Machinery' AND GD._pageNamespace='0' AND (AD.ChargeProduceBroadcast IS NOT NULL OR AD.ChargeProduceElectric IS NOT NULL OR AD.ChargeProduceHydraulic IS NOT NULL)
   | where    = GD.Categories='Machinery' AND GD.ParentObject='Switch' AND GD._pageNamespace='0'
   | format    = list
   | format    = list
   | order by  = GD.PlainName
   | order by  = GD.PlainName
Line 54: Line 54:
| list3style = border-bottom:1px solid rgba(77,110,122,0.3);padding-bottom: 5px;
| list3style = border-bottom:1px solid rgba(77,110,122,0.3);padding-bottom: 5px;


| group5 = Power Transmission
| group4 = Machinery
| list5 = {{#cargo_query:
| list4 = {{#cargo_query:
   | tables    = GeneralData=GD, ItemsTable=IT, Characters=C
   | tables    = GeneralData=GD, ItemsTable=IT, Characters=C, ArtifactData=AD
   | join on  = GD.ObjectID=IT.ObjectID, GD.ObjectID=C.ObjectID
   | join on  = GD.ObjectID=IT.ObjectID, GD.ObjectID=C.ObjectID, GD.JoinKey=AD.JoinKey
   | fields    = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page
   | fields    = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page
   | where    = (GD.Categories='Conduits' OR GD.Categories='Gearboxes') AND GD._pageNamespace='0'
   | where    = GD._pageNamespace='0' AND GD.Categories='Machinery' AND (GD.ParentObject<>'Switch' AND GD.ObjectID<>'ConveyorDrive' AND AD.ChargeProduceBroadcast IS NULL AND AD.ChargeProduceElectric IS NULL AND AD.ChargeProduceHydraulic IS NULL AND AD.ChargeProduceMechanical IS NULL)
   | format    = list
   | format    = list
   | order by  = GD.PlainName
   | order by  = GD.PlainName
Line 66: Line 66:
   | limit    = 999
   | limit    = 999
   }}
   }}
| group5style = border-bottom:1px solid rgba(77,110,122,0.3);padding-bottom: 5px;
| group4style = border-bottom:1px solid rgba(77,110,122,0.3);padding-bottom: 5px;
| list5style = border-bottom:1px solid rgba(77,110,122,0.3);padding-bottom: 5px;
| list4style = border-bottom:1px solid rgba(77,110,122,0.3);padding-bottom: 5px;


}}</includeonly><noinclude>Navbox for objects in the [[:Category:Machinery|Machinery]] category.
}}</includeonly><noinclude>Navbox for objects in the [[:Category:Machinery|Machinery]] category.