Difference between revisions of "Template:Link Skill/Table"
From A3! Wiki
m |
m |
||
| Line 4: | Line 4: | ||
|fields=CONCAT(linkname, IFNULL(CONCAT('<br /><span style="color: red; font-size: 0.8em;">Event: [[',event,']]</span>'),''))=Link Skill, | |fields=CONCAT(linkname, IFNULL(CONCAT('<br /><span style="color: red; font-size: 0.8em;">Event: [[',event,']]</span>'),''))=Link Skill, | ||
IF(troupe IS NOT NULL, CONCAT('[[File:', troupe, '_troupe.png|25px|link=]] [[', troupe, ' Troupe|', troupe, ']]'), | IF(troupe IS NOT NULL, CONCAT('[[File:', troupe, '_troupe.png|25px|link=]] [[', troupe, ' Troupe|', troupe, ']]'), | ||
| − | CONCAT(IFNULL(CONCAT('[[File:',file1,'|33px]] '),''), CONCAT('[[', CASE WHEN LOCATE(' ',chara1) = 0 THEN chara1 ELSE LEFT(chara1,LOCATE(' ',chara1) - 1) END,']]'), | + | CONCAT(IFNULL(CONCAT('[[File:',file1,'|33px]] '),''), CONCAT('[[',chara1,'|', CASE WHEN LOCATE(' ',chara1) = 0 THEN chara1 ELSE LEFT(chara1,LOCATE(' ',chara1) - 1) END,']]'), |
| − | IFNULL(CONCAT('<br />[[File:',file2,'|33px]] '),''), IFNULL(CONCAT('<br />[[', CASE WHEN LOCATE(' ',chara2) = 0 THEN chara2 ELSE LEFT(chara2,LOCATE(' ',chara2) - 1) END,']]'),''), | + | IFNULL(CONCAT('<br />[[File:',file2,'|33px]] '),''), IFNULL(CONCAT('<br />[[',chara2,'|', CASE WHEN LOCATE(' ',chara2) = 0 THEN chara2 ELSE LEFT(chara2,LOCATE(' ',chara2) - 1) END,']]'),''), |
| − | IFNULL(CONCAT('<br />[[File:',file3,'|33px]] '),''), IFNULL(CONCAT('<br />[[', CASE WHEN LOCATE(' ',chara3) = 0 THEN chara3 ELSE LEFT(chara3,LOCATE(' ',chara3) - 1) END,']]'),''), | + | IFNULL(CONCAT('<br />[[File:',file3,'|33px]] '),''), IFNULL(CONCAT('<br />[[',chara3,'|', CASE WHEN LOCATE(' ',chara3) = 0 THEN chara3 ELSE LEFT(chara3,LOCATE(' ',chara3) - 1) END,']]'),''), |
| − | IFNULL(CONCAT('<br />[[File:',file4,'|33px]] '),''), IFNULL(CONCAT('<br />[[', CASE WHEN LOCATE(' ',chara4) = 0 THEN chara4 ELSE LEFT(chara4,LOCATE(' ',chara4) - 1) END,']]'),''), | + | IFNULL(CONCAT('<br />[[File:',file4,'|33px]] '),''), IFNULL(CONCAT('<br />[[',chara4,'|', CASE WHEN LOCATE(' ',chara4) = 0 THEN chara4 ELSE LEFT(chara4,LOCATE(' ',chara4) - 1) END,']]'),''), |
| − | IFNULL(CONCAT('<br />[[File:',file5,'|33px]] '),''), IFNULL(CONCAT('<br />[[', CASE WHEN LOCATE(' ',chara5) = 0 THEN chara5 ELSE LEFT(chara5,LOCATE(' ',chara5) - 1) END,']]'),'') ) ) = Characters, | + | IFNULL(CONCAT('<br />[[File:',file5,'|33px]] '),''), IFNULL(CONCAT('<br />[[',chara5,'|', CASE WHEN LOCATE(' ',chara5) = 0 THEN chara5 ELSE LEFT(chara5,LOCATE(' ',chara5) - 1) END,']]'),'') ) ) = 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 | ||
