Template:Weapon Navbox: Difference between revisions
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={{# | |list1={{#cargo_query:tables=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 | ||
|order by=GD.Tier | |||
|delimiter= - </span><span style="display:inline-block">|intro=<span style="display:inline-block">|outro=</span>}} | |delimiter= - </span><span style="display:inline-block">|intro=<span style="display:inline-block">|outro=</span>}} | ||
| group2=2 Handed | | group2=2 Handed | ||
| list2={{# | | list2={{#cargo_query:tables=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,,,%' | |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 | ||
|order by=GD.Tier | |||
|delimiter= - </span><span style="display:inline-block">|intro=<span style="display:inline-block">|outro=</span>}} | |delimiter= - </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={{# | |list1={{#cargo_query:tables=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 | ||
|order by=GD.Tier | |||
|delimiter= - </span><span style="display:inline-block">|intro=<span style="display:inline-block">|outro=</span>}} | |delimiter= - </span><span style="display:inline-block">|intro=<span style="display:inline-block">|outro=</span>}} | ||
| group2=2 Handed | | group2=2 Handed | ||
| list2={{# | | list2={{#cargo_query:tables=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,,,%' | |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 | ||
|order by=GD.Tier | |||
|delimiter= - </span><span style="display:inline-block">|intro=<span style="display:inline-block">|outro=</span>}} | |delimiter= - </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={{# | |list1={{#cargo_query:tables=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 | ||
|order by=GD.Tier | |||
|delimiter= - </span><span style="display:inline-block">|intro=<span style="display:inline-block">|outro=</span>}} | |delimiter= - </span><span style="display:inline-block">|intro=<span style="display:inline-block">|outro=</span>}} | ||
| group2=2 Handed | | group2=2 Handed | ||
| list2={{# | | list2={{#cargo_query:tables=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,,,%' | |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 | ||
|order by=GD.Tier | |||
|delimiter= - </span><span style="display:inline-block">|intro=<span style="display:inline-block">|outro=</span>}} | |delimiter= - </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={{# | |list1={{#cargo_query:tables=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 | |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 | ||
|delimiter= - </span><span style="display:inline-block">|intro=<span style="display:inline-block">|outro=</span>}} | |delimiter= - </span><span style="display:inline-block">|intro=<span style="display:inline-block">|outro=</span>}} | ||
}} | }} |