Hi all, I'm trying to create a custom dynamic list but I'm a bit confused about some of the sql elements.
Should I be updating the existing 'ML_TABLES' sql file or should I be creating a new one?
Also, if I am updating the existing file, does it matter where I put them? (i.e. can I put them all at the end or do I need to put them at specific points throughout the file?)
The edits I mean are these:
CREATE TABLE IF NOT EXISTS ML_Labels_Dynamic (ID INTEGER PRIMARY KEY AUTOINCREMENT, Name TEXT, MainType TEXT default "FEATURE", SubType TEXT, CultureType TEXT);
CREATE TABLE IF NOT EXISTS ML_CultureEras (ID INTEGER PRIMARY KEY AUTOINCREMENT, Type TEXT, Description TEXT);
CREATE TABLE IF NOT EXISTS ML_CultureGroups (ID INTEGER PRIMARY KEY AUTOINCREMENT, Type TEXT, Description TEXT);
CREATE TABLE IF NOT EXISTS ML_Cultures (ID INTEGER PRIMARY KEY AUTOINCREMENT, Type TEXT, 'Group' TEXT, Description TEXT, SuggestedCivs TEXT);
INSERT INTO ML_Cultures (Type, 'Group', Description, SuggestedCivs)
SELECT 'CUSTOM', 'CULTURE_GROUP_AMERICAN', 'TXT_KEY_ML_CULTURE_CUSTOM' , 'TXT_KEY_ML_CULTURE_CUSTOM_SUGGESTEDCIVS' ;
CREATE TABLE IF NOT EXISTS ML_CivCultures (ID INTEGER PRIMARY KEY AUTOINCREMENT, CivType TEXT, CultureType TEXT, CultureEra TEXT DEFAULT 'ANY');
INSERT INTO ML_CivCultures(CivType, CultureType, CultureEra)
SELECT 'CIVILIZATION_CUSTOM', 'CUSTOM', 'ANY' ;
Thanks
*edit: Just thought I should add that I am able to select my custome culture in game, but no labels are generated so I guess I need to find a way to link the custom entry in the 'ML_TABLES' file to the custom xml file that I have created.