static void OnePassTH(
EZThreadproc passproc,
vector<double> &shXout,
vector<double> &shXin,
int nXout,
int nthr,
double shw )
{
int nr = vRgn.size(), // regions total
nb; // regions per thread
if( nthr > nr )
nthr = nr;
Xout = &shXout;
Xin = &shXin;
w = shw;
nb = nr / nthr;
vthr.resize( nthr );
Xout->resize( nXout );
vthr[0].r0 = 0;
vthr[0].rlim = nb;
for( int i = 1; i < nthr; ++i ) {
CThrdat &C = vthr[i];
C.r0 = vthr[i-1].rlim;
C.rlim = (i == nthr-1 ? nr : C.r0 + nb);
}
if( !EZThreads( passproc, nthr, 1, "passproc" ) )
exit( 42 );
Remark();
vthr.clear();
}
/// Read from XML file
bool CvImprovementEntry::CacheResults(Database::Results& kResults, CvDatabaseUtility& kUtility)
{
if(!CvBaseInfo::CacheResults(kResults, kUtility))
return false;
//Basic properties
const char* szArtDefineTag = kResults.GetText("ArtDefineTag");
SetArtDefineTag(szArtDefineTag);
m_iGoldMaintenance = kResults.GetInt("GoldMaintenance");
m_iCultureBombRadius = kResults.GetInt("CultureBombRadius");
m_iRequiresXAdjacentLand = kResults.GetInt("RequiresXAdjacentLand");
#if defined(MOD_API_EXTENSIONS)
m_iRequiresXAdjacentWater = kResults.GetInt("RequiresXAdjacentWater");
#endif
#if defined(MOD_GLOBAL_STACKING_RULES)
m_iAdditionalUnits = kResults.GetInt("AdditionalUnits");
#endif
m_iCultureAdjacentSameType = kResults.GetInt("CultureAdjacentSameType");
m_bHillsMakesValid = kResults.GetBool("HillsMakesValid");
#if defined(MOD_GLOBAL_ALPINE_PASSES)
m_bMountainsMakesValid = kResults.GetBool("MountainsMakesValid");
#endif
#if defined(MOD_GLOBAL_PASSABLE_FORTS)
m_bMakesPassable = kResults.GetBool("MakesPassable");
#endif
m_bFreshWaterMakesValid = kResults.GetBool("FreshWaterMakesValid");
m_bRiverSideMakesValid = kResults.GetBool("RiverSideMakesValid");
m_bNoFreshWater = kResults.GetBool("NoFreshWater");
#if defined(MOD_API_EXTENSIONS)
if (MOD_API_EXTENSIONS) {
m_bAddsFreshWater = kResults.GetBool("AddsFreshWater");
}
#endif
m_bRequiresFlatlands = kResults.GetBool("RequiresFlatlands");
m_bRequiresFlatlandsOrFreshWater = kResults.GetBool("RequiresFlatlandsOrFreshWater");
m_bRequiresFeature = kResults.GetBool("RequiresFeature");
m_bRequiresImprovement = kResults.GetBool("RequiresImprovement");
m_bRemovesResource = kResults.GetBool("RemovesResource");
m_bPromptWhenComplete = kResults.GetBool("PromptWhenComplete");
m_bWater = kResults.GetBool("Water");
m_bCoastal = kResults.GetBool("Coastal");
m_bDestroyedWhenPillaged = kResults.GetBool("DestroyedWhenPillaged");
m_bDisplacePillager = kResults.GetBool("DisplacePillager");
m_bBuildableOnResources = kResults.GetBool("BuildableOnResources");
m_eImprovementUsageType = m_bBuildableOnResources ? IMPROVEMENTUSAGE_LANDMARK : IMPROVEMENTUSAGE_BASIC;
m_bBarbarianCamp = kResults.GetBool("BarbarianCamp");
m_bGoody = kResults.GetBool("Goody");
m_bPermanent = kResults.GetBool("Permanent");
m_iTilesPerGoody = kResults.GetInt("TilesPerGoody");
m_iGoodyUniqueRange = kResults.GetInt("GoodyRange");
m_iFeatureGrowthProbability = kResults.GetInt("FeatureGrowth");
m_iUpgradeTime = kResults.GetInt("UpgradeTime");
m_iRiverSideUpgradeMod = kResults.GetInt("RiverSideUpgradeMod");
m_iCoastalLandUpgradeMod = kResults.GetInt("CoastalLandUpgradeMod");
m_iHillsUpgradeMod = kResults.GetInt("HillsUpgradeMod");
m_iFreshWaterUpgradeMod = kResults.GetInt("FreshWaterUpgradeMod");
m_iDefenseModifier = kResults.GetInt("DefenseModifier");
m_iNearbyEnemyDamage = kResults.GetInt("NearbyEnemyDamage");
m_iPillageGold = kResults.GetInt("PillageGold");
m_bOutsideBorders = kResults.GetBool("OutsideBorders");
m_bInAdjacentFriendly = kResults.GetBool("InAdjacentFriendly");
m_bIgnoreOwnership = kResults.GetBool("IgnoreOwnership");
m_bOnlyCityStateTerritory = kResults.GetBool("OnlyCityStateTerritory");
#if defined(MOD_DIPLOMACY_CITYSTATES)
if (MOD_DIPLOMACY_CITYSTATES) {
m_bIsEmbassy = kResults.GetBool("IsEmbassy");
}
#endif
#if defined(MOD_BALANCE_CORE)
const char* szObsoleteTech = kResults.GetText("ObsoleteTech");
m_iGetObsoleteTech = (CivilizationTypes)GC.getInfoTypeForString(szObsoleteTech, true);
m_bAdjacentLake = kResults.GetBool("Lakeside");
m_bAdjacentCity = kResults.GetBool("Cityside");
m_iGrantsVision = kResults.GetInt("GrantsVisionXTiles");
#endif
m_bNoTwoAdjacent = kResults.GetBool("NoTwoAdjacent");
m_bAdjacentLuxury = kResults.GetBool("AdjacentLuxury");
m_bAllowsWalkWater = kResults.GetBool("AllowsWalkWater");
m_bCreatedByGreatPerson = kResults.GetBool("CreatedByGreatPerson");
m_bSpecificCivRequired = kResults.GetBool("SpecificCivRequired");
m_iResourceExtractionMod = kResults.GetInt("ResourceExtractionMod");
m_iLuxuryCopiesSiphonedFromMinor = kResults.GetInt("LuxuryCopiesSiphonedFromMinor");
#if defined(MOD_DIPLOMACY_CITYSTATES)
if (MOD_DIPLOMACY_CITYSTATES) {
m_iImprovementLeagueVotes = kResults.GetInt("ImprovementLeagueVotes");
}
#endif
const char* szCivilizationType = kResults.GetText("CivilizationType");
m_eRequiredCivilization = (CivilizationTypes)GC.getInfoTypeForString(szCivilizationType, true);
#if defined(MOD_BALANCE_CORE)
const char* szImprovementResource = kResults.GetText("ImprovementResource");
m_iImprovementResource = (ResourceTypes)GC.getInfoTypeForString(szImprovementResource, true);
m_iImprovementResourceQuantity = kResults.GetInt("ImprovementResourceQuantity");
const char* szTextVal;
szTextVal = kResults.GetText("UnitFreePromotion");
if(szTextVal != NULL)
{
m_iUnitFreePromotionImprovement = GC.getInfoTypeForString(szTextVal, true);
}
#endif
//References
const char* szWorldsoundscapeAudioScript = kResults.GetText("WorldSoundscapeAudioScript");
if(szWorldsoundscapeAudioScript != NULL)
{
m_iWorldSoundscapeScriptId = gDLL->GetAudioTagIndex(szWorldsoundscapeAudioScript, AUDIOTAG_SOUNDSCAPE);
}
else
{
m_iWorldSoundscapeScriptId = -1;
Remark(1, "Warning: Missing soundscape definition in XML for feature: '%s'", GetType());
}
const char* szImprovementPillage = kResults.GetText("ImprovementPillage");
m_iImprovementPillage = GC.getInfoTypeForString(szImprovementPillage, true);
const char* szImprovementUpgrade = kResults.GetText("ImprovementUpgrade");
m_iImprovementUpgrade = GC.getInfoTypeForString(szImprovementUpgrade, true);
//Arrays
const char* szImprovementType = GetType();
const size_t lenImprovementType = strlen(szImprovementType);
kUtility.PopulateArrayByExistence(m_pbTerrainMakesValid,
"Terrains",
"Improvement_ValidTerrains",
"TerrainType",
"ImprovementType",
szImprovementType);
kUtility.PopulateArrayByExistence(m_pbFeatureMakesValid,
"Features",
"Improvement_ValidFeatures",
"FeatureType",
"ImprovementType",
szImprovementType);
kUtility.PopulateArrayByExistence(m_pbImprovementMakesValid,
"Improvements",
"Improvement_ValidImprovements",
"PrereqImprovement",
"ImprovementType",
szImprovementType);
#if defined(MOD_API_UNIFIED_YIELDS)
kUtility.SetYields(m_piAdjacentSameTypeYield, "Improvement_YieldAdjacentSameType", "ImprovementType", szImprovementType);
kUtility.SetYields(m_piAdjacentTwoSameTypeYield, "Improvement_YieldAdjacentTwoSameType", "ImprovementType", szImprovementType);
#endif
kUtility.SetYields(m_piYieldChange, "Improvement_Yields", "ImprovementType", szImprovementType);
kUtility.SetYields(m_piYieldPerEra, "Improvement_YieldPerEra", "ImprovementType", szImprovementType);
kUtility.SetYields(m_piAdjacentCityYieldChange, "Improvement_AdjacentCityYields", "ImprovementType", szImprovementType);
kUtility.SetYields(m_piAdjacentMountainYieldChange, "Improvement_AdjacentMountainYieldChanges", "ImprovementType", szImprovementType);
kUtility.SetYields(m_piCoastalLandYieldChange, "Improvement_CoastalLandYields", "ImprovementType", szImprovementType);
kUtility.SetYields(m_piFreshWaterChange, "Improvement_FreshWaterYields", "ImprovementType", szImprovementType);
kUtility.SetYields(m_piHillsYieldChange, "Improvement_HillsYields", "ImprovementType", szImprovementType);
kUtility.SetYields(m_piRiverSideYieldChange, "Improvement_RiverSideYields", "ImprovementType", szImprovementType);
kUtility.SetYields(m_piPrereqNatureYield, "Improvement_PrereqNatureYields", "ImprovementType", szImprovementType);
kUtility.SetFlavors(m_piFlavorValue, "Improvement_Flavors", "ImprovementType", szImprovementType);
{
//Initialize Improvement Resource Types to number of Resources
const int iNumResources = kUtility.MaxRows("Resources");
m_paImprovementResource = FNEW(CvImprovementResourceInfo[iNumResources], c_eCiv5GameplayDLL, 0);
kUtility.InitializeArray(m_piResourceQuantityRequirements, iNumResources);
std::string strResourceTypesKey = "Improvements - ResourceTypes";
Database::Results* pResourceTypes = kUtility.GetResults(strResourceTypesKey);
if(pResourceTypes == NULL)
{
pResourceTypes = kUtility.PrepareResults(strResourceTypesKey, "select Resources.ID, ResourceType, ResourceMakesValid, ResourceTrade, DiscoveryRand from Improvement_ResourceTypes inner join Resources on ResourceType = Resources.Type where ImprovementType = ?");
}
std::string strYieldResultsKey = "Improvements - YieldResults";
Database::Results* pYieldResults = kUtility.GetResults(strYieldResultsKey);
if(pYieldResults == NULL)
{
pYieldResults = kUtility.PrepareResults(strYieldResultsKey, "select Yields.ID, Yield from Improvement_ResourceType_Yields inner join Yields on YieldType = Yields.Type where ImprovementType = ? and ResourceType = ?");
}
pResourceTypes->Bind(1, szImprovementType, lenImprovementType, false);
while(pResourceTypes->Step())
{
const int idx = pResourceTypes->GetInt("ID");
CvImprovementResourceInfo& pResourceInfo = m_paImprovementResource[idx];
const char* szResourceType = pResourceTypes->GetText("ResourceType");
pResourceInfo.m_bResourceMakesValid = pResourceTypes->GetBool("ResourceMakesValid");
pResourceInfo.m_bResourceTrade = pResourceTypes->GetBool("ResourceTrade");
pResourceInfo.m_iDiscoverRand = pResourceTypes->GetInt("DiscoveryRand");
m_piResourceQuantityRequirements[idx] = pResourceTypes->GetInt("QuantityRequirement");
//Populate Yields for structure
kUtility.InitializeArray(pResourceInfo.m_piYieldChange, "Yields");
pYieldResults->Bind(1, szImprovementType, lenImprovementType, false);
pYieldResults->Bind(2, szResourceType, -1, false);
while(pYieldResults->Step())
{
const int yieldIdx = pYieldResults->GetInt("ID");
const int yield = pYieldResults->GetInt("Yield");
pResourceInfo.m_piYieldChange[yieldIdx] = yield;
}
pYieldResults->Reset();
}
pResourceTypes->Reset();
}
const int iNumYields = kUtility.MaxRows("Yields");
#if defined(MOD_BALANCE_CORE)
//AdjacentImprovementYieldChanges
{
const int iNumImprovements = kUtility.MaxRows("Improvements");
CvAssertMsg(iNumImprovements > 0, "Num Improvement Infos <= 0");
kUtility.Initialize2DArray(m_ppiAdjacentImprovementYieldChanges, iNumImprovements, iNumYields);
std::string strKey = "Improvements - AdjacentImprovementYieldChanges";
Database::Results* pResults = kUtility.GetResults(strKey);
if(pResults == NULL)
{
pResults = kUtility.PrepareResults(strKey, "select Yields.ID as YieldID, Improvements.ID as ImprovementID, Yield from Improvement_AdjacentImprovementYieldChanges inner join Yields on YieldType = Yields.Type inner join Improvements on OtherImprovementType = Improvements.Type where ImprovementType = ?");
}
pResults->Bind(1, szImprovementType, lenImprovementType, false);
while(pResults->Step())
{
const int yield_idx = pResults->GetInt(0);
CvAssert(yield_idx > -1);
const int improvement_idx = pResults->GetInt(1);
CvAssert(improvement_idx > -1);
const int yield = pResults->GetInt(2);
m_ppiAdjacentImprovementYieldChanges[improvement_idx][yield_idx] = yield;
}
pResults->Reset();
}
#endif
const int iNumTechs = GC.getNumTechInfos();
CvAssertMsg(iNumTechs > 0, "Num Tech Infos <= 0");
//TechYieldChanges
{
kUtility.Initialize2DArray(m_ppiTechYieldChanges, iNumTechs, iNumYields);
std::string strKey = "Improvements - TechYieldChanges";
Database::Results* pResults = kUtility.GetResults(strKey);
if(pResults == NULL)
{
pResults = kUtility.PrepareResults(strKey, "select Yields.ID as YieldID, Technologies.ID as TechID, Yield from Improvement_TechYieldChanges inner join Yields on YieldType = Yields.Type inner join Technologies on TechType = Technologies.Type where ImprovementType = ?");
}
pResults->Bind(1, szImprovementType, lenImprovementType, false);
while(pResults->Step())
{
const int yield_idx = pResults->GetInt(0);
CvAssert(yield_idx > -1);
const int tech_idx = pResults->GetInt(1);
CvAssert(tech_idx > -1);
const int yield = pResults->GetInt(2);
m_ppiTechYieldChanges[tech_idx][yield_idx] = yield;
}
}
//TechNoFreshWaterYieldChanges
{
kUtility.Initialize2DArray(m_ppiTechNoFreshWaterYieldChanges, iNumTechs, iNumYields);
std::string strKey = "Improvements - TechNoFreshWaterYieldChanges";
Database::Results* pResults = kUtility.GetResults(strKey);
if(pResults == NULL)
{
pResults = kUtility.PrepareResults(strKey, "select Yields.ID as YieldID, Technologies.ID as TechID, Yield from Improvement_TechNoFreshWaterYieldChanges inner join Yields on YieldType = Yields.Type inner join Technologies on TechType = Technologies.Type where ImprovementType = ?");
}
pResults->Bind(1, szImprovementType, lenImprovementType, false);
while(pResults->Step())
{
const int yield_idx = pResults->GetInt(0);
CvAssert(yield_idx > -1);
const int tech_idx = pResults->GetInt(1);
CvAssert(tech_idx > -1);
const int yield = pResults->GetInt(2);
m_ppiTechNoFreshWaterYieldChanges[tech_idx][yield_idx] = yield;
}
pResults->Reset();
}
//TechFreshWaterYieldChanges
{
kUtility.Initialize2DArray(m_ppiTechFreshWaterYieldChanges, iNumTechs, iNumYields);
std::string strKey = "Improvements - TechFreshWaterYieldChanges";
Database::Results* pResults = kUtility.GetResults(strKey);
if(pResults == NULL)
{
pResults = kUtility.PrepareResults(strKey, "select Yields.ID as YieldID, Technologies.ID as TechID, Yield from Improvement_TechFreshWaterYieldChanges inner join Yields on YieldType = Yields.Type inner join Technologies on TechType = Technologies.Type where ImprovementType = ?");
}
pResults->Bind(1, szImprovementType, lenImprovementType, false);
while(pResults->Step())
{
const int yield_idx = pResults->GetInt(0);
CvAssert(yield_idx > -1);
const int tech_idx = pResults->GetInt(1);
CvAssert(tech_idx > -1);
const int yield = pResults->GetInt(2);
m_ppiTechFreshWaterYieldChanges[tech_idx][yield_idx] = yield;
}
pResults->Reset();
}
//RouteYieldChanges
{
const int iNumRoutes = kUtility.MaxRows("Routes");
kUtility.Initialize2DArray(m_ppiRouteYieldChanges, iNumRoutes, iNumYields);
std::string strKey = "Improvements - RouteYieldChanges";
Database::Results* pResults = kUtility.GetResults(strKey);
if(pResults == NULL)
{
pResults = kUtility.PrepareResults(strKey, "select Yields.ID as YieldID, Routes.ID as RouteID, Yield from Improvement_RouteYieldChanges inner join Yields on YieldType = Yields.Type inner join Routes on RouteType = Routes.Type where ImprovementType = ?;");
}
pResults->Bind(1, szImprovementType, lenImprovementType, false);
while(pResults->Step())
{
const int yield_idx = pResults->GetInt(0);
CvAssert(yield_idx > -1);
const int route_idx = pResults->GetInt(1);
CvAssert(route_idx > -1);
const int yield = pResults->GetInt(2);
m_ppiRouteYieldChanges[route_idx][yield_idx] = yield;
}
pResults->Reset();
}
return true;
}
/// Read from XML file
bool CvImprovementEntry::CacheResults(Database::Results& kResults, CvDatabaseUtility& kUtility)
{
if(!CvBaseInfo::CacheResults(kResults, kUtility))
return false;
//Basic properties
const char* szArtDefineTag = kResults.GetText("ArtDefineTag");
SetArtDefineTag(szArtDefineTag);
m_iGoldMaintenance = kResults.GetInt("GoldMaintenance");
m_iCultureBombRadius = kResults.GetInt("CultureBombRadius");
m_iCultureAdjacentSameType = kResults.GetInt("CultureAdjacentSameType");
m_bHillsMakesValid = kResults.GetBool("HillsMakesValid");
m_bFreshWaterMakesValid = kResults.GetBool("FreshWaterMakesValid");
m_bRiverSideMakesValid = kResults.GetBool("RiverSideMakesValid");
m_bNoFreshWater = kResults.GetBool("NoFreshWater");
m_bRequiresFlatlands = kResults.GetBool("RequiresFlatlands");
m_bRequiresFlatlandsOrFreshWater = kResults.GetBool("RequiresFlatlandsOrFreshWater");
m_bRequiresFeature = kResults.GetBool("RequiresFeature");
m_bWater = kResults.GetBool("Water");
m_bCoastal = kResults.GetBool("Coastal");
m_bDestroyedWhenPillaged = kResults.GetBool("DestroyedWhenPillaged");
m_bBuildableOnResources = kResults.GetBool("BuildableOnResources");
m_eImprovementUsageType = m_bBuildableOnResources ? IMPROVEMENTUSAGE_LANDMARK : IMPROVEMENTUSAGE_BASIC;
m_bBarbarianCamp = kResults.GetBool("BarbarianCamp");
m_bGoody = kResults.GetBool("Goody");
m_bPermanent = kResults.GetBool("Permanent");
m_iTilesPerGoody = kResults.GetInt("TilesPerGoody");
m_iGoodyUniqueRange = kResults.GetInt("GoodyRange");
m_iFeatureGrowthProbability = kResults.GetInt("FeatureGrowth");
m_iUpgradeTime = kResults.GetInt("UpgradeTime");
m_iRiverSideUpgradeMod = kResults.GetInt("RiverSideUpgradeMod");
m_iCoastalLandUpgradeMod = kResults.GetInt("CoastalLandUpgradeMod");
m_iHillsUpgradeMod = kResults.GetInt("HillsUpgradeMod");
m_iFreshWaterUpgradeMod = kResults.GetInt("FreshWaterUpgradeMod");
m_iDefenseModifier = kResults.GetInt("DefenseModifier");
m_iNearbyEnemyDamage = kResults.GetInt("NearbyEnemyDamage");
m_iPillageGold = kResults.GetInt("PillageGold");
m_bOutsideBorders = kResults.GetBool("OutsideBorders");
m_bInAdjacentFriendly = kResults.GetBool("InAdjacentFriendly");
m_bCreatedByGreatPerson = kResults.GetBool("CreatedByGreatPerson");
m_bSpecificCivRequired = kResults.GetBool("SpecificCivRequired");
m_iResourceExtractionMod = kResults.GetInt("ResourceExtractionMod");
const char* szCivilizationType = kResults.GetText("CivilizationType");
m_eRequiredCivilization = (CivilizationTypes)GC.getInfoTypeForString(szCivilizationType, true);
//References
const char* szWorldsoundscapeAudioScript = kResults.GetText("WorldSoundscapeAudioScript");
if(szWorldsoundscapeAudioScript != NULL)
{
m_iWorldSoundscapeScriptId = gDLL->GetAudioTagIndex(szWorldsoundscapeAudioScript, AUDIOTAG_SOUNDSCAPE);
}
else
{
m_iWorldSoundscapeScriptId = -1;
Remark(1, "Warning: Missing soundscape definition in XML for feature: '%s'", GetType());
}
const char* szImprovementPillage = kResults.GetText("ImprovementPillage");
m_iImprovementPillage = GC.getInfoTypeForString(szImprovementPillage, true);
const char* szImprovementUpgrade = kResults.GetText("ImprovementUpgrade");
m_iImprovementUpgrade = GC.getInfoTypeForString(szImprovementUpgrade, true);
//Arrays
const char* szImprovementType = GetType();
const size_t lenImprovementType = strlen(szImprovementType);
kUtility.PopulateArrayByExistence(m_pbTerrainMakesValid,
"Terrains",
"Improvement_ValidTerrains",
"TerrainType",
"ImprovementType",
szImprovementType);
kUtility.PopulateArrayByExistence(m_pbFeatureMakesValid,
"Features",
"Improvement_ValidFeatures",
"FeatureType",
"ImprovementType",
szImprovementType);
kUtility.SetYields(m_piYieldChange, "Improvement_Yields", "ImprovementType", szImprovementType);
kUtility.SetYields(m_piAdjacentCityYieldChange, "Improvement_AdjacentCityYields", "ImprovementType", szImprovementType);
kUtility.SetYields(m_piAdjacentMountainYieldChange, "Improvement_AdjacentMountainYieldChanges", "ImprovementType", szImprovementType);
kUtility.SetYields(m_piCoastalLandYieldChange, "Improvement_CoastalLandYields", "ImprovementType", szImprovementType);
kUtility.SetYields(m_piFreshWaterChange, "Improvement_FreshWaterYields", "ImprovementType", szImprovementType);
kUtility.SetYields(m_piHillsYieldChange, "Improvement_HillsYields", "ImprovementType", szImprovementType);
kUtility.SetYields(m_piRiverSideYieldChange, "Improvement_RiverSideYields", "ImprovementType", szImprovementType);
kUtility.SetYields(m_piPrereqNatureYield, "Improvement_PrereqNatureYields", "ImprovementType", szImprovementType);
kUtility.SetFlavors(m_piFlavorValue, "Improvement_Flavors", "ImprovementType", szImprovementType);
{
//Initialize Improvement Resource Types to number of Resources
const int iNumResources = kUtility.MaxRows("Resources");
m_paImprovementResource = FNEW(CvImprovementResourceInfo[iNumResources], c_eCiv5GameplayDLL, 0);
kUtility.InitializeArray(m_piResourceQuantityRequirements, iNumResources);
std::string strResourceTypesKey = "Improvements - ResourceTypes";
Database::Results* pResourceTypes = kUtility.GetResults(strResourceTypesKey);
if(pResourceTypes == NULL)
{
pResourceTypes = kUtility.PrepareResults(strResourceTypesKey, "select Resources.ID, ResourceType, ResourceMakesValid, ResourceTrade, DiscoveryRand from Improvement_ResourceTypes inner join Resources on ResourceType = Resources.Type where ImprovementType = ?");
}
std::string strYieldResultsKey = "Improvements - YieldResults";
Database::Results* pYieldResults = kUtility.GetResults(strYieldResultsKey);
if(pYieldResults == NULL)
{
pYieldResults = kUtility.PrepareResults(strYieldResultsKey, "select Yields.ID, Yield from Improvement_ResourceType_Yields inner join Yields on YieldType = Yields.Type where ImprovementType = ? and ResourceType = ?");
}
pResourceTypes->Bind(1, szImprovementType, lenImprovementType, false);
while(pResourceTypes->Step())
{
const int idx = pResourceTypes->GetInt("ID");
CvImprovementResourceInfo& pResourceInfo = m_paImprovementResource[idx];
const char* szResourceType = pResourceTypes->GetText("ResourceType");
pResourceInfo.m_bResourceMakesValid = pResourceTypes->GetBool("ResourceMakesValid");
pResourceInfo.m_bResourceTrade = pResourceTypes->GetBool("ResourceTrade");
pResourceInfo.m_iDiscoverRand = pResourceTypes->GetInt("DiscoveryRand");
m_piResourceQuantityRequirements[idx] = pResourceTypes->GetInt("QuantityRequirement");
//Populate Yields for structure
kUtility.InitializeArray(pResourceInfo.m_piYieldChange, "Yields");
pYieldResults->Bind(1, szImprovementType, lenImprovementType, false);
pYieldResults->Bind(2, szResourceType, -1, false);
while(pYieldResults->Step())
{
const int yieldIdx = pYieldResults->GetInt("ID");
const int yield = pYieldResults->GetInt("Yield");
pResourceInfo.m_piYieldChange[yieldIdx] = yield;
}
pYieldResults->Reset();
}
pResourceTypes->Reset();
}
const int iNumYields = kUtility.MaxRows("Yields");
const int iNumTechs = GC.getNumTechInfos();
CvAssertMsg(iNumTechs > 0, "Num Tech Infos <= 0");
//TechYieldChanges
{
kUtility.Initialize2DArray(m_ppiTechYieldChanges, iNumTechs, iNumYields);
std::string strKey = "Improvements - TechYieldChanges";
Database::Results* pResults = kUtility.GetResults(strKey);
if(pResults == NULL)
{
pResults = kUtility.PrepareResults(strKey, "select Yields.ID as YieldID, Technologies.ID as TechID, Yield from Improvement_TechYieldChanges inner join Yields on YieldType = Yields.Type inner join Technologies on TechType = Technologies.Type where ImprovementType = ?");
}
pResults->Bind(1, szImprovementType, lenImprovementType, false);
while(pResults->Step())
{
const int yield_idx = pResults->GetInt(0);
CvAssert(yield_idx > -1);
const int tech_idx = pResults->GetInt(1);
CvAssert(tech_idx > -1);
const int yield = pResults->GetInt(2);
m_ppiTechYieldChanges[tech_idx][yield_idx] = yield;
}
}
//TechNoFreshWaterYieldChanges
{
kUtility.Initialize2DArray(m_ppiTechNoFreshWaterYieldChanges, iNumTechs, iNumYields);
std::string strKey = "Improvements - TechNoFreshWaterYieldChanges";
Database::Results* pResults = kUtility.GetResults(strKey);
if(pResults == NULL)
{
pResults = kUtility.PrepareResults(strKey, "select Yields.ID as YieldID, Technologies.ID as TechID, Yield from Improvement_TechNoFreshWaterYieldChanges inner join Yields on YieldType = Yields.Type inner join Technologies on TechType = Technologies.Type where ImprovementType = ?");
}
pResults->Bind(1, szImprovementType, lenImprovementType, false);
while(pResults->Step())
{
const int yield_idx = pResults->GetInt(0);
CvAssert(yield_idx > -1);
const int tech_idx = pResults->GetInt(1);
CvAssert(tech_idx > -1);
const int yield = pResults->GetInt(2);
m_ppiTechNoFreshWaterYieldChanges[tech_idx][yield_idx] = yield;
}
pResults->Reset();
}
//TechFreshWaterYieldChanges
{
kUtility.Initialize2DArray(m_ppiTechFreshWaterYieldChanges, iNumTechs, iNumYields);
std::string strKey = "Improvements - TechFreshWaterYieldChanges";
Database::Results* pResults = kUtility.GetResults(strKey);
if(pResults == NULL)
{
pResults = kUtility.PrepareResults(strKey, "select Yields.ID as YieldID, Technologies.ID as TechID, Yield from Improvement_TechFreshWaterYieldChanges inner join Yields on YieldType = Yields.Type inner join Technologies on TechType = Technologies.Type where ImprovementType = ?");
}
pResults->Bind(1, szImprovementType, lenImprovementType, false);
while(pResults->Step())
{
const int yield_idx = pResults->GetInt(0);
CvAssert(yield_idx > -1);
const int tech_idx = pResults->GetInt(1);
CvAssert(tech_idx > -1);
const int yield = pResults->GetInt(2);
m_ppiTechFreshWaterYieldChanges[tech_idx][yield_idx] = yield;
}
pResults->Reset();
}
//RouteYieldChanges
{
const int iNumRoutes = kUtility.MaxRows("Routes");
kUtility.Initialize2DArray(m_ppiRouteYieldChanges, iNumRoutes, iNumYields);
std::string strKey = "Improvements - RouteYieldChanges";
Database::Results* pResults = kUtility.GetResults(strKey);
if(pResults == NULL)
{
pResults = kUtility.PrepareResults(strKey, "select Yields.ID as YieldID, Routes.ID as RouteID, Yield from Improvement_RouteYieldChanges inner join Yields on YieldType = Yields.Type inner join Routes on RouteType = Routes.Type where ImprovementType = ?;");
}
pResults->Bind(1, szImprovementType, lenImprovementType, false);
while(pResults->Step())
{
const int yield_idx = pResults->GetInt(0);
CvAssert(yield_idx > -1);
const int route_idx = pResults->GetInt(1);
CvAssert(route_idx > -1);
const int yield = pResults->GetInt(2);
m_ppiRouteYieldChanges[route_idx][yield_idx] = yield;
}
pResults->Reset();
}
return true;
}
