Template:Sandbox/Aurelain/HeroInfobox/base: 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 28: Line 28:
     <!--==== STARTING SKILLS ================================================-->
     <!--==== STARTING SKILLS ================================================-->
     <div class='band'>{{Link|type=ui|id=starting_skills|lang={{{lang}}}|link=Skills}}</div>
     <div class='band'>{{Link|type=ui|id=starting_skills|lang={{{lang}}}|link=Skills}}</div>
     <div style='display:flex'><!--
     <div style='display:flex; flex-direction: column'><!--
         -->{{#cargo_query:
         -->{{#cargo_query:
         tables = Hero=H, Hero__start_skills=S, Hero__start_skill_levels=L
         tables =  
         | join on = H._rowID=S._rowID, S._rowID=L._rowID, S._position=L._position
            Hero=H,
         | fields = S._value=id, L._value=level, CONCAT('{{{lang|en}}}') = lang
            Hero__start_skills=S,
            Hero__start_skill_levels=L
         | join on =
            H._rowID=S._rowID,
            S._rowID=L._rowID,
            S._position=L._position
         | fields =
            S._value=id,
            L._value=level,
            CONCAT('{{{lang|en}}}') = lang
         | where = H.id='{{{id|}}}'
         | where = H.id='{{{id|}}}'
         | order by = S._position
         | order by = S._position
Line 57: Line 66:
     <!--==== STARTING ARMY ==================================================-->
     <!--==== STARTING ARMY ==================================================-->
     <div class='band'>{{Link|type=ui|id=starting_army|lang={{{lang}}}|link=0}}</div>
     <div class='band'>{{Link|type=ui|id=starting_army|lang={{{lang}}}|link=0}}</div>
    <div>{{#cargo_query:
        tables = Hero=H, HeroStartSquad=HSS, Unit=U,
        Translation=unit_t, Translation=unit_en
        |join on = H.id        = HSS.hero_id,
        HSS.unit_id  = U.id,
        U.id        = unit_t.target_id,
        U.id        = unit_en.target_id
        |where  = H.id = '{{{id|}}}'
        AND HSS.variant    = 'primary'
        AND unit_t.type    = 'unit'      AND unit_t.language    = '{{{lang|en}}}'
        AND unit_en.type    = 'unit'      AND unit_en.language  = 'en'
        |fields  = unit_t.name                          = name,
        unit_en.name                        = pagelink,
        CONCAT(unit_en.name, '_icon')        = filename,
        IF(HSS.min = HSS.max, HSS.min,
        CONCAT(HSS.min, " - ", HSS.max)) = text
        |order by= HSS.slot
        |format  = template
        |template= MediumIconThumbDisplay
        |named args = yes
        }}
    </div>


     <!--==== INTERNAL ID ====================================================-->
     <!--==== INTERNAL ID ====================================================-->

Revision as of 08:12, 25 August 2026

1. English:

Mag
To a true scholar of magic, the body is nothing but dead weight.
Faction
Hero Class
Attributes
Starting Skills
Starting Spells
Starting Army

20 - 27

11 - 16

8 - 11
Internal ID
necro_hero_10
{{Sandbox/Aurelain/HeroInfobox/base
    | lang = en
    | id = necro_hero_10
    | name = Mag
    | portrait = Mag.png
    | faction = undead
    | class = magic_undead
    | startattack = 4
    | startdefense = 0
    | startspellpower = 2
    | startknowledge = 1
    | motto = To a true scholar of magic, the body is nothing but dead weight.
}}

2. Japanese:

マグ
真の魔法学者にとって、肉体は重荷でしかない。
派閥
Hero Class💬
能力値
開始スキル
開始呪文
開始軍勢

20 - 27

11 - 16

8 - 11
Internal ID💬
necro_hero_10
{{Sandbox/Aurelain/HeroInfobox/base
    | lang = ja
    | id = necro_hero_10
    | name = マグ
    | portrait = Mag.png
    | faction = undead
    | class = magic_undead
    | startattack = 4
    | startdefense = 0
    | startspellpower = 2
    | startknowledge = 1
    | motto = 真の魔法学者にとって、肉体は重荷でしかない。
}}


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