Template:HeroesWithSpell: Difference between revisions
From Heroes of Might and Magic: Olden Era Official Wiki
Created page with "<includeonly><!-- -->{{#cargo_query: tables = Hero = H, Translation = T, Translation = E | join on = H.id = T.target_id, H.id = E.target_id | where = 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 = CONCAT(E.name, '.png') = filename, E.na..." |
No edit summary |
||
| Line 9: | Line 9: | ||
H.id = E.target_id | H.id = E.target_id | ||
| where = | | where = | ||
H.start_magics HOLDS '{{{id}}}' | (H.start_magics HOLDS '{{{id}}}' OR H.start_magics HOLDS '{{{id}}}_special') | ||
AND H.id NOT LIKE 'campaign%' | AND H.id NOT LIKE 'campaign%' | ||
AND H.id NOT LIKE 'tutorial%' | AND H.id NOT LIKE 'tutorial%' | ||
Revision as of 16:38, 27 June 2026
This template enumerates the heroes starting with a particular spell.
Usage
1. Basic, with the id of the spell:
Input: {{HeroesWithSpell | id=primal_3_magic_wean}}
Output: 
Leira
2. With lang:
Input: {{HeroesWithSpell | id=primal_3_magic_wean | lang=ja}}
Output: レイラ
3. When there are no heroes to match the criteria, the `wiki_none` text is displayed:
Input: {{HeroesWithSpell | id=neutral_magic_dimension_door}}
Output: None
