Template:CardSearch: Difference between revisions

From LOTR-TCG Wiki
No edit summary
No edit summary
Line 25: Line 25:
AND ("{{{twilightMore|}}}" = "" OR CR.TwilightCost >= "{{{twilightMore|}}}")
AND ("{{{twilightMore|}}}" = "" OR CR.TwilightCost >= "{{{twilightMore|}}}")
AND ("{{{twilightLess|}}}" = "" OR CR.TwilightCost <= "{{{twilightLess|}}}")
AND ("{{{twilightLess|}}}" = "" OR CR.TwilightCost <= "{{{twilightLess|}}}")
AND ("{{{strength|}}}" = "" OR CASE WHEN "{{{strength|}}}" LIKE '+%' OR "{{{strength|}}}" LIKE '-%' THEN CR.StrengthMod = "{{{strength|}}}" ELSE CR.Strength = "{{{strength|}}}" END)
AND ("{{{strength|}}}" = "" OR CASE WHEN "{{{strength|}}}" RLIKE '(\\+{{!}}-)\\d+' 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 ("{{{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|}}}" RLIKE '(\\+{{!}}-)\\d+' THEN CAST(CR.StrengthMod AS INT) <= CAST("{{{strengthLess|}}}" AS INT) 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)
AND ("{{{vitality|}}}" = "" OR CASE WHEN "{{{vitality|}}}" RLIKE '(\\+{{!}}-)\\d+' THEN CR.VitalityMod = "{{{vitality|}}}" ELSE CR.Vitality = "{{{vitality|}}}" END)
AND ("{{{vitalityMore|}}}" = "" OR CASE WHEN "{{{vitalityMore|}}}" LIKE '+%' OR "{{{vitalityMore|}}}" LIKE '-%' THEN CR.VitalityMod >= "{{{vitalityMore|}}}" ELSE CR.Vitality >= "{{{vitalityMore|}}}" END)
AND ("{{{vitalityMore|}}}" = "" OR CASE WHEN "{{{vitalityMore|}}}" RLIKE '(\\+{{!}}-)\\d+' THEN CAST(CR.VitalityMod AS INT) >= CAST("{{{vitalityMore|}}}" AS INT) ELSE CR.Vitality >= "{{{vitalityMore|}}}" END)
AND ("{{{vitalityLess|}}}" = "" OR CASE WHEN "{{{vitalityLess|}}}" LIKE '+%' OR "{{{vitalityLess|}}}" LIKE '-%' THEN CR.VitalityMod <= "{{{vitalityLess|}}}" ELSE CR.Vitality <= "{{{vitalityLess|}}}" END)
AND ("{{{vitalityLess|}}}" = "" OR CASE WHEN "{{{vitalityLess|}}}" RLIKE '(\\+{{!}}-)\\d+' THEN CAST(CR.VitalityMod AS INT) <= CAST("{{{vitalityLess|}}}" AS INT) ELSE CR.Vitality >= "{{{vitalityLess|}}}" END)


AND ("{{{sitenum|}}}" = "" OR CASE WHEN "{{{sitenum|}}}" LIKE '+%' OR "{{{sitenum|}}}" LIKE '-%' THEN CR.SiteNumMod = "{{{sitenum|}}}" ELSE CR.SiteNum = "{{{sitenum|}}}" END)
AND ("{{{sitenum|}}}" = "" OR CASE WHEN "{{{sitenum|}}}" RLIKE '(\\+{{!}}-)\\d+' THEN CR.SiteNumMod = "{{{sitenum|}}}" ELSE CR.SiteNum = "{{{sitenum|}}}" END)
AND ("{{{sitenumMore|}}}" = "" OR CASE WHEN "{{{sitenumMore|}}}" LIKE '+%' OR "{{{sitenumMore|}}}" LIKE '-%' THEN CR.SiteNumMod >= "{{{sitenumMore|}}}" ELSE CR.SiteNum >= "{{{sitenumMore|}}}" END)
AND ("{{{sitenumMore|}}}" = "" OR CASE WHEN "{{{sitenumMore|}}}" RLIKE '(\\+{{!}}-)\\d+' THEN CAST(CR.SiteNumMod AS INT) >= CAST("{{{sitenumMore|}}}" AS INT) ELSE CR.SiteNum >= "{{{sitenumMore|}}}" END)
AND ("{{{sitenumLess|}}}" = "" OR CASE WHEN "{{{sitenumLess|}}}" LIKE '+%' OR "{{{sitenumLess|}}}" LIKE '-%' THEN CR.SiteNumMod <= "{{{sitenumLess|}}}" ELSE CR.SiteNum <= "{{{sitenumLess|}}}" END)
AND ("{{{sitenumLess|}}}" = "" OR CASE WHEN "{{{sitenumLess|}}}" RLIKE '(\\+{{!}}-)\\d+' THEN CAST(CR.SiteNumMod AS INT) <= CAST("{{{sitenumLess|}}}" AS INT) ELSE CR.SiteNum >= "{{{sitenumLess|}}}" END)


AND ("{{{resistance|}}}" = "" OR CASE WHEN "{{{resistance|}}}" LIKE '+%' OR "{{{resistance|}}}" LIKE '-%' THEN CR.ResistanceMod = "{{{resistance|}}}" ELSE CR.Resistance = "{{{resistance|}}}" END)
AND ("{{{resistance|}}}" = "" OR CASE WHEN "{{{resistance|}}}" RLIKE '(\\+{{!}}-)\\d+' THEN CR.ResistanceMod = "{{{resistance|}}}" ELSE CR.Resistance = "{{{resistance|}}}" END)
AND ("{{{resistanceMore|}}}" = "" OR CASE WHEN "{{{resistanceMore|}}}" LIKE '+%' OR "{{{resistanceMore|}}}" LIKE '-%' THEN CR.ResistanceMod >= "{{{resistanceMore|}}}" ELSE CR.Resistance >= "{{{resistanceMore|}}}" END)
AND ("{{{resistanceMore|}}}" = "" OR CASE WHEN "{{{resistanceMore|}}}" RLIKE '(\\+{{!}}-)\\d+' THEN CAST(CR.ResistanceMod AS INT) >= CAST("{{{resistanceMore|}}}" AS INT) ELSE CR.Resistance >= "{{{resistanceMore|}}}" END)
AND ("{{{resistanceLess|}}}" = "" OR CASE WHEN "{{{resistanceLess|}}}" LIKE '+%' OR "{{{resistanceLess|}}}" LIKE '-%' THEN CR.ResistanceMod <= "{{{resistanceLess|}}}" ELSE CR.Resistance <= "{{{resistanceLess|}}}" END)
AND ("{{{resistanceLess|}}}" = "" OR CASE WHEN "{{{resistanceLess|}}}" RLIKE '(\\+{{!}}-)\\d+' THEN CAST(CR.ResistanceMod AS INT) <= CAST("{{{resistanceLess|}}}" AS INT) ELSE CR.Resistance >= "{{{resistanceLess|}}}" END)


AND ("{{{signet|}}}" = "" OR CR.Signet = "{{{signet|}}}")
AND ("{{{signet|}}}" = "" OR CR.Signet = "{{{signet|}}}")

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

Retrieved from "https://wiki.lotrtcgpc.net/index.php?title=Template:CardSearch&oldid=112120"