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}}} |