Difference between revisions of "User:Fimbulvetr/Sandbox 3"

From A3! Wiki
Line 1: Line 1:
{| cellpadding="10" style="text-align:center; background-color: #121212; margin: auto;"
+
{| cellpadding="10" style="text-align:center; background-color: #fff; margin: auto;"
! colspan="{{#expr: 1 + {{#cargo_query:tables=Characters|fields=COUNT(troupe)=count|group by=troupe|order by=count DESC|more results text=|no html|limit=1}}}}" style="background-color:#5a2123;"|[[Characters]]
+
! colspan="{{#expr: 1 + {{#cargo_query:tables=Characters|fields=COUNT(troupe)=count|group by=troupe|order by=count DESC|more results text=|no html|limit=1}}}}" style="background-color:#aaa;"|[[Characters]]
 
|-
 
|-
 
|<div style="float:left;padding-right:5px;">WEY</div> '''Spring:'''
 
|<div style="float:left;padding-right:5px;">WEY</div> '''Spring:'''
 
{{#cargo_query:tables=Characters
 
{{#cargo_query:tables=Characters
|fields=name
+
|fields=name_en
|order by=name ASC
+
|order by=name_en ASC
 
|where=troupe="Spring"
 
|where=troupe="Spring"
 
|more results text=
 
|more results text=
Line 12: Line 12:
 
|<div style="float:left;padding-right:5px;">WEY</div> '''Summer:'''
 
|<div style="float:left;padding-right:5px;">WEY</div> '''Summer:'''
 
{{#cargo_query:tables=Characters
 
{{#cargo_query:tables=Characters
|fields=name
+
|fields=name_en
|order by=name ASC
+
|order by=name_en ASC
 
|where=troupe="Summer"
 
|where=troupe="Summer"
 
|more results text=
 
|more results text=
Line 20: Line 20:
 
|<div style="float:left;padding-right:5px;">WEY</div> '''Autumn:'''
 
|<div style="float:left;padding-right:5px;">WEY</div> '''Autumn:'''
 
{{#cargo_query:tables=Characters
 
{{#cargo_query:tables=Characters
|fields=name
+
|fields=name_en
|order by=name ASC
+
|order by=name_en ASC
 
|where=troupe="Autumn"
 
|where=troupe="Autumn"
 
|more results text=
 
|more results text=
Line 28: Line 28:
 
|<div style="float:left;padding-right:5px;">WEY</div> '''Winter:'''
 
|<div style="float:left;padding-right:5px;">WEY</div> '''Winter:'''
 
{{#cargo_query:tables=Characters
 
{{#cargo_query:tables=Characters
|fields=name
+
|fields=name_en
|order by=name ASC
+
|order by=name_en ASC
 
|where=troupe="Winter"
 
|where=troupe="Winter"
 
|more results text=
 
|more results text=
 
|no html}}
 
|no html}}
 
|}
 
|}

Revision as of 07:00, 8 October 2017

Characters
WEY
Spring:
Error: Table Characters not found.
WEY
Summer:
Error: Table Characters not found.
WEY
Autumn:
Error: Table Characters not found.
WEY
Winter:
Error: Table Characters not found.