8,290
edits
m (formatting) |
(exclude shields / bucklers) |
||
Line 14: | Line 14: | ||
| join on = IT.ObjectID=GD.ObjectID | | join on = IT.ObjectID=GD.ObjectID | ||
| fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page | | fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page | ||
| where = COALESCE(GD.Tier,1)=1 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0' AND Weight <> '' | | where = COALESCE(GD.Tier,1)=1 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0' AND Weight <> '' AND Skill <> 'Shield' | ||
| format = list | | format = list | ||
| order by = GD.PlainName | | order by = GD.PlainName | ||
Line 28: | Line 28: | ||
| join on = IT.ObjectID=GD.ObjectID | | join on = IT.ObjectID=GD.ObjectID | ||
| fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page | | fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page | ||
| where = COALESCE(GD.Tier,1)=2 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0' AND Weight <> '' | | where = COALESCE(GD.Tier,1)=2 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0' AND Weight <> '' AND Skill <> 'Shield' | ||
| format = list | | format = list | ||
| order by = GD.PlainName | | order by = GD.PlainName | ||
Line 42: | Line 42: | ||
| join on = IT.ObjectID=GD.ObjectID | | join on = IT.ObjectID=GD.ObjectID | ||
| fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page | | fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page | ||
| where = COALESCE(GD.Tier,1)=3 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0' AND Weight <> '' | | where = COALESCE(GD.Tier,1)=3 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0' AND Weight <> '' AND Skill <> 'Shield' | ||
| format = list | | format = list | ||
| order by = GD.PlainName | | order by = GD.PlainName | ||
Line 56: | Line 56: | ||
| join on = IT.ObjectID=GD.ObjectID | | join on = IT.ObjectID=GD.ObjectID | ||
| fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page | | fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page | ||
| where = COALESCE(GD.Tier,1)=4 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0' AND Weight <> '' | | where = COALESCE(GD.Tier,1)=4 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0' AND Weight <> '' AND Skill <> 'Shield' | ||
| format = list | | format = list | ||
| order by = GD.PlainName | | order by = GD.PlainName | ||
Line 70: | Line 70: | ||
| join on = IT.ObjectID=GD.ObjectID | | join on = IT.ObjectID=GD.ObjectID | ||
| fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page | | fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page | ||
| where = COALESCE(GD.Tier,1)=5 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0' AND Weight <> '' | | where = COALESCE(GD.Tier,1)=5 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0' AND Weight <> '' AND Skill <> 'Shield' | ||
| format = list | | format = list | ||
| order by = GD.PlainName | | order by = GD.PlainName | ||
Line 84: | Line 84: | ||
| join on = IT.ObjectID=GD.ObjectID | | join on = IT.ObjectID=GD.ObjectID | ||
| fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page | | fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page | ||
| where = COALESCE(GD.Tier,1)=6 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0' AND Weight <> '' | | where = COALESCE(GD.Tier,1)=6 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0' AND Weight <> '' AND Skill <> 'Shield' | ||
| format = list | | format = list | ||
| order by = GD.PlainName | | order by = GD.PlainName | ||
Line 98: | Line 98: | ||
| join on = IT.ObjectID=GD.ObjectID | | join on = IT.ObjectID=GD.ObjectID | ||
| fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page | | fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page | ||
| where = COALESCE(GD.Tier,1)=7 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0' AND Weight <> '' | | where = COALESCE(GD.Tier,1)=7 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0' AND Weight <> '' AND Skill <> 'Shield' | ||
| format = list | | format = list | ||
| order by = GD.PlainName | | order by = GD.PlainName | ||
Line 112: | Line 112: | ||
| join on = IT.ObjectID=GD.ObjectID | | join on = IT.ObjectID=GD.ObjectID | ||
| fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page | | fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page | ||
| where = COALESCE(GD.Tier,1)>=8 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0' AND Weight <> '' | | where = COALESCE(GD.Tier,1)>=8 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0' AND Weight <> '' AND Skill <> 'Shield' | ||
| format = list | | format = list | ||
| order by = GD.PlainName | | order by = GD.PlainName | ||
Line 121: | Line 121: | ||
| list8style = border-bottom:1px solid rgba(77,110,122,0.3);padding-bottom: 5px; | | list8style = border-bottom:1px solid rgba(77,110,122,0.3);padding-bottom: 5px; | ||
}}</includeonly><noinclude>Generic template wrapper for a tiered body part equipment navbox for the specified body part. | }}</includeonly><noinclude>Generic template wrapper for a tiered body part equipment navbox for the specified body part. Excludes shields and bucklers from the navbox by default. | ||
{| class="wikitable" | {| class="wikitable" |