Thalassicus / cep-bnw

Civ V Communitas Expansion Pack
32 stars 22 forks source link

CER_Unlocks & CEL_End #268

Open GrantSP opened 10 years ago

GrantSP commented 10 years ago

Both these files are making changes to the PrereqTech for Builds.

All this:

UPDATE Builds SET PrereqTech ='TECH_BRONZE_WORKING'
WHERE Type IN (
    'BUILD_BRAZILWOOD_CAMP'
);

UPDATE Builds SET PrereqTech ='TECH_DRAMA'
WHERE Type IN (
    'BUILD_MOAI'        ,
    'BUILD_CHATEAU'
);

UPDATE Builds SET PrereqTech ='TECH_CONSTRUCTION'
WHERE Type IN (
    'BUILD_KASBAH'
);

UPDATE Builds SET PrereqTech ='TECH_AGRICULTURE'
WHERE Type IN (
    'BUILD_TERRACE_FARM'
);

UPDATE Builds SET PrereqTech ='TECH_CONSTRUCTION'
WHERE Type IN (
    'BUILD_FEITORIA'
);

is in _CELEnd. I would suggest that all of this could easily be removed and just make any adjustments in _CERUnlocks Adding in the correct changes, like the recent Terrace Farm change, to the _CERUnlocks.

Curiously I thought _CELEnd loaded before _CERUnlocks yet the changes made in the former are retained in the database.