Template:CardInfobox: Difference between revisions
From LOTR-TCG Wiki
No edit summary Tag: Reverted |
No edit summary |
||
(21 intermediate revisions by the same user not shown) | |||
Line 6: | Line 6: | ||
| | | | ||
{{#tag:gallery|{{#cargo_query:tables=Cards=C,CardReleases=CR,Languages=L,Rarities=R | {{#tag:gallery|{{#cargo_query:tables=Cards=C,CardReleases=CR,Languages=L,Rarities=R | ||
|join on=C.ID = CR.BaseCardID,CR.LanguageCode=L.Code,C.Rarity = R.Abbr | |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.