Template:SubSkillDef - Revision history

76561198026315966: obelisk-bot: Pushing translation table rework

2026-05-14T20:48:37Z

obelisk-bot: Pushing translation table rework

← Older revision		Revision as of 20:48, 14 May 2026
Line 10:		Line 10:

	# <code><nowiki>{{SubSkillDef \| id=… \| parent_skill_id=… \| …}}</nowiki></code>		# <code><nowiki>{{SubSkillDef \| id=… \| parent_skill_id=… \| …}}</nowiki></code>
	# <code><nowiki>{{TranslationDef \| type=sub_skill \| target_id=<id> \| …}}</nowiki></code>		# N × <code><nowiki>{{TranslationDef \| type=sub_skill \| target_id=<id> \| language=… \| name=… \| description=… }}</nowiki></code> — one row per language
	# M × <code><nowiki>{{BonusDef \| parent_type=sub_skill \| parent_id=<id> \| … }}</nowiki></code>		# M × <code><nowiki>{{BonusDef \| parent_type=sub_skill \| parent_id=<id> \| … }}</nowiki></code>

Line 18:		Line 18:
	\| variant = String		\| variant = String
	\| parent_skill_id = String		\| parent_skill_id = String
	~~\| name = String~~
	\| name_sid = String		\| name_sid = String
	~~\| description = Wikitext~~
	\| desc_sid = String		\| desc_sid = String
	\| icon = String		\| icon = String
Line 31:		Line 29:
	\| variant = String <!-- production / arena / campaign / test -->		\| variant = String <!-- production / arena / campaign / test -->
	\| parent_skill_id = String <!-- nullable; null for orphans -->		\| parent_skill_id = String <!-- nullable; null for orphans -->
	~~\| name = String~~ <!-- ~~resolved English~~ -->		<!-- Localization references — display text lives in the Translation table, type='sub_skill' -->
	\| name_sid = String		\| name_sid = String
	~~\| description = Wikitext <!-- resolved English; nullable -->~~
	\| desc_sid = String <!-- nullable -->		\| desc_sid = String <!-- nullable -->
	\| icon = String <!-- nullable -->		\| icon = String <!-- nullable -->
Line 44:		Line 41:
	* '''<code>variant</code>''' distinguishes production / arena / campaign / test variants. Most analytical queries should <code>WHERE variant = 'production'</code>.		* '''<code>variant</code>''' distinguishes production / arena / campaign / test variants. Most analytical queries should <code>WHERE variant = 'production'</code>.
	* '''<code>parent_skill_id</code>''' is derived: the id of the [[Template:SkillDef\|Skill]] whose <code><nowiki>{{SkillLevelDef}}</nowiki></code> rows include this sub-skill in their <code>offered_sub_skills</code> list. NULL when no skill in the corpus references this sub-skill — those 77 orphans live on the <code>Data:Skill/_orphan_sub_skills</code> catch-all page (test entries + arena legacy <code>*_old</code>).		* '''<code>parent_skill_id</code>''' is derived: the id of the [[Template:SkillDef\|Skill]] whose <code><nowiki>{{SkillLevelDef}}</nowiki></code> rows include this sub-skill in their <code>offered_sub_skills</code> list. NULL when no skill in the corpus references this sub-skill — those 77 orphans live on the <code>Data:Skill/_orphan_sub_skills</code> catch-all page (test entries + arena legacy <code>*_old</code>).
	* '''<code>name_sid</code> / <code>desc_sid</code>''' point at the L10n entries~~; <code>~~name~~</code>~~ / <code>~~desc~~</code> ~~are the resolved English mirrors~~.		* '''<code>name_sid</code> / <code>desc_sid</code>''' point at the L10n entries, surfaced for traceability. Display name / description for every language (English included) live in the [[Template:TranslationDef\|Translation]] table, <code>type='sub_skill'</code>.

	== Related tables ==		== Related tables ==
