I've been asked to think about language translation solution for the site I work for. It's a large database driven site.
Paying someone to to manually translate the content is not an option at this time so I'm experimenting with babelfish and google translators. An easy solution I've tested was using some flag icons to link through the translators however my boss wants the foreign language versions to be spiderable and show up in searches.
So I was thinking of maybe making a fetching script that would get the translated content and either write it to a static file or to the db and put it on a cron.
I'm drawing a blank on how to get a script to traverse all of our site's pages at the moment. Possibly I could set it up so that the first time someone went to a page that needed translation it would fetch and store and then subsequent visitors would go to the static page.
Anyone have any thoughts on this situation? This could probably turn into a pretty useful script for many sites if it works out.
The site I work for is www.gamerevolution.com if you want to see what I'm dealing with.