Socra
Chieftain
- Joined
- Mar 9, 2015
- Messages
- 51
I'm trying to create and insert a new "test" city-state.
Game loads, no crashes, but no appearance.
I tried to be lazy with the loc name, description, etc. But I don't "think" that's the problem.
What other basic stuff have I missed besides that?
Here's my code so far:
--Cherokee City State
INSERT INTO Types
(Type, Kind)
VALUES ('LORD_CIVILIZATION_CHEROKEE', 'KIND_CIVILIZATION') ,
('LEADER_MINOR_CIV_CHEROKEE', 'KIND_LEADER') ,
('MINOR_CIV_CHEROKEE_TRAIT', 'KIND_TRAIT') ;
INSERT INTO TypeProperties
(Type, Name, Value)
VALUES ('LORD_CIVILIZATION_CHEROKEE', 'CityStateCategory', 'CULTURAL') ;
INSERT INTO Civilizations
(CivilizationType, Name, Description, Adjective, RandomCityNameDepth, StartingCivilizationLevelType, Ethnicity)
VALUES ('LORD_CIVILIZATION_CHEROKEE', 'Cherokee Tribe', 'Cherokee Tribe', 'Cherokee Tribe', 1, 'CIVILIZATION_LEVEL_CITY_STATE', 'ETHNICITY_EURO');
INSERT INTO Leaders
(LeaderType, Name, OperationList, IsBarbarianLeader, InheritFrom, SceneLayers)
VALUES ('LEADER_MINOR_CIV_CHEROKEE', 'Cherokee', NULL, 0, 'LEADER_MINOR_CIV_CULTURAL', 0) ;
INSERT INTO LeaderTraits
(LeaderType, TraitType)
VALUES ('LEADER_MINOR_CIV_CHEROKEE', 'MINOR_CIV_CHEROKEE_TRAIT') ;
INSERT INTO Traits
(TraitType, Name, Description)
VALUES ('MINOR_CIV_CHEROKEE_TRAIT', 'Cherokee Bonus', '+30% growth in all your cities') ;
INSERT INTO TraitModifiers
(TraitType, ModifierId)
VALUES ('MINOR_CIV_CHEROKEE_TRAIT', 'MINOR_CIV_CHEROKEE_UNIQUE_INFLUENCE_BONUS') ;
INSERT INTO Modifiers
(ModifierId, ModifierType, RunOnce, Permanent, OwnerRequirementSetId, SubjectRequirementSetId)
VALUES ('MINOR_CIV_CHEROKEE_UNIQUE_INFLUENCE_BONUS','MODIFIER_ALL_PLAYERS_ATTACH_MODIFIER',0,0, NULL,'PLAYER_IS_SUZERAIN')
('MINOR_CIV_CHEROKEE_GROWTH_FOOD_BONUS', 'MODIFIER_PLAYER_CITIES_ADJUST_CITY_GROWTH',0,0, NULL, NULL);
INSERT INTO ModifierArguements
(ModifierId,Name,Type,Value,Extra,SecondExtra)
VALUES ('MINOR_CIV_CHEROKEE_UNIQUE_INFLUENCE_BONUS', 'ModifierId', 'ARGTYPE_IDENTITY', 'MINOR_CIV_CHEROKEE_GROWTH_FOOD_BONUS', NULL, NULL) ,
('MINOR_CIV_CHEROKEE_GROWTH_FOOD_BONUS', 'Amount', 'ARGTYPE_IDENTITY', 30, NULL, NULL) ;
INSERT INTO Colors
(Type, Red, Green, Blue, Alpha)
VALUES ('COLOR_PLAYER_CITY_STATE_FOOD_SECONDARY', 0.6980, 0.9333, 0.2275, 1);
INSERT INTO PlayerColors
(Type, Usage, PrimaryColor, SecondaryColor, TextColor)
VALUES ('LORD_CIVILIZATION_CHEROKEE', Minor, 'COLOR_PLAYER_CITY_STATE_PRIMARY', 'COLOR_PLAYER_CITY_STATE_FOOD_SECONDARY', 'COLOR_PLAYER_CITY_STATE_FOOD_SECONDARY');
INSERT INTO CivilizationLeaders
(LeaderType, CivilizationType, CapitalName)
VALUES ('LEADER_MINOR_CIV_CHEROKEE', 'LORD_CIVILIZATION_CHEROKEE', 'Kituwa');
INSERT INTO StartPosition
(MapName, Civilization, Leader, X, Y)
VALUES ('GiantEarth', 'LORD_CIVILIZATION_CHEROKEE', 'LEADER_MINOR_CIV_CHEROKEE', 150, 64);
Game loads, no crashes, but no appearance.
I tried to be lazy with the loc name, description, etc. But I don't "think" that's the problem.
What other basic stuff have I missed besides that?
Here's my code so far:
Spoiler :
--Cherokee City State
INSERT INTO Types
(Type, Kind)
VALUES ('LORD_CIVILIZATION_CHEROKEE', 'KIND_CIVILIZATION') ,
('LEADER_MINOR_CIV_CHEROKEE', 'KIND_LEADER') ,
('MINOR_CIV_CHEROKEE_TRAIT', 'KIND_TRAIT') ;
INSERT INTO TypeProperties
(Type, Name, Value)
VALUES ('LORD_CIVILIZATION_CHEROKEE', 'CityStateCategory', 'CULTURAL') ;
INSERT INTO Civilizations
(CivilizationType, Name, Description, Adjective, RandomCityNameDepth, StartingCivilizationLevelType, Ethnicity)
VALUES ('LORD_CIVILIZATION_CHEROKEE', 'Cherokee Tribe', 'Cherokee Tribe', 'Cherokee Tribe', 1, 'CIVILIZATION_LEVEL_CITY_STATE', 'ETHNICITY_EURO');
INSERT INTO Leaders
(LeaderType, Name, OperationList, IsBarbarianLeader, InheritFrom, SceneLayers)
VALUES ('LEADER_MINOR_CIV_CHEROKEE', 'Cherokee', NULL, 0, 'LEADER_MINOR_CIV_CULTURAL', 0) ;
INSERT INTO LeaderTraits
(LeaderType, TraitType)
VALUES ('LEADER_MINOR_CIV_CHEROKEE', 'MINOR_CIV_CHEROKEE_TRAIT') ;
INSERT INTO Traits
(TraitType, Name, Description)
VALUES ('MINOR_CIV_CHEROKEE_TRAIT', 'Cherokee Bonus', '+30% growth in all your cities') ;
INSERT INTO TraitModifiers
(TraitType, ModifierId)
VALUES ('MINOR_CIV_CHEROKEE_TRAIT', 'MINOR_CIV_CHEROKEE_UNIQUE_INFLUENCE_BONUS') ;
INSERT INTO Modifiers
(ModifierId, ModifierType, RunOnce, Permanent, OwnerRequirementSetId, SubjectRequirementSetId)
VALUES ('MINOR_CIV_CHEROKEE_UNIQUE_INFLUENCE_BONUS','MODIFIER_ALL_PLAYERS_ATTACH_MODIFIER',0,0, NULL,'PLAYER_IS_SUZERAIN')
('MINOR_CIV_CHEROKEE_GROWTH_FOOD_BONUS', 'MODIFIER_PLAYER_CITIES_ADJUST_CITY_GROWTH',0,0, NULL, NULL);
INSERT INTO ModifierArguements
(ModifierId,Name,Type,Value,Extra,SecondExtra)
VALUES ('MINOR_CIV_CHEROKEE_UNIQUE_INFLUENCE_BONUS', 'ModifierId', 'ARGTYPE_IDENTITY', 'MINOR_CIV_CHEROKEE_GROWTH_FOOD_BONUS', NULL, NULL) ,
('MINOR_CIV_CHEROKEE_GROWTH_FOOD_BONUS', 'Amount', 'ARGTYPE_IDENTITY', 30, NULL, NULL) ;
INSERT INTO Colors
(Type, Red, Green, Blue, Alpha)
VALUES ('COLOR_PLAYER_CITY_STATE_FOOD_SECONDARY', 0.6980, 0.9333, 0.2275, 1);
INSERT INTO PlayerColors
(Type, Usage, PrimaryColor, SecondaryColor, TextColor)
VALUES ('LORD_CIVILIZATION_CHEROKEE', Minor, 'COLOR_PLAYER_CITY_STATE_PRIMARY', 'COLOR_PLAYER_CITY_STATE_FOOD_SECONDARY', 'COLOR_PLAYER_CITY_STATE_FOOD_SECONDARY');
INSERT INTO CivilizationLeaders
(LeaderType, CivilizationType, CapitalName)
VALUES ('LEADER_MINOR_CIV_CHEROKEE', 'LORD_CIVILIZATION_CHEROKEE', 'Kituwa');
INSERT INTO StartPosition
(MapName, Civilization, Leader, X, Y)
VALUES ('GiantEarth', 'LORD_CIVILIZATION_CHEROKEE', 'LEADER_MINOR_CIV_CHEROKEE', 150, 64);