Template:SplashCard - Revision history

Teltura at 05:16, 6 July 2024

2024-07-06T05:16:54Z

← Older revision		Revision as of 05:16, 6 July 2024
Line 19:		Line 19:
	, CONCAT('{{#replace:{{#replace:{{{2}}}\|'\|''}}\|.\|․}}','')=Caption		, CONCAT('{{#replace:{{#replace:{{{2}}}\|'\|''}}\|.\|․}}','')=Caption
	\|where= CR.ID = '{{IDLookup\|{{{1}}}\|{{{Lang\|EN}}}}}'		\|where= CR.ID = '{{IDLookup\|{{{1}}}\|{{{Lang\|EN}}}}}'
			\|order by=CASE WHEN C.Subtitle IS NULL THEN 1 ELSE 0 END DESC, C.Title, C.Subtitle
	\|format=template		\|format=template
	\|named args=yes		\|named args=yes
Line 31:		Line 32:
	, '{{{Size\|500}}}px'=ImageWidth		, '{{{Size\|500}}}px'=ImageWidth
	, CONCAT('{{#replace:{{#replace:{{{2}}}\|'\|''}}\|.\|․}}','')=Caption		, CONCAT('{{#replace:{{#replace:{{{2}}}\|'\|''}}\|.\|․}}','')=Caption
	\|where= (C.Title LIKE '{{#replace:{{{1}}}\|'\|''}}' OR C.Subtitle LIKE '{{#replace:{{{1}}}\|'\|''}}' OR (C.Title LIKE '{{#explode:{{#replace:{{{1}}}\|'\|''}}\|, \|0}}' AND C.Subtitle LIKE TRIM('{{#explode:{{#replace:{{{1}}}\|'\|''}}\|, \|1}}'))) AND CR.LanguageCode = '{{{Lang\|EN}}}'		\|where= (
	\|order by=CASE WHEN C.SetNum = '0' THEN 100 ELSE CASE WHEN C.SETNUM REGEXP '^-?[0-9]+$' THEN CAST(C.SetNum AS UNSIGNED INTEGER) ELSE 100 END END, CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'P' THEN 0 WHEN C.Subset = 'D' THEN 1 ELSE 10 END, C.CardNum		C.Title LIKE '{{#replace:{{{1}}}\|'\|''}}'
			OR C.Subtitle LIKE '{{#replace:{{{1}}}\|'\|''}}'
			OR (
			C.Title LIKE '{{#explode:{{#replace:{{{1}}}\|'\|''}}\|, \|0}}'
			AND C.Subtitle LIKE TRIM('{{#explode:{{#replace:{{{1}}}\|'\|''}}\|, \|1}}')
			)
			)
			AND CR.LanguageCode = '{{{Lang\|EN}}}'
			\|order by=CASE WHEN C.Subtitle IS NULL THEN 1 ELSE 0 END DESC, CASE WHEN C.SetNum = '0' THEN 100 ELSE CASE WHEN C.SETNUM REGEXP '^-?[0-9]+$' THEN CAST(C.SetNum AS UNSIGNED INTEGER) ELSE 100 END END, CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'P' THEN 0 WHEN C.Subset = 'D' THEN 1 ELSE 10 END, C.CardNum
	\|limit=1		\|limit=1
	\|more results text=		\|more results text=

Teltura at 02:01, 6 July 2024

2024-07-06T02:01:35Z

