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 from dropdown}}}
<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">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 from dropdown}}}
<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">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 many from dropdown}}}
<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">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=list|no html}}|placeholder=Select 1 or more from dropdown}}}
<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=list|no html}}|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">Has Culture</span><small><i> (OR)</i></small>: {{{field|culture|input type=tokens|default=|size=40|values={{#cargo_query:tables=Cards=C,CardSets=S|join on=C.SetNum=S.ID|fields=C.Culture|group by=C.Culture|order by=CASE WHEN S.Creator = 'Decipher' THEN 0 WHEN S.Creator = "Player's Council" THEN 1 WHEN S.Creator = "-Enola-" THEN 3 ELSE 4 END, S.ReleaseDate, S.Name|format=list|no html}}|placeholder=Select from dropdown}}}
<span class="heading">Has Culture</span><small><i> (OR)</i></small>: {{{field|culture|input type=tokens|default=|size=40|values={{#cargo_query:tables=Cards=C,CardSets=S|join on=C.SetNum=S.ID|fields=C.Culture|group by=C.Culture|order by=CASE WHEN S.Creator = 'Decipher' THEN 0 WHEN S.Creator = "Player's Council" THEN 1 WHEN S.Creator = "-Enola-" THEN 3 ELSE 4 END, CASE WHEN C.Culture = "The One Ring" THEN 0 WHEN C.Culture = "Site" THEN 100 ELSE 1 END, S.Name|format=list|no html}}|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|targetsCulture|input type=tokens|default=|size=40|cargo table=Cards|cargo field=Culture|placeholder=Select from dropdown}}}
<!--    --><span class="heading">Uses Culture</span><small><i> (OR)</i></small>: {{{field|targetsCulture|input type=tokens|default=|size=40|cargo table=Cards|cargo field=Culture|placeholder=Select 1 or more}}}
</div>
</div>
<span class="heading">Has 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">Has 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">
<div class="mw-collapsible-content">
<!--    --><span class="heading">Uses 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}}}
<!--    --><span class="heading">Uses Card Type</span><small><i> (OR)</i></small>: {{{field|targetsCardtype|input type=tokens|default=|size=40|cargo table=Cards|cargo field=CardType|placeholder=Select 1 or more}}}
</div>
</div>


<span class="heading">Has Race</span><small><i> (OR)</i></small>: {{{field|race|input type=tokens|default=|size=40|values=
<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}}}
{{#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 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|targetsRace|input type=tokens|default=|size=40|values=
<!--    --><span class="heading">Uses 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}}}
{{#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 1 or more}}}
</div>
</div>
              
              
<span class="heading">Has Item Class</span><small><i> (OR)</i></small>: {{{field|itemClass|input type=tokens|default=|size=40|values=
<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}}}
{{#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 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|targetsItemClass|input type=tokens|default=|size=40|values=
<!--    --><span class="heading">Uses 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}}}
{{#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 1 or more}}}


</div>
</div>
Line 81: Line 81:


<span class="heading">Has Keyword</span><small><i> (OR)</i></small>: {{{field|keyword|input type=tokens|default=|size=40|values=
<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}}}
{{#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 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|targetsKeyword|input type=tokens|default=|size=40|values=
<!--    --><span class="heading">Uses 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}}}
{{#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 1 or more}}}


</div>
</div>
Line 121: Line 121:
  </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 from dropdown}}}
<span class="heading">Signet: </span>{{{field|signet|input type=tokens|default=|size=30|cargo table=CardReleases|cargo field=Signet|placeholder=Select 1 or more}}}
</div>
</div>
</div>
</div>
Line 130: Line 130:
<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 from dropdown}}}
<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">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 159: Line 159:
<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 from dropdown}}}
<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">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 03:20, 26 September 2022

Run query

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