Template:Card: Difference between revisions
From LOTR-TCG Wiki
No edit summary Tag: Manual revert |
No edit summary |
||
| Line 23: | Line 23: | ||
, IFNULL(CR.Subtitle,ECR.Subtitle)=Subtitle | , IFNULL(CR.Subtitle,ECR.Subtitle)=Subtitle | ||
, IFNULL(CR.CollInfo,C.CollInfo)=CollInfo | , IFNULL(CR.CollInfo,C.CollInfo)=CollInfo | ||
|where= (C.Subtitle LIKE '{{#replace:{{{1}}}|'|''}}' OR C.Title LIKE '{{#replace:{{{1}}}|'|''}}' OR (C.Title LIKE '{{#explode:{{#replace:{{{1}}}|'|''}}|, |0}}' AND C.Subtitle LIKE TRIM('{{#explode:{{#replace:{{{1}}}|'|''}}|,|1}}'))) AND CR.LanguageCode = '{{{2|EN}}}' | |where= (C.Subtitle LIKE '{{#replace:{{{1}}}|'|''}}' OR C.Title LIKE '{{#replace:{{{1}}}|'|''}}' OR (C.Title LIKE '{{#explode:{{#replace:{{{1}}}|'|''}}|, |0}}' AND C.Subtitle LIKE TRIM('{{#explode:{{#replace:{{{1}}}|'|''}}|, |1}}'))) AND CR.LanguageCode = '{{{2|EN}}}' | ||
|order by=CASE WHEN C.SetNum = '0' THEN 100 ELSE CASE WHEN C.SETNUM REGEXP '^-?[0-9]+$' THEN CAST(C.SetNum AS UNSIGNED INTEGER) ELSE 100 END END, CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'P' THEN 0 WHEN C.Subset = 'D' THEN 1 ELSE 10 END, C.CardNum | |order by=CASE WHEN C.SetNum = '0' THEN 100 ELSE CASE WHEN C.SETNUM REGEXP '^-?[0-9]+$' THEN CAST(C.SetNum AS UNSIGNED INTEGER) ELSE 100 END END, CASE WHEN C.Subset = 'S' THEN 0 WHEN C.Subset = 'F' THEN 1 WHEN C.Subset = 'P' THEN 0 WHEN C.Subset = 'D' THEN 1 ELSE 10 END, C.CardNum | ||
|limit=1 | |limit=1 | ||
Revision as of 02:03, 20 October 2021
This is the "Card" template.
It should be called in the following format:
{{Card
|1=
|2=
}}
Edit the page to see the template text.
