Of course. You can convert them easily to sqls. I personally prefer them to xmls.
Do you think that MinorCivs.xml should be contained within Colors.xml to ensure it's loading along with the other xmls as a set? Or would that make no difference?Of course. You can convert them easily to sqls. I personally prefer them to xmls.
CREATE TABLE IF NOT EXISTS PlayerColors (
`GameData` INT,
`GameData_PlayerColors` INT,
`GameData_PlayerColors_Row` INT,
`GameData_PlayerColors_Row_Type` VARCHAR(30) CHARACTER SET utf8,
`GameData_PlayerColors_Row_PrimaryColor` VARCHAR(23) CHARACTER SET utf8,
`GameData_PlayerColors_Row_SecondaryColor` VARCHAR(31) CHARACTER SET utf8,
`GameData_PlayerColors_Row_TextColor` VARCHAR(23) CHARACTER SET utf8
);
INSERT INTO PlayerColors VALUES
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_ALMATY','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_ALMATY','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_ANTWERP','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_ANTWERP','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_BELGRADE','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_BELGRADE','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_BRATISLAVA','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_BRATISLAVA','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_BRUSSELS','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_BRUSSELS','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_BUCHAREST','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_BUCHAREST','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_BUDAPEST','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_BUDAPEST','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_BUENOS_AIRES','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_BUENOS_AIRES','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_BYBLOS','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_BYBLOS','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_CAHOKIA','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_CAHOKIA','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_CAPE_TOWN','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_CAPE_TOWN','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_COLOMBO','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_COLOMBO','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_FLORENCE','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_FLORENCE','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_GENOA','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_GENOA','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_HANOI','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_HANOI','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_HONG_KONG','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_HONG_KONG','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_IFE','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_IFE','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_JERUSALEM','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_JERUSALEM','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_KABUL','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_KABUL','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_KATHMANDU','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_KATHMANDU','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_KIEV','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_KIEV','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_KUALA_LUMPUR','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_KUALA_LUMPUR','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_KYZYL','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_KYZYL','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_LHASA','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_LHASA','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_MALACCA','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_MALACCA','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_MANILA','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_MANILA','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_MBANZA_KONGO','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_MBANZA_KONGO','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_MELBOURNE','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_MELBOURNE','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_MILAN','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_MILAN','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_MOGADISHU','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_MOGADISHU','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_MOMBASA','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_MOMBASA','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_MONACO','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_MONACO','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_ORMUS','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_ORMUS','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_PANAMA_CITY','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_PANAMA_CITY','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_PRAGUE','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_PRAGUE','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_QUEBEC_CITY','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_QUEBEC_CITY','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_RIGA','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_RIGA','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_RAGUSA','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_RAGUSA','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_SAMARKAND','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_SAMARKAND','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_SIDON','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_SIDON','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_SOFIA','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_SOFIA','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_SYDNEY','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_SYDNEY','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_TYRE','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_TYRE','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_UR','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_UR','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_VALLETTA','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_VALLETTA','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_VANCOUVER','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_VANCOUVER','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_VATICAN_CITY','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_VATICAN_CITY','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_WELLINGTON','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_WELLINGTON','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_WITTENBERG','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_WITTENBERG','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_YEREVAN','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_YEREVAN','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_ZANZIBAR','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_ZANZIBAR','COLOR_PLAYER_PEACH_TEXT'),
(NULL,NULL,NULL,'PLAYERCOLOR_MINOR_ZURICH','COLOR_PLAYER_MINOR_ICON','COLOR_PLAYER_MINOR_ZURICH','COLOR_PLAYER_PEACH_TEXT');
This is from sqlizer just so I would see what an example looks like. I'm not sure what the null is for.This table must be created? What are 3 first columns for? Varchar is better from string?
CREATE TABLE IF NOT EXISTS
COMMUNITY (
Type text default null,
Value integer default 0);
Probably because you're not referencing it right. The game has the tendency to load whatever is name-wise first when all of the mod's dependencies are done, but tends to ignore references like crazy.@ryanmusante Do you have any idea why this mod and CSL sometimes ignore reference for UCS? There's one guy who made modpack and MC loaded before UCS in it even though it has reference. Also one guy few days ao complaint of the same issue for both mods. I had no idea how to resolve this.
How is going work on new version with reworked files?
So, that UCS sql was what I intended to combine with the others and use as a base. I hadn't finished yet what I started. Has 6.1 corrected the problem?@ryanmusante Do you have any idea why this mod and CSL sometimes ignore reference for UCS? There's one guy who made modpack and MC loaded before UCS in it even though it has reference.
Hey there, I'm having the same issue with Sweden reverting to the dark blue/yellow. I've completely refreshed my mods folder, re-downloaded the latest version of the mods I had but the problem remains. I'm not getting any problems with Morocco like you had, and as far as I can tell it is only Sweden affected now.@ryanmusante I have strange glitch. When I load mods (only VP and MC) first civ that is chosen by default by the game in start game options menu has colours reset to default. Glitch stays after starting the game. But, when I enter menu to choose civs, everything looks good. Do you have the same?
So it's something hard-coded that can't be altered possibly. It has better stability as DLC?The problem with the default civ colors was present in the mod version of RCI - I remember it being mentioned in the thread. So it's not something you have introduced during the merge.
<ReloadUnitSystem>1</ReloadUnitSystem>