Template:CardSearch - Revision history

Teltura: Adding proper hunter support to the has keyword section

2023-06-22T04:34:01Z

Adding proper hunter support to the has keyword section

← Older revision		Revision as of 04:34, 22 June 2023
Line 34:		Line 34:
	AND ("{{{phaseAction\|}}}" = "" OR ((C.CardType IN ('Event') AND "{{{phaseAction\|}}}" LIKE CONCAT('%', CR.Subtypes__full, '%')) OR CR.GameText RLIKE "({{#replace:{{#replace:{{{phaseAction\|}}}:\|,\|:{{!}}}}\|\|}})"))		AND ("{{{phaseAction\|}}}" = "" OR ((C.CardType IN ('Event') AND "{{{phaseAction\|}}}" LIKE CONCAT('%', CR.Subtypes__full, '%')) OR CR.GameText RLIKE "({{#replace:{{#replace:{{{phaseAction\|}}}:\|,\|:{{!}}}}\|\|}})"))

	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+\\)\\.') )		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+\\)\\.') OR ("{{{keyword\|}}}" LIKE '%Hunter%' AND CR.GameText RLIKE '(?<!\\w )Hunter \\d+\\.') )

	AND ("{{{usesKeyword\|}}}" = "" OR (CR.GameText RLIKE '(?<=\\w )({{#replace:{{#replace:{{{usesKeyword\|}}}\|,\|{{!}}}}\|\|}})' AND (1 = CASE WHEN "{{{usesKeyword\|}}}" LIKE '%Archer%' AND CR.GameText LIKE '%Archer%' THEN CR.GameText RLIKE '(?<=\\w )archer\\b' ELSE 1 END )) )		AND ("{{{usesKeyword\|}}}" = "" OR (CR.GameText RLIKE '(?<=\\w )({{#replace:{{#replace:{{{usesKeyword\|}}}\|,\|{{!}}}}\|\|}})' AND (1 = CASE WHEN "{{{usesKeyword\|}}}" LIKE '%Archer%' AND CR.GameText LIKE '%Archer%' THEN CR.GameText RLIKE '(?<=\\w )archer\\b' ELSE 1 END )) )

Teltura: fixing wrong comparison operator for strength lessthan

2023-06-07T00:29:02Z

fixing wrong comparison operator for strength lessthan

← Older revision		Revision as of 00:29, 7 June 2023
Line 44:		Line 44:
	AND ("{{{strength\|}}}" = "" OR CASE WHEN "{{{strength\|}}}" RLIKE '(\\+{{!}}-)\\d+' 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\|}}}" RLIKE '(\\+{{!}}-)\\d+' 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)

Teltura at 03:44, 5 January 2023

2023-01-05T03:44:47Z

← Older revision		Revision as of 03:44, 5 January 2023
Line 69:		Line 69:

	AND ("{{{isSanctuary\|any}}}" = "any" OR CASE WHEN {{Boolean\|{{{isSanctuary\|any}}}}} = 1 THEN CR.GameText RLIKE '(?<!\\w )Sanctuary\\.' ELSE CR.GameText NOT RLIKE '(?<!\\w )Sanctuary\\.' END)		AND ("{{{isSanctuary\|any}}}" = "any" OR CASE WHEN {{Boolean\|{{{isSanctuary\|any}}}}} = 1 THEN CR.GameText RLIKE '(?<!\\w )Sanctuary\\.' ELSE CR.GameText NOT RLIKE '(?<!\\w )Sanctuary\\.' END)
	AND ("{{{arrowDir\|Any}}}" = "any" OR ~~{{lc:~~CR.ArrowDir}} = "{{{arrowDir\|any}}}")		AND ("{{{arrowDir\|Any}}}" = "any" OR CR.ArrowDir = "{{{arrowDir\|any}}}")

	AND (CASE WHEN {{Boolean\|{{{isFoil\|no}}}}} = 0 THEN CR.Subset NOT IN ('F', 'A', 'O') ELSE CR.Subset IN ('F', 'A', 'O') END)		AND (CASE WHEN {{Boolean\|{{{isFoil\|no}}}}} = 0 THEN CR.Subset NOT IN ('F', 'A', 'O') ELSE CR.Subset IN ('F', 'A', 'O') END)

Teltura at 03:41, 5 January 2023

2023-01-05T03:41:09Z

