Editing List of Foil Cards
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 1: | Line 1: | ||
[[File:LOTR-EN03F049.0_card.jpg|right|x500px|thumb | [[File:LOTR-EN03F049.0_card.jpg|right|x500px|thumb]] | ||
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. | 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. | ||
Line 7: | Line 7: | ||
These pages will be loading hundreds of images apiece, so be warned if your bandwidth is low. | These pages will be loading hundreds of images apiece, so be warned if your bandwidth is low. | ||
* [[List of Foil Cards/Promotional]] (''''' | * [[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]] (''''' | * [[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]] (''''' | * [[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]] (''''' | * [[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]] (''''' | * [[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]] (''''' | * [[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]] (''''' | * [[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]] (''''' | * [[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]] (''''' | * [[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]] (''''' | * [[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]] (''''' | * [[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]] (''''' | * [[List of Foil Cards/Shadows]] ('''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('EN', 'TW') AND C.SetNum = '11'}}''') | ||
* [[List of Foil Cards/Black Rider]] (''''' | * [[List of Foil Cards/Black Rider]] ('''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('EN', 'TW') AND C.SetNum = '12'}}''') | ||
* [[List of Foil Cards/Bloodlines]] (''''' | * [[List of Foil Cards/Bloodlines]] ('''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('EN', 'TW') AND C.SetNum = '13'}}''') | ||
* [[List of Foil Cards/Expanded Middle-earth]] (''''' | * [[List of Foil Cards/Expanded Middle-earth]] ('''{{CardCountTotal|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('EN', 'TW') AND C.SetNum = '14'}}''') | ||
* [[List of Foil Cards/The Hunters]] (''''' | * [[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]] (''''' | * [[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]] (''''' | * [[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]] (''''' | * [[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]] (''''' | * [[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''': | '''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 | |||
}} | |||
== Uploading Cards == | == Uploading Cards == | ||
When using the pages above, navigate to the placeholder for the card you wish to use and click on it. It will take you to the Upload File page with the appropriate filename already prefilled for you; all you need to do is drag'n'drop your image onto the "Browse" button (or click it and navigate to your image) and then fill in the image description (perhaps with "uploaded by [your name]" or something similar). | |||