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;"|


-->{{#cargo_query:tables=Cards=C,CardReleases=CR,CardSets=CS,Rarities=R,Languages=L
{{#cargo_query:tables=Cards=C,CardReleases=CR,CardSets=CS,Rarities=R
|join on=C.ID = CR.ID,C.SetNum=CS.ID,R.Abbr=C.Rarity,CR.LanguageCode=L.Code
|join on=C.ID = CR.BaseCardID,CS.ID = C.SetNum,R.Abbr=C.Rarity
|fields= TRIM('Collection Info'),
|fields= TRIM('Title'), CR.Title,  
TRIM('Title'), CR.Title,  
TRIM('Subtitle'), CR.Subtitle,
TRIM('Subtitle'), IFNULL(CR.Subtitle,' '),
TRIM('Collectible'), C.IsPhysical,
TRIM('Unique'), IF(CR.IsUnique = 1, 'Yes', 'No'),
TRIM('Notes'), C.Notes,
TRIM('Collectible'),  IF(IFNULL(CR.IsPhysical, C.IsPhysical) = 1, 'Yes', 'No'),
TRIM('Set'), CONCAT(CS.ID, ' - [[', CS.Name, ']]'),
TRIM('Notes'), IFNULL(C.Notes,' '),
<!--'Rarity', CONCAT(R.Abbr, ' - [[Rarity{{!}}', 'R.Name]]'),-->
TRIM('[[Set]]'), CONCAT(CS.ID, ' - [[', CS.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('Revision'), C.Revision,
TRIM('Revision'), C.Revision,
TRIM('Notes'), CONCAT(C.Notes, '<br>', CR.Notes)
|where=C.ID='{{IDLookup|{{{1}}}}}'
|where=C.ID='{{IDLookup|{{{1}}}}}' AND R.Sets HOLDS C.SetNum
|format=template
|format=template
|template=CardSubInfoTable
|template=CardSubInfoTable
Line 44: Line 35:
|delimiter=\n
|delimiter=\n
|no html
|no html
}}<!--
}}
 
{| class="wikitable mw-collapsible" style="width:100%;margin:0"
|-
!colspan="2" class="mw-customtoggle-section1"|Collection Info
|-
|style="width:140px"| '''Title'''
| Gimli
|-
| '''Subtitle'''
| Son of Gloin
|-
| '''Set'''
| 1 - [[Fellowship of the Ring]]
|-
| '''Rarity'''
| R - [[Rarity|Rare]]
|-
| '''Card Number'''
| 13
|-
| '''Revisions'''
| 0 (never been errata'd)
|-
| '''Language'''
| EN - English
|-
| '''Collectible'''
| Yes
|-
| '''Notes'''
|
|}


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


-->{{#cargo_query:tables=Cards=C,CardReleases=CR,CardTypes=CT
{| class="wikitable mw-collapsible" style="width:100%;margin:0"
|join on=C.ID = CR.ID,C.CardType = CT.Name
|-
|fields= TRIM('Gameplay Info')=TableName,
!colspan="2" class="mw-customtoggle-section1"|Gameplay Info
IF(C.IsPlayable = 1, 'Yes', 'No')=Playable,
|-
C.CardType,
|style="width:140px"| '''Playable'''  
CONCAT('[[Image:Culture_', C.Culture, '.svg{{!}}x20px{{!}}text-bottom{{!}}link=', C.Culture, '_Culture{{!}}class=whitebg]] \'\'\'[[', C.Culture, '_Culture{{!}}', C.Culture, ']]\'\'\'')=Culture,
| Yes
CONCAT('[[', IF(C.Side='Freeps', 'Free Peoples', C.Side), ']]')=Side,
|-
CT.SubtypeClass, CR.Subtypes,
| '''Culture'''
CR.TwilightCost,
| {{C|Dwarven}}  
IF(CR.Strength=0, NULL, CR.Strength)=Strength,
|-
IF(CR.StrengthMod=0, NULL, CR.StrengthMod)=StrengthMod,
| '''Side'''  
IF(CR.Vitality=0, NULL, CR.Vitality)=Vitality,
| [[Free Peoples]]
IF(CR.VitalityMod=0, NULL, CR.VitalityMod)=VitalityMod,
|-
IF(CR.SiteNum=0, NULL, CR.SiteNum)=SiteNum,
| '''Race'''  
IF(CR.SiteNumMod=0, NULL, CR.SiteNumMod)=SiteNumMod,
| [[Dwarf]]
IF(CR.Resistance=0, NULL, CR.Resistance)=Resistance,
|-
IF(CR.ResistanceMod=0, NULL, CR.ResistanceMod)=ResistanceMod,
| '''Twilight Cost'''
IF(CR.Signet='None', NULL, CR.Signet)=Signet,
| 2
IF(CR.Block='None', NULL, CR.Block)=Block,
|-
IF(CR.ShadowNum=0, NULL, CR.ShadowNum)=ShadowNum,
| '''Strength'''  
IF(C.CardType!='Site', NULL, IF(CR.SiteNum IN (3,6), 'Yes', 'No'))=IsSanctuary,
| 6
IF(CR.ArrowDir='None', NULL, CR.ArrowDir)=ArrowDir,
|-
CR.FormattedGameText,
| '''Vitality'''  
IF(CR.Lore IS NOT NULL, CONCAT('\'\'', CR.Lore, '\'\''), NULL)=Lore,
| 3
IF(CR.PromoText IS NOT NULL, CONCAT('\'\'\'', CR.PromoText, '\'\'\''), NULL)=PromoText
|-
|where=C.ID='{{IDLookup|{{{1}}}}}'
| '''Signet'''
|format=template
| Gandalf
|template=CardInfoTable
|-
|named args= yes
| '''Game Text'''
|delimiter=\n
| '''Damage +1'''.  
|no html
'''Skirmish''': Exert Gimli to make him strength +2.  
}}<!--
|-
| '''Lore'''
| ''“There was a younger dwarf at Glóin's side: his son Gimli.”''
|}
 
|-
|style="padding:0px;"|
 
{| class="wikitable mw-collapsible mw-collapsed" style="width:100%;margin:0"
|-
!colspan="2" class="mw-customtoggle-section1"|Translations
|-
!style="width:140px"| '''Language'''  
! FR - French
|-
| '''Name'''  
| Gimli, Fil de Gloin
|-
| '''Game Text'''  
| '''Dégâts +1'''.
'''Combat:''' Affaiblissez Gimli pour lui donner +2 en force.
|-
| '''Lore'''  
| “À côté de Glóin se trouvait un jeune Nain: son fils Gimli.”
|-
| '''Notes'''
|  
|}


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


-->{{#cargo_query:tables=Cards=C,CardReleases=CR,Languages=L
{| class="wikitable mw-collapsible mw-collapsed" style="width:100%;margin:0"
|join on=C.ID = CR.BaseCardID,CR.LanguageCode=L.Code
|-
|fields=CONCAT(L.Code, ' - ', L.Name)=LanguageName,
!colspan="3" class="mw-customtoggle-section1"|Technical Info
CR.Title,
|-
CR.Subtitle,
|style="width:140px"| '''Wiki Base Card ID'''
CR.FormattedGameText,
| LOTR-EN01S013.0
IF(CR.Lore IS NOT NULL, CONCAT('\'\'', CR.Lore, '\'\''), NULL)=Lore,
|-
IF(CR.PromoText IS NOT NULL, CONCAT('\'\'\'', CR.PromoText, '\'\'\''), NULL)=PromoText
| '''TLHH ID'''
CR.Notes,
| TLHH_ImageNum
CR._pageName = pn1,
|-
C._pageName = pn2
| '''Gemp ID'''
|where=C.ID='{{IDLookup|{{{1}}}}}'
| GEMP_ID
AND L.Code NOT IN ('EN', 'TW')
|-
AND (C.SetNum IN ('9', '14', '16', '19') OR CR.Subset IN ('S'))
| '''LOTRO Hex ID'''
|intro=<!--
| LOTRO_HexNum
-->{{{!}} 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;"|<!--
| '''LOTRO Image ID'''
| LOTRO_ImageNum
|}


-->{{#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>
</includeonly>
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"