Template:CardInfobox: Difference between revisions
From LOTR-TCG Wiki
(reverting messed up edits) Tag: Manual revert |
(Fixing sites showing "none" as a linked side) |
||
| (18 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 | ||
|fields= IFNULL(CR.ImageFilename, 'Card_Not_Found.jpg')=Filename,CR.LanguageCode,CR.Subset=Style | |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}}}}}' | |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 24: | 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 50: | 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.
