More help with smoother difficulty

[Gaurav]

Hi, all, and thanks in advance.

I cannot play at high difficulties (king or above) because I just get wiped out in the ancient era. I'm probably just not that good at knowing all the details of the game, aren't aggressive enough, or whatever. I get wiped out by barbarians and/or the ai. Fine, I'll just play at prince level. Except then I survive the ancient era and by mid to late game, I'm way too far ahead of the ai!

I looked into smoother difficulty 2.0 mod because I wanted the ai to get science / culture bonuses per era so that they can keep up and make that part of the game more interesting.

But it looks like the mod only applies to high difficulties. Staring at this code:

Spoiler EraScaling.sql :

-- First set science&culture flat from 8 -> 12
UPDATE ModifierArguments SET Extra=12 WHERE ModifierId="HIGH_DIFFICULTY_SCIENCE_SCALING" AND Name="Amount";
UPDATE ModifierArguments SET Extra=12 WHERE ModifierId="HIGH_DIFFICULTY_CULTURE_SCALING" AND Name="Amount";

-- [schwarzpol] NEW: Base tourism modifier of 20% per difficulty. Also added era scaling of 5% per difficulty and era.
INSERT INTO TraitModifiers (TraitType, ModifierId) VALUES
('TRAIT_LEADER_MAJOR_CIV', 'HIGH_DIFFICULTY_TOURISM_SCALING');

INSERT INTO Modifiers (ModifierId, ModifierType, OwnerRequirementSetId) VALUES
('HIGH_DIFFICULTY_TOURISM_SCALING', 'MODIFIER_PLAYER_ADJUST_TOURISM', 'PLAYER_IS_HIGH_DIFFICULTY_AI');

INSERT INTO ModifierArguments (ModifierId, Name, Type, Value, Extra) VALUES
('HIGH_DIFFICULTY_TOURISM_SCALING', 'Amount', 'LinearScaleFromDefaultHandicap', 0, 20);

-- NEW: AI gets bonus science&culture
-- +1 per difficulty starts at classical, deity gets +35% at info era
INSERT INTO TraitModifiers (TraitType, ModifierId) VALUES
('TRAIT_LEADER_MAJOR_CIV', 'TOURISM_SCALING_CLASSICAL'),
('TRAIT_LEADER_MAJOR_CIV', 'TOURISM_SCALING_MEDIEVAL'),
('TRAIT_LEADER_MAJOR_CIV', 'TOURISM_SCALING_RENAISSANCE'),
('TRAIT_LEADER_MAJOR_CIV', 'TOURISM_SCALING_INDUSTRIAL'),
('TRAIT_LEADER_MAJOR_CIV', 'TOURISM_SCALING_MODERN'),
('TRAIT_LEADER_MAJOR_CIV', 'TOURISM_SCALING_ATOMIC'),
('TRAIT_LEADER_MAJOR_CIV', 'TOURISM_SCALING_INFO'),
('TRAIT_LEADER_MAJOR_CIV', 'TOURISM_SCALING_FUTURE'),
('TRAIT_LEADER_MAJOR_CIV', 'SCIENCE_SCALING_CLASSICAL'),
('TRAIT_LEADER_MAJOR_CIV', 'SCIENCE_SCALING_MEDIEVAL'),
('TRAIT_LEADER_MAJOR_CIV', 'SCIENCE_SCALING_RENAISSANCE'),
('TRAIT_LEADER_MAJOR_CIV', 'SCIENCE_SCALING_INDUSTRIAL'),
('TRAIT_LEADER_MAJOR_CIV', 'SCIENCE_SCALING_MODERN'),
('TRAIT_LEADER_MAJOR_CIV', 'SCIENCE_SCALING_ATOMIC'),
('TRAIT_LEADER_MAJOR_CIV', 'SCIENCE_SCALING_INFO'),
('TRAIT_LEADER_MAJOR_CIV', 'SCIENCE_SCALING_FUTURE'),
('TRAIT_LEADER_MAJOR_CIV', 'CULTURE_SCALING_CLASSICAL'),
('TRAIT_LEADER_MAJOR_CIV', 'CULTURE_SCALING_MEDIEVAL'),
('TRAIT_LEADER_MAJOR_CIV', 'CULTURE_SCALING_RENAISSANCE'),
('TRAIT_LEADER_MAJOR_CIV', 'CULTURE_SCALING_INDUSTRIAL'),
('TRAIT_LEADER_MAJOR_CIV', 'CULTURE_SCALING_MODERN'),
('TRAIT_LEADER_MAJOR_CIV', 'CULTURE_SCALING_ATOMIC'),
('TRAIT_LEADER_MAJOR_CIV', 'CULTURE_SCALING_INFO'),
('TRAIT_LEADER_MAJOR_CIV', 'CULTURE_SCALING_FUTURE');

