List of International Cards - Revision history

Teltura: adding language subtotals

2022-04-15T07:04:53Z

adding language subtotals

Teltura: Text replacement - ", 'M'" to ""

2022-04-14T19:02:39Z

Text replacement - ", 'M'" to ""

← Older revision		Revision as of 19:02, 14 April 2022
Line 243:		Line 243:
	\|join on=C.ID = CR.BaseCardID		\|join on=C.ID = CR.BaseCardID
	\|fields=CR.ImageFilename		\|fields=CR.ImageFilename
	\|where= CR.Subset IN ('F', 'O', 'A', 'S~~', 'M~~') AND CR.LanguageCode IN ('EN', 'TG', 'DE', 'FR', 'IT', 'ES', 'PL', 'PT', 'ZH', 'EL', 'HU', 'NL', 'SV')		\|where= CR.Subset IN ('F', 'O', 'A', 'S') AND CR.LanguageCode IN ('EN', 'TG', 'DE', 'FR', 'IT', 'ES', 'PL', 'PT', 'ZH', 'EL', 'HU', 'NL', 'SV')
	\|named args= yes		\|named args= yes
	\|default=''No Cards Found		\|default=''No Cards Found
Line 254:		Line 254:
	\|join on=C.ID = CR.BaseCardID		\|join on=C.ID = CR.BaseCardID
	\|fields=COUNT(*)		\|fields=COUNT(*)
	\|where= CR.Subset IN ('F', 'O', 'A', 'S~~', 'M~~') AND CR.LanguageCode IN ('EN', 'TG', 'DE', 'FR', 'IT', 'ES', 'PL', 'PT', 'ZH', 'EL', 'HU', 'NL', 'SV')		\|where= CR.Subset IN ('F', 'O', 'A', 'S') AND CR.LanguageCode IN ('EN', 'TG', 'DE', 'FR', 'IT', 'ES', 'PL', 'PT', 'ZH', 'EL', 'HU', 'NL', 'SV')
	\|named args= yes		\|named args= yes
	\|default=''No Cards Found		\|default=''No Cards Found
Line 264:		Line 264:
	\|join on=C.ID = CR.BaseCardID		\|join on=C.ID = CR.BaseCardID
	\|fields=CR.ImageFilename		\|fields=CR.ImageFilename
	\|where= CR.Subset IN ('F', 'O', 'A', 'S~~', 'M~~') AND CR.LanguageCode IN ('EN', 'TG', 'DE', 'FR', 'IT', 'ES', 'PL', 'PT', 'ZH', 'EL', 'HU', 'NL', 'SV')		\|where= CR.Subset IN ('F', 'O', 'A', 'S') AND CR.LanguageCode IN ('EN', 'TG', 'DE', 'FR', 'IT', 'ES', 'PL', 'PT', 'ZH', 'EL', 'HU', 'NL', 'SV')
	\|named args= yes		\|named args= yes
	\|default=''No Cards Found		\|default=''No Cards Found
Line 275:		Line 275:
	\|join on=C.ID = CR.BaseCardID		\|join on=C.ID = CR.BaseCardID
	\|fields=COUNT(*)		\|fields=COUNT(*)
	\|where= CR.Subset IN ('F', 'O', 'A', 'S~~', 'M~~') AND CR.LanguageCode IN ('EN', 'TG', 'DE', 'FR', 'IT', 'ES', 'PL', 'PT', 'ZH', 'EL', 'HU', 'NL', 'SV')		\|where= CR.Subset IN ('F', 'O', 'A', 'S') AND CR.LanguageCode IN ('EN', 'TG', 'DE', 'FR', 'IT', 'ES', 'PL', 'PT', 'ZH', 'EL', 'HU', 'NL', 'SV')
	\|named args= yes		\|named args= yes
	\|default=''No Cards Found		\|default=''No Cards Found

Teltura: Removing stat breakdown pending its reintroduction on more bite-sized pages (to avoid timeouts)

2022-04-14T18:31:00Z

Removing stat breakdown pending its reintroduction on more bite-sized pages (to avoid timeouts)

Show changes

Teltura: Removing bad headings

2022-04-13T05:31:12Z

Removing bad headings

