How to use simple SQL code to change costs of individual techs or buildings?

Takfloyd

Prince
Joined
Apr 17, 2005
Messages
502
Location
Bergen
I believe this should be possible with a single line of code, such as in Gedemon's slower tech mod where tech costs are multiplied like for example:

UPDATE Technologies SET Cost = Cost*1.5 WHERE EraType ='ERA_INFORMATION';

But I would like to do it per technology, or per district/unit/building/project. What would be the syntax for this?

EDIT: After some research, I think this should work:

UPDATE Technologies SET Cost = Cost*2 WHERE TechnologyType ='TECH_NUCLEAR_FUSION';
 
Last edited:
Back
Top Bottom