Template:CardSearch: Difference between revisions

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


AND ("{{{race|}}}" = "" OR (C.CardType IN ('Minion', 'Companion', 'Ally') AND ("{{{race|}}}" LIKE CONCAT('%', CR.Subtypes__full, '%') OR ("{{{race|}}}" = "[Raceless]" AND CR.Subtypes__full IS NULL AND CR.Revision = 0)) ))
AND ("{{{race|}}}" = "" OR (C.CardType IN ('Minion', 'Companion', 'Ally') AND ("{{{race|}}}" LIKE CONCAT('%', CR.Subtypes__full, '%') OR ("{{{race|}}}" = "[Raceless]" AND CR.Subtypes__full IS NULL AND CR.Revision = 0)) ))
AND ("{{{usesRace|}}}" = "" OR CR.GameText RLIKE "({{#replace:{{#replace:{{{usesRace|}}}|,|{{!}}}}||}})" OR ("{{{usesRace|}}}" LIKE '%Dwarf%' AND CR.GameText LIKE 'Dwarves') OR ("{{{usesRace|}}}" LIKE '%Elf%' AND CR.GameText LIKE 'Elves') )
AND ("{{{usesRace|}}}" = "" OR CR.GameText RLIKE "({{#replace:{{#replace:{{{usesRace|}}}|,|{{!}}}}||}})" OR ("{{{usesRace|}}}" LIKE '%Dwarf%' AND CR.GameText LIKE '%Dwarves%') OR ("{{{usesRace|}}}" LIKE '%Elf%' AND CR.GameText LIKE '%Elves%') )





Revision as of 10:05, 26 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.