Modding new buildings, having difficulties

pippin_nl

Chieftain
Joined
Jan 3, 2006
Messages
9
I'm trying to add a building, but for some reason it's not working


-- Tags
--------------------------------------------------------------
INSERT OR IGNORE INTO TypeTags (Type,Tag) VALUES('BUILDING_HAMLET_X1','AGELESS');
INSERT OR IGNORE INTO TypeTags (Type,Tag) VALUES('BUILDING_HAMLET_X1','PERSISTENT');

-- Types
--------------------------------------------------------------
INSERT OR IGNORE INTO Types (Type,Kind) VALUES('BUILDING_HAMLET_X1','KIND_CONSTRUCTIBLE');

-- Constructibles
--------------------------------------------------------------
INSERT OR IGNORE INTO Constructibles (ConstructibleType,Name,Description,Cost,Population,Age,ConstructibleClass) VALUES('BUILDING_HAMLET_X1','Village','Village',15,1,'AGE_ANTIQUITY','BUILDING');

-- Buildings
--------------------------------------------------------------
INSERT OR IGNORE INTO Buildings (ConstructibleType,TraitType,Movable,Town) VALUES('BUILDING_HAMLET_X1','TRAIT_GREECE',0,1);

-- Constructible_ValidDistricts
--------------------------------------------------------------
INSERT OR IGNORE INTO Constructible_ValidDistricts (ConstructibleType,DistrictType) VALUES('BUILDING_HAMLET_X1','DISTRICT_CITY_CENTER');
INSERT OR IGNORE INTO Constructible_ValidDistricts (ConstructibleType,DistrictType) VALUES('BUILDING_HAMLET_X1','DISTRICT_URBAN');


-- Constructible_ValidTerrains
--------------------------------------------------------------
INSERT OR IGNORE INTO Constructible_ValidTerrains (ConstructibleType,TerrainType) VALUES('BUILDING_HAMLET_X1','TERRAIN_FLAT');

-- IconDefinitions
--------------------------------------------------------------
INSERT OR IGNORE INTO IconDefinitions (ID,Path) VALUES('BUILDING_HAMLET_X1','blp:buildicon_villa');

-- ProgressionTreeNodeUnlocks
--------------------------------------------------------------
INSERT OR IGNORE INTO ProgressionTreeNodeUnlocks (ProgressionTreeNodeType,TargetKind,TargetType,UnlockDepth) VALUES('NODE_TECH_AQ_AGRICULTURE','KIND_CONSTRUCTIBLE','BUILDING_HAMLET_X1','1');
 
Type before TypeTag?

Try running your statements directly in the sqlite db. You may have to run this statement to type insert to work:

DROP TRIGGER OnTypeInsert;
CREATE TRIGGER OnTypeInsert AFTER INSERT ON Types BEGIN UPDATE Types SET Hash = random() Where Type = New.Type; END;
 
database.log:

[2025-03-03 17:56:12] [frontend]: Validating Foreign Key Constraints...
[2025-03-03 17:56:12] [frontend]: Passed Validation.
[2025-03-03 17:56:12] [localization]: StartupErrorMessages.xml
[2025-03-03 17:56:12] [localization]: Database XML root elements must start with either <Database> or <GameEffects>.
[2025-03-03 17:56:12] [localization]: Validating Foreign Key Constraints...
[2025-03-03 17:56:12] [localization]: Passed Validation.
[2025-03-03 17:56:12] [FullTextSearch]: Initializing FullTextSearch
[2025-03-03 17:56:12] [HallofFame]: Database found. Checking versions...
[2025-03-03 17:56:12] [HallofFame]: Database is up-to-date!
[2025-03-03 17:56:12] [HallofFame]: UpdateAggregateDataPoints took 0.000760 seconds.
[2025-03-03 17:56:12] [frontend]: Validating Foreign Key Constraints...
[2025-03-03 17:56:12] [frontend]: Passed Validation.
[2025-03-03 17:56:13] [HallofFame]: UpdateAggregateDataPoints took 0.001561 seconds.
[2025-03-03 17:56:36] [localization]: Rebuilding database.
[2025-03-03 17:56:36] [localization] Warning: Attempting to shutdown database with outstanding queries.
[2025-03-03 17:56:36] [localization]: StartupErrorMessages.xml
[2025-03-03 17:56:36] [localization]: Database XML root elements must start with either <Database> or <GameEffects>.
[2025-03-03 17:56:36] [frontend]: Rebuilding database.
[2025-03-03 17:56:36] [frontend]: Validating Foreign Key Constraints...
[2025-03-03 17:56:36] [frontend]: Passed Validation.
[2025-03-03 17:56:37] [HallofFame]: UpdateAggregateDataPoints took 0.001016 seconds.
[2025-03-03 17:56:38] [localization]: Rebuilding database.
[2025-03-03 17:56:38] [localization]: StartupErrorMessages.xml
[2025-03-03 17:56:38] [localization]: Database XML root elements must start with either <Database> or <GameEffects>.
[2025-03-03 17:56:38] [frontend]: Rebuilding database.
[2025-03-03 17:56:39] [frontend]: Validating Foreign Key Constraints...
[2025-03-03 17:56:39] [frontend]: Passed Validation.
[2025-03-03 17:56:39] [HallofFame]: UpdateAggregateDataPoints took 0.001036 seconds.
[2025-03-03 17:56:39] [localization]: Rebuilding database.
[2025-03-03 17:56:39] [localization]: StartupErrorMessages.xml
[2025-03-03 17:56:39] [localization]: Database XML root elements must start with either <Database> or <GameEffects>.
[2025-03-03 17:56:42] [gameplay]: Validating Foreign Key Constraints...
[2025-03-03 17:56:42] [gameplay]: Passed Validation.
[2025-03-03 17:57:00] [FullTextSearch]: FTS - Creating Context
 
Back
Top Bottom