Template:UnitInfobox: Difference between revisions

From Heroes of Might and Magic: Olden Era Official Wiki
Browse history interactively
Newer edit →
Created page with "<includeonly><!-- -->{{#cargo_query: tables = Unit = U, <!-- Unit --> Unit = U0, <!-- Base unit --> Translation = T, <!-- Translation of name in desired language --> Translation = E, <!-- Translation of name in English --> | join on = U.id = T.target_id, U.id = E.target_id, {{#switch: {{#sub: {{{id}}} | -4 }} | #default = U.id = U0.id | _upg = U.base_sid = U0.id | _alt =..."
 
No edit summary
Line 31: Line 31:
     U.tier = tier,
     U.tier = tier,
     U.squad_value = squad_value,
     U.squad_value = squad_value,
     {{#if:{{{specialist|}}}|
     <!-- Lua fields -->
        CONCAT("{{{specialist}}}") = specialist,
    CONCAT("{{#invoke:UnitInfobox|findGrowth|id={{{id}}}}}") = units_weekly,
     |}}
    CONCAT("{{#invoke:UnitInfobox|findBuilding|id={{{id}}}}}") = building,
    CONCAT("{{#invoke:UnitInfobox|findDwelling|id={{{id}}}}}") = dwelling,
    CONCAT("{{#invoke:UnitInfobox|findDwelling|id={{{id}}}|bank=1}}") = bank,
     CONCAT("{{#invoke:UnitInfobox|findSpecialist|id={{{id}}}}}") = specialist,
     <!-- Unit costs -->
     <!-- Unit costs -->
     U.gold_cost = gold_cost,
     U.gold_cost = gold_cost,
Line 76: Line 79:
| named args =
| named args =
     yes
     yes
}}<!--
}}</includeonly><!--
################################################################################
################################################################################
--></includeonly><noinclude>
--><noinclude>
Renders the right-floating unit box.
 
----


1. Temple base unit:
1. Temple base unit:
Line 122: Line 128:


---- <!--====================================================================-->
---- <!--====================================================================-->
4. Hive unit, with specialist hero:
4. Hive unit:
{{UnitInfobox
{{UnitInfobox
| lang = en
| lang = en
| id = hive_queen
| id = hive_queen
| specialist = demon_hero_14
}}
}}
<pre><nowiki>
<pre><nowiki>
Line 132: Line 137:
| lang = en
| lang = en
| id = hive_queen
| id = hive_queen
| specialist = demon_hero_14
}}
}}
</nowiki></pre>
</nowiki></pre>

Revision as of 06:06, 17 July 2026

Renders the right-floating unit box.

1. Temple base unit:

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 '"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The...' at line 1

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("angel") 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("1") AS `units_weekly`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The function &quot;findBuilding&quot; does not exist.</span></strong>") AS `building`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-f3340c9b">Lua error in Module:UnitInfobox at line 27: bad argument #3 to &#039;format&#039; (string expected, got nil).</span></strong>") AS `dwelling`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-f3340c9b">Lua error in Module:UnitInfobox at line 27: bad argument #3 to &#039;format&#039; (string expected, got nil).</span></strong>") AS `bank`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9a2cb624">Script error: The function &quot;findSpecialist&quot; does not exist.</span></strong>") AS `specialist`,`U`.`gold_cost` AS `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` = 'angel' 

   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  

{{UnitInfobox
| lang = en
| id = angel
}}

2. Necropolis upgraded unit:

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 '"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The...' at line 1

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("vampire") 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("2") AS `units_weekly`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The function &quot;findBuilding&quot; does not exist.</span></strong>") AS `building`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-f3340c9b">Lua error in Module:UnitInfobox at line 27: bad argument #3 to &#039;format&#039; (string expected, got nil).</span></strong>") AS `dwelling`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-f3340c9b">Lua error in Module:UnitInfobox at line 27: bad argument #3 to &#039;format&#039; (string expected, got nil).</span></strong>") AS `bank`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9a2cb624">Script error: The function &quot;findSpecialist&quot; does not exist.</span></strong>") AS `specialist`,`U`.`gold_cost` AS `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`.`base_sid`=`U0`.`id`)) WHERE `U`.`id` = 'vampire_upg' 

   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  

{{UnitInfobox
| lang = en
| id = vampire_upg
}}

3. Grove upgraded alternative unit:

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 '"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The...' at line 1

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("phoenix") 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("1") AS `units_weekly`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The function &quot;findBuilding&quot; does not exist.</span></strong>") AS `building`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-f3340c9b">Lua error in Module:UnitInfobox at line 27: bad argument #3 to &#039;format&#039; (string expected, got nil).</span></strong>") AS `dwelling`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-f3340c9b">Lua error in Module:UnitInfobox at line 27: bad argument #3 to &#039;format&#039; (string expected, got nil).</span></strong>") AS `bank`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9a2cb624">Script error: The function &quot;findSpecialist&quot; does not exist.</span></strong>") AS `specialist`,`U`.`gold_cost` AS `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`.`base_sid`=`U0`.`upgrade_sid`)) WHERE `U`.`id` = 'phoenix_upg_alt' 

   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  

