Arkatakor
King
In the Vox Populi modmod that i'm working on, its now been several days that I have tried to solve the following updates to the builds table to no end. :
UPDATE Builds
SET PrereqTech = 'TECH_POTTERY'
WHERE Type = 'BUILD_TRADING_POST' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_TERRAIN' AND Value= 1 );
UPDATE Builds
SET PrereqTech = 'TECH_MINING'
WHERE Type = 'BUILD_REMOVE_FOREST' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_TERRAIN' AND Value= 1 );
UPDATE Builds
SET PrereqTech = 'TECH_BRONZE_WORKING'
WHERE Type = 'BUILD_REMOVE_JUNGLE' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_TERRAIN' AND Value= 1 );
What happens is that:
1) The trading post is buildable with zero tech requirements even though its set to require pottery.
2) The Remove forest icon is visually displayed in the tech tree as to require mining, BUT workers can only chop forests upon researching bronze working (as in the original mod).
3) The Remove jungle icon is visually displayed in the tech tree as to require mining, BUT workers can only chop forests upon researching iron working (as in the original mod).
There are no syntax errors that i'm aware of. The file Units/Updates.SQL where the above SQL commands are residing is the last Action to be called in the mod, and the SQL commands nearly the last in the file. I did this to make sure my updates are not being overridden by something else in the modmod. Any suggestions would be greatly appreciated.
UPDATE Builds
SET PrereqTech = 'TECH_POTTERY'
WHERE Type = 'BUILD_TRADING_POST' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_TERRAIN' AND Value= 1 );
UPDATE Builds
SET PrereqTech = 'TECH_MINING'
WHERE Type = 'BUILD_REMOVE_FOREST' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_TERRAIN' AND Value= 1 );
UPDATE Builds
SET PrereqTech = 'TECH_BRONZE_WORKING'
WHERE Type = 'BUILD_REMOVE_JUNGLE' AND EXISTS (SELECT * FROM COMMUNITY WHERE Type='COMMUNITY_CORE_BALANCE_TERRAIN' AND Value= 1 );
What happens is that:
1) The trading post is buildable with zero tech requirements even though its set to require pottery.
2) The Remove forest icon is visually displayed in the tech tree as to require mining, BUT workers can only chop forests upon researching bronze working (as in the original mod).
3) The Remove jungle icon is visually displayed in the tech tree as to require mining, BUT workers can only chop forests upon researching iron working (as in the original mod).
There are no syntax errors that i'm aware of. The file Units/Updates.SQL where the above SQL commands are residing is the last Action to be called in the mod, and the SQL commands nearly the last in the file. I did this to make sure my updates are not being overridden by something else in the modmod. Any suggestions would be greatly appreciated.