Template:Weapon Navbox: Difference between revisions

From Caves of Qud Wiki
Jump to navigation Jump to search
No edit summary
(Fix some missing items in the weapon navbox)
 
(One intermediate revision by one other user not shown)
Line 12: Line 12:
| list1 = {{Navbox subgroup|state=collapsed
| list1 = {{Navbox subgroup|state=collapsed
|group1=1 Handed
|group1=1 Handed
|list1={{#invoke:CargoQuery|main
|list1={{#cargo_query:tables=ItemsTable=IT, GeneralData=GD, ExtraInfo=EI
|table=ItemsTable=IT, GeneralData=GD, ExtraInfo=EI
|join on = IT.JoinKey = EI.JoinKey, IT.JoinKey = GD.JoinKey
|join on = IT.JoinKey = EI.JoinKey, IT.JoinKey = GD.JoinKey
|fields=IT._pageName=Page|where=IT.Skill = 'Axe' AND EI.Info NOT LIKE '%Two Handed,,,%' AND GD._pageNamespace = '0'
|fields=IT._pageName=Page|where=IT.Skill = 'Axe' AND (EI.Info IS NULL OR EI.Info NOT LIKE '%Two Handed,,,%') AND GD._pageNamespace = '0' AND Weight <> ''
|format=list|order by=GD.Tier
|format=list
|template=favilink page
|order by=GD.Tier
|delimiter=&nbsp;-&nbsp;</span><span style="display:inline-block">|intro=<span style="display:inline-block">|outro=</span>}}
|delimiter=&nbsp;-&nbsp;</span><span style="display:inline-block">|intro=<span style="display:inline-block">|outro=</span>}}


| group2=2 Handed
| group2=2 Handed
| list2={{#invoke:CargoQuery|main
| list2={{#cargo_query:tables=ItemsTable=IT, GeneralData=GD, ExtraInfo=EI
|table=ItemsTable=IT, GeneralData=GD, ExtraInfo=EI
|join on = IT.JoinKey = EI.JoinKey, IT.JoinKey = GD.JoinKey
|join on = IT.JoinKey = EI.JoinKey, IT.JoinKey = GD.JoinKey
|fields=IT._pageName=Page|where=IT.Skill = 'Axe' AND EI.Info LIKE '%Two Handed,,,%' AND GD._pageNamespace = '0'
|fields=IT._pageName=Page|where=IT.Skill = 'Axe' AND EI.Info LIKE '%Two Handed,,,%' AND GD._pageNamespace = '0' AND Weight <> ''
|format=list|order by=GD.Tier
|format=list
|template=favilink page
|order by=GD.Tier
|delimiter=&nbsp;-&nbsp;</span><span style="display:inline-block">|intro=<span style="display:inline-block">|outro=</span>}}
|delimiter=&nbsp;-&nbsp;</span><span style="display:inline-block">|intro=<span style="display:inline-block">|outro=</span>}}
}}
}}
| group2style = background:rgba(6,28,23,0.2);
| group2style = background:rgba(6,28,23,0.2);
| group2= [[Cudgel]]
| group2= [[Cudgel]]
| list2 = {{Navbox subgroup|state=collapsed
| list2 = {{Navbox subgroup|state=collapsed
|group1=1 Handed
|group1=1 Handed
|list1={{#invoke:CargoQuery|main
|list1={{#cargo_query:tables=ItemsTable=IT, GeneralData=GD, ExtraInfo=EI
|table=ItemsTable=IT, GeneralData=GD, ExtraInfo=EI
|join on = IT.JoinKey = EI.JoinKey, IT.JoinKey = GD.JoinKey
|join on = IT.JoinKey = EI.JoinKey, IT.JoinKey = GD.JoinKey
|fields=IT._pageName=Page|where=IT.Skill = 'Cudgel' AND EI.Info NOT LIKE '%Two Handed,,,%' AND GD._pageNamespace = '0'
|fields=IT._pageName=Page|where=IT.Skill = 'Cudgel' AND (EI.Info IS NULL OR EI.Info NOT LIKE '%Two Handed,,,%') AND GD._pageNamespace = '0' AND Weight <> ''
|format=list|order by=GD.Tier
|format=list
|template=favilink page
|order by=GD.Tier
|delimiter=&nbsp;-&nbsp;</span><span style="display:inline-block">|intro=<span style="display:inline-block">|outro=</span>}}
|delimiter=&nbsp;-&nbsp;</span><span style="display:inline-block">|intro=<span style="display:inline-block">|outro=</span>}}


| group2=2 Handed
| group2=2 Handed
| list2={{#invoke:CargoQuery|main
| list2={{#cargo_query:tables=ItemsTable=IT, GeneralData=GD, ExtraInfo=EI
|table=ItemsTable=IT, GeneralData=GD, ExtraInfo=EI
|join on = IT.JoinKey = EI.JoinKey, IT.JoinKey = GD.JoinKey
|join on = IT.JoinKey = EI.JoinKey, IT.JoinKey = GD.JoinKey
|fields=IT._pageName=Page|where=IT.Skill = 'Cudgel' AND EI.Info LIKE '%Two Handed,,,%' AND GD._pageNamespace = '0'
|fields=IT._pageName=Page|where=IT.Skill = 'Cudgel' AND EI.Info LIKE '%Two Handed,,,%' AND GD._pageNamespace = '0' AND Weight <> ''
|format=list|order by=GD.Tier
|format=list
|template=favilink page
|order by=GD.Tier
|delimiter=&nbsp;-&nbsp;</span><span style="display:inline-block">|intro=<span style="display:inline-block">|outro=</span>}}
|delimiter=&nbsp;-&nbsp;</span><span style="display:inline-block">|intro=<span style="display:inline-block">|outro=</span>}}
}}
}}
Line 54: Line 51:
| list3= {{Navbox subgroup|state=collapsed
| list3= {{Navbox subgroup|state=collapsed
|group1=1 Handed
|group1=1 Handed
|list1={{#invoke:CargoQuery|main
|list1={{#cargo_query:tables=ItemsTable=IT, GeneralData=GD, ExtraInfo=EI
|table=ItemsTable=IT, GeneralData=GD, ExtraInfo=EI
|join on = IT.JoinKey = EI.JoinKey, IT.JoinKey = GD.JoinKey
|join on = IT.JoinKey = EI.JoinKey, IT.JoinKey = GD.JoinKey
|fields=IT._pageName=Page|where=IT.Skill = 'Long Blade' AND EI.Info NOT LIKE '%Two Handed,,,%' AND GD._pageNamespace = '0'
|fields=IT._pageName=Page|where=IT.Skill = 'Long Blade' AND (EI.Info IS NULL OR EI.Info NOT LIKE '%Two Handed,,,%') AND GD._pageNamespace = '0' AND Weight <> ''
|format=list|order by=GD.Tier
|format=list
|template=favilink page
|order by=GD.Tier
|delimiter=&nbsp;-&nbsp;</span><span style="display:inline-block">|intro=<span style="display:inline-block">|outro=</span>}}
|delimiter=&nbsp;-&nbsp;</span><span style="display:inline-block">|intro=<span style="display:inline-block">|outro=</span>}}


| group2=2 Handed
| group2=2 Handed
| list2={{#invoke:CargoQuery|main
| list2={{#cargo_query:tables=ItemsTable=IT, GeneralData=GD, ExtraInfo=EI
|table=ItemsTable=IT, GeneralData=GD, ExtraInfo=EI
|join on = IT.JoinKey = EI.JoinKey, IT.JoinKey = GD.JoinKey
|join on = IT.JoinKey = EI.JoinKey, IT.JoinKey = GD.JoinKey
|fields=IT._pageName=Page|where=IT.Skill = 'Long Blade' AND EI.Info LIKE '%Two Handed,,,%' AND GD._pageNamespace = '0'
|fields=IT._pageName=Page|where=IT.Skill = 'Long Blade' AND EI.Info LIKE '%Two Handed,,,%' AND GD._pageNamespace = '0' AND Weight <> ''
|format=list|order by=GD.Tier
|format=list
|template=favilink page
|order by=GD.Tier
|delimiter=&nbsp;-&nbsp;</span><span style="display:inline-block">|intro=<span style="display:inline-block">|outro=</span>}}
|delimiter=&nbsp;-&nbsp;</span><span style="display:inline-block">|intro=<span style="display:inline-block">|outro=</span>}}
}}
}}
Line 75: Line 70:
| list4= {{Navbox subgroup|state=collapsed
| list4= {{Navbox subgroup|state=collapsed
|group1=1 Handed
|group1=1 Handed
|list1={{#invoke:CargoQuery|main
|list1={{#cargo_query:tables=ItemsTable=IT, GeneralData=GD, ExtraInfo=EI
|table=ItemsTable=IT, GeneralData=GD, ExtraInfo=EI
|join on = IT.JoinKey = EI.JoinKey, IT.JoinKey = GD.JoinKey
|join on = IT.JoinKey = EI.JoinKey, IT.JoinKey = GD.JoinKey
|fields=IT._pageName=Page|where=IT.Skill = 'Short Blade' AND EI.Info NOT LIKE '%Two Handed,,,%' AND GD._pageNamespace = '0'
|fields=IT._pageName=Page|where=IT.Skill = 'Short Blade' AND GD._pageNamespace = '0' AND Weight <> ''
|format=list
|format=list
|order by=GD.Tier
|order by=GD.Tier
|template=favilink page
|delimiter=&nbsp;-&nbsp;</span><span style="display:inline-block">|intro=<span style="display:inline-block">|outro=</span>}}
|delimiter=&nbsp;-&nbsp;</span><span style="display:inline-block">|intro=<span style="display:inline-block">|outro=</span>}}
}}
}}

Latest revision as of 21:16, 6 December 2020