I hope this will help many tool developers!
osimulate.com/uploads/ogame_strings.rar
or
osimulate.com/uploads/ogame_strings.zip
The archive contains 2 files:
SQL file to generate and populate a simple database with 2 tables: Languages and ItemTranslations
CSV file that contains the join of the tables
Display Spoiler
SELECT ItemTranslations.Id, ItemTranslations.TechId, ItemTranslations.Text, Languages.Name,Languages.ShortName, Languages.Host FROM ItemTranslations INNER JOIN
Languages ON ItemTranslations.Language_Id = Languages.Id
The fields of ItemTranslation table are:
The fields of Language table are:
The tables are linked by one relationship that maps to a country all the localized items.
The strings were retrieved directly from OGame interface in an automated way.
There are 58 strings for each of the 28 countries, which leads to 1624 strings overall.
Now the tool developers have a complete and precise database of ships, defenses, buildings and techs of OGame items translated in ALL languages.
Tips & Tricks Corner: 5 ranges of TechIds can be identified:
1 - 44: Buildings
106 - 199: Techs
202 - 215: Ships
502 - 503: Missiles
401 - 408: Defenses
I dont know why gameforge hasn't done something like this before...
osimulate.com/uploads/ogame_strings.rar
or
osimulate.com/uploads/ogame_strings.zip
The archive contains 2 files:
SQL file to generate and populate a simple database with 2 tables: Languages and ItemTranslations
CSV file that contains the join of the tables
SELECT ItemTranslations.Id, ItemTranslations.TechId, ItemTranslations.Text, Languages.Name,Languages.ShortName, Languages.Host FROM ItemTranslations INNER JOIN
Languages ON ItemTranslations.Language_Id = Languages.Id
The fields of ItemTranslation table are:
- Id: Primary key of the table, not important
- Text: The localized text of the item
- TechId: The OGame Id of the Item
The fields of Language table are:
- Id: Primary key of the table, not important
- Name: The Name of the country
- Host: The Homepage of OGame in that country
- ShortName: The country code
The tables are linked by one relationship that maps to a country all the localized items.
The strings were retrieved directly from OGame interface in an automated way.
There are 58 strings for each of the 28 countries, which leads to 1624 strings overall.
Now the tool developers have a complete and precise database of ships, defenses, buildings and techs of OGame items translated in ALL languages.
Tips & Tricks Corner: 5 ranges of TechIds can be identified:
1 - 44: Buildings
106 - 199: Techs
202 - 215: Ships
502 - 503: Missiles
401 - 408: Defenses
I dont know why gameforge hasn't done something like this before...
The post was edited 2 times, last by _HeDo ().