Template:CardSearch: Difference between revisions
From LOTR-TCG Wiki
No edit summary |
No edit summary |
||
| Line 5: | Line 5: | ||
|join on=C.ID = CR.ID | |join on=C.ID = CR.ID | ||
|fields=CR.ID=CardID | |fields=CR.ID=CardID | ||
, | ,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:', '') | |||
, | |||
, | |||
, | |||
, | |||
,CR. | |||
, | |||
, | |||
,IFNULL(CR. | |||
|where= ('{{{isUnique|any}}}' = 'any' OR CR.IsUnique = CASE WHEN '{{{isUnique|any}}}' = 'yes' THEN 1 WHEN '{{{isUnique|any}}}' = 'no' THEN 0 ELSE 2 END) | |where= ('{{{isUnique|any}}}' = 'any' OR CR.IsUnique = CASE WHEN '{{{isUnique|any}}}' = 'yes' THEN 1 WHEN '{{{isUnique|any}}}' = 'no' THEN 0 ELSE 2 END) | ||
|order by={{{sort|{{StandardSort}}}}} | |order by={{{sort|{{StandardSort}}}}} | ||
| Line 23: | Line 12: | ||
-->{{{!}} class="cargoQueryTable sortable cargoDynamicTable" style="margin:4px" | -->{{{!}} class="cargoQueryTable sortable cargoDynamicTable" style="margin:4px" | ||
! Portrait !! Card Name !! Culture !! Card Type !! Game Text | ! Portrait !! Card Name !! Culture !! Card Type !! Game Text | ||
|format= | |format=ul | ||
|template=CardReadoutRow | |template=CardReadoutRow | ||
|named args= yes | |named args= yes | ||
| Line 31: | Line 20: | ||
|delimiter= | |delimiter= | ||
|no html | |no html | ||
}} | |||
{{#cargo_query:tables=Cards=C,CardReleases=CR | |||
|join on=C.ID = CR.ID | |||
|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 | |||
|where= {{{filter|{{PromoFilter}}}}} | |||
|order by={{{sort|{{StandardSort}}}}} | |||
|limit=400 | |||
|format=ul | |||
|columns={{{columns|3}}} | |||
}} | }} | ||
</includeonly> | </includeonly> | ||
Revision as of 21:54, 24 September 2022
This is the "CardSearch" template.
It should be called in the following format:
{{CardSearch
|filter=
|sort=
}}
Edit the page to see the template text.
