Caves of Qud Wiki

Template:Tiered Body Part Equipment Navbox: Difference between revisions

Template:Tiered Body Part Equipment Navbox (view source)

Revision as of 21:48, 22 December 2022

57 bytes removed ,  21:48, 22 December 2022
tweak query to include black mote
(add seealso param)
(tweak query to include black mote)
 
(One intermediate revision by the same user not shown)
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 140: Line 140:
|-
|-
| seealso
| seealso
| Optional. An additional link that should be pre-pended to the default list of "see also:" links.
| 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.
|}
|}


Retrieved from "https://wiki.cavesofqud.com/wiki/Special:MobileDiff/65728...83600"