Pazyryk
Deity
- Joined
- Jun 13, 2008
- Messages
- 3,584
One thing I've noticed a lot is that many tables in the DB are populated only in part by XML files, with the remainder populated by the dll. However, it is still possible to change these values via SQL.
One extreme example is the Defines table. The DebugDB Defines table has 1392 rows, which is much much more than you see in GlobalDefines.xml. Interestingly, you can change these values via SQL. Now, it's very likely that many of these won't work, or won't do what you want (e.g., CITY_PLOTS_RADIUS), but there are many more that may work just fine.
Interestingly, DebugDB has 40 rows that you don't see in CoreDB (I haven't noticed this difference in other tables). These are:
One extreme example is the Defines table. The DebugDB Defines table has 1392 rows, which is much much more than you see in GlobalDefines.xml. Interestingly, you can change these values via SQL. Now, it's very likely that many of these won't work, or won't do what you want (e.g., CITY_PLOTS_RADIUS), but there are many more that may work just fine.
Interestingly, DebugDB has 40 rows that you don't see in CoreDB (I haven't noticed this difference in other tables). These are:
Spoiler :
Code:
LAND_TERRAIN 0
DEEP_WATER_TERRAIN 6
SHALLOW_WATER_TERRAIN 5
RUINS_IMPROVEMENT 0
NUKE_FEATURE 6
CAPITAL_BUILDINGCLASS 48
DEFAULT_SPECIALIST 0
INITIAL_CITY_ROUTE_TYPE 0
STANDARD_HANDICAP 1
MULTIPLAYER_HANDICAP 3
STANDARD_HANDICAP_QUICK 1
STANDARD_GAMESPEED 2
STANDARD_TURNTIMER 3
STANDARD_CLIMATE 0
STANDARD_WORLD_SIZE 3
STANDARD_SEALEVEL 1
STANDARD_ERA 0
STANDARD_CALENDAR 0
BARBARIAN_HANDICAP 1
BARBARIAN_CIVILIZATION 3
MINOR_CIV_HANDICAP 3
MINOR_CIVILIZATION 2
PROMOTION_EMBARKATION 8
PROMOTION_OCEAN_IMPASSABLE 10
PROMOTION_OCEAN_IMPASSABLE_UNTIL_ASTRONOMY 9
BARBARIAN_CAMP_IMPROVEMENT 1
WALLS_BUILDINGCLASS 24
AI_HANDICAP 1
MAX_CIV_PLAYERS 63
MAX_CIV_TEAMS 63
MAX_MAJOR_CIVS 22
MAX_MINOR_CIVS 41
MAX_PLAYERS 64
MAX_TEAMS 64
BARBARIAN_PLAYER 63
BARBARIAN_TEAM 63
NUM_CITY_PLOTS 37
CITY_HOME_PLOT 0
CITY_PLOTS_RADIUS 3
CITY_PLOTS_DIAMETER 7