Template:CardSearch: Difference between revisions

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

@@ Line 48: / Line 48: @@
 AND ("{{{sitesitenumLess|}}}" = "" OR (C.CardType = 'Site' AND CR.SiteNum <= "{{{sitesitenumLess|}}}"))
-AND ("{{{shadownum|}}}" = "" OR (C.CardType = 'Site' AND IFNULL(CR.ShadowNumber, CR.TwilightCost) = "{{{shadownum|}}}"))
+AND ("{{{shadownum|}}}" = "" OR (C.CardType = 'Site' AND IFNULL(CR.ShadowNum, CR.TwilightCost) = "{{{shadownum|}}}"))
-AND ("{{{shadownumMore|}}}" = "" OR (C.CardType = 'Site' AND IFNULL(CR.ShadowNumber, CR.TwilightCost) >= "{{{shadownumMore|}}}"))
+AND ("{{{shadownumMore|}}}" = "" OR (C.CardType = 'Site' AND IFNULL(CR.ShadowNum, CR.TwilightCost) >= "{{{shadownumMore|}}}"))
-AND ("{{{shadownumLess|}}}" = "" OR (C.CardType = 'Site' AND IFNULL(CR.ShadowNumber, CR.TwilightCost) <= "{{{shadownumLess|}}}"))
+AND ("{{{shadownumLess|}}}" = "" OR (C.CardType = 'Site' AND IFNULL(CR.ShadowNum, CR.TwilightCost) <= "{{{shadownumLess|}}}"))
 AND ("{{{isSanctuary|any}}}" = "" OR CASE WHEN {{Boolean|{{{isSanctuary|any}}}}} = 1 THEN CR.GameText RLIKE '(?<!\\w )Sanctuary\\.' ELSE CR.GameText NOT RLIKE '(?<!\\w )Sanctuary\\.' END)