|
|
| Line 1: |
Line 1: |
| − | =Backstage: Other Charas= | + | ==Backstage: Other Charas (GOD-za)== |
| | ''Last updated: Thu, 27 May 2021''<hr> | | ''Last updated: Thu, 27 May 2021''<hr> |
| − | ===Ensemble Cast===
| |
| | {{#cargo_query: | | {{#cargo_query: |
| − | tables=Cards,Card_Files,Card_Stats,Charas_Ensemble
| + | tables=Cards,Card_Files,Charas,Card_Stats,Charas |
| − | |join on=Cards.chara=Charas_Ensemble.name_en, Cards.number=Card_Files.number, Cards.number=Card_Stats.number
| + | |join on=Cards.chara=Charas._pageName, Cards.number=Card_Files.number, Card_Stats.number=Cards.number |
| − | |fields=CONCAT('[[File:', rarity, '_icon.png|x20px|middle|link=|', rarity, ']]')=Rarity, IF( Cards.prebloomed LIKE 'Yes' OR Cards.prebloomed LIKE 'yes' OR Cards.prebloomed like 'true' OR Cards.prebloomed = '1', CONCAT('[[File:',Card_Files.icon2,'|35px]]'), CONCAT(CONCAT('[[File:',Card_Files.icon1,'|35px]]'), ' ', CONCAT('[[File:',Card_Files.icon2,'|35px]]')))=Icon,CONCAT('[[', Cards.chara ,'/', Cards.cardname,'|', Cards.cardname, ']]')=Card Name, Card_Stats.cardname_jp = Card Name (JP)
| |
| − | |where=Charas_Ensemble.maincast LIKE "Ensemble"
| |
| − | |format=table
| |
| − | |order by=Cards.number
| |
| − | }}
| |
| − | ===MANKAI Affiliates===
| |
| − | {{#cargo_query:
| |
| − | tables=Cards,Card_Files,Charas,Card_Stats,Charas_Ensemble | |
| − | |join on=Cards.chara=Charas._pageName,Cards.chara=Charas_Ensemble.name_en,Cards.number=Card_Files.number,Card_Stats.number=Cards.number
| |
| − | |fields=CONCAT('[[File:', rarity, '_icon.png|x20px|middle|link=|', rarity, ']]')=Rarity, IF( Cards.prebloomed LIKE 'Yes' OR Cards.prebloomed LIKE 'yes' OR Cards.prebloomed like 'true' OR Cards.prebloomed = '1', CONCAT('[[File:',Card_Files.icon2,'|35px]]'), CONCAT(CONCAT('[[File:',Card_Files.icon1,'|35px]]'), ' ', CONCAT('[[File:',Card_Files.icon2,'|35px]]')))=Icon,CONCAT('[[', Cards.chara ,'/', Cards.cardname,'|', Cards.cardname, ']]')=Card Name, Card_Stats.cardname_jp = Card Name (JP)
| |
| − | |where=Charas.troupe is null AND Charas_Ensemble.maincast is null AND Cards.cardname NOT LIKE "%Demon Coach" AND Cards.chara NOT LIKE "Kamekichi%" AND Cards.chara NOT LIKE "%Sankaku%"
| |
| − | |format=table
| |
| − | |order by=Cards.chara,Cards.number,Cards.rarity
| |
| − | }}
| |
| − | ===GOD-za===
| |
| − | {{#cargo_query:
| |
| − | tables=Cards,Card_Files,Charas,Card_Stats,Charas_Ensemble
| |
| − | |join on=Cards.chara=Charas._pageName,Cards.chara=Charas_Ensemble.name_en,Cards.number=Card_Files.number,Card_Stats.number=Cards.number | |
| | |fields=CONCAT('[[File:', rarity, '_icon.png|x20px|middle|link=|', rarity, ']]')=Rarity, IF( Cards.prebloomed LIKE 'Yes' OR Cards.prebloomed LIKE 'yes' OR Cards.prebloomed like 'true' OR Cards.prebloomed = '1', CONCAT('[[File:',Card_Files.icon2,'|35px]]'), CONCAT(CONCAT('[[File:',Card_Files.icon1,'|35px]]'), ' ', CONCAT('[[File:',Card_Files.icon2,'|35px]]')))=Icon,CONCAT('[[', Cards.chara ,'/', Cards.cardname,'|', Cards.cardname, ']]')=Card Name, Card_Stats.cardname_jp = Card Name (JP) | | |fields=CONCAT('[[File:', rarity, '_icon.png|x20px|middle|link=|', rarity, ']]')=Rarity, IF( Cards.prebloomed LIKE 'Yes' OR Cards.prebloomed LIKE 'yes' OR Cards.prebloomed like 'true' OR Cards.prebloomed = '1', CONCAT('[[File:',Card_Files.icon2,'|35px]]'), CONCAT(CONCAT('[[File:',Card_Files.icon1,'|35px]]'), ' ', CONCAT('[[File:',Card_Files.icon2,'|35px]]')))=Icon,CONCAT('[[', Cards.chara ,'/', Cards.cardname,'|', Cards.cardname, ']]')=Card Name, Card_Stats.cardname_jp = Card Name (JP) |
| | |where=Charas.troupe LIKE "GOD-za" | | |where=Charas.troupe LIKE "GOD-za" |
| | |format=table | | |format=table |
| − | |order by=Cards.rarity, Cards.number | + | |order by=Cards.chara, Cards.rarity, Cards.number |
| − | }}
| |
| − | | |
| − | =GOD-za (Haruto & Shift) temp. chara data=
| |
| − | ''Last updated: Thu, 27 May 2021''<hr>
| |
| − | {{Character Data
| |
| − | |firstname=Haruto
| |
| − | |surname=Asuka
| |
| − | |name_jp=飛鳥 晴翔
| |
| − | |name_en=Asuka Haruto
| |
| − | |image=<!--Haruto Profile.png-->
| |
| − | |icon=<!--Haruto Asuka Icon.png-->
| |
| − | |age=,23,,25
| |
| − | |height=172
| |
| − | |birthday=09/02
| |
| − | |bloodtype=B
| |
| − | |occupation=,,,Actor (belonging to GOD-za)
| |
| − | |motif=N/A
| |
| − | |hobby=不幸の手紙書き
| |
| − | |LIME_jp=晴翔
| |
| − | |liked_food=?
| |
| − | |disliked_food=?
| |
| − | |family=?
| |
| − | |strength=?
| |
| − | |weakness=?
| |
| − | |troupe=GOD-za
| |
| − | |voice=[[Mitsuhiro Ichiki]]
| |
| − | |signature=
| |
| − | |maincast=no
| |
| − | }}
| |
| − | {{Character Data
| |
| − | |firstname=Shift
| |
| − | |surname=Arakawa
| |
| − | |name_jp=荒川 志太
| |
| − | |name_en=Arakawa Shift
| |
| − | |image=<!--Shift Profile.png-->
| |
| − | |icon=<!--Shift Arakawa Icon.png-->
| |
| − | |age=,,,15
| |
| − | |height=185
| |
| − | |birthday=09/28
| |
| − | |bloodtype=A
| |
| − | |occupation=,,,1st year at Fuko High School
| |
| − | |motif=N/A
| |
| − | |hobby=?
| |
| − | |LIME_jp=志太
| |
| − | |liked_food=Croquette udon
| |
| − | |disliked_food=Food that is too high-class
| |
| − | |family=Mother, younger brother
| |
| − | |strength=Baseball
| |
| − | |weakness=?
| |
| − | |troupe=GOD-za
| |
| − | |voice=[[Tatsuya Kageyama]]
| |
| − | |signature=
| |
| − | |maincast=no
| |
| | }} | | }} |
_Haruto_Asuka_Comedy_R_Icon_Unbloomed.png){kind=icon}
_Haruto_Asuka_Comedy_R_Icon_Bloomed.png){kind=icon}
_Haruto_Asuka_Action_SR%2B%2B_Icon_Bloomed.png){kind=icon}
_Haruto_Asuka_Serious_SSR_Icon_Unbloomed.png){kind=icon}
_Haruto_Asuka_Serious_SSR_Icon_Bloomed.png){kind=icon}
_Shift_Arakawa_Serious_R_Icon_Unbloomed.png){kind=icon}
_Shift_Arakawa_Serious_R_Icon_Bloomed.png){kind=icon}
_Shift_Arakawa_Action_SR_Icon_Unbloomed.png){kind=icon}
_Shift_Arakawa_Action_SR_Icon_Bloomed.png){kind=icon}
_Shift_Arakawa_Comedy_SR%2B%2B_Icon_Bloomed.png){kind=icon}
