cyberhawk94
Chieftain
- Joined
- May 15, 2020
- Messages
- 9
I am making a small re-balancing mod for my own use, and to be fair I have no idea what I am doing. I am basing it heavily on the format and syntax used by an existing mod, and simply adding additional effects. As far as I can tell everything is the same, but the mod doesn't seem to work.
Below is the .modinfo file, all the changes in the Russia and Canada files work perfectly (the original mod), none of the changes in the "Simple" file apply at all, and there are no visible errors in the Modding log
<FrontEndActions>
<UpdateDatabase id="Config">
<Properties>
<LoadOrder>13</LoadOrder>
</Properties>
<File>TCR_Config.sql</File>
</UpdateDatabase>
<UpdateText id="Text">
<Properties>
<LoadOrder>13</LoadOrder>
</Properties>
<File>TCR_Text.sql</File>
</UpdateText>
</FrontEndActions>
<InGameActions>
<UpdateText id="Text">
<Properties>
<LoadOrder>13</LoadOrder>
</Properties>
<File>TCR_Text.sql</File>
</UpdateText>
<UpdateDatabase id="Database">
<Properties>
<LoadOrder>13</LoadOrder>
</Properties>
<File>TCR_Canada.sql</File>
<File>TCR_Russia.sql</File>
<File>TCR_Simple.sql</File>
</UpdateDatabase>
</InGameActions>
<Files>
<File>TCR_Canada.sql</File>
<File>TCR_Config.sql</File>
<File>TCR_Russia.sql</File>
<File>TCR_Simple.sql</File>
<File>TCR_Text.sql</File>
</Files>
</Mod>
TCR_Simple.sql
-- Traits
--------------------------------------------------------------
UPDATE Traits SET Description='LOC_TRAIT_CIVILIZATION_MAORI_MANA_DESCRIPTION_CYB' WHERE TraitType='TRAIT_CIVILIZATION_MAORI_MANA';
UPDATE Traits SET Description='LOC_TRAIT_CIVILIZATION_MEDITERRANEAN_COLONIES_DESCRIPTION_CYB' WHERE TraitType='TRAIT_CIVILIZATION_MEDITERRANEAN_COLONIES';
UPDATE Traits SET Description='LOC_TRAIT_CIVILIZATION_INDUSTRIAL_REVOLUTION_DESCRIPTION_CYB' WHERE TraitType='TRAIT_CIVILIZATION_INDUSTRIAL_REVOLUTION';
UPDATE Traits SET Description='LOC_TRAIT_LEADER_DIVINE_WIND_DESCRIPTION_CYB' WHERE TraitType='TRAIT_LEADER_DIVINE_WIND';
--------------------------------------------------------------
-- TraitModifiers
--------------------------------------------------------------
DELETE FROM TraitModifiers WHERE ModifierId='TRAIT_MAORI_FISHING_BOAT_FOOD';
DELETE FROM TraitModifiers WHERE ModifierId='TRAIT_FREE_TECH_BOOST_WRITING';
DELETE FROM TraitModifiers WHERE ModifierId='TRAIT_ADJUST_MILITARY_ENGINEER_PRODUCTION';
DELETE FROM TraitModifiers WHERE ModifierId='TRAIT_ADJUST_MILITARY_ENGINEER_BUILDCHARGES';
INSERT OR REPLACE INTO TraitModifiers
(ModifierId, TraitType)
SELECT 'TRAIT_CYB_ENGLISH_ZONES', TraitType FROM Traits WHERE TraitType='TRAIT_CIVILIZATION_INDUSTRIAL_REVOLUTION';
--------------------------------------------------------------
-- Modifiers
--------------------------------------------------------------
INSERT OR REPLACE INTO Modifiers
(ModifierId, ModifierType)
VALUES ('TRAIT_CYB_ENGLISH_ZONES', 'MODIFIER_PLAYER_CITIES_ADJUST_DISTRICT_PRODUCTION');
--------------------------------------------------------------
-- ModifierArguments
--------------------------------------------------------------
INSERT OR REPLACE INTO ModifierArguments
(ModifierId, Name, Value)
VALUES ('TRAIT_BOOST_HOLY_SITE_PRODUCTION', 'DistrictType', 'DISTRICT_HOLY_SITE'),
('TRAIT_BOOST_HOLY_SITE_PRODUCTION', 'Amount', 50),
('TRAIT_BOOST_THEATER_DISTRICT_PRODUCTION', 'DistrictType', 'DISTRICT_THEATER'),
('TRAIT_BOOST_THEATER_DISTRICT_PRODUCTION', 'Amount', 50),
('TRAIT_BOOST_ENCAMPMENT_PRODUCTION', 'DistrictType', 'DISTRICT_ENCAMPMENT'),
('TRAIT_BOOST_ENCAMPMENT_PRODUCTION', 'Amount', 50),
('TRAIT_MAORI_PRODUCTION_WOODS_CONSERVATION', 'YieldType', 'YIELD_PRODUCTION'),
('TRAIT_MAORI_PRODUCTION_WOODS_CONSERVATION', 'Amount', 1),
('TRAIT_MAORI_PRODUCTION_RAINFOREST_CONSERVATION', 'YieldType', 'YIELD_PRODUCTION'),
('TRAIT_MAORI_PRODUCTION_RAINFOREST_CONSERVATION', 'Amount', 1),
('TRAIT_CYB_ENGLISH_ZONES', 'DistrictType', 'DISTRICT_INDUSTRIAL_ZONE'),
('TRAIT_CYB_ENGLISH_ZONES', 'Amount', 20);
--------------------------------------------------------------
Below is the .modinfo file, all the changes in the Russia and Canada files work perfectly (the original mod), none of the changes in the "Simple" file apply at all, and there are no visible errors in the Modding log
<FrontEndActions>
<UpdateDatabase id="Config">
<Properties>
<LoadOrder>13</LoadOrder>
</Properties>
<File>TCR_Config.sql</File>
</UpdateDatabase>
<UpdateText id="Text">
<Properties>
<LoadOrder>13</LoadOrder>
</Properties>
<File>TCR_Text.sql</File>
</UpdateText>
</FrontEndActions>
<InGameActions>
<UpdateText id="Text">
<Properties>
<LoadOrder>13</LoadOrder>
</Properties>
<File>TCR_Text.sql</File>
</UpdateText>
<UpdateDatabase id="Database">
<Properties>
<LoadOrder>13</LoadOrder>
</Properties>
<File>TCR_Canada.sql</File>
<File>TCR_Russia.sql</File>
<File>TCR_Simple.sql</File>
</UpdateDatabase>
</InGameActions>
<Files>
<File>TCR_Canada.sql</File>
<File>TCR_Config.sql</File>
<File>TCR_Russia.sql</File>
<File>TCR_Simple.sql</File>
<File>TCR_Text.sql</File>
</Files>
</Mod>
TCR_Simple.sql
-- Traits
--------------------------------------------------------------
UPDATE Traits SET Description='LOC_TRAIT_CIVILIZATION_MAORI_MANA_DESCRIPTION_CYB' WHERE TraitType='TRAIT_CIVILIZATION_MAORI_MANA';
UPDATE Traits SET Description='LOC_TRAIT_CIVILIZATION_MEDITERRANEAN_COLONIES_DESCRIPTION_CYB' WHERE TraitType='TRAIT_CIVILIZATION_MEDITERRANEAN_COLONIES';
UPDATE Traits SET Description='LOC_TRAIT_CIVILIZATION_INDUSTRIAL_REVOLUTION_DESCRIPTION_CYB' WHERE TraitType='TRAIT_CIVILIZATION_INDUSTRIAL_REVOLUTION';
UPDATE Traits SET Description='LOC_TRAIT_LEADER_DIVINE_WIND_DESCRIPTION_CYB' WHERE TraitType='TRAIT_LEADER_DIVINE_WIND';
--------------------------------------------------------------
-- TraitModifiers
--------------------------------------------------------------
DELETE FROM TraitModifiers WHERE ModifierId='TRAIT_MAORI_FISHING_BOAT_FOOD';
DELETE FROM TraitModifiers WHERE ModifierId='TRAIT_FREE_TECH_BOOST_WRITING';
DELETE FROM TraitModifiers WHERE ModifierId='TRAIT_ADJUST_MILITARY_ENGINEER_PRODUCTION';
DELETE FROM TraitModifiers WHERE ModifierId='TRAIT_ADJUST_MILITARY_ENGINEER_BUILDCHARGES';
INSERT OR REPLACE INTO TraitModifiers
(ModifierId, TraitType)
SELECT 'TRAIT_CYB_ENGLISH_ZONES', TraitType FROM Traits WHERE TraitType='TRAIT_CIVILIZATION_INDUSTRIAL_REVOLUTION';
--------------------------------------------------------------
-- Modifiers
--------------------------------------------------------------
INSERT OR REPLACE INTO Modifiers
(ModifierId, ModifierType)
VALUES ('TRAIT_CYB_ENGLISH_ZONES', 'MODIFIER_PLAYER_CITIES_ADJUST_DISTRICT_PRODUCTION');
--------------------------------------------------------------
-- ModifierArguments
--------------------------------------------------------------
INSERT OR REPLACE INTO ModifierArguments
(ModifierId, Name, Value)
VALUES ('TRAIT_BOOST_HOLY_SITE_PRODUCTION', 'DistrictType', 'DISTRICT_HOLY_SITE'),
('TRAIT_BOOST_HOLY_SITE_PRODUCTION', 'Amount', 50),
('TRAIT_BOOST_THEATER_DISTRICT_PRODUCTION', 'DistrictType', 'DISTRICT_THEATER'),
('TRAIT_BOOST_THEATER_DISTRICT_PRODUCTION', 'Amount', 50),
('TRAIT_BOOST_ENCAMPMENT_PRODUCTION', 'DistrictType', 'DISTRICT_ENCAMPMENT'),
('TRAIT_BOOST_ENCAMPMENT_PRODUCTION', 'Amount', 50),
('TRAIT_MAORI_PRODUCTION_WOODS_CONSERVATION', 'YieldType', 'YIELD_PRODUCTION'),
('TRAIT_MAORI_PRODUCTION_WOODS_CONSERVATION', 'Amount', 1),
('TRAIT_MAORI_PRODUCTION_RAINFOREST_CONSERVATION', 'YieldType', 'YIELD_PRODUCTION'),
('TRAIT_MAORI_PRODUCTION_RAINFOREST_CONSERVATION', 'Amount', 1),
('TRAIT_CYB_ENGLISH_ZONES', 'DistrictType', 'DISTRICT_INDUSTRIAL_ZONE'),
('TRAIT_CYB_ENGLISH_ZONES', 'Amount', 20);
--------------------------------------------------------------