Form:CardSearch: Difference between revisions

From LOTR-TCG Wiki
No edit summary
No edit summary
Line 13: Line 13:
{{{for template|CardSearch}}}
{{{for template|CardSearch}}}


{{#cargo_query:tables=Formats=F|fields=F.Name|order by=CASE WHEN F.Name = "Fellowship Block" THEN 1 WHEN F.Name = "Movie Block" THEN 2 WHEN F.Name = "Expanded" THEN 3 WHEN F.Name LIKE "Towers%" THEN 4 WHEN F.Name = "King Standard" THEN 5 WHEN F.Name = "King Block" THEN 6 WHEN F.Name LIKE "War of the Ring%" THEN 7 WHEN F.Name = "Standard" THEN 8 ELSE 9 END, F.Name|format=list|nohtml}}
{{#replace:{{#cargo_query:tables=Formats=F|fields=F.Name|order by=CASE WHEN F.Name = "Fellowship Block" THEN 1 WHEN F.Name = "Movie Block" THEN 2 WHEN F.Name = "Expanded" THEN 3 WHEN F.Name LIKE "Towers%" THEN 4 WHEN F.Name = "King Standard" THEN 5 WHEN F.Name = "King Block" THEN 6 WHEN F.Name LIKE "War of the Ring%" THEN 7 WHEN F.Name = "Standard" THEN 8 ELSE 9 END, F.Name|format=list|nohtml}}|, |,}}


<div class="flex">
<div class="flex">
Line 29: Line 29:
<span class="heading">Creator: </span>{{{field|creator|input type=tokens|default=Decipher,Player's Council|size=40|values={{#cargo_query:tables=CardSets=S|fields=S.Creator|where=S.Creator NOT IN ('mLOTRO', 'Aradrissar')|group by=S.Creator|order by=CASE WHEN S.Creator = 'Decipher' THEN 0 WHEN S.Creator = "Player's Council" THEN 1 ELSE 2 END, S.Creator|format=list|no html}}|existing values only|placeholder=Select 1 or more}}}
<span class="heading">Creator: </span>{{{field|creator|input type=tokens|default=Decipher,Player's Council|size=40|values={{#cargo_query:tables=CardSets=S|fields=S.Creator|where=S.Creator NOT IN ('mLOTRO', 'Aradrissar')|group by=S.Creator|order by=CASE WHEN S.Creator = 'Decipher' THEN 0 WHEN S.Creator = "Player's Council" THEN 1 ELSE 2 END, S.Creator|format=list|no html}}|existing values only|placeholder=Select 1 or more}}}


<span class="heading">Format: </span>{{{field|format|input type=dropdown|default=|size=40|values={{#replace:{{#cargo_query:tables=Formats=F|fields=F.Name|order by=CASE WHEN F.Name = "Fellowship Block" THEN 1 WHEN F.Name = "Movie Block" THEN 2 WHEN F.Name = "Expanded" THEN 3 WHEN F.Name LIKE "Towers%" THEN 4 WHEN F.Name = "King Standard" THEN 5 WHEN F.Name = "King Block" THEN 6 WHEN F.Name LIKE "War of the Ring%" THEN 7 WHEN F.Name = "Standard" THEN 8 ELSE 9 END, F.Name|format=list|nohtml}}|, |,}}|existing values only|placeholder=Select 1}}}
<span class="heading">Format: </span>{{{field|format|input type=dropdown|default=|size=40|values=test1, test2, test3|existing values only|placeholder=Select 1}}}


<span class="heading">Set#: </span>{{{field|setnums|input type=tokens|default=|size=40|values=1 - The Fellowship of the Ring,2 - Mines of Moria,3 - Realms of the Elf-lords,4 - The Two Towers,5 - Battle of Helm's Deep,6 - Ents of Fangorn,7 - The Return of the King,8 - Siege of Gondor,9 - Reflections,10 - Mount Doom,11 - Shadows,12 - Black Rider,13 - Bloodlines,14 - Expanded Middle-earth, 15 - The Hunters, 16 - The Wraith Collection, 17 - Rise of Saruman, 18 - Treachery & Deceit,19 - Age's End,V1 - Shadow of the Past|existing values only|placeholder=Select 1 or more}}}
<span class="heading">Set#: </span>{{{field|setnums|input type=tokens|default=|size=40|values=1 - The Fellowship of the Ring,2 - Mines of Moria,3 - Realms of the Elf-lords,4 - The Two Towers,5 - Battle of Helm's Deep,6 - Ents of Fangorn,7 - The Return of the King,8 - Siege of Gondor,9 - Reflections,10 - Mount Doom,11 - Shadows,12 - Black Rider,13 - Bloodlines,14 - Expanded Middle-earth, 15 - The Hunters, 16 - The Wraith Collection, 17 - Rise of Saruman, 18 - Treachery & Deceit,19 - Age's End,V1 - Shadow of the Past|existing values only|placeholder=Select 1 or more}}}

Revision as of 03:53, 22 October 2022