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

From Heroes of Might and Magic: Olden Era Official Wiki
Browse history interactively
Created page with "<noinclude> <pre><nowiki> {{Sandbox/Aurelain/HeroesNavbox/Row|lang=en|class=might_human}} </nowiki></pre> {{Sandbox/Aurelain/HeroesNavbox/Row|lang=en|class=might_human}} </noinclude><includeonly> |{{LinkIcon|type=hero_class|id={{{class}}}|lang={{{lang}}}}} |{{#cargo_query: tables = Hero=H, Translation=hero_t |join on = H.id = hero_t.target_id |where = H.class_id = '{{{class}}}' AND hero_t.type = 'hero' AND hero_t.language = '{{{lang|en}}}'..."
 
No edit summary
 
(20 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}}}}}
     |join on =
|{{#cargo_query:
        H.id = T.target_id,
     tables = Hero=H, Translation=hero_t
        H.id = E.target_id
     |join on = H.id = hero_t.target_id
     |where =
     |where   = H.class_id = '{{{class}}}'
        H.class_id = '{{{class}}}'
              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%'
        AND T.type = 'hero'
     |order by= hero_t.name
        AND T.language = '{{{lang|en}}}'
     |fields = CONCAT('hero')  = type,
        AND E.type = 'hero'
              H.id           = id,
        AND E.language = 'en'
              CONCAT('{{{lang|en}}}') = lang
     |order by =
 
        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

1. English:

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

Output: IsterLeon
Sticky-FingersJohn
JohnsonKestrelAeos
the
ExaltedHeretic
AvisKeandraLord
EdgarOld
Lord
Mandall

2. Japanese:

Input: {{Sandbox/Aurelain/HeroesNavbox/Row|lang=ja|class=might_human}}

Output: イスターレオン・スティッキー＝フィンガーズジョン・ジョンソンケストレル高尚のイーオス異端のエイヴィスキアンドラエドガー卿老マンダル卿


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