Form:CardSearch: Difference between revisions

From LOTR-TCG Wiki
No edit summary
(Fixing Race, Item Class, and Rarity filters not working properly)
 
(169 intermediate revisions by 2 users not shown)
Line 3: Line 3:
<!--{{#forminput:form=}}-->
<!--{{#forminput:form=}}-->
</noinclude><includeonly>
</noinclude><includeonly>
{{{standard input|run query|label=Run query|class=button}}}
{{{standard input|run query|label=Run query|class=button}}}  
 
[[Special:RunQuery/CardSearch|{{Button| <big>✕</big>  Clear Form|color=red}}]]


__NOTOC____NOEDITSECTION__<!--
__NOTOC____NOEDITSECTION__<!--
Line 9: Line 11:


<div id="wikiPreview" style="display: none; padding-bottom: 25px; margin-bottom: 25px; border-bottom: 1px solid #AAAAAA;"></div>
<div id="wikiPreview" style="display: none; padding-bottom: 25px; margin-bottom: 25px; border-bottom: 1px solid #AAAAAA;"></div>
{{{for template|BaseCard}}}
{{{for template|CardSearch}}}
 
<span class="heading">Format: </span>{{{field|format|input type=dropdown|default=|size=40|values={{#cargo_query:tables=Formats=F|fields=F.Name|order by=CASE WHEN F.Name LIKE "%Fellowship%" THEN 1 WHEN F.Name LIKE "%Movie%" THEN 2 WHEN F.Name LIKE "%Expanded%" THEN 3 WHEN F.Name LIKE "Towers%" THEN 4 WHEN F.Name = "King Standard" THEN 5 WHEN F.Name = "King Block" THEN 6 WHEN F.Name LIKE "War of the Ring%" THEN 7 WHEN F.Name = "Standard" THEN 8 ELSE 9 END, F.Name|format=list|no html}}|existing values only|placeholder=Select 1}}}


<div class="flex">
<div class="flex">
<div class="sidebar flex" style="max-width:250px">
<div class="title">Basic Attributes</div>


<div class="sidebar flex" style="max-width:300px">
<span class="heading">Side: </span>{{{field|side|input type=tokens|default=|size=40|cargo table=Cards|cargo field=Side|existing values only|placeholder=Select 1 or more}}}
<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">Title: </span>{{{field|title|input type=text|default=|size=30|placeholder=Title Search Text}}}
<span class="heading">Is Culture</span><small><i> (OR)</i></small>: {{{field|culture|input type=tokens|default=|size=40|values={{#cargo_query:tables=Cultures=CU|fields=CU.Name|order by=CU.SortOrder|where=CU.Name NOT IN ('The One Ring', 'Site')|format=list|no html}}|existing values only|placeholder=Select 1 or more}}}


<span class="heading">Subtitle: </span>{{{field|subtitle|input type=text|default=|size=30|placeholder=Subtitle Search Text}}}
<span class="heading">Is Card Type</span><small><i> (OR)</i></small>: {{{field|cardtype|input type=tokens|default=|size=40|cargo table=Cards|cargo field=CardType|existing values only|placeholder=Select 1 or more}}}


<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">Is 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]', CR.Subtypes__full)|where=C.CardType IN ('Companion', 'Ally', 'Minion')|format=template|template=TagFilterOutput|group by=Subtypes__full|order by=CASE WHEN CR.Subtypes__full IS NULL THEN 0 ELSE 1 END,CR.Subtypes__full|no html}}|existing values only|placeholder=Select 1 or more}}}


<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">Is 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]', CR.Subtypes__full)|where=C.CardType IN ('Artifact', 'Possession') AND (CR.Subtypes__full IS NULL OR CR.Subtypes__full NOT LIKE '%,%') |format=template|template=TagFilterOutput|group by=Subtypes__full|order by=CASE WHEN CR.Subtypes__full IS NULL THEN 0 ELSE 1 END,CR.Subtypes__full|no html}}|existing values only|placeholder=Select 1 or more}}}


<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">Phase Action</span><small><i> (OR)</i></small>: {{{field|phaseAction|input type=tokens|default=|size=40|values=Fellowship,Shadow,Maneuver,Archery,Skirmish,Regroup,Response|existing values only|placeholder=Select 1 or more}}}
</div>
</div>




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


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


<span class="heading">Playable</span>{{{field|isPlayable|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">Errata</span>{{{field|isErrata|input type=radiobutton|mandatory|default=any|values=any,yes,no|size=40}}}
<span class="heading">Text Search: </span>{{{field|textSearch|input type=textarea|autogrow|default=|cols=40|placeholder=Game Text to search}}}
Use % for wildcards.  Twilight symbols are stored like (1) and (X), and Culture symbols are referenced like [GONDOR] or [RINGWRAITH].
<div class="mw-collapsible-content ">
<!--    --><span class="heading">Regex Text Search: </span>{{{field|textRegexSearch|input type=textarea|autogrow|default=|cols=40|placeholder=Game Text to match (using regex)}}}
Uses [https://www.regular-expressions.info/ regex] to perform more powerful searching.
</div>


<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">Has Keyword</span><small><i> (OR)</i></small>: {{{field|keyword|input type=tokens|default=|size=40|values=Ambush,Archer,Battleground,Besieger,Corsair,Damage +1,Damage +2,Defender +1,Dwelling,Easterling,Enduring,Engine,Fierce,Forest,Fortification,Hunter,Knight,Lurker,Machine,Marsh,Mountain,Mounted,Muster,Pipeweed,Plains,Ranger,Ring-bound,River,Roaming,Sanctuary,Search,Southron,Spell,Stealth,Tale,Tentacle,Toil,Tracker,Twilight,Unbound,Underground,Unhasty,Valiant,Villager,Warg-rider,Weather,Burglar,Cunning,Wise|existing values only|placeholder=Select 1 or more}}}
</div>
</div>


<span class="heading">Lore Text Search: </span>{{{field|loreSearch|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}}}
<div class="sidebar flex " style="max-width:400px; justify-content:flex-start;" >
<div class="title">Quick Search</div>
{{{field|advancedOptions|input type=tree|list|default=|structure=
*Burdens:
**Auto-corruption
**Add Burdens
**Prevent Burden Removal
**Remove Burdens
**Prevent Burden Adding
**Spot Burdens
*Card Manipulation:
**Look At Top Of Deck
**Reveal Top Of Deck
**Place On Top Of Deck
**Place On Bottom Of Deck
**Shuffle Into Deck
**Discard From Your Deck
**Discard From Opponent's Deck
**Discard From Opponent's Hand
**Reveal Opponent's Hand
*Culture Tokens:
**Add Tokens
**Reinforce Tokens
**Remove Tokens
**Remove Token From Others
**Spot Tokens
*Cycling:
**Draw Cards
**Recover Cards Into Hand
**Discard From Your Hand
*Initiative:
**Initiative Bonus
**Shadow Initiative Manipulation
**Freeps Initiative Loss Bonus
*Move Limit:
**Increase Move Limit
**Decrease Move Limit
**Force Move
**Force Stop
*Recursion:
**Take Cards Into Hand From Discard
**Take Cards Into Hand From Deck
**Play Cards From Discard
**Play Cards From Deck
*Signets:
**Uses Aragorn Signet
**Uses Frodo Signet
**Uses Gandalf Signet
**Uses Théoden Signet
*Site Control:
**Take Control Of Site
**Liberate Site
**Prevent Site Control
**Your Site Control Bonus
**No Site Control Bonus
*Site Manipulation:
**Play Site
**Prevent Site Replacement
*Skirmishing:
**Ally Participation
**Cancel Skirmish
**Dodge Skirmish
**Replace Skirmish
**Overwhelm Protection
*Stats:
**Modify Strength:
***Add Strength
***Remove Strength
**Modify Resistance:
***Add Resistance
***Remove Resistance
**Modify Site Number:
***Add Site Number
***Remove Site Number
*Targeted Removal:
** Ally Removal
** Companion Removal
** Minion Removal
** Follower Removal
** Condition Removal
** Artifact Removal
** Possession Removal
*Threats:
**Add Threats
**Prevent Threat Removal
**Remove Threats
|size=40|depth=0|hideroot|width=400|height=400|class=flex}}}
</div>
</div>
</div>


<div class="flex">
<div class="sidebar flex" style="max-width:250px">
<div class="title">Advanced Search</div>


<div class="sidebar flex" style="max-width:200px">
<span class="heading">Uses Culture</span><small><i> (OR)</i></small>: {{{field|usesCulture|input type=tokens|default=|size=40|values={{#cargo_query:tables=Cultures=CU|fields=CU.Name|order by=CU.SortOrder|where=CU.Name NOT IN ('The One Ring', 'Site')|format=list|no html}}|existing values only|placeholder=Select 1 or more}}}
<div class="content mw-collapsible mw-collapsed" data-expandtext="Show more" data-collapsetext="Show less">
<div class="title">Stats</div>
<span class="heading">Twilight Cost: </span>{{{field|twilight|input type=text|default=|size=12|placeholder=}}} <div class="mw-collapsible-content"><small>
<!--    --><span class="heading">>=</span> {{{field|twilightMore|input type=text|default=|size=5}}} <span class="heading"><=</span> {{{field|twilightLess|input type=text|default=|size=5}}}
  </small></div>
 
<span class="heading">Strength: </span>{{{field|strength|input type=text|default=|size=12|placeholder=}}}
  <div class="mw-collapsible-content"><small>
<!--    --><span class="heading">>=</span> {{{field|strengthMore|input type=text|default=|size=5}}} <span class="heading"><=</span> {{{field|strengthLess|input type=text|default=|size=5}}}
  </small></div>
 
<span class="heading">Vitality: </span>{{{field|vitality|input type=text|default=|size=12|placeholder=}}}
  <div class="mw-collapsible-content"><small>
<!--    --><span class="heading">>=</span> {{{field|vitalityMore|input type=text|default=|size=5}}} <span class="heading"><=</span> {{{field|vitalityLess|input type=text|default=|size=5}}}
  </small></div>
 
<span class="heading">Resistance: </span>{{{field|resistance|input type=text|default=|size=12|placeholder=}}}
  <div class="mw-collapsible-content"><small>
<!--    --><span class="heading">>=</span> {{{field|resistanceMore|input type=text|default=|size=5}}} <span class="heading"><=</span> {{{field|resistanceLess|input type=text|default=|size=5}}}
  </small></div>
 
<span class="heading">Site Number: </span>{{{field|sitenum|input type=text|default=|size=12|placeholder=}}}
  <div class="mw-collapsible-content"><small>
<!--    --><span class="heading">>=</span> {{{field|sitenumMore|input type=text|default=|size=5}}} <span class="heading"><=</span> {{{field|sitenumLess|input type=text|default=|size=5}}}
  </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}}}
  </div>
</div>
 


<div class="sidebar flex" style="max-width:300px">
<span class="heading">Uses Card Type</span><small><i> (OR)</i></small>: {{{field|usesCardtype|input type=tokens|default=|size=40|cargo table=Cards|cargo field=CardType|existing values only|placeholder=Select 1 or more}}}
<div class="content mw-collapsible mw-collapsed" data-expandtext="Show more" data-collapsetext="Show less">
<div class="title">Site Info</div>


<span class="heading">Block: </span>{{{field|block|input type=tokens|default=|size=30|cargo table=CardReleases|cargo field=Block|placeholder=Select from dropdown}}}
<span class="heading">Uses Race</span><small><i> (OR)</i></small>: {{{field|usesRace|input type=tokens|default=|size=40|values=
{{#cargo_query:tables=Cards=C,CardReleases=CR|join on=C.ID = CR.ID|fields=CR.Subtypes__full|where=C.CardType IN ('Companion', 'Ally', 'Minion') AND CR.Subtypes__full IS NOT NULL|format=template|template=TagFilterOutput|group by=Subtypes__full|no html}}|existing values only|placeholder=Select 1 or more}}}


<span class="heading">Shadow Number: </span>{{{field|shadownum|input type=text|default=|size=12|placeholder=}}}
<span class="heading">Uses Item Class</span><small><i> (OR)</i></small>: {{{field|usesItemClass|input type=tokens|default=|size=40|values=
  <div class="mw-collapsible-content"><small>
{{#cargo_query:tables=Cards=C,CardReleases=CR|join on=C.ID = CR.ID|fields=CR.Subtypes__full|where=C.CardType IN ('Artifact', 'Possession') AND CR.Subtypes__full IS NOT NULL AND CR.Subtypes__full NOT LIKE '%,%' AND CR.Subtypes__full NOT LIKE '%Support Area%'|format=template|template=TagFilterOutput|group by=Subtypes__full|no html}}|existing values only|placeholder=Select 1 or more}}}
<!--    --><span class="heading">>=</span> {{{field|shadownumMore|input type=text|default=|size=5}}} <span class="heading"><=</span> {{{field|shadownumLess|input type=text|default=|size=5}}}
  </small></div>


<span class="heading">Sanctuary</span>{{{field|isSanctuary|input type=radiobutton|mandatory|default=any|values=any,yes,no|size=40}}}
<span class="heading">Uses Keyword</span><small><i> (OR)</i></small>: {{{field|usesKeyword|input type=tokens|default=|size=40|values=Ambush,Archer,Battleground,Besieger,Corsair,Damage,Defender,Dwelling,Easterling,Enduring,Engine,Fierce,Forest,Fortification,Hunter,Knight,Lurker,Machine,Marsh,Mountain,Mounted,Muster,Pipeweed,Plains,Ranger,Ring-bound,River,Roaming,Sanctuary,Search,Southron,Spell,Stealth,Tale,Tentacle,Toil,Tracker,Twilight,Unbound,Underground,Unhasty,Valiant,Villager,Warg-rider,Weather,Burglar,Cunning,Wise|existing values only|placeholder=Select 1 or more}}}
</div>


<span class="heading">Arrow Direction</span>{{{field|arrowDir|input type=radiobutton|mandatory|default=any|values=any,left,right|size=40}}}
</div>
</div>


<div class="sidebar flex" style="max-width:300px">
<div class="content mw-collapsible " data-expandtext="Show more" data-collapsetext="Show less">
<div class="title">Stats</div>


<div class="sidebar flex" style="max-width:300px">
<span class="heading">Twilight Cost: </span>{{{field|twilight|input type=text|default=|size=12|placeholder=}}} <div class="mw-collapsible-content"><small>
<div>
<!--    --><span class="heading">>=</span> {{{field|twilightMore|input type=text|default=|size=5}}} <span class="heading"><=</span> {{{field|twilightLess|input type=text|default=|size=5}}}
<div class="content mw-collapsible mw-collapsed" data-expandtext="Show more" data-collapsetext="Show less">
  </small></div>
<div class="title">Game Text</div>
 
<span class="heading">Strength: </span>{{{field|strength|input type=text|default=|size=12|placeholder=}}}
  <div class="mw-collapsible-content"><small>
<!--    --><span class="heading">>=</span> {{{field|strengthMore|input type=text|default=|size=5}}} <span class="heading"><=</span> {{{field|strengthLess|input type=text|default=|size=5}}}
  </small></div>
 
<span class="heading">Vitality: </span>{{{field|vitality|input type=text|default=|size=12|placeholder=}}}
  <div class="mw-collapsible-content"><small>
<!--    --><span class="heading">>=</span> {{{field|vitalityMore|input type=text|default=|size=5}}} <span class="heading"><=</span> {{{field|vitalityLess|input type=text|default=|size=5}}}
  </small></div>
 
<span class="heading">Resistance: </span>{{{field|resistance|input type=text|default=|size=12|placeholder=}}}
  <div class="mw-collapsible-content"><small>
<!--    --><span class="heading">>=</span> {{{field|resistanceMore|input type=text|default=|size=5}}} <span class="heading"><=</span> {{{field|resistanceLess|input type=text|default=|size=5}}}
  </small></div>


<span class="heading">Text Search: </span>{{{field|textSearch|input type=textarea|autogrow|default=|cols=40|placeholder=Game Text to match}}}
<span class="heading">Site Number: </span>{{{field|sitenum|input type=text|default=|size=12|placeholder=}}}
  <div class="mw-collapsible-content">
  <div class="mw-collapsible-content"><small>
<!--    --><span class="heading">Regex Text Search: </span>{{{field|textRegexSearch|input type=textarea|autogrow|default=|cols=40|placeholder=Game Text to match (using regex)}}}
<!--    --><span class="heading">>=</span> {{{field|sitenumMore|input type=text|default=|size=5}}} <span class="heading"><=</span> {{{field|sitenumLess|input type=text|default=|size=5}}}
  </small></div>
 
<span class="heading">Signet: </span>{{{field|signet|input type=tokens|default=|size=30|cargo table=CardReleases|cargo field=Signet|existing values only|placeholder=Select 1 or more}}}
</div>
</div>


<span class="heading">Tagged Text Search: </span>{{{field|taggedTextRegexSearch|input type=textarea|autogrow|default=|cols=40|placeholder=HTML Tagged Game Text to match (using regex)}}}


</div>
<div class="sidebar flex" style="max-width:300px">
</div>
<div class="content mw-collapsible " data-expandtext="Show more" data-collapsetext="Show less">
<div class="title">Site Stats</div>


<span class="heading">Site Number: </span>{{{field|sitesitenum|input type=text|default=|size=12|placeholder=}}}
  <div class="mw-collapsible-content"><small>
<!--    --><span class="heading">>=</span> {{{field|sitesitenumMore|input type=text|default=|size=5}}} <span class="heading"><=</span> {{{field|sitesitenumLess|input type=text|default=|size=5}}}
  </small></div>


<div>
<span class="heading">Shadow Number: </span>{{{field|shadownum|input type=text|default=|size=12|placeholder=}}}
<div class="content mw-collapsible mw-collapsed" data-expandtext="Show more" data-collapsetext="Show less">
  <div class="mw-collapsible-content"><small>
<!--    --><span class="heading">>=</span> {{{field|shadownumMore|input type=text|default=|size=5}}} <span class="heading"><=</span> {{{field|shadownumLess|input type=text|default=|size=5}}}
  </small></div>


<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">Sanctuary</span>{{{field|isSanctuary|input type=radiobutton|default=any|values=any,yes,no|size=40}}}
  <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">Arrow Direction</span>{{{field|arrowDir|input type=radiobutton|default=any|values=any,left,right|size=40}}}
</div>
</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="sidebar flex" style="max-width:250px">
  <div class="mw-collapsible-content">
<div class="title">Collection Info</div>
<!--    --><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">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}}|existing values only|placeholder=Select 1 or more}}}


<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|existing values only|placeholder=Select 1 or more}}}


<span class="heading">Has Race</span><small><i> (OR)</i></small>: {{{field|race|input type=tokens|default=|size=40|values=
<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=template|template=TagFilterOutput|no html|delimiter=,}}|existing values only|placeholder=Select 1 or more}}}
{{#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">Foil Images</span>{{{field|isFoil|input type=radiobutton|mandatory|default=no|values=yes,no|size=40}}}
<!--    --><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}}}


</div>
<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=yes|values=any,yes,no|size=40}}}


<span class="heading">Has Item Class</span><small><i> (OR)</i></small>: {{{field|itemClass|input type=tokens|default=|size=40|values=
<span class="heading">Errata</span>{{{field|isErrata|input type=radiobutton|mandatory|default=any|values=any,yes,no|size=40}}}
{{#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">Language: </span>{{{field|languageName|input type=tokens|default=English|size=30|cargo table=Languages|cargo field=Name|existing values only|placeholder=Select 1 or more}}}
<!--    --><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}}}


<span class="heading">Lore Text Search: </span>{{{field|loreSearch|input type=textarea|autogrow|default=|cols=30|placeholder=Lore regex search to match}}}
</div>
</div>
</div>


{{{standard input|run query|label=Run query|class=button}}}


<span class="heading">Has Keyword</span><small><i> (OR)</i></small>: {{{field|keyword|input type=tokens|default=|size=40|values=
[[Special:RunQuery/CardSearch|{{Button| <big>✕</big>  Clear Form|color=red}}]]
{{#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 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"
|-
 
|-
! Lore:
| {{{field|Lore}}}
|-
! Promo Text:
| {{{field|PromoText}}}
|}

Latest revision as of 02:30, 25 January 2024

Run query

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