Template:CardSearch: Difference between revisions
From LOTR-TCG Wiki
(fixing sanctuary for realsies (and standardizing arrow dir's capitalization)) |
No edit summary |
||
Line 69: | Line 69: | ||
AND ("{{{isSanctuary|any}}}" = "any" OR CASE WHEN {{Boolean|{{{isSanctuary|any}}}}} = 1 THEN CR.GameText RLIKE '(?<!\\w )Sanctuary\\.' ELSE CR.GameText NOT RLIKE '(?<!\\w )Sanctuary\\.' END) | AND ("{{{isSanctuary|any}}}" = "any" OR CASE WHEN {{Boolean|{{{isSanctuary|any}}}}} = 1 THEN CR.GameText RLIKE '(?<!\\w )Sanctuary\\.' ELSE CR.GameText NOT RLIKE '(?<!\\w )Sanctuary\\.' END) | ||
AND ("{{{arrowDir|Any}}}" = "any" OR {{ | AND ("{{{arrowDir|Any}}}" = "any" OR {{lc:CR.ArrowDir}} = "{{{arrowDir|any}}}") | ||
AND (CASE WHEN {{Boolean|{{{isFoil|no}}}}} = 0 THEN CR.Subset NOT IN ('F', 'A', 'O') ELSE CR.Subset IN ('F', 'A', 'O') END) | AND (CASE WHEN {{Boolean|{{{isFoil|no}}}}} = 0 THEN CR.Subset NOT IN ('F', 'A', 'O') ELSE CR.Subset IN ('F', 'A', 'O') END) |
Revision as of 03:41, 5 January 2023
This is the "CardSearch" template.
It should be called in the following format:
{{CardSearch |isUnique= |sort= }}
Edit the page to see the template text.