Template:Hogwarts navbox: Difference between revisions
From Absit Omen Lexicon
mNo edit summary |
mNo edit summary |
||
| Line 85: | Line 85: | ||
tables=Occupations | tables=Occupations | ||
|fields=_pageName | |fields=_pageName | ||
|where=type="Hogwarts" AND current_occupation= | |where=type="Hogwarts" AND current_occupation=1 AND title LIKE "headm%" | ||
|order by=title | |order by=title | ||
|default=OPEN | |default=OPEN | ||
| Line 95: | Line 95: | ||
tables=Occupations | tables=Occupations | ||
|fields=_pageName | |fields=_pageName | ||
|where=type="Hogwarts" AND current_occupation= | |where=type="Hogwarts" AND current_occupation=1 AND title LIKE "deputy head%" | ||
|order by=title | |order by=title | ||
|default=OPEN | |default=OPEN | ||
| Line 106: | Line 106: | ||
tables=Occupations | tables=Occupations | ||
|fields=CONCAT('[[',_pageName,'{{!}}',title,']]') | |fields=CONCAT('[[',_pageName,'{{!}}',title,']]') | ||
|where=type="Hogwarts" AND current_occupation= | |where=type="Hogwarts" AND current_occupation=1 AND title LIKE "%head of%" | ||
|order by=title | |order by=title | ||
|default=OPEN | |default=OPEN | ||
| Line 117: | Line 117: | ||
tables=Occupations | tables=Occupations | ||
|fields=CONCAT('[[',_pageName,'{{!}}',department,']]') | |fields=CONCAT('[[',_pageName,'{{!}}',department,']]') | ||
|where=type="Hogwarts" AND department IS NOT NULL AND current_occupation= | |where=type="Hogwarts" AND department IS NOT NULL AND current_occupation=1 | ||
|order by=department | |order by=department | ||
|default=OPEN | |default=OPEN | ||
| Line 128: | Line 128: | ||
tables=Occupations | tables=Occupations | ||
|fields=CONCAT('[[',_pageName,'{{!}}',title,']]') | |fields=CONCAT('[[',_pageName,'{{!}}',title,']]') | ||
|where=type="Hogwarts" AND department IS NULL AND current_occupation= | |where=type="Hogwarts" AND department IS NULL AND current_occupation=1 AND title NOT LIKE "%head%" AND title<>"Governor" | ||
|order by=title | |order by=title | ||
|default=OPEN | |default=OPEN | ||
