Editing Form:CardSearch
From LOTR-TCG Wiki
The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then publish the changes below to finish undoing the edit.
Latest revision | Your text | ||
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}}} | ||
__NOTOC____NOEDITSECTION__<!-- | __NOTOC____NOEDITSECTION__<!-- | ||
Line 11: | Line 9: | ||
<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| | {{{for template|BaseCard}}} | ||
<div class="flex"> | |||
<div class="sidebar flex" style="max-width:300px"> | |||
<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">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">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={{#cargo_query:tables=Rarities=R|fields=CONCAT(R.Name, ' (', R.Abbr, ')')|where=R.Sets HOLDS NOT '30' AND R.Sets HOLDS NOT '31'|format=list|no html}}|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">Language: </span>{{{field|languageName|input type=tokens|default=|size=30|cargo table=Languages|cargo field=Name|placeholder=Select from dropdown}}} | |||
<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> | |||
<div class="sidebar flex" style="max-width:200px"> | |||
<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="flex"> | <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">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">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|shadownumLess|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|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:300px"> | |||
<div> | |||
<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)}}} | |||
</div> | |||
</div> | |||
<div> | |||
<div class="content mw-collapsible mw-collapsed" data-expandtext="Show more" data-collapsetext="Show less"> | |||
<span class="heading">Culture</span><small><i> (OR)</i></small>: {{{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><small><i> (OR)</i></small>: {{{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 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}}} | |||
<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}}} | |||
</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> | |||
<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:900px"> | |||
<div class="title">Advanced Search</div> | |||
<span class="heading">Abilities</span>{{{field|advancedAbilities|input type=checkboxes|default=|values=Ambush: add, Ambush: remove, Ambush: initial ability, Archer: add, Archer: remove, Archer: initial ability, Archery: increase total, Archery: decrease total, Archery: prevent, Damage: increase, Damage: decrease, Damage: initial ability, Defender: add, Defender: remove, Defender: inital ability, Enduring: add, Enduring: remove, Enduring: initial ability, Fierce: add, Fierce: remove, Fierce: initial ability, Hunter: add, Hunter: remove, Hunter: initial ability, Knight: add, Lurker: add, Lurker: remove, Lurker: initial ability, Muster: add, Muster: remove, Muster: initial ability, Roaming: add, Roaming: remove, Prevent special ability or event use, Cancel special ability or effect effect|size=40|class=flex}}} | |||
<span class="heading">Filtering/Cycling</span>{{{field|advancedFiltering|input type=checkboxes|default=|values=Stack card from hand, Stack card from discard pile, Stack card from draw deck, Stack card from play, Take stacked card in hand, Discard stacked card, Shuffle stacked card into draw deck, Play stacked card, Discard from hand, Shuffle from hand into draw deck, Place from hand on top of draw deck, Place form hand on bottom of draw deck, Take in hand from discard pile, Play from discard pile, Shuffle into draw deck from discard pile, Place on top of draw deck from discard pile, Place on bottom of draw deck from discard pile, Discard from draw deck, Take in hand from draw deck, Draw, Take in hand from bottom of draw deck, Play from draw deck, Reorganize draw deck, Discard from play, Return to hand from play, Shuffle into draw deck from play, Place on top of draw deck from play, Place on bottom of draw deck from play, Play from dead pile, Remove from game|size=40|class=flex}}} | |||
<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}}} | |||
<span class="heading">Tokens</span>{{{field|advancedCounters|input type=checkboxes|default=|values=Twilight Token: add, Twilight Token: remove, Burden: add, Burden: remove, Prevent Burden Adding, Prevent Burden Removing, Ring-bearer corruption, Threat: add, Threat: remove, Token: remove, Token: reinforce, Token: support|size=40|class=flex}}} | |||
<span class="heading">Attributes</span>{{{field|advancedAttributes|input type=checkboxes|default=|values=Strength: increase, Strength: decrease, Triple strength to overwhelm, Vitality: increase, Vitality: decrease, Signet: add, Signet: remove, Resistance: add, Resistance: remove, Site number: increase, Site number: decrease|size=40|class=flex}}} | |||
<span class="heading">Sites/Movement</span>{{{field|advancedSites|input type=checkboxes|default=|values=Move limit: increase, Move limit: decrease, Force Move, Site: play next, Site: replace, Site: prevent replace, Site: control, Site: liberate, Site: prevent control, Site: gain keyword, Site: lose game text|size=40|class=flex}}} | |||
<span class="heading">Misc.</span>{{{field|advancedMIsc|input type=checkboxes|default=|values=Initiative for Shadow, Create minion, Ally participation in archery and skirmish|size=40|class=flex}}} | |||
<span class="heading">Assignment</span>{{{field|advancedAssignment|input type=checkboxes|default=|values=Assign to Ring-bearer, Assign to Ally, Assign to Companion, Prevent assignment, Replace character in skirmish, Cancel skirmish|size=40|class=flex}}} | |||
<span class="heading">Healing</span>{{{field|advancedHealing|input type=checkboxes|default=|values=heal ally, heal companion, heal minion, prevent healing|size=40|class=flex}}} | |||
<span class="heading">Wounding</span>{{{field|advancedWounding|input type=checkboxes|default=|values=Prevent wound, Direct wound, Indirect wound|size=40|class=flex}}} | |||
<span class="heading">Exertion</span>{{{field|advancedExertion|input type=checkboxes|default=|values=Prevent exertion, Direct exertion, Indirect exertion|size=40|class=flex}}} | |||
<span class="heading">Killing</span>{{{field|advancedKilling|input type=checkboxes|default=|values=Remove from dead pile, Kill minion, Kill companion, Kill ally, Prevent kill|size=40|class=flex}}} | |||
<span class="heading">Discard</span>{{{field|advancedDiscard|input type=checkboxes|default=|values=Discard minion, Discard companion, Discard ally, Discard artifact, Prevent discard|size=40|class=flex}}} | |||
<span class="heading">Telepathy</span>{{{field|advancedTelepathy|input type=checkboxes|default=|values=Look at the top of draw deck, Reveal top of draw deck, Reveal hand, Reveal deck|size=40|class=flex}}} | |||
<span class="heading">Possessions</span>{{{field|advancedPossessions|input type=checkboxes|default=|values=Possession: discard, Possession: return to hand, Possession: transfer|size=40|class=flex}}} | |||
<span class="heading">Conditions</span>{{{field|advancedConditions|input type=checkboxes|default=|values=Condition: discard, Condition: return to han, Condition: transfer|size=40|class=flex}}} | |||
<span class="heading">Followers</span>{{{field|advancedFollowers|input type=checkboxes|default=|values=Discard follower, Prevent follower use or transfer|size=40|class=flex}}} | |||
</div> | </div> | ||
</div> |