Template:Sandbox/Aurelain/HeroesNavbox: Difference between revisions

From Heroes of Might and Magic: Olden Era Official Wiki
No edit summary
No edit summary
Line 8: Line 8:
! colspan=2 style=" text-align:center; letter-spacing:.3px;"|{{{title_text|Hero Classes}}}
! colspan=2 style=" text-align:center; letter-spacing:.3px;"|{{{title_text|Hero Classes}}}
|-
|-
|{{LinkIcon|type=hero_class|id=magic_demon|lang={{{lang}}}}}
{{Sandbox/Aurelain/HeroesNavbox/Row|lang={{{lang}}}|class=might_human}}
|{{#cargo_query:
{{Sandbox/Aurelain/HeroesNavbox/Row|lang={{{lang}}}|class=magic_human}}
tables  = Hero=H,
          Translation=hero_t
|join on = H.id = hero_t.target_id
|where  = H.class_id = 'magic_demon'
          AND hero_t.type  = 'hero'  AND hero_t.language = '{{{lang|en}}}'
          AND H.id NOT LIKE 'campaign%'
          AND H.id NOT LIKE 'tutorial%'
          AND H.id NOT LIKE 'cm_fun%'
|order by= hero_t.name
|fields  = CONCAT('hero')  = type,
          H.id            = id,
          CONCAT('{{{lang|en}}}') = lang
 
|format = template
|template=LinkIcon
|delimiter=  • 
|named args = yes
}}
|}
|}
</includeonly>
</includeonly>

Revision as of 07:13, 20 June 2026