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 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 = Hero=H, Translation=T
     | join on = H.id=T.target_id
     | join on = H.id=T.target_id
     | where   = H.class_id='{{{class}}}'
     | where = H.class_id='{{{class}}}'
              AND T.type='hero'
                AND T.type='hero'
              AND T.language='{{{lang|en}}}'
                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= T.name
     | order by = T.name
     | fields = 'hero'=type,
     | fields = 'hero'=type,
               H.id=id,
               H.id=id,
               CONCAT('{{{lang|en}}}') = lang
               CONCAT('{{{lang|en}}}') = lang

Revision as of 07:39, 20 June 2026

Input: 

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

Output:

|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=23943"