Sid Meier's Civilization VI

Sid Meier's Civilization VI

EnigmaConundrum's Comanche [GS]
Madisonian 11 May, 2024 @ 6:00am
Here's the fix for Gathering Storm:
The Comanche doesn't properly show up in the civ selection list with Gathering Storm since the civ was released prior to the expansion; to fix that, locate the ComancheConfig.sql file in the mod folder and copy the code below over the original code.

Reload the game and the Comanche will be available for Standard, R&F, and GS rulesets.

Tested and works as of May 2024.

PS: My previously mentioned fix of changing all Players:Expansion1_Players to Players:Expansion2_Players also works but is a lazy method that changes availability from R&F only to GS only; the code below makes it available in all rulesets should you need it.


The ComancheConfig.sql should look like this:
--=============================================== -- CONFIG DATA --=============================================== -- Players ------------------------------------------------------------------------ INSERT INTO Players (Domain, CivilizationType, Portrait, PortraitBackground, LeaderType, LeaderName, LeaderIcon, LeaderAbilityName, LeaderAbilityDescription, LeaderAbilityIcon, CivilizationName, CivilizationIcon, CivilizationAbilityName, CivilizationAbilityDescription, CivilizationAbilityIcon) VALUES ('Players:StandardPlayers', 'CIVILIZATION_ENIGMA_COMANCHE', 'LEADER_ENIGMA_POTSUNAKWAHIPU_NEUTRAL.dds', 'LEADER_GORGO_BACKGROUND', 'LEADER_ENIGMA_POTSUNAKWAHIPU', 'LOC_LEADER_ENIGMA_POTSUNAKWAHIPU_NAME', 'ICON_LEADER_ENIGMA_POTSUNAKWAHIPU', 'LOC_TRAIT_LEADER_ENIGMA_GREAT_RAID_NAME', 'LOC_TRAIT_LEADER_ENIGMA_GREAT_RAID_DESCRIPTION', 'ICON_LEADER_ENIGMA_POTSUNAKWAHIPU', 'LOC_CIVILIZATION_ENIGMA_COMANCHE_NAME', 'ICON_CIVILIZATION_ENIGMA_COMANCHE', 'LOC_TRAIT_CIVILIZATION_ENIGMA_COMANCHE_MOON_NAME', 'LOC_TRAIT_CIVILIZATION_ENIGMA_COMANCHE_MOON_DESCRIPTION', 'ICON_CIVILIZATION_ENIGMA_COMANCHE'); INSERT INTO Players (Domain, CivilizationType, Portrait, PortraitBackground, LeaderType, LeaderName, LeaderIcon, LeaderAbilityName, LeaderAbilityDescription, LeaderAbilityIcon, CivilizationName, CivilizationIcon, CivilizationAbilityName, CivilizationAbilityDescription, CivilizationAbilityIcon) VALUES ('Players:StandardPlayers', 'CIVILIZATION_ENIGMA_COMANCHE', 'LEADER_ENIGMA_QUANAH_NEUTRAL.dds', 'LEADER_VICTORIA_BACKGROUND', 'LEADER_ENIGMA_QUANAH', 'LOC_LEADER_ENIGMA_QUANAH_NAME', 'ICON_LEADER_ENIGMA_QUANAH', 'LOC_TRAIT_LEADER_ENIGMA_HALF_MOON_CHURCH_NAME', 'LOC_TRAIT_LEADER_ENIGMA_HALF_MOON_CHURCH_DESCRIPTION', 'ICON_LEADER_ENIGMA_QUANAH', 'LOC_CIVILIZATION_ENIGMA_COMANCHE_NAME', 'ICON_CIVILIZATION_ENIGMA_QUANAH_COMANCHE', 'LOC_TRAIT_CIVILIZATION_ENIGMA_COMANCHE_MOON_NAME', 'LOC_TRAIT_CIVILIZATION_ENIGMA_COMANCHE_MOON_DESCRIPTION', 'ICON_CIVILIZATION_ENIGMA_QUANAH_COMANCHE'); ------------------------------------------------------------------------ -- PlayerItems ------------------------------------------------------------------------ INSERT INTO PlayerItems (Domain, CivilizationType, LeaderType, Type, Icon, Name, Description, SortIndex) VALUES ('Players:StandardPlayers', 'CIVILIZATION_ENIGMA_COMANCHE', 'LEADER_ENIGMA_POTSUNAKWAHIPU', 'BUILDING_ENIGMA_SWEAT_LODGE', 'ICON_BUILDING_ENIGMA_SWEAT_LODGE', 'LOC_BUILDING_ENIGMA_SWEAT_LODGE_NAME', 'LOC_BUILDING_ENIGMA_SWEAT_LODGE_DESCRIPTION', 20), ('Players:StandardPlayers', 'CIVILIZATION_ENIGMA_COMANCHE', 'LEADER_ENIGMA_POTSUNAKWAHIPU', 'UNIT_ENIGMA_QUICKSTINGER', 'ICON_UNIT_ENIGMA_QUICKSTINGER', 'LOC_UNIT_ENIGMA_QUICKSTINGER_NAME', 'LOC_UNIT_ENIGMA_QUICKSTINGER_DESCRIPTION', 10); INSERT INTO PlayerItems (Domain, CivilizationType, LeaderType, Type, Icon, Name, Description, SortIndex) VALUES ('Players:StandardPlayers', 'CIVILIZATION_ENIGMA_COMANCHE', 'LEADER_ENIGMA_QUANAH', 'BUILDING_ENIGMA_SWEAT_LODGE', 'ICON_BUILDING_ENIGMA_SWEAT_LODGE', 'LOC_BUILDING_ENIGMA_SWEAT_LODGE_NAME', 'LOC_BUILDING_ENIGMA_SWEAT_LODGE_DESCRIPTION', 20), ('Players:StandardPlayers', 'CIVILIZATION_ENIGMA_COMANCHE', 'LEADER_ENIGMA_QUANAH', 'UNIT_ENIGMA_QUICKSTINGER', 'ICON_UNIT_ENIGMA_QUICKSTINGER', 'LOC_UNIT_ENIGMA_QUICKSTINGER_NAME', 'LOC_UNIT_ENIGMA_QUICKSTINGER_DESCRIPTION', 10), ('Players:StandardPlayers', 'CIVILIZATION_ENIGMA_COMANCHE', 'LEADER_ENIGMA_QUANAH', 'BUILDING_ENIGMA_STAR_HOUSE', 'ICON_BUILDING_ENIGMA_STAR_HOUSE', 'LOC_BUILDING_ENIGMA_STAR_HOUSE_NAME', 'LOC_BUILDING_ENIGMA_STAR_HOUSE_DESCRIPTION', 30); --=============================================== INSERT INTO Players (Domain, CivilizationType, Portrait, PortraitBackground, LeaderType, LeaderName, LeaderIcon, LeaderAbilityName, LeaderAbilityDescription, LeaderAbilityIcon, CivilizationName, CivilizationIcon, CivilizationAbilityName, CivilizationAbilityDescription, CivilizationAbilityIcon) VALUES ('Players:Expansion1_Players', 'CIVILIZATION_ENIGMA_COMANCHE', 'LEADER_ENIGMA_POTSUNAKWAHIPU_NEUTRAL.dds', 'LEADER_GORGO_BACKGROUND', 'LEADER_ENIGMA_POTSUNAKWAHIPU', 'LOC_LEADER_ENIGMA_POTSUNAKWAHIPU_NAME', 'ICON_LEADER_ENIGMA_POTSUNAKWAHIPU', 'LOC_TRAIT_LEADER_ENIGMA_GREAT_RAID_NAME', 'LOC_TRAIT_LEADER_ENIGMA_GREAT_RAID_DESCRIPTION', 'ICON_LEADER_ENIGMA_POTSUNAKWAHIPU', 'LOC_CIVILIZATION_ENIGMA_COMANCHE_NAME', 'ICON_CIVILIZATION_ENIGMA_COMANCHE', 'LOC_TRAIT_CIVILIZATION_ENIGMA_COMANCHE_MOON_NAME', 'LOC_TRAIT_CIVILIZATION_ENIGMA_COMANCHE_MOON_DESCRIPTION', 'ICON_CIVILIZATION_ENIGMA_COMANCHE'); INSERT INTO Players (Domain, CivilizationType, Portrait, PortraitBackground, LeaderType, LeaderName, LeaderIcon, LeaderAbilityName, LeaderAbilityDescription, LeaderAbilityIcon, CivilizationName, CivilizationIcon, CivilizationAbilityName, CivilizationAbilityDescription, CivilizationAbilityIcon) VALUES ('Players:Expansion1_Players', 'CIVILIZATION_ENIGMA_COMANCHE', 'LEADER_ENIGMA_QUANAH_NEUTRAL.dds', 'LEADER_VICTORIA_BACKGROUND', 'LEADER_ENIGMA_QUANAH', 'LOC_LEADER_ENIGMA_QUANAH_NAME', 'ICON_LEADER_ENIGMA_QUANAH', 'LOC_TRAIT_LEADER_ENIGMA_HALF_MOON_CHURCH_NAME', 'LOC_TRAIT_LEADER_ENIGMA_HALF_MOON_CHURCH_DESCRIPTION', 'ICON_LEADER_ENIGMA_QUANAH', 'LOC_CIVILIZATION_ENIGMA_COMANCHE_NAME', 'ICON_CIVILIZATION_ENIGMA_QUANAH_COMANCHE', 'LOC_TRAIT_CIVILIZATION_ENIGMA_COMANCHE_MOON_NAME', 'LOC_TRAIT_CIVILIZATION_ENIGMA_COMANCHE_MOON_DESCRIPTION', 'ICON_CIVILIZATION_ENIGMA_QUANAH_COMANCHE'); ------------------------------------------------------------------------ -- PlayerItems ------------------------------------------------------------------------ INSERT INTO PlayerItems (Domain, CivilizationType, LeaderType, Type, Icon, Name, Description, SortIndex) VALUES ('Players:Expansion1_Players', 'CIVILIZATION_ENIGMA_COMANCHE', 'LEADER_ENIGMA_POTSUNAKWAHIPU', 'BUILDING_ENIGMA_SWEAT_LODGE', 'ICON_BUILDING_ENIGMA_SWEAT_LODGE', 'LOC_BUILDING_ENIGMA_SWEAT_LODGE_NAME', 'LOC_BUILDING_ENIGMA_SWEAT_LODGE_DESCRIPTION', 20), ('Players:Expansion1_Players', 'CIVILIZATION_ENIGMA_COMANCHE', 'LEADER_ENIGMA_POTSUNAKWAHIPU', 'UNIT_ENIGMA_QUICKSTINGER', 'ICON_UNIT_ENIGMA_QUICKSTINGER', 'LOC_UNIT_ENIGMA_QUICKSTINGER_NAME', 'LOC_UNIT_ENIGMA_QUICKSTINGER_DESCRIPTION', 10); INSERT INTO PlayerItems (Domain, CivilizationType, LeaderType, Type, Icon, Name, Description, SortIndex) VALUES ('Players:Expansion1_Players', 'CIVILIZATION_ENIGMA_COMANCHE', 'LEADER_ENIGMA_QUANAH', 'BUILDING_ENIGMA_SWEAT_LODGE', 'ICON_BUILDING_ENIGMA_SWEAT_LODGE', 'LOC_BUILDING_ENIGMA_SWEAT_LODGE_NAME', 'LOC_BUILDING_ENIGMA_SWEAT_LODGE_DESCRIPTION', 20), ('Players:Expansion1_Players', 'CIVILIZATION_ENIGMA_COMANCHE', 'LEADER_ENIGMA_QUANAH', 'UNIT_ENIGMA_QUICKSTINGER', 'ICON_UNIT_ENIGMA_QUICKSTINGER', 'LOC_UNIT_ENIGMA_QUICKSTINGER_NAME', 'LOC_UNIT_ENIGMA_QUICKSTINGER_DESCRIPTION', 10), ('Players:Expansion1_Players', 'CIVILIZATION_ENIGMA_COMANCHE', 'LEADER_ENIGMA_QUANAH', 'BUILDING_ENIGMA_STAR_HOUSE', 'ICON_BUILDING_ENIGMA_STAR_HOUSE', 'LOC_BUILDING_ENIGMA_STAR_HOUSE_NAME', 'LOC_BUILDING_ENIGMA_STAR_HOUSE_DESCRIPTION', 30); --=============================================== INSERT INTO Players (Domain, CivilizationType, Portrait, PortraitBackground, LeaderType, LeaderName, LeaderIcon, LeaderAbilityName, LeaderAbilityDescription, LeaderAbilityIcon, CivilizationName, CivilizationIcon, CivilizationAbilityName, CivilizationAbilityDescription, CivilizationAbilityIcon) VALUES ('Players:Expansion2_Players', 'CIVILIZATION_ENIGMA_COMANCHE', 'LEADER_ENIGMA_POTSUNAKWAHIPU_NEUTRAL.dds', 'LEADER_GORGO_BACKGROUND', 'LEADER_ENIGMA_POTSUNAKWAHIPU', 'LOC_LEADER_ENIGMA_POTSUNAKWAHIPU_NAME', 'ICON_LEADER_ENIGMA_POTSUNAKWAHIPU', 'LOC_TRAIT_LEADER_ENIGMA_GREAT_RAID_NAME', 'LOC_TRAIT_LEADER_ENIGMA_GREAT_RAID_DESCRIPTION', 'ICON_LEADER_ENIGMA_POTSUNAKWAHIPU', 'LOC_CIVILIZATION_ENIGMA_COMANCHE_NAME', 'ICON_CIVILIZATION_ENIGMA_COMANCHE', 'LOC_TRAIT_CIVILIZATION_ENIGMA_COMANCHE_MOON_NAME', 'LOC_TRAIT_CIVILIZATION_ENIGMA_COMANCHE_MOON_DESCRIPTION', 'ICON_CIVILIZATION_ENIGMA_COMANCHE'); INSERT INTO Players (Domain, CivilizationType, Portrait, PortraitBackground, LeaderType, LeaderName, LeaderIcon, LeaderAbilityName, LeaderAbilityDescription, LeaderAbilityIcon, CivilizationName, CivilizationIcon, CivilizationAbilityName, CivilizationAbilityDescription, CivilizationAbilityIcon) VALUES ('Players:Expansion2_Players', 'CIVILIZATION_ENIGMA_COMANCHE', 'LEADER_ENIGMA_QUANAH_NEUTRAL.dds', 'LEADER_VICTORIA_BACKGROUND', 'LEADER_ENIGMA_QUANAH', 'LOC_LEADER_ENIGMA_QUANAH_NAME', 'ICON_LEADER_ENIGMA_QUANAH', 'LOC_TRAIT_LEADER_ENIGMA_HALF_MOON_CHURCH_NAME', 'LOC_TRAIT_LEADER_ENIGMA_HALF_MOON_CHURCH_DESCRIPTION', 'ICON_LEADER_ENIGMA_QUANAH', 'LOC_CIVILIZATION_ENIGMA_COMANCHE_NAME', 'ICON_CIVILIZATION_ENIGMA_QUANAH_COMANCHE', 'LOC_TRAIT_CIVILIZATION_ENIGMA_COMANCHE_MOON_NAME', 'LOC_TRAIT_CIVILIZATION_ENIGMA_COMANCHE_MOON_DESCRIPTION', 'ICON_CIVILIZATION_ENIGMA_QUANAH_COMANCHE'); ------------------------------------------------------------------------ -- PlayerItems ------------------------------------------------------------------------ INSERT INTO PlayerItems (Domain, CivilizationType, LeaderType, Type, Icon, Name, Description, SortIndex) VALUES ('Players:Expansion2_Players', 'CIVILIZATION_ENIGMA_COMANCHE', 'LEADER_ENIGMA_POTSUNAKWAHIPU', 'BUILDING_ENIGMA_SWEAT_LODGE', 'ICON_BUILDING_ENIGMA_SWEAT_LODGE', 'LOC_BUILDING_ENIGMA_SWEAT_LODGE_NAME', 'LOC_BUILDING_ENIGMA_SWEAT_LODGE_DESCRIPTION', 20), ('Players:Expansion2_Players', 'CIVILIZATION_ENIGMA_COMANCHE', 'LEADER_ENIGMA_POTSUNAKWAHIPU', 'UNIT_ENIGMA_QUICKSTINGER', 'ICON_UNIT_ENIGMA_QUICKSTINGER', 'LOC_UNIT_ENIGMA_QUICKSTINGER_NAME', 'LOC_UNIT_ENIGMA_QUICKSTINGER_DESCRIPTION', 10); INSERT INTO PlayerItems (Domain, CivilizationType, LeaderType, Type, Icon, Name, Description, SortIndex) VALUES ('Players:Expansion2_Players', 'CIVILIZATION_ENIGMA_COMANCHE', 'LEADER_ENIGMA_QUANAH', 'BUILDING_ENIGMA_SWEAT_LODGE', 'ICON_BUILDING_ENIGMA_SWEAT_LODGE', 'LOC_BUILDING_ENIGMA_SWEAT_LODGE_NAME', 'LOC_BUILDING_ENIGMA_SWEAT_LODGE_DESCRIPTION', 20), ('Players:Expansion2_Players', 'CIVILIZATION_ENIGMA_COMANCHE', 'LEADER_ENIGMA_QUANAH', 'UNIT_ENIGMA_QUICKSTINGER', 'ICON_UNIT_ENIGMA_QUICKSTINGER', 'LOC_UNIT_ENIGMA_QUICKSTINGER_NAME', 'LOC_UNIT_ENIGMA_QUICKSTINGER_DESCRIPTION', 10), ('Players:Expansion2_Players', 'CIVILIZATION_ENIGMA_COMANCHE', 'LEADER_ENIGMA_QUANAH', 'BUILDING_ENIGMA_STAR_HOUSE', 'ICON_BUILDING_ENIGMA_STAR_HOUSE', 'LOC_BUILDING_ENIGMA_STAR_HOUSE_NAME', 'LOC_BUILDING_ENIGMA_STAR_HOUSE_DESCRIPTION', 30);
Last edited by Madisonian; 11 May, 2024 @ 6:07am