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.