Form:CardSearch: Difference between revisions

From LOTR-TCG Wiki
No edit summary
No edit summary
Line 53: Line 53:
<div class="content mw-collapsible" data-expandtext="Show more" data-collapsetext="Show less">
<div class="content mw-collapsible" data-expandtext="Show more" data-collapsetext="Show less">


<span class="heading">Has Culture</span><small><i> (OR)</i></small>: {{{field|culture|input type=tokens|default=|size=40|values={{#cargo_query:tables=Cards=C,CardSets=S|join on=C.SetNum=S.ID|fields=C.Culture|group by=C.Culture|order by=CASE WHEN S.Creator = 'Decipher' THEN 0 WHEN S.Creator = "Player's Council" THEN 1 WHEN S.Creator = "-Enola-" THEN 3 ELSE 4 END, CASE WHEN C.Culture = "The One Ring" THEN 0 WHEN C.Culture = "Site" THEN 100 ELSE 1 END, C.ID, C.Culture|format=list|no html}}|placeholder=Select 1 or more}}}
<span class="heading">Has Culture</span><small><i> (OR)</i></small>: {{{field|culture|input type=tokens|default=|size=40|values={{#cargo_query:tables=Cards=C,CardSets=S|join on=C.SetNum=S.ID|fields=C.Culture|group by=C.Culture|order by=CASE WHEN S.Creator = 'Decipher' THEN 0 WHEN S.Creator = "Player's Council" THEN 1 WHEN S.Creator = "-Enola-" THEN 3 ELSE 4 END, CASE WHEN C.Culture = "The One Ring" THEN 0 WHEN C.Culture = "Site" THEN 100 ELSE 1 END, CASE WHEN S.ID = "0" THEN 100 ELSE 0 END, C.ID, C.Culture|format=list|no html}}|placeholder=Select 1 or more}}}
<div class="mw-collapsible-content">
<div class="mw-collapsible-content">
<!--    --><span class="heading">Uses Culture</span><small><i> (OR)</i></small>: {{{field|targetsCulture|input type=tokens|default=|size=40|cargo table=Cards|cargo field=Culture|placeholder=Select 1 or more}}}
<!--    --><span class="heading">Uses Culture</span><small><i> (OR)</i></small>: {{{field|targetsCulture|input type=tokens|default=|size=40|cargo table=Cards|cargo field=Culture|placeholder=Select 1 or more}}}

Revision as of 03:39, 26 September 2022