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
| | {{#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=slideshow |
| |format=template | | }} |
| |template=GalleryQuery
| |
| |named args= yes
| |
| |delimiter=\n
| |
| |no html
| |
| }}|mode="slideshow"}}
| |
| |- | | |- |
| |style="padding:0px;"|<!-- | | |style="padding:0px;"| |
|
| |
|
| -->{{#cargo_query:tables=Cards=C,CardReleases=CR,CardSets=CS,Rarities=R,Languages=L
| | {| class="wikitable mw-collapsible" style="width:100%;margin:0" |
| |join on=C.ID = CR.ID,C.SetNum=CS.ID,R.Abbr=C.Rarity,CR.LanguageCode=L.Code | | |- |
| |fields= TRIM('Collection Info'), | | !colspan="3" class="mw-customtoggle-section1"|Collection Info |
| TRIM('Title'), CR.Title,
| | |- |
| TRIM('Subtitle'), IFNULL(CR.Subtitle,' '),
| | |style="width:140px"| '''Title''' |
| TRIM('Unique'), IF(CR.IsUnique = 1, 'Yes', 'No'),
| | |colspan="2" | Gimli |
| TRIM('Collectible'), IF(IFNULL(CR.IsPhysical, C.IsPhysical) = 1, 'Yes', 'No'),
| | |- |
| TRIM('Notes'), IFNULL(C.Notes,' '),
| | | '''Subtitle''' |
| TRIM('[[Set]]'), CONCAT(CS.ID, ' - [[', CS.Name, ']]'),
| | |colspan="2"| Son of Gloin |
| TRIM('[[Rarity]]'), CONCAT(R.Abbr, ' - [[Rarity{{!}}', R.Name, ']]'),
| | |- |
| TRIM('Card Number'), C.CardNum,
| | | '''Set''' |
| TRIM('[[Language]]'), CONCAT(L.Code, ' - [[Languages{{!}}', L.Name, ']]'),
| | |colspan="2"| 1 - [[Fellowship of the Ring]] |
| TRIM('Revision'), C.Revision,
| | |- |
| TRIM('Notes'), CONCAT(C.Notes, '<br>', CR.Notes)
| | | '''Rarity''' |
| |where=C.ID='{{IDLookup|{{{1}}}}}' AND R.Sets HOLDS C.SetNum | | |colspan="2"| R - [[Rarity|Rare]] |
| |format=template | | |- |
| |template=CardSubInfoTable | | | '''Card Number''' |
| |named args= no | | |colspan="2"| 13 |
| |delimiter=\n | | |- |
| |no html | | | '''Revisions''' |
| }}<!-- | | |colspan="2"| 0 (never been errata'd) |
| | |- |
| | | '''Language''' |
| | |colspan="2"| EN - English |
| | |- |
| | | '''Collectible''' |
| | |colspan="2"| Yes |
| | |- |
| | | '''Notes''' |
| | |colspan="2"| |
| | |} |
| | |
| | |- |
| | |style="padding:0px;"| |
| | |
| | {| class="wikitable mw-collapsible" style="width:100%;margin:0" |
| | |- |
| | !colspan="3" class="mw-customtoggle-section1"|Gameplay Info |
| | |- |
| | |style="width:140px"| '''Playable''' |
| | |colspan="2" | Yes |
| | |- |
| | | '''Culture''' |
| | |colspan="2"| {{C|Dwarven}} |
| | |- |
| | | '''Side''' |
| | |colspan="2"| [[Free Peoples]] |
| | |- |
| | | '''Race''' |
| | |colspan="2"| [[Dwarf]] |
| | |- |
| | | '''Twilight Cost''' |
| | |colspan="2"| 2 |
| | |- |
| | | '''Strength''' |
| | |colspan="2"| 6 |
| | |- |
| | | '''Vitality''' |
| | |colspan="2"| 3 |
| | |- |
| | | '''Signet''' |
| | |colspan="2"| Gandalf |
| | |- |
| | | '''Game Text''' |
| | |colspan="2"| '''Damage +1'''. |
| | '''Skirmish''': Exert Gimli to make him strength +2. |
| | |- |
| | | '''Lore''' |
| | |colspan="2"| ''“There was a younger dwarf at Glóin's side: his son Gimli.”'' |
| | |} |
|
| |
|
| -->
| |
| |- | | |- |
| |style="padding:0px;"|<!-- | | |style="padding:0px;"| |
|
| |
|
| -->{{#cargo_query:tables=Cards=C,CardReleases=CR,CardTypes=CT
| | {| class="wikitable mw-collapsible mw-collapsed" style="width:100%;margin:0" |
| |join on=C.ID = CR.ID,C.CardType = CT.Name | | |- |
| |fields= TRIM('Gameplay Info')=TableName, | | !colspan="3" class="mw-customtoggle-section1"|Translations |
| IF(C.IsPlayable = 1, 'Yes', 'No')=Playable,
| | |- |
| C.CardType,
| | !style="width:140px"| '''Language''' |
| CONCAT('[[Image:Culture_', C.Culture, '.svg{{!}}x20px{{!}}text-bottom{{!}}link=', C.Culture, '_Culture{{!}}class=whitebg]] \'\'\'[[', C.Culture, '_Culture{{!}}', C.Culture, ']]\'\'\'')=Culture,
| | !colspan="2" | FR - French |
| CONCAT('[[', IF(C.Side='Freeps', 'Free Peoples', C.Side), ']]')=Side,
| | |- |
| CT.SubtypeClass, CR.Subtypes,
| | | '''Name''' |
| CR.TwilightCost,
| | |colspan="2"| Gimli, Fil de Gloin |
| IF(CR.Strength=0, NULL, CR.Strength)=Strength,
| | |- |
| IF(CR.StrengthMod=0, NULL, CR.StrengthMod)=StrengthMod,
| | | '''Game Text''' |
| IF(CR.Vitality=0, NULL, CR.Vitality)=Vitality,
| | |colspan="2"| '''Dégâts +1'''. |
| IF(CR.VitalityMod=0, NULL, CR.VitalityMod)=VitalityMod,
| | '''Combat:''' Affaiblissez Gimli pour lui donner +2 en force. |
| IF(CR.SiteNum=0, NULL, CR.SiteNum)=SiteNum,
| | |- |
| IF(CR.SiteNumMod=0, NULL, CR.SiteNumMod)=SiteNumMod,
| | | '''Lore''' |
| IF(CR.Resistance=0, NULL, CR.Resistance)=Resistance,
| | |colspan="2"| “À côté de Glóin se trouvait un jeune Nain: son fils Gimli.” |
| IF(CR.ResistanceMod=0, NULL, CR.ResistanceMod)=ResistanceMod,
| | |- |
| IF(CR.Signet='None', NULL, CR.Signet)=Signet,
| | | '''Notes''' |
| IF(CR.Block='None', NULL, CR.Block)=Block,
| | |colspan="2"| |
| 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;"|<!-- | | |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,
| |
| 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;"|<!-- | | !colspan="3" class="mw-customtoggle-section1"|Technical Info |
| | |- |
| | |style="width:140px"| '''Wiki Base Card ID''' |
| | |colspan="2" | LOTR-EN01S013.0 |
| | |- |
| | | '''TLHH ID''' |
| | |colspan="2"| TLHH_ImageNum |
| | |- |
| | | '''Gemp ID''' |
| | |colspan="2"| GEMP_ID |
| | |- |
| | | '''LOTRO Hex ID''' |
| | |colspan="2"| LOTRO_HexNum |
| | |- |
| | | '''LOTRO Image ID''' |
| | |colspan="2"| 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> |