← Older revision		Revision as of 03:41, 5 January 2023
Line 69:		Line 69:

	AND ("{{{isSanctuary\|any}}}" = "any" OR CASE WHEN {{Boolean\|{{{isSanctuary\|any}}}}} = 1 THEN CR.GameText RLIKE '(?<!\\w )Sanctuary\\.' ELSE CR.GameText NOT RLIKE '(?<!\\w )Sanctuary\\.' END)		AND ("{{{isSanctuary\|any}}}" = "any" OR CASE WHEN {{Boolean\|{{{isSanctuary\|any}}}}} = 1 THEN CR.GameText RLIKE '(?<!\\w )Sanctuary\\.' ELSE CR.GameText NOT RLIKE '(?<!\\w )Sanctuary\\.' END)
	AND ("{{{arrowDir\|Any}}}" = "any" OR {{~~lowercase~~ CR.ArrowDir}} = "{{{arrowDir\|any}}}")		AND ("{{{arrowDir\|Any}}}" = "any" OR {{lc:CR.ArrowDir}} = "{{{arrowDir\|any}}}")

	AND (CASE WHEN {{Boolean\|{{{isFoil\|no}}}}} = 0 THEN CR.Subset NOT IN ('F', 'A', 'O') ELSE CR.Subset IN ('F', 'A', 'O') END)		AND (CASE WHEN {{Boolean\|{{{isFoil\|no}}}}} = 0 THEN CR.Subset NOT IN ('F', 'A', 'O') ELSE CR.Subset IN ('F', 'A', 'O') END)

