Template:Sandbox/Aurelain/HeroesNavbox/Row: Difference between revisions

From Heroes of Might and Magic: Olden Era Official Wiki
Browse history interactively
← Older editNewer edit →
No edit summary
No edit summary
Line 7: Line 7:
|{{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=hero_t
     tables  = Hero=H, Translation=T
     |join on = H.id = hero_t.target_id
     |join on = H.id=T.target_id
     |where  = H.class_id = '{{{class}}}'
     |where  = H.class_id='{{{class}}}'
               AND hero_t.type = 'hero' AND hero_t.language = '{{{lang|en}}}'
               AND T.type='hero'
              AND T.language='{{{lang|en}}}'
               AND H.id NOT LIKE 'campaign%'
               AND H.id NOT LIKE 'campaign%'
               AND H.id NOT LIKE 'tutorial%'
               AND H.id NOT LIKE 'tutorial%'
               AND H.id NOT LIKE 'cm_fun%'
               AND H.id NOT LIKE 'cm_fun%'
     |order by= hero_t.name
     |order by= T.name
     |fields  = CONCAT('hero')  = type,
     |fields  = 'hero'=type,
               H.id           = id,
               H.id=id,
               CONCAT('{{{lang|en}}}') = lang
               CONCAT('{{{lang|en}}}') = lang


Revision as of 07:22, 20 June 2026

{{Sandbox/Aurelain/HeroesNavbox/Row|lang=en|class=might_human}}

|Knight |File:Human hero 5.pngAeos the Exalted • File:Human hero 6.pngHeretic Avis • File:Human hero 1.pngIster • File:Human hero 3.pngJohn Johnson • File:Human hero 7.pngKeandra • File:Human hero 4.pngKestrel • File:Human hero 2.pngLeon Sticky-Fingers • File:Human hero 8.pngLord Edgar • File:Human hero 9.pngOld Lord Mandall


Retrieved from "https://wiki.hoodedhorse.com/Heroes_of_Might_and_Magic_Olden_Era/index.php?title=Template:Sandbox/Aurelain/HeroesNavbox/Row&oldid=23940"