Change VP Options

andersw · Sep 9, 2019

I've been trying to find a way to remove free worker on emperor+ and this is supposedly the tool (I dont get it to work with really advanced setup).
Now, how, what where do I need to add for this change?

Asterix Rage · Sep 9, 2019

andersw said:
I dont get it to work with really advanced setup

RAS is so good to deal with that...

psparky · Sep 9, 2019

Having installed the mod, edit the file code.sql and add the following:

UPDATE HandicapInfos SET
AIStartingWorkerUnits = '0'
WHERE Type = 'HANDICAP_EMPEROR';

and similar for the other difficulties.

ryanmusante · Sep 22, 2019

psparky said:
I've been making good use of this mod, mostly to configure the game to my personal tastes, but also for it's original purpose of saving game options. Thanks for making it

Thanks for help with any of this.

What kind of things could you post as samples that some would find useful?

Yaviel · Oct 14, 2019

Sub6, a big thank you from me for opening up modding to us laymen. I've been using your mod a long time now and through it got interested in learning to modify Civ V myself. Recently, I released my first mod Beyond which incorporates some custom mod options by default and you are listed under the special thanks! :c5happy:

Check it out and let me know what you think. Anyway this is how my Code.sql for Change VP Options looks like, making all my games more enjoyable.

Code:

-- Advanced Game Options

   UPDATE GameOptions SET "Default" = 1 WHERE Type = 'GAMEOPTION_EVENTS';

   UPDATE GameOptions SET "Default" = 1 WHERE Type = 'GAMEOPTION_BAD_EVENTS_OFF';

   UPDATE GameOptions SET "Default" = 1 WHERE Type = 'GAMEOPTION_NO_BARBARIANS';

   UPDATE GameOptions SET "Default" = 1 WHERE Type = 'GAMEOPTION_NO_TECH_BROKERING';

   UPDATE GameOptions SET "Default" = 1 WHERE Type = 'GAMEOPTION_NO_TECH_TRADING';

   UPDATE GameOptions SET "Default" = 1 WHERE Type = 'GAMEOPTION_RANDOM_PERSONALITIES';

   UPDATE GameOptions SET "Default" = 1 WHERE Type = 'GAMEOPTION_RANDOM_VICTORY';

   UPDATE GameOptions SET "Default" = 1 WHERE Type = 'GAMEOPTION_ADVANCED_DIPLOMACY';

-- Unit Selection Sound

   INSERT INTO Audio_2DSounds (ScriptID, SoundID, SoundType, MaxVolume, MinVolume)
   SELECT 'AS2D_SELECT_SETTLER', 'SND_SELECT_SETTLER', 'GAME_SFX', 0, 0 UNION ALL
   SELECT 'AS2D_SELECT_WORKER', 'SND_SELECT_WORKER', 'GAME_SFX', 0, 0;

