Template:CardSearch: Difference between revisions
From LOTR-TCG Wiki
No edit summary |
No edit summary |
||
Line 7: | Line 7: | ||
|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 ("{{{title|}}}" = "" OR CR.Title RLIKE "{{{title|}}}") | ||
AND ("{{{subtitle|}}}" = "" OR CR. | AND ("{{{subtitle|}}}" = "" OR CR.Subtitle RLIKE "{{{subtitle|}}}") | ||
AND ("{{{side|}}}" = "" OR CR.Side = "{{{title|}}}") | |||
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:56, 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.