Template:HeroInfoBox: Difference between revisions

From Heroes of Might and Magic: Olden Era Official Wiki
No edit summary
No edit summary
Line 1: Line 1:
<includeonly>
<includeonly>
{{#cargo_query:tables=Hero=H
{{#cargo_query:tables=Hero=H,HeroClass=HC,Faction=F
|fields= H.name, H.motto, H.description, H.name_sid, H.motto_sid, H.desc_sid, H.class_id=class, H.faction, H.class_type, H.icon, H.specialization_id, H.source_path, H.start_skills, H.start_skill_levels, H.start_magics, H.cost_gold, H.start_level, H.attacks_times_before, H.mesh, H.mount, H.native_biome, H.skills_roll_variant, H.view_radius, H.stats_num, H.magic_casts_per_round, H.enable_tactics, H.tactics_placement_size, H.enable_hero_native_biome, H.offence=startattack, H.defence=startdefense, H.spell_power=startspellpower, H.intelligence=startknowledge, H.luck, H.morale, H.roll_lvl1_attack, H.roll_lvl1_defense, H.roll_lvl1_power, H.roll_lvl1_knowledge, H.roll_lvl24_attack, H.roll_lvl24_defense, H.roll_lvl24_power, H.roll_lvl24_knowledge
|join on=H.class_id=HC.id,H.faction=F.id
|fields= H.name, H.motto, H.description=biography, H.name_sid, H.motto_sid, H.desc_sid, HC.name=class, F.name=faction, H.class_type, H.icon, H.specialization_id, H.source_path, H.start_skills, H.start_skill_levels, H.start_magics, H.cost_gold, H.start_level, H.attacks_times_before, H.mesh, H.mount, H.native_biome, H.skills_roll_variant, H.view_radius, H.stats_num, H.magic_casts_per_round, H.enable_tactics, H.tactics_placement_size, H.enable_hero_native_biome,
IF(H.offence IS NULL, HC.offence, H.offence)=startattack,  
IF(H.defence IS NULL, HC.defence, H.defence)=startdefense,  
IF(H.spell_power IS NULL, HC.spell_power, H.spell_power)=startspellpower,
IF(H.intelligence IS NULL, HC.intelligence, H.intelligence)=startknowledge,  
H.luck, H.morale, H.roll_lvl1_attack, H.roll_lvl1_defense, H.roll_lvl1_power, H.roll_lvl1_knowledge, H.roll_lvl24_attack, H.roll_lvl24_defense, H.roll_lvl24_power, H.roll_lvl24_knowledge
|where=H.id='{{{id}}}'
|where=H.id='{{{id}}}'
|format=template
|format=template

Revision as of 17:16, 13 May 2026


This article is a stub. You can help this wiki by expanding it.

The template is under construction.

Usage

Capitalize all names and titles properly.


Error: No field named "name" found for the database table "Hero".


{{Template:HeroInfoBox|lang=en|id=demon_hero_4}}