Template:Member: Difference between revisions

From Absit Omen Lexicon
mNo edit summary
mNo edit summary
Line 1: Line 1:
<includeonly>
<includeonly>
=={{{2}}} Characters==
=={{{2|}}} Characters==
{{#cargo_query:
{{#cargo_query:
tables=Characters
tables=Characters
|where=member="{{{1|}}}" AND status LIKE active
|where=member="{{{1|}}}" AND status = active AND status = inactive
|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 LIKE active
|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 LIKE active
|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:54, 26 June 2016