Editing Template:CardInfobox

<noinclude>
{{#template_params:ID}}
</noinclude><includeonly>
{| class="wikitable card-infobox-container" style="float:right; width:370px; margin:0 0 0 50px"
|-
|
{{#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
|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
|template=GalleryQuery
|named args= yes
|delimiter=\n
|no html
}}|mode="slideshow"}}
|-
|style="padding:0px;"|<!--

-->{{#cargo_query:tables=Cards=C,CardReleases=CR,CardSets=CS,Rarities=R,Languages=L
|join on=C.ID = CR.ID,C.SetNum=CS.ID,R.Abbr=C.Rarity,CR.LanguageCode=L.Code
|fields= TRIM('Collection Info'),
TRIM('Title'), CR.Title, 
TRIM('Subtitle'), IFNULL(CR.Subtitle,' '),
TRIM('Unique'), IF(CR.IsUnique = 1, 'Yes', 'No'),
TRIM('Collectible'),  IF(IFNULL(CR.IsPhysical, C.IsPhysical) = 1, 'Yes', 'No'),
TRIM('Notes'), IFNULL(C.Notes,' '),
TRIM('[[Set]]'), CONCAT(CS.ID, ' - [[', CS.Name, ']]'),
TRIM('[[Rarity]]'), CONCAT(R.Abbr, ' - [[Rarity{{!}}', R.Name, ']]'),
TRIM('Card Number'), C.CardNum,
TRIM('[[Language]]'), CONCAT(L.Code, ' - [[Languages{{!}}', L.Name, ']]'),
TRIM('Revision'), C.Revision,
TRIM('Notes'), CONCAT(C.Notes, '<br>', CR.Notes) 
|where=C.ID='{{IDLookup|{{{1}}}}}' AND R.Sets HOLDS C.SetNum
|format=template
|template=CardSubInfoTable
|named args= no
|delimiter=\n
|no html
}}<!--

-->
|-
|style="padding:0px;"|<!--

-->{{#cargo_query:tables=Cards=C,CardReleases=CR,CardTypes=CT
|join on=C.ID = CR.ID,C.CardType = CT.Name
|fields= TRIM('Gameplay Info')=TableName,
IF(C.IsPlayable = 1, 'Yes', 'No')=Playable, 
C.CardType,
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,
CT.SubtypeClass, CR.Subtypes,
CR.TwilightCost,
IF(CR.Strength=0, NULL, CR.Strength)=Strength,
IF(CR.StrengthMod=0, NULL, CR.StrengthMod)=StrengthMod,
IF(CR.Vitality=0, NULL, CR.Vitality)=Vitality,
IF(CR.VitalityMod=0, NULL, CR.VitalityMod)=VitalityMod,
IF(CR.SiteNum=0, NULL, CR.SiteNum)=SiteNum,
IF(CR.SiteNumMod=0, NULL, CR.SiteNumMod)=SiteNumMod,
IF(CR.Resistance=0, NULL, CR.Resistance)=Resistance,
IF(CR.ResistanceMod=0, NULL, CR.ResistanceMod)=ResistanceMod,
IF(CR.Signet='None', NULL, CR.Signet)=Signet,
IF(CR.Block='None', NULL, CR.Block)=Block,
IF(CR.ShadowNum=0, NULL, CR.ShadowNum)=ShadowNum,
IF(C.CardType!='Site', NULL, IF(CR.SiteNum IN (3,6), 'Yes', 'No'))=IsSanctuary,
IF(CR.ArrowDir='None', NULL, CR.ArrowDir)=ArrowDir,
CR.FormattedGameText,
IF(CR.Lore IS NOT NULL, CONCAT('\'\'', CR.Lore, '\'\''), NULL)=Lore,
IF(CR.PromoText IS NOT NULL, CONCAT('\'\'\'', CR.PromoText, '\'\'\''), NULL)=PromoText
|where=C.ID='{{IDLookup|{{{1}}}}}'
|format=template
|template=CardInfoTable
|named args= yes
|delimiter=\n
|no html
}}<!--

-->
|-
|style="padding:0px;"|<!--

-->{{#cargo_query:tables=Cards=C,CardReleases=CR,Languages=L
|join on=C.ID = CR.BaseCardID,CR.LanguageCode=L.Code
|fields=CONCAT(L.Code, ' - ', L.Name)=LanguageName,
CR.Title,
CR.Subtitle,
CR.FormattedGameText,
IF(CR.Lore IS NOT NULL, CONCAT('\'\'', CR.Lore, '\'\''), NULL)=Lore,
IF(CR.PromoText IS NOT NULL, CONCAT('\'\'\'', CR.PromoText, '\'\'\''), NULL)=PromoText
CR.Notes,
CR._pageName = pn1,
C._pageName = pn2
|where=C.ID='{{IDLookup|{{{1}}}}}' 
AND L.Code NOT IN ('EN', 'TW')
AND (C.SetNum IN ('9', '14', '16', '19') OR CR.Subset IN ('S'))
|intro=<!--
-->{{{!}} class="wikitable mw-collapsible mw-collapsed" style="width:100%;margin:0"
{{!}}-
!colspan="2" {{!}}Translations
|format=template
|template=TranslationInfoboxTable
|named args= yes
|outro=<br>
{{!}}}
|default=
|delimiter=
|no html
}}<!--
-->
|-
|style="padding:0px;"|<!--

-->{{#cargo_query:tables=Cards=C,CardReleases=CR,CardSets=CS,Rarities=R,Languages=L
|join on=C.ID = CR.ID,C.SetNum=CS.ID,R.Abbr=C.Rarity,CR.LanguageCode=L.Code
|fields= TRIM('Technical Info'),
TRIM('Wiki Base Card ID'), C.ID, 
TRIM('TLHH ID'), C.TLHH_ImageNum,
TRIM('GEMP ID'), C.GEMP_ID,
TRIM('LOTRO Hex ID'), C.LOTRO_HexNum,
TRIM('LOTRO Image ID'), C.LOTRO_ImageNum
TRIM('mLOTRO ID'), C.mLOTRO_ID
|where=C.ID='{{IDLookup|{{{1}}}}}' AND R.Sets HOLDS C.SetNum
|format=template
|template=CollapsedCardSubInfoTable
|named args= no
|delimiter=\n
|no html
}}
|}
</includeonly>