Template:Sandbox/Aurelain/Unit Infobox

From Heroes of Might and Magic: Olden Era Official Wiki
Revision as of 15:23, 15 July 2026 by Aurelain (talk | contribs)


1. Temple base unit:

Angel
Faction
Tier
VII
Cost
2400Gold 1Gems
Squad value
3660
Stats
Health
225
Attack
30
Defense
30
Damage
50-75
Morale
0
Luck
0
Initiative
8
Speed
4
Related Units
Base unit
Angel
Upgrade A
Upgrade B
Internal ID
angel
{{Sandbox/Aurelain/Unit Infobox
| lang = en
| id = angel
}}

2. Necropolis upgraded unit:

Vampire Lord
Faction
Tier
VII
Cost
(Upgrade cost)
( 800Gold 1Mercury)
Squad value
3276
Stats
Health
175This stat is higher compared to the base unit.

Base: 150
Increase: +25
Attack
22
Defense
26This stat is higher compared to the base unit.

Base: 20
Increase: +6
Damage
30This stat is higher compared to the base unit.

Base: 25
Increase: +5-30This stat is higher compared to the base unit.

Base: 25
Increase: +5
Morale
0
Luck
0
Initiative
13This stat is higher compared to the base unit.

Base: 11
Increase: +2
Speed
8This stat is higher compared to the base unit.

Base: 6
Increase: +2
Related Units
Base unit
Upgrade A
Vampire Lord
Upgrade B
Internal ID
vampire_upg
{{Sandbox/Aurelain/Unit Infobox
| lang = en
| id = vampire_upg
}}

3. Grove upgraded alternative unit:

Energy Phoenix
Faction
Tier
VII
Cost
(Upgrade cost)
( 1900Gold 1Crystals)
Squad value
7699
Stats
Health
250This stat is higher compared to the base unit.

Base: 200
Increase: +50
Attack
28
Defense
39This stat is higher compared to the base unit.

Base: 26
Increase: +13
Damage
45-65
Morale
0
Luck
0
Initiative
15This stat is higher compared to the base unit.

Base: 14
Increase: +1
Speed
10This stat is higher compared to the base unit.

Base: 8
Increase: +2
Related Units
Base unit
Upgrade A
Upgrade B
Energy Phoenix
Internal ID
phoenix_upg_alt
{{Sandbox/Aurelain/Unit Infobox
| lang = en
| id = phoenix_upg_alt
}}

4. Hive unit, with specialist hero:

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.`gold_cost` = gold_cost AS `CONCAT( demon hero 14 )=specialist\x0A U gold...' at line 2

Function: CargoSQLQuery::run Query: SELECT `U0`.`_pageID` AS `cargo_backlink_page_id_U0`,`E`.`_pageID` AS `cargo_backlink_page_id_E`,`T`.`_pageID` AS `cargo_backlink_page_id_T`,`U`.`_pageID` AS `cargo_backlink_page_id_U`,`T`.`language` AS `lang`,`U`.`id` AS `id`,CONCAT("hive_queen") AS `base_id`,`E`.`name` AS `name_en`,`T`.`name` AS `name`,`U`.`faction` AS `faction`,`U`.`tier` AS `tier`,`U`.`squad_value` AS `squad_value`,CONCAT("demon_hero_14")=specialist 

   `U`.`gold_cost` = gold_cost AS `CONCAT( demon hero 14 )=specialist
   U gold cost = gold cost`,`U`.`wood_cost` AS `wood_cost`,`U`.`ore_cost` AS `ore_cost`,`U`.`mercury_cost` AS `mercury_cost`,`U`.`dust_cost` AS `dust_cost`,`U`.`crystal_cost` AS `crystal_cost`,`U`.`gemstone_cost` AS `gemstone_cost`,`U`.`hp` AS `hp`,`U`.`offence` AS `offence`,`U`.`defence` AS `defence`,`U`.`damage_min` AS `damage_min`,`U`.`damage_max` AS `damage_max`,`U`.`morale` AS `morale`,`U`.`luck` AS `luck`,`U`.`initiative` AS `initiative`,`U`.`speed` AS `speed`,`U0`.`gold_cost` AS `gold_cost0`,`U0`.`wood_cost` AS `wood_cost0`,`U0`.`ore_cost` AS `ore_cost0`,`U0`.`mercury_cost` AS `mercury_cost0`,`U0`.`dust_cost` AS `dust_cost0`,`U0`.`crystal_cost` AS `crystal_cost0`,`U0`.`gemstone_cost` AS `gemstone_cost0`,`U0`.`hp` AS `hp0`,`U0`.`offence` AS `offence0`,`U0`.`defence` AS `defence0`,`U0`.`damage_min` AS `damage_min0`,`U0`.`damage_max` AS `damage_max0`,`U0`.`morale` AS `morale0`,`U0`.`luck` AS `luck0`,`U0`.`initiative` AS `initiative0`,`U0`.`speed` AS `speed0`  FROM `mw4v_cargo__Unit` `U` LEFT OUTER JOIN `mw4v_cargo__Translation` `T` ON ((`U`.`id`=`T`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `E` ON ((`U`.`id`=`E`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Unit` `U0` ON ((`U`.`id`=`U0`.`id`))   WHERE `U`.`id` = 'hive_queen'
   AND `T`.`type` = 'unit'
   AND `T`.`language` = 'en'
   AND `E`.`type` = 'unit'
   AND `E`.`language` = 'en'  ORDER BY `U0`.`_pageID`,`E`.`_pageID`,`T`.`_pageID`,`U`.`_pageID`,`T`.`language` LIMIT 100  

