Template:CardSplashImage: Difference between revisions
From LOTR-TCG Wiki
No edit summary |
No edit summary |
||
(2 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
<includeonly> | <includeonly>{{#if:{{#pos:{{{1}}}|0}}{{#pos:{{{1}}}|1}}{{#pos:{{{1}}}|2}}{{#pos:{{{1}}}|3}}{{#pos:{{{1}}}|4}}{{#pos:{{{1}}}|5}}{{#pos:{{{1}}}|6}}{{#pos:{{{1}}}|7}}{{#pos:{{{1}}}|8}}{{#pos:{{{1}}}|9}}|{{#cargo_query: | ||
{{#if:{{#pos:{{{1}}}|0}}{{#pos:{{{1}}}|1}}{{#pos:{{{1}}}|2}}{{#pos:{{{1}}}|3}}{{#pos:{{{1}}}|4}}{{#pos:{{{1}}}|5}}{{#pos:{{{1}}}|6}}{{#pos:{{{1}}}|7}}{{#pos:{{{1}}}|8}}{{#pos:{{{1}}}|9}}|{{#cargo_query: | |||
tables=Cards=C,CardReleases=CR,CardReleases=ECR | tables=Cards=C,CardReleases=CR,CardReleases=ECR | ||
|join on= C.ID = CR.BaseCardID,ECR.ID = C.ID | |join on= C.ID = CR.BaseCardID,ECR.ID = C.ID | ||
|fields= REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle | |fields= REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle | ||
, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile | , IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile | ||
, {{{2| | , TRIM('{{{2|}}}')=Blurb | ||
, {{{3| | , TRIM('{{{3|}}}')=Size | ||
|where= CR.ID = '{{IDLookup|{{{1}}}|{{{4|EN}}}}}' | |where= CR.ID = '{{IDLookup|{{{1}}}|{{{4|EN}}}}}' | ||
|format=template | |format=template | ||
Line 18: | Line 17: | ||
|fields= REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle | |fields= REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle | ||
, IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile | , IFNULL(CR.ImageFilename,'File:Card_Not_Found.jpg')=ImageFile | ||
, {{{2|}}}=Blurb | , TRIM('{{{2|}}}')=Blurb | ||
, {{{3|}}}=Size | , TRIM('{{{3|}}}')=Size | ||
|where= (C.Title LIKE '{{#replace:{{{1}}}|'|''}}' OR C.Subtitle LIKE '{{#replace:{{{1}}}|'|''}}' OR (C.Title LIKE '{{#explode:{{#replace:{{{1}}}|'|''}}|, |0}}' AND C.Subtitle LIKE TRIM('{{#explode:{{#replace:{{{1}}}|'|''}}|, |1}}'))) AND CR.LanguageCode = '{{{4|EN}}}' | |where= (C.Title LIKE '{{#replace:{{{1}}}|'|''}}' OR C.Subtitle LIKE '{{#replace:{{{1}}}|'|''}}' OR (C.Title LIKE '{{#explode:{{#replace:{{{1}}}|'|''}}|, |0}}' AND C.Subtitle LIKE TRIM('{{#explode:{{#replace:{{{1}}}|'|''}}|, |1}}'))) AND CR.LanguageCode = '{{{4|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 |