Line 50:		Line 47:
	* [[Template:SkillLevelDef\|SkillLevel]] — joined on <code>SkillLevel.offered_sub_skills HOLDS SubSkill.id</code> (N:M; a sub-skill is typically offered at exactly one (skill, level) but the relation is general).		* [[Template:SkillLevelDef\|SkillLevel]] — joined on <code>SkillLevel.offered_sub_skills HOLDS SubSkill.id</code> (N:M; a sub-skill is typically offered at exactly one (skill, level) but the relation is general).
	* [[Template:BonusDef\|<code>BonusDef</code>]] — joined on <code>parent_type='sub_skill' AND parent_id = SubSkill.id</code>.		* [[Template:BonusDef\|<code>BonusDef</code>]] — joined on <code>parent_type='sub_skill' AND parent_id = SubSkill.id</code>.
	* [[Template:TranslationDef\|~~<code>TranslationDef</code>~~]] — ~~one row per sub-skill with~~ <code>type=sub_skill</code>, ~~<code>target_id=id</code>~~.		* [[Template:TranslationDef\|Translation]] — display text in every language (English included), joined on <code>id = Translation.target_id WHERE Translation.type='sub_skill' AND Translation.language='{{{lang\|en}}}'</code> (1:N, one row per language).

	[[Category:Cargo Definitions]]		[[Category:Cargo Definitions]]
Line 57:		Line 54:
	\| variant = {{{variant\|}}}		\| variant = {{{variant\|}}}
	\| parent_skill_id = {{{parent_skill_id\|}}}		\| parent_skill_id = {{{parent_skill_id\|}}}
	~~\| name = {{{name\|}}}~~
	\| name_sid = {{{name_sid\|}}}		\| name_sid = {{{name_sid\|}}}
	~~\| description = {{{description\|}}}~~
	\| desc_sid = {{{desc_sid\|}}}		\| desc_sid = {{{desc_sid\|}}}
	\| icon = {{{icon\|}}}		\| icon = {{{icon\|}}}

76561198026315966: obelisk-bot: uploading initial Cargo templates

2026-05-13T01:12:57Z

obelisk-bot: uploading initial Cargo templates

← Older revision		Revision as of 01:12, 13 May 2026
Line 63:		Line 63:
	\| icon = {{{icon\|}}}		\| icon = {{{icon\|}}}
	\| source_path = {{{source_path\|}}}		\| source_path = {{{source_path\|}}}
	}}</includeonly>		}}
			Created <code>SubSkill</code> entry: <code>{{{id\|}}}</code></includeonly>

76561198026315966: obelisk-bot: uploading initial Cargo templates

2026-05-13T00:02:38Z

obelisk-bot: uploading initial Cargo templates

← Older revision		Revision as of 00:02, 13 May 2026
Line 5:		Line 5:

	== Page layout ==		== Page layout ==
	Sub-skills are inlined on their parent skill's page (<code>Data:Skill/<parent_skill_id></code>) — they share the page with the parent's <code>{{SkillDef}}</code>, <code>{{SkillLevelDef}}</code>, and per-skill <code>{{TranslationDef}}</code> rows. The 77 unreferenced sub-skills (8 test + ~69 arena legacy <code>*_old</code>) emit onto the catch-all page <code>Data:Skill/_orphan_sub_skills</code> with <code>parent_skill_id=NULL</code>.		Sub-skills are inlined on their parent skill's page (<code>Data:Skill/<parent_skill_id></code>) — they share the page with the parent's <code><nowiki>{{SkillDef}}</nowiki></code>, <code><nowiki>{{SkillLevelDef}}</nowiki></code>, and per-skill <code><nowiki>{{TranslationDef}}</nowiki></code> rows. The 77 unreferenced sub-skills (8 test + ~69 arena legacy <code>*_old</code>) emit onto the catch-all page <code>Data:Skill/_orphan_sub_skills</code> with <code>parent_skill_id=NULL</code>.

	Each sub-skill contributes:		Each sub-skill contributes:

	# <code>{{SubSkillDef \| id=… \| parent_skill_id=… \| …}}</code>		# <code><nowiki>{{SubSkillDef \| id=… \| parent_skill_id=… \| …}}</nowiki></code>
	# <code>{{TranslationDef \| type=sub_skill \| target_id=<id> \| …}}</code>		# <code><nowiki>{{TranslationDef \| type=sub_skill \| target_id=<id> \| …}}</nowiki></code>
	# M × <code>{{BonusDef \| parent_type=sub_skill \| parent_id=<id> \| … }}</code>		# M × <code><nowiki>{{BonusDef \| parent_type=sub_skill \| parent_id=<id> \| … }}</nowiki></code>

	== Schema ==		== Schema ==
