Pathea Games Forums

Please login or register.

Login with username, password and session length
Advanced search  


Planet Explorers Released!

Author Topic: SQL command for auto-translation of repeated words[marked]  (Read 405 times)


  • Colonist
  • **
  • Karma: 2
  • Posts: 71
    • View Profile
SQL command for auto-translation of repeated words[marked]
« on: January 07, 2017, 12:42:41 PM »

This command that can be used in DB browser for SQLite in the tab "Execute SQL" can be very useful to translate words repeated in the translation file. First the English column must be duplicated and renamed as your translated language. Do also a backup of the file.

Code: [Select]
UPDATE translation SET language = replace( language, "OriginalString", "TranslatedString");

For Example, to translate IN ALL CELLS the string "Buying price:" in "Prezzo di Acquisto:" (italian translation) you can use this command:

Code: [Select]
UPDATE translation SET italiano = replace( italiano, "Buying price:", "Prezzo di Acquisto:");

I hope this can be useful to speed up all other translations! :)
« Last Edit: January 09, 2017, 05:48:31 AM by Dorist1 »


  • Enlistee
  • *
  • Karma: 0
  • Posts: 2
    • View Profile
Re: SQL command for auto-translation of repeated words
« Reply #1 on: January 07, 2017, 05:31:56 PM »

You are a Saint! Thank you!
I've logged in to complain about how hopeless it is to try and translate this game from scratch.
It really needs a cleanup, there are some strings that are clearly unused since early alpha.