Template:CardSearch: Difference between revisions
From LOTR-TCG Wiki
No edit summary |
No edit summary |
||
| Line 7: | Line 7: | ||
,CONCAT("{{{creator|}}}")=Creator | ,CONCAT("{{{creator|}}}")=Creator | ||
|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) | ||
AND ("{{{title|}}}" = "" OR CR.Title RLIKE "{{{title|}}}") | |||
AND ("{{{subtitle|}}}" = "" OR CR.Title RLIKE "{{{subtitle|}}}") | |||
AND ("{{{creator|}}}" = "" OR "{{{creator|}}}" LIKE CONCAT('%', S.Creator, '%')) | AND ("{{{creator|}}}" = "" OR "{{{creator|}}}" LIKE CONCAT('%', S.Creator, '%')) | ||
|order by={{{sort|{{CultureSort}}}}} | |order by={{{sort|{{CultureSort}}}}} | ||
Revision as of 22:52, 24 September 2022
This is the "CardSearch" template.
It should be called in the following format:
{{CardSearch
|isUnique=
|sort=
}}
Edit the page to see the template text.
