Template:Tiered Body Part Equipment Navbox: Difference between revisions

tweak query to include black mote
(exclude shields / bucklers)
(tweak query to include black mote)
 
(5 intermediate revisions by the same user not shown)
Line 1: Line 1:
<includeonly>{{Navbox
<includeonly>{{Navbox
| name      = {{{navboxname|Body Armor}}} Navbox
| name      = {{{navboxname|Body Armor}}} Navbox
| title      = List of [[:Category:{{{category|Armor}}}|{{{navboxname|Body Armor}}}]]
| title      = List of [[:Category:{{{category|Armor}}}|{{{navboxtitle|{{{navboxname|Body Armor}}}}}}]]
| below      = <div style="text-align:right;font-size:100%; font-weight:bold; font-family:Source Code Pro;"><span style="color:#155352;">see also:</span> [[Template:Armor_Navbox|full list of armor and shields]] <span style="color:#155352;">-</span> [[List_of_Body_Parts|equipment by body part]]</span></div>
| below      = <div style="text-align:right;font-size:100%; font-weight:bold; font-family:Source Code Pro;"><span style="color:#155352;">see also:</span> {{#if:{{{seealso|}}}|{{{seealso}}} <span style="color:#155352;">-</span>}} [[Template:Armor_Navbox|full list of armor and shields]] <span style="color:#155352;">-</span> [[List_of_Body_Parts|equipment by body part]]</span></div>
| listclass  = hlist
| listclass  = hlist
| state      = {{{state|collapsed}}}
| state      = {{{state|collapsed}}}
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 <> '' AND Skill <> 'Shield'
   | where    = COALESCE(GD.Tier,1)=1 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0' 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 <> '' AND Skill <> 'Shield'
   | where    = COALESCE(GD.Tier,1)=2 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0' 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 <> '' AND Skill <> 'Shield'
   | where    = COALESCE(GD.Tier,1)=3 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0' 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 <> '' AND Skill <> 'Shield'
   | where    = COALESCE(GD.Tier,1)=4 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0' 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 <> '' AND Skill <> 'Shield'
   | where    = COALESCE(GD.Tier,1)=5 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0' 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 <> '' AND Skill <> 'Shield'
   | where    = COALESCE(GD.Tier,1)=6 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0' 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 <> '' AND Skill <> 'Shield'
   | where    = COALESCE(GD.Tier,1)=7 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0' 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 <> '' AND Skill <> 'Shield'
   | where    = COALESCE(GD.Tier,1)>=8 AND WornOn='{{{bodypart|Body}}}' AND GD._pageNamespace='0' AND Skill <> 'Shield'
   | format    = list
   | format    = list
   | order by  = GD.PlainName
   | order by  = GD.PlainName
Line 128: Line 128:
|-
|-
| navboxname
| navboxname
| Name of the navbox for end-user display. Should match the page name minus "Navbox", for example set this to "Body Armor" if the page name is "Template:Body Armor Navbox"
| Name of the navbox. Should match the navbox page name excluding the " Navbox" part at the end. For example, "Template:Body Armor Navbox" should have this set to "Body Armor".
|-
| navboxtitle
| Optional. User-friendly navbox title. Defaults to navboxname if not specified.
|-
|-
| bodypart
| bodypart
Line 135: Line 138:
| category
| category
| The associated category to link to. For example, the Body Armor Navbox sets this to "Armor", which results in a link to [[:Category:Armor]].
| The associated category to link to. For example, the Body Armor Navbox sets this to "Armor", which results in a link to [[:Category:Armor]].
|-
| seealso
| Optional. An additional link that should be pre-pended to the default list of "see also:" links. See [[Template:Floating Nearby Objects Navbox]] for an example of this in use.
|}
|}