INSERT INTO Modifiers (ModifierId, ModifierType, OwnerRequirementSetId) VALUES
('TOURISM_SCALING_CLASSICAL', 'MODIFIER_PLAYER_ADJUST_TOURISM', 'HIGH_DIFFICULTY_AI_CLASSICAL'),
('TOURISM_SCALING_MEDIEVAL', 'MODIFIER_PLAYER_ADJUST_TOURISM', 'HIGH_DIFFICULTY_AI_MEDIEVAL'),
('TOURISM_SCALING_RENAISSANCE', 'MODIFIER_PLAYER_ADJUST_TOURISM', 'HIGH_DIFFICULTY_AI_RENAISSANCE'),
('TOURISM_SCALING_INDUSTRIAL', 'MODIFIER_PLAYER_ADJUST_TOURISM', 'HIGH_DIFFICULTY_AI_INDUSTRIAL'),
('TOURISM_SCALING_MODERN', 'MODIFIER_PLAYER_ADJUST_TOURISM', 'HIGH_DIFFICULTY_AI_MODERN'),
('TOURISM_SCALING_ATOMIC', 'MODIFIER_PLAYER_ADJUST_TOURISM', 'HIGH_DIFFICULTY_AI_ATOMIC'),
('TOURISM_SCALING_INFO', 'MODIFIER_PLAYER_ADJUST_TOURISM', 'HIGH_DIFFICULTY_AI_INFO'),
('TOURISM_SCALING_FUTURE', 'MODIFIER_PLAYER_ADJUST_TOURISM', 'HIGH_DIFFICULTY_AI_FUTURE'),
('SCIENCE_SCALING_CLASSICAL', 'MODIFIER_PLAYER_CITIES_ADJUST_CITY_YIELD_MODIFIER', 'HIGH_DIFFICULTY_AI_CLASSICAL'),
('SCIENCE_SCALING_MEDIEVAL', 'MODIFIER_PLAYER_CITIES_ADJUST_CITY_YIELD_MODIFIER', 'HIGH_DIFFICULTY_AI_MEDIEVAL'),
('SCIENCE_SCALING_RENAISSANCE', 'MODIFIER_PLAYER_CITIES_ADJUST_CITY_YIELD_MODIFIER', 'HIGH_DIFFICULTY_AI_RENAISSANCE'),
('SCIENCE_SCALING_INDUSTRIAL', 'MODIFIER_PLAYER_CITIES_ADJUST_CITY_YIELD_MODIFIER', 'HIGH_DIFFICULTY_AI_INDUSTRIAL'),
('SCIENCE_SCALING_MODERN', 'MODIFIER_PLAYER_CITIES_ADJUST_CITY_YIELD_MODIFIER', 'HIGH_DIFFICULTY_AI_MODERN'),
('SCIENCE_SCALING_ATOMIC', 'MODIFIER_PLAYER_CITIES_ADJUST_CITY_YIELD_MODIFIER', 'HIGH_DIFFICULTY_AI_ATOMIC'),
('SCIENCE_SCALING_INFO', 'MODIFIER_PLAYER_CITIES_ADJUST_CITY_YIELD_MODIFIER', 'HIGH_DIFFICULTY_AI_INFO'),
('SCIENCE_SCALING_FUTURE', 'MODIFIER_PLAYER_CITIES_ADJUST_CITY_YIELD_MODIFIER', 'HIGH_DIFFICULTY_AI_FUTURE'),
('CULTURE_SCALING_CLASSICAL', 'MODIFIER_PLAYER_CITIES_ADJUST_CITY_YIELD_MODIFIER', 'HIGH_DIFFICULTY_AI_CLASSICAL'),
('CULTURE_SCALING_MEDIEVAL', 'MODIFIER_PLAYER_CITIES_ADJUST_CITY_YIELD_MODIFIER', 'HIGH_DIFFICULTY_AI_MEDIEVAL'),
('CULTURE_SCALING_RENAISSANCE', 'MODIFIER_PLAYER_CITIES_ADJUST_CITY_YIELD_MODIFIER', 'HIGH_DIFFICULTY_AI_RENAISSANCE'),
('CULTURE_SCALING_INDUSTRIAL', 'MODIFIER_PLAYER_CITIES_ADJUST_CITY_YIELD_MODIFIER', 'HIGH_DIFFICULTY_AI_INDUSTRIAL'),
('CULTURE_SCALING_MODERN', 'MODIFIER_PLAYER_CITIES_ADJUST_CITY_YIELD_MODIFIER', 'HIGH_DIFFICULTY_AI_MODERN'),
('CULTURE_SCALING_ATOMIC', 'MODIFIER_PLAYER_CITIES_ADJUST_CITY_YIELD_MODIFIER', 'HIGH_DIFFICULTY_AI_ATOMIC'),
('CULTURE_SCALING_INFO', 'MODIFIER_PLAYER_CITIES_ADJUST_CITY_YIELD_MODIFIER', 'HIGH_DIFFICULTY_AI_INFO'),
('CULTURE_SCALING_FUTURE', 'MODIFIER_PLAYER_CITIES_ADJUST_CITY_YIELD_MODIFIER', 'HIGH_DIFFICULTY_AI_FUTURE');

