Change VP Options

ryanmusante · Feb 10, 2018

Thank you for all your help.

In /Sid Meier's Civilization 5/MODS/(1) Community Patch/Core Files/Core Tables, the CustomModOptions.xml file states to use the mod at "picknmix" rather than just selecting a value. Must you install the actual mod into the mods folder or could you just enable the switch from within the file without any problems?

Sub6 · Feb 10, 2018

ryanmusante said:
Thank you for all your help.

In /Sid Meier's Civilization 5/MODS/(1) Community Patch/Core Files/Core Tables, the CustomModOptions.xml file states to use the mod at "picknmix" rather than just selecting a value. Must you install the actual mod into the mods folder or could you just enable the switch from within the file without any problems?

Some of the WHoward's mods just change the Value of CustomModOptions.
e.g. Global - Local Generals

Code:

<?xml version="1.0" encoding="utf-8"?>
<GameData>
    <CustomModOptions>
        <Update>
            <Where Name="GLOBAL_LOCAL_GENERALS"/>
            <Set Value="1"/>
        </Update>
    </CustomModOptions>
</GameData>

In that case, you don't need the actual mod.
These code worked for me without the actual mods.

Code:

UPDATE CustomModOptions SET Value = '1' WHERE Name = 'GLOBAL_LOCAL_GENERALS';
UPDATE CustomModOptions SET Value = '1' WHERE Name = 'GLOBAL_RELIGIOUS_SETTLERS';
UPDATE CustomModOptions SET Value = '1' WHERE Name = 'DIPLOMACY_AUTO_DENOUNCE';

ryanmusante · Feb 11, 2018

/home/ryan/Documents/My Games/Sid Meier's Civilization 5/Logs has a CustomMods.log which appears to be the comprehensive list of parameters built-in without the need for external mod, is this correct?

Spoiler CustomMods.log :

Deadstarre · Feb 11, 2018

ryanmusante said:
appears to be the comprehensive list of parameters built-in without the need for external mod, is this correct?

a lot of those look like mod options that are in and for the vp package only, not set up to trigger off something external

Sub6 · Feb 11, 2018

ryanmusante said:
/home/ryan/Documents/My Games/Sid Meier's Civilization 5/Logs has a CustomMods.log which appears to be the comprehensive list of parameters built-in without the need for external mod, is this correct?

I’m not sure, but these mods use various files.

Global - Capture Great People
Global - Coastal Waters Only
UI - City Production
UI - Diary

In this case, you need original mods.
For example, this code didn't work without the actual mod.

Code:

UPDATE CustomModOptions SET Value = '1' WHERE Name = 'EVENTS_UNIT_CAPTURE';

ryanmusante · Mar 17, 2018

For deletion of regular units in the game, i.e. the mechs, how do I go about this?

Code:

<?xml version="1.0" encoding="utf-8"?>
<GameData>
    <UnitClasses>
        <Delete Type="UNITCLASS_MECH"/>
        <Delete Type="UNITCLASS_XCOM_SQUAD"/>
    </UnitClasses>

    <DeleteMissingReferences table="UnitClasses" column="Type"/>
    <DeleteMissingReferences table="Units" column="Type"/>

Sub6 · Mar 17, 2018

ryanmusante said:

For deletion of regular units in the game, i.e. the mechs, how do I go about this?

Code:

<?xml version="1.0" encoding="utf-8"?>
<GameData>
    <UnitClasses>
        <Delete Type="UNITCLASS_MECH"/>
        <Delete Type="UNITCLASS_XCOM_SQUAD"/>
    </UnitClasses>

    <DeleteMissingReferences table="UnitClasses" column="Type"/>
    <DeleteMissingReferences table="Units" column="Type"/>

I added a file (Code.xml) in January.
Please insert your code into it.
Like this

Code:

<?xml version="1.0" encoding="utf-8"?>
<GameData>
    <UnitClasses>
        <Delete Type="UNITCLASS_MECH"/>
        <Delete Type="UNITCLASS_XCOM_SQUAD"/>
    </UnitClasses>
    <DeleteMissingReferences table="UnitClasses" column="Type"/>
    <DeleteMissingReferences table="Units" column="Type"/>
</GameData>

