Template:CardSearch: Difference between revisions

From LOTR-TCG Wiki
mNo edit summary
(Only the appropriate sites should appear when filtering by format)
Line 12: Line 12:
AND ("{{{subtitle|}}}" = "" OR C.Subtitle RLIKE "{{{subtitle|}}}")
AND ("{{{subtitle|}}}" = "" OR C.Subtitle RLIKE "{{{subtitle|}}}")
AND ("{{{side|}}}" = "" OR C.Side = "{{{side|}}}")
AND ("{{{side|}}}" = "" OR C.Side = "{{{side|}}}")
AND ("{{{format|}}}" = "" OR (F.Name = "{{{format|}}}" AND F.XList HOLDS NOT C.CollInfo))
AND ("{{{format|}}}" = "" OR (F.Name = "{{{format|}}}" AND ((C.CardType != 'Site' AND F.XList HOLDS NOT C.CollInfo) OR (C.CardType = 'Site' AND CR.Block = F.SitePath))))
AND ("{{{creator|}}}" = "" OR "{{{creator|}}}" LIKE CONCAT('%', S.Creator, '%'))
AND ("{{{creator|}}}" = "" OR "{{{creator|}}}" LIKE CONCAT('%', S.Creator, '%'))
AND ("{{{setnums|}}}" = "" OR "{{{setnums|}}}" LIKE CONCAT('%', S.Name, '%'))
AND ("{{{setnums|}}}" = "" OR "{{{setnums|}}}" LIKE CONCAT('%', S.Name, '%'))

Revision as of 19:36, 26 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.