Template:Sandbox/Aurelain/HeroesNavbox/Row: Difference between revisions
From Heroes of Might and Magic: Olden Era Official Wiki
No edit summary |
No edit summary |
||
| Line 10: | Line 10: | ||
|{{LinkIcon|type=hero_class|id={{{class}}}|lang={{{lang}}}|suffix=_icon.png}} | |{{LinkIcon|type=hero_class|id={{{class}}}|lang={{{lang}}}|suffix=_icon.png}} | ||
|{{#cargo_query: | |{{#cargo_query: | ||
tables = Hero=H, Translation=T | tables = | ||
| join on = H.id=T.target_id | Hero = H, | ||
| where = H.class_id='{{{class}}}' | Translation = T, | ||
Translation = E | |||
| join on = | |||
H.id = T.target_id, | |||
H.id = E.target_id | |||
| where = | |||
H.class_id = '{{{class}}}' | |||
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.language = 'en' | |||
| order by = | |||
T.name | |||
| fields = | |||
T.language = lang, | |||
T.name = name, | |||
E.name = name_en, | |||
| format = template | | format = template | ||
| template= | | template = Sandbox/Aurelain/HeroesNavbox/Hero | ||
| delimiter= • | | delimiter= • | ||
| named args = yes | | named args = yes | ||
}} | }} | ||
</includeonly> | </includeonly> | ||
Revision as of 08:17, 20 June 2026
Input:
{{Sandbox/Aurelain/HeroesNavbox/Row|lang=en|class=might_human}}
Output:
|
Knight
|
Aeos the Exalted • File:.png [[ | Aeos the Exalted]] • File:.png [[ | Heretic Avis]] •
Heretic Avis •
Ister • File:.png [[ | Ister]] • File:.png [[ | John Johnson]] •
John Johnson •
Keandra • File:.png [[ | Keandra]] • File:.png [[ | Kestrel]] •
Kestrel • File:.png [[ | Leon Sticky-Fingers]] •
Leon Sticky-Fingers •
Lord Edgar • File:.png [[ | Lord Edgar]] •
Old Lord Mandall • File:.png [[ | Old Lord Mandall]]


