What do these tables do?

[Mackles]

A rather blunt way of titling the thread, but I don't want to waste anyone's time with a clever turn of phrase

Anyway, I am in the stages of building my own battle overhaul mod, but was wondering about a few tables that Ithink I might need, but am not quite sure if I do. If anyone could shed some light as to what I can do with the following it would be mucho appreciated!

effect_bonus_value_siege_item_junctions
effect_bonus_value_unit_ability_junctions

missile_weapons
missile_weapons_to_projectiles
projectile_displays
projectile_shot_type_enums
projectiles_explosions

special_ability_groups
special_ability_groups_to_factions_junctions
special_ability_to_invalid_usage_flags
special_ability_to_special_ability_phase_junctions

unit_abilities
unit_attribute_groups
unit_to_groupings_military_permissions
unit_attributes_to_groups_junctions
unit_experience_bonuses
unit_experience_threshold_modifiers
unit_set_to_unit_junctions


Any and all answers will be most helpful! I shall endeavor to make sense of the rest of what I've gotten myself into!

[crzyrndm]

//-- the effect_bonus_value_<stuff>_junctions tables assign internal effect ids to database entries. Siege_item_juctions is all about the effects which set what engines are allowed to be built when besieging. Unit_ability_junctions is used for abilities that affect other abilities currently by the looks, and enabling various command abilities that have requirements.
effect_bonus_value_siege_item_junctions
effect_bonus_value_unit_ability_junctions


missile_weapons // the weapons that go into the ranged column in land_units
missile_weapons_to_projectiles // The alternate/secondary projectiles that weapon may use (the weapon will start with the projectile selected in missile_weapons active)
projectile_displays // vfx assignments for projectiles
projectile_shot_type_enums // locking projectiles so that they require an effect to unlock them, dunno if supersedes works, but if it did, I'd guess that say you put explosive in the flammable entry, and then unlocked flammable, explosive would be replaced by flammable.
projectiles_explosions // Setting up the explosion caused by a projectile impact. Damage is non-ap, don't make it fire a million projectiles if you want your computer to continue living, error margin is how much the amount of projectiles varies.

special_ability_groups // command ability icons by the looks
special_ability_groups_to_factions_junctions // lockingabilities to factions
special_ability_to_invalid_usage_flags // situations where the ability cannot be activated
special_ability_to_special_ability_phase_junctions // tying an ability to the phases (progression over time). special_ability_phases and special ability_phase_effects control the actual impact of each ability

unit_abilities // requires enabling and possibly tooltips
unit_attribute_groups // groups of attributes to be assigned to units
unit_to_groupings_military_permissions // factions/groups that can recruit a unit
unit_attributes_to_groups_junctions // assigning individual attributes to the groups defined above
unit_experience_bonuses
unit_experience_threshold_modifiers // Multipliers on the amount of experience a unit requires to rank up
unit_set_to_unit_junctions // assigning a set to each unit. Sets are used for campaign effects such as decreasing recruit cost of light/heavy/merc units

That should do it. I'm not sure on the experience table, because I thought the bonuses were standardised/flat, but I don't know.

[Mackles]

crzyrndm thank you sooo much! Saved me a lot of time and head scratching

I've also recently started using the table fragment method you outlined, hopefully keeping my stuff nice and neat.

Basically, you're my hero/deity.

[crzyrndm]

crzyrndm thank you sooo much!

Not a problem