LordTerrin
Chieftain
- Joined
- Nov 5, 2001
- Messages
- 15
I've searched the SQL in tons of mods and I haven't found any that modify what happens to a resource when you improve it, (e.g. - build a farm on wheat, build a quarry on stone)
I can set the BASE values of stone's production, for example, by doing this:
or to add a value to a resource that didn't have it in the first place:
Going off the table structure in \Documents\My Games\Sid Meier's Civilization VI\CacheDebugGameplay.sqllite
but I've executed this code and it doesn't not add two additional production to a resource when I farm it.
My question is: Does anyone know the syntax for modifying improvements?
I can set the BASE values of stone's production, for example, by doing this:
Code:
UPDATE Resource_YieldChanges SET YieldChange = '4' WHERE ResourceType = 'RESOURCE_STONE' ;
or to add a value to a resource that didn't have it in the first place:
Code:
INSERT INTO Resource_YieldChanges (ResourceType, YieldType, YieldChange) VALUES ('RESOURCE_WHEAT', 'YIELD_PRODUCTION', '1') ;
Going off the table structure in \Documents\My Games\Sid Meier's Civilization VI\CacheDebugGameplay.sqllite
Code:
INSERT INTO Improvement_YieldChanges (ImprovementType, YieldType, YieldChange) VALUES ('IMPROVEMENT_FARM', 'YIELD_PRODUCTION', '2');
but I've executed this code and it doesn't not add two additional production to a resource when I farm it.
My question is: Does anyone know the syntax for modifying improvements?
Last edited: