Editing List of Foil Cards

[[File:LOTR-EN03F049.0_card.jpg|right|x500px|thumb|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.

* [[List of Foil Cards/Promotional]] ('''''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('EN', 'TW') AND C.SetNum = '0'}}''''')
* [[List of Foil Cards/The Fellowship of the Ring]] ('''''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('EN', 'TW') AND C.SetNum = '1'}}''''')
* [[List of Foil Cards/Mines of Moria]] ('''''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('EN', 'TW') AND C.SetNum = '2'}}''''')
* [[List of Foil Cards/Realms of the Elf-lords]] ('''''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('EN', 'TW') AND C.SetNum = '3'}}''''')
* [[List of Foil Cards/The Two Towers]] ('''''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('EN', 'TW') AND C.SetNum = '4'}}''''')
* [[List of Foil Cards/Battle of Helm's Deep]] ('''''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('EN', 'TW') AND C.SetNum = '5'}}''''')
* [[List of Foil Cards/Ents of Fangorn]] ('''''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('EN', 'TW') AND C.SetNum = '6'}}''''')
* [[List of Foil Cards/The Return of the King]] ('''''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('EN', 'TW') AND C.SetNum = '7'}}''''' )
* [[List of Foil Cards/Siege of Gondor]] ('''''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('EN', 'TW') AND C.SetNum = '8'}}''''' )
* [[List of Foil Cards/Reflections]] ('''''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('EN', 'TW') AND C.SetNum = '9'}}''''')
* [[List of Foil Cards/Mount Doom]] ('''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('EN', 'TW') AND C.SetNum = '10'}}''')
* [[List of Foil Cards/Shadows]] ('''''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('EN', 'TW', 'TG') AND C.SetNum = '11'}}''''')
* [[List of Foil Cards/Black Rider]] ('''''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('EN', 'TW', 'TG') AND C.SetNum = '12'}}''''')
* [[List of Foil Cards/Bloodlines]] ('''''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('EN', 'TW', 'TG') AND C.SetNum = '13'}}''''')
* [[List of Foil Cards/Expanded Middle-earth]] ('''''0 / 0''''')
* [[List of Foil Cards/The Hunters]] ('''''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('EN', 'TW') AND C.SetNum = '15'}}''''')
* [[List of Foil Cards/The Wraith Collection]] ('''''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('EN', 'TW') AND C.SetNum = '16'}}''''')
* [[List of Foil Cards/Rise of Saruman]] ('''''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('EN', 'TW') AND C.SetNum = '17'}}''''')
* [[List of Foil Cards/Treachery & Deceit]] ('''''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('EN', 'TW') AND C.SetNum = '18'}}''''')
* [[List of Foil Cards/Age's End]] ('''''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('EN', 'TW') AND C.SetNum = '19'}}''''')

'''GRAND TOTAL''': {{#lstcnt:{{#cargo_query:tables=Cards=C,CardReleases=CR
|join on=C.ID = CR.BaseCardID
|fields=CR.ImageFilename 
|where= CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('EN', 'TW')
|named args= yes
|default=''No Cards Found
|delimiter=
|no html
|format=template
|template=ImageExistCount
|limit=3000
}}|,}} / {{#cargo_query:tables=Cards=C,CardReleases=CR
|join on=C.ID = CR.BaseCardID
|fields=COUNT(*)
|where= CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('EN', 'TW')
|named args= yes
|default=''No Cards Found
|delimiter=
|no html
}} 

<big>{{#number_format: {{#expr: {{#lstcnt:{{#cargo_query:tables=Cards=C,CardReleases=CR
|join on=C.ID = CR.BaseCardID
|fields=CR.ImageFilename 
|where= CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('EN', 'TW', 'TG')
|named args= yes
|default=''No Cards Found
|delimiter=
|no html
|format=template
|template=ImageExistCount
|limit=3000
}}|,}} / {{formatnum:{{#cargo_query:tables=Cards=C,CardReleases=CR
|join on=C.ID = CR.BaseCardID
|fields=COUNT(*)
|where= CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('EN', 'TW', 'TG')
|named args= yes
|default=''No Cards Found
|delimiter=
|no html
}} * 100 |R
}} | 0 }} }}% COMPLETE</big>


== Uploading Cards ==

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:

# Register an account on the wiki; uploads will not work anonymously the way edits can.
# Click on the link to the set for your card above
# 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)
# 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).
# 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.  
# 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.