Line 20:		Line 20:
	\| name = String		\| name = String
	\| name_sid = String		\| name_sid = String
	\| ~~desc~~ = Wikitext		\| description = Wikitext
	\| desc_sid = String		\| desc_sid = String
	\| icon = String		\| icon = String
Line 33:		Line 33:
	\| name = String <!-- resolved English -->		\| name = String <!-- resolved English -->
	\| name_sid = String		\| name_sid = String
	\| ~~desc~~ = Wikitext <!-- resolved English; nullable -->		\| description = Wikitext <!-- resolved English; nullable -->
	\| desc_sid = String <!-- nullable -->		\| desc_sid = String <!-- nullable -->
	\| icon = String <!-- nullable -->		\| icon = String <!-- nullable -->
Line 43:		Line 43:
	* '''<code>id</code>''' is the source JSON id (e.g. <code>sub_skill_offense</code>, <code>arena_sub_skill_offense_old</code>, <code>sub_skill_marchOfWar</code>).		* '''<code>id</code>''' is the source JSON id (e.g. <code>sub_skill_offense</code>, <code>arena_sub_skill_offense_old</code>, <code>sub_skill_marchOfWar</code>).
	* '''<code>variant</code>''' distinguishes production / arena / campaign / test variants. Most analytical queries should <code>WHERE variant = 'production'</code>.		* '''<code>variant</code>''' distinguishes production / arena / campaign / test variants. Most analytical queries should <code>WHERE variant = 'production'</code>.
	* '''<code>parent_skill_id</code>''' is derived: the id of the [[Template:SkillDef\|Skill]] whose <code>{{SkillLevelDef}}</code> rows include this sub-skill in their <code>offered_sub_skills</code> list. NULL when no skill in the corpus references this sub-skill — those 77 orphans live on the <code>Data:Skill/_orphan_sub_skills</code> catch-all page (test entries + arena legacy <code>*_old</code>).		* '''<code>parent_skill_id</code>''' is derived: the id of the [[Template:SkillDef\|Skill]] whose <code><nowiki>{{SkillLevelDef}}</nowiki></code> rows include this sub-skill in their <code>offered_sub_skills</code> list. NULL when no skill in the corpus references this sub-skill — those 77 orphans live on the <code>Data:Skill/_orphan_sub_skills</code> catch-all page (test entries + arena legacy <code>*_old</code>).
	* '''<code>name_sid</code> / <code>desc_sid</code>''' point at the L10n entries; <code>name</code> / <code>desc</code> are the resolved English mirrors.		* '''<code>name_sid</code> / <code>desc_sid</code>''' point at the L10n entries; <code>name</code> / <code>desc</code> are the resolved English mirrors.

Line 59:		Line 59:
	\| name = {{{name\|}}}		\| name = {{{name\|}}}
	\| name_sid = {{{name_sid\|}}}		\| name_sid = {{{name_sid\|}}}
	\| ~~desc~~ = {{{~~desc~~\|}}}		\| description = {{{description\|}}}
	\| desc_sid = {{{desc_sid\|}}}		\| desc_sid = {{{desc_sid\|}}}
	\| icon = {{{icon\|}}}		\| icon = {{{icon\|}}}
	\| source_path = {{{source_path\|}}}		\| source_path = {{{source_path\|}}}
	}}</includeonly>		}}</includeonly>

76561198026315966: obelisk-bot: uploading initial Cargo templates

2026-05-12T23:33:28Z

obelisk-bot: uploading initial Cargo templates

New page

