We have a website that we have been able to translate static texts to 3 local languages using locale_en.php locale_hz.php but we also want to provide translation for the contents posted by users to 3 different local languages. Unfortunately Google hasn't translated our native languages yet. We are looking at automatically detecting the texts on the page and provide some form of translation. We already have a mysql table with up to 130,000+ english words. Any pointers pls? Would really appreciate.
What you are asking is a rabbit hole you may not be ready to dive down.
Firstly. Automatic translation is not yet at a presentable level. (and some would argue may never be with our current style of computers.) You are overwhelmingly better off showing the wrong language than showing a poorly translated and unprofessional version of someone's native language.
The ideal way to get things translated is to provide an incentive for other users of your site to spend time hand-translating text. Or, using a service that will crowd-source the translation.
One example of that is: http://www.acclaro.com/crowdsourcing-translation
But there are many others.
Hope that helps.
It always was a problem, the best and accurate way is you have a language file to each language you need, in case os posts it is a little bit complex, if you have time you can translate by time in time, but it is not the best solution.
Another option is, google translate it for you, wordpress system have something on this way, take a look in word press language plugins.
Good question, unfortunately there are no good solutions to automatic translations unless you feel comfortable to use google translation for your users.
Good Luck.