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 ("{{{creator|}}}" = "" OR "{{{creator|}}}" LIKE CONCAT('%', S.Creator, '%'))
|order by={{{sort|{{CultureSort}}}}}
|order by={{{sort|{{CultureSort}}}}}
|limit=100
|limit=100

Revision as of 22:47, 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.