Difference between revisions of "Template:Link Skill/Table"
From A3! Wiki
Fimbulvetr (talk | contribs) |
Fimbulvetr (talk | contribs) |
||
| Line 2: | Line 2: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Link_Skill | tables=Link_Skill | ||
| − | |fields=linkname=Link Skill,IF(troupe IS NOT NULL, CONCAT('[[File:', troupe, '_troupe.png|25px|link=]] ', troupe), CONCAT(CONCAT('[[',chara1,']]'), IFNULL(CONCAT('<br>[[',chara2,']]'), ''), IFNULL(CONCAT('<br>[[',chara3, ']]'), ''), IFNULL(CONCAT('<br>[[',chara4,']]'), ''))) = | + | |fields=linkname=Link Skill,IF(troupe IS NOT NULL, CONCAT('[[File:', troupe, '_troupe.png|25px|link=]] ', troupe), CONCAT(CONCAT('[[File:', chara1 ,'_Icon.png|30px]] ','[[',chara1,']]'), IFNULL(CONCAT('<br>[[File:', chara2 ,'_Icon.png|30px]] ','[[',chara2,']]'), ''), IFNULL(CONCAT('<br>[[File:', chara3 ,'_Icon.png|30px]] ','[[',chara3,']]'), ''), IFNULL(CONCAT('<br>[[File:', chara4,'_Icon.png|30px]] ','[[',chara4,']]'), ''))) = Characters, |
description=Description, | description=Description, | ||
CONCAT(CASE WHEN attribute = "Co" THEN CONCAT('[[File:Comedy.png|20px|link=|Comedy]] Co ', bonus, '% Up') WHEN attribute = "Ac" THEN CONCAT('[[File:Action.png|20px|link=|Action]] Ac ', bonus, '% Up') ELSE CONCAT('[[File:Serious.png|20px|link=|Serious]] Sr ', bonus, '% Up') END) = Bonus | CONCAT(CASE WHEN attribute = "Co" THEN CONCAT('[[File:Comedy.png|20px|link=|Comedy]] Co ', bonus, '% Up') WHEN attribute = "Ac" THEN CONCAT('[[File:Action.png|20px|link=|Action]] Ac ', bonus, '% Up') ELSE CONCAT('[[File:Serious.png|20px|link=|Serious]] Sr ', bonus, '% Up') END) = Bonus | ||