Teltura: fixing sanctuary for realsies (and standardizing arrow dir's capitalization)

2023-01-05T03:39:55Z

fixing sanctuary for realsies (and standardizing arrow dir's capitalization)

← Older revision		Revision as of 03:39, 5 January 2023
Line 68:		Line 68:
	AND ("{{{shadownumLess\|}}}" = "" OR (C.CardType = 'Site' AND IFNULL(CR.ShadowNum, CR.TwilightCost) <= "{{{shadownumLess\|}}}"))		AND ("{{{shadownumLess\|}}}" = "" OR (C.CardType = 'Site' AND IFNULL(CR.ShadowNum, CR.TwilightCost) <= "{{{shadownumLess\|}}}"))

	AND ("{{{isSanctuary\|any}}}" = "~~Any~~" OR CASE WHEN {{Boolean\|{{{isSanctuary\|any}}}}} = 1 THEN CR.GameText RLIKE '(?<!\\w )Sanctuary\\.' ELSE CR.GameText NOT RLIKE '(?<!\\w )Sanctuary\\.' END)		AND ("{{{isSanctuary\|any}}}" = "any" OR CASE WHEN {{Boolean\|{{{isSanctuary\|any}}}}} = 1 THEN CR.GameText RLIKE '(?<!\\w )Sanctuary\\.' ELSE CR.GameText NOT RLIKE '(?<!\\w )Sanctuary\\.' END)
	AND ("{{{arrowDir\|Any}}}" = "~~Any~~" OR CR.ArrowDir = "{{{arrowDir\|~~Any~~}}}")		AND ("{{{arrowDir\|Any}}}" = "any" OR {{lowercase CR.ArrowDir}} = "{{{arrowDir\|any}}}")

	AND (CASE WHEN {{Boolean\|{{{isFoil\|no}}}}} = 0 THEN CR.Subset NOT IN ('F', 'A', 'O') ELSE CR.Subset IN ('F', 'A', 'O') END)		AND (CASE WHEN {{Boolean\|{{{isFoil\|no}}}}} = 0 THEN CR.Subset NOT IN ('F', 'A', 'O') ELSE CR.Subset IN ('F', 'A', 'O') END)

Teltura: fixing "any" filter not working for sanctuary

2023-01-05T03:36:37Z

fixing "any" filter not working for sanctuary

← Older revision		Revision as of 03:36, 5 January 2023
Line 68:		Line 68:
	AND ("{{{shadownumLess\|}}}" = "" OR (C.CardType = 'Site' AND IFNULL(CR.ShadowNum, 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)		AND ("{{{isSanctuary\|any}}}" = "Any" OR CASE WHEN {{Boolean\|{{{isSanctuary\|any}}}}} = 1 THEN CR.GameText RLIKE '(?<!\\w )Sanctuary\\.' ELSE CR.GameText NOT RLIKE '(?<!\\w )Sanctuary\\.' END)
	AND ("{{{arrowDir\|Any}}}" = "Any" OR CR.ArrowDir = "{{{arrowDir\|Any}}}")		AND ("{{{arrowDir\|Any}}}" = "Any" OR CR.ArrowDir = "{{{arrowDir\|Any}}}")

Phallen Cassidy at 20:46, 14 December 2022

2022-12-14T20:46:30Z

← Older revision		Revision as of 20:46, 14 December 2022
Line 105:		Line 105:
	("{{{advancedOptions\|}}}" RLIKE '(Cycling:{{!}}Draw Cards)' AND (CR.GameText RLIKE 'draw (up to )?(an?{{!}}X{{!}}\\d{{!}}all{{!}}every{{!}}each) card' AND CR.GameText NOT RLIKE 'opponent shuffle[^\\.]*draw deck and draw' AND CR.GameText NOT RLIKE '(Free Peoples {{!}}Shadow )?player (must {{!}}may )?draw' OR CR.GameText RLIKE 'muster')) OR		("{{{advancedOptions\|}}}" RLIKE '(Cycling:{{!}}Draw Cards)' AND (CR.GameText RLIKE 'draw (up to )?(an?{{!}}X{{!}}\\d{{!}}all{{!}}every{{!}}each) card' AND CR.GameText NOT RLIKE 'opponent shuffle[^\\.]*draw deck and draw' AND CR.GameText NOT RLIKE '(Free Peoples {{!}}Shadow )?player (must {{!}}may )?draw' OR CR.GameText RLIKE 'muster')) OR
	("{{{advancedOptions\|}}}" RLIKE '(Cycling:{{!}}Recover Cards Into Hand)' AND CR.GameText RLIKE 'take [^\\.]*into hand') OR		("{{{advancedOptions\|}}}" RLIKE '(Cycling:{{!}}Recover Cards Into Hand)' AND CR.GameText RLIKE 'take [^\\.]*into hand') OR
	("{{{advancedOptions\|}}}" RLIKE '(Cycling:{{!}}Discard From Your Hand)' AND (CR.GameText ~~LIKE~~ 'discard %from hand' AND CR.GameText NOT RLIKE '(opponent{{!}}owner{{!}}(Free Peoples {{!}}Shadow )?player)[^\\.]* discard[^\\.]*from hand' OR CR.GameText RLIKE 'muster')) OR		("{{{advancedOptions\|}}}" RLIKE '(Cycling:{{!}}Discard From Your Hand)' AND (CR.GameText RLIKE 'discard [^\\.]from hand' AND CR.GameText NOT RLIKE '(opponent{{!}}owner{{!}}(Free Peoples {{!}}Shadow )?player)[^\\.] discard[^\\.]*from hand' OR CR.GameText RLIKE 'muster')) OR

	("{{{advancedOptions\|}}}" RLIKE '(Recursion:{{!}}Take Cards Into Hand From Discard)' AND CR.GameText RLIKE 'take [^\\.]into hand from[^\\.]discard') OR		("{{{advancedOptions\|}}}" RLIKE '(Recursion:{{!}}Take Cards Into Hand From Discard)' AND CR.GameText RLIKE 'take [^\\.]into hand from[^\\.]discard') OR

Phallen Cassidy: Improving quick filter for "discard from your hand"

2022-12-14T20:45:07Z

Improving quick filter for "discard from your hand"

← Older revision		Revision as of 20:45, 14 December 2022
Line 105:		Line 105:
	("{{{advancedOptions\|}}}" RLIKE '(Cycling:{{!}}Draw Cards)' AND (CR.GameText RLIKE 'draw (up to )?(an?{{!}}X{{!}}\\d{{!}}all{{!}}every{{!}}each) card' AND CR.GameText NOT RLIKE 'opponent shuffle[^\\.]*draw deck and draw' AND CR.GameText NOT RLIKE '(Free Peoples {{!}}Shadow )?player (must {{!}}may )?draw' OR CR.GameText RLIKE 'muster')) OR		("{{{advancedOptions\|}}}" RLIKE '(Cycling:{{!}}Draw Cards)' AND (CR.GameText RLIKE 'draw (up to )?(an?{{!}}X{{!}}\\d{{!}}all{{!}}every{{!}}each) card' AND CR.GameText NOT RLIKE 'opponent shuffle[^\\.]*draw deck and draw' AND CR.GameText NOT RLIKE '(Free Peoples {{!}}Shadow )?player (must {{!}}may )?draw' OR CR.GameText RLIKE 'muster')) OR
	("{{{advancedOptions\|}}}" RLIKE '(Cycling:{{!}}Recover Cards Into Hand)' AND CR.GameText RLIKE 'take [^\\.]*into hand') OR		("{{{advancedOptions\|}}}" RLIKE '(Cycling:{{!}}Recover Cards Into Hand)' AND CR.GameText RLIKE 'take [^\\.]*into hand') OR
	("{{{advancedOptions\|}}}" RLIKE '(Cycling:{{!}}Discard From Your Hand)' AND (CR.GameText ~~RLIKE~~ 'discard ~~(up to )?(an?{{!}}X{{!}}\\d{{!}}all{{!}}every{{!}}each) cards?~~ from hand' AND CR.GameText NOT RLIKE '(opponent ~~must discard~~{{!}}(Free Peoples {{!}}Shadow )?player[^\\.]~~must~~ [^\\.] ~~discard)~~' OR CR.GameText RLIKE 'muster')) OR		("{{{advancedOptions\|}}}" RLIKE '(Cycling:{{!}}Discard From Your Hand)' AND (CR.GameText LIKE 'discard %from hand' AND CR.GameText NOT RLIKE '(opponent{{!}}owner{{!}}(Free Peoples {{!}}Shadow )?player)[^\\.]* discard[^\\.]*from hand' OR CR.GameText RLIKE 'muster')) OR

	("{{{advancedOptions\|}}}" RLIKE '(Recursion:{{!}}Take Cards Into Hand From Discard)' AND CR.GameText RLIKE 'take [^\\.]into hand from[^\\.]discard') OR		("{{{advancedOptions\|}}}" RLIKE '(Recursion:{{!}}Take Cards Into Hand From Discard)' AND CR.GameText RLIKE 'take [^\\.]into hand from[^\\.]discard') OR

Teltura at 00:46, 23 November 2022

2022-11-23T00:46:39Z

← Older revision		Revision as of 00:46, 23 November 2022
Line 158:		Line 158:
	("{{{advancedOptions\|}}}" RLIKE '(Card Manipulation:{{!}}Discard From Your Deck)' AND CR.GameText RLIKE "discards? (up to )?(the{{!}}an?{{!}}X{{!}}\\d{{!}}all{{!}}every{{!}}each)[^\\.]* (from{{!}}of) (the top of )?your draw deck") OR		("{{{advancedOptions\|}}}" RLIKE '(Card Manipulation:{{!}}Discard From Your Deck)' AND CR.GameText RLIKE "discards? (up to )?(the{{!}}an?{{!}}X{{!}}\\d{{!}}all{{!}}every{{!}}each)[^\\.]* (from{{!}}of) (the top of )?your draw deck") OR
	("{{{advancedOptions\|}}}" RLIKE '(Card Manipulation:{{!}}Discard From Opponent''s Deck)' AND CR.GameText RLIKE "discards? (up to )?(the{{!}}an?{{!}}X{{!}}\\d{{!}}all{{!}}every{{!}}each)[^\\.]* (from{{!}}of) (the top of )?(its owners{{!}}(your{{!}}an) opponent's{{!}}his{{!}}his or her{{!}}their) draw deck") OR		("{{{advancedOptions\|}}}" RLIKE '(Card Manipulation:{{!}}Discard From Opponent''s Deck)' AND CR.GameText RLIKE "discards? (up to )?(the{{!}}an?{{!}}X{{!}}\\d{{!}}all{{!}}every{{!}}each)[^\\.]* (from{{!}}of) (the top of )?(its owners{{!}}(your{{!}}an) opponent's{{!}}his{{!}}his or her{{!}}their) draw deck") OR
	("{{{advancedOptions\|}}}" RLIKE '(Card Manipulation:{{!}}Discard From Opponent''s Hand)' AND CR.GameText RLIKE "(discards? (up to )?(an?{{!}}X{{!}}\\d{{!}}all{{!}}every{{!}}each)[^\\.]* from (its owners{{!}}(your{{!}}an) opponent's{{!}}the shadow player''s{{!}}his{{!}}his or her{{!}}their) hand{{!}}(make )?(an opponent{{!}}the shadow player{{!}}the free peoples player{{!}}that player) discard[^\\.]*from hand){{!}}owner discards") OR		("{{{advancedOptions\|}}}" RLIKE '(Card Manipulation:{{!}}Discard From Opponent''s Hand)' AND CR.GameText RLIKE "(discards? (up to )?(an?{{!}}X{{!}}\\d{{!}}all{{!}}every{{!}}each)[^\\.]* from (its owners{{!}}(your{{!}}an) opponent's{{!}}the shadow player''s{{!}}his{{!}}his or her{{!}}their) hand{{!}}((choose{{!}}make) )?(an opponent{{!}}the shadow player{{!}}the free peoples player{{!}}that player)( to)? discard[^\\.]*from hand){{!}}owner discards") OR
	("{{{advancedOptions\|}}}" RLIKE '(Card Manipulation:{{!}}Reveal Opponent''s Hand)' AND CR.GameText RLIKE "(reveal (up to )?(an?{{!}}X{{!}}\\d{{!}}all{{!}}every{{!}}each)[^\\.]* from (its owners{{!}}(your{{!}}an) opponent's{{!}}his{{!}}his or her{{!}}their) hand{{!}}reveal (your{{!}}an) opponent's hand)") OR		("{{{advancedOptions\|}}}" RLIKE '(Card Manipulation:{{!}}Reveal Opponent''s Hand)' AND CR.GameText RLIKE "(reveal (up to )?(an?{{!}}X{{!}}\\d{{!}}all{{!}}every{{!}}each)[^\\.]* from (its owners{{!}}(your{{!}}an) opponent's{{!}}his{{!}}his or her{{!}}their) hand{{!}}reveal (your{{!}}an) opponent's hand)") OR

Teltura at 00:43, 23 November 2022

2022-11-23T00:43:33Z

← Older revision		Revision as of 00:43, 23 November 2022
Line 158:		Line 158:
	("{{{advancedOptions\|}}}" RLIKE '(Card Manipulation:{{!}}Discard From Your Deck)' AND CR.GameText RLIKE "discards? (up to )?(the{{!}}an?{{!}}X{{!}}\\d{{!}}all{{!}}every{{!}}each)[^\\.]* (from{{!}}of) (the top of )?your draw deck") OR		("{{{advancedOptions\|}}}" RLIKE '(Card Manipulation:{{!}}Discard From Your Deck)' AND CR.GameText RLIKE "discards? (up to )?(the{{!}}an?{{!}}X{{!}}\\d{{!}}all{{!}}every{{!}}each)[^\\.]* (from{{!}}of) (the top of )?your draw deck") OR
	("{{{advancedOptions\|}}}" RLIKE '(Card Manipulation:{{!}}Discard From Opponent''s Deck)' AND CR.GameText RLIKE "discards? (up to )?(the{{!}}an?{{!}}X{{!}}\\d{{!}}all{{!}}every{{!}}each)[^\\.]* (from{{!}}of) (the top of )?(its owners{{!}}(your{{!}}an) opponent's{{!}}his{{!}}his or her{{!}}their) draw deck") OR		("{{{advancedOptions\|}}}" RLIKE '(Card Manipulation:{{!}}Discard From Opponent''s Deck)' AND CR.GameText RLIKE "discards? (up to )?(the{{!}}an?{{!}}X{{!}}\\d{{!}}all{{!}}every{{!}}each)[^\\.]* (from{{!}}of) (the top of )?(its owners{{!}}(your{{!}}an) opponent's{{!}}his{{!}}his or her{{!}}their) draw deck") OR
	("{{{advancedOptions\|}}}" RLIKE '(Card Manipulation:{{!}}Discard From Opponent''s Hand)' AND CR.GameText RLIKE "(discards? (up to )?(an?{{!}}X{{!}}\\d{{!}}all{{!}}every{{!}}each)[^\\.]* from (its owners{{!}}(your{{!}}an) opponent's{{!}}the shadow player''s{{!}}his{{!}}his or her{{!}}their)~~? ?~~hand{{!}}make (an opponent{{!}}the shadow player{{!}}the free peoples player{{!}}that player) discard[^\\.]*from hand){{!}}owner discards") OR		("{{{advancedOptions\|}}}" RLIKE '(Card Manipulation:{{!}}Discard From Opponent''s Hand)' AND CR.GameText RLIKE "(discards? (up to )?(an?{{!}}X{{!}}\\d{{!}}all{{!}}every{{!}}each)[^\\.]* from (its owners{{!}}(your{{!}}an) opponent's{{!}}the shadow player''s{{!}}his{{!}}his or her{{!}}their) hand{{!}}(make )?(an opponent{{!}}the shadow player{{!}}the free peoples player{{!}}that player) discard[^\\.]*from hand){{!}}owner discards") OR
	("{{{advancedOptions\|}}}" RLIKE '(Card Manipulation:{{!}}Reveal Opponent''s Hand)' AND CR.GameText RLIKE "(reveal (up to )?(an?{{!}}X{{!}}\\d{{!}}all{{!}}every{{!}}each)[^\\.]* from (its owners{{!}}(your{{!}}an) opponent's{{!}}his{{!}}his or her{{!}}their) hand{{!}}reveal (your{{!}}an) opponent's hand)") OR		("{{{advancedOptions\|}}}" RLIKE '(Card Manipulation:{{!}}Reveal Opponent''s Hand)' AND CR.GameText RLIKE "(reveal (up to )?(an?{{!}}X{{!}}\\d{{!}}all{{!}}every{{!}}each)[^\\.]* from (its owners{{!}}(your{{!}}an) opponent's{{!}}his{{!}}his or her{{!}}their) hand{{!}}reveal (your{{!}}an) opponent's hand)") OR

← Older revision		Revision as of 04:34, 22 June 2023
Line 34:		Line 34:
	AND ("{{{phaseAction\|}}}" = "" OR ((C.CardType IN ('Event') AND "{{{phaseAction\|}}}" LIKE CONCAT('%', CR.Subtypes__full, '%')) OR CR.GameText RLIKE "({{#replace:{{#replace:{{{phaseAction\|}}}:\|,\|:{{!}}}}\|\|}})"))		AND ("{{{phaseAction\|}}}" = "" OR ((C.CardType IN ('Event') AND "{{{phaseAction\|}}}" LIKE CONCAT('%', CR.Subtypes__full, '%')) OR CR.GameText RLIKE "({{#replace:{{#replace:{{{phaseAction\|}}}:\|,\|:{{!}}}}\|\|}})"))

	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+\\)\\.') )		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+\\)\\.') OR ("{{{keyword\|}}}" LIKE '%Hunter%' AND CR.GameText RLIKE '(?<!\\w )Hunter \\d+\\.') )

	AND ("{{{usesKeyword\|}}}" = "" OR (CR.GameText RLIKE '(?<=\\w )({{#replace:{{#replace:{{{usesKeyword\|}}}\|,\|{{!}}}}\|\|}})' AND (1 = CASE WHEN "{{{usesKeyword\|}}}" LIKE '%Archer%' AND CR.GameText LIKE '%Archer%' THEN CR.GameText RLIKE '(?<=\\w )archer\\b' ELSE 1 END )) )		AND ("{{{usesKeyword\|}}}" = "" OR (CR.GameText RLIKE '(?<=\\w )({{#replace:{{#replace:{{{usesKeyword\|}}}\|,\|{{!}}}}\|\|}})' AND (1 = CASE WHEN "{{{usesKeyword\|}}}" LIKE '%Archer%' AND CR.GameText LIKE '%Archer%' THEN CR.GameText RLIKE '(?<=\\w )archer\\b' ELSE 1 END )) )

← Older revision		Revision as of 00:29, 7 June 2023
Line 44:		Line 44:
	AND ("{{{strength\|}}}" = "" OR CASE WHEN "{{{strength\|}}}" RLIKE '(\\+{{!}}-)\\d+' 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\|}}}" RLIKE '(\\+{{!}}-)\\d+' 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)

