(... continued from previous post)
Civilizations, Leaders and Traits
You need a minimum of 10 civs, any less and you have to remove two from the default number of the map size you are playing (so standard map you can only play 6 civs on and small map you can only play 4 civs on - this appears to be hard-coded within the .exe file as that's where the CTD happens if you don't follow the rules!)
The Minors and Barbarians define a lot of city names, I stripped those back to 5 each (the minimum required)
Units and UnitPromotions
Left the Warrior in as the UUs are based on it, but you could remove that as well, provided you add some other default unit
The Work Boat can be removed if you don't want to improve sea resources
The settler can possibly be removed, provided you add something else that can found cities, the Worker is a bad idea to remove as demanding a work unit from a CS is hard-coded to give a Worker.
The nine standard great people are all hard-coded within the DLL (mostly in the buy GP with faith code after completing a policy tree - note the DLL hard-codes GP to specific trees, and the Mayan trait)
If you take the spaceship parts out, you'll also need to remove the associated projects and mod the victory progress UI
Missionary and Inquisitor are hard-coded in the DLL. If you disabled faith generation, you could remove them (but then you'll need to mod the Natural Wonders and AssignStartingPlots.lus)
The promotions that are left are either some basic ones (insta-heal, embark, drill 1 and 2 and shock 1 and 2) for the Warrior (which could be removed if some others are added back in) and a few that are referenced from Features (altitude training) or referenced directly from the DLL (via the PostDefines table - remove these at your own risk!)
Buildings
Every capital needs a palace, if you remove this you MUST add a building with the palace flag set.
The Monument could be removed, but you need at least one default building for the UBs to be based on
Projects
Removing all projects will cause an XML validation error. I left Apollo as without it you'll need to mod the Victory Progress UI. Unless adding in a modded project, best to leave it in and not hook it up to a tech.
Processes
Removing all processes will cause an XML validation error. Pick either research or wealth to leave in, you don't need to hook it up to a tech.
Improvements, Routes and Builds
Huts and camps are required by the map scripts, ruins are required by the DLL (on razing a city)
You need something for the workers to do (or the AI auto-improve land code sulks), so I left in Farm and Mine - these could be removed if adding something else
If you leave workboats in, you'll need to leave in fishing boats - but you could remove both
The railroad build has been removed, and you could remove the road build as well - just do NOT delete them from the Routes table. The path-finding and city connection code in the DLL will not work properly if you do!
IMPORTANT: Take great care with the Builds table, as the DLL hard-codes references to some of them by ID (not Type) - fortunately this table doesn't need to have contiguous IDs.
Goody Huts
Unless modding the map scripts to remove goody hut improvements, you'll need to leave in something for the hut to produce. If you use the Shoshone UUs ability, you MUST have at least three different goody hut rewards
Techs and Eras
The DLL expects to find ERA_ANCIENT, ERA_INDUSTRIAL and ERA_MODERN (industrial via hard-coding, the other two via the PostDefines table) - but you can rename them as anything eg "Early", "Middle" and "Late", but don't change their Types.
The UI code expects to find Eras in ascending order in the database and the pedia expects them to have ascending TXT_KEYs (which I didn't do for this example ) - see the
initial discussion in this thread
Agriculture and Future Tech could be removed, but you'll need to add (at least) one initial tech to give to each civ and have one that repeats
Policies
If you want to change the number of policy trees (branches) you'll need to mod the UI.
It's also not a good idea to change the Types (POLICY_HONOR, POLICY_LIBERTY, etc) as those are hard-coded in the DLL
Ideologies and Tenets
The three ideologies are hard-coded in the DLL - there must be three ... not two or four. If you don't want ideologies, just don't have any buildings that enable them!
You can change the display name of the ideologies, but the Types are hard-coded in the DLL
If you want to change the number of tenets per level you'll need to mod the UI. To change the number of tiers (level) requires DLL mods (as the AI pushes for a level 3 tenet)
Religions & Beliefs
Not sure how the AI will handle only a single religion - as there is code in the DLL to try to found an opposing religion
You need at least one pantheon belief per civ (so ten), and one founder, two follower and one enhancer beliefs per religion (assuming you don't enable the trait that gives bonus beliefs or the policy to grant reformation beliefs)
Leagues and Resolutions
You could probably get away with a single league session. If you don't want the League, it's probably best to leave the minimum entries in the database and just not set the enabler on any tech.
Terrains, Features and Resources
Changes to terrains, features and resources (other than civ specific ones) will require major edits to AssignStartingPlots.lua and other map scripts.
Note also that some features have hard-coded references in the DLL, and others have "well-known" IDs in the GUI drawing code.
Mod Structure
The database actions fall into three sections
- Delete what we don't want
- Add stuff back in
- Renumber everything
Add stuff back in is split into four sections - Civs (including leaders, traits and uniques), Techs, Policies and AI.
The AI file patches the AI's strategies - read the comments!
The delete and renumber could be done in single files, but I've split them out into eight sub-files
- Buildings
- Civilizations
- Improvements
- Leagues
- Policies
- Religions
- Technologies
- Units
If you want to keep all the standard buildings (say) just remove/disable the two buildings files
The sql files are in two parts split by a
line. Above the line, everything we want to delete, below the line, everything we need to do to fix up the database. You should only need to edit the sql above the line if you want to make changes to what is deleted.
The SQL statements to delete everything as described from the database (ie every non-comment line above the -- TIDY UP lines) are
Code:
DELETE FROM Civilizations WHERE Type NOT IN ('CIVILIZATION_MINOR', 'CIVILIZATION_BARBARIAN');
DELETE FROM Units WHERE (Combat > 0 OR RangedCombat > 0) AND Type NOT IN ('UNIT_WARRIOR', 'UNIT_BARBARIAN_WARRIOR');
DELETE FROM Unit_ClassUpgrades WHERE UnitType IN ('UNIT_WARRIOR', 'UNIT_BARBARIAN_WARRIOR'); -- Remove the upgrade paths (this is probably unnecessary)
DELETE FROM Units WHERE Type IN ('UNIT_ARCHAEOLOGIST', 'UNIT_CARAVAN', 'UNIT_CARGO_SHIP');
DELETE FROM UnitPromotions_UnitCombats WHERE PromotionType NOT IN ('PROMOTION_INSTA_HEAL', 'PROMOTION_EMBARKATION', 'PROMOTION_SHOCK_1', 'PROMOTION_SHOCK_2', 'PROMOTION_DRILL_1', 'PROMOTION_DRILL_2');
DELETE FROM Buildings WHERE Type NOT IN ('BUILDING_PALACE', 'BUILDING_MONUMENT');
DELETE FROM Projects WHERE Type NOT IN ('PROJECT_APOLLO_PROGRAM', 'PROJECT_SS_BOOSTER', 'PROJECT_SS_COCKPIT', 'PROJECT_SS_ENGINE', 'PROJECT_SS_STASIS_CHAMBER');
DELETE FROM Improvements WHERE Type IN ('IMPROVEMENT_ARCHAEOLOGICAL_DIG', 'IMPROVEMENT_LANDMARK');
DELETE FROM Improvements WHERE Type IN (SELECT ImprovementType FROM Builds WHERE ImprovementType NOT IN ('IMPROVEMENT_FARM', 'IMPROVEMENT_MINE', 'IMPROVEMENT_FISHING_BOATS'));
DELETE FROM Builds WHERE Type IN ('BUILD_SCRUB_FALLOUT', 'BUILD_RAILROAD');
DELETE FROM GoodyHuts WHERE TYPE NOT IN ('GOODY_GOLD');
DELETE FROM Technologies WHERE Type NOT IN ('TECH_AGRICULTURE', 'TECH_FUTURE_TECH');
DELETE FROM Processes WHERE Type NOT IN ('PROCESS_WEALTH');
DELETE FROM Eras WHERE Type NOT IN ('ERA_ANCIENT', 'ERA_INDUSTRIAL', 'ERA_MODERN');
DELETE FROM Policies WHERE Level=0; -- Policies
DELETE FROM Policies WHERE Level>0; -- Tenets
DELETE FROM Religions WHERE ID>2;
UPDATE Worlds SET MaxActiveReligions=2;
DELETE FROM Beliefs WHERE Pantheon=1 AND Type NOT IN (SELECT Type FROM Beliefs WHERE Pantheon=1 LIMIT 10); -- One per civ
DELETE FROM Beliefs WHERE Founder=1 AND Type NOT IN (SELECT Type FROM Beliefs WHERE Founder=1 LIMIT 2); -- One per religion
DELETE FROM Beliefs WHERE Follower=1 AND Type NOT IN (SELECT Type FROM Beliefs WHERE Follower=1 LIMIT 4); -- Two per religion
DELETE FROM Beliefs WHERE Enhancer=1 AND Type NOT IN (SELECT Type FROM Beliefs WHERE Enhancer=1 LIMIT 2); -- One per religion
DELETE FROM Beliefs WHERE Reformation=1;
DELETE FROM LeagueSpecialSessions WHERE Type NOT IN ('LEAGUE_SPECIAL_SESSION_START_WORLD_CONGRESS', 'LEAGUE_SPECIAL_SESSION_START_UNITED_NATIONS');
UPDATE LeagueSpecialSessions SET EraTrigger='ERA_INDUSTRIAL' WHERE Type='LEAGUE_SPECIAL_SESSION_START_WORLD_CONGRESS';
UPDATE LeagueSpecialSessions SET EraTrigger='ERA_MODERN' WHERE Type='LEAGUE_SPECIAL_SESSION_START_UNITED_NATIONS';
DELETE FROM Resolutions WHERE Type IN ('RESOLUTION_ALL_CITY_STATES_EMBARGO', 'RESOLUTION_PLAYER_EMBARGO', 'RESOLUTION_BAN_LUXURY_HAPPINESS', 'RESOLUTION_STANDING_ARMY_TAX', 'RESOLUTION_MEMBER_DISCOVERED_TECH_DISCOUNT');
DELETE FROM Resolutions WHERE Type IN ('RESOLUTION_NUCLEAR_NON_PROLIFERATION', 'RESOLUTION_WORLD_RELIGION', 'RESOLUTION_WORLD_IDEOLOGY', 'RESOLUTION_HISTORICAL_LANDMARKS');
DELETE FROM LeagueProjects;
The SQL to tidy everything up is significantly longer!
Indeed, there are references to the Missionary and Inquisitor in the DLL code. What's the best way to disable them without causing crashes? Setting their faith cost to a very high number, or just making them "unpurchasable" by setting it to 0?
--- OP updated)
