Template:CardSearch: Difference between revisions

From LOTR-TCG Wiki
No edit summary
No edit summary
Line 19: Line 19:
AND ("{{{isErrata|any}}}" = "any" OR CASE WHEN {{Boolean|{{{isErrata|any}}}}} = 0 THEN CR.Revision = 0 WHEN {{Boolean|{{{isErrata|any}}}}} = 1 THEN CR.Revision > 0 END )
AND ("{{{isErrata|any}}}" = "any" OR CASE WHEN {{Boolean|{{{isErrata|any}}}}} = 0 THEN CR.Revision = 0 WHEN {{Boolean|{{{isErrata|any}}}}} = 1 THEN CR.Revision > 0 END )
AND ("{{{languageName|}}}" = "" OR L.Name IN ("{{#replace:{{#replace:{{{languageName}}}|,|","}}||}}"))
AND ("{{{languageName|}}}" = "" OR L.Name IN ("{{#replace:{{#replace:{{{languageName}}}|,|","}}||}}"))
AND ("{{#replace:{{{loreSearch|}}}|"|}}" = "" OR EN.Lore RLIKE {{#replace:{{{loreSearch|}}}|"|}})
AND ("{{#replace:{{{loreSearch|}}}|"|}}" = "" OR EN.Lore RLIKE "{{#replace:{{{loreSearch|}}}|"|}}")


|order by={{{sort|{{CultureSort}}}}}
|order by={{{sort|{{CultureSort}}}}}

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