Template:CardSearch: Difference between revisions

Revision as of 09:11, 26 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.

@@ Line 23: / Line 23: @@
 AND ("{{{usesCulture|}}}" = "" OR CR.GameText RLIKE "\\[({{#replace:{{#replace:{{{usesCulture|}}}|,|{{!}}}}||}})]" )
-AND ("{{{cardtype|}}}" = "" OR C.CardType IN ("{{#replace:{{#replace:{{{cardtype|}}}|,|","}}||}}"))
+AND ("{{{cardtype|}}}" = "" OR C.CardType IN ("{{StripList|{{{cardtype|}}}}}"))
 AND ("{{{usesCardtype|}}}" = "" OR CR.GameText RLIKE "(?<!this )({{#replace:{{#replace:{{#replace:{{{usesCardtype|}}}|,|{{!}}}}||}}|TheOneRing|The One Ring}})" )
+AND ("{{{race|}}}" = "" OR (C.CardType IN ('Minion', 'Companion', 'Ally') AND "{{{race|}}}" LIKE CONCAT('%', CR.Subtypes__full, '%')) )