Form:CardSearch: Difference between revisions
From LOTR-TCG Wiki
No edit summary |
No edit summary |
||
| Line 45: | Line 45: | ||
Sometimes the bracket syntax of the symbols makes things hard. Cards are also stored in HTML, using <nowiki><symbol>gondor</symbol></nowiki> and <nowiki><twilight>1</twilight></nowiki> syntax. However, other card text is also formatted using HTML, using <nowiki><keyword>Fellowship</keyword></nowiki> and similar syntax, which can make searching harder. YMMV. | Sometimes the bracket syntax of the symbols makes things hard. Cards are also stored in HTML, using <nowiki><symbol>gondor</symbol></nowiki> and <nowiki><twilight>1</twilight></nowiki> syntax. However, other card text is also formatted using HTML, using <nowiki><keyword>Fellowship</keyword></nowiki> and similar syntax, which can make searching harder. YMMV. | ||
</div> | </div> | ||
</div> | |||
</div> | |||
<div class="sidebar flex" style="max-width:250px"> | |||
<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> | |||
</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> | ||
| Line 122: | Line 171: | ||
</div> | </div> | ||
<div class="sidebar flex" style="max-width:900px"> | <div class="sidebar flex" style="max-width:900px"> | ||
