Template:CardInfobox: Difference between revisions

From LOTR-TCG Wiki
No edit summary
Tag: Reverted
No edit summary
 
(19 intermediate revisions by the same user not shown)
Line 5: Line 5:
|-
|-
|
|
{{#tag:gallery|{{#cargo_query:tables=Cards=C,CardReleases=CR,Languages=L
{{#tag:gallery|{{#cargo_query:tables=Cards=C,CardReleases=CR,Languages=L,Rarities=R
|join on=C.ID = CR.BaseCardID,CR.LanguageCode=L.Code
|join on=C.ID = CR.BaseCardID,CR.LanguageCode=L.Code,C.Rarity=R.Abbr
|order by=L.SortOrder,{{StandardSort}}
|fields= IFNULL(CR.ImageFilename
,'Card_Not_Found.jpg')=Filename
,CR.LanguageCode
,CR.Subset=Style
,R.Name=Rarity
,CR.Revision=Revision
|where=C.ID='{{IDLookup|{{{1}}}}}'
|order by=L.SortOrder,{{StandardSort}},CR._rowID
|format=template
|format=template
|template=GalleryQuery
|template=GalleryQuery
Line 22: 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, ']]'),

Latest revision as of 15:04, 1 July 2022

This is the "CardInfobox" template.

It should be called in the following format:

{{CardInfobox
|ID=
}}

Edit the page to see the template text.