Posted by: db48x
« on: August 16, 2020, 07:33:01 PM »I like your organization; you actually put some thought into the size ratio.
A few minutes ago I realized that I had made a horrible blunder in my own game: I put 5 brigades into every battalion!
I had to stop and write some SQL to fix it:
A few minutes ago I realized that I had made a horrible blunder in my own game: I put 5 brigades into every battalion!
I had to stop and write some SQL to fix it:
Code: [Select]
UPDATE FCT_GroundUnitClass SET ClassName = replace(ClassName, "Brigade", "Battalion") WHERE FCT_GroundUnitClass.GameID = 35 AND ClassName LIKE '%Brigade HQ%' AND HQCapacity = 1000;
UPDATE FCT_GroundUnitClass SET ClassName = replace(ClassName, "Battalion", "Brigade") WHERE FCT_GroundUnitClass.GameID = 35 AND ClassName LIKE '%Battalion HQ%' AND HQCapacity = 5000;
UPDATE FCT_GroundUnitFormationTemplate SET Name = replace(Name, "Brigade", "Battalion") WHERE RaceID = 197 AND Name LIKE '%Brigade%' AND Abbreviation LIKE 'HA1%';
UPDATE FCT_GroundUnitFormationTemplate SET Name = replace(Name, "Battalion", "Brigade") WHERE RaceID = 197 AND Name LIKE '%Battalion%' AND Abbreviation LIKE 'HA2%';
UPDATE FCT_GroundUnitFormation SET Name = replace(Name, "Brigade", "Battalion") WHERE RaceID = 197 AND Name LIKE '%Brigade%' AND Abbreviation LIKE 'HA1%';
UPDATE FCT_GroundUnitFormation SET Name = replace(Name, "Battalion", "Brigade") WHERE RaceID = 197 AND Name LIKE '%Battalion%' AND Abbreviation LIKE 'HA2%';