Template:SpellRankDef

From Heroes of Might and Magic: Olden Era Official Wiki
Revision as of 01:12, 13 May 2026 by Ketura (talk | contribs) (obelisk-bot: uploading initial Cargo templates)

This template defines and stores rows for the SpellRank Cargo table. Per-mastery-level data for a 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 Data:Spell/<id> page.

Schema

This template defines the table "SpellRank". View table.

Field notes

  • Primary key is (spell_id, level).
  • name_sid carries the spell's name SID — same across all four ranks; duplicated per-row for clean labelled per-rank queries.
  • description carries resolved English text. Hero-dependent placeholders ({N} for spell-power-scaled values) stay unsubstituted.
  • bonus_description is the unlock blurb at this level. Null at level 1.
  • Per-language columns are sparse — only emitted when the corresponding SID exists.

Related tables

  • Spell — joined on SpellRank.spell_id = Spell.id (N:1).
Retrieved from "https://wiki.hoodedhorse.com/Heroes_of_Might_and_Magic_Olden_Era/index.php?title=Template:SpellRankDef&oldid=13228"