Template:Tiered Body Part Equipment Navbox: Difference between revisions

From Caves of Qud Wiki
Jump to navigation Jump to search
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"

Revision as of 23:37, 20 December 2021

Generic template wrapper for a tiered body part equipment navbox for the specified body part. Excludes shields and bucklers from the navbox by default.

parameter description
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"
bodypart The body part that will be used for cargo queries, such as "Head" or "Body".
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.

Example:

{{Tiered Body Part Equipment Navbox|category=Head Equipment|bodypart=Head|navboxname=Head Equipment}}

Result: