Editing Template:CardInfobox

From LOTR-TCG Wiki
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.

The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then publish the changes below to finish undoing the edit.

Latest revision Your text
Line 3: Line 3:
</noinclude><includeonly>
</noinclude><includeonly>
{| class="wikitable card-infobox-container" style="float:right; width:370px; margin:0 0 0 50px"
{| class="wikitable card-infobox-container" style="float:right; width:370px; margin:0 0 0 50px"
|+ <big>Gimli, Son of Gloin</big>
|-
|-
|
|
{{#tag:gallery|{{#cargo_query:tables=Cards=C,CardReleases=CR,Languages=L,Rarities=R
{{#tag:gallery|{{#cargo_query:tables=Cards=C,CardReleases=CR
|join on=C.ID = CR.BaseCardID,CR.LanguageCode=L.Code,C.Rarity=R.Abbr
|join on=C.ID = CR.BaseCardID
|fields= IFNULL(CR.ImageFilename
|fields= CR.ImageFilename=Filename,CR.LanguageCode,CR.Subset=Style
,'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,{{StandardSort}},CR._rowID
|format=template
|format=template
|template=GalleryQuery
|template=GalleryQuery
Line 20: Line 15:
|delimiter=\n
|delimiter=\n
|no html
|no html
}}|mode="slideshow"}}
}}|mode="slideshow"|showthumbnails="true"}}
|-
|-
|style="padding:0px;"|<!--
|style="padding:0px;"|<!--
Line 28: Line 23:
|fields= TRIM('Collection Info'),
|fields= TRIM('Collection Info'),
TRIM('Title'), CR.Title,  
TRIM('Title'), CR.Title,  
TRIM('Subtitle'), IFNULL(CR.Subtitle,' '),
TRIM('Subtitle'), CR.Subtitle,
TRIM('Unique'), IF(CR.IsUnique = 1, 'Yes', 'No'),
TRIM('Collectible'), IF(C.IsPhysical = 1, 'Yes', 'No'),
TRIM('Collectible'), IF(IFNULL(CR.IsPhysical, C.IsPhysical) = 1, 'Yes', 'No'),
TRIM('Notes'), C.Notes,
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, ']]'),
TRIM('Card Number'), C.CardNum,
TRIM('Card Number'), C.CardNum,
TRIM('[[Language]]'), CONCAT(L.Code, ' - [[Languages{{!}}', L.Name, ']]'),
TRIM('Language'), CONCAT(L.Code, ' - [[Languages{{!}}', L.Name, ']]'),
TRIM('Revision'), C.Revision,
TRIM('Revision'), C.Revision,
TRIM('Notes'), CONCAT(C.Notes, '<br>', CR.Notes)  
TRIM('Notes'), CONCAT(C.Notes, '<br>', CR.Notes)  
Line 54: Line 48:
|fields= TRIM('Gameplay Info')=TableName,
|fields= TRIM('Gameplay Info')=TableName,
IF(C.IsPlayable = 1, 'Yes', 'No')=Playable,  
IF(C.IsPlayable = 1, 'Yes', 'No')=Playable,  
C.CardType,
CONCAT('[[Image:', 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,
CONCAT('[[', IF(C.Side='Freeps', 'Free Peoples', C.Side), ']]')=Side,
CT.SubtypeClass, CR.Subtypes,
CT.SubtypeClass, CR.Subtypes,
Line 70: Line 63:
IF(CR.Block='None', NULL, CR.Block)=Block,
IF(CR.Block='None', NULL, CR.Block)=Block,
IF(CR.ShadowNum=0, NULL, CR.ShadowNum)=ShadowNum,
IF(CR.ShadowNum=0, NULL, CR.ShadowNum)=ShadowNum,
IF(C.CardType!='Site', NULL, IF(CR.SiteNum IN (3,6), 'Yes', 'No'))=IsSanctuary,
IF(CR.IsSanctuary=0, NULL, IF(CR.Subtypes LIKE '%Sanctuary%', 'Yes', 'No'))=IsSanctuary,
IF(CR.ArrowDir='None', NULL, CR.ArrowDir)=ArrowDir,
IF(CR.ArrowDir='None', NULL, CR.ArrowDir)=ArrowDir,
CR.FormattedGameText,
CR.FormattedGameText,
Line 98: Line 91:
CR._pageName = pn1,
CR._pageName = pn1,
C._pageName = pn2
C._pageName = pn2
|where=C.ID='{{IDLookup|{{{1}}}}}'  
|where=C.ID='{{IDLookup|{{{1}}}}}' AND L.Code NOT IN ('EN', 'TW')
AND L.Code NOT IN ('EN', 'TW')
AND (C.SetNum IN ('9', '14', '16', '19') OR CR.Subset IN ('S'))
|intro=<!--
|intro=<!--
-->{{{!}} class="wikitable mw-collapsible mw-collapsed" style="width:100%;margin:0"
-->{{{!}} class="wikitable mw-collapsible mw-collapsed" style="width:100%;margin:0"
Line 108: Line 99:
|template=TranslationInfoboxTable
|template=TranslationInfoboxTable
|named args= yes
|named args= yes
|outro=<br>
|outro={{!}}}
{{!}}}
|default=
|delimiter=
|delimiter=
|no html
|no html
Line 123: Line 112:
TRIM('Wiki Base Card ID'), C.ID,  
TRIM('Wiki Base Card ID'), C.ID,  
TRIM('TLHH ID'), C.TLHH_ImageNum,
TRIM('TLHH ID'), C.TLHH_ImageNum,
TRIM('GEMP ID'), C.GEMP_ID,
TRIM('GEMP ID'), CONCAT(C.SetNum, '_', C.CardNum),
TRIM('LOTRO Hex ID'), C.LOTRO_HexNum,
TRIM('LOTRO Hex ID'), C.LOTRO_HexNum,
TRIM('LOTRO Image ID'), C.LOTRO_ImageNum,
TRIM('LOTRO Image ID'), C.LOTRO_ImageNum
TRIM('mLOTRO ID'), C.mLOTRO_ID
|where=C.ID='{{IDLookup|{{{1}}}}}' AND R.Sets HOLDS C.SetNum
|where=C.ID='{{IDLookup|{{{1}}}}}' AND R.Sets HOLDS C.SetNum
|format=template
|format=template
Please note that all contributions to the LOTR-TCG Wiki may be edited, altered, or removed by other contributors. Your writing is liable to be edited mercilessly, so be sure to back up any major claims with links if possible.

To edit this page, please answer the question that appears below (more info):

Cancel Editing help (opens in new window)
Retrieved from "https://wiki.lotrtcgpc.net/wiki/Template:CardInfobox"