← Older revision		Revision as of 02:01, 6 July 2024
Line 17:		Line 17:
	, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile		, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile
	, '{{{Size\|500}}}px'=ImageWidth		, '{{{Size\|500}}}px'=ImageWidth
	, '{{#replace:{{#replace:{{{2}}}\|'\|''}}\|.\|․}}'=Caption		, CONCAT('{{#replace:{{#replace:{{{2}}}\|'\|''}}\|.\|․}}','')=Caption
	\|where= CR.ID = '{{IDLookup\|{{{1}}}\|{{{Lang\|EN}}}}}'		\|where= CR.ID = '{{IDLookup\|{{{1}}}\|{{{Lang\|EN}}}}}'
	\|format=template		\|format=template

Teltura at 02:01, 6 July 2024

2024-07-06T02:01:14Z

← Older revision		Revision as of 02:01, 6 July 2024
Line 30:		Line 30:
	, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile		, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile
	, '{{{Size\|500}}}px'=ImageWidth		, '{{{Size\|500}}}px'=ImageWidth
	, '{{{2}}}'=Caption		, CONCAT('{{#replace:{{#replace:{{{2}}}\|'\|''}}\|.\|․}}','')=Caption
	\|where= (C.Title LIKE '{{#replace:{{{1}}}\|'\|''}}' OR C.Subtitle LIKE '{{#replace:{{{1}}}\|'\|''}}' OR (C.Title LIKE '{{#explode:{{#replace:{{{1}}}\|'\|''}}\|, \|0}}' AND C.Subtitle LIKE TRIM('{{#explode:{{#replace:{{{1}}}\|'\|''}}\|, \|1}}'))) AND CR.LanguageCode = '{{{Lang\|EN}}}'		\|where= (C.Title LIKE '{{#replace:{{{1}}}\|'\|''}}' OR C.Subtitle LIKE '{{#replace:{{{1}}}\|'\|''}}' OR (C.Title LIKE '{{#explode:{{#replace:{{{1}}}\|'\|''}}\|, \|0}}' AND C.Subtitle LIKE TRIM('{{#explode:{{#replace:{{{1}}}\|'\|''}}\|, \|1}}'))) AND CR.LanguageCode = '{{{Lang\|EN}}}'
	\|order by=CASE WHEN C.SetNum = '0' THEN 100 ELSE CASE WHEN C.SETNUM REGEXP '^-?[0-9]+$' THEN CAST(C.SetNum AS UNSIGNED INTEGER) ELSE 100 END END, CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'P' THEN 0 WHEN C.Subset = 'D' THEN 1 ELSE 10 END, C.CardNum		\|order by=CASE WHEN C.SetNum = '0' THEN 100 ELSE CASE WHEN C.SETNUM REGEXP '^-?[0-9]+$' THEN CAST(C.SetNum AS UNSIGNED INTEGER) ELSE 100 END END, CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'P' THEN 0 WHEN C.Subset = 'D' THEN 1 ELSE 10 END, C.CardNum

Teltura at 02:00, 6 July 2024

2024-07-06T02:00:03Z

← Older revision		Revision as of 02:00, 6 July 2024
Line 30:		Line 30:
	, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile		, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile
	, '{{{Size\|500}}}px'=ImageWidth		, '{{{Size\|500}}}px'=ImageWidth
	, '~~{{#replace:~~{{{2}~~}}\|'\|''~~}}'=Caption		, '{{{2}}}'=Caption
	\|where= (C.Title LIKE '{{#replace:{{{1}}}\|'\|''}}' OR C.Subtitle LIKE '{{#replace:{{{1}}}\|'\|''}}' OR (C.Title LIKE '{{#explode:{{#replace:{{{1}}}\|'\|''}}\|, \|0}}' AND C.Subtitle LIKE TRIM('{{#explode:{{#replace:{{{1}}}\|'\|''}}\|, \|1}}'))) AND CR.LanguageCode = '{{{Lang\|EN}}}'		\|where= (C.Title LIKE '{{#replace:{{{1}}}\|'\|''}}' OR C.Subtitle LIKE '{{#replace:{{{1}}}\|'\|''}}' OR (C.Title LIKE '{{#explode:{{#replace:{{{1}}}\|'\|''}}\|, \|0}}' AND C.Subtitle LIKE TRIM('{{#explode:{{#replace:{{{1}}}\|'\|''}}\|, \|1}}'))) AND CR.LanguageCode = '{{{Lang\|EN}}}'
	\|order by=CASE WHEN C.SetNum = '0' THEN 100 ELSE CASE WHEN C.SETNUM REGEXP '^-?[0-9]+$' THEN CAST(C.SetNum AS UNSIGNED INTEGER) ELSE 100 END END, CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'P' THEN 0 WHEN C.Subset = 'D' THEN 1 ELSE 10 END, C.CardNum		\|order by=CASE WHEN C.SetNum = '0' THEN 100 ELSE CASE WHEN C.SETNUM REGEXP '^-?[0-9]+$' THEN CAST(C.SetNum AS UNSIGNED INTEGER) ELSE 100 END END, CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'P' THEN 0 WHEN C.Subset = 'D' THEN 1 ELSE 10 END, C.CardNum

Teltura at 01:57, 6 July 2024

2024-07-06T01:57:51Z

← Older revision		Revision as of 01:57, 6 July 2024
Line 30:		Line 30:
	, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile		, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile
	, '{{{Size\|500}}}px'=ImageWidth		, '{{{Size\|500}}}px'=ImageWidth
	, '~~{{#replace:~~{{#replace:{{{2}}}\|'\|''~~}}\|.\|․~~}}'=Caption		, '{{#replace:{{{2}}}\|'\|''}}'=Caption
	\|where= (C.Title LIKE '{{#replace:{{{1}}}\|'\|''}}' OR C.Subtitle LIKE '{{#replace:{{{1}}}\|'\|''}}' OR (C.Title LIKE '{{#explode:{{#replace:{{{1}}}\|'\|''}}\|, \|0}}' AND C.Subtitle LIKE TRIM('{{#explode:{{#replace:{{{1}}}\|'\|''}}\|, \|1}}'))) AND CR.LanguageCode = '{{{Lang\|EN}}}'		\|where= (C.Title LIKE '{{#replace:{{{1}}}\|'\|''}}' OR C.Subtitle LIKE '{{#replace:{{{1}}}\|'\|''}}' OR (C.Title LIKE '{{#explode:{{#replace:{{{1}}}\|'\|''}}\|, \|0}}' AND C.Subtitle LIKE TRIM('{{#explode:{{#replace:{{{1}}}\|'\|''}}\|, \|1}}'))) AND CR.LanguageCode = '{{{Lang\|EN}}}'
	\|order by=CASE WHEN C.SetNum = '0' THEN 100 ELSE CASE WHEN C.SETNUM REGEXP '^-?[0-9]+$' THEN CAST(C.SetNum AS UNSIGNED INTEGER) ELSE 100 END END, CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'P' THEN 0 WHEN C.Subset = 'D' THEN 1 ELSE 10 END, C.CardNum		\|order by=CASE WHEN C.SetNum = '0' THEN 100 ELSE CASE WHEN C.SETNUM REGEXP '^-?[0-9]+$' THEN CAST(C.SetNum AS UNSIGNED INTEGER) ELSE 100 END END, CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'P' THEN 0 WHEN C.Subset = 'D' THEN 1 ELSE 10 END, C.CardNum

Teltura at 01:53, 6 July 2024

2024-07-06T01:53:09Z

← Older revision		Revision as of 01:53, 6 July 2024
Line 17:		Line 17:
	, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile		, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile
	, '{{{Size\|500}}}px'=ImageWidth		, '{{{Size\|500}}}px'=ImageWidth
	, ~~REPLACE(REPLACE(~~'{{{2}}}','.~~','~~․'~~),'''', '''''')~~=Caption		, '{{#replace:{{#replace:{{{2}}}\|'\|''}}\|.\|․}}'=Caption
	\|where= CR.ID = '{{IDLookup\|{{{1}}}\|{{{Lang\|EN}}}}}'		\|where= CR.ID = '{{IDLookup\|{{{1}}}\|{{{Lang\|EN}}}}}'
	\|format=template		\|format=template
Line 30:		Line 30:
	, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile		, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile
	, '{{{Size\|500}}}px'=ImageWidth		, '{{{Size\|500}}}px'=ImageWidth
	, ~~REPLACE(REPLACE(~~'{{{2}}}','.~~','~~․'~~),'''', '''''')~~=Caption		, '{{#replace:{{#replace:{{{2}}}\|'\|''}}\|.\|․}}'=Caption
	\|where= (C.Title LIKE '{{#replace:{{{1}}}\|'\|''}}' OR C.Subtitle LIKE '{{#replace:{{{1}}}\|'\|''}}' OR (C.Title LIKE '{{#explode:{{#replace:{{{1}}}\|'\|''}}\|, \|0}}' AND C.Subtitle LIKE TRIM('{{#explode:{{#replace:{{{1}}}\|'\|''}}\|, \|1}}'))) AND CR.LanguageCode = '{{{Lang\|EN}}}'		\|where= (C.Title LIKE '{{#replace:{{{1}}}\|'\|''}}' OR C.Subtitle LIKE '{{#replace:{{{1}}}\|'\|''}}' OR (C.Title LIKE '{{#explode:{{#replace:{{{1}}}\|'\|''}}\|, \|0}}' AND C.Subtitle LIKE TRIM('{{#explode:{{#replace:{{{1}}}\|'\|''}}\|, \|1}}'))) AND CR.LanguageCode = '{{{Lang\|EN}}}'
	\|order by=CASE WHEN C.SetNum = '0' THEN 100 ELSE CASE WHEN C.SETNUM REGEXP '^-?[0-9]+$' THEN CAST(C.SetNum AS UNSIGNED INTEGER) ELSE 100 END END, CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'P' THEN 0 WHEN C.Subset = 'D' THEN 1 ELSE 10 END, C.CardNum		\|order by=CASE WHEN C.SetNum = '0' THEN 100 ELSE CASE WHEN C.SETNUM REGEXP '^-?[0-9]+$' THEN CAST(C.SetNum AS UNSIGNED INTEGER) ELSE 100 END END, CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'P' THEN 0 WHEN C.Subset = 'D' THEN 1 ELSE 10 END, C.CardNum

Teltura at 01:50, 6 July 2024

2024-07-06T01:50:08Z

← Older revision		Revision as of 01:50, 6 July 2024
Line 17:		Line 17:
	, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile		, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile
	, '{{{Size\|500}}}px'=ImageWidth		, '{{{Size\|500}}}px'=ImageWidth
	, REPLACE('{{{2}}}','.','․')=Caption		, REPLACE(REPLACE('{{{2}}}','.','․'),'''', '''''')=Caption
	\|where= CR.ID = '{{IDLookup\|{{{1}}}\|{{{Lang\|EN}}}}}'		\|where= CR.ID = '{{IDLookup\|{{{1}}}\|{{{Lang\|EN}}}}}'
	\|format=template		\|format=template
Line 30:		Line 30:
	, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile		, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile
	, '{{{Size\|500}}}px'=ImageWidth		, '{{{Size\|500}}}px'=ImageWidth
	, REPLACE('{{{2}}}','.','․')=Caption		, REPLACE(REPLACE('{{{2}}}','.','․'),'''', '''''')=Caption
	\|where= (C.Title LIKE '{{#replace:{{{1}}}\|'\|''}}' OR C.Subtitle LIKE '{{#replace:{{{1}}}\|'\|''}}' OR (C.Title LIKE '{{#explode:{{#replace:{{{1}}}\|'\|''}}\|, \|0}}' AND C.Subtitle LIKE TRIM('{{#explode:{{#replace:{{{1}}}\|'\|''}}\|, \|1}}'))) AND CR.LanguageCode = '{{{Lang\|EN}}}'		\|where= (C.Title LIKE '{{#replace:{{{1}}}\|'\|''}}' OR C.Subtitle LIKE '{{#replace:{{{1}}}\|'\|''}}' OR (C.Title LIKE '{{#explode:{{#replace:{{{1}}}\|'\|''}}\|, \|0}}' AND C.Subtitle LIKE TRIM('{{#explode:{{#replace:{{{1}}}\|'\|''}}\|, \|1}}'))) AND CR.LanguageCode = '{{{Lang\|EN}}}'
	\|order by=CASE WHEN C.SetNum = '0' THEN 100 ELSE CASE WHEN C.SETNUM REGEXP '^-?[0-9]+$' THEN CAST(C.SetNum AS UNSIGNED INTEGER) ELSE 100 END END, CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'P' THEN 0 WHEN C.Subset = 'D' THEN 1 ELSE 10 END, C.CardNum		\|order by=CASE WHEN C.SetNum = '0' THEN 100 ELSE CASE WHEN C.SETNUM REGEXP '^-?[0-9]+$' THEN CAST(C.SetNum AS UNSIGNED INTEGER) ELSE 100 END END, CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'P' THEN 0 WHEN C.Subset = 'D' THEN 1 ELSE 10 END, C.CardNum

Teltura at 23:16, 5 July 2024

2024-07-05T23:16:10Z

← Older revision		Revision as of 23:16, 5 July 2024
Line 1:		Line 1:
	<noinclude>		<noinclude>
	{{#template_params:ID\|Lang\|Size~~\|Caption~~}}		{{#template_params:1\|2\|Lang\|Size}}

	Parameter 1 should refer to the card. Usually this can just be the card name: ''<nowiki>{{Card\|The One Ring, The Ruling Ring}}</nowiki>'' or ''<nowiki>{{Card\|The Ruling Ring}}</nowiki>'' produce {{Card\|The Ruling Ring}}. If you want to link to a different version of the same card, you can use the card's collector number: ''<nowiki>{{Card\|4C2}}</nowiki>'' produces {{Card\|4C2}}. If that doesn't work, you can instead use the "Wiki Base Card ID" parameter, found in each card page's infobox under "Technical Info". For example, using ''<nowiki>{{Card\|LOTR-EN15G060.0}}</nowiki>'' is currently the only working way to link to the Gondor version {{Card\|LOTR-EN15G060.0}}.		Parameter 1 should refer to the card. Usually this can just be the card name: ''<nowiki>{{Card\|The One Ring, The Ruling Ring}}</nowiki>'' or ''<nowiki>{{Card\|The Ruling Ring}}</nowiki>'' produce {{Card\|The Ruling Ring}}. If you want to link to a different version of the same card, you can use the card's collector number: ''<nowiki>{{Card\|4C2}}</nowiki>'' produces {{Card\|4C2}}. If that doesn't work, you can instead use the "Wiki Base Card ID" parameter, found in each card page's infobox under "Technical Info". For example, using ''<nowiki>{{Card\|LOTR-EN15G060.0}}</nowiki>'' is currently the only working way to link to the Gondor version {{Card\|LOTR-EN15G060.0}}.

	Parameter 2 is the language code, which will produce the appropriate title + image for the requested language. ''<nowiki>{{Card\|Gimli, Son of Gloin\|FR}}</nowiki>'' produces {{Card\|Gimli, Son of Gloin\|FR}}, and ''<nowiki>{{Card\|Gimli, Son of Gloin\|TW}}</nowiki>'' produces the tengwar {{Card\|Gimli, Son of Gloin\|TW}}.		Parameter 2 is the caption being placed beneath the card image.

			Lang is language code, which will produce the appropriate title + image for the requested language. ''<nowiki>{{Card\|Gimli, Son of Gloin\|FR}}</nowiki>'' produces {{Card\|Gimli, Son of Gloin\|FR}}, and ''<nowiki>{{Card\|Gimli, Son of Gloin\|TW}}</nowiki>'' produces the tengwar {{Card\|Gimli, Son of Gloin\|TW}}. This defaults to EN.

			Size is the max width of the image, which defaults to 500px.

	If the card is not found (due to a typo, for instance), then it will display like this: {{Card\|Glimlik, Son of Gloin}}.		If the card is not found (due to a typo, for instance), then it will display like this: {{Card\|Glimlik, Son of Gloin}}.

Teltura at 23:12, 5 July 2024

2024-07-05T23:12:52Z

← Older revision		Revision as of 23:12, 5 July 2024
Line 7:		Line 7:

	If the card is not found (due to a typo, for instance), then it will display like this: {{Card\|Glimlik, Son of Gloin}}.		If the card is not found (due to a typo, for instance), then it will display like this: {{Card\|Glimlik, Son of Gloin}}.
	</noinclude><includeonly>{{#if:{{#pos:{{{ID}}}\|0}}{{#pos:{{{ID}}}\|1}}{{#pos:{{{ID}}}\|2}}{{#pos:{{{ID}}}\|3}}{{#pos:{{{ID}}}\|4}}{{#pos:{{{ID}}}\|5}}{{#pos:{{{ID}}}\|6}}{{#pos:{{{ID}}}\|7}}{{#pos:{{{ID}}}\|8}}{{#pos:{{{ID}}}\|9}}\|{{#cargo_query:		</noinclude><includeonly>{{#if:{{#pos:{{{1}}}\|0}}{{#pos:{{{1}}}\|1}}{{#pos:{{{1}}}\|2}}{{#pos:{{{1}}}\|3}}{{#pos:{{{1}}}\|4}}{{#pos:{{{1}}}\|5}}{{#pos:{{{1}}}\|6}}{{#pos:{{{1}}}\|7}}{{#pos:{{{1}}}\|8}}{{#pos:{{{1}}}\|9}}\|{{#cargo_query:
	tables=Cards=C,CardReleases=CR,CardReleases=ECR		tables=Cards=C,CardReleases=CR,CardReleases=ECR
	\|join on= C.ID = CR.BaseCardID,ECR.ID = C.ID		\|join on= C.ID = CR.BaseCardID,ECR.ID = C.ID
Line 13:		Line 13:
	, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile		, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile
	, '{{{Size\|500}}}px'=ImageWidth		, '{{{Size\|500}}}px'=ImageWidth
	, REPLACE('{{{~~Caption~~}}}','.','․')=Caption		, REPLACE('{{{2}}}','.','․')=Caption
	\|where= CR.ID = '{{IDLookup\|{{{ID}}}\|{{{Lang\|EN}}}}}'		\|where= CR.ID = '{{IDLookup\|{{{1}}}\|{{{Lang\|EN}}}}}'
	\|format=template		\|format=template
	\|named args=yes		\|named args=yes
	\|template=SplashCardWithCaption		\|template=SplashCardWithCaption
	\|default={{PageLookup\|{{{ID}}}}}		\|default={{PageLookup\|{{{1}}}}}
	}}		}}
	\| {{#cargo_query:		\| {{#cargo_query:
Line 26:		Line 26:
	, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile		, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile
	, '{{{Size\|500}}}px'=ImageWidth		, '{{{Size\|500}}}px'=ImageWidth
	, REPLACE('{{{~~Caption~~}}}','.','․')=Caption		, REPLACE('{{{2}}}','.','․')=Caption
	\|where= (C.Title LIKE '{{#replace:{{{ID}}}\|'\|''}}' OR C.Subtitle LIKE '{{#replace:{{{ID}}}\|'\|''}}' OR (C.Title LIKE '{{#explode:{{#replace:{{{ID}}}\|'\|''}}\|, \|0}}' AND C.Subtitle LIKE TRIM('{{#explode:{{#replace:{{{ID}}}\|'\|''}}\|, \|1}}'))) AND CR.LanguageCode = '{{{Lang\|EN}}}'		\|where= (C.Title LIKE '{{#replace:{{{1}}}\|'\|''}}' OR C.Subtitle LIKE '{{#replace:{{{1}}}\|'\|''}}' OR (C.Title LIKE '{{#explode:{{#replace:{{{1}}}\|'\|''}}\|, \|0}}' AND C.Subtitle LIKE TRIM('{{#explode:{{#replace:{{{1}}}\|'\|''}}\|, \|1}}'))) AND CR.LanguageCode = '{{{Lang\|EN}}}'
	\|order by=CASE WHEN C.SetNum = '0' THEN 100 ELSE CASE WHEN C.SETNUM REGEXP '^-?[0-9]+$' THEN CAST(C.SetNum AS UNSIGNED INTEGER) ELSE 100 END END, CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'P' THEN 0 WHEN C.Subset = 'D' THEN 1 ELSE 10 END, C.CardNum		\|order by=CASE WHEN C.SetNum = '0' THEN 100 ELSE CASE WHEN C.SETNUM REGEXP '^-?[0-9]+$' THEN CAST(C.SetNum AS UNSIGNED INTEGER) ELSE 100 END END, CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'P' THEN 0 WHEN C.Subset = 'D' THEN 1 ELSE 10 END, C.CardNum
	\|limit=1		\|limit=1
Line 34:		Line 34:
	\|named args=yes		\|named args=yes
	\|template=SplashCardWithCaption		\|template=SplashCardWithCaption
	\|default={{PageLookup\|{{{ID}}}}}		\|default={{PageLookup\|{{{1}}}}}
	}}		}}
	}}</includeonly>		}}</includeonly>

Teltura at 23:06, 5 July 2024

2024-07-05T23:06:01Z

← Older revision		Revision as of 23:06, 5 July 2024
Line 13:		Line 13:
	, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile		, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile
	, '{{{Size\|500}}}px'=ImageWidth		, '{{{Size\|500}}}px'=ImageWidth
	, REPLACE('{{{Caption}}}','.','.')=Caption		, REPLACE('{{{Caption}}}','.','․')=Caption
	\|where= CR.ID = '{{IDLookup\|{{{ID}}}\|{{{Lang\|EN}}}}}'		\|where= CR.ID = '{{IDLookup\|{{{ID}}}\|{{{Lang\|EN}}}}}'
	\|format=template		\|format=template
Line 26:		Line 26:
	, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile		, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile
	, '{{{Size\|500}}}px'=ImageWidth		, '{{{Size\|500}}}px'=ImageWidth
	, '{{{Caption}}} '=Caption		, REPLACE('{{{Caption}}}','.','․')=Caption
	\|where= (C.Title LIKE '{{#replace:{{{ID}}}\|'\|''}}' OR C.Subtitle LIKE '{{#replace:{{{ID}}}\|'\|''}}' OR (C.Title LIKE '{{#explode:{{#replace:{{{ID}}}\|'\|''}}\|, \|0}}' AND C.Subtitle LIKE TRIM('{{#explode:{{#replace:{{{ID}}}\|'\|''}}\|, \|1}}'))) AND CR.LanguageCode = '{{{Lang\|EN}}}'		\|where= (C.Title LIKE '{{#replace:{{{ID}}}\|'\|''}}' OR C.Subtitle LIKE '{{#replace:{{{ID}}}\|'\|''}}' OR (C.Title LIKE '{{#explode:{{#replace:{{{ID}}}\|'\|''}}\|, \|0}}' AND C.Subtitle LIKE TRIM('{{#explode:{{#replace:{{{ID}}}\|'\|''}}\|, \|1}}'))) AND CR.LanguageCode = '{{{Lang\|EN}}}'
	\|order by=CASE WHEN C.SetNum = '0' THEN 100 ELSE CASE WHEN C.SETNUM REGEXP '^-?[0-9]+$' THEN CAST(C.SetNum AS UNSIGNED INTEGER) ELSE 100 END END, CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'P' THEN 0 WHEN C.Subset = 'D' THEN 1 ELSE 10 END, C.CardNum		\|order by=CASE WHEN C.SetNum = '0' THEN 100 ELSE CASE WHEN C.SETNUM REGEXP '^-?[0-9]+$' THEN CAST(C.SetNum AS UNSIGNED INTEGER) ELSE 100 END END, CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'P' THEN 0 WHEN C.Subset = 'D' THEN 1 ELSE 10 END, C.CardNum