Template:Implode characters with location: Difference between revisions

@@ Line 1: / Line 1: @@
-<includeonly>{{#ifexpr: {{#ask:
+<includeonly>{{#ifexpr: {{#cargo_query:
-[[:+]]
+tables=characters
-{{#if: {{{1|}}} |   [[Alignment::{{{1}}}]] | }}
+|fields=COUNT(*)
-{{#if: {{{2|}}} | [[Affiliation::{{{2}}}]] | }}
+|where=characters.alignment = "{{{1}}}" and characters.status = "{{{3}}}" and characters.affiliation HOLDS "{{{2}}}" and characters.location = "{{{4}}}"
-{{#if: {{{3|}}} |      [[Status::{{{3}}}]] | }}
+|format=list
-|format=count}} | {{#if: {{{4|}}} | {{Implode characters with location/render|{{{4}}}|#userparam={{{1|}}},{{{2|}}},{{{3|}}}}} | <table class="nowraplinks navbox-subgroup" style="border-spacing:0">
+}} | <table class="nowraplinks navbox-subgroup" style="border-spacing:0">{{#cargo_query:
-{{Implode characters with location/render||#userparam={{{1|}}},{{{2|}}},{{{3|}}}}}{{#ask: [[Category:Locations]]
+tables=characters
- |format=template
+|fields=characters._pageName
- |template=Implode characters with location/render
+|where=characters.alignment = "{{{1}}}" and characters.status = "{{{3}}}" and characters.affiliation HOLDS "{{{2}}}" and characters.location = "{{{4}}}"
- |userparam={{{1|}}},{{{2|}}},{{{3|}}}
+|order by=characters.leader DESC, characters.name ASC
- |link=none
+|format=ul
-}}</table> | }} }}</includeonly>
+}}</table> | }}</includeonly>

Latest revision as of 18:08, 27 July 2024