Difference between revisions of "User:AsahiKaen/Sandbox2"

From A3! Wiki
m
m (Archive of "missing files" code --> G.Sheets embed test)
(Tag: Replaced)
Line 1: Line 1:
"Missing Files" ALL test layouts<br>
+
''Test for embedding Google Spreadsheet graphs. Last updated Sunday, 3 Jan 2021.''<br>
If someone's reading this: please don't judge my placeholders !! xD
 
  
=Reference Table=
+
<iframe src="https://docs.google.com/spreadsheets/d/e/2PACX-1vRSBhBJoCLKtdja6x-2f_Jmi6gi-w7phmTbX3bP6bvwGJZ2YfDogxIiTY4Ds6f7-xo4m5-ixz9lXNoU/pubchart?oid=1803784660&amp;format=interactive"></iframe>
{| class="mw-collapsible mw-collapsed summertable table"
 
!style="width: 14%; text-align:center"|Character || style="width: 43%"|Unbloomed || style="width: 43%"|Bloomed
 
|-
 
| style="text-align:center"|[[File:Tenma SD Icon.png|250px|link=Tenma Sumeragi]]
 
|style="vertical-align:top"|
 
* tenmA...ily
 
* so so much
 
* and i'm so proud of how far you've come!!! babieee
 
|style="vertical-align:top"|
 
* ya..that's it
 
* from your resident tenma oshi. uwu
 
|-
 
| style="text-align:center"|[[File:Yuki SD Icon.png|250px|link=Yuki Rurikawa]]
 
|
 
<!--Unbloomed-->|style="vertical-align:top"|{{#cargo_query:tables = Card_Files|fields=}} | N/A | N/A | {{#tag:gallery
 
<!--Bloomed-->|style="vertical-align:top"|
 
|}
 
 
 
=Reference codes=
 
<!--From Template:Event (Info)
 
'''Event Scout:''' {{#cargo_query:tables= Scout|fields=CONCAT("[[Scouting Events","#",Scout.name_en,"|",Scout.name_en,"]]")|where=Scout.event HOLDS "{{{name_en|}}}" }}
 
{{#cargo_query:tables=Scout,Cards,Card_Files|join on=Cards.cardset = Scout.name_en, Cards.number = Card_Files.number|fields=Card_Files.icon1, CONCAT(Cards.rarity, ' ', Cards.chara) = Caption, CONCAT('Cards/', Cards.chara, '/', Cards.cardname) = Page Link|where=Scout.event HOLDS "{{{name_en|}}}" |format=gallery|mode=nolines|image width=100px|show bytes=0|show dimensions=0|show filename=0|alt field=Caption|caption field=Caption|link field=Page Link|default=|order by=Cards.number}}
 
 
 
'''Event Cards:''' {{#ifeq: {{#cargo_query:tables=Cards,Card_Files|join on=Cards.number = Card_Files.number|fields=IFNULL(Card_Files.icon1,Card_Files.icon2)|where=Cards.cardset="{{{name_en|}}}"|default=N/A}} | N/A | N/A | {{#tag:gallery|{{Featured Cards|{{{name_en}}}}}|mode=nolines|widths=100px}} }}<br>
 
-->
 
 
 
<!--From Template:Scout List (for Rarity > Card Name)
 
<p>'''Featured Cards:'''</p>
 
{{#ifeq: {{{type|}}} | combined | <ul>{{#cargo_query:tables=Scout,Cards|join on=Scout.name_en = Cards.cardset|fields=Cards.number,Cards.rarity,Cards.cardname,Cards.chara|where=Scout.name_en="{{{scout1|}}}" OR Scout.name_en="{{{scout2|}}}"|order by=Cards.rarity DESC, Cards.number ASC|format=template|template=Scout/Cards|named args=yes}}
 
</ul>
 
{{#cargo_query:tables=Scout,Cards,Card_Files|join on=Scout.name_en = Cards.cardset, Cards.number = Card_Files.number|fields=Cards.rarity,Cards.chara,Card_Files.image1,CONCAT(Cards.rarity,' [[',Cards.chara,']]')=caption|where=Scout.name_en="{{{scout1|}}}" OR Scout.name_en="{{{scout2|}}}"|order by=Cards.rarity DESC, Cards.number ASC|format=gallery|mode=nolines|show bytes=0|show dimensions=0|show filename=0|caption field=caption|default=' '}} | <ul>{{#cargo_query:tables=Scout,Cards|join on=Scout.name_en = Cards.cardset|fields=Cards.rarity,Cards.cardname,Cards.chara|where=Scout.name_en="{{{name_en|}}}"|order by=Cards.rarity DESC, Cards.number ASC|format=template|template=Scout/Cards|named args=yes|default=}}
 
</ul>
 
{{#cargo_query:tables=Scout,Cards,Card_Files|join on=Scout.name_en = Cards.cardset, Cards.number = Card_Files.number|fields=Cards.rarity,Cards.chara,Card_Files.image1,CONCAT(Cards.rarity,' [[',Cards.chara,']]')=caption,CONCAT('Cards/',Cards.chara,'/',Cards.cardname)=link|where=Scout.name_en="{{{name_en|}}}"|order by=Cards.rarity DESC, Cards.number ASC|format=gallery|mode=nolines|show bytes=0|show filename=0|show dimensions=0|caption field=caption|link field=link|default=}} }}</div>{{clear}}
 
-->
 
 
 
=File type > chara, by troupe=
 
<!--------------TRANSPARENT CARDS-------------->
 
{| class="mw-collapsible mw-collapsed mankaitable table"
 
!colspan="3" style="text-align:center"|Transparent Cards
 
|- style="background: var(--mankai-med)"
 
| style="width: 10%; text-align:center"|'''Character''' || style="width: 43%; text-align:center"|'''Unbloomed''' || style="width: 43%; text-align:center"|'''Bloomed'''
 
|- style="background: var(--sakuya-light)"
 
| style="text-align:center"|[[File:Sakuya SD Icon.png|250px|link=Sakuya Sakuma]]
 
| ||
 
|-
 
| || ||
 
|- style="background: var(--banri-light)"
 
| style="text-align:center"|[[File:Banri SD Icon.png|250px|link=Banri Settsu]]
 
|
 
* card no. 1
 
* card no. 1 but Bloomed
 
* card no. 2 bloomed
 
* oh this is so sexy HAHA
 
| thank u valentines banri for coming home twice, in solos, !
 
|- style="background: var(--juza-light)"
 
| style="text-align:center"|[[File:Juza SD Icon.png|250px|link=Juza Hyodo]]|| My first starter SSR on EN :D bfg vibes fooled me in thinking i'd be juza oshi..vibes were Wrong but you're still a precious sweet tooth || text text text
 
|- style="background: var(--taichi-light)"
 
| style="text-align:center"|[[File:Taichi SD Icon.png|250px|link=Taichi Nanao]]
 
|<!--TAICHI unbloomed-->
 
* taichi sir
 
* i love your fashion sense
 
* <3
 
|<!--TAICHI bloomed-->
 
* how about
 
* <s>how about you be a true man and own up to Yuki</s>
 
* uguuu I jjustw want you to be Happy
 
|- style="background: var(--omi-light)"
 
| style="text-align:center"|[[File:Omi SD Icon.png|250px|link=Omi Fushimi]] Omi
 
|<!--OMI unbloomed-->
 
* why do people keep Bullying you !!?!?!
 
* like what did you ever do to them,,,
 
* you cook for everyone! so well too !!!!
 
* i hope ppl stop using you in derogatory memes :(
 
* but instead for positive uplifting ones !!
 
* ... ok but i admit, that one of your unbloomed initial.. surrounded by ENCORE ENCORE in the back.. that one can stay
 
* BACK TO WORK STUFF THOUGH. so it's vertically centered by default.. should probably work on that
 
|<!--OMI bloomed-->
 
* puw apuw apuwapuwa pUWAAa
 
* ..ignore me please i'm just trying to fill up space here
 
* actually no one should even be reading this !! unless i send a link for This version out
 
* o_o i see you
 
* unless you're my friend !! then ilySm and i hope you have a great great day :D
 
|- style="background: var(--sakyo-light)"
 
| style="text-align:center"|[[File:Sakyo SD Icon.png|250px|link=Sakyo Furuichi]]
 
| some text here
 
| chess king sakyo didn't come home :(
 
|- style="background: var(--azami-light)"
 
| style="text-align:center"|[[File:Azami SD Icon.png|250px|link=Azami Izumida]]
 
| can't wait for you to finally come to EN!!!
 
|
 
* babie
 
* please don't be sad :( we love U
 
|-
 
| <!--DIVIDER--> || ||
 
|- style="background: var(--tsumugi-light)"
 
| style="text-align:center"|[[File:Tsumugi SD Icon.png|250px|link=Tsumugi Tsukioka]]
 
|
 
* hm
 
* hmMM
 
|
 
* oya oyaoya
 
* tsumu bb i am SO SOo proud of you..
 
* best actor
 
|}
 
 
 
__NOTOC__
 

Revision as of 09:18, 3 January 2021