Store Page
Sid Meier's Civilization VI
All Discussions Screenshots Artwork Broadcasts Videos Workshop News Guides Reviews

Sid Meier's Civilization VI

Store Page
Sid Meier's Civilization VI >  Workshop > the_m4a's Workshop > CQUI - Community Quick User Interface > Discussions
CQUI - Community Quick User Interface
Description Discussions28 Comments1231 Change Notes
the_m4a  [developer] 13 Aug, 2020 @ 11:09pm
Ensure CQUI_Settings_Local is -not- updated every time a new change is pushed to the Workshop
**Edit: the next update to the workshop will remove the CQUI_Settings_Local.sql file from the CQUI\Assets folder. ONLY the version in the parent folder will be used (this is the version that is NOT overwritten each time a new update is made). See the link to our GitHub wiki below.**

One of the common requests we've had is to find a way to -not- override the custom settings people have set up in their CQUI_Settings_Local.sql file every time a new version of the mod is pushed to the Steam Workshop.

I found a hacky, but appears to work, solution that should allow y'all to keep those settings without having to restore them every time I push a new version to the workshop: store the CQUI_Settings_Local.sql file in the parent folder of the mod.

Explained with pictures on our GitHub page: https://github.com/civfanatics/CQUI_Community-Edition/wiki/CQUI_Settings_Local-in-Parent-Subfolder
Last edited by the_m4a; 4 Sep, 2020 @ 11:32pm
< >
Showing 1-2 of 2 comments
**************________0022DE92 18 Aug, 2020 @ 5:13am 
the setting file are broken for me. any change of parameters in the setting file will cause all check boxes in cqui setting to be unchecked.
and the comment in the setting files "Attention: Don't write your custom settings in the original copy of this file"are misleading. Does it mean I should not modify the setting files?
And finally, wha't the difference between cqui_settingsi.sql and cqui_settings_local.sql? which on overides which one?
#1
the_m4a  [developer] 26 Aug, 2020 @ 6:48pm 
that's my fault on the "Attention" thing. I copy and pasted the original file in to that cqui_settings_local copy and must have missed the comment.

Here is a version of the file without the code comments
remove the "--" from the beginning of any of those lines to have that value be set when a new game is created. Value of 0 is disabled, 1 is enabled.

