Template:SpellRankDef - Revision history

76561198026315966: obelisk-bot: Pushing translation table rework

2026-05-15T00:34:24Z

obelisk-bot: Pushing translation table rework

← Older revision		Revision as of 00:34, 15 May 2026
Line 2:		Line 2:
	This template defines and stores rows for the '''SpellRank''' Cargo table. Per-mastery-level structural data for a [[Template:SpellDef\|Spell]]. Always 4 rows per spell — levels 1=no skill, 2=basic, 3=advanced, 4=expert.		This template defines and stores rows for the '''SpellRank''' Cargo table. Per-mastery-level structural data for a [[Template:SpellDef\|Spell]]. Always 4 rows per spell — levels 1=no skill, 2=basic, 3=advanced, 4=expert.

	SpellRank carries only the '''mechanical, language-independent''' fields. ~~All~~ localizable text — ~~the rank's name,~~ description, and bonus unlock blurb, in every language including English — lives in the shared [[Template:TranslationDef\|Translation]] table, keyed by <code>type=spell_rank</code>, <code>target_id=<spell_id></code>, <code>variant=<level></code>.		SpellRank carries only the '''mechanical, language-independent''' fields. The rank's localizable text — its description and bonus unlock blurb, in every language including English — lives in the shared [[Template:TranslationDef\|Translation]] table, keyed by <code>type=spell_rank</code>, <code>target_id=<spell_id></code>, <code>variant=<level></code>. The spell's '''name''' is '''not''' a per-rank value — it is static across all four ranks — so it is stored once, in [[Template:SpellDef\|Spell]]'s <code>type=spell</code> Translation rows, and never duplicated here.

	The bot emits these inline on the parent <code>Data:Spell/<id></code> page, each <code><nowiki>{{SpellRankDef}}</nowiki></code> row followed by its per-language <code><nowiki>{{TranslationDef}}</nowiki></code> rows.		The bot emits these inline on the parent <code>Data:Spell/<id></code> page, each <code><nowiki>{{SpellRankDef}}</nowiki></code> row followed by its per-language <code><nowiki>{{TranslationDef}}</nowiki></code> rows.
Line 10:		Line 10:
	\| spell_id = String		\| spell_id = String
	\| level = Integer		\| level = Integer
	~~\| name_sid = String~~
	\| description_sid = String		\| description_sid = String
	\| bonus_description_sid = String		\| bonus_description_sid = String
Line 21:		Line 20:
	\| spell_id = String		\| spell_id = String
	\| level = Integer <!-- 1=no skill, 2=basic, 3=advanced, 4=expert -->		\| level = Integer <!-- 1=no skill, 2=basic, 3=advanced, 4=expert -->
	~~\| name_sid = String <!-- same across all four ranks; per-row for clean labelled queries -->~~
	\| description_sid = String		\| description_sid = String
	\| bonus_description_sid = String <!-- null at level 1 -->		\| bonus_description_sid = String <!-- null at level 1 -->
Line 31:		Line 29:
	== Field notes ==		== Field notes ==
	* Primary key is <code>(spell_id, level)</code>.		* Primary key is <code>(spell_id, level)</code>.
	* <code>name_sid</code> ~~carries the~~ spell's name ~~SID — same~~ across all four ranks~~; duplicated per-row for clean labelled~~ per-rank ~~queries~~. ~~Traceability only; not~~ the ~~translation join path~~.		* '''No <code>name_sid</code> here.''' The spell's name is static across all four ranks — it is not a per-rank value. It lives on [[Template:SpellDef\|Spell]] (<code>name_sid</code>) and its resolved text in the Translation table under <code>type='spell'</code>. There is no "rank name" concept in the source data.
	* <code>description_sid</code> / <code>bonus_description_sid</code> point at the L10n entries the rank's text was sourced from. <code>bonus_description_sid</code> is null at level 1.		* <code>description_sid</code> / <code>bonus_description_sid</code> point at the L10n entries the rank's text was sourced from. <code>bonus_description_sid</code> is null at level 1. Traceability only; not the translation join path.
	* Resolved text for every language (including English) lives in [[Template:TranslationDef\|Translation]]: ~~<code>name</code>,~~ <code>description</code>, and <code>bonus_description</code> columns, <code>WHERE type='spell_rank' AND target_id=<spell_id> AND variant=<level></code>. Hero-dependent placeholders (<code>{N}</code> for spell-power-scaled values) stay unsubstituted in the stored text.		* Resolved text for every language (including English) lives in [[Template:TranslationDef\|Translation]]: the <code>description</code> and <code>bonus_description</code> columns, <code>WHERE type='spell_rank' AND target_id=<spell_id> AND variant=<level></code>. The <code>name</code> column on those rows is left empty — see the note above. Hero-dependent placeholders (<code>{N}</code> for spell-power-scaled values) stay unsubstituted in the stored text.
	* <code>mana_cost</code> / <code>upgrade_cost</code> are the per-rank mechanical costs.		* <code>mana_cost</code> / <code>upgrade_cost</code> are the per-rank mechanical costs.

Line 44:		Line 42:
	\| spell_id = {{{spell_id\|}}}		\| spell_id = {{{spell_id\|}}}
	\| level = {{{level\|}}}		\| level = {{{level\|}}}
	~~\| name_sid = {{{name_sid\|}}}~~
	\| description_sid = {{{description_sid\|}}}		\| description_sid = {{{description_sid\|}}}
	\| bonus_description_sid = {{{bonus_description_sid\|}}}		\| bonus_description_sid = {{{bonus_description_sid\|}}}

76561198026315966: obelisk-bot: Pushing translation table rework

2026-05-14T20:48:35Z

obelisk-bot: Pushing translation table rework

Show changes

76561198026315966: obelisk-bot: uploading initial Cargo templates

2026-05-13T01:12:55Z

obelisk-bot: uploading initial Cargo templates

@@ Line 1: / Line 1: @@
 <noinclude>
-This template defines and stores rows for the '''SpellRank''' Cargo table. Per-mastery-level data for a [[Template:SpellDef|Spell]]. Always 4 rows per spell — levels 1=no skill, 2=basic, 3=advanced, 4=expert. Each row is self-contained: it carries the English defaults, the mechanical fields, ''and'' the 15 non-English translations of every translatable field. The old <code>SpellRankTranslationDef</code> sibling table was folded back into this one — the three-translatable-field shape (name + description + bonus_description) didn't fit [[Template:EntryDef|Entry]]'s generic name+description-only schema, so spell ranks get their own expanded shape.
+This template defines and stores rows for the '''SpellRank''' Cargo table. Per-mastery-level data for a [[Template:SpellDef|Spell]]. Always 4 rows per spell — levels 1=no skill, 2=basic, 3=advanced, 4=expert. Each row is self-contained: it carries English defaults, mechanical fields, and 15 non-English translations of name + description + bonus_description.
-The bot emits these inline on the parent <code>Data:Spell/<id></code> page. There are no individual <code>Data:SpellRank/…</code> pages.
+The bot emits these inline on the parent <code>Data:Spell/<id></code> page.
 == Schema ==
@@ Line 61: / Line 61: @@
 | zh_tw_bonus_description = Wikitext
 }}
 == Field notes ==
-* '''Primary key is <code>(spell_id, level)</code>.'''
+* Primary key is <code>(spell_id, level)</code>.
-* '''<code>name_sid</code>''' carries the spell's name SID — same value across all four ranks for a given spell. Duplicated per-row so a query against <code>SpellRank</code> alone can render a labeled per-rank table without joining back to <code>Spell</code>.
+* <code>name_sid</code> carries the spell's name SID — same across all four ranks; duplicated per-row for clean labelled per-rank queries.
-* '''<code>description_sid</code>''' points at the source <code>description[level-1]</code> SID. Levels 1 and 2 often share the same SID (the "no mastery" text and the "basic" text are typically identical).
+* <code>description</code> carries resolved English text. Hero-dependent placeholders (<code>{N}</code> for spell-power-scaled values) stay unsubstituted.
-* '''<code>description</code>''' carries the resolved English text. Static spell-config placeholders are pre-substituted (the bot threads the spell's JSON through the resolver). '''Hero-dependent placeholders (<code>{N}</code> for spell-power-scaled values) intentionally stay unsubstituted''' — the actual numbers depend on the casting hero, so the wiki display layer surfaces them generically. See D-030.
+* <code>bonus_description</code> is the unlock blurb at this level. Null at level 1.
-* '''<code>bonus_description_sid</code> / <code>bonus_description</code>''' are the unlock-bonus message shown when reaching this level (e.g. "Affects all friendly creatures."). Null for level 1 (the starting rank).
+* Per-language columns are sparse — only emitted when the corresponding SID exists.
 == Related tables ==
@@ Line 198: / Line 128: @@
 | zh_tw_description = {{{zh_tw_description|}}}
 | zh_tw_bonus_description = {{{zh_tw_bonus_description|}}}
-}}</includeonly>
+}}

76561198026315966: obelisk-bot: uploading initial Cargo templates

2026-05-13T00:11:34Z

obelisk-bot: uploading initial Cargo templates

Show changes

76561198026315966: obelisk-bot: uploading initial Cargo templates

2026-05-13T00:02:37Z

obelisk-bot: uploading initial Cargo templates

Show changes

76561198026315966: obelisk-bot: uploading initial Cargo templates

2026-05-12T23:33:27Z

obelisk-bot: uploading initial Cargo templates

New page

<noinclude>
This template defines and stores rows for the '''SpellRank''' Cargo table. Per-mastery-level data for a [[Template:SpellDef|Spell]]. Always 4 rows per spell — levels 1=no skill, 2=basic, 3=advanced, 4=expert. Each row is self-contained: it carries the English defaults, the mechanical fields, ''and'' the 15 non-English translations of every translatable field. The old <code>SpellRankTranslationDef</code> sibling table was folded back into this one — the three-translatable-field shape (name + desc + bonus_description) didn't fit [[Template:EntryDef|Entry]]'s generic name+desc-only schema, so spell ranks get their own expanded shape.

The bot emits these inline on the parent <code>Data:Spell/<id></code> page. There are no individual <code>Data:SpellRank/…</code> pages.

== Schema ==
{{#cargo_declare:_table=SpellRank
| spell_id = String
| level = Integer
| name_sid = String
| description_sid = String
| description = Wikitext
| bonus_description_sid = String
| bonus_description = Wikitext
| mana_cost = Integer
| upgrade_cost = Integer
| pt_br_name = String
| pt_br_desc = Wikitext
| pt_br_bonus_description = Wikitext
| cs_name = String
| cs_desc = Wikitext
| cs_bonus_description = Wikitext
| fr_name = String
| fr_desc = Wikitext
| fr_bonus_description = Wikitext
| de_name = String
| de_desc = Wikitext
| de_bonus_description = Wikitext
| hu_name = String
| hu_desc = Wikitext
| hu_bonus_description = Wikitext
| it_name = String
| it_desc = Wikitext
| it_bonus_description = Wikitext
| ja_name = String
| ja_desc = Wikitext
| ja_bonus_description = Wikitext
| ko_name = String
| ko_desc = Wikitext
| ko_bonus_description = Wikitext
| pl_name = String
| pl_desc = Wikitext
| pl_bonus_description = Wikitext
| ru_name = String
| ru_desc = Wikitext
| ru_bonus_description = Wikitext
| es_name = String
| es_desc = Wikitext
| es_bonus_description = Wikitext
| tr_name = String
| tr_desc = Wikitext
| tr_bonus_description = Wikitext
| uk_name = String
| uk_desc = Wikitext
| uk_bonus_description = Wikitext
| zh_cn_name = String
| zh_cn_desc = Wikitext
| zh_cn_bonus_description = Wikitext
| zh_tw_name = String
| zh_tw_desc = Wikitext
| zh_tw_bonus_description = Wikitext
}}

<pre><nowiki>
{{SpellRankDef
| spell_id = String 
| level = Integer 

| name_sid = String 

| description_sid = String
| description = Wikitext 


| bonus_description_sid = String
| bonus_description = Wikitext 

| mana_cost = Integer
| upgrade_cost = Integer


| pt_br_name = String
| pt_br_desc = Wikitext
| pt_br_bonus_description = Wikitext
| cs_name = String
| cs_desc = Wikitext
| cs_bonus_description = Wikitext
| fr_name = String
| fr_desc = Wikitext
| fr_bonus_description = Wikitext
| de_name = String
| de_desc = Wikitext
| de_bonus_description = Wikitext
| hu_name = String
| hu_desc = Wikitext
| hu_bonus_description = Wikitext
| it_name = String
| it_desc = Wikitext
| it_bonus_description = Wikitext
| ja_name = String
| ja_desc = Wikitext
| ja_bonus_description = Wikitext
| ko_name = String
| ko_desc = Wikitext
| ko_bonus_description = Wikitext
| pl_name = String
| pl_desc = Wikitext
| pl_bonus_description = Wikitext
| ru_name = String
| ru_desc = Wikitext
| ru_bonus_description = Wikitext
| es_name = String
| es_desc = Wikitext
| es_bonus_description = Wikitext
| tr_name = String
| tr_desc = Wikitext
| tr_bonus_description = Wikitext
| uk_name = String
| uk_desc = Wikitext
| uk_bonus_description = Wikitext
| zh_cn_name = String
| zh_cn_desc = Wikitext
| zh_cn_bonus_description = Wikitext
| zh_tw_name = String
| zh_tw_desc = Wikitext
| zh_tw_bonus_description = Wikitext
}}
</nowiki></pre>

== Field notes ==
* '''Primary key is <code>(spell_id, level)</code>.'''
* '''<code>name_sid</code>''' carries the spell's name SID — same value across all four ranks for a given spell. Duplicated per-row so a query against <code>SpellRank</code> alone can render a labeled per-rank table without joining back to <code>Spell</code>.
* '''<code>description_sid</code>''' points at the source <code>description[level-1]</code> SID. Levels 1 and 2 often share the same SID (the "no mastery" text and the "basic" text are typically identical).
* '''<code>description</code>''' carries the resolved English text. Static spell-config placeholders are pre-substituted (the bot threads the spell's JSON through the resolver). '''Hero-dependent placeholders (<code>{N}</code> for spell-power-scaled values) intentionally stay unsubstituted''' — the actual numbers depend on the casting hero, so the wiki display layer surfaces them generically. See D-030.
* '''<code>bonus_description_sid</code> / <code>bonus_description</code>''' are the unlock-bonus message shown when reaching this level (e.g. "Affects all friendly creatures."). Null for level 1 (the starting rank).
* '''<code>upgrade_cost</code>''' is the resource cost paid to upgrade ''to'' this level (in the spell's primary upgrade resource — usually a small number like 25). Null for level 1. For length-1 source <code>upgradeCost</code> arrays (mostly world-map utility spells), only level 2 gets a value.
* '''<code><lang>_*</code> columns''' are sparse — a row only carries the translations for which the corresponding SID exists. If a spell has no <code>bonus_description_sid</code> at a given level, all 15 <code><lang>_bonus_description</code> columns are simply absent from the emitted invocation.
* '''Resolver context''' for the non-English lookups uses the same per-rank <code>magic_json = {"raw": spell.raw_json, "level": <level>}</code> context the English lookup uses, so per-mastery-level magicDealer values substitute identically across all 16 languages.

== Related tables ==
* [[Template:SpellDef|Spell]] — joined on <code>SpellRank.spell_id = Spell.id</code> (N:1).

[[Category:Cargo Definitions]]
</noinclude><includeonly>{{#cargo_store:_table=SpellRank
| spell_id = {{{spell_id|}}}
| level = {{{level|}}}
| name_sid = {{{name_sid|}}}
| description_sid = {{{description_sid|}}}
| description = {{{description|}}}
| bonus_description_sid = {{{bonus_description_sid|}}}
| bonus_description = {{{bonus_description|}}}
| mana_cost = {{{mana_cost|}}}
| upgrade_cost = {{{upgrade_cost|}}}
| pt_br_name = {{{pt_br_name|}}}
| pt_br_desc = {{{pt_br_desc|}}}
| pt_br_bonus_description = {{{pt_br_bonus_description|}}}
| cs_name = {{{cs_name|}}}
| cs_desc = {{{cs_desc|}}}
| cs_bonus_description = {{{cs_bonus_description|}}}
| fr_name = {{{fr_name|}}}
| fr_desc = {{{fr_desc|}}}
| fr_bonus_description = {{{fr_bonus_description|}}}
| de_name = {{{de_name|}}}
| de_desc = {{{de_desc|}}}
| de_bonus_description = {{{de_bonus_description|}}}
| hu_name = {{{hu_name|}}}
| hu_desc = {{{hu_desc|}}}
| hu_bonus_description = {{{hu_bonus_description|}}}
| it_name = {{{it_name|}}}
| it_desc = {{{it_desc|}}}
| it_bonus_description = {{{it_bonus_description|}}}
| ja_name = {{{ja_name|}}}
| ja_desc = {{{ja_desc|}}}
| ja_bonus_description = {{{ja_bonus_description|}}}
| ko_name = {{{ko_name|}}}
| ko_desc = {{{ko_desc|}}}
| ko_bonus_description = {{{ko_bonus_description|}}}
| pl_name = {{{pl_name|}}}
| pl_desc = {{{pl_desc|}}}
| pl_bonus_description = {{{pl_bonus_description|}}}
| ru_name = {{{ru_name|}}}
| ru_desc = {{{ru_desc|}}}
| ru_bonus_description = {{{ru_bonus_description|}}}
| es_name = {{{es_name|}}}
| es_desc = {{{es_desc|}}}
| es_bonus_description = {{{es_bonus_description|}}}
| tr_name = {{{tr_name|}}}
| tr_desc = {{{tr_desc|}}}
| tr_bonus_description = {{{tr_bonus_description|}}}
| uk_name = {{{uk_name|}}}
| uk_desc = {{{uk_desc|}}}
| uk_bonus_description = {{{uk_bonus_description|}}}
| zh_cn_name = {{{zh_cn_name|}}}
| zh_cn_desc = {{{zh_cn_desc|}}}
| zh_cn_bonus_description = {{{zh_cn_bonus_description|}}}
| zh_tw_name = {{{zh_tw_name|}}}
| zh_tw_desc = {{{zh_tw_desc|}}}
| zh_tw_bonus_description = {{{zh_tw_bonus_description|}}}
}}</includeonly>