Form:CardSearch: Difference between revisions
From LOTR-TCG Wiki
No edit summary |
No edit summary |
||
| Line 17: | Line 17: | ||
<span class="heading">Unique?</span>{{{field|isUnique|input type=radiobutton|mandatory|default=any|values=any,yes,no|size=40}}} | <span class="heading">Unique?</span>{{{field|isUnique|input type=radiobutton|mandatory|default=any|values=any,yes,no|size=40}}} | ||
<span class="heading">Title: </span>{{{field|title|input type=text|default=|size=30|placeholder=Title Search Text}}} | <span class="heading">Title: </span>{{{field|title|input type=text|default=|size=30|placeholder=Title regex Search Text}}} | ||
<span class="heading">Subtitle: </span>{{{field|subtitle|input type=text|default=|size=30|placeholder=Subtitle Search Text}}} | <span class="heading">Subtitle: </span>{{{field|subtitle|input type=text|default=|size=30|placeholder=Subtitle regex Search Text}}} | ||
<span class="heading">Side: </span>{{{field|side|input type=tokens|default=|size=40|cargo table=Cards|cargo field=Side|placeholder=Select | <span class="heading">Side: </span>{{{field|side|input type=tokens|default=|size=40|cargo table=Cards|cargo field=Side|placeholder=Select 1 or more from dropdown}}} | ||
<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}}|placeholder=Select | <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}}|placeholder=Select 1 or more from dropdown}}} | ||
<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,|placeholder=Select many from dropdown}}} | <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,|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'|order by=R.SortOrder|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'|order by=R.SortOrder|format=list|no html}}|placeholder=Select 1 or more from dropdown}}} | ||
</div> | </div> | ||
| Line 42: | Line 42: | ||
<span class="heading">Errata</span>{{{field|isErrata|input type=radiobutton|mandatory|default=any|values=any,yes,no|size=40}}} | <span class="heading">Errata</span>{{{field|isErrata|input type=radiobutton|mandatory|default=any|values=any,yes,no|size=40}}} | ||
<span class="heading">Language: </span>{{{field|languageName|input type=tokens|default=English|size=30|cargo table=Languages|cargo field=Name|placeholder=Select from dropdown}}} | <span class="heading">Language: </span>{{{field|languageName|input type=tokens|default=English|size=30|cargo table=Languages|cargo field=Name|placeholder=Select 1 or more from dropdown}}} | ||
<span class="heading">Lore Text Search: </span>{{{field|loreSearch|input type=textarea|autogrow|default=|cols=30|placeholder=Lore | <span class="heading">Lore Text Search: </span>{{{field|loreSearch|input type=textarea|autogrow|default=|cols=30|placeholder=Lore regex search to match}}} | ||
<!-- <span class="heading">Promo Text Search: </span>{{{field|promoSearch|input type=textarea|autogrow|default=|cols=30|placeholder=Lore text to match}}} --> | <!-- <span class="heading">Promo Text Search: </span>{{{field|promoSearch|input type=textarea|autogrow|default=|cols=30|placeholder=Lore text to match}}} --> | ||
| Line 77: | Line 77: | ||
</small></div> | </small></div> | ||
<span class="heading">Signet: </span>{{{field|signet|input type=tokens|default=|size=30|cargo table=CardReleases|cargo field=Signet|placeholder=Select from dropdown}}} | <span class="heading">Signet: </span>{{{field|signet|input type=tokens|default=|size=30|cargo table=CardReleases|cargo field=Signet|placeholder=Select 1 or more from dropdown}}} | ||
</div> | </div> | ||
</div> | </div> | ||
| Line 86: | Line 86: | ||
<div class="title">Site Info</div> | <div class="title">Site Info</div> | ||
<span class="heading">Block: </span>{{{field|block|input type=tokens|default=|size=30| | <span class="heading">Block: </span>{{{field|block|input type=tokens|default=|size=30|values=Fellowship,Towers,King,Shadows,Hobbit|placeholder=Select 1 or more from dropdown}}} | ||
<span class="heading">Site Number: </span>{{{field|sitesitenum|input type=text|default=|size=12|placeholder=}}} | <span class="heading">Site Number: </span>{{{field|sitesitenum|input type=text|default=|size=12|placeholder=}}} | ||
