Template:Sandbox/Aurelain/HeroesWithSpell: Difference between revisions
From Heroes of Might and Magic: Olden Era Official Wiki
No edit summary |
No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
<includeonly><!-- | <includeonly><!-- | ||
--> | -->{{#cargo_query: | ||
{{#cargo_query: | |||
tables = | tables = | ||
Hero = H, | Hero = H, | ||
| Line 13: | Line 11: | ||
H._ID = SM._rowID | H._ID = SM._rowID | ||
| where = | | where = | ||
SM._value IN ('{{{id}}}', '{{{id}}}_special') | SM._value IN ('{{{id}}}', '{{{id}}}_special') | ||
AND H.id NOT LIKE 'campaign%' | AND H.id NOT LIKE 'campaign%' | ||
| Line 27: | Line 24: | ||
T.name = text, | T.name = text, | ||
T.language = lang, | T.language = lang, | ||
IF(SM._value LIKE '%_special%', 'peru', "") = color | |||
IF(SM._value LIKE '%_special%', ' | |||
| format = | | format = | ||
template | template | ||
Latest revision as of 10:49, 28 June 2026
This template enumerates the heroes starting with a particular spell.
Usage
1. Basic, with the id of the spell:
Input: {{Sandbox/Aurelain/HeroesWithSpell | id=night_6_magic_deaths_grip}}
Output: 
Shadespinner
Oona
Sister
Keiri
2. With lang:
Input: {{Sandbox/Aurelain/HeroesWithSpell | id=night_6_magic_deaths_grip | lang=ja}}
3. When there are no heroes to match the criteria, the `wiki_none` text is displayed:
Input: {{Sandbox/Aurelain/HeroesWithSpell | id=foo}}
Output: None
