Template:HeroDef - Revision history

76561198026315966: obelisk-bot: Pushing translation table rework

2026-05-14T20:48:09Z

obelisk-bot: Pushing translation table rework

← Older revision		Revision as of 20:48, 14 May 2026
Line 5:		Line 5:
	The bot emits these per-hero blocks at <code>Data:Hero/<id></code>:		The bot emits these per-hero blocks at <code>Data:Hero/<id></code>:

	# <code><nowiki>{{HeroDef \| id~~=… \| name=… \| motto=… \| desc~~=… \| start_skills=… \| start_magics=… \| …}}</nowiki></code> — main row. <code>start_skills</code> and <code>start_magics</code> are comma-joined SID lists inline on this row (no side tables for them).		# <code><nowiki>{{HeroDef \| id=… \| start_skills=… \| start_magics=… \| …}}</nowiki></code> — main row. <code>start_skills</code> and <code>start_magics</code> are comma-joined SID lists inline on this row (no side tables for them).
	# <code><nowiki>{{TranslationDef \| type=hero \| target_id=<id> \| …}}</nowiki></code> — name/~~desc translation (~~per ~~D-026)~~.		# <code><nowiki>{{TranslationDef \| type=hero \| target_id=<id> \| language=… \| name=… \| description=… }}</nowiki></code> × N — name/description, one row per language.
	# <code><nowiki>{{TranslationDef \| type=hero_motto \| target_id=<id> \| …}}</nowiki></code> — motto translation (~~separate row, kept off~~ the ~~schema-specialization path; per D-027~~).		# <code><nowiki>{{TranslationDef \| type=hero_motto \| target_id=<id> \| language=… \| description=… }}</nowiki></code> × N — motto, a separate translation key, one row per language (motto text goes in the <code>description</code> column since it may carry markup).
	# <code><nowiki>{{HeroStartSquadDef \| …}}</nowiki></code> × N — one per starting squad slot (primary + alt collapsed via <code>variant</code> discriminator).		# <code><nowiki>{{HeroStartSquadDef \| …}}</nowiki></code> × N — one per starting squad slot (primary + alt collapsed via <code>variant</code> discriminator).

