| Latest revision |
Your text |
| Line 1: |
Line 1: |
| <noinclude> | | <noinclude> |
| {{#template_params:ID}} | | {{#template_params:CollInfo (label=Collector's Info)|ID}} |
| </noinclude><includeonly> | | </noinclude><includeonly> |
| {| class="wikitable card-infobox-container" style="float:right; width:370px; margin:0 0 0 50px"
| | {{#if:{{{CollInfo|}}}|{{CardInfoBox_ID|ID={{#cargo_query:tables=Cards|fields=ID|where=Cards.CollInfo='{{{CollInfo}}}'}}}}|{{CardInfoBox_ID|ID={{{ID}}}}}}}</includeonly> |
| |-
| |
| |
| |
| {{#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> | |
