Template:IDLookup: Difference between revisions

From LOTR-TCG Wiki
No edit summary
No edit summary
 
(9 intermediate revisions by the same user not shown)
Line 1: Line 1:
<noinclude>
<noinclude>
{{#template_params:1|2}}
{{#template_params:1|2}}
</noinclude><includeonly>{{#if: {{#pos:{{{1}}}|-}}|{{#cargo_query:tables=Cards=C,CardReleases=CR|join on= C.ID = CR.BaseCardID|fields=C.ID|where=CR.ID='{{{1}}}'|no html}}|{{#cargo_query:tables=Cards=C,CardReleases=CR|fields=C.ID|join on= C.ID = CR.BaseCardID|where=C.CollInfo='{{{1}}}' AND CR.LanguageCode = '{{{2|EN}}}'|no html}}}}</includeonly><noinclude>
</noinclude><includeonly>{{#if: {{#pos:{{{1}}}|-}}|{{#cargo_query:tables=Cards=C,CardReleases=CR|join on= C.ID = CR.BaseCardID|fields=IFNULL(CR.ID, C.ID)|where=CR.ID='{{{1}}}'|limit=1|no html|more results text=}}|{{#cargo_query:tables=Cards=C,CardReleases=CR|fields=CR.ID|join on= C.ID = CR.BaseCardID|where=C.CollInfo='{{{1}}}' AND CR.LanguageCode = '{{{2|EN}}}'|group by=C.ID|limit=1|no html|more results text=}}}}</includeonly><noinclude>
<templatedata>
<templatedata>
{
{
"params": {
"params": {
"1": {
"1": {
"description": "Collector's info to look up (ignored if it's a wiki ID instead)",
"description": "Collector's info or Wiki ID to look up",
"example": "1R13"
"example": "1R13 or LOTR-EN01S013.0"
}
}
},
},
"description": "Performs a lookup into the cargo Cards database.  If a card WikiID is passed (such as '''LOTR-TW01S013.0'''), it will be ignored, but otherwise it will be treated as a collector's info to be looked up instead."
"description": "Performs a lookup into the cargo Cards database.  If a collector's info is passed in, the English CardRelease ID will be returned.  If a card WikiID is passed the BaseCard ID will be returned."
}
}
</templatedata>
</templatedata>
</noinclude>
</noinclude>

Latest revision as of 06:07, 11 June 2023

This is the "IDLookup" template.

It should be called in the following format:

{{IDLookup
|1=
|2=
}}

Edit the page to see the template text.

Performs a lookup into the cargo Cards database. If a collector's info is passed in, the English CardRelease ID will be returned. If a card WikiID is passed the BaseCard ID will be returned.

Template parameters[Edit template data]

ParameterDescriptionTypeStatus
11

Collector's info or Wiki ID to look up

Example
1R13 or LOTR-EN01S013.0
Unknownoptional