Different Government Penalty HELP

[gelodgreat]

Can anyone help me with different government penalty? It works if example you start with reneissance era then you choose a government but after changing eras and gov the penalty gives higher penalty. And it seems that it doesnt work but is should

UPDATE Governments SET OtherGovernmentIntolerance = -0.1 WHERE GovernmentType='GOVERNMENT_AUTOCRACY';
UPDATE Governments SET OtherGovernmentIntolerance = -0.1 WHERE GovernmentType='GOVERNMENT_OLIGARCHY';
UPDATE Governments SET OtherGovernmentIntolerance = -0.1 WHERE GovernmentType='GOVERNMENT_CLASSICAL_REPUBLIC';
UPDATE Governments SET OtherGovernmentIntolerance = -0.1 WHERE GovernmentType='GOVERNMENT_MONARCHY';
UPDATE Governments SET OtherGovernmentIntolerance = -0.1 WHERE GovernmentType='GOVERNMENT_THEOCRACY';
UPDATE Governments SET OtherGovernmentIntolerance = -0.1 WHERE GovernmentType='GOVERNMENT_MERCHANT_REPUBLIC';
UPDATE Governments SET OtherGovernmentIntolerance = -0.1 WHERE GovernmentType='GOVERNMENT_FASCISM';
UPDATE Governments SET OtherGovernmentIntolerance = -0.1 WHERE GovernmentType='GOVERNMENT_COMMUNISM';
UPDATE Governments SET OtherGovernmentIntolerance = -0.1 WHERE GovernmentType='GOVERNMENT_DEMOCRACY';

-- JFD Governments you can remove this lines below if you're not playing with JFD's Rule of Faith
UPDATE Governments SET OtherGovernmentIntolerance = -0.1 WHERE GovernmentType='GOVERNMENT_JFD_ABSOLUTE_MONARCHY';
UPDATE Governments SET OtherGovernmentIntolerance = -0.1 WHERE GovernmentType='GOVERNMENT_JFD_CONSTITUTIONAL_MONARCHY';
UPDATE Governments SET OtherGovernmentIntolerance = -0.1 WHERE GovernmentType='GOVERNMENT_JFD_NOBLE_REPUBLIC';

 

[gyogen2]

Are you able to open your DebugGameplay.sqlite file and see if the changes are actually uploaded into the database, if not, if you want to post it I'll look for you when I can.

 

[gelodgreat]

Are you able to open your DebugGameplay.sqlite file and see if the changes are actually uploaded into the database, if not, if you want to post it I'll look for you when I can.

Thanks mate.

https://drive.google.com/open?id=0B0k2qUZxX80Kc2pwMmU2Y2JyVUU

 

[gyogen2]

The changes do not seem to appear in database:

Are you applying this to a new game or a saved? Also, have you tried clearing the cache then loading? I have to work all day today, but if you haven't found answer I will try to look again tonight.

 

[gyogen2]

I quickly ran the code, and my database showed the updated intolerance.

 

[gelodgreat]

I quickly ran the code, and my database showed the updated intolerance.

so you just clear your cache?

 

[gyogen2]

Just to make sure the game reloads the database. However, if you're trying to apply the changes to a saved game, it seems the game currently doesn't update changes.

 

[gelodgreat]

Just to make sure the game reloads the database. However, if you're trying to apply the changes to a saved game, it seems the game currently doesn't update changes.

so my mod works but need to delete the current cache?

 

[gyogen2]

I'm not sure about your mod, I just added the lines of code to one of my mods to check if they worked. So I can just say the code itself works.
If your mod only consists of those lines, then it should work, if you have other entries also, I can't say without seeing them all.

Are you starting a new game when you test?

 

[gelodgreat]

I'm not sure about your mod, I just added the lines of code to one of my mods to check if they worked. So I can just say the code itself works.
If your mod only consists of those lines, then it should work, if you have other entries also, I can't say without seeing them all.

Are you starting a new game when you test?

can u share me your code that works?

yes i always start a new game when testing mods

 

[gyogen2]

I just copied and pasted from your post and pasted into one of my sqls.

Spoiler :

UPDATE Governments SET OtherGovernmentIntolerance = 0 WHERE GovernmentType='GOVERNMENT_AUTOCRACY';
UPDATE Governments SET OtherGovernmentIntolerance = 0 WHERE GovernmentType='GOVERNMENT_OLIGARCHY';
UPDATE Governments SET OtherGovernmentIntolerance = 0 WHERE GovernmentType='GOVERNMENT_CLASSICAL_REPUBLIC';
UPDATE Governments SET OtherGovernmentIntolerance = 0 WHERE GovernmentType='GOVERNMENT_MONARCHY';
UPDATE Governments SET OtherGovernmentIntolerance = 0 WHERE GovernmentType='GOVERNMENT_THEOCRACY';
UPDATE Governments SET OtherGovernmentIntolerance = 0 WHERE GovernmentType='GOVERNMENT_MERCHANT_REPUBLIC';
UPDATE Governments SET OtherGovernmentIntolerance = 0 WHERE GovernmentType='GOVERNMENT_FASCISM';
UPDATE Governments SET OtherGovernmentIntolerance = 0 WHERE GovernmentType='GOVERNMENT_COMMUNISM';
UPDATE Governments SET OtherGovernmentIntolerance = 0 WHERE GovernmentType='GOVERNMENT_DEMOCRACY';

I didn't copy the JFD government lines since not using that mod.