I'm trying to edit the reasearch rate in sqlite, but i can't seem to get it to work. when I edit the rate_goverment_research to any number, I get 999 turns ingame in the research screen. Does anyone have any clue on what I am doing wrong?
1) Go to the "strat_modifiers" table. 2) Scroll down till you hit ""AI***Bonus". Make Sure your under "player_id" = 1 3) Modifing these stats will boost your research/production/revenue. Haven't seen this effect applied to the enemy's, cause they have seperate value's.
@ Tebi Tan: in the table ( number ) you can edit things, just press the triangle to the right to expand it and see all the tables that are inside. if you see the list with admiral trait and admirals and further down players then your ok.
@ evryone: while using these edits i found that my game crashed on database exceptions. so i modded the previously states SQL statements a bit. This made the game more stable. their down below.
As for editing admirals. you can savely edit the name, gender, and evasion loyalty and the other one. however editing the admiral trait, or adding one by force makes the game less stable.
editing your player stats for more savings works fine as long as you stay below the 60 milion. above this the ammount of interest you recieve (1%) will build up your cash so fast it ultimatly goes over the 999 miljon and most certainly crashes the game. the 30 to 60 milion is more then enough to keep going throughout the game. ( if you reach the 800 milion mark, just open up the database/savegame again and reduce your savings to around 60 milion.)
For upgrading planets some research wants to add something so i diminisched them a bit wich makes them more stable
As for Research the statements below set all technologies you did not research jet to feasable and set for research in a certain order. just keep pressing cancel research until they are all canceled if you want to make your own path(like most of us would), it will still stay 1 turn per research. I did this for the stated sql removed the ones you already researched. I also changed the state and feasabilety in the previously mentioned sql statements to prevent lockouts with feasabilety over 1.00.
For Planet upgrades First do this one:
UPDATE planets SET resources=49000, max_resources=49000, size=20, infrastructure=1, suitability=( SELECT suitability FROM factions INNER JOIN players ON factions.id=players.faction_id WHERE players.id=1) WHERE EXISTS ( SELECT colonies.orbital_object_id FROM colonies WHERE colonies.orbital_object_id=planets.orbital_object_id AND colonies.player_id=1 )
THEN do this one:
UPDATE colonies SET shipcon_rate=8 WHERE player_id=1
FOR RESEARCH upgrades
First this one
UPDATE player_techs SET state=5, feasibility=1, player_feasibility=0.99, research_cost=1 WHERE player_id=1 AND state!=6;
THEN this one
UPDATE player_tech_branches SET feasibility=0.99, research_cost=1 WHERE player_id=1;