Line 13:		Line 13:
	{{#cargo_declare:_table=Hero		{{#cargo_declare:_table=Hero
	\| id = String		\| id = String
	~~\| name = String~~
	~~\| motto = Wikitext~~
	~~\| description = Wikitext~~
	\| name_sid = String		\| name_sid = String
	\| motto_sid = String		\| motto_sid = String
Line 60:		Line 57:
	{{HeroDef		{{HeroDef
	\| id = String		\| id = String
	~~\| name = String~~
	~~\| motto~~ = ~~Wikitext~~		<!-- Localization references — display text lives in the Translation table:
	\| description = ~~Wikitext~~		type='hero' carries name+description, type='hero_motto' carries the motto -->
	\| name_sid = String		\| name_sid = String
	\| motto_sid = String		\| motto_sid = String
Line 85:		Line 82:

	<!-- Note: spell level / isLearned are dropped (constant in the		<!-- Note: spell level / isLearned are dropped (constant in the
	2026-05-03 corpus ~~per D-027 revised~~). Skill level is preserved		2026-05-03 corpus). Skill level is preserved because 8/208
	because 8/208 entries diverge from the default of 1. -->		entries diverge from the default of 1. -->


Line 143:		Line 140:
	== Field notes ==		== Field notes ==
	* '''<code>id</code>''' is the hero's source JSON id (e.g. <code>human_hero_1</code>, <code>campaign_M10_hero_demon_1</code>).		* '''<code>id</code>''' is the hero's source JSON id (e.g. <code>human_hero_1</code>, <code>campaign_M10_hero_demon_1</code>).
	* '''<code>name_sid</code>/<code>motto_sid</code>/<code>desc_sid</code>''' carry the source SID for traceability ~~and as the join key to the Translation rows~~. Faction heroes use implicit conventions (<code><id></code> / <code><id>_motto</code> / <code><id>_description</code>); campaign heroes set them explicitly in source JSON.		* '''<code>name_sid</code>/<code>motto_sid</code>/<code>desc_sid</code>''' carry the source SID for traceability only. Faction heroes use implicit conventions (<code><id></code> / <code><id>_motto</code> / <code><id>_description</code>); campaign heroes set them explicitly in source JSON.
	* '''~~<code>~~name</~~code>~~/<code>~~motto~~</code>/<code>~~desc~~</code>~~'''~~ carry the ~~resolved English text inline~~. ~~Translations live~~ on ~~the two~~ <code>~~TranslationDef~~</code> ~~rows (one for name+desc, one for motto)~~.		* '''Display name / motto / description''' for every language (English included) live in the [[Template:TranslationDef\|Translation]] table — <code>type='hero'</code> rows carry name + description, <code>type='hero_motto'</code> rows carry the motto. Both keyed on <code>target_id = Hero.id</code>.
	* '''<code>class_id</code>''' is <code><class_type>_<faction></code> — matches <code>HeroClass.id</code>.		* '''<code>class_id</code>''' is <code><class_type>_<faction></code> — matches <code>HeroClass.id</code>.
	* '''<code>faction</code>/<code>class_type</code>''' are denormalized from the class so that "all human heroes" / "all might heroes" filters don't need a join.		* '''<code>faction</code>/<code>class_type</code>''' are denormalized from the class so that "all human heroes" / "all might heroes" filters don't need a join.
Line 154:		Line 151:
	* <code>SkillDef</code> (future) — joined on <code>start_skills</code> LIKE <code>%<sid>%</code> or via Cargo's <code>HOLDS</code> operator on the List column.		* <code>SkillDef</code> (future) — joined on <code>start_skills</code> LIKE <code>%<sid>%</code> or via Cargo's <code>HOLDS</code> operator on the List column.
	* <code>SpellDef</code> (future) — same join pattern via <code>start_magics</code>.		* <code>SpellDef</code> (future) — same join pattern via <code>start_magics</code>.
	'' [[Template:HeroSpecializationDef\|HeroSpecialization]] — joined on <code>specialization_id = id</code> (N:1). The hero's unique passive. ''(Schema lands in a follow-up.)*		* [[Template:HeroSpecializationDef\|HeroSpecialization]] — joined on <code>specialization_id = id</code> (N:1). The hero's unique passive.
	* [[Template:TranslationDef\|<code>~~TranslationDef~~</code>~~]] — two rows per hero (~~<code>type=hero</code> and <code>~~type=hero_motto~~</code>).		* [[Template:TranslationDef\|Translation]] — display text in every language (English included), joined on <code>id = Translation.target_id</code> with <code>Translation.type IN ('hero', 'hero_motto')</code> and the desired <code>language</code> filter (1:N, two keys × one row per language).

	== Notes ==		== Notes ==
Line 162:		Line 159:
	</noinclude><includeonly>{{#cargo_store:_table=Hero		</noinclude><includeonly>{{#cargo_store:_table=Hero
	\| id = {{{id\|}}}		\| id = {{{id\|}}}
	~~\| name = {{{name\|}}}~~
	~~\| motto = {{{motto\|}}}~~
	~~\| description = {{{description\|}}}~~
	\| name_sid = {{{name_sid\|}}}		\| name_sid = {{{name_sid\|}}}
	\| motto_sid = {{{motto_sid\|}}}		\| motto_sid = {{{motto_sid\|}}}

76561198026315966: obelisk-bot: uploading initial Cargo templates

2026-05-13T01:12:42Z

obelisk-bot: uploading initial Cargo templates

← Older revision		Revision as of 01:12, 13 May 2026
Line 204:		Line 204:
	\| roll_lvl24_power = {{{roll_lvl24_power\|}}}		\| roll_lvl24_power = {{{roll_lvl24_power\|}}}
	\| roll_lvl24_knowledge = {{{roll_lvl24_knowledge\|}}}		\| roll_lvl24_knowledge = {{{roll_lvl24_knowledge\|}}}
	}}</includeonly>		}}
			Created <code>Hero</code> entry: <code>{{{id\|}}}</code></includeonly>

76561198026315966: obelisk-bot: uploading initial Cargo templates

2026-05-13T00:02:23Z

obelisk-bot: uploading initial Cargo templates

← Older revision		Revision as of 00:02, 13 May 2026
Line 5:		Line 5:
	The bot emits these per-hero blocks at <code>Data:Hero/<id></code>:		The bot emits these per-hero blocks at <code>Data:Hero/<id></code>:

	# <code>{{HeroDef \| id=… \| name=… \| motto=… \| desc=… \| start_skills=… \| start_magics=… \| …}}</code> — main row. <code>start_skills</code> and <code>start_magics</code> are comma-joined SID lists inline on this row (no side tables for them).		# <code><nowiki>{{HeroDef \| id=… \| name=… \| motto=… \| desc=… \| start_skills=… \| start_magics=… \| …}}</nowiki></code> — main row. <code>start_skills</code> and <code>start_magics</code> are comma-joined SID lists inline on this row (no side tables for them).
	# <code>{{TranslationDef \| type=hero \| target_id=<id> \| …}}</code> — name/desc translation (per D-026).		# <code><nowiki>{{TranslationDef \| type=hero \| target_id=<id> \| …}}</nowiki></code> — name/desc translation (per D-026).
	# <code>{{TranslationDef \| type=hero_motto \| target_id=<id> \| …}}</code> — motto translation (separate row, kept off the schema-specialization path; per D-027).		# <code><nowiki>{{TranslationDef \| type=hero_motto \| target_id=<id> \| …}}</nowiki></code> — motto translation (separate row, kept off the schema-specialization path; per D-027).
	# <code>{{HeroStartSquadDef \| …}}</code> × N — one per starting squad slot (primary + alt collapsed via <code>variant</code> discriminator).		# <code><nowiki>{{HeroStartSquadDef \| …}}</nowiki></code> × N — one per starting squad slot (primary + alt collapsed via <code>variant</code> discriminator).

	== Schema ==		== Schema ==
Line 15:		Line 15:
	\| name = String		\| name = String
	\| motto = Wikitext		\| motto = Wikitext
	\| ~~desc~~ = Wikitext		\| description = Wikitext
	\| name_sid = String		\| name_sid = String
	\| motto_sid = String		\| motto_sid = String
Line 62:		Line 62:
	\| name = String		\| name = String
	\| motto = Wikitext		\| motto = Wikitext
	\| ~~desc~~ = Wikitext		\| description = Wikitext
	\| name_sid = String		\| name_sid = String
	\| motto_sid = String		\| motto_sid = String
Line 164:		Line 164:
	\| name = {{{name\|}}}		\| name = {{{name\|}}}
	\| motto = {{{motto\|}}}		\| motto = {{{motto\|}}}
	\| ~~desc~~ = {{{~~desc~~\|}}}		\| description = {{{description\|}}}
	\| name_sid = {{{name_sid\|}}}		\| name_sid = {{{name_sid\|}}}
	\| motto_sid = {{{motto_sid\|}}}		\| motto_sid = {{{motto_sid\|}}}

76561198026315966: obelisk-bot: uploading initial Cargo templates

2026-05-12T23:33:19Z

obelisk-bot: uploading initial Cargo templates

New page

<noinclude>
One row per hero (~177 in the 2026-05-03 corpus: 108 faction + 46 campaign + 21 tutorial + 2 custom-map). Carries the per-hero identity (name/motto/desc), the link to the parent [[Template:HeroClassDef|HeroClass]], and any class-default fields the hero diverges on. Faction heroes match their class template exactly, so their override fields are sparse-emitted (absent); campaign and tutorial heroes routinely override <code>stats</code>, <code>start_level</code>, and
<code>attacks_times_before</code>.

The bot emits these per-hero blocks at <code>Data:Hero/<id></code>:

# <code>{{HeroDef | id=… | name=… | motto=… | desc=… | start_skills=… | start_magics=… | …}}</code> — main row. <code>start_skills</code> and <code>start_magics</code> are comma-joined SID lists inline on this row (no side tables for them).
# <code>{{TranslationDef | type=hero | target_id=<id> | …}}</code> — name/desc translation (per D-026).
# <code>{{TranslationDef | type=hero_motto | target_id=<id> | …}}</code> — motto translation (separate row, kept off the schema-specialization path; per D-027).
# <code>{{HeroStartSquadDef | …}}</code> × N — one per starting squad slot (primary + alt collapsed via <code>variant</code> discriminator).

== Schema ==
{{#cargo_declare:_table=Hero
| id = String
| name = String
| motto = Wikitext
| desc = Wikitext
| name_sid = String
| motto_sid = String
| desc_sid = String
| class_id = String
| faction = String
| class_type = String (allowed values=might,magic)
| icon = String
| specialization_id = String
| source_path = String
| start_skills = List (,) of String
| start_skill_levels = List (,) of Integer
| start_magics = List (,) of String
| cost_gold = Integer
| start_level = Integer
| attacks_times_before = String
| mesh = String
| mount = String
| native_biome = String
| skills_roll_variant = String
| view_radius = Integer
| stats_num = Integer
| magic_casts_per_round = Integer
| enable_tactics = Boolean
| tactics_placement_size = Integer
| enable_hero_native_biome = Boolean
| offence = Integer
| defence = Integer
| spell_power = Integer
| intelligence = Integer
| luck = Integer
| morale = Integer
| roll_lvl1_attack = Integer
| roll_lvl1_defense = Integer
| roll_lvl1_power = Integer
| roll_lvl1_knowledge = Integer
| roll_lvl24_attack = Integer
| roll_lvl24_defense = Integer
| roll_lvl24_power = Integer
| roll_lvl24_knowledge = Integer
}}

<pre><nowiki>
{{HeroDef
| id = String
| name = String
| motto = Wikitext
| desc = Wikitext
| name_sid = String
| motto_sid = String
| desc_sid = String

| class_id = String 
| faction = String 
| class_type = String (allowed values=might,magic)

| icon = String
| specialization_id = String 

| source_path = String


| start_skills = List (,) of String 
| start_skill_levels = List (,) of Integer 
| start_magics = List (,) of String 




| cost_gold = Integer
| start_level = Integer
| attacks_times_before = String 
| mesh = String
| mount = String
| native_biome = String
| skills_roll_variant = String


| view_radius = Integer
| stats_num = Integer
| magic_casts_per_round = Integer
| enable_tactics = Boolean
| tactics_placement_size = Integer
| enable_hero_native_biome = Boolean
| offence = Integer
| defence = Integer
| spell_power = Integer
| intelligence = Integer
| luck = Integer
| morale = Integer


| roll_lvl1_attack = Integer
| roll_lvl1_defense = Integer
| roll_lvl1_power = Integer
| roll_lvl1_knowledge = Integer
| roll_lvl24_attack = Integer
| roll_lvl24_defense = Integer
| roll_lvl24_power = Integer
| roll_lvl24_knowledge = Integer
}}
</nowiki></pre>

== Override semantics ==
Every Cargo query that wants the effective value of a class-shared field on a hero should use:

<syntaxhighlight lang="sql">
COALESCE(Hero.<col>, HeroClass.<col>) AS effective_<col>
</syntaxhighlight>

Joining on <code>Hero.class_id = HeroClass.id</code>. Hero wins if present; HeroClass fills in otherwise.

For faction heroes (108): all 11 class-shared columns are absent on the Hero row — every query falls through to HeroClass.

For campaign/tutorial heroes: ~3-5 columns are typically present (empirically: <code>stats_*</code>, <code>start_level</code>, <code>attacks_times_before</code>). Other class-shared columns still inherit from HeroClass.

== Field notes ==
* '''<code>id</code>''' is the hero's source JSON id (e.g. <code>human_hero_1</code>, <code>campaign_M10_hero_demon_1</code>).
* '''<code>name_sid</code>/<code>motto_sid</code>/<code>desc_sid</code>''' carry the source SID for traceability and as the join key to the Translation rows. Faction heroes use implicit conventions (<code><id></code> / <code><id>_motto</code> / <code><id>_description</code>); campaign heroes set them explicitly in source JSON.
* '''<code>name</code>/<code>motto</code>/<code>desc</code>''' carry the resolved English text inline. Translations live on the two <code>TranslationDef</code> rows (one for name+desc, one for motto).
* '''<code>class_id</code>''' is <code><class_type>_<faction></code> — matches <code>HeroClass.id</code>.
* '''<code>faction</code>/<code>class_type</code>''' are denormalized from the class so that "all human heroes" / "all might heroes" filters don't need a join.
* '''<code>specialization_id</code>''' points at a row in <code>HeroSpecializationDef</code> (one specialization per hero, 1:1 ratio). Schema for that table comes in a follow-up.

== Related tables ==
* [[Template:HeroClassDef|HeroClass]] — joined on <code>class_id = id</code> (N:1). Carries the class defaults the Hero row may override.
* [[Template:HeroStartSquadDef|HeroStartSquad]] — joined on <code>hero_id = id</code> (1:N). Each row is one slot in primary or alt starting army.
* <code>SkillDef</code> (future) — joined on <code>start_skills</code> LIKE <code>%<sid>%</code> or via Cargo's <code>HOLDS</code> operator on the List column.
* <code>SpellDef</code> (future) — same join pattern via <code>start_magics</code>.
'' [[Template:HeroSpecializationDef|HeroSpecialization]] — joined on <code>specialization_id = id</code> (N:1). The hero's unique passive. ''(Schema lands in a follow-up.)*
* [[Template:TranslationDef|<code>TranslationDef</code>]] — two rows per hero (<code>type=hero</code> and <code>type=hero_motto</code>).

== Notes ==

[[Category:Cargo Definitions]]
</noinclude><includeonly>{{#cargo_store:_table=Hero
| id = {{{id|}}}
| name = {{{name|}}}
| motto = {{{motto|}}}
| desc = {{{desc|}}}
| name_sid = {{{name_sid|}}}
| motto_sid = {{{motto_sid|}}}
| desc_sid = {{{desc_sid|}}}
| class_id = {{{class_id|}}}
| faction = {{{faction|}}}
| class_type = {{{class_type|}}}
| icon = {{{icon|}}}
| specialization_id = {{{specialization_id|}}}
| source_path = {{{source_path|}}}
| start_skills = {{{start_skills|}}}
| start_skill_levels = {{{start_skill_levels|}}}
| start_magics = {{{start_magics|}}}
| cost_gold = {{{cost_gold|}}}
| start_level = {{{start_level|}}}
| attacks_times_before = {{{attacks_times_before|}}}
| mesh = {{{mesh|}}}
| mount = {{{mount|}}}
| native_biome = {{{native_biome|}}}
| skills_roll_variant = {{{skills_roll_variant|}}}
| view_radius = {{{view_radius|}}}
| stats_num = {{{stats_num|}}}
| magic_casts_per_round = {{{magic_casts_per_round|}}}
| enable_tactics = {{{enable_tactics|}}}
| tactics_placement_size = {{{tactics_placement_size|}}}
| enable_hero_native_biome = {{{enable_hero_native_biome|}}}
| offence = {{{offence|}}}
| defence = {{{defence|}}}
| spell_power = {{{spell_power|}}}
| intelligence = {{{intelligence|}}}
| luck = {{{luck|}}}
| morale = {{{morale|}}}
| roll_lvl1_attack = {{{roll_lvl1_attack|}}}
| roll_lvl1_defense = {{{roll_lvl1_defense|}}}
| roll_lvl1_power = {{{roll_lvl1_power|}}}
| roll_lvl1_knowledge = {{{roll_lvl1_knowledge|}}}
| roll_lvl24_attack = {{{roll_lvl24_attack|}}}
| roll_lvl24_defense = {{{roll_lvl24_defense|}}}
| roll_lvl24_power = {{{roll_lvl24_power|}}}
| roll_lvl24_knowledge = {{{roll_lvl24_knowledge|}}}
}}</includeonly>