Difference between revisions of "Template:Link Skill/Table"

From A3! Wiki
m
(2nd try - remove en link skills from chara page)
 
(2 intermediate revisions by the same user not shown)
Line 14: Line 14:
 
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
|where="{{PAGENAME}}" IN(chara1,chara2,chara3,chara4,chara5) OR troupe="{{Character to Troupe|character={{PAGENAME}} }}"
+
|where=type="Regular" AND "{{PAGENAME}}" IN(chara1,chara2,chara3,chara4,chara5) OR troupe="{{Character to Troupe|character={{PAGENAME}} }}"
 
|format=table
 
|format=table
 
|order by=CASE WHEN attribute = "Co" THEN 0
 
|order by=CASE WHEN attribute = "Co" THEN 0

Latest revision as of 11:10, 21 January 2020