← Older revision		Revision as of 03:44, 5 January 2023
Line 69:		Line 69:

	AND ("{{{isSanctuary\|any}}}" = "any" OR CASE WHEN {{Boolean\|{{{isSanctuary\|any}}}}} = 1 THEN CR.GameText RLIKE '(?<!\\w )Sanctuary\\.' ELSE CR.GameText NOT RLIKE '(?<!\\w )Sanctuary\\.' END)		AND ("{{{isSanctuary\|any}}}" = "any" OR CASE WHEN {{Boolean\|{{{isSanctuary\|any}}}}} = 1 THEN CR.GameText RLIKE '(?<!\\w )Sanctuary\\.' ELSE CR.GameText NOT RLIKE '(?<!\\w )Sanctuary\\.' END)
	AND ("{{{arrowDir\|Any}}}" = "any" OR ~~{{lc:~~CR.ArrowDir}} = "{{{arrowDir\|any}}}")		AND ("{{{arrowDir\|Any}}}" = "any" OR CR.ArrowDir = "{{{arrowDir\|any}}}")

	AND (CASE WHEN {{Boolean\|{{{isFoil\|no}}}}} = 0 THEN CR.Subset NOT IN ('F', 'A', 'O') ELSE CR.Subset IN ('F', 'A', 'O') END)		AND (CASE WHEN {{Boolean\|{{{isFoil\|no}}}}} = 0 THEN CR.Subset NOT IN ('F', 'A', 'O') ELSE CR.Subset IN ('F', 'A', 'O') END)

