Template:CardSearch: Difference between revisions
From LOTR-TCG Wiki
No edit summary |
No edit summary |
||
| Line 14: | Line 14: | ||
AND ("{{{rarityabbr|}}}" = "" OR "{{{rarityabbr|}}}" LIKE CONCAT('%(', C.Rarity, ')%')) | AND ("{{{rarityabbr|}}}" = "" OR "{{{rarityabbr|}}}" LIKE CONCAT('%(', C.Rarity, ')%')) | ||
AND (CASE WHEN {{Boolean|{{{isFoil|no}}}}} THEN CR.Subset NOT IN ('F', 'A', 'O') ELSE CR.Subset IN ('F', 'A', 'O') END) | |||
AND ("{{{isPhysical|any}}}" = "any" OR IFNULL(CR.IsPhysical, C.IsPhysical) = {{Boolean|{{{isPhysical|any}}}}}) | AND ("{{{isPhysical|any}}}" = "any" OR IFNULL(CR.IsPhysical, C.IsPhysical) = {{Boolean|{{{isPhysical|any}}}}}) | ||
AND ("{{{isPlayable|any}}}" = "any" OR IFNULL(CR.isPlayable, C.isPlayable) = {{Boolean|{{{isPlayable|any}}}}}) | AND ("{{{isPlayable|any}}}" = "any" OR IFNULL(CR.isPlayable, C.isPlayable) = {{Boolean|{{{isPlayable|any}}}}}) | ||
Revision as of 07:23, 25 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.
