1. We have added the ability to collapse/expand forum categories and widgets on forum home.
    Dismiss Notice
  2. All Civ avatars are brought back and available for selection in the Avatar Gallery! There are 945 avatars total.
    Dismiss Notice
  3. To make the site more secure, we have installed SSL certificates and enabled HTTPS for both the main site and forums.
    Dismiss Notice
  4. Civ6 is released! Order now! (Amazon US | Amazon UK | Amazon CA | Amazon DE | Amazon FR)
    Dismiss Notice
  5. Dismiss Notice
  6. Forum account upgrades are available for ad-free browsing.
    Dismiss Notice

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

Discussion in 'Civ6 - Creation & Customization' started by Takfloyd, Dec 2, 2017.

  1. Takfloyd

    Takfloyd Chieftain

    Joined:
    Apr 17, 2005
    Messages:
    246
    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: Dec 2, 2017

Share This Page