Template:Sandbox/Aurelain/HeroInfobox/base: Difference between revisions

From Heroes of Might and Magic: Olden Era Official Wiki
No edit summary
No edit summary
 
(39 intermediate revisions by the same user not shown)
Line 24: Line 24:


     <!--==== ATTRIBUTES =====================================================-->
     <!--==== ATTRIBUTES =====================================================-->
     <div class='band'>{{Link|type=ui|id=stats|lang={{{lang}}}}}</div>
     <div class='band'>{{Translation|wiki_start_attributes|{{{lang}}}}}</div>
    <div style='display:flex;color:#fff'>
        {{StatDisplay|id=offence|stat={{{startattack}}}|lang={{{lang}}}}}
        {{StatDisplay|id=defence|stat={{{startdefense}}}|lang={{{lang}}}}}
        {{StatDisplay|id=spellPower|stat={{{startspellpower}}}|lang={{{lang}}}}}
        {{StatDisplay|id=intelligence|stat={{{startknowledge}}}|lang={{{lang}}}}}
    </div>


     <!--==== STARTING SKILLS ================================================-->
     <!--==== STARTING SKILLS ================================================-->
     <div class='band'>{{Link|type=ui|id=starting_skills|lang={{{lang}}}|link=Skills}}</div>
     <div class='band'>{{Translation|starting_skills|{{{lang}}}}}</div>
     <div style='display:flex; flex-direction: column'><!--
     <div class='columnar'>{{#cargo_query:
        -->{{#cargo_query:
         tables =
         tables =
             Hero=H,
             Hero = H,
             Hero__start_skills=S,
             Hero__start_skills = S,
             Hero__start_skill_levels=L
             Hero__start_skill_levels = L
         | join on =
         | join on =
             H._rowID=S._rowID,
             H._rowID = S._rowID,
             S._rowID=L._rowID,
             S._rowID = L._rowID,
             S._position=L._position
             S._position = L._position
         | fields =
         | fields =
             S._value=id,
             S._value = id,
             L._value=level,
             L._value = level,
            CONCAT('64px') = size
             CONCAT('{{{lang}}}') = lang
             CONCAT('{{{lang|en}}}') = lang
         | where =
         | where = H.id='{{{id|}}}'
            H.id = '{{{id|}}}'
            AND S._value IS NOT NULL
         | order by = S._position
         | order by = S._position
         | format = template
         | format = template
         | template = Skill
         | template = Skill
         | named args= yes
         | named args = yes
        | default = {{Translation|wiki_none|{{{lang}}}}}
         }}
         }}
     </div>
     </div>


     <!--==== STARTING SPELLS ================================================-->
     <!--==== STARTING SPELLS ================================================-->
     <div class='band'>{{Link|type=ui|id=starting_spells|lang={{{lang}}}|link=Spells}}</div>
     <div class='band'>{{Translation|starting_spells|{{{lang}}}}}</div>
     <div><!--
     <div class='columnar'>{{#cargo_query:
        -->{{#cargo_query:
         tables =
         tables = Hero=H, Hero__start_magics=S
            Hero = H,
         | join on = H._rowID=S._rowID
            Hero__start_magics = S
         | fields = S._value=id, CONCAT('{{{lang|en}}}') = lang
         | join on =
         | where = H.id='{{{id|}}}'
            H._rowID = S._rowID
         | fields =
            S._value = id,
            CONCAT('{{{lang}}}') = lang
         | where =
            H.id = '{{{id|}}}'
            AND S._value IS NOT NULL
         | format = template
         | format = template
         | template = SpellDisplay
         | template = Spell
         | named args = yes
         | named args = yes
        | default = {{Translation|wiki_none|{{{lang}}}}}
         }}
         }}
     </div>
     </div>


     <!--==== STARTING ARMY ==================================================-->
     <!--==== STARTING ARMY ==================================================-->
     <div class='band'>{{Link|type=ui|id=starting_army|lang={{{lang}}}|link=0}}</div>
     <div class='band'>{{Translation|starting_army|{{{lang}}}}}</div>
     <div>{{#cargo_query:
     <div class='army'>{{#cargo_query:
         tables = Hero=H, HeroStartSquad=HSS, Unit=U,
         tables =
        Translation=unit_t, Translation=unit_en
            Hero = H,
         |join on = H.id         = HSS.hero_id,
            HeroStartSquad = HSS,
        HSS.unit_id = U.id,
            Unit = U,
        U.id         = unit_t.target_id,
            Translation = unit_t,
        U.id         = unit_en.target_id
            Translation = unit_en
         |where   = H.id = '{{{id|}}}'
         |join on =
        AND HSS.variant     = 'primary'
            H.id = HSS.hero_id,
        AND unit_t.type     = 'unit'       AND unit_t.language   = '{{{lang|en}}}'
            HSS.unit_id = U.id,
        AND unit_en.type   = 'unit'       AND unit_en.language   = 'en'
            U.id = unit_t.target_id,
         |fields = unit_t.name                          = name,
            U.id = unit_en.target_id
        unit_en.name                        = pagelink,
         |where =
        CONCAT(unit_en.name, '_icon')       = filename,
            H.id = '{{{id|}}}'
        IF(HSS.min = HSS.max, HSS.min,
            AND HSS.variant = 'primary'
        CONCAT(HSS.min, " - ", HSS.max)) = text
            AND unit_t.type = 'unit'
         |order by= HSS.slot
            AND unit_t.language = '{{{lang|en}}}'
         |format = template
            AND unit_en.type = 'unit'
         |template= MediumIconThumbDisplay
            AND unit_en.language = 'en'
         |fields =
            U.id = id,
            CONCAT('{{{lang}}}') = lang,
            CONCAT('1') = stack,
            IF(HSS.min = HSS.max, HSS.min, CONCAT(HSS.min, "-", HSS.max)) = text
         |order by = HSS.slot
         |format = template
         |template = Unit
         |named args = yes
         |named args = yes
         }}
         }}
