Skip to content

Localized Text revamp

Compare
Choose a tag to compare
@GrantSP GrantSP released this 13 Mar 04:36

See the following for the changelog: #193

Why the change?

With this release we bring the localized text into being a fully functioned option, not subject to obscure checking methods.

Each language in Civ V has its own database table, German = Language_DE_DE, Spanish = Language_ES_ES etc.
Previously we had all text files loaded into one database and then checked a date tag to see which language was the latest and gave that one to the user for display.
The logic behind this was to provide accurate information even if it was in an unfamiliar language.
That was the logic.

After the release of the so-called "Fall patch" the core files from Firaxis broke the code used to implement this and we have had to re-tune our code to adjust.
This is the result.

What has changed?

  • CAT_Start.sql now sets up the LoadedFile table with a column for each language. When the UPDATE LoadedFile SET command is run it also checks which language the file is for and adds it as loaded into this table. Allowing for better error-checking.
  • CAT_AlterTables.sql has the redundant CEP_Language_ tables removed.
  • Core text files now have a unified sql command to insert them into the appropriate language table.
  • Over 20 text files for each language (10 including English).
  • Instructions on how to update the translations if needed.

Things to look out for.

Whilst every effort was made to ensure as accurate a translation as possible, the actual Google translation routine still had trouble handling certain things. These might slip through the hand edit done in the text editor.

  • Variables in the format [ICON_SOMEWORD] don't always get handled well in some languages, notably French & Chinese
  • Likewise those in the format {1_num} and similar
  • Especially is this true when multiple variables are in sequence such as [ICON_GOLD]{1_num}{2_value}[COLOR_RED]
  • Leading symbols such as "+" or "-" aren't showing in some languages. This may be because those languages usually don't display them this way. Native speakers would do well to make note of this and advise us.
    The formula in the spreadsheets has now stripped out the trailing text from the foreign versions. In each language text these variables now only are in the format: {1}. The "_num" is not actually recognized by the game code, only the number.

If you make edits manually to the TXT_KEYs make note of these for checking.

This release incorporates all the edits made to the New Features branch over the last few months.
It is however not an Official stable release and may have some issues.

As it makes drastic changes to the existing tables it should not be used with saved games.

Minor Update
One or two non-critical changes to the mod.
Fixed some file loading errors and included a couple of orphaned changes from the Stable branch.

Trade-route gold fix
YieldLibrary.lua change to address the trade gold issue.