[R&F] Trying to Change Pax Britannica

[Legacy of Smiles]

Hi, completely new to modding and a bit (a lot) stuck as none of my code works. The below code is my attempt to do two things: remove the PB restriction that means only settled cities get the boost and remove the free unit from building a RND. Any help or advice would be appreciated. Thanks!

DELETE FROM RequirementsSetRequirements (RequirementSetId, RequirementId) VALUES ('CITY_FOUNDED_ON_NON_HOME_CONTINENT_REQUIREMENTS', 'CITY_FOUNDED_BY_SETTLER_REQUIREMENT') ;

DELETE FROM TraitModifiers (TraitType, ModifierId) VALUES (TRAIT_LEADER_PAX_BRITANNICA, TRAIT_FREE_MELEE_UNIT_FOREIGN_ROYAL_NAVY_DOCKYARD)

 

[Laurana Kanan]

You're missing single quotes and a semi-colon in the second statement. Also, your syntax isn't correct. Try

DELETE FROM RequirementsSetRequirements
WHERE       RequirementSetId = 'CITY_FOUNDED_ON_NON_HOME_CONTINENT_REQUIREMENTS' AND
            RequirementId = 'CITY_FOUNDED_BY_SETTLER_REQUIREMENT';

DELETE FROM TraitModifiers
WHERE       TraitType = 'TRAIT_LEADER_PAX_BRITANNICA' AND
            ModifierId = 'TRAIT_FREE_MELEE_UNIT_FOREIGN_ROYAL_NAVY_DOCKYARD';

 

[Legacy of Smiles]

You're missing single quotes and a semi-colon in the second statement. Also, your syntax isn't correct. Try

DELETE FROM RequirementsSetRequirements
WHERE       RequirementSetId = 'CITY_FOUNDED_ON_NON_HOME_CONTINENT_REQUIREMENTS' AND
            RequirementId = 'CITY_FOUNDED_BY_SETTLER_REQUIREMENT';

DELETE FROM TraitModifiers
WHERE       TraitType = 'TRAIT_LEADER_PAX_BRITANNICA' AND
            ModifierId = 'TRAIT_FREE_MELEE_UNIT_FOREIGN_ROYAL_NAVY_DOCKYARD';

Thanks, I wrote it from guesswork (using Python knowledge and recycled code) mainly and you can tell I had no idea.