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

From A3! Wiki
Line 1: Line 1:
{| cellpadding="10" style="text-align:center; background-color: #eee; margin: auto;" class="navboxtable"
+
==Link Skill==
! colspan="{{#expr: 1 + {{#cargo_query:tables=Characters|fields=COUNT(troupeorder)=count|order by=count ASC|more results text=|no html|limit=1}}}}" style="font-size: 1.4rem"|[[Character Hub|Main Characters]]
+
{| class="wikitable a3table sortable"
|-style="line-height:30px"
+
|-
|<div style="float:left">[[File:Spring troupe.png|30px]]</div> '''Spring'''
+
! Link Skill
{{#cargo_query:tables=Characters
+
! Characters
|fields=firstname
+
! Description
|order by=troupeorder ASC
+
! Bonus
|where=troupe="Spring" AND maincast=1
+
|- style="height: 3em;"
|more results text=
 
|no html
 
|format=template
 
|template=Navbox Link}}
 
|-style="line-height:30px"
 
|<div style="float:left">[[File:Summer troupe.png|30px]]</div> '''Summer'''
 
{{#cargo_query:tables=Characters
 
|fields=firstname
 
|order by=troupeorder ASC
 
|where=troupe="Summer" AND maincast=1
 
|more results text=
 
|no html
 
|format=template
 
|template=Navbox Link}}
 
|-style="line-height:30px"
 
|<div style="float:left">[[File:Autumn troupe.png|30px]]</div> '''Autumn'''
 
{{#cargo_query:tables=Characters
 
|fields=firstname
 
|order by=troupeorder ASC
 
|where=troupe="Autumn" AND maincast=1
 
|more results text=
 
|no html
 
|format=template
 
|template=Navbox Link}}
 
|-style="line-height:30px"
 
|<div style="float:left">[[File:Winter troupe.png|30px]]</div> '''Winter'''
 
{{#cargo_query:tables=Characters
 
|fields=firstname
 
|order by=troupeorder ASC
 
|where=troupe="Winter" AND maincast=1
 
|more results text=
 
|no html
 
|format=template
 
|template=Navbox Link}}
 
 
|}
 
|}
 +
 +
 +
{{#cargo_query:
 +
tables=Link_Skill
 +
|fields=linkname=Link Skill,CONCAT(chara1, IFNULL(CONCAT(', ',chara2), ''), IFNULL(CONCAT(', ',chara3, ''), ''), IFNULL(CONCAT(', ',chara4,''), '')) = Characters,description=Description,CONCAT(attribute,' ',bonus,'% Up') = Bonus
 +
|where="Tsuzuru Minagi" IN(chara1,chara2,chara3,chara4) OR troupe="Spring"
 +
|format=table
 +
|order by=bonus="Co" DESC,bonus="Ac" DESC,bonus="Sr" DESC
 +
|limit=10
 +
}}

Revision as of 11:55, 19 December 2017

Link Skill

Link Skill Characters Description Bonus


Link Skill Characters Description Bonus
Tsuzuru Minagi, Muku Sakisaka, Sakyo Furuichi, Tasuku Takato Established by Sakyo. Will they be able to get glamorous prizes in the sweepstakes...!? Co 48% Up
Tsuzuru Minagi, Citron "We've only just started climbing - this long, unending..." Co 12% Up
Tsuzuru Minagi, Homare Arisugawa A culture club started by Homare. Is the release of a collaboration zine close at hand? Co 12% Up
Tsuzuru Minagi, Omi Fushimi, Azami Izumida, Tasuku Takato "Minagi, Fushimi, and Azami all have good muscles...I want to make a futsal team too." Ac 36% Up
A theatre unit specialising in traditional fairytales and fantasy plays. Sr 60% Up
Tsuzuru Minagi, Omi Fushimi A popular university of average rank. The students are called 'fairy (yousei) boys'. Sr 12% Up
Tsuzuru Minagi, Juza Hyodo, Omi Fushimi The 'fairy boys', now with Juza included! The school canteen's cream anmitsu is to die for? Sr 27% Up
Tsuzuru Minagi, Tenma Sumeragi, Juza Hyodo, Taichi Nanao Upperclassmen’s graduation and underclassmen’s enrollment. A new lineup of 'fairy boys'! Sr 39% Up
Masumi Usui, Itaru Chigasaki, Tsuzuru Minagi Flailing over Masumi, sighing over Itaru...Tsuzuru gets a double dose of anxiety. Ac 36% Up
Homare Arisugawa, Tsuzuru Minagi, Azami Izumida 言葉を操る者の死闘!?小粋なリリックド派手にかませ! Co 24% Up

More...