Template:CardSplashImage - Revision history

Teltura at 11:08, 3 February 2023

2023-02-03T11:08:17Z

← Older revision		Revision as of 11:08, 3 February 2023
Line 1:		Line 1:
	<includeonly>~~{{{1}}} {{{2}}} {{{3}}} {{{4}}}~~		<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:
	{{#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

Teltura at 11:07, 3 February 2023

2023-02-03T11:07:31Z

← Older revision		Revision as of 11:07, 3 February 2023
Line 5:		Line 5:
	\|fields= REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle		\|fields= REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
	, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile		, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile
	, '{{{2\|}}}'=Blurb		, TRIM('{{{2\|}}}')=Blurb
	, '{{{3\|}}}'=Size		, TRIM('{{{3\|}}}')=Size
	\|where= CR.ID = '{{IDLookup\|{{{1}}}\|{{{4\|EN}}}}}'		\|where= CR.ID = '{{IDLookup\|{{{1}}}\|{{{4\|EN}}}}}'
	\|format=template		\|format=template
Line 18:		Line 18:
	\|fields= REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle		\|fields= REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
	, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile		, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile
	, '{{{2\|}}}'=Blurb		, TRIM('{{{2\|}}}')=Blurb
	, '{{{3\|}}}'=Size		, TRIM('{{{3\|}}}')=Size
	\|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 = '{{{4\|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 = '{{{4\|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 11:06, 3 February 2023

2023-02-03T11:06:51Z

← Older revision		Revision as of 11:06, 3 February 2023
Line 5:		Line 5:
	\|fields= REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle		\|fields= REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
	, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile		, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile
	, {{{2\|''}}}=Blurb		, '{{{2\|}}}'=Blurb
	, {{{3\|''}}}=Size		, '{{{3\|}}}'=Size
	\|where= CR.ID = '{{IDLookup\|{{{1}}}\|{{{4\|EN}}}}}'		\|where= CR.ID = '{{IDLookup\|{{{1}}}\|{{{4\|EN}}}}}'
	\|format=template		\|format=template
Line 18:		Line 18:
	\|fields= REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle		\|fields= REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
	, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile		, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile
	, {{{2\|}}}=Blurb		, '{{{2\|}}}'=Blurb
	, {{{3\|}}}=Size		, '{{{3\|}}}'=Size
	\|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 = '{{{4\|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 = '{{{4\|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 11:06, 3 February 2023

2023-02-03T11:06:09Z

← Older revision		Revision as of 11:06, 3 February 2023
Line 5:		Line 5:
	\|fields= REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle		\|fields= REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
	, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile		, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile
	, {{{2\|}}}=Blurb		, {{{2\|''}}}=Blurb
	, {{{3\|}}}=Size		, {{{3\|''}}}=Size
	\|where= CR.ID = '{{IDLookup\|{{{1}}}\|{{{4\|EN}}}}}'		\|where= CR.ID = '{{IDLookup\|{{{1}}}\|{{{4\|EN}}}}}'
	\|format=template		\|format=template

Teltura at 11:05, 3 February 2023

2023-02-03T11:05:07Z

← Older revision		Revision as of 11:05, 3 February 2023
Line 1:		Line 1:
	<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:		<includeonly>{{{1}}} {{{2}}} {{{3}}} {{{4}}}
			{{#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

Teltura: Created page with "{{#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}..."

2023-02-03T11:02:39Z

Created page with "<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}..."

New page

<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
|join on= C.ID = CR.BaseCardID,ECR.ID = C.ID
|fields= REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile
, {{{2|}}}=Blurb
, {{{3|}}}=Size
|where= CR.ID = '{{IDLookup|{{{1}}}|{{{4|EN}}}}}'
|format=template
|named args=yes
|template=LinkWithSplashImage
|default={{PageLookup|{{{1}}}}}
}}
| {{#cargo_query:
tables=Cards=C,CardReleases=CR,CardReleases=ECR
|join on= C.ID = CR.BaseCardID,ECR.ID = C.ID
|fields= REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile
, {{{2|}}}=Blurb
, {{{3|}}}=Size
|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 = '{{{4|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
|limit=1
|more results text=
|format=template
|named args=yes
|template=LinkWithSplashImage
|default={{PageLookup|{{{1}}}}}
}}
}}</includeonly>