Template:Missile Weapon Navbox: Difference between revisions
Jump to navigation
Jump to search
(make links into favilinks) |
(separated bows and rifles) |
||
Line 8: | Line 8: | ||
| innerstyle = font-family:Source Code Pro; | | innerstyle = font-family:Source Code Pro; | ||
| group1= [[Bow and Rifle|Bow]] | |||
| group1= [[Bow and Rifle]] | |||
| list1 = {{#cargo_query:tables=ItemsTable=IT, GeneralData=GD | | list1 = {{#cargo_query:tables=ItemsTable=IT, GeneralData=GD | ||
|join on = IT.JoinKey = GD.JoinKey | |join on = IT.JoinKey = GD.JoinKey | ||
|fields=CONCAT('{{((}}favilink{{!}}',CONCAT(IT._pageName),'{{))}}')=Page | |fields=CONCAT('{{((}}favilink{{!}}',CONCAT(IT._pageName),'{{))}}')=Page | ||
|where=IT.Skill = 'Bow and Rifle' AND GD._pageNamespace = '0' AND Weight <> '' | |where=IT.Skill = 'Bow and Rifle' AND GD._pageNamespace = '0' AND Weight <> '' AND GD.PlainName LIKE "%bow" | ||
|format=list | |||
|order by=GD.Tier | |||
|delimiter= - </span><span style="display:inline-block">|intro=<span style="display:inline-block">|outro=</span> | |||
}} | |||
| group2= [[Bow and Rifle|Rifle]] | |||
| list2 = {{#cargo_query:tables=ItemsTable=IT, GeneralData=GD | |||
|join on = IT.JoinKey = GD.JoinKey | |||
|fields=CONCAT('{{((}}favilink{{!}}',CONCAT(IT._pageName),'{{))}}')=Page | |||
|where=IT.Skill = 'Bow and Rifle' AND GD._pageNamespace = '0' AND Weight <> '' AND GD.PlainName NOT LIKE "%bow" | |||
|format=list | |format=list | ||
|order by=GD.Tier | |order by=GD.Tier | ||
Line 19: | Line 27: | ||
}} | }} | ||
| | | group3= [[Pistol]] | ||
| list3 = {{#cargo_query:tables=ItemsTable=IT, GeneralData=GD | |||
| | |||
|join on = IT.JoinKey = GD.JoinKey | |join on = IT.JoinKey = GD.JoinKey | ||
|fields=CONCAT('{{((}}favilink{{!}}',CONCAT(IT._pageName),'{{))}}')=Page | |fields=CONCAT('{{((}}favilink{{!}}',CONCAT(IT._pageName),'{{))}}')=Page | ||
Line 30: | Line 37: | ||
}} | }} | ||
| | | group4= [[Heavy Weapon]] | ||
| | | list4= {{#cargo_query:tables=ItemsTable=IT, GeneralData=GD | ||
|join on = IT.JoinKey = GD.JoinKey | |join on = IT.JoinKey = GD.JoinKey | ||
|fields=CONCAT('{{((}}favilink{{!}}',CONCAT(IT._pageName),'{{))}}')=Page | |fields=CONCAT('{{((}}favilink{{!}}',CONCAT(IT._pageName),'{{))}}')=Page |