{{UnitInfobox
| lang = en
| id = phoenix_upg_alt
}}

4. Hive unit:

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 '"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The...' at line 1

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("1") AS `units_weekly`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The function &quot;findBuilding&quot; does not exist.</span></strong>") AS `building`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-f3340c9b">Lua error in Module:UnitInfobox at line 27: bad argument #3 to &#039;format&#039; (string expected, got nil).</span></strong>") AS `dwelling`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-f3340c9b">Lua error in Module:UnitInfobox at line 27: bad argument #3 to &#039;format&#039; (string expected, got nil).</span></strong>") AS `bank`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9a2cb624">Script error: The function &quot;findSpecialist&quot; does not exist.</span></strong>") AS `specialist`,`U`.`gold_cost` AS `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  

{{UnitInfobox
| lang = en
| id = hive_queen
}}

5. Schism unit, in Japanese:

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 '"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The...' at line 1

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("succubus") 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("3") AS `units_weekly`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The function &quot;findBuilding&quot; does not exist.</span></strong>") AS `building`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-f3340c9b">Lua error in Module:UnitInfobox at line 27: bad argument #3 to &#039;format&#039; (string expected, got nil).</span></strong>") AS `dwelling`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-f3340c9b">Lua error in Module:UnitInfobox at line 27: bad argument #3 to &#039;format&#039; (string expected, got nil).</span></strong>") AS `bank`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9a2cb624">Script error: The function &quot;findSpecialist&quot; does not exist.</span></strong>") AS `specialist`,`U`.`gold_cost` AS `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` = 'succubus' 

   AND `T`.`type` = 'unit'
   AND `T`.`language` = 'ja'
   AND `E`.`type` = 'unit'
   AND `E`.`language` = 'en'  ORDER BY `U0`.`_pageID`,`E`.`_pageID`,`T`.`_pageID`,`U`.`_pageID`,`T`.`language` LIMIT 100  

{{UnitInfobox
| lang = ja
| id = succubus
}}

6. Dungeon unit:

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 '"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The...' at line 1

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("hydra") 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("2") AS `units_weekly`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The function &quot;findBuilding&quot; does not exist.</span></strong>") AS `building`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-f3340c9b">Lua error in Module:UnitInfobox at line 27: bad argument #3 to &#039;format&#039; (string expected, got nil).</span></strong>") AS `dwelling`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-f3340c9b">Lua error in Module:UnitInfobox at line 27: bad argument #3 to &#039;format&#039; (string expected, got nil).</span></strong>") AS `bank`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9a2cb624">Script error: The function &quot;findSpecialist&quot; does not exist.</span></strong>") AS `specialist`,`U`.`gold_cost` AS `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` = 'hydra' 

   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  

{{UnitInfobox
| lang = en
| id = hydra
}}

7. Neutral unit:

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 '"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The...' at line 1

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("pixie") 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("100") AS `units_weekly`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The function &quot;findBuilding&quot; does not exist.</span></strong>") AS `building`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-f3340c9b">Lua error in Module:UnitInfobox at line 27: bad argument #3 to &#039;format&#039; (string expected, got nil).</span></strong>") AS `dwelling`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-f3340c9b">Lua error in Module:UnitInfobox at line 27: bad argument #3 to &#039;format&#039; (string expected, got nil).</span></strong>") AS `bank`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9a2cb624">Script error: The function &quot;findSpecialist&quot; does not exist.</span></strong>") AS `specialist`,`U`.`gold_cost` AS `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` = 'pixie' 

   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  

{{UnitInfobox
| lang = en
| id = pixie
}}

8. Neutral upgraded unit:

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 '"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The...' at line 1

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("dragon") 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("") AS `units_weekly`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The function &quot;findBuilding&quot; does not exist.</span></strong>") AS `building`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-f3340c9b">Lua error in Module:UnitInfobox at line 27: bad argument #3 to &#039;format&#039; (string expected, got nil).</span></strong>") AS `dwelling`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-f3340c9b">Lua error in Module:UnitInfobox at line 27: bad argument #3 to &#039;format&#039; (string expected, got nil).</span></strong>") AS `bank`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9a2cb624">Script error: The function &quot;findSpecialist&quot; does not exist.</span></strong>") AS `specialist`,`U`.`gold_cost` AS `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`.`base_sid`=`U0`.`id`)) WHERE `U`.`id` = 'dragon_upg' 

   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  

{{UnitInfobox
| lang = en
| id = dragon_upg
}}
Retrieved from "https://wiki.hoodedhorse.com/Heroes_of_Might_and_Magic_Olden_Era/index.php?title=Template:UnitInfobox&oldid=28677"