Form:CardSearch: Difference between revisions

From LOTR-TCG Wiki
No edit summary
No edit summary
Line 11: Line 11:
{{{for template|BaseCard}}}
{{{for template|BaseCard}}}


<div class="sidebar flex" >
<div class="flex">
 
<div class="sidebar flex" style="max-width:300px">
<div class="title">Card Info</div>
<div class="title">Card Info</div>
<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=40|placeholder=Title Search Text}}}
<span class="heading">Title: </span>{{{field|title|input type=text|default=|size=30|placeholder=Title Search Text}}}


<span class="heading">Subtitle: </span>{{{field|subtitle|input type=text|default=|size=40|placeholder=Subtitle Search Text}}}
<span class="heading">Subtitle: </span>{{{field|subtitle|input type=text|default=|size=30|placeholder=Subtitle Search Text}}}


<span class="heading">Side: </span>{{{field|side|input type=tokens|default=|size=40|cargo table=Cards|cargo field=Side|placeholder=Select from dropdown}}}
<span class="heading">Side: </span>{{{field|side|input type=tokens|default=|size=40|cargo table=Cards|cargo field=Side|placeholder=Select from dropdown}}}


<span class="heading">Culture: </span>{{{field|culture|input type=tokens|default=|size=40|cargo table=Cards|cargo field=Culture|placeholder=Select 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">Rarity: </span>{{{field|rarityabbr|input type=tokens|default=|size=40|values=C,U,R,R+,RF,O,P,D|placeholder=Select from dropdown}}}
</div>
 
 
 
<div class="sidebar flex" style="max-width:250px">
<div class="title">Collection Info</div>
<span class="heading">Foil</span>{{{field|isFoil|input type=radiobutton|mandatory|default=any|values=any,yes,no|size=40}}}
 
<span class="heading">Physical</span>{{{field|isPhysical|input type=radiobutton|mandatory|default=any|values=any,yes,no|size=40}}}
 
<span class="heading">Playable</span>{{{field|isPlayable|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">Card Type: </span>{{{field|cardtype|input type=tokens|default=|size=40|cargo table=Cards|cargo field=CardType|placeholder=Select from dropdown}}}
<span class="heading">Language: </span>{{{field|languageName|input type=tokens|default=|size=30|cargo table=Languages|cargo field=Name|placeholder=Select 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">Lore Text Search: </span>{{{field|loreSearch|input type=textarea|autogrow|default=|cols=30|placeholder=Lore text to match}}}


<span class="heading">Rarity: </span>{{{field|rarityabbr|input type=tokens|default=|size=40|values=C,U,R,R+,RF,O,P,D|placeholder=Select from dropdown}}}
<span class="heading">Promo Text Search: </span>{{{field|promoSearch|input type=textarea|autogrow|default=|cols=30|placeholder=Lore text to match}}}
</div>
</div>


<div class="sidebar flex" style="max-width:200px">
<div class="sidebar flex" style="max-width:200px">
Line 62: Line 80:




 
<div class="sidebar flex" style="max-width:300px">
<div class="sidebar flex" style="max-width:250px">
<div class="title">Collection Info</div>
<span class="heading">Foil</span>{{{field|isFoil|input type=radiobutton|mandatory|default=any|values=any,yes,no|size=40}}}
 
<span class="heading">Physical</span>{{{field|isPhysical|input type=radiobutton|mandatory|default=any|values=any,yes,no|size=40}}}
 
<span class="heading">Playable</span>{{{field|isPlayable|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=|size=30|cargo table=Languages|cargo field=Name|placeholder=Select from dropdown}}}
</div>
 
 
<div class="sidebar flex" style="max-width:320px">
<div class="content mw-collapsible mw-collapsed" data-expandtext="Show more" data-collapsetext="Show less">
<div class="content mw-collapsible mw-collapsed" data-expandtext="Show more" data-collapsetext="Show less">
<div class="title">Site Info</div>
<div class="title">Site Info</div>
Line 95: Line 98:




 
<div class="sidebar flex" style="max-width:300px">
<div class="sidebar flex" style="max-width:320px">
<div>
<div class="content mw-collapsible mw-collapsed" data-expandtext="Show more" data-collapsetext="Show less">
<div class="content mw-collapsible mw-collapsed" data-expandtext="Show more" data-collapsetext="Show less">
<div class="title">Game Text</div>
<div class="title">Game Text</div>
Line 107: Line 110:


</div>
</div>
</div>
<div>
<div class="content mw-collapsible mw-collapsed" data-expandtext="Show more" data-collapsetext="Show less">
<span class="heading">Culture: </span>{{{field|culture|input type=tokens|default=|size=40|cargo table=Cards|cargo field=Culture|placeholder=Select from dropdown}}}
  <div class="mw-collapsible-content">
<!--    --><span class="heading">Targets Culture</span><small><i> (OR)</i></small>: {{{field|targetsCulture|input type=tokens|default=|size=40|cargo table=Cards|cargo field=Culture|placeholder=Select from dropdown}}}
</div>
<span class="heading">Card Type: </span>{{{field|cardtype|input type=tokens|default=|size=40|cargo table=Cards|cargo field=CardType|placeholder=Select from dropdown}}}
  <div class="mw-collapsible-content">
<!--    --><span class="heading">Targets Card Type</span><small><i> (OR)</i></small>: {{{field|targetsCardtype|input type=tokens|default=|size=40|cargo table=Cards|cargo field=CardType|placeholder=Select from dropdown}}}
</div>


<span class="heading">Has Keywords: </span>{{{field|textSearch|input type=tokens|default=|size=20|values={{#cargo_query:tables=Cards=C,CardReleases=CR|join on=C.ID = CR.ID|fields=CR.Subtypes|where=C.CardType IN ('Artifact', 'Possession') AND Subtypes__full NOT LIKE '' AND Subtypes__full NOT LIKE '%•%'|format=list|more results text=|group by=Subtypes__full}}|placeholder=Game Text to match}}}
<span class="heading">Has Race</span><small><i> (OR)</i></small>: {{{field|race|input type=tokens|default=|size=40|values=
{{#cargo_query:tables=Cards=C,CardReleases=CR|join on=C.ID = CR.ID|fields=IF(CR.Subtypes__full IS NULL, '[Raceless]', REPLACE(CR.Subtypes__full, ',', ' • '))|where=C.CardType IN ('Companion', 'Ally', 'Minion')|format=list|group by=Subtypes__full|no html}}|placeholder=Select from dropdown}}}


{{{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}}}
  <div class="mw-collapsible-content">
<!--    --><span class="heading">Targets Race</span><small><i> (OR)</i></small>: {{{field|targetsRace|input type=tokens|default=|size=40|values=
{{#cargo_query:tables=Cards=C,CardReleases=CR|join on=C.ID = CR.ID|fields=IF(CR.Subtypes__full IS NULL, '[Raceless]', REPLACE(CR.Subtypes__full, ',', ' • '))|where=C.CardType IN ('Companion', 'Ally', 'Minion')|format=list|group by=Subtypes__full|no html}}|placeholder=Select from dropdown}}}


{{{field|setnum|input type=combobox|default=|size=40|values={{#cargo_query:tables=Cards=C,CardReleases=CR|join on=C.ID = CR.ID|fields=CR.Subtypes|where=C.CardType IN ('Artifact', 'Possession') AND Subtypes__full NOT LIKE '' AND Subtypes__full NOT LIKE '%•%'|format=list|more results text=|group by=Subtypes__full}}|placeholder=Type single # or pick block}}}
</div>
 
 
<span class="heading">Has Item Class</span><small><i> (OR)</i></small>: {{{field|itemClass|input type=tokens|default=|size=40|values=
{{#cargo_query:tables=Cards=C,CardReleases=CR|join on=C.ID = CR.ID|fields=IF(CR.Subtypes__full IS NULL, '[Classless]', REPLACE(CR.Subtypes__full, ',', ' • '))|where=C.CardType IN ('Artifact', 'Possession')|format=list|group by=Subtypes__full|no html}}|placeholder=Select from dropdown}}}
 
  <div class="mw-collapsible-content">
<!--    --><span class="heading">Targets Item Class</span><small><i> (OR)</i></small>: {{{field|targetsItemClass|input type=tokens|default=|size=40|values=
{{#cargo_query:tables=Cards=C,CardReleases=CR|join on=C.ID = CR.ID|fields=IF(CR.Subtypes__full IS NULL, '[Classless]', REPLACE(CR.Subtypes__full, ',', ' • '))|where=C.CardType IN ('Artifact', 'Possession')|format=list|group by=Subtypes__full|no html}}|placeholder=Select from dropdown}}}
 
</div>


{{#cargo_query:tables=Cards=C,CardReleases=CR|join on=C.ID = CR.ID|fields=CR.Subtypes|where=C.CardType IN ('Artifact', 'Possession') AND Subtypes__full NOT LIKE ''|format=list|more results text=|group by=Subtypes__full}}


{{#listunique:list=A,A,A,B,C,C|insep=,|outsep=.}}
<span class="heading">Has Keyword</span><small><i> (OR)</i></small>: {{{field|keyword|input type=tokens|default=|size=40|values=
{{#cargo_query:tables=Cards=C,CardReleases=CR|join on=C.ID = CR.ID|fields=IF(CR.Subtypes__full IS NULL, '[Raceless]', REPLACE(CR.Subtypes__full, ',', ' • '))|where=C.CardType IN ('Companion', 'Ally', 'Minion')|format=list|group by=Subtypes__full|no html}}|placeholder=Select from dropdown}}}


  <div class="mw-collapsible-content">
<!--    --><span class="heading">Targets Keyword</span><small><i> (OR)</i></small>: {{{field|targetsKeyword|input type=tokens|default=|size=40|values=
{{#cargo_query:tables=Cards=C,CardReleases=CR|join on=C.ID = CR.ID|fields=IF(CR.Subtypes__full IS NULL, '[Raceless]', REPLACE(CR.Subtypes__full, ',', ' • '))|where=C.CardType IN ('Companion', 'Ally', 'Minion')|format=list|group by=Subtypes__full|no html}}|placeholder=Select from dropdown}}}


 
</div>


</div>
</div>


</div>
</div>
</div>
</div>


<div class="sidebar flex" style="max-width:300px">
<div class="title">Advanced Search</div>
<span class="heading">Costs</span>{{{field|advancedCost|input type=checkboxes|default=|values=Cost Reduction, Cost Increase, Burden Adding to Play, Burden Removing to Play, Threat Adding to Play, Threat Removing to Play, Token Removing to Play, Discard From Hand to Play, Remove From Game to Play, Exert to Play|size=40|class=flex}}}
</div>


</div>
   
   


{| class="formtable"
{| class="formtable"
|-
! Subtypes:
| {{{field|Subtypes}}}
|-
|-


! Game Text:
| {{{field|GameText}}}
|-
! Tagged Game Text:
| {{{field|TaggedGameText}}}
|-
|-
! Lore:  
! Lore:  

Revision as of 08:24, 22 January 2022

Run query

Retrieved from "https://wiki.lotrtcgpc.net/index.php?title=Form:CardSearch&oldid=100372"