← Older revision		Revision as of 03:41, 5 January 2023
Line 69:		Line 69:

	AND ("{{{isSanctuary\|any}}}" = "any" OR CASE WHEN {{Boolean\|{{{isSanctuary\|any}}}}} = 1 THEN CR.GameText RLIKE '(?<!\\w )Sanctuary\\.' ELSE CR.GameText NOT RLIKE '(?<!\\w )Sanctuary\\.' END)		AND ("{{{isSanctuary\|any}}}" = "any" OR CASE WHEN {{Boolean\|{{{isSanctuary\|any}}}}} = 1 THEN CR.GameText RLIKE '(?<!\\w )Sanctuary\\.' ELSE CR.GameText NOT RLIKE '(?<!\\w )Sanctuary\\.' END)
	AND ("{{{arrowDir\|Any}}}" = "any" OR {{~~lowercase~~ CR.ArrowDir}} = "{{{arrowDir\|any}}}")		AND ("{{{arrowDir\|Any}}}" = "any" OR {{lc:CR.ArrowDir}} = "{{{arrowDir\|any}}}")

	AND (CASE WHEN {{Boolean\|{{{isFoil\|no}}}}} = 0 THEN CR.Subset NOT IN ('F', 'A', 'O') ELSE CR.Subset IN ('F', 'A', 'O') END)		AND (CASE WHEN {{Boolean\|{{{isFoil\|no}}}}} = 0 THEN CR.Subset NOT IN ('F', 'A', 'O') ELSE CR.Subset IN ('F', 'A', 'O') END)

