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

From Heroes of Might and Magic: Olden Era Official Wiki
No edit summary
No edit summary
 
(41 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'><!--
     <div class='columnar'>{{#cargo_query:
        -->{{#cargo_query:
         tables =
         tables = Hero=H, Hero__start_skills=S, Hero__start_skill_levels=L
            Hero = H,
         | join on = H._rowID=S._rowID, S._rowID=L._rowID, S._position=L._position
            Hero__start_skills = S,
         | fields = S._value=id, L._value=level, CONCAT('{{{lang|en}}}') = lang
            Hero__start_skill_levels = L
         | where = H.id='{{{id|}}}'
         | join on =
            H._rowID = S._rowID,
            S._rowID = L._rowID,
            S._position = L._position
         | fields =
            S._value = id,
            L._value = level,
            CONCAT('{{{lang}}}') = lang
         | where =
            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 class='army'>{{#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 =
            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
        }}
    </div>


     <!--==== INTERNAL ID ====================================================-->
     <!--==== INTERNAL ID ====================================================-->
Line 74: 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 88: 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 106: 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 120: 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 = 真の魔法学者にとって、肉体は重荷でしかない。
}}