Template:Walls Navbox: Difference between revisions
Jump to navigation
Jump to search
m (exclude Data namespace) |
m (title tweaks) |
||
Line 79: | Line 79: | ||
| tables = Characters=C, GeneralData=GD | | tables = Characters=C, GeneralData=GD | ||
| 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,'{{!}}{{(}}lcfirst:',GD._pageName,'{{)}}{{)}}')=Page | ||
| where = GD.Categories = 'Tech Walls' AND GD._pageNamespace = '0' | | where = GD.Categories = 'Tech Walls' AND GD._pageNamespace = '0' | ||
| format = list | | format = list | ||
Line 107: | Line 107: | ||
| tables = Characters=C, GeneralData=GD | | tables = Characters=C, GeneralData=GD | ||
| 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,'{{!}}{{(}}lcfirst:',GD._pageName,'{{)}}{{)}}')=Page | ||
| where = GD.Categories = 'Sultan Walls' AND GD._pageNamespace = '0' | | where = GD.Categories = 'Sultan Walls' AND GD._pageNamespace = '0' | ||
| format = list | | format = list | ||
Line 121: | Line 121: | ||
| tables = Characters=C, GeneralData=GD | | tables = Characters=C, GeneralData=GD | ||
| 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,'{{!}}{{(}}lcfirst:',GD._pageName,'{{)}}{{)}}')=Page | ||
| where = GD.Categories = 'Murals' AND GD._pageNamespace = '0' | | where = GD.Categories = 'Murals' AND GD._pageNamespace = '0' | ||
| format = list | | format = list |
Revision as of 19:46, 14 June 2022
Navbox listing walls (and wall-like-objects) by category. Each category is sorted by name.
Example:
{{Walls Navbox}}