Difference between revisions of "Template:Play Cast/Cards"

From A3! Wiki
m
m
 
Line 1: Line 1:
<includeonly>{{#cargo_compound_query:tables=Card_Chibis,Card_Files,Cards,Charas;join on=Charas.firstname=Card_Chibis.firstname,Card_Chibis.number=Cards.number,Card_Chibis.number=Card_Files.number;fields=CONCAT('[[File:',Card_Files.icon1,'|link=Cards/',Charas.firstname,' ',Charas.surname,'/',Cards.cardname,'|50px]] ');where=Charas.firstname="{{{chara|}}}" AND Card_Chibis.chibi1="{{{chibi|}}}"
+
<includeonly>{{#cargo_compound_query:tables=Card_Chibis,Card_Files,Cards,Charas;join on=Charas.firstname=Card_Chibis.firstname,Card_Chibis.number=Cards.number,Card_Chibis.number=Card_Files.number;fields=CONCAT('[[File:',Card_Files.icon1,'|link=Cards/',Charas.firstname,IFNULL(CONCAT(' ',Charas.surname),''),'/',Cards.cardname,'|50px]] ');where=Charas.firstname="{{{chara|}}}" AND Card_Chibis.chibi1="{{{chibi|}}}"
|tables=Card_Chibis,Card_Files,Cards,Charas;join on=Charas.firstname=Card_Chibis.firstname,Card_Chibis.number=Cards.number,Card_Chibis.number=Card_Files.number;fields=CONCAT('[[File:',Card_Files.icon2,'|link=Cards/',Charas.firstname,' ',Charas.surname,'/',Cards.cardname,'|50px]] ');where=Charas.firstname="{{{chara|}}}" AND Card_Chibis.chibi2="{{{chibi|}}}"
+
|tables=Card_Chibis,Card_Files,Cards,Charas;join on=Charas.firstname=Card_Chibis.firstname,Card_Chibis.number=Cards.number,Card_Chibis.number=Card_Files.number;fields=CONCAT('[[File:',Card_Files.icon2,'|link=Cards/',Charas.firstname,IFNULL(CONCAT(' ',Charas.surname),''),'/',Cards.cardname,'|50px]] ');where=Charas.firstname="{{{chara|}}}" AND Card_Chibis.chibi2="{{{chibi|}}}"
 
|default=
 
|default=
 
|delimiter=
 
|delimiter=
Line 6: Line 6:
 
|limit=1000}}</includeonly><noinclude>
 
|limit=1000}}</includeonly><noinclude>
  
{{Play Cast/Cards|chara=Sakyo|chibi=027}}
+
{{Play Cast/Cards|chara=Sakyo|chibi=037}}
 +
{{Play Cast/Cards|chara=Guy|chibi=005}}
  
 
</noinclude>
 
</noinclude>

Latest revision as of 12:31, 19 November 2018


(Trajectory of Blooming) Sakyo Furuichi Action SR Icon Bloomed.png (Named Color) Guy Comedy SR Icon Unbloomed.png (Premonition of Blooming) Guy Comedy SR Icon Unbloomed.png (Rehearsal) Guy Comedy R Icon Unbloomed.png (Together with a Friend's Incarnation) Guy Serious SR Icon Unbloomed.png