elyukai/optolith-database-schema

Definitions and utilities for the flat-file database of Optolith, a character creation tool for the Pen and Paper RPG “The Dark Eye 5”, and its external integrations into other software.

optolith-database-schema's Issues

Zauberrunen

• Schema
  • Probe modifiziert um Kampftechnik
  • Schutzrune vor (Wesenheit) 😡

UI

• Improve for YAML
• Use Intl techniques (like PluralRules)

Category `Alchemicum` is unnecessary

All items that are categorized here fit better into other categories. Eliminate waste - remove this category.

Poisons: duration type "Indefinite" - unintuitive naming / usage unclear

Currently, this duration category is used in the following instances (list not complete):

• Ghul's poison (default duration: permanent)
• Totenbleiche (default duration: until death or no further ingestion)
• Alcohol (default duration: until applied status effects wane)
• Hexenhornissengift (default duration: instant)

Is this usage correct? If yes, I suggest to rename this category to Other, to make it more intuitive.

If No, I have to correct the entries :)

Apart from that, I suggest to introduce extra categories for the two latter cases (StatusWane and Instant).

Poisons: required field 'value' not available in all cases

value is currently required , but most animal poisons have no value (see https://dsa.ulisses-regelwiki.de/gift_tier.html)

Item category references differ from folder names

Item categories references are in singular and use and as conjunction, whereas folder names are held in plural als use or as conjunction, e. g. "BandagesAndRemedies" vs "BandageOrRemedy".

This is somewhat inconvenient because the ItemsIdMap (for compatibility) uses folder names, and one needs a lookup table to map the new item reference from e. g.
- [ITEMTPL_143, BandagesAndRemedies, 5]
to the category BandageOrRemedy to create a valid item reference. Such a mapping is nowhere in the code and has to be created manually.

Proposal: Change folder names to item category names.

Poinsons: PoisonTranslation lacks `notes` or `special`

Many animal poisons have some special effects which currently cannot be included.

Example: https://dsa.ulisses-regelwiki.de/Kvillo.html

Pflanzen

• Schema

Modifier Table

Possible Column combinations:

• Action/Modifier
• Situation/Penalty
• Situation/Modifier/Example
• Type/Modifier
• Recharge Time/Penalty/Cost
• Situation/Regeneration (?)
• Type/Example/Damage (Modifier) (?)

Elixir identifier is missing

The elixir identifier is missing in the identifier definition.

Item complexity "various"?

The generic item"Winterkleidung" (Data\Equipment\Armor\4_Winter-Clothing.yml) explicitly specify their complexity as "various", which is currently not an allowed value for a complexity entry.

How to deal with this?

Another very special example example are furs (Data\Equipment\Armor\2_Furs.yml). Possible fix: move to category "Clothes", where complexity is optional.

Poisons: cost = 0

Cost has currently a minimum of 1, but some poisons have no cost, see
https://dsa.ulisses-regelwiki.de/brba.html

Internal English translations

Magical Actions

• Animistenkräfte
• Geodenrituale
• Schelmenstreiche
• Zibiljarituale
• Zauberrunen

Special Abilities

• Sikaryan-Raub-Sonderfertigkeiten
• Lykanthropische Gaben
• Talentstilsonderfertigkeiten
• Erweiterte Talentsonderfertigkeiten
• Kugelzauber (Gildenmagier)
• Kesselzauber
• Kappenzauber
• Spielzeugzauber
• Schalenzauber
• Sex-Schicksalspunktsonderfertigkeiten
• Sex-Sonderfertigkeiten
• Waffenzauber
• Sichelrituale
• Ringzauber
• Chronikzauber
• Trinkhornzauber
• Krallenkettenzauber

Item Groups

• Ausrüstung der Geweihtenschaft
• Liebesspielzeug

Focus Rules

• Kirchenprägungen

Poisons

• Schema
• Entries converted
• Evaluate splitting up schemes (AHE)
• Giftart: Dämonisch

Pflanzliche Hilfsmittel

Extracted from #4.

MagicalArtifacts - Weight is not allowed

Why though.

Patrons

• Schema
• Entries converted
• Typische Vorteile
• Typische Nachteile
• Typische Zauber

Weapon/restricted_to_traditions[] restricted to MagicalTraditionReference

https://github.com/elyukai/optolith-database-schema/blob/main/docs/reference/equipment/item/Weapon.md#Weapon/restricted_to_traditions[]

This property should probably support blessed_traditions, too?
Example: Data\Equipment\Weapons\19_Ravens-Beak.yml - currently causes errors.

Item category "Stationery" is misspelled

"Schreibwerkzeug" translates to "Stationery", not "Stationary"

Items - Musicalinstruments: attributes `complexity` and `combat_use` missing

e. g. Data\Equipment\MusicalInstruments\3_Flute.yml (branch: pickbreaker)

Weapon's "complexity" field is mandatory, but some weapons don't have a complexity

Current examples (pickbreaker branch):

• Data\Equipment\Weapons\67_Stone.yml
• Data\Equipment\Weapons\86_Soap-In-Cloth-Tube.yml

Equipment/Armor - "complexity" field is mandatory, but no complexity is given for helmets in the rules

see "Aventurische Rüstkammer II", pp 148f. The column "complexity" is missing, in contrast to the previous pages / item categories.

Items: Mandatory attributes not available in all cases

Example: The description Gürtelhalter (Aventurische Rüstkammer II, S. 121) doesn't provide values for "weight" or "structure_points", which are both mandatory fields for WeaponAccessory.

Trade Secrets

• Schema

Botch Table

Focus Rules

• Schema
• Handle subjects as category?
• Entries converted

Poisons: duration type `instant` missing

Currently only possible with a workaround such as

duration:
default:
constant:
unit: CombatRounds
value: 0
tag: Constant

Some animal poisons have an instant duration, e. g. https://dsa.ulisses-regelwiki.de/brba.html

Elixire

• Schema (maybe multiple schemas make more sense, evaluate)

No "rules" in Ammunition/AmmunitionTranslation

In the Ammunition/AmmunitionTranslation schema provides no field for rules or notes. However, this information is even included in the old data.

Books - mandatory information missing

Books from "Gods of Aventuria" - (pp. 232) lack complexity, structure points, and weight:

Items

• Schema
• Weapon can be for multiple combat techniques with different values at once
• Weapons and Armors in other groups?
• Secondary Type may have associated valeus such as structure points
• Different base values depending on group (some may not have price or weight for example)
• Entry may belong to multiple groups (combat-use group and profane group)