Teltura at 16:53, 15 October 2021

2021-10-15T16:53:53Z

@@ Line 9: / Line 9: @@
 {{#cargo_query:tables=Cards=C,CardReleases=CR
 |join on=C.ID = CR.ID
-|fields=CR.ID=CardID
+|fields=
-,IFNULL(IFNULL(CR.FormattedGameText, CR.GameText),'')=GameText
+CONCAT('[[File:', IFNULL(CR.PortraitFilename,'File:Portrait_Not_Found.jpg'), '|center|link=', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''), ']]')=Portrait
-,C.Subset
-,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
+,CONCAT('<span class="tooltip">[[',  REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''),  '|',  CR.Title,  CASE WHEN CR.Subtitle IS NULL THEN '' ELSE CONCAT(', ', CR.Subtitle) END, ' (', IFNULL(CR.CollInfo,C.CollInfo), ')]]<span>[[File:', IFNULL(CR.ImageFilename,'Card_Not_Found.jpg'), ']]</span></span>')=CardName
-= Oversized Cards =
+,CONCAT('[[Image:Culture_', C.Culture, '.svg|x20px|text-bottom|link=', C.Culture, '_Culture|class=whitebg]] ''''''[[', C.Culture, '_Culture|', C.Culture, ']]''''''')=Culture
 ,C.CardType
-= Tengwar Anthology =
+,IFNULL(IFNULL(CR.FormattedGameText, CR.GameText),'')=GameText
 |where= C.SetNum = 1
 |order by=C.Subset DESC, CR.ID, C.SetOrder, C.CardNum, CR._rowID
 |limit=400
-|intro=<!--
+|format=dynamic table
--->{{{!}} class="wikitable" style="margin:2px"
+|hidden fields=Subset
 |named args= yes
 |default=
 |delimiter=
 }}

Teltura: Created page with "NOTOC {{NavBar|Fellowship of the Ring Index| Main Page|Promotional Index|Mines of Moria Index}} {{SetTabs}} Here you will find every card in the Fellowship..."

2021-10-15T15:51:31Z

Created page with "__NOTOC__ {{NavBar|Fellowship of the Ring Index| Main Page|Promotional Index|Mines of Moria Index}} {{SetTabs}} Here you will find every card in the Fellowship..."

New page

__NOTOC__
{{NavBar|Fellowship of the Ring Index| [[Main Page]]|[[Promotional Index]]|[[Mines of Moria Index]]}}
{{SetTabs}}

Here you will find every card in the [[Fellowship of the Ring]] set. Please see that page for additional information.

= Standard Cards =

{{#cargo_query:tables=Cards=C,CardReleases=CR
|join on=C.ID = CR.ID
|fields=CR.ID=CardID
,IFNULL(IFNULL(CR.FormattedGameText, CR.GameText),'')=GameText
,C.Subset
,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
,IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile
,IFNULL(CR.PortraitFilename,'File:Portrait_Not_Found.jpg')=PortraitFile
,C.Culture
,C.CardType
,CR.Subtypes=CardSubtype
,CR.Title=Title
,CR.Subtitle=Subtitle
,CR.SiteNum
,IFNULL(CR.CollInfo,C.CollInfo)=CollInfo
|where= C.SetNum = 1 AND C.Subset = 'S'
|order by=C.Subset DESC, CR.ID, C.SetOrder, C.CardNum, CR._rowID
|limit=400
|intro={{{!}} class="wikitable" style="margin:2px"
! Portrait !! Card Name !! Culture !! Card Type !! Game Text
|format=template
|template=CardReadoutRow
|named args= yes
|outro=
{{!}}}
|default=
|delimiter=
|no html
}}

= Oversized Cards =

{{#cargo_query:tables=Cards=C,CardReleases=CR
|join on=C.ID = CR.ID
|fields=CR.ID=CardID
,IFNULL(IFNULL(CR.FormattedGameText, CR.GameText),'')=GameText
,C.Subset
,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
,IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile
,IFNULL(CR.PortraitFilename,'File:Portrait_Not_Found.jpg')=PortraitFile
,C.Culture
,C.CardType
,CR.Subtypes=CardSubtype
,CR.Title=Title
,CR.Subtitle=Subtitle
,CR.SiteNum
,IFNULL(CR.CollInfo,C.CollInfo)=CollInfo
|where= C.SetNum = 1 AND C.Subset = 'M'
|order by=C.Subset DESC, CR.ID, C.SetOrder, C.CardNum, CR._rowID
|limit=400
|intro={{{!}} class="wikitable" style="margin:2px"
! Portrait !! Card Name !! Culture !! Card Type !! Game Text
|format=template
|template=CardReadoutRow
|named args= yes
|outro=
{{!}}}
|default=
|delimiter=
|no html
}}

= Tengwar Anthology =

{{#cargo_query:tables=Cards=C,CardReleases=CR,CardReleases=ECR
|join on=C.ID = CR.BaseCardID,C.ID = ECR.ID
|fields=CR.ID=CardID
,IFNULL(IFNULL(ECR.FormattedGameText, ECR.GameText),'')=GameText
,C.Subset
,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
,IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile
,IFNULL(CR.PortraitFilename,'File:Portrait_Not_Found.jpg')=PortraitFile
,C.Culture
,C.CardType
,''=CardSubtype
,ECR.Title=Title
,ECR.Subtitle=Subtitle
,ECR.SiteNum
,IFNULL(CR.CollInfo,C.CollInfo)=CollInfo
|where= C.SetNum = 1 AND CR.LanguageCode = 'TW'
|order by=C.Subset DESC, CR.ID, C.SetOrder, C.CardNum, CR._rowID
|limit=400
|intro={{{!}} class="wikitable" style="margin:2px"
! Portrait !! Card Name !! Culture !! Card Type !! Game Text
|format=template
|template=CardReadoutRow
|named args= yes
|outro=
{{!}}}
|default=
|delimiter=
|no html
}}

User:Teltura/index - Revision history

Teltura at 16:53, 15 October 2021

Teltura: Created page with "__NOTOC__ {{NavBar|Fellowship of the Ring Index| Main Page|Promotional Index|Mines of Moria Index}} {{SetTabs}} Here you will find every card in the Fellowship..."

Teltura: Created page with "NOTOC {{NavBar|Fellowship of the Ring Index| Main Page|Promotional Index|Mines of Moria Index}} {{SetTabs}} Here you will find every card in the Fellowship..."