Template:Sandbox/Aurelain/HeroInfobox/base: Difference between revisions
From Heroes of Might and Magic: Olden Era Official Wiki
No edit summary |
No edit summary |
||
| (35 intermediate revisions by the same user not shown) | |||
| Line 24: | Line 24: | ||
<!--==== ATTRIBUTES =====================================================--> | <!--==== ATTRIBUTES =====================================================--> | ||
<div class='band'>{{ | <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'>{{ | <div class='band'>{{Translation|starting_skills|{{{lang}}}}}</div> | ||
<div class='columnar'>{{#cargo_query: | <div class='columnar'>{{#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('{{{lang | CONCAT('{{{lang}}}') = 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'>{{ | <div class='band'>{{Translation|starting_spells|{{{lang}}}}}</div> | ||
<div class='columnar'>{{#cargo_query: | <div class='columnar'>{{#cargo_query: | ||
tables = | tables = | ||
Hero=H, | Hero = H, | ||
Hero__start_magics=S | Hero__start_magics = S | ||
| join on = | | join on = | ||
H._rowID=S._rowID | H._rowID = S._rowID | ||
| fields = | | fields = | ||
S._value = id, | S._value = id, | ||
CONCAT('{{{lang | CONCAT('{{{lang}}}') = lang | ||
| where = | | where = | ||
H.id='{{{id|}}}' | H.id = '{{{id|}}}' | ||
AND S._value IS NOT NULL | |||
| format = template | | format = template | ||
| template = Spell | | template = Spell | ||
| named args = yes | | named args = yes | ||
| default = {{Translation|wiki_none|{{{lang}}}}} | |||
}} | }} | ||
</div> | </div> | ||
<!--==== STARTING ARMY ==================================================--> | <!--==== STARTING ARMY ==================================================--> | ||
<div class='band'>{{ | <div class='band'>{{Translation|starting_army|{{{lang}}}}}</div> | ||
<div>{{#cargo_query: | <div class='army'>{{#cargo_query: | ||
tables = Hero=H, HeroStartSquad=HSS, Unit=U, | tables = | ||
Hero = H, | |||
|join on = H.id | HeroStartSquad = HSS, | ||
Unit = U, | |||
Translation = unit_t, | |||
Translation = unit_en | |||
|where | |join on = | ||
H.id = HSS.hero_id, | |||
HSS.unit_id = U.id, | |||
U.id = unit_t.target_id, | |||
|fields | U.id = unit_en.target_id | ||
|where = | |||
H.id = '{{{id|}}}' | |||
AND HSS.variant = 'primary' | |||
AND unit_t.type = 'unit' | |||
|order by= HSS.slot | AND unit_t.language = '{{{lang|en}}}' | ||
|format | AND unit_en.type = 'unit' | ||
|template= | 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 110: | Line 128: | ||
| faction = undead | | faction = undead | ||
| class = magic_undead | | class = magic_undead | ||
| startattack = | | startattack = 1 | ||
| startdefense = 0 | | startdefense = 0 | ||
| startspellpower = 2 | | startspellpower = 2 | ||
| startknowledge = | | 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 124: | Line 142: | ||
| faction = undead | | faction = undead | ||
| class = magic_undead | | class = magic_undead | ||
| startattack = | | startattack = 1 | ||
| startdefense = 0 | | startdefense = 0 | ||
| startspellpower = 2 | | startspellpower = 2 | ||
| startknowledge = | | 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 142: | Line 160: | ||
| faction = undead | | faction = undead | ||
| class = magic_undead | | class = magic_undead | ||
| startattack = | | startattack = 1 | ||
| startdefense = 0 | | startdefense = 0 | ||
| startspellpower = 2 | | startspellpower = 2 | ||
| startknowledge = | | startknowledge = 4 | ||
| motto = 真の魔法学者にとって、肉体は重荷でしかない。 | | motto = 真の魔法学者にとって、肉体は重荷でしかない。 | ||
}} | }} | ||
| Line 156: | Line 174: | ||
| faction = undead | | faction = undead | ||
| class = magic_undead | | class = magic_undead | ||
| startattack = | | startattack = 1 | ||
| startdefense = 0 | | startdefense = 0 | ||
| startspellpower = 2 | | startspellpower = 2 | ||
| startknowledge = | | 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
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 = 真の魔法学者にとって、肉体は重荷でしかない。
}}


