Form:CardSearch: Difference between revisions

From LOTR-TCG Wiki
No edit summary
(Fixing Race, Item Class, and Rarity filters not working properly)
 
(175 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="sidebar flex" style="max-width:250px">
<div class="title">Basic Attributes</div>
 
<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}}}
 
<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">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">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">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">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 class="sidebar bg flex" style="max-width:400px">
  <div class="title">Card Name</div>
<span class="heading">Unique?</span>{{{field|isUnique|input type=radiobutton|mandatory|default=any|values=any,yes,no|size=40}}}


{{{field|title|input type=text|default=|size=40|placeholder=Title Search Text}}}
<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>


{{{field|subtitle|input type=text|default=|size=40|placeholder=Subtitle Search Text}}}
<span class="heading">Title: </span>{{{field|title|input type=text|default=|size=30|placeholder=Title regex Search Text}}}
  </div>
 
<span class="heading">Subtitle: </span>{{{field|subtitle|input type=text|default=|size=30|placeholder=Subtitle regex Search Text}}}
  <div class="sidebar bg flex" style="max-width:400px">
 
  <div class="content mw-collapsible mw-collapsed" data-expandtext="Show more" data-collapsetext="Show less">
<span class="heading">Unique?</span>{{{field|isUnique|input type=radiobutton|mandatory|default=any|values=any,yes,no|size=40}}}
  <div class="title">Card Name</div>
 
{{{field|attack|input type=tokens|default=|size=12|cargo table=Cards|cargo field=attack|placeholder=Seperated by ",". Ex: 1, 2}}}
<span class="heading">Text Search: </span>{{{field|textSearch|input type=textarea|autogrow|default=|cols=40|placeholder=Game Text to search}}}
   <div class="mw-collapsible-content"><small>
Use % for wildcards. Twilight symbols are stored like (1) and (X), and Culture symbols are referenced like [GONDOR] or [RINGWRAITH].
    <div class="heading">Does not contains</div>{{{field|attackNot|input type=tokens|default=|size=12|cargo table=Cards|cargo field=attack}}}
<div class="mw-collapsible-content ">
<!--    --><span class="heading">>=</span> {{{field|attackMore|input type=text|default=|size=5}}}, <span class="heading"><=</span> {{{field|attackLess|input type=text|default=|size=5}}}
<!--    --><span class="heading">Regex Text Search: </span>{{{field|textRegexSearch|input type=textarea|autogrow|default=|cols=40|placeholder=Game Text to match (using regex)}}}
   </small></div>
Uses [https://www.regular-expressions.info/ regex] to perform more powerful searching.
  </div>
</div>
</div>
 
<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>
 
 
<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 class="flex">
<div class="sidebar flex" style="max-width:250px">
<div class="title">Advanced Search</div>
 
<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}}}
 
<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}}}
 
<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">Uses Item Class</span><small><i> (OR)</i></small>: {{{field|usesItemClass|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 ('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">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>
 
 
<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>
 
<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|existing values only|placeholder=Select 1 or more}}}
</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">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>
 
<span class="heading">Shadow Number: </span>{{{field|shadownum|input type=text|default=|size=12|placeholder=}}}
  <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">Sanctuary</span>{{{field|isSanctuary|input type=radiobutton|default=any|values=any,yes,no|size=40}}}
 
<span class="heading">Arrow Direction</span>{{{field|arrowDir|input type=radiobutton|default=any|values=any,left,right|size=40}}}
</div>
</div>
 
 
<div class="sidebar flex" style="max-width:250px">
<div class="title">Collection Info</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">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}}}
 
<span class="heading">Foil Images</span>{{{field|isFoil|input type=radiobutton|mandatory|default=no|values=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=yes|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|existing values only|placeholder=Select 1 or more}}}
 
<span class="heading">Lore Text Search: </span>{{{field|loreSearch|input type=textarea|autogrow|default=|cols=30|placeholder=Lore regex search to match}}}
</div>
</div>
 
{{{standard input|run query|label=Run query|class=button}}}


{| class="formtable"
[[Special:RunQuery/CardSearch|{{Button| <big>✕</big>  Clear Form|color=red}}]]
|-
! Title:
| {{{field|Title}}}
|-
! Subtitle:
| {{{field|Subtitle}}}
|-
! Set Number:
| {{{field|SetNum}}}
|-
! Subset:
| {{{field|Subset}}}
|-
! Rarity:
| {{{field|Rarity}}}
|-
! Card Number:
| {{{field|CardNum}}}
|-
! Revision:
| {{{field|Revision}}}
|-
! Culture:
| {{{field|Culture}}}
|-
! Side:  
| {{{field|Side}}}
|-
! Card Type:
| {{{field|CardType|input type=checkboxes|default=|size=12|cargo table=CardTypes|cargo field=Name|placeholder=Separated by ",". Ex: 1, 2}}}
|-
! Was Physically Printed:
| {{{field|IsPhysical}}}
|-
! Is An Actual Playable Card:
| {{{field|IsPlayable}}}
|-
! Revision:
| {{{field|Revision}}}
|-
! Language Code:
| {{{field|LanguageCode}}}
|-
! Subtypes:
| {{{field|Subtypes}}}
|-
! Twilight Cost:
| {{{field|TwilightCost}}}
|-
! Strength:
| {{{field|Strength}}}
|-
! Strength Modifier:
| {{{field|StrengthMod}}}
|-
! Vitality:
| {{{field|Vitality}}}
|-
! Vitality Modifier:
| {{{field|VitalityMod}}}
|-
! Site Number:
| {{{field|SiteNum}}}
|-
! Site Number Modifier:
| {{{field|SiteNumMod}}}
|-
! Resistance:
| {{{field|Resistance}}}
|-
! Resistance Modifier:
| {{{field|ResistanceMod}}}
|-
! Signet:
| {{{field|Signet}}}
|-
! Block:
| {{{field|Block}}}
|-
! Shadow Number:
| {{{field|ShadowNum}}}
|-
! Arrow Direction:
| {{{field|ArrowDir}}}
|-
! Is Sanctuary:
| {{{field|IsSanctuary}}}
|-
! Game Text:
| {{{field|GameText}}}
|-
! Tagged Game Text:
| {{{field|TaggedGameText}}}
|-
! Formatted Game Text:
| {{{field|FormattedGameText}}}
|-
! 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"