Template:CardInfobox: Difference between revisions
From LOTR-TCG Wiki
No edit summary |
No edit summary |
||
(118 intermediate revisions by the same user not shown) | |||
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" | ||
|- | |- | ||
| | | | ||
{{#tag:gallery|{{#cargo_query:tables=Cards=C,CardReleases=CR | {{#tag:gallery|{{#cargo_query:tables=Cards=C,CardReleases=CR,Languages=L,Rarities=R | ||
|join on=C.ID = CR.BaseCardID | |join on=C.ID = CR.BaseCardID,CR.LanguageCode=L.Code,C.Rarity=R.Abbr | ||
|fields= | |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}}}}}' | |where=C.ID='{{IDLookup|{{{1}}}}}' | ||
| | |order by=L.SortOrder,{{StandardSort}},CR._rowID | ||
|format=template | |||
|template=GalleryQuery | |template=GalleryQuery | ||
|named args= yes | |named args= yes | ||
|delimiter=\n | |delimiter=\n | ||
|no html | |no html | ||
}}|mode="slideshow | }}|mode="slideshow"}} | ||
|- | |- | ||
|style="padding:0px;"| | |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;"| | |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;"| | |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;"|<!-- | |||
|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> | </includeonly> |
Latest revision as of 15:04, 1 July 2022
This is the "CardInfobox" template.
It should be called in the following format:
{{CardInfobox |ID= }}
Edit the page to see the template text.