-- City Ambience

   INSERT INTO Audio_2DSounds (ScriptID, SoundID, SoundType, Looping, DontTriggerDuplicates, DontPlayMoreThan, MaxVolume, MinVolume)
   SELECT 'AS2D_AMBIENCE_CITY_ERA_ANCIENT_LARGE', 'SND_AMBIENCE_CITY_ANC_LARGE', 'GAME_AMBIENCE', 1, 1, 1, 20, 20 UNION ALL
   SELECT 'AS2D_AMBIENCE_CITY_ERA_ANCIENT_SMALL', 'SND_AMBIENCE_CITY_ANC_SMALL', 'GAME_AMBIENCE', 1, 1, 1, 20, 20 UNION ALL
   SELECT 'AS2D_AMBIENCE_CITY_ERA_CLASSICAL_LARGE', 'SND_AMBIENCE_CITY_ANC_LARGE', 'GAME_AMBIENCE', 1, 1, 1, 20, 20 UNION ALL
   SELECT 'AS2D_AMBIENCE_CITY_ERA_CLASSICAL_SMALL', 'SND_AMBIENCE_CITY_ANC_SMALL', 'GAME_AMBIENCE', 1, 1, 1, 20, 20 UNION ALL
   SELECT 'AS2D_AMBIENCE_CITY_ERA_MEDIEVAL_LARGE', 'SND_AMBIENCE_CITY_MED_LARGE', 'GAME_AMBIENCE', 1, 1, 1, 20, 20 UNION ALL
   SELECT 'AS2D_AMBIENCE_CITY_ERA_MEDIEVAL_SMALL', 'SND_AMBIENCE_CITY_MED_SMALL', 'GAME_AMBIENCE', 1, 1, 1, 20, 20 UNION ALL
   SELECT 'AS2D_AMBIENCE_CITY_ERA_RENAISSANCE_LARGE', 'SND_AMBIENCE_CITY_MED_LARGE', 'GAME_AMBIENCE', 1, 1, 1, 20, 20 UNION ALL
   SELECT 'AS2D_AMBIENCE_CITY_ERA_RENAISSANCE_SMALL', 'SND_AMBIENCE_CITY_MED_SMALL', 'GAME_AMBIENCE', 1, 1, 1, 20, 20 UNION ALL
   SELECT 'AS2D_AMBIENCE_CITY_ERA_INDUSTRIAL_LARGE', 'SND_AMBIENCE_CITY_IND_LARGE', 'GAME_AMBIENCE', 1, 1, 1, 20, 20 UNION ALL
   SELECT 'AS2D_AMBIENCE_CITY_ERA_INDUSTRIAL_SMALL', 'SND_AMBIENCE_CITY_IND_SMALL', 'GAME_AMBIENCE', 1, 1, 1, 20, 20 UNION ALL
   SELECT 'AS2D_AMBIENCE_CITY_ERA_MODERN_LARGE', 'SND_AMBIENCE_CITY_MODERN_LARGE', 'GAME_AMBIENCE', 1, 1, 1, 20, 20 UNION ALL
   SELECT 'AS2D_AMBIENCE_CITY_ERA_MODERN_SMALL', 'SND_AMBIENCE_CITY_MODERN_SMALL', 'GAME_AMBIENCE', 1, 1, 1, 20, 20 UNION ALL
   SELECT 'AS2D_AMBIENCE_CITY_ERA_FUTURE_LARGE', 'SND_AMBIENCE_CITY_MODERN_LARGE', 'GAME_AMBIENCE', 1, 1, 1, 20, 20 UNION ALL
   SELECT 'AS2D_AMBIENCE_CITY_ERA_FUTURE_SMALL', 'SND_AMBIENCE_CITY_MODERN_SMALL', 'GAME_AMBIENCE', 1, 1, 1, 20, 20;

PS: The free AI workers are now gone on all difficulties since the latest beta.

Sub6 · Oct 14, 2019

BlueCulture said:
Sub6, a big thank you from me for opening up modding to us laymen. I've been using your mod a long time now and through it got interested in learning to modify Civ V myself. Recently, I released my first mod Beyond which incorporates some custom mod options by default and you are listed under the special thanks! Check it out and let me know what you think. Anyway this is how my Code.sql for Change VP Options looks like, making all my games more enjoyable.

I'd love to check it.

PS: The free AI workers are now gone on all difficulties since the latest beta.

Thank you for letting me know.
I have to catch up on recent versions.

Sub6 · Nov 10, 2019

ver. 2019.11.08 Beta
for those who try Recursive's Diplo AI options

cf.
(1) Community Patch\Core Files\Core Changes\CoreChanges.sql
Line: 45-65

Code:

-- set "DISABLE VICTORY COMPETITION" by default
-- "the AI will not receive any aggression boosts towards competitors for victory conditions."
UPDATE Defines SET Value = '1' WHERE Name = 'DIPLO_AI_NO_VICTORY_COMPETITION';

Code:

-- set "PASSIVE AI (HUMAN ONLY)" by default
-- "AI civilizations will never initiate wars with human players."
UPDATE Defines SET Value = '1' WHERE Name = 'DIPLO_AI_WAR_DISALLOWED_HUMAN';

Code:

-- set "PASSIVE AI (GLOBAL)" by default
-- "AI civilizations will never initiate wars with other civs or City-States."
UPDATE Defines SET Value = '1' WHERE Name = 'DIPLO_AI_WAR_DISALLOWED_GLOBAL';

ryanmusante · Feb 12, 2020

Damthe said:
is there a way to remove experience penalty from purchased units ?

and also for scout and pathfinder barbarian penalties i've tried these codes but it doesnt work any solution to it aswell ?

Does the AI lose experience when purchasing units?

TheOneHitPupper · Mar 28, 2020

Is there a way to have it save map type options? Like if you're using the Communitas map each time, have it save settings for Rainfall, Temperature, etc.? Also is there a way to save how many City-States/AI players there are?

Asterix Rage · Mar 28, 2020

TheOneHitPupper said:
Is there a way to have it save map type options? Like if you're using the Communitas map each time, have it save settings for Rainfall, Temperature, etc.? Also is there a way to save how many City-States/AI players there are?

