Template:ListTable - Revision history

Teltura at 06:43, 13 February 2023

2023-02-13T06:43:15Z

2023-02-12T17:58:26Z

← Older revision		Revision as of 17:58, 12 February 2023
Line 13:		Line 13:
	\|order by={{{sort\|{{StandardSort}}}}}		\|order by={{{sort\|{{StandardSort}}}}}
	\|limit=400		\|limit=400
	\|intro=<ul>		\|intro=<ul style="columns: {{{columns\|3}}}; -webkit-columns: {{{columns\|3}}}; -moz-columns: {{{columns\|3}}};">
	\|format=template		\|format=template
	\|template=CardULReadout		\|template=CardULReadout

2023-02-12T17:55:52Z

2023-02-12T17:54:39Z

← Older revision		Revision as of 17:54, 12 February 2023
Line 5:		Line 5:
	\|join on=C.ID = CR.ID		\|join on=C.ID = CR.ID
	\|fields=		\|fields=
	,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle		REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
	,CR.Title		,CR.Title
	,CR.Subtitle		,CR.Subtitle

2023-02-12T17:53:57Z

2023-02-12T17:52:32Z

converting to use a template with lazy loading support

← Older revision		Revision as of 17:52, 12 February 2023
Line 5:		Line 5:
	\|join on=C.ID = CR.ID		\|join on=C.ID = CR.ID
	\|fields=		\|fields=
	,~~CONCAT('<span class="tooltip">[[',~~ REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''), ~~'\|',~~ CR.Title, ~~CASE WHEN~~ CR.Subtitle ~~IS NULL THEN '' ELSE CONCAT(', '~~, CR~~.Subtitle) END, ' (', IFNULL(CR.CollInfo,C~~.CollInfo~~), ')]]<span>[[File:'~~, ~~IFNULL(~~CR.ImageFilename~~,'Card_Not_Found.jpg'), '\|500x500px]]</span></span>')~~=~~CardName~~		,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle
			,CR.Title
			,CR.Subtitle
			,CR.CollInfo
			,CR.ImageFilename=ImageFile
	\|where= {{{filter\|{{PromoFilter}}}}}		\|where= {{{filter\|{{PromoFilter}}}}}
	\|order by={{{sort\|{{StandardSort}}}}}		\|order by={{{sort\|{{StandardSort}}}}}
	\|limit=400		\|limit=400
	\|format=ul		\|intro=<ul>
			\|format=CardULReadout
			\|outro=</ul>
	\|columns={{{columns\|3}}}		\|columns={{{columns\|3}}}
	}}		}}
	</includeonly>		</includeonly>

2022-03-04T05:49:34Z

← Older revision		Revision as of 05:49, 4 March 2022
Line 5:		Line 5:
	\|join on=C.ID = CR.ID		\|join on=C.ID = CR.ID
	\|fields=		\|fields=
	,CONCAT('<span class="tooltip">[[', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''), '\|', CR.Title, CASE WHEN CR.Subtitle IS NULL THEN '' ELSE CONCAT(', ', CR.Subtitle) END, ' (', IFNULL(CR.CollInfo,C.CollInfo), ')]]<span>[[File:', IFNULL(CR.ImageFilename,'Card_Not_Found.jpg'), ']]</span></span>')=CardName		,CONCAT('<span class="tooltip">[[', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''), '\|', CR.Title, CASE WHEN CR.Subtitle IS NULL THEN '' ELSE CONCAT(', ', CR.Subtitle) END, ' (', IFNULL(CR.CollInfo,C.CollInfo), ')]]<span>[[File:', IFNULL(CR.ImageFilename,'Card_Not_Found.jpg'), '\|500x500px]]</span></span>')=CardName
	\|where= {{{filter\|{{PromoFilter}}}}}		\|where= {{{filter\|{{PromoFilter}}}}}
	\|order by={{{sort\|{{StandardSort}}}}}		\|order by={{{sort\|{{StandardSort}}}}}

2022-01-09T09:09:32Z

2022-01-09T09:08:47Z

added column param

← Older revision		Revision as of 09:08, 9 January 2022
Line 1:		Line 1:
	<noinclude>		<noinclude>
	{{#template_params:filter\|sort}}		{{#template_params:filter\|sort\|columns}}
	</noinclude><includeonly>		</noinclude><includeonly>
	{{#cargo_query:tables=Cards=C,CardReleases=CR		{{#cargo_query:tables=Cards=C,CardReleases=CR
Line 10:		Line 10:
	\|limit=400		\|limit=400
	\|format=ul		\|format=ul
	\|columns=3		\|columns={{columns\|3}}
	}}		}}
	</includeonly>		</includeonly>