Template:CardInfobox: Difference between revisions

From LOTR-TCG Wiki
No edit summary
Tags: Manual revert Reverted
(Fixing sites showing "none" as a linked side)
 
(12 intermediate revisions by the same user not shown)
Line 12: Line 12:
,CR.Subset=Style
,CR.Subset=Style
,R.Name=Rarity
,R.Name=Rarity
,CR.Revision=Revision
|where=C.ID='{{IDLookup|{{{1}}}}}'
|where=C.ID='{{IDLookup|{{{1}}}}}'
|order by=L.SortOrder,CR._rowID
|order by=L.SortOrder,{{StandardSort}},CR._rowID
|format=template
|format=template
|template=GalleryQuery
|template=GalleryQuery
Line 28: Line 29:
TRIM('Title'), CR.Title,  
TRIM('Title'), CR.Title,  
TRIM('Subtitle'), IFNULL(CR.Subtitle,' '),
TRIM('Subtitle'), IFNULL(CR.Subtitle,' '),
TRIM('Collectible'), IF(C.IsPhysical = 1, 'Yes', 'No'),
TRIM('Unique'), IF(CR.IsUnique = 1, 'Yes', 'No'),
TRIM('Notes'), C.Notes,
TRIM('Collectible'), IF(IFNULL(CR.IsPhysical, C.IsPhysical) = 1, 'Yes', 'No'),
TRIM('Notes'), IFNULL(C.Notes,' '),
TRIM('[[Set]]'), CONCAT(CS.ID, ' - [[', CS.Name, ']]'),
TRIM('[[Set]]'), CONCAT(CS.ID, ' - [[', CS.Name, ']]'),
TRIM('[[Rarity]]'), CONCAT(R.Abbr, ' - [[Rarity{{!}}', R.Name, ']]'),
TRIM('[[Rarity]]'), CONCAT(R.Abbr, ' - [[Rarity{{!}}', R.Name, ']]'),
Line 54: Line 56:
C.CardType,
C.CardType,
CONCAT('[[Image:Culture_', C.Culture, '.svg{{!}}x20px{{!}}text-bottom{{!}}link=', C.Culture, '_Culture{{!}}class=whitebg]] \'\'\'[[', C.Culture, '_Culture{{!}}', C.Culture, ']]\'\'\'')=Culture,
CONCAT('[[Image:Culture_', C.Culture, '.svg{{!}}x20px{{!}}text-bottom{{!}}link=', C.Culture, '_Culture{{!}}class=whitebg]] \'\'\'[[', C.Culture, '_Culture{{!}}', C.Culture, ']]\'\'\'')=Culture,
CONCAT('[[', IF(C.Side='Freeps', 'Free Peoples', C.Side), ']]')=Side,
IF(C.Side='None', C.Side, CONCAT('[[', IF(C.Side='Freeps', 'Free Peoples', C.Side), ']]'))=Side,
CT.SubtypeClass, CR.Subtypes,
CT.SubtypeClass, CR.Subtypes,
CR.TwilightCost,
CR.TwilightCost,

Latest revision as of 03:22, 28 June 2024

This is the "CardInfobox" template.

It should be called in the following format:

{{CardInfobox
|ID=
}}

Edit the page to see the template text.