← Older revision		Revision as of 03:39, 5 January 2023
Line 68:		Line 68:
	AND ("{{{shadownumLess\|}}}" = "" OR (C.CardType = 'Site' AND IFNULL(CR.ShadowNum, CR.TwilightCost) <= "{{{shadownumLess\|}}}"))		AND ("{{{shadownumLess\|}}}" = "" OR (C.CardType = 'Site' AND IFNULL(CR.ShadowNum, CR.TwilightCost) <= "{{{shadownumLess\|}}}"))

	AND ("{{{isSanctuary\|any}}}" = "~~Any~~" OR CASE WHEN {{Boolean\|{{{isSanctuary\|any}}}}} = 1 THEN CR.GameText RLIKE '(?<!\\w )Sanctuary\\.' ELSE CR.GameText NOT RLIKE '(?<!\\w )Sanctuary\\.' END)		AND ("{{{isSanctuary\|any}}}" = "any" OR CASE WHEN {{Boolean\|{{{isSanctuary\|any}}}}} = 1 THEN CR.GameText RLIKE '(?<!\\w )Sanctuary\\.' ELSE CR.GameText NOT RLIKE '(?<!\\w )Sanctuary\\.' END)
	AND ("{{{arrowDir\|Any}}}" = "~~Any~~" OR CR.ArrowDir = "{{{arrowDir\|~~Any~~}}}")		AND ("{{{arrowDir\|Any}}}" = "any" OR {{lowercase CR.ArrowDir}} = "{{{arrowDir\|any}}}")

	AND (CASE WHEN {{Boolean\|{{{isFoil\|no}}}}} = 0 THEN CR.Subset NOT IN ('F', 'A', 'O') ELSE CR.Subset IN ('F', 'A', 'O') END)		AND (CASE WHEN {{Boolean\|{{{isFoil\|no}}}}} = 0 THEN CR.Subset NOT IN ('F', 'A', 'O') ELSE CR.Subset IN ('F', 'A', 'O') END)