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,
                AND T.type='hero'
        Translation = E
                AND T.language='{{{lang|en}}}'
     | join on =
                AND H.id NOT LIKE 'campaign%'
        H.id = T.target_id,
                AND H.id NOT LIKE 'tutorial%'
        H.id = E.target_id
                AND H.id NOT LIKE 'cm_fun%'
     | where =
    | order by = T.name
        H.class_id = '{{{class}}}'
    | fields = 'hero'=type,
        AND H.id NOT LIKE 'campaign%'
              H.id=id,
        AND H.id NOT LIKE 'tutorial%'
              CONCAT('{{{lang|en}}}') = lang
        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=LinkIcon
     | 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]]