INSERT OR REPLACE INTO CQUI_Settings -- Don"t touch this line! VALUES ('CQUI_ShowDebugPrint', 0), -- Shows print in the console -- ("CQUI_AlwaysOpenTechTrees", 1), -- ("CQUI_AutoapplyArchaeologistLens", 1), -- ("CQUI_AutoapplyBuilderLens", 1), -- ("CQUI_AutoapplyScoutLens", 1), -- ("CQUI_AutoExpandUnitActions", 1), -- ("CQUI_RelocateCityStrike", 1), -- ("CQUI_RelocateEncampmentStrike", 0), -- ("CQUI_ProductionQueue", 1), -- ("CQUI_ShowCultureGrowth", 1), -- ("CQUI_ShowPolicyReminder", 1), -- ("CQUI_ShowLuxuries", 1), -- ("CQUI_ShowUnitPaths", 1), -- ("CQUI_ShowYieldsOnCityHover", 1), -- ("CQUI_Smartbanner", 0), -- ("CQUI_Smartbanner_UnlockedCitizen", 0), -- ("CQUI_Smartbanner_Districts", 0), -- ("CQUI_Smartbanner_Population", 0), -- ("CQUI_Smartbanner_Cultural", 1), -- ("CQUI_SmartWorkIcon", 1), -- ("CQUI_TechPopupVisual", 0), -- ("CQUI_TechPopupAudio", 1), -- ("CQUI_WonderBuiltPopupVisual", 1), -- ("CQUI_WonderBuiltPopupAudio", 1), -- ("CQUI_ToggleYieldsOnLoad", 1), -- ("CQUI_ShowCitizenIconsOnCityHover", 0), -- ("CQUI_ShowCityManageAreaOnCityHover", 1), -- ("CQUI_TraderAddDivider", 1), -- ("CQUI_TraderShowSortOrder", 0), -- ("CQUI_ShowProductionRecommendations", 0), -- ("CQUI_ShowTechCivicRecommendations", 1), -- ("CQUI_ShowImprovementsRecommendations", 0), -- ("CQUI_ShowCityDetailAdvisor", 0), -- ("CQUI_BindingsMode", 1), -- ("CQUI_ResourceDimmingStyle", 1), -- ("CQUI_SmartWorkIconSize", 64), -- ("CQUI_SmartWorkIconAlpha", 40), -- ("CQUI_WorkIconSize", 64), -- ("CQUI_WorkIconAlpha", 80), -- ("CQUI_TrimGossip", 1), -- ("CQUI_LOC_GOSSIP_AGENDA_KUDOS", 0), -- ("CQUI_LOC_GOSSIP_AGENDA_WARNING", 1), -- ("CQUI_LOC_GOSSIP_ALLIED", 1), -- ("CQUI_LOC_GOSSIP_ANARCHY_BEGINS", 1), -- ("CQUI_LOC_GOSSIP_ARTIFACT_EXTRACTED", 0), -- ("CQUI_LOC_GOSSIP_BARBARIAN_INVASION_STARTED", 1), -- ("CQUI_LOC_GOSSIP_BARBARIAN_RAID_STARTED", 1), -- ("CQUI_LOC_GOSSIP_BEACH_RESORT_CREATED", 0), -- ("CQUI_LOC_GOSSIP_CHANGE_GOVERNMENT", 1), -- ("CQUI_LOC_GOSSIP_CITY_BESIEGED", 1), -- ("CQUI_LOC_GOSSIP_CITY_LIBERATED", 1), -- ("CQUI_LOC_GOSSIP_CITY_RAZED", 1), -- ("CQUI_LOC_GOSSIP_CLEAR_CAMP", 0), -- ("CQUI_LOC_GOSSIP_CITY_STATE_INFLUENCE", 1), -- ("CQUI_LOC_GOSSIP_CONQUER_CITY", 1), -- ("CQUI_LOC_GOSSIP_CONSTRUCT_DISTRICT", 1), -- ("CQUI_LOC_GOSSIP_CREATE_PANTHEON", 1), -- ("CQUI_LOC_GOSSIP_CULTURVATE_CIVIC", 1), --Civic researched -- ("CQUI_LOC_GOSSIP_DECLARED_FRIENDSHIP", 1), -- ("CQUI_LOC_GOSSIP_DELEGATION", 0), -- ("CQUI_LOC_GOSSIP_DENOUNCED", 1), -- ("CQUI_LOC_GOSSIP_EMBASSY", 0), -- ("CQUI_LOC_GOSSIP_ERA_CHANGED", 1), -- ("CQUI_LOC_GOSSIP_FIND_NATURAL_WONDER", 0), -- ("CQUI_LOC_GOSSIP_FOUND_CITY", 1), -- ("CQUI_LOC_GOSSIP_FOUND_RELIGION", 1), -- ("CQUI_LOC_GOSSIP_GREATPERSON_CREATED", 1), -- ("CQUI_LOC_GOSSIP_LAUNCHING_ATTACK", 1), -- ("CQUI_LOC_GOSSIP_WAR_PREPARATION", 1), -- ("CQUI_LOC_GOSSIP_INQUISITION_LAUNCHED", 0), -- ("CQUI_LOC_GOSSIP_LAND_UNIT_LEVEL", 0), -- ("CQUI_LOC_GOSSIP_MAKE_DOW", 1), -- ("CQUI_LOC_GOSSIP_NATIONAL_PARK_CREATED", 0), -- ("CQUI_LOC_GOSSIP_NEW_RELIGIOUS_MAJORITY", 1), -- ("CQUI_LOC_GOSSIP_PILLAGE", 0), -- ("CQUI_LOC_GOSSIP_POLICY_ENACTED", 1), -- ("CQUI_LOC_GOSSIP_RECEIVE_DOW", 1), -- ("CQUI_LOC_GOSSIP_RELIC_RECEIVED", 0), -- ("CQUI_LOC_GOSSIP_RESEARCH_AGREEMENT", 0), -- ("CQUI_LOC_GOSSIP_RESEARCH_TECH", 1), -- ("CQUI_LOC_GOSSIP_SPY_DISRUPT_ROCKETRY_DETECTED", 1), -- ("CQUI_LOC_GOSSIP_SPY_DISRUPT_ROCKETRY_UNDETECTED", 1), -- ("CQUI_LOC_GOSSIP_SPY_GREAT_WORK_HEIST_DETECTED", 0), -- ("CQUI_LOC_GOSSIP_SPY_GREAT_WORK_HEIST_UNDETECTED", 0), -- ("CQUI_LOC_GOSSIP_SPY_RECRUIT_PARTISANS_DETECTED", 1), -- ("CQUI_LOC_GOSSIP_SPY_RECRUIT_PARTISANS_UNDETECTED", 1), -- ("CQUI_LOC_GOSSIP_SPY_SABOTAGE_PRODUCTION_DETECTED", 1), -- ("CQUI_LOC_GOSSIP_SPY_SABOTAGE_PRODUCTION_UNDETECTED", 1), -- ("CQUI_LOC_GOSSIP_SPY_SIPHON_FUNDS_DETECTED", 1), -- ("CQUI_LOC_GOSSIP_SPY_SIPHON_FUNDS_UNDETECTED", 1), -- ("CQUI_LOC_GOSSIP_SPY_STEAL_TECH_BOOST_DETECTED", 1), -- ("CQUI_LOC_GOSSIP_SPY_STEAL_TECH_BOOST_UNDETECTED", 1), -- ("CQUI_LOC_GOSSIP_TRADE_DEAL", 0), -- ("CQUI_LOC_GOSSIP_TRADE_RENEGE", 0), -- ("CQUI_LOC_GOSSIP_TRAIN_SETTLER", 1), -- ("CQUI_LOC_GOSSIP_TRAIN_UNIT", 1), -- ("CQUI_LOC_GOSSIP_TRAIN_UNIQUE_UNIT", 1), -- ("CQUI_LOC_GOSSIP_PROJECT_STARTED", 0), -- ("CQUI_LOC_GOSSIP_START_VICTORY_STRATEGY", 1), -- ("CQUI_LOC_GOSSIP_STOP_VICTORY_STRATEGY", 1), -- ("CQUI_LOC_GOSSIP_WMD_BUILT", 1), -- ("CQUI_LOC_GOSSIP_WMD_STRIKE", 1), -- ("CQUI_LOC_GOSSIP_WONDER_STARTED", 1), -- Keeping this last one uncommented allows for uncommenting only those you care about above ("CQUI_DUMMY_SETTING_TO_END_THE_SETTINGS_LOCAL_FILE", 0);
Last edited by the_m4a; 26 Aug, 2020 @ 6:52pm
#2
< >
Showing 1-2 of 2 comments
Per page: 1530 50