INSERT INTO ModifierArguments (ModifierId, Name, Value) VALUES
('SCIENCE_SCALING_CLASSICAL', 'YieldType', 'YIELD_SCIENCE'),
('SCIENCE_SCALING_MEDIEVAL', 'YieldType', 'YIELD_SCIENCE'),
('SCIENCE_SCALING_RENAISSANCE', 'YieldType', 'YIELD_SCIENCE'),
('SCIENCE_SCALING_INDUSTRIAL', 'YieldType', 'YIELD_SCIENCE'),
('SCIENCE_SCALING_MODERN', 'YieldType', 'YIELD_SCIENCE'),
('SCIENCE_SCALING_ATOMIC', 'YieldType', 'YIELD_SCIENCE'),
('SCIENCE_SCALING_INFO', 'YieldType', 'YIELD_SCIENCE'),
('SCIENCE_SCALING_FUTURE', 'YieldType', 'YIELD_SCIENCE'),
('CULTURE_SCALING_CLASSICAL', 'YieldType', 'YIELD_CULTURE'),
('CULTURE_SCALING_MEDIEVAL', 'YieldType', 'YIELD_CULTURE'),
('CULTURE_SCALING_RENAISSANCE', 'YieldType', 'YIELD_CULTURE'),
('CULTURE_SCALING_INDUSTRIAL', 'YieldType', 'YIELD_CULTURE'),
('CULTURE_SCALING_MODERN', 'YieldType', 'YIELD_CULTURE'),
('CULTURE_SCALING_ATOMIC', 'YieldType', 'YIELD_CULTURE'),
('CULTURE_SCALING_INFO', 'YieldType', 'YIELD_CULTURE'),
('CULTURE_SCALING_FUTURE', 'YieldType', 'YIELD_CULTURE');

INSERT INTO ModifierArguments (ModifierId, Name, Type, Value, Extra) VALUES
('TOURISM_SCALING_CLASSICAL', 'Amount', 'LinearScaleFromDefaultHandicap', 0, 5),
('TOURISM_SCALING_MEDIEVAL', 'Amount', 'LinearScaleFromDefaultHandicap', 0, 5),
('TOURISM_SCALING_RENAISSANCE', 'Amount', 'LinearScaleFromDefaultHandicap', 0, 5),
('TOURISM_SCALING_INDUSTRIAL', 'Amount', 'LinearScaleFromDefaultHandicap', 0, 5),
('TOURISM_SCALING_MODERN', 'Amount', 'LinearScaleFromDefaultHandicap', 0, 5),
('TOURISM_SCALING_ATOMIC', 'Amount', 'LinearScaleFromDefaultHandicap', 0, 5),
('TOURISM_SCALING_INFO', 'Amount', 'LinearScaleFromDefaultHandicap', 0, 5),
('TOURISM_SCALING_FUTURE', 'Amount', 'LinearScaleFromDefaultHandicap', 0, 5),
('SCIENCE_SCALING_CLASSICAL', 'Amount', 'LinearScaleFromDefaultHandicap', 0, 1),
('SCIENCE_SCALING_MEDIEVAL', 'Amount', 'LinearScaleFromDefaultHandicap', 0, 1),
('SCIENCE_SCALING_RENAISSANCE', 'Amount', 'LinearScaleFromDefaultHandicap', 0, 1),
('SCIENCE_SCALING_INDUSTRIAL', 'Amount', 'LinearScaleFromDefaultHandicap', 0, 1),
('SCIENCE_SCALING_MODERN', 'Amount', 'LinearScaleFromDefaultHandicap', 0, 1),
('SCIENCE_SCALING_ATOMIC', 'Amount', 'LinearScaleFromDefaultHandicap', 0, 1),
('SCIENCE_SCALING_INFO', 'Amount', 'LinearScaleFromDefaultHandicap', 0, 1),
('SCIENCE_SCALING_FUTURE', 'Amount', 'LinearScaleFromDefaultHandicap', 0, 1),
('CULTURE_SCALING_CLASSICAL', 'Amount', 'LinearScaleFromDefaultHandicap', 0, 1),
('CULTURE_SCALING_MEDIEVAL', 'Amount', 'LinearScaleFromDefaultHandicap', 0, 1),
('CULTURE_SCALING_RENAISSANCE', 'Amount', 'LinearScaleFromDefaultHandicap', 0, 1),
('CULTURE_SCALING_INDUSTRIAL', 'Amount', 'LinearScaleFromDefaultHandicap', 0, 1),
('CULTURE_SCALING_MODERN', 'Amount', 'LinearScaleFromDefaultHandicap', 0, 1),
('CULTURE_SCALING_ATOMIC', 'Amount', 'LinearScaleFromDefaultHandicap', 0, 1),
('CULTURE_SCALING_INFO', 'Amount', 'LinearScaleFromDefaultHandicap', 0, 1),
('CULTURE_SCALING_FUTURE', 'Amount', 'LinearScaleFromDefaultHandicap', 0, 1);

