Template:ItemSetTierDef

From Heroes of Might and Magic: Olden Era Official Wiki
Revision as of 20:48, 14 May 2026 by Ketura (talk | contribs) (obelisk-bot: Pushing translation table rework)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

One unlock tier of an ItemSetDef. The hero unlocks the tier's bonuses when they have `required_amount` artifacts from the parent set equipped. Sets have 1-3 tiers each (~37 tiers across the 24 sets in the 2026-05-03 corpus).

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

Schema

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

{{ItemSetTierDef
| id = String                        <!-- synthesized: <set_id>_tier_<ordinal> -->
| set_id = String                    <!-- joins ItemSet.id -->
| ordinal = Integer                  <!-- 0-based position in source bonuses[] -->
| required_amount = Integer          <!-- pieces equipped to unlock -->

| description_sid = String           <!-- display text lives in the Translation table, type='item_set_tier' -->
}}

Field notes

  • Primary key is id. The synthesized form <set_id>tier<ordinal> lets Bonus.parent_id join cleanly via parent_type='item_set_tier'.
  • set_id is the parent — duplicated here as a column so filtering by set doesn't require parsing the composite id.
  • required_amount values seen in the 2026-05-03 corpus: 2 (×17 tiers), 3 (×11), 4 (×7), 5 (×2), 6 (×2), 8 (×1).
  • Description for every language (English included) lives in the Translation table, type='item_set_tier' (description only — tiers have no name).

Related tables

  • ItemSet — joined on set_id = id (N:1).
  • BonusDef — joined on id = parent_id (1:N) where Bonus.parent_type = 'item_set_tier'. Each tier has 1-6 bonus effects.
  • Translation — the tier's description in every language (English included), joined on id = Translation.target_id WHERE Translation.type='item_set_tier' AND Translation.language='en' (1:N, one row per language).

Notes