Difference between revisions of "Template:Link Skill/Table"
From A3! Wiki
m |
m |
||
| Line 3: | Line 3: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Link_Skill | tables=Link_Skill | ||
| − | |fields=CONCAT(linkname, IFNULL(CONCAT('<br /><span style="color: red; font-size: 0.8em;">Event: [[',event,']]</span>'),''))=Link Skill, | + | |fields=CONCAT(IFNULL(CONCAT('<span style="font-size: 0.8em;">'''Part Two'''</span><br />'),''), 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]] '),IFNULL(CONCAT('[[File:',chara1,' Icon.png|33px]] '),'')), CONCAT('[[',chara1,'|', CASE WHEN LOCATE(' ',chara1) = 0 THEN chara1 ELSE LEFT(chara1,LOCATE(' ',chara1) - 1) END,']]'), | CONCAT(IFNULL(CONCAT('[[File:',file1,'|33px]] '),IFNULL(CONCAT('[[File:',chara1,' Icon.png|33px]] '),'')), CONCAT('[[',chara1,'|', CASE WHEN LOCATE(' ',chara1) = 0 THEN chara1 ELSE LEFT(chara1,LOCATE(' ',chara1) - 1) END,']]'), | ||
