Template:CardSearch: Difference between revisions

From LOTR-TCG Wiki
No edit summary
No edit summary
Line 11: Line 11:


|where= ('{{{isUnique|any}}}' = 'any' OR CR.IsUnique = {{Boolean|{{{isUnique|any}}}}})  
|where= ('{{{isUnique|any}}}' = 'any' OR CR.IsUnique = {{Boolean|{{{isUnique|any}}}}})  
AND ("{{{title|}}}" = "" OR CR.Title RLIKE "{{{title|}}}")
AND ("{{{title|}}}" = "" OR C.Title RLIKE "{{{title|}}}")
AND ("{{{subtitle|}}}" = "" OR CR.Subtitle RLIKE "{{{subtitle|}}}")
AND ("{{{subtitle|}}}" = "" OR C.Subtitle RLIKE "{{{subtitle|}}}")
AND ("{{{side|}}}" = "" OR C.Side = "{{{side|}}}")
AND ("{{{side|}}}" = "" OR C.Side = "{{{side|}}}")
AND ("{{{creator|}}}" = "" OR "{{{creator|}}}" LIKE CONCAT('%', S.Creator, '%'))
AND ("{{{creator|}}}" = "" OR "{{{creator|}}}" LIKE CONCAT('%', S.Creator, '%'))
Line 113: Line 113:
("{{{advancedOptions|}}}" RLIKE '(Recursion:{{!}}Take Cards Into Hand From Deck)' AND CR.GameText RLIKE 'take [^\\.]*into hand from[^\\.]*draw deck') OR
("{{{advancedOptions|}}}" RLIKE '(Recursion:{{!}}Take Cards Into Hand From Deck)' AND CR.GameText RLIKE 'take [^\\.]*into hand from[^\\.]*draw deck') OR
("{{{advancedOptions|}}}" RLIKE '(Recursion:{{!}}Play Cards From Discard)' AND CR.GameText RLIKE 'play (up to )?(an?{{!}}X{{!}}\\d{{!}}all{{!}}every{{!}}each) (\\[\\w+\\] )?\\w from your discard pile') OR
("{{{advancedOptions|}}}" RLIKE '(Recursion:{{!}}Play Cards From Discard)' AND CR.GameText RLIKE 'play (up to )?(an?{{!}}X{{!}}\\d{{!}}all{{!}}every{{!}}each) (\\[\\w+\\] )?\\w from your discard pile') OR
   
 
   
 
   
 
 





Revision as of 09:02, 5 October 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.