Form:CardSearch: Difference between revisions

From LOTR-TCG Wiki
No edit summary
No edit summary
Line 33: Line 33:
<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">Stats</div>
<div class="title">Stats</div>
<span class="heading">Twilight: </span>{{{field|twilight|input type=text|default=|size=12|placeholder=}}} <div class="mw-collapsible-content"><small>
<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}}}
<!--    --><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>
   </small></div>
    
    
<span class="heading">Strength: </span>{{{field|strength|input type=text|default=|size=12|placeholder=}}}
<span class="heading">Strength: </span>{{{field|strength|input type=text|default=|size=12|placeholder=}}}
   <div class="mw-collapsible-content"><small>
   <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}}}
<!--    --><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>
   </small></div>
    
    
<span class="heading">Vitality: </span>{{{field|vitality|input type=text|default=|size=12|placeholder=}}}
<span class="heading">Vitality: </span>{{{field|vitality|input type=text|default=|size=12|placeholder=}}}
   <div class="mw-collapsible-content"><small>
   <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}}}
<!--    --><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>
   </small></div>
    
    
<span class="heading">Resistance: </span>{{{field|resistance|input type=text|default=|size=12|placeholder=}}}
<span class="heading">Resistance: </span>{{{field|resistance|input type=text|default=|size=12|placeholder=}}}
   <div class="mw-collapsible-content"><small>
   <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}}}
<!--    --><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>
   </small></div>


<span class="heading">Site Number: </span>{{{field|sitenum|input type=text|default=|size=12|placeholder=}}}
<span class="heading">Site Number: </span>{{{field|sitenum|input type=text|default=|size=12|placeholder=}}}
   <div class="mw-collapsible-content"><small>
   <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}}}
<!--    --><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>
   </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>
</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">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="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">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|mandatory|default=any|values=any,yes,no|size=40}}}
 
<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:320px">
<div class="content mw-collapsible mw-collapsed" data-expandtext="Show more" data-collapsetext="Show less">
<div class="title">Game Text</div>
 
<span class="heading">Text Search: </span>{{{field|textSearch|input type=textarea|autogrow|default=|cols=40|placeholder=Game Text to match}}}
  <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)}}}
 
<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)}}}
 
{{#listunique:list={{#cargo_query:tables=Cards=C,CardReleases=CR|join on=C.ID = CR.ID|fields=CR.Subtypes|where=C.CardType IN ('Artifact', 'Possession')|format=list|more results text=|limit=600}}|insep=,|outsep=.}}
 
 
{{#listunique:list=A,A,A,B,C,C|insep=,|outsep=.}}
 
 
  </div>
 
 
</div>
</div>
 
 
   
   


{| class="formtable"
{| class="formtable"
|-
! 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:  
! Subtypes:  
| {{{field|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:  
! Game Text:  
| {{{field|GameText}}}
| {{{field|GameText}}}
Line 154: Line 132:
! Tagged Game Text:  
! Tagged Game Text:  
| {{{field|TaggedGameText}}}
| {{{field|TaggedGameText}}}
|-
! Formatted Game Text:
| {{{field|FormattedGameText}}}
|-
|-
! Lore:  
! Lore:  

Revision as of 10:14, 21 January 2022

Run query

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