SLGray
King
Thanks for the Qajar dynasty.
--==========================================================================================================================
-- Gazebo's Community Balance Patch (Vox Populi)
--==========================================================================================================================
-- COMMUNITY
------------------------------------------------------------
CREATE TABLE IF NOT EXISTS COMMUNITY (Type TEXT, Value INTEGER);
------------------------------
-- Building
------------------------------
UPDATE Buildings SET Cost = '500' WHERE Type = 'BUILDING_UC_SAVAK' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_BUILDINGS' AND Value= 1 );
UPDATE Buildings SET GoldMaintenance = '4' WHERE Type = 'BUILDING_UC_SAVAK' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_BUILDINGS' AND Value= 1 );
UPDATE Buildings
SET EspionageModifier = '-25'
WHERE Type = 'BUILDING_UC_SAVAK' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_BUILDINGS' AND Value= 1 );
UPDATE Buildings
SET BlockBuildingDestructionSpies = '1'
WHERE Type = 'BUILDING_UC_SAVAK' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_BUILDINGS' AND Value= 1 );
UPDATE Buildings
SET Defense = '500'
WHERE Type = 'BUILDING_UC_SAVAK' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_BUILDINGS' AND Value= 1 );
------------------------------
-- Units
------------------------------
UPDATE Units SET Combat = '37' WHERE Type = 'UNIT_UC_LITERACY_CORPS' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_UNITS' AND Value= 1 );
UPDATE Units SET BaseLandAirDefense = '8' WHERE Type = 'UNIT_UC_LITERACY_CORPS' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_UNITS' AND Value= 1 );
UPDATE Units SET Cost = '1259' WHERE Type = 'UNIT_UC_LITERACY_CORPS' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_UNITS' AND Value= 1 );
UPDATE Units SET FaithCost = '650' WHERE Type = 'UNIT_UC_LITERACY_CORPS' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_UNITS' AND Value= 1 );
UPDATE Units SET Combat = '37' WHERE Type = 'UNIT_UC_ACADEMY_CORPS' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_UNITS' AND Value= 1 );
UPDATE Units SET BaseLandAirDefense = '8' WHERE Type = 'UNIT_UC_ACADEMY_CORPS' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_UNITS' AND Value= 1 );
UPDATE Units SET Class = 'UNITCLASS_PARATROOPER'
WHERE Type = 'UNIT_UC_LITERACY_CORPS' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_UNITS' AND Value= 1 );
UPDATE Units SET ObsoleteTech = 'TECH_MOBILE_TACTICS'
WHERE Type = 'UNIT_UC_LITERACY_CORPS' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_UNITS' AND Value= 1 );
UPDATE Civilization_UnitClassOverrides SET UnitClassType = 'UNITCLASS_PARATROOPER'
WHERE UnitType = 'UNIT_UC_LITERACY_CORPS' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_UNITS' AND Value= 1 );
UPDATE Language_en_US
SET Text = 'Pahlavi replacement for the Paratrooper, but comes much earlier at Scientific Theory and has adjusted [ICON_STRENGTH] Strength and Cost. When garrisoned, gains XP from building [ICON_FOOD] Food and [ICON_RESEARCH] Science buildings, and they are built faster. Provides [ICON_GREAT_PEOPLE] Great Scientist Points in the [ICON_CAPITAL] Capital when upgrading.'
WHERE Tag = 'TXT_KEY_UNIT_UC_LITERACY_CORPS_HELP' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_UNITS' AND Value= 1 );
UPDATE Language_en_US
SET Text = 'Pahlavi replacement for the Paratrooper, but comes much earlier at Scientific Theory and has adjusted [ICON_STRENGTH] Strength and Cost. When garrisoned, gains XP from building [ICON_FOOD] Food and [ICON_RESEARCH] Science buildings, and they are built faster. Provides [ICON_GREAT_PEOPLE] Great Scientist Points in the [ICON_CAPITAL] Capital when upgrading.'
WHERE Tag = 'TXT_KEY_UNIT_UC_LITERACY_CORPS_STRATEGY' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_UNITS' AND Value= 1 );
For anyone wanting to play the Pahlavi dinasty civ with Vox Populi you can copy and paste the following chunk in the Uighur_Caesar's Iran Pahlavi Dynasty (v 1)\Support\Support.sql file
It adapts the xml code of the UB and UU to the changes of VP mod.
Note: I changed the class of the Literacy corp to paratrooper as in VP it unlocks at flight and upgrades into marines.
Code:--========================================================================================================================== -- Gazebo's Community Balance Patch (Vox Populi) --========================================================================================================================== -- COMMUNITY ------------------------------------------------------------ CREATE TABLE IF NOT EXISTS COMMUNITY (Type TEXT, Value INTEGER); ------------------------------ -- Building ------------------------------ UPDATE Buildings SET Cost = '500' WHERE Type = 'BUILDING_UC_SAVAK' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_BUILDINGS' AND Value= 1 ); UPDATE Buildings SET GoldMaintenance = '4' WHERE Type = 'BUILDING_UC_SAVAK' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_BUILDINGS' AND Value= 1 ); UPDATE Buildings SET EspionageModifier = '-25' WHERE Type = 'BUILDING_UC_SAVAK' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_BUILDINGS' AND Value= 1 ); UPDATE Buildings SET BlockBuildingDestructionSpies = '1' WHERE Type = 'BUILDING_UC_SAVAK' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_BUILDINGS' AND Value= 1 ); UPDATE Buildings SET Defense = '500' WHERE Type = 'BUILDING_UC_SAVAK' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_BUILDINGS' AND Value= 1 ); ------------------------------ -- Units ------------------------------ UPDATE Units SET Combat = '37' WHERE Type = 'UNIT_UC_LITERACY_CORPS' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_UNITS' AND Value= 1 ); UPDATE Units SET BaseLandAirDefense = '8' WHERE Type = 'UNIT_UC_LITERACY_CORPS' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_UNITS' AND Value= 1 ); UPDATE Units SET Cost = '1259' WHERE Type = 'UNIT_UC_LITERACY_CORPS' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_UNITS' AND Value= 1 ); UPDATE Units SET FaithCost = '650' WHERE Type = 'UNIT_UC_LITERACY_CORPS' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_UNITS' AND Value= 1 ); UPDATE Units SET Combat = '37' WHERE Type = 'UNIT_UC_ACADEMY_CORPS' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_UNITS' AND Value= 1 ); UPDATE Units SET BaseLandAirDefense = '8' WHERE Type = 'UNIT_UC_ACADEMY_CORPS' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_UNITS' AND Value= 1 ); UPDATE Units SET Class = 'UNITCLASS_PARATROOPER' WHERE Type = 'UNIT_UC_LITERACY_CORPS' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_UNITS' AND Value= 1 ); UPDATE Units SET ObsoleteTech = 'TECH_MOBILE_TACTICS' WHERE Type = 'UNIT_UC_LITERACY_CORPS' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_UNITS' AND Value= 1 ); UPDATE Civilization_UnitClassOverrides SET UnitClassType = 'UNITCLASS_PARATROOPER' WHERE UnitType = 'UNIT_UC_LITERACY_CORPS' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_UNITS' AND Value= 1 ); UPDATE Language_en_US SET Text = 'Pahlavi replacement for the Paratrooper, but comes much earlier at Scientific Theory and has adjusted [ICON_STRENGTH] Strength and Cost. When garrisoned, gains XP from building [ICON_FOOD] Food and [ICON_RESEARCH] Science buildings, and they are built faster. Provides [ICON_GREAT_PEOPLE] Great Scientist Points in the [ICON_CAPITAL] Capital when upgrading.' WHERE Tag = 'TXT_KEY_UNIT_UC_LITERACY_CORPS_HELP' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_UNITS' AND Value= 1 ); UPDATE Language_en_US SET Text = 'Pahlavi replacement for the Paratrooper, but comes much earlier at Scientific Theory and has adjusted [ICON_STRENGTH] Strength and Cost. When garrisoned, gains XP from building [ICON_FOOD] Food and [ICON_RESEARCH] Science buildings, and they are built faster. Provides [ICON_GREAT_PEOPLE] Great Scientist Points in the [ICON_CAPITAL] Capital when upgrading.' WHERE Tag = 'TXT_KEY_UNIT_UC_LITERACY_CORPS_STRATEGY' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_UNITS' AND Value= 1 );
I notice that you worked on Vermont. Does it have TSL for YaEmp v25? It does not appear in the menu.
And updated, to fix the fact that I forgot to Resource-condition the CanStartMission and consequently stopped the Player from being able to dig Archaeological Sites outside their borders.