Template:Sandbox/Aurelain/Unit Infobox
Renders the right-floating unit box. Besides the obvious lang and id, there are also some parameters that we attempt to automatically infer. In case we failed to do so, they can be manually overridden with custom values:
- specialist -> the hero who specializes in this unit
- building -> the Town building that offers this unit for hire
- dwelling -> the Map building that offers this unit for hire
- bank -> the Map building that offers a one-time amount of this unit upon defeating its guardians
- growth -> the number of units offered for hire by the Town building (for faction-aligned units) or by the Map dwelling (for neutral units)
1. Temple base unit:
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("<strong class="error"><span class="scribunto-error mw-scribunto-error-9a2cb624">Script error: The function "findSpecialist" does not exist.</span></strong>") AS `specialist`,CONCAT("1") AS `units_weekly`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The function "findBuilding" 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 'format' (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 'format' (string expected, got nil).</span></strong>") AS `bank`,`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
{{Sandbox/Aurelain/Unit Infobox
| lang = en
| id = angel
}}
2. Necropolis upgraded unit:
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("<strong class="error"><span class="scribunto-error mw-scribunto-error-9a2cb624">Script error: The function "findSpecialist" does not exist.</span></strong>") AS `specialist`,CONCAT("2") AS `units_weekly`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The function "findBuilding" 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 'format' (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 'format' (string expected, got nil).</span></strong>") AS `bank`,`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
{{Sandbox/Aurelain/Unit Infobox
| lang = en
| id = vampire_upg
}}
3. Grove upgraded alternative unit:
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("<strong class="error"><span class="scribunto-error mw-scribunto-error-9a2cb624">Script error: The function "findSpecialist" does not exist.</span></strong>") AS `specialist`,CONCAT("1") AS `units_weekly`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The function "findBuilding" 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 'format' (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 'format' (string expected, got nil).</span></strong>") AS `bank`,`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
{{Sandbox/Aurelain/Unit Infobox
| lang = en
| id = phoenix_upg_alt
}}
4. Hive unit:
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("<strong class="error"><span class="scribunto-error mw-scribunto-error-9a2cb624">Script error: The function "findSpecialist" does not exist.</span></strong>") AS `specialist`,CONCAT("1") AS `units_weekly`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The function "findBuilding" 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 'format' (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 'format' (string expected, got nil).</span></strong>") AS `bank`,`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
{{Sandbox/Aurelain/Unit Infobox
| lang = en
| id = hive_queen
}}
5. Schism unit, in Japanese:
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("<strong class="error"><span class="scribunto-error mw-scribunto-error-9a2cb624">Script error: The function "findSpecialist" does not exist.</span></strong>") AS `specialist`,CONCAT("3") AS `units_weekly`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The function "findBuilding" 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 'format' (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 'format' (string expected, got nil).</span></strong>") AS `bank`,`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
{{Sandbox/Aurelain/Unit Infobox
| lang = ja
| id = succubus
}}
6. Dungeon unit:
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("<strong class="error"><span class="scribunto-error mw-scribunto-error-9a2cb624">Script error: The function "findSpecialist" does not exist.</span></strong>") AS `specialist`,CONCAT("2") AS `units_weekly`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The function "findBuilding" 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 'format' (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 'format' (string expected, got nil).</span></strong>") AS `bank`,`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
{{Sandbox/Aurelain/Unit Infobox
| lang = en
| id = hydra
}}
7. Neutral unit:
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("<strong class="error"><span class="scribunto-error mw-scribunto-error-9a2cb624">Script error: The function "findSpecialist" does not exist.</span></strong>") AS `specialist`,CONCAT("100") AS `units_weekly`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The function "findBuilding" 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 'format' (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 'format' (string expected, got nil).</span></strong>") AS `bank`,`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
{{Sandbox/Aurelain/Unit Infobox
| lang = en
| id = pixie
}}
8. Neutral upgraded unit:
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("<strong class="error"><span class="scribunto-error mw-scribunto-error-9a2cb624">Script error: The function "findSpecialist" does not exist.</span></strong>") AS `specialist`,CONCAT("") AS `units_weekly`,CONCAT("<strong class="error"><span class="scribunto-error mw-scribunto-error-9ea780d1">Script error: The function "findBuilding" 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 'format' (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 'format' (string expected, got nil).</span></strong>") AS `bank`,`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
{{Sandbox/Aurelain/Unit Infobox
| lang = en
| id = dragon_upg
}}
