I've been trying to create this mod (Austria tbe) for some while now and there were some obstacles over the days, but I've always found a solution. Now though I'm at a point where i simply can't find a solution and i wanted to ask if anyone could maybe help me here. At some point I couldn't start a game anymore after I did some changes, but for some reason I can't remember which changes they were. The database.log tells me:
> [1325993.908] [Gameplay] ERROR: near "INSERT": syntax error
and I don't know where that error could be.
> [1325993.908] [Gameplay] ERROR: near "INSERT": syntax error
and I don't know where that error could be.
Code:
--==========================================================================================================================
-- LEADERS
--==========================================================================================================================
-- Types
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Types
(Type, Kind)
VALUES ('LEADER_NEON_KOERNER', 'KIND_LEADER');
--------------------------------------------------------------------------------------------------------------------------
-- Leaders
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Leaders
(LeaderType, Name, InheritFrom, SceneLayers)
VALUES ('LEADER_NEON_KOERNER', 'LOC_LEADER_NEON_KOERNER', 'LEADER_DEFAULT', 4);
--------------------------------------------------------------------------------------------------------------------------
-- LeaderQuotes
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO LeaderQuotes
(LeaderType, Quote)
VALUES ('LEADER_NEON_KOERNER', 'LOC_PEDIA_LEADERS_PAGE_LEADER_NEON_KOERNER_QUOTE');
--------------------------------------------------------------------------------------------------------------------------
-- HistoricalAgendas
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO HistoricalAgendas
(LeaderType, AgendaType)
VALUES ('LEADER_NEON_KOERNER', 'AGENDA_OPTIMUS_PRINCEPS');
--------------------------------------------------------------------------------------------------------------------------
-- AgendaPreferredLeaders
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO AgendaPreferredLeaders
(LeaderType, AgendaType)
VALUES ('LEADER_NEON_KOERNER', 'AGENDA_NUKE_LOVER');
--==========================================================================================================================
-- LEADERS: COLOURS
--==========================================================================================================================
-- PlayerColors
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO PlayerColors
(Type, Usage, PrimaryColor, SecondaryColor, TextColor)
VALUES ('LEADER_NEON_KOERNER', 'Unique', 'COLOR_PLAYER_NEON_KOERNER_PRIMARY', 'COLOR_PLAYER_NEON_KOERNER_SECONDARY', 'COLOR_PLAYER_WHITE_TEXT');
INSERT INTO Colors
(Type, Red, Green, Blue, Alpha)
VALUES ('COLOR_PLAYER_NEON_KOERNER_PRIMARY', 0.988, 0.008, 0.016, 1),
('COLOR_PLAYER_NEON_KOERNER_SECONDARY', 1, 1, 1, 1);
--==========================================================================================================================
-- LEADERS: LOADING INFO
--==========================================================================================================================
-- LoadingInfo
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO LoadingInfo
(LeaderType, BackgroundImage, ForegroundImage, PlayDawnOfManAudio)
VALUES ('LEADER_NEON_KOERNER', 'LEADER_KOERNER_BACKGROUND', 'LEADER_KOERNER_NEUTRAL', 0);
--==========================================================================================================================
-- CIVILIZATIONS
--==========================================================================================================================
-- Types
----------------------------------------------------------------------------------------------------------------------------
INSERT INTO Types
(Type, Kind)
VALUES ('CIVILIZATION_NEON_AUSTRIA', 'KIND_CIVILIZATION');
----------------------------------------------------------------------------------------------------------------------------
-- Civilizations
----------------------------------------------------------------------------------------------------------------------------
INSERT INTO Civilizations
(CivilizationType, Name, Description, Adjective, StartingCivilizationLevelType, RandomCityNameDepth, Ethnicity)
VALUES ('CIVILIZATION_NEON_AUSTRIA', 'LOC_CIVILIZATION_NEON_AUSTRIA_NAME', 'LOC_CIVILIZATION_NEON_AUSTRIA_DESCRIPTION', 'LOC_CIVILIZATION_NEON_AUSTRIA_ADJECTIVE', 'CIVILIZATION_LEVEL_FULL_CIV', 10, 'ETHNICITY_EURO');
----------------------------------------------------------------------------------------------------------------------------
-- CityNames
----------------------------------------------------------------------------------------------------------------------------
INSERT INTO CityNames
(CivilizationType, CityName)
VALUES ('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITY_NAME_NEON_AUSTRIA_2'),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITY_NAME_NEON_AUSTRIA_3'),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITY_NAME_NEON_AUSTRIA_4'),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITY_NAME_NEON_AUSTRIA_5'),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITY_NAME_NEON_AUSTRIA_6'),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITY_NAME_NEON_AUSTRIA_7'),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITY_NAME_NEON_AUSTRIA_8'),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITY_NAME_NEON_AUSTRIA_9'),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITY_NAME_NEON_AUSTRIA_10'),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITY_NAME_NEON_AUSTRIA_11'),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITY_NAME_NEON_AUSTRIA_12'),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITY_NAME_NEON_AUSTRIA_13'),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITY_NAME_NEON_AUSTRIA_14'),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITY_NAME_NEON_AUSTRIA_15'),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITY_NAME_NEON_AUSTRIA_16'),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITY_NAME_NEON_AUSTRIA_17'),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITY_NAME_NEON_AUSTRIA_18'),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITY_NAME_NEON_AUSTRIA_19'),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITY_NAME_NEON_AUSTRIA_20'),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITY_NAME_NEON_AUSTRIA_21'),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITY_NAME_NEON_AUSTRIA_22'),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITY_NAME_NEON_AUSTRIA_23'),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITY_NAME_NEON_AUSTRIA_24'),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITY_NAME_NEON_AUSTRIA_25'),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITY_NAME_NEON_AUSTRIA_26'),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITY_NAME_NEON_AUSTRIA_27'),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITY_NAME_NEON_AUSTRIA_28'),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITY_NAME_NEON_AUSTRIA_29'),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITY_NAME_NEON_AUSTRIA_30');
----------------------------------------------------------------------------------------------------------------------------
-- CivilizationCitizenNames
----------------------------------------------------------------------------------------------------------------------------
INSERT INTO CivilizationCitizenNames
(CivilizationType, CitizenName, Female, Modern)
VALUES ('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITIZEN_NEON_AUSTRIA_MALE_1', 0, 0),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITIZEN_NEON_AUSTRIA_MALE_2', 0, 0),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITIZEN_NEON_AUSTRIA_MALE_3', 0, 0),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITIZEN_NEON_AUSTRIA_MALE_4', 0, 0),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITIZEN_NEON_AUSTRIA_MALE_5', 0, 0),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITIZEN_NEON_AUSTRIA_FEMALE_1', 1, 0),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITIZEN_NEON_AUSTRIA_FEMALE_2', 1, 0),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITIZEN_NEON_AUSTRIA_FEMALE_3', 1, 0),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITIZEN_NEON_AUSTRIA_FEMALE_4', 1, 0),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITIZEN_NEON_AUSTRIA_FEMALE_5', 1, 0),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITIZEN_NEON_AUSTRIA_MODERN_MALE_1', 0, 1),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITIZEN_NEON_AUSTRIA_MODERN_MALE_2', 0, 1),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITIZEN_NEON_AUSTRIA_MODERN_MALE_3', 0, 1),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITIZEN_NEON_AUSTRIA_MODERN_MALE_4', 0, 1),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITIZEN_NEON_AUSTRIA_MODERN_MALE_5', 0, 1),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITIZEN_NEON_AUSTRIA_MODERN_FEMALE_1', 1, 1),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITIZEN_NEON_AUSTRIA_MODERN_FEMALE_2', 1, 1),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITIZEN_NEON_AUSTRIA_MODERN_FEMALE_3', 1, 1),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITIZEN_NEON_AUSTRIA_MODERN_FEMALE_4', 1, 1),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CITIZEN_NEON_AUSTRIA_MODERN_FEMALE_5', 1, 1),
----------------------------------------------------------------------------------------------------------------------------
-- CivilizationInfo
----------------------------------------------------------------------------------------------------------------------------
INSERT INTO CivilizationInfo
(CivilizationType, Header, Caption, SortIndex)
VALUES ('CIVILIZATION_NEON_AUSTRIA', 'LOC_CIVINFO_LOCATION', 'LOC_CIVINFO_NEON_AUSTRIA_LOCATION', 10),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CIVINFO_SIZE', 'LOC_CIVINFO_NEON_AUSTRIA_SIZE', 20),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CIVINFO_POPULATION', 'LOC_CIVINFO_NEON_AUSTRIA_POPULATION', 30),
('CIVILIZATION_NEON_AUSTRIA', 'LOC_CIVINFO_CAPITAL', 'LOC_CIVINFO_NEON_AUSTRIA_CAPITAL', 40);
----------------------------------------------------------------------------------------------------------------------------
-- CivilizationLeaders
----------------------------------------------------------------------------------------------------------------------------
INSERT INTO CivilizationLeaders
(CivilizationType, LeaderType, CapitalName)
VALUES ('CIVILIZATION_NEON_AUSTRIA', 'LEADER_NEON_KOERNER', 'Vienna');
--------------------------------------------------------------------------------------------------------------------------
-- BackGround Art
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO DiplomacyInfo
(Type, BackgroundImage)
VALUES ('LEADER_NEON_KOERNER', 'ART_LEADER_KOERNER.dds');
--==========================================================================================================================
-- LEADERS: TRAITS
--==========================================================================================================================
-- Types
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Types
(Type, Kind)
VALUES ('TRAIT_LEADER_NEON_KOERNER_LTRAIT', 'KIND_TRAIT');
--------------------------------------------------------------------------------------------------------------------------
-- Traits
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Traits
(TraitType, Name, Description)
VALUES ('TRAIT_LEADER_NEON_KOERNER_LTRAIT', 'LOC_TRAIT_LEADER_NEON_KOERNER_LTRAIT_NAME', 'LOC_TRAIT_LEADER_NEON_KOERNER_LTRAIT_DESCRIPTION');
--------------------------------------------------------------------------------------------------------------------------
-- TraitModifiers
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO TraitModifiers
(TraitType, ModifierId)
VALUES ('TRAIT_LEADER_NEON_KOERNER_LTRAIT', 'NEON_KOERNER_LTRAIT_EXTRA_SLOT_1');
--------------------------------------------------------------------------------------------------------------------------
-- Modifiers
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Modifiers
(ModifierId, ModifierType)
VALUES ('NEON_KOERNER_LTRAIT_EXTRA_SLOT_1', 'MODIFIER_PLAYER_CULTURE_ADJUST_GOVERNMENT_SLOTS_MODIFIER');
--------------------------------------------------------------------------------------------------------------------------
-- ModifierArguments
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO ModifierArguments
(ModifierId, Name, Value)
VALUES ('NEON_KOERNER_LTRAIT_EXTRA_SLOT_1', 'GovernmentSlotType', 'SLOT_ECONOMIC');
--==========================================================================================================================
-- CIVILIZATIONS: TRAITS
--==========================================================================================================================
-- Types
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Types
(Type, Kind)
VALUES ('TRAIT_CIVILIZATION_NEON_CIV_TRAIT', 'KIND_TRAIT'),
('TRAIT_CIVILIZATION_BUILDING_NEON_CUSTOM', 'KIND_TRAIT'),
('TRAIT_CIVILIZATION_UNIT_NEON_CUSTOM_I', 'KIND_TRAIT'),
('TRAIT_CIVILIZATION_UNIT_NEON_CUSTOM_II', 'KIND_TRAIT');
--------------------------------------------------------------------------------------------------------------------------
-- Traits
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Traits
(TraitType, Name, Description)
VALUES ('TRAIT_CIVILIZATION_NEON_CIV_TRAIT', 'LOC_TRAIT_CIVILIZATION_NEON_CIV_TRAIT_NAME', 'LOC_TRAIT_CIVILIZATION_NEON_CIV_TRAIT_DESCRIPTION'),
('TRAIT_CIVILIZATION_BUILDING_NEON_CUSTOM', 'LOC_TRAIT_CIVILIZATION_BUILDING_NEON_CUSTOM_NAME', 'LOC_TRAIT_CIVILIZATION_BUILDING_NEON_CUSTOM_DESCRIPTION'),
('TRAIT_CIVILIZATION_UNIT_NEON_CUSTOM_I', 'LOC_UNIT_NEON_CUSTOM_I_NAME', 'LOC_UNIT_NEON_CUSTOM_I_DESCRIPTION'),
('TRAIT_CIVILIZATION_UNIT_NEON_CUSTOM_II', 'LOC_UNIT_NEON_CUSTOM_II_NAME', 'LOC_UNIT_NEON_CUSTOM_II_DESCRIPTION');
--------------------------------------------------------------------------------------------------------------------------
-- TraitModifiers
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO TraitModifiers
(TraitType, ModifierId)
VALUES ('TRAIT_CIVILIZATION_NEON_CIV_TRAIT', 'NEON_TRAIT_BORDER');
--------------------------------------------------------------------------------------------------------------------------
-- Modifiers
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Modifiers
(ModifierId, ModifierType)
VALUES ('NEON_TRAIT_BORDER', 'MODIFIER_ALL_CITIES_CULTURE_BORDER_EXPANSION');
--------------------------------------------------------------------------------------------------------------------------
-- ModifierArguments
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO ModifierArguments
(ModifierId, Name, Value)
VALUES ('NEON_TRAIT_BORDER', 'Amount', '100');
--------------------------------------------------------------------------------------------------------------------------
-- LeaderTraits
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO LeaderTraits
(LeaderType, TraitType)
VALUES ('LEADER_NEON_KOERNER', 'TRAIT_LEADER_NEON_KOERNER_LTRAIT');
----------------------------------------------------------------------------------------------------------------------------
-- CivilizationTraits
----------------------------------------------------------------------------------------------------------------------------
INSERT INTO CivilizationTraits
(TraitType, CivilizationType)
VALUES ('TRAIT_CIVILIZATION_NEON_CIV_TRAIT', 'CIVILIZATION_NEON_AUSTRIA'),
('TRAIT_CIVILIZATION_BUILDING_NEON_CUSTOM', 'CIVILIZATION_NEON_AUSTRIA'),
('TRAIT_CIVILIZATION_UNIT_NEON_CUSTOM_I', 'CIVILIZATION_NEON_AUSTRIA'),
('TRAIT_CIVILIZATION_UNIT_NEON_CUSTOM_II', 'CIVILIZATION_NEON_AUSTRIA');