I'm not sure about what you are looking for but using RAS, \ModUserData\GTAS_AdvancedSetupMod-15.db keeps all the setup

ryanmusante · Mar 28, 2020

TheOneHitPupper said:
Is there a way to have it save map type options? Like if you're using the Communitas map each time, have it save settings for Rainfall, Temperature, etc.? Also is there a way to save how many City-States/AI players there are?

Something like this for the XML.

Code:

    <Worlds>
        <Update>
            <Where Type="WORLDSIZE_DUEL"/>
            <Set DefaultPlayers="4" DefaultMinorCivs="8"/>       
        </Update>
        <Update>
            <Where Type="WORLDSIZE_TINY"/>
            <Set DefaultPlayers="6" DefaultMinorCivs="10"/>
        </Update>
        <Update>
            <Where Type="WORLDSIZE_SMALL"/>
            <Set DefaultPlayers="8" DefaultMinorCivs="12"/>
        </Update>
        <Update>
            <Where Type="WORLDSIZE_STANDARD"/>
            <Set DefaultPlayers="10" DefaultMinorCivs="14"/>
        </Update>
        <Update>
            <Where Type="WORLDSIZE_LARGE"/>
            <Set DefaultPlayers="12" DefaultMinorCivs="16"/>
        </Update>
        <Update>
            <Where Type="WORLDSIZE_HUGE"/>
            <Set DefaultPlayers="14" DefaultMinorCivs="18"/>
        </Update>
    </Worlds>

Catan · May 7, 2020

What is the best way to find out what the following options are called in SQL?

Max Turns
Allow Policy Saving
Allow Promotion Saving
Complete Kills
Disable Start Bias
New Random Seed
No Ancient Ruins
No City Razing
No Espionage
One-City Challenge
Quick Combat
Quick Movement
Raging Barbarians
Time
Science
Domination
Cultural
Diplomatic

I know victory conditions can be changed in config.ini but I need it to work in SQL.

Sub6 · May 8, 2020

Catan said:
What is the best way to find out what the following options are called in SQL?

I could't find the "Max Turns".
cf.
\Sid Meier's Civilization V\Assets\Gameplay\XML\GameInfo\CIV5GameOptions.xml
\Sid Meier's Civilization V\Assets\DLC\Expansion\Gameplay\XML\GameInfo\CIV5GameOptions_Expansion.xml

Spoiler Game Options :

cf.
\Sid Meier's Civilization V\Assets\Gameplay\XML\GameInfo\CIV5Victories.xml

Spoiler Victory conditions :

For your information, disabling all Victory conditions causes a crash.

Catan · May 25, 2020

Sub6 said:
I could't find the "Max Turns".
cf.
\Sid Meier's Civilization V\Assets\Gameplay\XML\GameInfo\CIV5GameOptions.xml
\Sid Meier's Civilization V\Assets\DLC\Expansion\Gameplay\XML\GameInfo\CIV5GameOptions_Expansion.xml

Spoiler Game Options :

-- Allow Policy Saving
UPDATE GameOptions SET "Default" = 1 WHERE Type = 'GAMEOPTION_POLICY_SAVING';

-- Allow Promotion Saving
UPDATE GameOptions SET "Default" = 1 WHERE Type = 'GAMEOPTION_PROMOTION_SAVING';

-- Complete Kills
UPDATE GameOptions SET "Default" = 1 WHERE Type = 'GAMEOPTION_COMPLETE_KILLS';

-- Disable Start Bias
UPDATE GameOptions SET "Default" = 1 WHERE Type = 'GAMEOPTION_DISABLE_START_BIAS';

-- New Random Seed
UPDATE GameOptions SET "Default" = 1 WHERE Type = 'GAMEOPTION_NEW_RANDOM_SEED';

-- No Ancient Ruins
UPDATE GameOptions SET "Default" = 1 WHERE Type = 'GAMEOPTION_NO_GOODY_HUTS';

-- No City Razing
UPDATE GameOptions SET "Default" = 1 WHERE Type = 'GAMEOPTION_NO_CITY_RAZING';

-- No Espionage
UPDATE GameOptions SET "Default" = 1 WHERE Type = 'GAMEOPTION_NO_ESPIONAGE';

-- One-City Challenge
UPDATE GameOptions SET "Default" = 1 WHERE Type = 'GAMEOPTION_ONE_CITY_CHALLENGE';

-- Quick Combat
UPDATE GameOptions SET "Default" = 1 WHERE Type = 'GAMEOPTION_QUICK_COMBAT';