{{Sandbox/Aurelain/Unit Infobox
| lang = en
| id = hive_queen
| specialist = demon_hero_14
}}

5. Schism unit, in Japanese:

信徒
派閥
ティア
V
Cost💬
Squad value💬
623
Stats💬
HP
60
攻撃力
16
防御力
13
ダメージ
14-20
士気
0
幸運
0
イニシアチブ
5
素早さ
2
Related Units💬
Base unit💬
信徒
Upgrade A💬
Upgrade B💬
Internal ID💬
succubus
{{Sandbox/Aurelain/Unit Infobox
| lang = ja
| id = succubus
}}

6. Dungeon unit:

Hydra
Faction
Tier
VI
Cost
1200Gold
Squad value
1345
Stats
Health
130
Attack
24
Defense
22
Damage
25-28
Morale
0
Luck
0
Initiative
6
Speed
4
Related Units
Base unit
Hydra
Upgrade A
Upgrade B
Internal ID
hydra
{{Sandbox/Aurelain/Unit Infobox
| lang = en
| id = hydra
}}

7. Neutral unit:

Pixie
Faction
Tier
I
Cost
100Gold
Squad value
75
Stats
Health
6
Attack
2
Defense
2
Damage
2-2
Morale
0
Luck
0
Initiative
8
Speed
8
Internal ID
pixie
{{Sandbox/Aurelain/Unit Infobox
| lang = en
| id = pixie
}}

8. Neutral upgraded unit:

Red Dragon
Faction
Tier
VII
Cost
5000Gold
(Upgrade cost)
( 2000Gold)
Squad value
8628
Stats
Health
325This stat is higher compared to the base unit.

Base: 250
Increase: +75
Attack
33This stat is higher compared to the base unit.

Base: 29
Increase: +4
Defense
32
Damage
60This stat is higher compared to the base unit.

Base: 50
Increase: +10-70This stat is higher compared to the base unit.

Base: 60
Increase: +10
Morale
0
Luck
0
Initiative
12This stat is higher compared to the base unit.

Base: 10
Increase: +2
Speed
9This stat is higher compared to the base unit.

Base: 7
Increase: +2
Internal ID
dragon_upg
{{Sandbox/Aurelain/Unit Infobox
| lang = en
| id = dragon_upg
}}
Retrieved from "https://wiki.hoodedhorse.com/Heroes_of_Might_and_Magic_Olden_Era/index.php?title=Template:Sandbox/Aurelain/Unit_Infobox&oldid=28495"