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

From A3! Wiki
m
(Trying to change so chara page doesn't show EN link skills)
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="{{PAGENAME}}" IN(chara1,chara2,chara3,chara4,chara5) OR troupe="{{Character to Troupe|character={{PAGENAME}} }} AND type="Regular" OR "Event""
 
|format=table
 
|format=table
 
|order by=CASE WHEN attribute = "Co" THEN 0
 
|order by=CASE WHEN attribute = "Co" THEN 0

Revision as of 11:06, 21 January 2020