Template:Walls Navbox: Difference between revisions

From Caves of Qud Wiki
Jump to navigation Jump to search
No edit summary
m (exclude Data namespace)
Line 24: Line 24:
   | join on  = C.ObjectID=GD.ObjectID  
   | join on  = C.ObjectID=GD.ObjectID  
   | fields    = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page
   | fields    = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page
   | where    = GD.Categories = 'Walls'
   | where    = GD.Categories = 'Walls' AND GD._pageNamespace = '0'
   | format    = list
   | format    = list
   | order by  = GD.PlainName
   | order by  = GD.PlainName
Line 38: Line 38:
   | join on  = C.ObjectID=GD.ObjectID  
   | join on  = C.ObjectID=GD.ObjectID  
   | fields    = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page
   | fields    = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page
   | where    = GD.Categories = 'Fences'
   | where    = GD.Categories = 'Fences' AND GD._pageNamespace = '0'
   | format    = list
   | format    = list
   | order by  = GD.PlainName
   | order by  = GD.PlainName
Line 52: Line 52:
   | join on  = C.ObjectID=GD.ObjectID  
   | join on  = C.ObjectID=GD.ObjectID  
   | fields    = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page
   | fields    = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page
   | where    = GD.Categories = 'Vents'
   | where    = GD.Categories = 'Vents' AND GD._pageNamespace = '0'
   | format    = list
   | format    = list
   | order by  = GD.PlainName
   | order by  = GD.PlainName
Line 66: Line 66:
   | join on  = C.ObjectID=GD.ObjectID  
   | join on  = C.ObjectID=GD.ObjectID  
   | fields    = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page
   | fields    = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page
   | where    = GD.Categories = 'Glass Walls'
   | where    = GD.Categories = 'Glass Walls' AND GD._pageNamespace = '0'
   | format    = list
   | format    = list
   | order by  = GD.PlainName
   | order by  = GD.PlainName
Line 80: Line 80:
   | join on  = C.ObjectID=GD.ObjectID  
   | join on  = C.ObjectID=GD.ObjectID  
   | fields    = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page
   | fields    = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page
   | where    = GD.Categories = 'Tech Walls'
   | where    = GD.Categories = 'Tech Walls' AND GD._pageNamespace = '0'
   | format    = list
   | format    = list
   | order by  = GD.PlainName
   | order by  = GD.PlainName
Line 94: Line 94:
   | join on  = C.ObjectID=GD.ObjectID  
   | join on  = C.ObjectID=GD.ObjectID  
   | fields    = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page
   | fields    = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page
   | where    = GD.Categories = 'Gemstone Walls'
   | where    = GD.Categories = 'Gemstone Walls' AND GD._pageNamespace = '0'
   | format    = list
   | format    = list
   | order by  = GD.PlainName
   | order by  = GD.PlainName
Line 108: Line 108:
   | join on  = C.ObjectID=GD.ObjectID  
   | join on  = C.ObjectID=GD.ObjectID  
   | fields    = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page
   | fields    = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page
   | where    = GD.Categories = 'Sultan Walls'
   | where    = GD.Categories = 'Sultan Walls' AND GD._pageNamespace = '0'
   | format    = list
   | format    = list
   | order by  = GD.PlainName
   | order by  = GD.PlainName
Line 122: Line 122:
   | join on  = C.ObjectID=GD.ObjectID  
   | join on  = C.ObjectID=GD.ObjectID  
   | fields    = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page
   | fields    = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page
   | where    = GD.Categories = 'Murals'
   | where    = GD.Categories = 'Murals' AND GD._pageNamespace = '0'
   | format    = list
   | format    = list
   | order by  = GD.PlainName
   | order by  = GD.PlainName
Line 136: Line 136:
   | join on  = C.ObjectID=GD.ObjectID  
   | join on  = C.ObjectID=GD.ObjectID  
   | fields    = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page
   | fields    = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page
   | where    = GD.Categories = 'Holographic Walls'
   | where    = GD.Categories = 'Holographic Walls' AND GD._pageNamespace = '0'
   | format    = list
   | format    = list
   | order by  = GD.PlainName
   | order by  = GD.PlainName
Line 150: Line 150:
   | join on  = C.ObjectID=GD.ObjectID  
   | join on  = C.ObjectID=GD.ObjectID  
   | fields    = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page
   | fields    = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page
   | where    = GD.Categories = 'Force Fields'
   | where    = GD.Categories = 'Force Fields' AND GD._pageNamespace = '0'
   | format    = list
   | format    = list
   | order by  = GD.PlainName
   | order by  = GD.PlainName

Revision as of 19:38, 14 June 2022

Navbox listing walls (and wall-like-objects) by category. Each category is sorted by name.

Example:

{{Walls Navbox}}

Result:

Retrieved from "https://wiki.cavesofqud.com/index.php?title=Template:Walls_Navbox&oldid=78058"