-- Quick Movement
UPDATE GameOptions SET "Default" = 1 WHERE Type = 'GAMEOPTION_QUICK_MOVEMENT';

-- Raging Barbarians
UPDATE GameOptions SET "Default" = 1 WHERE Type = 'GAMEOPTION_RAGING_BARBARIANS';

cf.
\Sid Meier's Civilization V\Assets\Gameplay\XML\GameInfo\CIV5Victories.xml

Spoiler Victory conditions :

DELETE FROM Victories WHERE Type = 'VICTORY_TIME';
DELETE FROM Victories WHERE Type = 'VICTORY_SPACE_RACE';
DELETE FROM Victories WHERE Type = 'VICTORY_DOMINATION';
DELETE FROM Victories WHERE Type = 'VICTORY_CULTURAL';
DELETE FROM Victories WHERE Type = 'VICTORY_DIPLOMATIC';

For your information, disabling all Victory conditions causes a crash.

Oh! You didn't need to write them all out for me but thank you very much. Do you also know if it's possible to update victories instead of deleting them? I tried but to no avail.

Sub6 · May 28, 2020

Catan said:
Do you also know if it's possible to update victories instead of deleting them? I tried but to no avail.

Unfortunately, I have no idea.

Asterix Rage · Feb 28, 2021

As suggested by @Kim Dong Un here.

Hotels reduce 1 urbanization

Code:

UPDATE Buildings
SET NoUnhappfromXSpecialists = '1'
WHERE Type = 'BUILDING_HOTEL';

Kim Dong Un · Feb 28, 2021

Asterix Rage said:
As suggested by @Kim Dong Un here.

Hotels reduce 1 urbanization

Code:

UPDATE Buildings SET NoUnhappfromXSpecialists = '1' WHERE Type = 'BUILDING_HOTEL';

Supreme Leader gets no credit for this one. Direct your praise to @Stalker0 !

Asterix Rage · Feb 28, 2021

Asterix Rage said:
Hotels reduce 1 urbanization

@Kim Dong Un
And because a feature not said in civilopedia is like a bug:

Code:

-- Hotels reduce 1 urbanization
UPDATE Buildings
SET NoUnhappfromXSpecialists = '1'
WHERE Type = 'BUILDING_HOTEL';

UPDATE Language_en_US
SET Text = '25% of the [ICON_CULTURE] Culture from World Wonders, Natural Wonders, and Tiles is added to the [ICON_TOURISM] Tourism output of the city. [ICON_TOURISM] Tourism output from Great Works +25%.[NEWLINE][NEWLINE]1 Specialist in this City no longer produces [ICON_HAPPINESS_3] Unhappiness from Urbanization.'
WHERE Tag = 'TXT_KEY_BUILDING_HOTEL_HELP' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_BUILDINGS' AND Value= 1 );

Asterix Rage · Aug 3, 2021

The very late game CERN Wonder gives 2 free techs. Useless IMO.
I suggest 2 free Great Prophets instead:

Code:

-- CERN gives 2 Great Prophets instead of 2 Free Technologies
UPDATE Buildings SET FreeTechs = '0' WHERE Type = 'BUILDING_CERN';
INSERT INTO Building_FreeUnits (BuildingType, UnitType, NumUnits)
SELECT 'BUILDING_CERN' , 'UNIT_PROPHET' , '2'
WHERE EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_BUILDINGS' AND Value= 1 );
UPDATE Language_en_US
SET Text = 'Receive 2 [COLOR_POSITIVE_TEXT]Free[ENDCOLOR] Great Prophets and +100 [ICON_INFLUENCE] Influence with all [ICON_CITY_STATE] City-States in the world.'
WHERE Tag = 'TXT_KEY_BUILDING_CERN_HELP' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_BUILDINGS' AND Value= 1 );

After all, many still hope that science and education will someday make religious mythology definitely obsolete.

ryanmusante · Mar 5, 2022

@adan_eslavo
Would using AlternativeNames.sql (Alternative Component Names) & PromotionTextChanges.sql (Promotion Overhaul) as \SQL\Code_4.sql and \SQL\Code_5.sql work if I'm not using any of the extra mods that require compatibility patches?

Change VP Options

Emperor

Warlord

King

Emperor

Chieftain

Chieftain

Chieftain

Emperor

Chieftain

Warlord

Emperor

Chieftain

Chieftain

Chieftain

Chieftain

Warlord

The One & Unly

Warlord

Warlord

Emperor

Similar threads