Template:Sandbox/Aurelain/SpellKnownBy: Difference between revisions
From Heroes of Might and Magic: Olden Era Official Wiki
No edit summary |
No edit summary |
||
| Line 2: | Line 2: | ||
-->{{#cargo_query: | -->{{#cargo_query: | ||
tables = | tables = | ||
Hero = H | Hero = H, | ||
Translation = T, | |||
Translation = E | |||
| join on = | |||
H.id = T.target_id, | |||
H.id = E.target_id | |||
| where = | | where = | ||
H.start_magics HOLDS '{{{id}}}' | H.start_magics HOLDS '{{{id}}}' | ||
AND H.id NOT LIKE 'campaign%' | |||
AND H.id NOT LIKE 'tutorial%' | |||
AND H.id NOT LIKE 'cm_fun%' | |||
AND T.type = 'hero' | |||
AND T.language = '{{{lang|en}}}' | |||
AND E.type = 'hero' | |||
AND E.language = 'en' | |||
| fields = | | fields = | ||
CONCAT(E.name, '.png') = filename, | |||
E.name = link, | |||
T.name = text, | |||
T.language = lang | |||
| format = | | format = | ||
template | template | ||
| template = | | template = | ||
Sandbox/Aurelain/ | Sandbox/Aurelain/Link/stack | ||
| named args = | | named args = | ||
yes | yes | ||
Revision as of 14:52, 27 June 2026
This template enumerates the heroes starting with a particular spell.
Usage
1. Basic:
Input: {{Sandbox/Aurelain/SpellKnownBy | id=day_2_magic_sharp_edge}}
Output: None
2. With lang:
Input: {{Sandbox/Aurelain/SpellKnownBy | id=day_2_magic_sharp_edge | lang=ja}}
Output: None💬
3. When there are no heroes to match the criteria, the `wiki_none` text is displayed:
Input: {{Sandbox/Aurelain/SpellKnownBy | id=neutral_magic_dimension_door}}
Output: None
