Template:CardInfobox: Difference between revisions
From LOTR-TCG Wiki
No edit summary |
No edit summary |
||
| Line 47: | Line 47: | ||
|join on=C.ID = CR.ID,C.CardType = CT.Name | |join on=C.ID = CR.ID,C.CardType = CT.Name | ||
|fields= TRIM('Gameplay Info'), | |fields= TRIM('Gameplay Info'), | ||
TRIM('Playable'), C.IsPlayable , | TRIM('Playable'), IF(C.IsPlayable = 1, 'Yes', 'No') , | ||
TRIM('Culture'), CONCAT('[[Image:', C.Culture, '.svg{{!}}x20px{{!}}text-bottom{{!}}link=', C.Culture, '_Culture{{!}}class=whitebg]] \'\'\'[[', C.Culture, '_Culture{{!}}', C.Culture, ']]\'\'\''), | TRIM('Culture'), CONCAT('[[Image:', C.Culture, '.svg{{!}}x20px{{!}}text-bottom{{!}}link=', C.Culture, '_Culture{{!}}class=whitebg]] \'\'\'[[', C.Culture, '_Culture{{!}}', C.Culture, ']]\'\'\''), | ||
TRIM('Side'), CONCAT('[[', C.Side, ']]'), | TRIM('Side'), CONCAT('[[', C.Side, ']]'), | ||
CT.SubtypeClass, CR.Subtypes, | CT.SubtypeClass, CR.Subtypes, | ||
TRIM('Twilight Cost'), CR.TwilightCost, | TRIM('Twilight Cost'), CR.TwilightCost, | ||
TRIM('Strength'), CR.Strength, | TRIM('Strength'), IF(CR.Strength=0, NULL, CR.Strength), | ||
TRIM('Strength'), IF(CR.StrengthMod=0, NULL, CR.StrengthMod), | TRIM('Strength'), IF(CR.StrengthMod=0, NULL, CR.StrengthMod), | ||
TRIM('Vitality'), CR.Vitality, | TRIM('Vitality'), IF(CR.Vitality=0, NULL, CR.Vitality), | ||
TRIM('Vitality'), CR.VitalityMod, | TRIM('Vitality'), IF(CR.VitalityMod=0, NULL, CR.VitalityMod), | ||
TRIM('Home Site'), CR.SiteNum, | TRIM('Home Site'), IF(CR.SiteNum=0, NULL, CR.SiteNum), | ||
TRIM('Site Number'), CR.SiteNumMod, | TRIM('Site Number'), IF(CR.SiteNumMod=0, NULL, CR.SiteNumMod), | ||
TRIM('Resistance'), CR.Resistance, | TRIM('Resistance'), IF(CR.Resistance=0, NULL, CR.Resistance), | ||
TRIM('Resistance'), CR.ResistanceMod, | TRIM('Resistance'), IF(CR.ResistanceMod=0, NULL, CR.ResistanceMod), | ||
TRIM('Signet'), CR.Signet, | TRIM('Signet'), IF(CR.Signet=0, NULL, CR.Signet), | ||
TRIM('Block'), CR.Block, | TRIM('Block'), IF(CR.Block=0, NULL, CR.Block), | ||
TRIM('Shadow Number'), CR.ShadowNum, | TRIM('Shadow Number'), IF(CR.ShadowNum=0, NULL, CR.ShadowNum), | ||
TRIM('Sanctuary'), CR.IsSanctuary, | TRIM('Sanctuary'), IF(CR.IsSanctuary=0, NULL, IF(C.IsSanctuary = 1, 'Yes', 'No')), | ||
TRIM('Arrow Direction'), CR.ArrowDir, | TRIM('Arrow Direction'), IF(CR.ArrowDir=0, NULL, CR.ArrowDir), | ||
TRIM('Game Text'), CR.FormattedGameText, | TRIM('Game Text'), IF(CR.FormattedGameText=0, NULL, CR.FormattedGameText), | ||
TRIM('Lore'), CONCAT('\'\'', CR.Lore, '\'\'') | TRIM('Lore'), IF(CR.Block=0, NULL, CR.Block),CONCAT('\'\'', CR.Lore, '\'\'') | ||
|where=C.ID='{{IDLookup|{{{1}}}}}' | |where=C.ID='{{IDLookup|{{{1}}}}}' | ||
|format=template | |format=template | ||
Revision as of 00:36, 4 October 2021
This is the "CardInfobox" template.
It should be called in the following format:
{{CardInfobox
|ID=
}}
Edit the page to see the template text.
