• Our friends from AlphaCentauri2.info are in need of technical assistance. If you have experience with the LAMP stack and some hours to spare, please help them out and post here.

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