Template:Sandbox/Aurelain/HeroesNavbox: 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=magic_demon|lang={{{lang}}}}}
|{{LinkIcon|type=hero_class|id=magic_demon|lang={{{lang}}}}}
|{{#cargo_query:
|{{#cargo_query:
    tables = Hero=H, Translation=hero_t
tables = Hero=H,
    |join on = H.id=hero_t.target_id
          Translation=hero_t
    |where = H.class_type='magic_demon'
|join on = H.id = hero_t.target_id
        AND hero_t.type='hero'
|where   = H.class_type = 'magic_demon'
        AND hero_t.language='{{{lang|en}}}'
          AND hero_t.type = 'hero' AND hero_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%'
    |fields  = CONCAT('hero')  = type,
|order by= hero_t.name
              H.id            = id,
|fields  = CONCAT('hero')  = type,
              CONCAT('{{{lang|en}}}') = lang
          H.id            = id,
    |order by = hero_t.name
          CONCAT('{{{lang|en}}}') = lang
    |limit = 20
 
    |format = table
|format = table
|named args = yes
}}
}}
|}
|}
</includeonly>
</includeonly>

Revision as of 13:12, 19 June 2026

{{Sandbox/Aurelain/HeroesNavbox|lang=ja}}
Hero Classes
ヘラルド No results


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