Template:CardSearch: Difference between revisions

Revision as of 10:31, 5 October 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.

@@ Line 36: / Line 36: @@
 AND ("{{{eventPhase|}}}" = "" OR (C.CardType IN ('Event') AND ("{{{eventPhase|}}}" LIKE CONCAT('%', CR.Subtypes__full, '%') OR CR.GameText RLIKE "({{#replace:{{#replace:{{{eventPhase|}}}:|,|{{!}}}}||}})")))
-AND ("{{{hasPhaseAction|}}}" = "" OR (C.CardType NOT IN ('Event') AND CR.GameText LIKE "{{{hasPhaseAction|}}}:"))
+AND ("{{{hasPhaseAction|}}}" = "" OR (C.CardType NOT IN ('Event') AND CR.GameText RLIKE "({{#replace:{{#replace:{{{hasPhaseAction|}}}:|,|{{!}}}}||}})"))
 AND ("{{{keyword|}}}" = "" OR CR.GameText RLIKE '(?<!\\w )({{#replace:{{#replace:{{#replace:{{#replace:{{{keyword|}}}|,|{{!}}}}||}}|+|XX \\+}}|XX|}})\\.' OR ("{{{keyword|}}}" LIKE '%Ring-bound%' AND (C.Title IN ('Frodo', 'Sam') OR CR.CanBearRing = 1)) OR ("{{{keyword|}}}" LIKE '%Unbound%' AND (C.CardType = 'Companion' AND C.Title NOT IN ('Frodo', 'Sam') AND CR.GameText NOT RLIKE '(?<!\\w )Ring-bound\\.')) OR ("{{{keyword|}}}" LIKE '%Ambush%' AND CR.GameText RLIKE '(?<!\\w )Ambush \\(\\d+\\)\\.') )