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

From Heroes of Might and Magic: Olden Era Official Wiki
No edit summary
No edit summary
 
(18 intermediate revisions by the same user not shown)
Line 1: Line 1:
<noinclude>
<includeonly><!--
<pre><nowiki>
-->{{#cargo_query:
{{Sandbox/Aurelain/HeroesNavbox/Row|lang=en|class=might_human}}
     tables =
</nowiki></pre>
        Hero = H,
{{Sandbox/Aurelain/HeroesNavbox/Row|lang=en|class=might_human}}
        Translation = T,
</noinclude><includeonly>
        Translation = E
|{{LinkIcon|type=hero_class|id={{{class}}}|lang={{{lang}}}|suffix=_icon.png}}
     |join on =
|{{#cargo_query:
        H.id = T.target_id,
     tables = Hero=H, Translation=T
        H.id = E.target_id
     |join on = H.id=T.target_id
     |where =
     |where   = H.class_id='{{{class}}}'
        H.class_id = '{{{class}}}'
              AND T.type='hero'
        AND H.id NOT LIKE 'campaign%'
              AND T.language='{{{lang|en}}}'
        AND H.id NOT LIKE 'tutorial%'
              AND H.id NOT LIKE 'campaign%'
        AND H.id NOT LIKE 'cm_fun%'
              AND H.id NOT LIKE 'tutorial%'
        AND T.type = 'hero'
              AND H.id NOT LIKE 'cm_fun%'
        AND T.language = '{{{lang|en}}}'
     |order by= T.name
        AND E.type = 'hero'
     |fields = 'hero'=type,
        AND E.language = 'en'
              H.id=id,
     |order by =
              CONCAT('{{{lang|en}}}') = lang
        H.id
 
     |fields =
        T.language = lang,
        H.id = id,
        'hero' = type,
        '1' = filename,
        '1' = stack
     |format = template
     |format = template
     |template=LinkIcon
     |template = LinkIcon
    |delimiter=  • 
     |named args = yes
     |named args = yes
}}
}}</includeonly><!--
</includeonly>
################################################################################
--><noinclude>
<!--=========================================================================-->
==1. English:==
 
{{Color|yellow|Input:}} <code><nowiki>{{Sandbox/Aurelain/HeroesNavbox/Row|lang=en|class=might_human}}</nowiki></code>
 
{{Color|green|Output:}} {{Sandbox/Aurelain/HeroesNavbox/Row|lang=en|class=might_human}}
 
==2. Japanese:==
 
{{Color|yellow|Input:}} <code><nowiki>{{Sandbox/Aurelain/HeroesNavbox/Row|lang=ja|class=might_human}}</nowiki></code>
 
{{Color|green|Output:}} {{Sandbox/Aurelain/HeroesNavbox/Row|lang=ja|class=might_human}}
 
</noinclude>

Latest revision as of 07:34, 2 September 2026