<noinclude>
Flat per-sub-skill ("perk") record. 617 rows in 2026-05-05: 203 production + 203 arena + 203 campaign + 8 test. Each sub-skill is a discrete pickable perk that the player chooses when their hero gains a skill mastery level — e.g. picking "Offense" vs "Defense" off the <code>skill_assault</code> Basic-mastery offering.

Sub-skills don't have levels of their own; they're flat. They carry identity (id, variant), display fields (name + desc + icon), the parent skill they were offered by (recovered from scanning every skill level's <code>offered_sub_skills</code> list), and the bonuses they grant. Bonuses flow into the unified [[Template:BonusDef|<code>BonusDef</code>]] table with <code>parent_type='sub_skill'</code>.

== Page layout ==
Sub-skills are inlined on their parent skill's page (<code>Data:Skill/<parent_skill_id></code>) — they share the page with the parent's <code>{{SkillDef}}</code>, <code>{{SkillLevelDef}}</code>, and per-skill <code>{{TranslationDef}}</code> rows. The 77 unreferenced sub-skills (8 test + ~69 arena legacy <code>*_old</code>) emit onto the catch-all page <code>Data:Skill/_orphan_sub_skills</code> with <code>parent_skill_id=NULL</code>.

Each sub-skill contributes:

# <code>{{SubSkillDef | id=… | parent_skill_id=… | …}}</code>
# <code>{{TranslationDef | type=sub_skill | target_id=<id> | …}}</code>
# M × <code>{{BonusDef | parent_type=sub_skill | parent_id=<id> | … }}</code>

== Schema ==
{{#cargo_declare:_table=SubSkill
| id = String
| variant = String
| parent_skill_id = String
| name = String
| name_sid = String
| desc = Wikitext
| desc_sid = String
| icon = String
| source_path = String
}}

<pre><nowiki>
{{SubSkillDef
| id = String
| variant = String 
| parent_skill_id = String 
| name = String 
| name_sid = String
| desc = Wikitext 
| desc_sid = String 
| icon = String 
| source_path = String
}}
</nowiki></pre>

== Field notes ==
* '''<code>id</code>''' is the source JSON id (e.g. <code>sub_skill_offense</code>, <code>arena_sub_skill_offense_old</code>, <code>sub_skill_marchOfWar</code>).
* '''<code>variant</code>''' distinguishes production / arena / campaign / test variants. Most analytical queries should <code>WHERE variant = 'production'</code>.
* '''<code>parent_skill_id</code>''' is derived: the id of the [[Template:SkillDef|Skill]] whose <code>{{SkillLevelDef}}</code> rows include this sub-skill in their <code>offered_sub_skills</code> list. NULL when no skill in the corpus references this sub-skill — those 77 orphans live on the <code>Data:Skill/_orphan_sub_skills</code> catch-all page (test entries + arena legacy <code>*_old</code>).
* '''<code>name_sid</code> / <code>desc_sid</code>''' point at the L10n entries; <code>name</code> / <code>desc</code> are the resolved English mirrors.

== Related tables ==
* [[Template:SkillDef|Skill]] — joined on <code>parent_skill_id = Skill.id</code> (N:1).
* [[Template:SkillLevelDef|SkillLevel]] — joined on <code>SkillLevel.offered_sub_skills HOLDS SubSkill.id</code> (N:M; a sub-skill is typically offered at exactly one (skill, level) but the relation is general).
* [[Template:BonusDef|<code>BonusDef</code>]] — joined on <code>parent_type='sub_skill' AND parent_id = SubSkill.id</code>.
* [[Template:TranslationDef|<code>TranslationDef</code>]] — one row per sub-skill with <code>type=sub_skill</code>, <code>target_id=id</code>.

[[Category:Cargo Definitions]]
</noinclude><includeonly>{{#cargo_store:_table=SubSkill
| id = {{{id|}}}
| variant = {{{variant|}}}
| parent_skill_id = {{{parent_skill_id|}}}
| name = {{{name|}}}
| name_sid = {{{name_sid|}}}
| desc = {{{desc|}}}
| desc_sid = {{{desc_sid|}}}
| icon = {{{icon|}}}
| source_path = {{{source_path|}}}
}}</includeonly>