ryanmusante · Mar 17, 2018

Excellent! Could you update samples.txt with some of what you're using? I like your recommendations.

Sub6 · Mar 17, 2018

ryanmusante said:
Excellent! Could you update samples.txt with some of what you're using? I like your recommendations.

Nothing has changed, unfortunately.

Deadstarre · Apr 6, 2018

I actually ran into a thread with an old mod from whoward providing basically the same thing as has been done here but for vanilla civ, not VP. of course VP is the new vanilla... so basically Sub6 is whoward level of greatness for providing this =) thank you again!

ryanmusante · Apr 6, 2018

Is empty spacing between xml elements a problem? Or will it process the same without? I just like to use spacing to make it easier to read.

Code:

<?xml version="1.0" encoding="utf-8"?>
<GameData>
    <Civilizations>
        <Update>
            <Where Type='CIVILIZATION_AUSTRIA'/>
            <Set AIPlayable="false"/>
        </Update>
        <Update>
            <Where Type='CIVILIZATION_VENICE'/>
            <Set AIPlayable="false"/>
        </Update>
    </Civilizations>
 
    <Resolutions>
        <Delete Type="RESOLUTION_BAN_LUXURY_HAPPINESS"/>
    </Resolutions>
 
    <UnitClasses>
        <Delete Type="UNITCLASS_MECH"/>
        <Delete Type="UNITCLASS_XCOM_SQUAD"/>
    </UnitClasses>

    <DeleteMissingReferences table="UnitClasses" column="Type"/>
    <DeleteMissingReferences table="Units" column="Type"/>
</GameData>

Deadstarre · Apr 6, 2018

ryanmusante said:
Is empty spacing between xml elements a problem? Or will it process the same without? I just like to use spacing to make it easier to read.

https://forums.civfanatics.com/threads/how-to-enable-logging.487482/

I believe the Database log is the place to know where (if) you're making syntax errors

ryanmusante · Apr 6, 2018

Is there any future updates to include a LUA file function?

Sub6 · Apr 8, 2018

Deadstarre said:
I actually ran into a thread with an old mod from whoward providing basically the same thing as has been done here but for vanilla civ, not VP. of course VP is the new vanilla... so basically Sub6 is whoward level of greatness for providing this =) thank you again!

I just copy whoward's code.

ryanmusante said:
Is empty spacing between xml elements a problem? Or will it process the same without? I just like to use spacing to make it easier to read.

I’m not sure, but your code seems to work.

ryanmusante said:
Is there any future updates to include a LUA file function?

I'm sorry to say I can't handle Lua.

Deadstarre · Apr 24, 2018

any idea how to change settings in the CommunityOptions.SQL file? COMMUNITY_CORE_BALANCE_RESOURCE_REVEAL for example, i'm trying to change the value to zero, i've tried update statements and also delete / insert but nothing seems to be working, I feel like im missing something here.

EDIT: well, i think reading is important. I see now "Disabling files below will only remove the SQL changes. If you also want to remove the XML changes, you will need to delete the associated XML files"

and i've been using only SQL statements. so this means I need to be updating values in both SQL and XML? i dont see an XML folder with communityoptions set... i am thoroughly confused lol

Sub6 · Apr 24, 2018

Deadstarre said:
any idea how to change settings in the CommunityOptions.SQL file? COMMUNITY_CORE_BALANCE_RESOURCE_REVEAL for example, i'm trying to change the value to zero, i've tried update statements and also delete / insert but nothing seems to be working, I feel like im missing something here.

If you just want to see Bonus resources on the first turn, try this one.

Code:

UPDATE Resources SET TechReveal = 'NULL' WHERE ResourceClassType = 'RESOURCECLASS_BONUS';

Deadstarre · Apr 24, 2018

it works, tyvm. gives error [24279.437] Invalid Reference on Resources.TechReveal - "NULL" does not exist in Technologies but i think its cuz the ' around null. i am still puzzled why this wouldn't work though
UPDATE COMMUNITY
SET Value = 0
WHERE Type = 'COMMUNITY_CORE_BALANCE_RESOURCE_REVEAL';

Asterix Rage · Apr 24, 2018