← Older revision		Revision as of 05:31, 13 April 2022
Line 45:		Line 45:
	* [[List of International Cards/DE/Black Rider/Foil]] ('''{{CardCountTotal\|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('DE', 'TG') AND C.SetNum = '12'}}''')		* [[List of International Cards/DE/Black Rider/Foil]] ('''{{CardCountTotal\|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('DE', 'TG') AND C.SetNum = '12'}}''')
	* [[List of International Cards/DE/Bloodlines/Foil]] ('''{{CardCountTotal\|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('DE', 'TG') AND C.SetNum = '13'}}''')		* [[List of International Cards/DE/Bloodlines/Foil]] ('''{{CardCountTotal\|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('DE', 'TG') AND C.SetNum = '13'}}''')
	* [[List of International Cards/DE/Expanded Middle-earth/Foil]] ('''{{CardCountTotal\|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('DE') AND C.SetNum = '14'}}''')~~=== Nonfoil ===~~		* [[List of International Cards/DE/Expanded Middle-earth/Foil]] ('''{{CardCountTotal\|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('DE') AND C.SetNum = '14'}}''')


Line 85:		Line 85:
	* [[List of International Cards/FR/Black Rider/Foil]] ('''{{CardCountTotal\|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('FR', 'TG') AND C.SetNum = '12'}}''')		* [[List of International Cards/FR/Black Rider/Foil]] ('''{{CardCountTotal\|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('FR', 'TG') AND C.SetNum = '12'}}''')
	* [[List of International Cards/FR/Bloodlines/Foil]] ('''{{CardCountTotal\|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('FR', 'TG') AND C.SetNum = '13'}}''')		* [[List of International Cards/FR/Bloodlines/Foil]] ('''{{CardCountTotal\|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('FR', 'TG') AND C.SetNum = '13'}}''')
	* [[List of International Cards/FR/Expanded Middle-earth/Foil]] ('''{{CardCountTotal\|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('FR') AND C.SetNum = '14'}}''')~~=== Nonfoil ===~~		* [[List of International Cards/FR/Expanded Middle-earth/Foil]] ('''{{CardCountTotal\|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('FR') AND C.SetNum = '14'}}''')


Line 125:		Line 125:
	* [[List of International Cards/IT/Black Rider/Foil]] ('''{{CardCountTotal\|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('IT', 'TG') AND C.SetNum = '12'}}''')		* [[List of International Cards/IT/Black Rider/Foil]] ('''{{CardCountTotal\|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('IT', 'TG') AND C.SetNum = '12'}}''')
	* [[List of International Cards/IT/Bloodlines/Foil]] ('''{{CardCountTotal\|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('IT', 'TG') AND C.SetNum = '13'}}''')		* [[List of International Cards/IT/Bloodlines/Foil]] ('''{{CardCountTotal\|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('IT', 'TG') AND C.SetNum = '13'}}''')
	* [[List of International Cards/IT/Expanded Middle-earth/Foil]] ('''{{CardCountTotal\|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('IT') AND C.SetNum = '14'}}''')~~=== Nonfoil ===~~		* [[List of International Cards/IT/Expanded Middle-earth/Foil]] ('''{{CardCountTotal\|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('IT') AND C.SetNum = '14'}}''')


