Template:Member: Difference between revisions

From Absit Omen Lexicon
mNo edit summary
mNo edit summary
Line 3: Line 3:
{{#cargo_query:
{{#cargo_query:
tables=Characters
tables=Characters
|where=member="{{{1|}}}" AND status = active AND status = inactive
|where=member="{{{1|}}}" AND status LIKE "active"
|fields=avatar, _pageName, full_name=full name
|fields=avatar, _pageName, full_name=full name
|order by=surname, given_name
|order by=surname, given_name
Line 17: Line 17:
{{#cargo_query:
{{#cargo_query:
tables=Characters
tables=Characters
|where=member="{{{1|}}}" AND status = retired
|where=member="{{{1|}}}" AND status = "retired"
|fields=avatar, _pageName, full_name=full name
|fields=avatar, _pageName, full_name=full name
|order by=surname, given_name
|order by=surname, given_name
Line 31: Line 31:
{{#cargo_query:
{{#cargo_query:
tables=Characters
tables=Characters
|where=member="{{{1|}}}" AND status = npc
|where=member="{{{1|}}}" AND status = "npc"
|fields=CONCAT("[[",_pageName,"|",full_name,"]]")=Character, CONCAT("{{Member/NPC|",npc_permission,"}}")=permission
|fields=CONCAT("[[",_pageName,"|",full_name,"]]")=Character, CONCAT("{{Member/NPC|",npc_permission,"}}")=permission
|order by=surname, given_name
|order by=surname, given_name
|format=table
|format=table
}}</includeonly>
}}</includeonly>

Revision as of 02:55, 26 June 2016