Editing Ents of Fangorn/Thumbs
From LOTR-TCG Wiki
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 2: | Line 2: | ||
{{NavBar|Ents of Fangorn/Thumbs|[[Main Page]]|[[Battle of Helm's Deep/Thumbs|Battle of Helm's Deep]]|[[The Return of the King/Thumbs|The Return of the King]]}} | {{NavBar|Ents of Fangorn/Thumbs|[[Main Page]]|[[Battle of Helm's Deep/Thumbs|Battle of Helm's Deep]]|[[The Return of the King/Thumbs|The Return of the King]]}} | ||
{{SetTabs}} | {{SetTabs}} | ||
= Standard Cards = | = 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 = 6 AND C.Subset = 'S' AND C.CardNum <= 122 | |||
|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 | |||
}} | }} | ||
= Alternate Image Cards = | = Alternate Image 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 = 6 AND C.Subset = 'S' AND C.CardNum >= 123 | |||
|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 = | = 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 = 6 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 = | = 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 = 6 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 | |||
}} | }} |