Line 106: Line 128:
     | faction = undead
     | faction = undead
     | class = magic_undead
     | class = magic_undead
     | startattack = 4
     | startattack = 1
     | startdefense = 0
     | startdefense = 0
     | startspellpower = 2
     | startspellpower = 2
     | startknowledge = 1
     | startknowledge = 4
     | motto = To a true scholar of magic, the body is nothing but dead weight.
     | motto = To a true scholar of magic, the body is nothing but dead weight.
}}
}}
Line 120: Line 142:
     | faction = undead
     | faction = undead
     | class = magic_undead
     | class = magic_undead
     | startattack = 4
     | startattack = 1
     | startdefense = 0
     | startdefense = 0
     | startspellpower = 2
     | startspellpower = 2
     | startknowledge = 1
     | startknowledge = 4
     | motto = To a true scholar of magic, the body is nothing but dead weight.
     | motto = To a true scholar of magic, the body is nothing but dead weight.
}}
}}
Line 138: Line 160:
     | faction = undead
     | faction = undead
     | class = magic_undead
     | class = magic_undead
     | startattack = 4
     | startattack = 1
     | startdefense = 0
     | startdefense = 0
     | startspellpower = 2
     | startspellpower = 2
     | startknowledge = 1
     | startknowledge = 4
     | motto = 真の魔法学者にとって、肉体は重荷でしかない。
     | motto = 真の魔法学者にとって、肉体は重荷でしかない。
}}
}}
Line 152: Line 174:
     | faction = undead
     | faction = undead
     | class = magic_undead
     | class = magic_undead
     | startattack = 4
     | startattack = 1
     | startdefense = 0
     | startdefense = 0
     | startspellpower = 2
     | startspellpower = 2
     | startknowledge = 1
     | startknowledge = 4
     | motto = 真の魔法学者にとって、肉体は重荷でしかない。
     | motto = 真の魔法学者にとって、肉体は重荷でしかない。
}}
}}

Latest revision as of 19:30, 25 August 2026

1. English:

Mag
To a true scholar of magic, the body is nothing but dead weight.
Faction
Hero Class
Starting Attributes
Attack 1
Starting Skills
Starting Spells
Starting Army
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 = 1
    | startdefense = 0
    | startspellpower = 2
    | startknowledge = 4
    | motto = To a true scholar of magic, the body is nothing but dead weight.
}}

2. Japanese:

マグ
真の魔法学者にとって、肉体は重荷でしかない。
Hero Class💬
Starting Attributes💬
開始スキル
開始呪文
開始軍勢
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 = 1
    | startdefense = 0
    | startspellpower = 2
    | startknowledge = 4
    | motto = 真の魔法学者にとって、肉体は重荷でしかない。
}}