Template:CardSearch: Difference between revisions
From LOTR-TCG Wiki
No edit summary |
No edit summary |
||
| Line 30: | Line 30: | ||
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%') ) | ||
AND ("{{{itemClass|}}}" = "" OR (C.CardType IN ('Artifact', 'Possession') AND ("{{{itemClass|}}}" LIKE CONCAT('%', CR.Subtypes__full, '%') OR ("{{{itemClass|}}}" = "[Classless]" AND CR.Subtypes__full IS NULL AND CR.Revision = 0)) )) | |||
Revision as of 10:10, 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.
