Template:Missile Weapon Navbox: Difference between revisions

make links into favilinks
(Created page with "{{Navbox | name = Missile Weapon Navbox | title = List of Missile Weapons | listclass = hlist | state = {{{state|collapsed}}} | titlestyle = background:rg...")
 
(make links into favilinks)
Line 12: Line 12:
| 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=IT._pageName=Page|where=IT.Skill = 'Bow and Rifle' AND GD._pageNamespace = '0' AND Weight <> ''
|fields=CONCAT('{{((}}favilink{{!}}',CONCAT(IT._pageName),'{{))}}')=Page
|where=IT.Skill = 'Bow and Rifle' AND GD._pageNamespace = '0' AND Weight <> ''
|format=list
|format=list
|order by=GD.Tier
|order by=GD.Tier
Line 22: Line 23:
| list2 = {{#cargo_query:tables=ItemsTable=IT, GeneralData=GD
| list2 = {{#cargo_query:tables=ItemsTable=IT, GeneralData=GD
|join on = IT.JoinKey = GD.JoinKey
|join on = IT.JoinKey = GD.JoinKey
|fields=IT._pageName=Page|where=IT.Skill = 'Pistol' AND GD._pageNamespace = '0' AND Weight <> ''
|fields=CONCAT('{{((}}favilink{{!}}',CONCAT(IT._pageName),'{{))}}')=Page
|where=IT.Skill = 'Pistol' AND GD._pageNamespace = '0' AND Weight <> ''
|format=list
|format=list
|order by=GD.Tier
|order by=GD.Tier
Line 31: Line 33:
| list3= {{#cargo_query:tables=ItemsTable=IT, GeneralData=GD
| list3= {{#cargo_query:tables=ItemsTable=IT, GeneralData=GD
|join on = IT.JoinKey = GD.JoinKey
|join on = IT.JoinKey = GD.JoinKey
|fields=IT._pageName=Page|where=IT.Skill = 'Heavy Weapon' AND GD._pageNamespace = '0' AND Weight <> ''
|fields=CONCAT('{{((}}favilink{{!}}',CONCAT(IT._pageName),'{{))}}')=Page
|where=IT.Skill = 'Heavy Weapon' AND GD._pageNamespace = '0' AND Weight <> ''
|format=list
|format=list
|order by=GD.Tier
|order by=GD.Tier