With each version of VP, I use to edit some files to make my preferences. That's fine but a bit boring.
Also, I don't feel very confortable with the update and delete fonctions.

What do you suggest to add in (Z) Change VP Options to get the same result than :

- Infinite XP vs CS

\MODS\(2) Community Balance Overhaul\Balance Changes\Minors\MinorBonuses.sql

Code:

WHERE Name = 'MINOR_MAX_XP_VALUE' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_MINORS' AND Value= -1 );

set to -1

- PROMOTION_PRISONER_WAR last 8 turns instead of 50

\(2) Community Balance Overhaul\Balance Changes\Units\PromotionChanges.xml

Code:

<Row>
            <Type>PROMOTION_PRISONER_WAR</Type>
            <Description>TXT_KEY_PROMOTION_PRISONER_WAR</Description>
            <Help>TXT_KEY_PROMOTION_PRISONER_WAR_HELP</Help>
            <Sound>AS2D_IF_LEVELUP</Sound>
            <CannotBeChosen>true</CannotBeChosen>
            <OrderPriority>1</OrderPriority>
            <WorkRateMod>-50</WorkRateMod>
            <PromotionDuration>50</PromotionDuration>
            <PortraitIndex>57</PortraitIndex>
            <IconAtlas>PROMOTION_ATLAS</IconAtlas>
            <PediaType>PEDIA_SHARED</PediaType>
            <PediaEntry>TXT_KEY_PROMOTION_PRISONER_WAR</PediaEntry>
        </Row>

<PromotionDuration>50</PromotionDuration> set to 8

And what I have to write to update a TXT_KEY ?

-----------------
I believe the two last ones can be writen as there are? :

- BALANCE_CORE_SCALING_XP

\MODS\(2) Community Balance Overhaul\Core Files\Core Changes\CommunityPatchDLLChanges.sql

Code:

UPDATE CustomModOptions
SET Value = '1'
WHERE Name = 'BALANCE_CORE_SCALING_XP';

Set to 0

- BALANCE_CORE_HALF_XP_PURCHASE
\MODS\(2) Community Balance Overhaul\Core Files\Core Changes\CommunityPatchDLLChanges.sql

Code:

UPDATE CustomModOptions
SET Value = '1'
WHERE Name = 'BALANCE_CORE_HALF_XP_PURCHASE';

Set to 0

Deadstarre · Apr 24, 2018

Asterix Rage said:
I believe the two last ones can be writen as there are? :

- BALANCE_CORE_SCALING_XP

\MODS\(2) Community Balance Overhaul\Core Files\Core Changes\CommunityPatchDLLChanges.sql

Code:

UPDATE CustomModOptions SET Value = '1' WHERE Name = 'BALANCE_CORE_SCALING_XP';

Set to 0

- BALANCE_CORE_HALF_XP_PURCHASE
\MODS\(2) Community Balance Overhaul\Core Files\Core Changes\CommunityPatchDLLChanges.sql

Code:

UPDATE CustomModOptions SET Value = '1' WHERE Name = 'BALANCE_CORE_HALF_XP_PURCHASE';

Set to 0

yes. and like this

Code:

UPDATE Defines
SET Value = '-1'
WHERE Name = 'MINOR_MAX_XP_VALUE';

UPDATE UnitPromotions
SET PromotionDuration = '20'
WHERE Type = 'PROMOTION_PRISONER_WAR';

UPDATE Language_en_US
SET Text = '-50% Work Rate when building Improvements or Routes for 20 turns (from turn captured).'
WHERE Tag = 'TXT_KEY_PROMOTION_PRISONER_WAR_HELP';

thanks for reminding me lol

Asterix Rage · Apr 25, 2018

Thx
---
UPDATE / SET / WHERE
---

Easy actually

Question about syntaxe :
-To set a num. value, do I have to write " = 'value' " or " = value " ( no ' ) Same?
-To set a alphanum. string I assume " 'alphanum' " is mandatory ?
-What about bolean ?

Change VP Options

Emperor

Chieftain

Emperor

Expert

Chieftain

Emperor

Chieftain

Emperor

Chieftain

Expert

Emperor

Expert

Emperor

Chieftain

Expert

Chieftain

Expert

Warlord

Expert

Warlord

Similar threads