Line 246:		Line 246:


	~~'''~~GRAND TOTAL~~''':~~ {{#lstcnt:{{#cargo_query:tables=Cards=C,CardReleases=CR		== GRAND TOTAL ==
			{{#lstcnt:{{#cargo_query:tables=Cards=C,CardReleases=CR
	\|join on=C.ID = CR.BaseCardID		\|join on=C.ID = CR.BaseCardID
	\|fields=CR.ImageFilename		\|fields=CR.ImageFilename

Teltura: adding actual international counts; this very well might blow up the damn page

2022-04-13T05:23:38Z

adding actual international counts; this very well might blow up the damn page

Show changes

Teltura: Created page with "MRW someone suggests creating a database of all international card images. The full list of international card images is..."

2022-04-13T05:21:35Z

Created page with "right|x500px|thumb|MRW someone suggests creating a database of all international card images. The full list of international card images is..."

New page

[[File:LOTR-DE03S049.0_card.jpg|right|x500px|thumb|MRW someone suggests creating a database of all international card images.]]

The full list of international card images is too large for a single page, so each set has its own page to display what does and doesn't exist on the wiki. These pages are split between foil and non-foil. Any card images which are missing will have the obvious "not found" placeholder.

Before submitting foil images, be sure to read up on the [[Foil Submission Guide]]. Non-foil cards can simply be scanned or whatever; so long as the text is clear enough to be transcribed by a non-speaker of the language, any non-foil image is fine.

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

'''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', 'S', 'M') AND CR.LanguageCode IN ('EN', 'TG', 'DE', 'FR', 'IT', 'ES', 'PL', 'PT', 'ZH', 'EL', 'HU', 'NL', 'SV')
|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', 'S', 'M') AND CR.LanguageCode IN ('EN', 'TG', 'DE', 'FR', 'IT', 'ES', 'PL', 'PT', 'ZH', 'EL', 'HU', 'NL', 'SV')
|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', 'S', 'M') AND CR.LanguageCode IN ('EN', 'TG', 'DE', 'FR', 'IT', 'ES', 'PL', 'PT', 'ZH', 'EL', 'HU', 'NL', 'SV')
|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', 'S', 'M') AND CR.LanguageCode IN ('EN', 'TG', 'DE', 'FR', 'IT', 'ES', 'PL', 'PT', 'ZH', 'EL', 'HU', 'NL', 'SV')
|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.

← Older revision		Revision as of 05:31, 13 April 2022
Line 45:		Line 45:
	* [[List of International Cards/DE/Black Rider/Foil]] ('''{{CardCountTotal\|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('DE', 'TG') AND C.SetNum = '12'}}''')		* [[List of International Cards/DE/Black Rider/Foil]] ('''{{CardCountTotal\|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('DE', 'TG') AND C.SetNum = '12'}}''')
	* [[List of International Cards/DE/Bloodlines/Foil]] ('''{{CardCountTotal\|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('DE', 'TG') AND C.SetNum = '13'}}''')		* [[List of International Cards/DE/Bloodlines/Foil]] ('''{{CardCountTotal\|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('DE', 'TG') AND C.SetNum = '13'}}''')
	* [[List of International Cards/DE/Expanded Middle-earth/Foil]] ('''{{CardCountTotal\|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('DE') AND C.SetNum = '14'}}''')~~=== Nonfoil ===~~		* [[List of International Cards/DE/Expanded Middle-earth/Foil]] ('''{{CardCountTotal\|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('DE') AND C.SetNum = '14'}}''')


Line 85:		Line 85:
	* [[List of International Cards/FR/Black Rider/Foil]] ('''{{CardCountTotal\|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('FR', 'TG') AND C.SetNum = '12'}}''')		* [[List of International Cards/FR/Black Rider/Foil]] ('''{{CardCountTotal\|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('FR', 'TG') AND C.SetNum = '12'}}''')
	* [[List of International Cards/FR/Bloodlines/Foil]] ('''{{CardCountTotal\|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('FR', 'TG') AND C.SetNum = '13'}}''')		* [[List of International Cards/FR/Bloodlines/Foil]] ('''{{CardCountTotal\|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('FR', 'TG') AND C.SetNum = '13'}}''')
	* [[List of International Cards/FR/Expanded Middle-earth/Foil]] ('''{{CardCountTotal\|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('FR') AND C.SetNum = '14'}}''')~~=== Nonfoil ===~~		* [[List of International Cards/FR/Expanded Middle-earth/Foil]] ('''{{CardCountTotal\|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('FR') AND C.SetNum = '14'}}''')


Line 125:		Line 125:
	* [[List of International Cards/IT/Black Rider/Foil]] ('''{{CardCountTotal\|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('IT', 'TG') AND C.SetNum = '12'}}''')		* [[List of International Cards/IT/Black Rider/Foil]] ('''{{CardCountTotal\|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('IT', 'TG') AND C.SetNum = '12'}}''')
	* [[List of International Cards/IT/Bloodlines/Foil]] ('''{{CardCountTotal\|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('IT', 'TG') AND C.SetNum = '13'}}''')		* [[List of International Cards/IT/Bloodlines/Foil]] ('''{{CardCountTotal\|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('IT', 'TG') AND C.SetNum = '13'}}''')
	* [[List of International Cards/IT/Expanded Middle-earth/Foil]] ('''{{CardCountTotal\|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('IT') AND C.SetNum = '14'}}''')~~=== Nonfoil ===~~		* [[List of International Cards/IT/Expanded Middle-earth/Foil]] ('''{{CardCountTotal\|filter=CR.Subset IN ('F', 'O', 'A') AND CR.LanguageCode IN ('IT') AND C.SetNum = '14'}}''')


Line 246:		Line 246:


	~~'''~~GRAND TOTAL~~''':~~ {{#lstcnt:{{#cargo_query:tables=Cards=C,CardReleases=CR		== GRAND TOTAL ==
			{{#lstcnt:{{#cargo_query:tables=Cards=C,CardReleases=CR
	\|join on=C.ID = CR.BaseCardID		\|join on=C.ID = CR.BaseCardID
	\|fields=CR.ImageFilename		\|fields=CR.ImageFilename