List of Foil Cards: Difference between revisions

From LOTR-TCG Wiki
(Created page with "Here is a list of every foil card (in English), or a placeholder if the card is missing. __TOC__ == Promotional == {{#cargo_query:tables=Cards=C,CardReleases=CR,Languages=L...")
 
(baking in the counts so that the page doesn't take a half hour to load just to tell us it's 100% complete.)
 
(23 intermediate revisions by the same user not shown)
Line 1: Line 1:
Here is a list of every foil card (in English), or a placeholder if the card is missing.
[[File:LOTR-EN03F049.0_card.jpg|right|x500px|thumb|MRW someone suggests creating a database of all foil images.]]


__TOC__
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.


== Promotional ==
Before submitting images, be sure to read up on the [[Foil Submission Guide]].
{{#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
}}


== The Fellowship of the Ring ==
These pages will be loading hundreds of images apiece, so be warned if your bandwidth is low.
{{#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
}}


== Mines of Moria ==
* [[List of Foil Cards/Promotional]] ('''''83 / 83''''')
{{#cargo_query:tables=Cards=C,CardReleases=CR,Languages=L
* [[List of Foil Cards/The Fellowship of the Ring]] ('''''365 / 365''''')
|join on=C.ID = CR.BaseCardID,CR.LanguageCode=L.Code
* [[List of Foil Cards/Mines of Moria]] ('''''122 / 122''''')
|fields= CR.ImageFilename=ImageFile
* [[List of Foil Cards/Realms of the Elf-lords]] ('''''122 / 122''''')
,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
* [[List of Foil Cards/The Two Towers]] ('''''365 / 365''''')
|where=L.Code='EN' AND CR.Subset = 'F' AND C.SetNum = '2'
* [[List of Foil Cards/Battle of Helm's Deep]] ('''''128 / 128''''')
|order by=C.SetNum, C.CardNum, CR.Revision
* [[List of Foil Cards/Ents of Fangorn]] ('''''128 / 128''''')
|named args= yes
* [[List of Foil Cards/The Return of the King]] ('''''365 / 365''''')
|format=template
* [[List of Foil Cards/Siege of Gondor]] ('''''122 / 122''''')
|template=CardListRow
* [[List of Foil Cards/Reflections]] ('''''52 / 52''''')
|limit=400
* [[List of Foil Cards/Mount Doom]] ('''''122 / 122''''')
}}
* [[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''''')


== Realms of the Elf-lords ==
'''GRAND TOTAL''': 2191 / 2,191
{{#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
}}


== The Two Towers ==
<big>100% COMPLETE</big>
{{#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
}}


== Ents of Fangorn ==
== Uploading Cards ==
{{#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
}}


== The Return of the King ==
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:
{{#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
}}


== Siege of Gondor ==
# Register an account on the wiki; uploads will not work anonymously the way edits can.
{{#cargo_query:tables=Cards=C,CardReleases=CR,Languages=L
# Click on the link to the set for your card above
|join on=C.ID = CR.BaseCardID,CR.LanguageCode=L.Code
# 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)
|fields= CR.ImageFilename=ImageFile
# 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).
,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
# 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.
|where=L.Code='EN' AND CR.Subset = 'F' AND C.SetNum = '8'
# Click the "Upload File" button, and you're done!
|order by=C.SetNum, C.CardNum, CR.Revision
|named args= yes
|format=template
|template=CardListRow
|limit=400
}}


== Reflections ==
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.
{{#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
}}

Latest revision as of 05:03, 15 September 2022

MRW someone suggests creating a database of all foil images.

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.

Before submitting images, be sure to read up on the Foil Submission Guide.

These pages will be loading hundreds of images apiece, so be warned if your bandwidth is low.

GRAND TOTAL: 2191 / 2,191

100% COMPLETE


Uploading Cards[edit]

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:

  1. Register an account on the wiki; uploads will not work anonymously the way edits can.
  2. Click on the link to the set for your card above
  3. 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)
  4. 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).
  5. 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.
  6. Click the "Upload File" button, and you're done!

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.

Retrieved from "https://wiki.lotrtcgpc.net/index.php?title=List_of_Foil_Cards&oldid=111939"