Template:CardText - Revision history

Teltura at 21:20, 11 April 2025

2025-04-11T21:20:45Z

← Older revision		Revision as of 21:20, 11 April 2025
Line 10:		Line 10:
	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
	\|fields= ~~REPLACE~~(~~REPLACE(C._pageName,~~ '~~/Data~~', ~~''), 'Data:', '')=PageTitle~~		\|fields= CONCAT(' ', REPLACE(CR.FormattedGameText, '\n\n', '\n '))
	~~, IFNULL~~(CR.~~ImageFilename~~,'~~File:Card_Not_Found.jpg~~'~~)=ImageFile~~
	, ~~IFNULL(CR.Title,ECR.Title~~)~~=Title~~
	~~, IFNULL(CR.Subtitle,ECR.Subtitle)=Subtitle~~
	~~, IFNULL(CR.CollInfo,C.CollInfo~~)~~=CollInfo~~
	\|where= CR.ID = '{{IDLookup\|{{{1}}}\|{{{2\|EN}}}}}'		\|where= CR.ID = '{{IDLookup\|{{{1}}}\|{{{2\|EN}}}}}'
	~~\|format=template~~
	\|named args=yes		\|named args=yes
	~~\|template=LinkNameWithImage~~
	\|default={{PageLookup\|{{{1}}}}}		\|default={{PageLookup\|{{{1}}}}}
	}}		}}
Line 24:		Line 18:
	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
	\|fields= CONCAT(' ', REPLACE(CR.FormattedGameText, '\n', '\n '))		\|fields= CONCAT(' ', REPLACE(CR.FormattedGameText, '\n\n', '\n '))
	\|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 = '{{{2\|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 = '{{{2\|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 21:19, 11 April 2025

2025-04-11T21:19:47Z

← Older revision		Revision as of 21:19, 11 April 2025
Line 24:		Line 24:
	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
	\|fields= REPLACE(CR.FormattedGameText, '\n', '\n ')		\|fields= CONCAT(' ', REPLACE(CR.FormattedGameText, '\n', '\n '))
	\|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 = '{{{2\|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 = '{{{2\|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 21:18, 11 April 2025

2025-04-11T21:18:28Z

← Older revision		Revision as of 21:18, 11 April 2025
Line 24:		Line 24:
	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
	\|fields= REPLACE(CR.FormattedGameText, '~~<br>~~', ' ~~<br>~~')		\|fields= REPLACE(CR.FormattedGameText, '\n', '\n ')
	\|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 = '{{{2\|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 = '{{{2\|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 21:17, 11 April 2025

2025-04-11T21:17:20Z

← Older revision		Revision as of 21:17, 11 April 2025
Line 29:		Line 29:
	\|limit=1		\|limit=1
	\|more results text=		\|more results text=
	~~\|format=template~~
	\|named args=yes		\|named args=yes
	\|default={{PageLookup\|{{{1}}}}}		\|default={{PageLookup\|{{{1}}}}}
	}}		}}
	}}</includeonly>		}}</includeonly>

Teltura: Created page with " {{#template_params:1|2}} Parameter 1 should refer to the card. Usually this can just be the card name: ''{{Card|The One Ring, The Ruling Ring}}'' or ''{{Card|The Ruling Ring}}'' 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: ''{{Card|4C2}}'' produces {{Card|4C2}}. If that doesn't work, you can instead use the "Wiki Base..."

2025-04-11T21:16:11Z

Created page with "<noinclude> {{#template_params:1|2}} 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..."

New page

<noinclude>
{{#template_params:1|2}}

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}}.

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:{{{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
, IFNULL(CR.Title,ECR.Title)=Title
, IFNULL(CR.Subtitle,ECR.Subtitle)=Subtitle
, IFNULL(CR.CollInfo,C.CollInfo)=CollInfo
|where= CR.ID = '{{IDLookup|{{{1}}}|{{{2|EN}}}}}'
|format=template
|named args=yes
|template=LinkNameWithImage
|default={{PageLookup|{{{1}}}}}
}}
| {{#cargo_query:
tables=Cards=C,CardReleases=CR,CardReleases=ECR
|join on= C.ID = CR.BaseCardID,ECR.ID = C.ID
|fields= REPLACE(CR.FormattedGameText, '<br>', ' <br>')
|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 = '{{{2|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
|default={{PageLookup|{{{1}}}}}
}}
}}</includeonly>