Template:Weapon Navbox: Difference between revisions
Jump to navigation
Jump to search
(rm favilink) |
(Fix some missing items in the weapon navbox) |
||
Line 14: | Line 14: | ||
|list1={{#cargo_query:tables=ItemsTable=IT, GeneralData=GD, ExtraInfo=EI | |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' AND Weight <> '' | |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 | |format=list | ||
|order by=GD.Tier | |order by=GD.Tier | ||
Line 34: | Line 34: | ||
|list1={{#cargo_query:tables=ItemsTable=IT, GeneralData=GD, ExtraInfo=EI | |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' AND Weight <> '' | |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 | |format=list | ||
|order by=GD.Tier | |order by=GD.Tier | ||
Line 53: | Line 53: | ||
|list1={{#cargo_query:tables=ItemsTable=IT, GeneralData=GD, ExtraInfo=EI | |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' AND Weight <> '' | |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 | |format=list | ||
|order by=GD.Tier | |order by=GD.Tier |