Editing List of Foil Cards

From LOTR-TCG Wiki
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.

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 1: Line 1:
[[File:LOTR-EN03F049.0_card.jpg|right|x500px|thumb|MRW someone suggests creating a database of all foil images.]]
Here is a list of every foil card (in English), or a placeholder if the card is missing.


The full list of foils is too large for a single page, so each set has its own page to display what does and doesn't exist foil-wise.  These pages only show English foils, as (with few exceptions), they can later be reconstituted from the English foils, if the images are sufficiently high quality.  Any foil images which are missing will have the obvious "not found" placeholder.
__TOC__


Before submitting images, be sure to read up on the [[Foil Submission Guide]].
== Promotional ==
{{#cargo_query:tables=Cards=C,CardReleases=CR,Languages=L
|join on=C.ID = CR.BaseCardID,CR.LanguageCode=L.Code
|fields= CR.ImageFilename=ImageFile
,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
|where=L.Code='EN' AND CR.Subset = 'F' AND C.SetNum = '0'
|order by=C.SetNum, C.CardNum, CR.Revision
|named args= yes
|format=template
|template=CardListRow
|limit=400
}}


These pages will be loading hundreds of images apiece, so be warned if your bandwidth is low.
== The Fellowship of the Ring ==
{{#cargo_query:tables=Cards=C,CardReleases=CR,Languages=L
|join on=C.ID = CR.BaseCardID,CR.LanguageCode=L.Code
|fields= CR.ImageFilename=ImageFile
,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
|where=L.Code='EN' AND CR.Subset = 'F' AND C.SetNum = '1'
|order by=C.SetNum, C.CardNum, CR.Revision
|named args= yes
|format=template
|template=CardListRow
|limit=400
}}


