Form:CardSearch: Difference between revisions

From LOTR-TCG Wiki
No edit summary
No edit summary
Line 21: Line 21:
<span class="heading">Subtitle: </span>{{{field|subtitle|input type=text|default=|size=30|placeholder=Subtitle regex Search Text}}}
<span class="heading">Subtitle: </span>{{{field|subtitle|input type=text|default=|size=30|placeholder=Subtitle regex Search Text}}}


<span class="heading">Side: </span>{{{field|side|input type=tokens|default=|size=40|cargo table=Cards|cargo field=Side|placeholder=Select 1 or more}}}
<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">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}}|placeholder=Select 1 or more}}}
<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,|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={{#replace:{{#replace:{{#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=list|no html|delimiter=,}}|<p>|}}|</p>|}}|placeholder=Select 1 or more}}}
<span class="heading">Rarity: </span>{{{field|rarityabbr|input type=tokens|default=|size=40|values={{#replace:{{#replace:{{#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=list|no html|delimiter=,}}|<p>|}}|</p>|}}|existing values only|placeholder=Select 1 or more}}}
</div>
</div>


Line 53: Line 53:
<div class="content mw-collapsible" data-expandtext="Show more" data-collapsetext="Show less">
<div class="content mw-collapsible" data-expandtext="Show more" data-collapsetext="Show less">


<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}}|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}}}
<div class="mw-collapsible-content">
<div class="mw-collapsible-content">
<!--    --><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}}|placeholder=Select 1 or more}}}
<!--    --><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>
</div>
<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|placeholder=Select from dropdown}}}
<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 from dropdown}}}
<div class="mw-collapsible-content">
<div class="mw-collapsible-content">
<!--    --><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|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}}}
</div>
</div>


<span class="heading">Is Race</span><small><i> (OR)</i></small>: {{{field|race|input type=tokens|default=|size=40|values=
<span class="heading">Is Race</span><small><i> (OR)</i></small>: {{{field|race|input type=tokens|default=|size=40|values=
{{#replace:{{#replace:{{#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=list|group by=Subtypes__full|order by=CASE WHEN CR.Subtypes__full IS NULL THEN 0 ELSE 1 END,CR.Subtypes__full|no html}}|<p>|}}|</p>|}}|placeholder=Select 1 or more}}}
{{#replace:{{#replace:{{#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=list|group by=Subtypes__full|order by=CASE WHEN CR.Subtypes__full IS NULL THEN 0 ELSE 1 END,CR.Subtypes__full|no html}}|<p>|}}|</p>|}}|existing values only|placeholder=Select 1 or more}}}


<div class="mw-collapsible-content">
<div class="mw-collapsible-content">
<!--    --><span class="heading">Uses Race</span><small><i> (OR)</i></small>: {{{field|usesRace|input type=tokens|default=|size=40|values=
<!--    --><span class="heading">Uses Race</span><small><i> (OR)</i></small>: {{{field|usesRace|input type=tokens|default=|size=40|values=
{{#replace:{{#replace:{{#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=list|group by=Subtypes__full|no html}}|<p>|}}|</p>|}}|placeholder=Select 1 or more}}}
{{#replace:{{#replace:{{#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=list|group by=Subtypes__full|no html}}|<p>|}}|</p>|}}|existing values only|placeholder=Select 1 or more}}}
</div>
</div>
              
              
<span class="heading">Is Item Class</span><small><i> (OR)</i></small>: {{{field|itemClass|input type=tokens|default=|size=40|values=
<span class="heading">Is Item Class</span><small><i> (OR)</i></small>: {{{field|itemClass|input type=tokens|default=|size=40|values=
{{#replace:{{#replace:{{#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=list|group by=Subtypes__full|order by=CASE WHEN CR.Subtypes__full IS NULL THEN 0 ELSE 1 END,CR.Subtypes__full|no html}}|<p>|}}|</p>|}}|placeholder=Select 1 or more}}}
{{#replace:{{#replace:{{#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=list|group by=Subtypes__full|order by=CASE WHEN CR.Subtypes__full IS NULL THEN 0 ELSE 1 END,CR.Subtypes__full|no html}}|<p>|}}|</p>|}}|existing values only|placeholder=Select 1 or more}}}


<div class="mw-collapsible-content">
<div class="mw-collapsible-content">
<!--    --><span class="heading">Uses Item Class</span><small><i> (OR)</i></small>: {{{field|usesItemClass|input type=tokens|default=|size=40|values=
<!--    --><span class="heading">Uses Item Class</span><small><i> (OR)</i></small>: {{{field|usesItemClass|input type=tokens|default=|size=40|values=
{{#replace:{{#replace:{{#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=list|group by=Subtypes__full|no html}}|<p>|}}|</p>|}}|placeholder=Select 1 or more}}}
{{#replace:{{#replace:{{#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=list|group by=Subtypes__full|no html}}|<p>|}}|</p>|}}|existing values only|placeholder=Select 1 or more}}}


</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|placeholder=Select 1 or more}}}
<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 class="mw-collapsible-content">
<div class="mw-collapsible-content">
<!--    --><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|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>
Line 119: Line 119:
  </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 1 or more}}}
<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>
</div>
Line 128: Line 128:
<div class="title">Site Info</div>
<div class="title">Site Info</div>


<span class="heading">Block: </span>{{{field|block|input type=tokens|default=|size=30|values=Fellowship,Towers,King,Shadows,Hobbit|placeholder=Select 1 or more}}}
<span class="heading">Block: </span>{{{field|block|input type=tokens|default=|size=30|values=Fellowship,Towers,King,Shadows,Hobbit|existing values only|placeholder=Select 1 or more}}}


<span class="heading">Site Number: </span>{{{field|sitesitenum|input type=text|default=|size=12|placeholder=}}}
<span class="heading">Site Number: </span>{{{field|sitesitenum|input type=text|default=|size=12|placeholder=}}}
Line 157: Line 157:
<span class="heading">Errata</span>{{{field|isErrata|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=English|size=30|cargo table=Languages|cargo field=Name|placeholder=Select 1 or more}}}
<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}}}
<span class="heading">Lore Text Search: </span>{{{field|loreSearch|input type=textarea|autogrow|default=|cols=30|placeholder=Lore regex search to match}}}

Revision as of 11:16, 26 September 2022