INSERT INTO RequirementSets (RequirementSetId, RequirementSetType) VALUES
('HIGH_DIFFICULTY_AI_CLASSICAL', 'REQUIREMENTSET_TEST_ALL'),
('HIGH_DIFFICULTY_AI_MEDIEVAL', 'REQUIREMENTSET_TEST_ALL'),
('HIGH_DIFFICULTY_AI_RENAISSANCE', 'REQUIREMENTSET_TEST_ALL'),
('HIGH_DIFFICULTY_AI_INDUSTRIAL', 'REQUIREMENTSET_TEST_ALL'),
('HIGH_DIFFICULTY_AI_MODERN', 'REQUIREMENTSET_TEST_ALL'),
('HIGH_DIFFICULTY_AI_ATOMIC', 'REQUIREMENTSET_TEST_ALL'),
('HIGH_DIFFICULTY_AI_INFO', 'REQUIREMENTSET_TEST_ALL'),
('HIGH_DIFFICULTY_AI_FUTURE', 'REQUIREMENTSET_TEST_ALL');

INSERT INTO RequirementSetRequirements (RequirementSetId, RequirementId) VALUES
('HIGH_DIFFICULTY_AI_CLASSICAL', 'REQUIRES_PLAYER_IS_AI'),
('HIGH_DIFFICULTY_AI_MEDIEVAL', 'REQUIRES_PLAYER_IS_AI'),
('HIGH_DIFFICULTY_AI_RENAISSANCE', 'REQUIRES_PLAYER_IS_AI'),
('HIGH_DIFFICULTY_AI_INDUSTRIAL', 'REQUIRES_PLAYER_IS_AI'),
('HIGH_DIFFICULTY_AI_MODERN', 'REQUIRES_PLAYER_IS_AI'),
('HIGH_DIFFICULTY_AI_ATOMIC', 'REQUIRES_PLAYER_IS_AI'),
('HIGH_DIFFICULTY_AI_INFO', 'REQUIRES_PLAYER_IS_AI'),
('HIGH_DIFFICULTY_AI_FUTURE', 'REQUIRES_PLAYER_IS_AI'),
('HIGH_DIFFICULTY_AI_CLASSICAL', 'REQUIRES_HIGH_DIFFICULTY'),
('HIGH_DIFFICULTY_AI_MEDIEVAL', 'REQUIRES_HIGH_DIFFICULTY'),
('HIGH_DIFFICULTY_AI_RENAISSANCE', 'REQUIRES_HIGH_DIFFICULTY'),
('HIGH_DIFFICULTY_AI_INDUSTRIAL', 'REQUIRES_HIGH_DIFFICULTY'),
('HIGH_DIFFICULTY_AI_MODERN', 'REQUIRES_HIGH_DIFFICULTY'),
('HIGH_DIFFICULTY_AI_ATOMIC', 'REQUIRES_HIGH_DIFFICULTY'),
('HIGH_DIFFICULTY_AI_INFO', 'REQUIRES_HIGH_DIFFICULTY'),
('HIGH_DIFFICULTY_AI_FUTURE', 'REQUIRES_HIGH_DIFFICULTY'),
('HIGH_DIFFICULTY_AI_CLASSICAL', 'PLAYER_AT_CLASSICAL_ERA'),
('HIGH_DIFFICULTY_AI_MEDIEVAL', 'PLAYER_AT_MEDIEVAL_ERA'),
('HIGH_DIFFICULTY_AI_RENAISSANCE', 'PLAYER_AT_RENAISSANCE_ERA'),
('HIGH_DIFFICULTY_AI_INDUSTRIAL', 'PLAYER_AT_INDUSTRIAL_ERA'),
('HIGH_DIFFICULTY_AI_MODERN', 'PLAYER_AT_MODERN_ERA'),
('HIGH_DIFFICULTY_AI_ATOMIC', 'PLAYER_AT_ATOMIC_ERA'),
('HIGH_DIFFICULTY_AI_INFO', 'PLAYER_AT_INFO_ERA'),
('HIGH_DIFFICULTY_AI_FUTURE', 'PLAYER_AT_FUTURE_ERA');

I want to give the AI players a flat bonus per era at low difficulties, settler through prince, say 5% per era, but 0 for ancient era, to science and culture only. How do I change this mod?