* [[List of Foil Cards/Promotional]] ('''''83 / 83''''')
== Mines of Moria ==
* [[List of Foil Cards/The Fellowship of the Ring]] ('''''365 / 365''''')
{{#cargo_query:tables=Cards=C,CardReleases=CR,Languages=L
* [[List of Foil Cards/Mines of Moria]] ('''''122 / 122''''')
|join on=C.ID = CR.BaseCardID,CR.LanguageCode=L.Code
* [[List of Foil Cards/Realms of the Elf-lords]] ('''''122 / 122''''')
|fields= CR.ImageFilename=ImageFile
* [[List of Foil Cards/The Two Towers]] ('''''365 / 365''''')
,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
* [[List of Foil Cards/Battle of Helm's Deep]] ('''''128 / 128''''')
|where=L.Code='EN' AND CR.Subset = 'F' AND C.SetNum = '2'
* [[List of Foil Cards/Ents of Fangorn]] ('''''128 / 128''''')
|order by=C.SetNum, C.CardNum, CR.Revision
* [[List of Foil Cards/The Return of the King]] ('''''365 / 365''''')
|named args= yes
* [[List of Foil Cards/Siege of Gondor]] ('''''122 / 122''''')
|format=template
* [[List of Foil Cards/Reflections]] ('''''52 / 52''''')
|template=CardListRow
* [[List of Foil Cards/Mount Doom]] ('''''122 / 122''''')
|limit=400
* [[List of Foil Cards/Shadows]] ('''''30 / 30''''')
}}
* [[List of Foil Cards/Black Rider]] ('''''39 / 39''''')
* [[List of Foil Cards/Bloodlines]] ('''''39 / 39''''')
* [[List of Foil Cards/Expanded Middle-earth]] ('''''0 / 0''''')
* [[List of Foil Cards/The Hunters]] ('''''27 / 27''''')
* [[List of Foil Cards/The Wraith Collection]] ('''''6 / 6''''')
* [[List of Foil Cards/Rise of Saruman]] ('''''27 / 27''''')
* [[List of Foil Cards/Treachery & Deceit]] ('''''27 / 27''''')
* [[List of Foil Cards/Age's End]] ('''''40 / 40''''')


'''GRAND TOTAL''':  2191 / 2,191
== Realms of the Elf-lords ==
{{#cargo_query:tables=Cards=C,CardReleases=CR,Languages=L
|join on=C.ID = CR.BaseCardID,CR.LanguageCode=L.Code
|fields= CR.ImageFilename=ImageFile
,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
|where=L.Code='EN' AND CR.Subset = 'F' AND C.SetNum = '3'
|order by=C.SetNum, C.CardNum, CR.Revision
|named args= yes
|format=template
|template=CardListRow
|limit=400
}}


<big>100% COMPLETE</big>
== The Two Towers ==
{{#cargo_query:tables=Cards=C,CardReleases=CR,Languages=L
|join on=C.ID = CR.BaseCardID,CR.LanguageCode=L.Code
|fields= CR.ImageFilename=ImageFile
,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
|where=L.Code='EN' AND CR.Subset = 'F' AND C.SetNum = '4'
|order by=C.SetNum, C.CardNum, CR.Revision
|named args= yes
|format=template
|template=CardListRow
|limit=400
}}


== Battle of Helm's Deep ==
{{#cargo_query:tables=Cards=C,CardReleases=CR,Languages=L
|join on=C.ID = CR.BaseCardID,CR.LanguageCode=L.Code
|fields= CR.ImageFilename=ImageFile
,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
|where=L.Code='EN' AND CR.Subset = 'F' AND C.SetNum = '5'
|order by=C.SetNum, C.CardNum, CR.Revision
|named args= yes
|format=template
|template=CardListRow
|limit=400
}}


== Uploading Cards ==
== Ents of Fangorn ==
{{#cargo_query:tables=Cards=C,CardReleases=CR,Languages=L
|join on=C.ID = CR.BaseCardID,CR.LanguageCode=L.Code
|fields= CR.ImageFilename=ImageFile
,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
|where=L.Code='EN' AND CR.Subset = 'F' AND C.SetNum = '6'
|order by=C.SetNum, C.CardNum, CR.Revision
|named args= yes
|format=template
|template=CardListRow
|limit=400
}}


If you are uploading cards for the first time, don't be nervous!  The process is straightforward (and undoing mistakes is easy on a wiki ;P). Follow the following steps:
== The Return of the King ==
{{#cargo_query:tables=Cards=C,CardReleases=CR,Languages=L
|join on=C.ID = CR.BaseCardID,CR.LanguageCode=L.Code
|fields= CR.ImageFilename=ImageFile
,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
|where=L.Code='EN' AND CR.Subset = 'F' AND C.SetNum = '7'
|order by=C.SetNum, C.CardNum, CR.Revision
|named args= yes
|format=template
|template=CardListRow
|limit=400
}}


# Register an account on the wiki; uploads will not work anonymously the way edits can.
== Siege of Gondor ==
# Click on the link to the set for your card above
{{#cargo_query:tables=Cards=C,CardReleases=CR,Languages=L
# Find the card you want to upload (either by scrolling or using ctrl + F; you can search for both card title or collector's info as you wish)
|join on=C.ID = CR.BaseCardID,CR.LanguageCode=L.Code
# Click on the card image (it may be a placeholder, or it may be an existing image if you are replacing one of a poorer quality).
|fields= CR.ImageFilename=ImageFile
# Alter the "Summary" box to include your name (copy-paste is your friend here), and then either click on the "Browse" button and navigate to your card image, or click-drag the image from your file explorer onto the button itself.
,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
# Click the "Upload File" button, and you're done!
|where=L.Code='EN' AND CR.Subset = 'F' AND C.SetNum = '8'
|order by=C.SetNum, C.CardNum, CR.Revision
|named args= yes
|format=template
|template=CardListRow
|limit=400
}}


New accounts will have their edits and uploads placed into a moderation queue as a spam-prevention measure, but this restriction will be lifted as soon as the wiki admins note your successful upload.
== Reflections ==
{{#cargo_query:tables=Cards=C,CardReleases=CR,Languages=L
|join on=C.ID = CR.BaseCardID,CR.LanguageCode=L.Code
|fields= CR.ImageFilename=ImageFile
,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
|where=L.Code='EN' AND CR.Subset = 'F' AND C.SetNum = '9'
|order by=C.SetNum, C.CardNum, CR.Revision
|named args= yes
|format=template
|template=CardListRow
|limit=400
}}
 
== Mount Doom ==
{{#cargo_query:tables=Cards=C,CardReleases=CR,Languages=L
|join on=C.ID = CR.BaseCardID,CR.LanguageCode=L.Code
|fields= CR.ImageFilename=ImageFile
,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
|where=L.Code='EN' AND CR.Subset = 'F' AND C.SetNum = '10'
|order by=C.SetNum, C.CardNum, CR.Revision
|named args= yes
|format=template
|template=CardListRow
|limit=400
}}
 
== Shadows ==
{{#cargo_query:tables=Cards=C,CardReleases=CR,Languages=L
|join on=C.ID = CR.BaseCardID,CR.LanguageCode=L.Code
|fields= CR.ImageFilename=ImageFile
,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
|where=L.Code='EN' AND CR.Subset = 'F' AND C.SetNum = '11'
|order by=C.SetNum, C.CardNum, CR.Revision
|named args= yes
|format=template
|template=CardListRow
|limit=400
}}
 
== Black Rider ==
{{#cargo_query:tables=Cards=C,CardReleases=CR,Languages=L
|join on=C.ID = CR.BaseCardID,CR.LanguageCode=L.Code
|fields= CR.ImageFilename=ImageFile
,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
|where=L.Code='EN' AND CR.Subset = 'F' AND C.SetNum = '12'
|order by=C.SetNum, C.CardNum, CR.Revision
|named args= yes
|format=template
|template=CardListRow
|limit=400
}}
 
== Bloodlines ==
{{#cargo_query:tables=Cards=C,CardReleases=CR,Languages=L
|join on=C.ID = CR.BaseCardID,CR.LanguageCode=L.Code
|fields= CR.ImageFilename=ImageFile
,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
|where=L.Code='EN' AND CR.Subset = 'F' AND C.SetNum = '13'
|order by=C.SetNum, C.CardNum, CR.Revision
|named args= yes
|format=template
|template=CardListRow
|limit=400
}}
 
== Expanded Middle-earth ==
{{#cargo_query:tables=Cards=C,CardReleases=CR,Languages=L
|join on=C.ID = CR.BaseCardID,CR.LanguageCode=L.Code
|fields= CR.ImageFilename=ImageFile
,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
|where=L.Code='EN' AND CR.Subset = 'F' AND C.SetNum = '14'
|order by=C.SetNum, C.CardNum, CR.Revision
|named args= yes
|format=template
|template=CardListRow
|limit=400
}}
 
== The Hunters ==
{{#cargo_query:tables=Cards=C,CardReleases=CR,Languages=L
|join on=C.ID = CR.BaseCardID,CR.LanguageCode=L.Code
|fields= CR.ImageFilename=ImageFile
,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
|where=L.Code='EN' AND CR.Subset = 'F' AND C.SetNum = '15'
|order by=C.SetNum, C.CardNum, CR.Revision
|named args= yes
|format=template
|template=CardListRow
|limit=400
}}
 
== The Wraith Collection ==
{{#cargo_query:tables=Cards=C,CardReleases=CR,Languages=L
|join on=C.ID = CR.BaseCardID,CR.LanguageCode=L.Code
|fields= CR.ImageFilename=ImageFile
,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
|where=L.Code='EN' AND CR.Subset = 'F' AND C.SetNum = '16'
|order by=C.SetNum, C.CardNum, CR.Revision
|named args= yes
|format=template
|template=CardListRow
|limit=400
}}
 
== Rise of Saruman ==
{{#cargo_query:tables=Cards=C,CardReleases=CR,Languages=L
|join on=C.ID = CR.BaseCardID,CR.LanguageCode=L.Code
|fields= CR.ImageFilename=ImageFile
,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
|where=L.Code='EN' AND CR.Subset = 'F' AND C.SetNum = '17'
|order by=C.SetNum, C.CardNum, CR.Revision
|named args= yes
|format=template
|template=CardListRow
|limit=400
}}
 
== Treachery & Deceit ==
{{#cargo_query:tables=Cards=C,CardReleases=CR,Languages=L
|join on=C.ID = CR.BaseCardID,CR.LanguageCode=L.Code
|fields= CR.ImageFilename=ImageFile
,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
|where=L.Code='EN' AND CR.Subset = 'F' AND C.SetNum = '18'
|order by=C.SetNum, C.CardNum, CR.Revision
|named args= yes
|format=template
|template=CardListRow
|limit=400
}}
 
== Age's End ==
{{#cargo_query:tables=Cards=C,CardReleases=CR,Languages=L
|join on=C.ID = CR.BaseCardID,CR.LanguageCode=L.Code
|fields= CR.ImageFilename=ImageFile
,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
|where=L.Code='EN' AND CR.Subset = 'F' AND C.SetNum = '19'
|order by=C.SetNum, C.CardNum, CR.Revision
|named args= yes
|format=template
|template=CardListRow
|limit=400
}}
Please note that all contributions to the LOTR-TCG Wiki may be edited, altered, or removed by other contributors. Your writing is liable to be edited mercilessly, so be sure to back up any major claims with links if possible.

To edit this page, please answer the question that appears below (more info):

Cancel Editing help (opens in new window)
Retrieved from "https://wiki.lotrtcgpc.net/wiki/List_of_Foil_Cards"