Making non Builders have access to building all improvements

[Pikachaoomega]

Hi!
So I'm very new to modding Civ 6 and sql in general and I've been using the MC_MasterTemplate thats on this site. I was able to figure out how to give builder charges to the unit I want (Missionary) and it can build the Colossal head that the template has as the UI but I can't get it to be able to build all the other improvements like farm or mines or etc.

Any help? I feel like I'm so close to figuring it out but using the modifier for improvements doesn't seem to make it work?

EDIT: From my research into like the base XML all the unique improvements that could have been used by multiple units are new improvements, like the Roman Legion getting a Roman Fort and military engineers only getting a fort. Is there an easy way to duplicate and rename improvements like farms so i could have like Civ_Farm type thing going on?

 

[DarkAlzara]

Hi!
So I'm very new to modding Civ 6 and sql in general and I've been using the MC_MasterTemplate thats on this site. I was able to figure out how to give builder charges to the unit I want (Missionary) and it can build the Colossal head that the template has as the UI but I can't get it to be able to build all the other improvements like farm or mines or etc.

Any help? I feel like I'm so close to figuring it out but using the modifier for improvements doesn't seem to make it work?

EDIT: From my research into like the base XML all the unique improvements that could have been used by multiple units are new improvements, like the Roman Legion getting a Roman Fort and military engineers only getting a fort. Is there an easy way to duplicate and rename improvements like farms so i could have like Civ_Farm type thing going on?

You need to insert into Improvement_ValidBuildUnits and you will need to do it for all the improvements you want your new unit to be able to build. For example if you want your new unit to be able to build farms, mines and quarries, you would use something like this:-

INSERT INTO Improvement_ValidBuildUnits
(ImprovementType, UnitType)
VALUES ('IMPROVEMENT_FARM', 'MY_NEW_UNIT_TAG'),
('IMPROVEMENT_MINE', ''MY_NEW_UNIT_TAG'),
('IMPROVEMENT_QUARRY', ''MY_NEW_UNIT_TAG');

Hope this helps

 

[Pikachaoomega]

You need to insert into Improvement_ValidBuildUnits and you will need to do it for all the improvements you want your new unit to be able to build. For example if you want your new unit to be able to build farms, mines and quarries, you would use something like this:-

INSERT INTO Improvement_ValidBuildUnits
(ImprovementType, UnitType)
VALUES ('IMPROVEMENT_FARM', 'MY_NEW_UNIT_TAG'),
('IMPROVEMENT_MINE', ''MY_NEW_UNIT_TAG'),
('IMPROVEMENT_QUARRY', ''MY_NEW_UNIT_TAG');

Hope this helps

Worked like a charm!! Thanks!

 

[DarkAlzara]

Worked like a charm!! Thanks!

No problem