Template:CardInfobox: Difference between revisions

From LOTR-TCG Wiki
No edit summary
No edit summary
Line 46: Line 46:
-->{{#cargo_query:tables=Cards=C,CardReleases=CR,CardTypes=CT
-->{{#cargo_query:tables=Cards=C,CardReleases=CR,CardTypes=CT
|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')=TableName,
TRIM('Playable'), IF(C.IsPlayable = 1, 'Yes', 'No') ,  
IF(C.IsPlayable = 1, 'Yes', 'No')=Playable,  
TRIM('Culture'), CONCAT('[[Image:', C.Culture, '.svg{{!}}x20px{{!}}text-bottom{{!}}link=', C.Culture, '_Culture{{!}}class=whitebg]] \'\'\'[[', C.Culture, '_Culture{{!}}', C.Culture, ']]\'\'\''),
CONCAT('[[Image:', C.Culture, '.svg{{!}}x20px{{!}}text-bottom{{!}}link=', C.Culture, '_Culture{{!}}class=whitebg]] \'\'\'[[', C.Culture, '_Culture{{!}}', C.Culture, ']]\'\'\'')=Culture,
TRIM('Side'), CONCAT('[[', C.Side, ']]'),
CONCAT('[[', C.Side, ']]')=Side,
CT.SubtypeClass, CR.Subtypes,
CT.SubtypeClass, CR.Subtypes,
TRIM('Twilight Cost'), CR.TwilightCost,
CR.TwilightCost,
TRIM('Strength'), IF(CR.Strength=0, NULL, CR.Strength),
IF(CR.Strength=0, NULL, CR.Strength)=Strength,
TRIM('Strength'), IF(CR.StrengthMod=0, NULL, CR.StrengthMod),
IF(CR.StrengthMod=0, NULL, CR.StrengthMod)=StrengthMod,
TRIM('Vitality'), IF(CR.Vitality=0, NULL, CR.Vitality),
IF(CR.Vitality=0, NULL, CR.Vitality)=Vitality,
TRIM('Vitality'), IF(CR.VitalityMod=0, NULL, CR.VitalityMod),
IF(CR.VitalityMod=0, NULL, CR.VitalityMod)=VitalityMod,
TRIM('Home Site'), IF(CR.SiteNum=0, NULL, CR.SiteNum),
IF(CR.SiteNum=0, NULL, CR.SiteNum)=SiteNum,
TRIM('Site Number'), IF(CR.SiteNumMod=0, NULL, CR.SiteNumMod),
IF(CR.SiteNumMod=0, NULL, CR.SiteNumMod)=SiteNumMod,
TRIM('Resistance'), IF(CR.Resistance=0, NULL, CR.Resistance),
IF(CR.Resistance=0, NULL, CR.Resistance)=Resistance,
TRIM('Resistance'), IF(CR.ResistanceMod=0, NULL, CR.ResistanceMod),
IF(CR.ResistanceMod=0, NULL, CR.ResistanceMod)=ResistanceMod,
TRIM('Signet'), IF(CR.Signet='None', NULL, CR.Signet),
IF(CR.Signet='None', NULL, CR.Signet)=Signet,
TRIM('Block'), IF(CR.Block='None', NULL, CR.Block),
IF(CR.Block='None', NULL, CR.Block)=Block,
TRIM('Shadow Number'), IF(CR.ShadowNum=0, NULL, CR.ShadowNum),
IF(CR.ShadowNum=0, NULL, CR.ShadowNum)=ShadowNum,
TRIM('Sanctuary'), IF(CR.IsSanctuary=0, NULL, IF(CR.IsSanctuary = 1, 'Yes', 'No')),
IF(CR.IsSanctuary=0, NULL, IF(CR.IsSanctuary = 1, 'Yes', 'No'))=IsSanctuary,
TRIM('Arrow Direction'), IF(CR.ArrowDir='None', NULL, CR.ArrowDir),
IF(CR.ArrowDir='None', NULL, CR.ArrowDir)=ArrowDir,
TRIM('Game Text'), IF(CR.FormattedGameText=0, NULL, CR.FormattedGameText),
IF(CR.FormattedGameText=0, NULL, CR.FormattedGameText)=FormattedGameText,
TRIM('Lore'), IF(CR.Block=0, NULL, CR.Block),CONCAT('\'\'', CR.Lore, '\'\'')
IF(CR.Lore IS NULL, CONCAT('\'\'', CR.Lore, '\'\''), NULL)=Lore
|where=C.ID='{{IDLookup|{{{1}}}}}'
|where=C.ID='{{IDLookup|{{{1}}}}}'
|format=template
|format=template
|template=CardSubInfoTable
|template=CardInfoTable
|named args= no
|named args= yes
|delimiter=\n
|delimiter=\n
|no html
|no html

Revision as of 04:10, 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.