Template:CardSearch: Difference between revisions

Revision as of 22:14, 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 27: / Line 27: @@
 AND ("{{{strength|}}}" = "" OR CASE WHEN "{{{strength|}}}" LIKE '+%' OR "{{{strength|}}}" LIKE '-%' THEN CR.StrengthMod = "{{{strength|}}}" ELSE CR.Strength = "{{{strength|}}}" END)
 AND ("{{{strengthMore|}}}" = "" OR CASE WHEN "{{{strengthMore|}}}" RLIKE '(\\+{{!}}-)\\d+' THEN CAST(CR.StrengthMod AS INT) >= CAST("{{{strengthMore|}}}" AS INT) ELSE CR.Strength >= "{{{strengthMore|}}}" END)
-AND ("{{{strengthLess|}}}" = "" OR CASE WHEN "{{{strengthLess|}}}" LIKE '+%' OR "{{{strengthLess|}}}" LIKE '-%' THEN CR.StrengthMod <= "{{{strengthLess|}}}" ELSE CR.Strength <= "{{{strengthLess|}}}" END)
+AND ("{{{strengthLess|}}}" = "" OR CASE WHEN "{{{strengthLess|}}}" RLIKE '(\\+{{!}}-)\\d+' THEN CAST(CR.StrengthMod AS INT) <= CAST("{{{strengthLess|}}}" AS INT) ELSE CR.Strength >= "{{{strengthLess|}}}" END)
 AND ("{{{vitality|}}}" = "" OR CASE WHEN "{{{vitality|}}}" LIKE '+%' OR "{{{vitality|}}}" LIKE '-%' THEN CR.VitalityMod = "{{{vitality|}}}" ELSE CR.Vitality = "{{{vitality|}}}" END)