
Originally Posted by
SamueleD
I have been sticking my nose in the various db tables for some time now, trying to figure out how to effectively nerf transport ships in this game.
Now, as others have previously explained in other threads, there are three very important tables for unit modding in R2: land_units, naval_units and main_units.
land_units defines land units (meaning the soldiers), naval_units defines ships (meaning ships, not crews, only the ships), main_units puts the two together and creates the various units you use in the game, usually it puts together units with transport ships (those are land units in-game), but for those few land units lucky enough to also be the crew of a ship there is one or more additional entries that put together a land unit with a different type of ship, not transport (and those are your naval units in-game). Note that: a)the size of units is defined in main_units b)in-game ship crews and in-game land units are the same land_unit, there is no separate entry, in land_units, the separate entry is in main_units, in-game naval crews are weaker only because they have less men!
That said units have two things going for them: abilities (in-game active abilities, like testudo) and attributes (in-game passive abilities, like disciplined). Ships (naval_units) have abilities, soldiers and crews (land_units) have abilities and belong to an attribute group, which defines their attributes.
If we want to nerf transports by decreasing their hull integrity (hitpoints), mass and speed, we can do that pretty easily, by editing the transport ships in naval_units (transports would still be incredibly dangerous when boarding).
However, if we want to do something more, like making so that units on transport ships get maluses to melee attack, melee defence, accuracy, reload speed and morale, things get pretty hard. Ships don't have attributes, only soldiers do, so we can't give transport ships an attribute that lowers those stats to its crew (or simply the troops it's transporting)!
It would be possible to create a separate land_unit for ship crews, but that would not help us, because we need to have a malus that applies to units only when they are on transport ships.
The only thing that comes to my mind would be to create an entirely new table (not a re-sized version of an already present table, a totally new one, which does something that no existing table does) which would link ship classes (like the transport class) to attributes, create an attribute that lowers the stats I mentioned previously and link it to the transport ship class.
Problem is: I have no idea how to do it and even if it is possible.
Does anyone here have any idea if it can be done and how?