Difference between revisions of "TechObjectDatabase.xml"
From BotF2-Wiki
(Added: Output-Types of Buildings) |
(→CSV2XML) |
||
| (15 intermediate revisions by one user not shown) | |||
| Line 5: | Line 5: | ||
see also [http://botf2.square7.ch/b2_db/Buildings.php Database] | see also [http://botf2.square7.ch/b2_db/Buildings.php Database] | ||
| + | __TOC__ | ||
How to extract for example Ships: | How to extract for example Ships: | ||
| Line 12: | Line 13: | ||
*mark up to begin of file but let first line untouched (so <pro...until </pro... is marked -> delete it | *mark up to begin of file but let first line untouched (so <pro...until </pro... is marked -> delete it | ||
*at least open with Excel | *at least open with Excel | ||
| + | |||
| + | == Adding new items == | ||
| + | |||
| + | make always sure you have the same keys in | ||
| + | *[[TechObjectDatabase.xml]] | ||
| + | *[[TextDatabase.xml]] | ||
| + | *[[TechTrees.xml]] | ||
| + | |||
| + | *don't forget the image file | ||
== Buildings == | == Buildings == | ||
| Line 43: | Line 53: | ||
*[[Raw Materials|RawMaterials]]([[Duranium]]) + PercentRawMaterials: [http://botf2.square7.ch/b2_db/BuildingsRawMaterials.php Database-List] | *[[Raw Materials|RawMaterials]]([[Duranium]]) + PercentRawMaterials: [http://botf2.square7.ch/b2_db/BuildingsRawMaterials.php Database-List] | ||
*[[Dilithium]]: [http://botf2.square7.ch/b2_db/BuildingsDilithium.php Database-List] | *[[Dilithium]]: [http://botf2.square7.ch/b2_db/BuildingsDilithium.php Database-List] | ||
| − | *[[GrowthRate]] + PercentGrowthRate: [http://botf2.square7.ch/b2_db/BuildingsGrowthRate.php Database-List] | + | *[[Planet#Growth Rate|GrowthRate]] + PercentGrowthRate: [http://botf2.square7.ch/b2_db/BuildingsGrowthRate.php Database-List] |
*[[Morale]]: [http://botf2.square7.ch/b2_db/BuildingsMorale.php Database-List] | *[[Morale]]: [http://botf2.square7.ch/b2_db/BuildingsMorale.php Database-List] | ||
*[[Morale]]EmpireWide: [http://botf2.square7.ch/b2_db/BuildingsMorale.php Database-List] | *[[Morale]]EmpireWide: [http://botf2.square7.ch/b2_db/BuildingsMorale.php Database-List] | ||
| Line 53: | Line 63: | ||
more Buildings by output (alphabetically): | more Buildings by output (alphabetically): | ||
| − | *[[AntiShipDefense]] + PercentAntiShipDefense: [http://botf2.square7.ch/b2_db/BuildingsAntiShipDefense.php Database-List] | + | *[[System#AntiShipDefense|AntiShipDefense]] + PercentAntiShipDefense: [http://botf2.square7.ch/b2_db/BuildingsAntiShipDefense.php Database-List] |
| − | *[[BribeResistance]] + PercentBribeResistanceEmpireWide: [http://botf2.square7.ch/b2_db/BuildingsBribeResistance.php Database-List] | + | *[[Bribe|BribeResistance]] + PercentBribeResistanceEmpireWide: [http://botf2.square7.ch/b2_db/BuildingsBribeResistance.php Database-List] |
| − | *[[ExternalAffairs]] + PercentExternalAffairs: [http://botf2.square7.ch/b2_db/BuildingsExternalAffairs | + | *[[Manual#Intel Panel|ExternalAffairs]] + PercentExternalAffairs: [http://botf2.square7.ch/b2_db/BuildingsExternalAffairs.php Database-List] |
| − | + | *[[Intercept]] + PercentIntercept: [http://botf2.square7.ch/b2_db/BuildingsIntercept.php Database-List] (no building at the moment) | |
| − | *[[Intercept]] + PercentIntercept: [http://botf2.square7.ch/b2_db/BuildingsIntercept.php Database-List] | + | *[[Manual#Intel Panel|InternalAffairs]] + PercentInternalAffairs: [http://botf2.square7.ch/b2_db/BuildingsInternalAffairs.php Database-List] |
| − | *[[InternalAffairs]] + PercentInternalAffairs: [http://botf2.square7.ch/b2_db/BuildingsInternalAffairs.php Database-List] | + | *[[Scan|JammingRange]]: [http://botf2.square7.ch/b2_db/BuildingsJammingRange.php Database-List] |
| − | *[[JammingRange]]: [http://botf2.square7.ch/b2_db/BuildingsJammingRange.php Database-List] | + | *[[Moon|MaxPopulationPerMoonSize]]: [http://botf2.square7.ch/b2_db/BuildingsMaxPopulationPerMoonSize.php Database-List] |
| − | *[[MaxPopulationPerMoonSize]]: [http://botf2.square7.ch/b2_db/BuildingsMaxPopulationPerMoonSize.php Database-List] | + | *[[Scan|PercentAntiCloak]]: [http://botf2.square7.ch/b2_db/BuildingsPercentAntiCloak.php Database-List] |
| − | *[[PercentAntiCloak]]: [http://botf2.square7.ch/b2_db/BuildingsPercentAntiCloak.php Database-List] | + | *[[System_Assault#GroundCombat|PercentGroundCombat]]: [http://botf2.square7.ch/b2_db/BuildingsGroundCombat+Defense.php Database-List] |
| − | *[[PercentGroundCombat]]: [http://botf2.square7.ch/b2_db/BuildingsGroundCombat+Defense.php Database-List] | + | *[[System_Assault#GroundCombat|PercentGroundDefense]]: [http://botf2.square7.ch/b2_db/BuildingsGroundCombat+Defense.php Database-List] |
| − | *[[PercentGroundDefense]]: [http://botf2.square7.ch/b2_db/BuildingsGroundCombat+Defense.php Database-List] | + | *[[Planet#Population Health|PercentPopulationHealth]]: [http://botf2.square7.ch/b2_db/BuildingsPercentPopulationHealth.php Database-List] |
| − | *[[PercentPopulationHealth]]: [http://botf2.square7.ch/b2_db/BuildingsPercentPopulationHealth.php Database-List] | + | *[[Ships#ShipBuilding|PercentScrapping]]: [http://botf2.square7.ch/b2_db/BuildingsPercentScrapping.php Database-List] |
| − | *[[PercentScrapping]]: [http://botf2.square7.ch/b2_db/BuildingsPercentScrapping.php Database-List] | + | *[[Ships#ShipBuilding|PercentShipBuilding]]: [http://botf2.square7.ch/b2_db/BuildingsPercentShipBuilding.php Database-List] |
| − | *[[PercentShipBuilding]]: [http://botf2.square7.ch/b2_db/BuildingsPercentShipBuilding.php Database-List] | + | *[[Ships#Experience|PercentShipExperience]]: [http://botf2.square7.ch/b2_db/BuildingsPercentShipExperience.php Database-List] |
| − | *[[PercentShipExperience]]: [http://botf2.square7.ch/b2_db/BuildingsPercentShipExperience | + | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | *[[Resource#Personnel|Personnel]] + PercentPersonnelLoyalty + PercentPersonnelTraining: [http://botf2.square7.ch/b2_db/BuildingsPersonnel.php Database-List] (no building at the moment) | |
| − | *[[ | + | *[[System#PlanetaryShielding|PlanetaryShielding]] + PercentPlanetaryShielding + ShieldPerEnergyTech: [http://botf2.square7.ch/b2_db/BuildingsPlanetaryShielding.php Database-List] |
| − | *[[ | + | *[[Raid|Raiding]] + PercentRaiding: [http://botf2.square7.ch/b2_db/BuildingsRaiding.php Database-List] |
| + | *[[Scan|ScanRange]]: [http://botf2.square7.ch/b2_db/BuildingsScanRange.php Database-List] and NEW: +PercentScanRange (see https://bitbucket.org/mstrobel/supremacy/issue/15/new-bonus-scanrange ) | ||
| + | *[[Trade Route|TradeRoutes]] + [[Trade Route#PercentTradeIncome|PercentTradeIncome]]: [http://botf2.square7.ch/b2_db/BuildingsTradeRoutes.php Database-List] | ||
| + | |||
| + | [[Research]]: [http://botf2.square7.ch/b2_db/BuildingsResearch.php Database-List] | ||
| + | *Research | ||
| + | *PercentResearchEmpireWide: | ||
*PercentBioTechResearch | *PercentBioTechResearch | ||
*PercentComputerResearch | *PercentComputerResearch | ||
| Line 83: | Line 94: | ||
*PercentWeaponsResearch | *PercentWeaponsResearch | ||
| − | Intelligence: | + | [[Intel|Intelligence]]: [http://botf2.square7.ch/b2_db/BuildingsIntelligence.php Database-List] |
| + | *Intelligence | ||
*PercentIntelligence | *PercentIntelligence | ||
*PercentGeneralIntelligence | *PercentGeneralIntelligence | ||
*PercentTotalIntelligence | *PercentTotalIntelligence | ||
| − | Security: | + | [[Security]]: [http://botf2.square7.ch/b2_db/BuildingsSecurity.php Database-List] |
*PercentEconomicSecurity | *PercentEconomicSecurity | ||
*PercentInternalSecurity | *PercentInternalSecurity | ||
| − | Sabotage: | + | [[Sabotage]]: [http://botf2.square7.ch/b2_db/BuildingsSabotage.php Database-List] |
*PercentSabotage | *PercentSabotage | ||
*PercentEconomicSabotage | *PercentEconomicSabotage | ||
| Line 98: | Line 110: | ||
*PercentPoliticalSabotage | *PercentPoliticalSabotage | ||
| − | + | == CSV2XML == | |
| − | * | + | |
| − | * | + | We're trying to create the TechObjectDatabase.xml out of a Google Sheet.... this are the steps |
| − | * | + | |
| + | * activate ADD-On for XML-Export | ||
| + | * doing the export by ADDON > EXPORT and save it to c:\_B2 (or do the next three steps) | ||
| + | ** open the file | ||
| + | ** on top: Open with (you might use XML EDITEY) | ||
| + | ** CopyPaste the whole stuff into C:\_B2\Balance - Export_New.xml | ||
| + | * run special Visual Studio app for replacements | ||
| + | * delete head line of output file !!! | ||
| + | |||
| + | |||
| + | |||
Latest revision as of 16:56, 4 August 2018
Folder: \Data
see also Database
Contents
How to extract for example Ships:
- copy file to Tech_date.xml
- edit with Notepad++
- search for </productionfacilities> -> that's the end of buildings
- mark up to begin of file but let first line untouched (so <pro...until </pro... is marked -> delete it
- at least open with Excel
Adding new items
make always sure you have the same keys in
- TechObjectDatabase.xml
- TextDatabase.xml
- TechTrees.xml
- don't forget the image file
Buildings
data fields:
- Key
- BioTech
- Construction (Tech)
- Energy (Tech)
- Computers (Tech)
- Weapons (Tech)
- Propulsion (Tech)
- BuildCost
- IsUniversallyAvailable
- TRUE (German: "WAHR")
- FALSE (German: "FALSCH")
- EnergyCost
- Restriction
- Type
- Amount
- ObsoletedItem
- UpgradeOption
- Prerequisite
- BuildCondition
Types
Buildings by output:
- Credits + PercentCredits + PercentTotalCredits: Database-List
- Deuterium + PercentDeuterium: Database-List
- RawMaterials(Duranium) + PercentRawMaterials: Database-List
- Dilithium: Database-List
- GrowthRate + PercentGrowthRate: Database-List
- Morale: Database-List
- MoraleEmpireWide: Database-List
- Food + PercentFood: Database-List
- Industry + PercentIndustry: Database-List
- Energy + PercentEnergy: Database-List
- Research: for more see also below "Research" Database-List
more Buildings by output (alphabetically):
- AntiShipDefense + PercentAntiShipDefense: Database-List
- BribeResistance + PercentBribeResistanceEmpireWide: Database-List
- ExternalAffairs + PercentExternalAffairs: Database-List
- Intercept + PercentIntercept: Database-List (no building at the moment)
- InternalAffairs + PercentInternalAffairs: Database-List
- JammingRange: Database-List
- MaxPopulationPerMoonSize: Database-List
- PercentAntiCloak: Database-List
- PercentGroundCombat: Database-List
- PercentGroundDefense: Database-List
- PercentPopulationHealth: Database-List
- PercentScrapping: Database-List
- PercentShipBuilding: Database-List
- PercentShipExperience: Database-List
- Personnel + PercentPersonnelLoyalty + PercentPersonnelTraining: Database-List (no building at the moment)
- PlanetaryShielding + PercentPlanetaryShielding + ShieldPerEnergyTech: Database-List
- Raiding + PercentRaiding: Database-List
- ScanRange: Database-List and NEW: +PercentScanRange (see https://bitbucket.org/mstrobel/supremacy/issue/15/new-bonus-scanrange )
- TradeRoutes + PercentTradeIncome: Database-List
- Research
- PercentResearchEmpireWide:
- PercentBioTechResearch
- PercentComputerResearch
- PercentConstructionResearch
- PercentEnergyResearch
- PercentPropulsionResearch
- PercentWeaponsResearch
- Intelligence
- PercentIntelligence
- PercentGeneralIntelligence
- PercentTotalIntelligence
- PercentEconomicSecurity
- PercentInternalSecurity
- PercentSabotage
- PercentEconomicSabotage
- PercentMilitarySabotage
- PercentPoliticalSabotage
CSV2XML
We're trying to create the TechObjectDatabase.xml out of a Google Sheet.... this are the steps
- activate ADD-On for XML-Export
- doing the export by ADDON > EXPORT and save it to c:\_B2 (or do the next three steps)
- open the file
- on top: Open with (you might use XML EDITEY)
- CopyPaste the whole stuff into C:\_B2\Balance - Export_New.xml
- run special Visual Studio app for replacements
- delete head line of output file !!!
