Meaningful Colours

Of course. You can convert them easily to sqls. I personally prefer them to xmls.
 
For me this mod should work. I was stunned when I saw such glitch. I even tried vp 9-15 to see if it is from there.

I think you can merge this in one sql file with correct order.
 
SQL formatting conversion of PlayerColors.xml. It's one line per entry. Does the game look for the former xml and use files from VP by default? Would I need a blank entry for the xmls>?
Spoiler SQL :

Code:
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 table must be created? What are 3 first columns for? Varchar is better from string?
 
@ryanmusante here is the example:
Code:
CREATE TABLE IF NOT EXISTS
COMMUNITY (
    Type                                        text                                        default null,
    Value                                       integer                                     default 0);
 
Last edited:
@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?
 
@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?
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.
 
So what do you suggest to make it right?

I added dependencies from VP which are also in UCS, but as references. Do you think it will help?

Probably that's why VP uses numbering in part's names?
 
Perhaps.

And that's correct also for the user-friendliness.
 
If someone has issues with mod load order then try v6.1. It helped @jdude147 who created modpack.
 
@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.
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?
 
Probably yes. Multiplayer modpack made by @jdude147 is working 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?
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.
I'm new here (and to the game) so if you need any additional info let me know.
 
Because if you have sweden as default then any other civ is ok. If the default civ change the problem moves to that new civ.

@ryanmusante Problem is gone if you load mod in modpack from DLC folder (example link in my signature).
 
Last edited:
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.
 
Ohh, that's valueble information. So only loading the mod as DLC helps in resolving it. Good to know. Thanks @psparky !
 
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.
So it's something hard-coded that can't be altered possibly. It has better stability as DLC?

I remember a mod {Toft's flags+++} that isn't compatible with VP but used a different technique. It combined lua hooks with xml.

What is the purpose of this setting?
Code:
<ReloadUnitSystem>1</ReloadUnitSystem>
 

Attachments

  • Screenshot_20181009-122511.png
    Screenshot_20181009-122511.png
    145.6 KB · Views: 83
  • Screenshot_20181009-122700.png
    Screenshot_20181009-122700.png
    1.1 MB · Views: 119
Last edited:
So is it best to rename it to (9) and put into MODS or just past it into DLC? I use Vox Populi and already have EUI in the DLC fodler and I read somewhere the game can/will only use one additional expansion, is this true?
 
Back
Top Bottom