Form:CardSearch: Difference between revisions

From LOTR-TCG Wiki
No edit summary
No edit summary
Line 25: Line 25:
<span class="heading">Creator: </span>{{{field|creator|input type=tokens|default=|size=40|cargo table=CardSets|cargo field=Creator|placeholder=Select many from dropdown}}}
<span class="heading">Creator: </span>{{{field|creator|input type=tokens|default=|size=40|cargo table=CardSets|cargo field=Creator|placeholder=Select many from dropdown}}}


<span class="heading">Set#: </span>{{{field|setnum|input type=combobox|default=|size=40|values=All,Fellowship Block,Towers Block,King Block,Movie Block,War of the Ring Block,Hunters Block,Hobbit Draft Game|placeholder=Type single # or pick block}}}
<span class="heading">Set#: </span>{{{field|setnums|input type=tokens|default=|size=40|cargo table=CardSets|cargo field=ID|placeholder=Select many from dropdown}}}


<span class="heading">Rarity: </span>{{{field|rarityabbr|input type=tokens|default=|size=40|values={{#cargo_query:tables=Rarities=R|fields=CONCAT(R.Name, ' (', R.Abbr, ')')|where=R.Sets HOLDS NOT '30' AND R.Sets HOLDS NOT '31'|format=list|no html}}|placeholder=Select from dropdown}}}
<span class="heading">Rarity: </span>{{{field|rarityabbr|input type=tokens|default=|size=40|values={{#cargo_query:tables=Rarities=R|fields=CONCAT(R.Name, ' (', R.Abbr, ')')|where=R.Sets HOLDS NOT '30' AND R.Sets HOLDS NOT '31'|format=list|no html}}|placeholder=Select from dropdown}}}

Revision as of 05:10, 25 September 2022