is it possable to to selective translation

someone100 · 09-30-2008, 03:59 AM

is it possable to to selective translation* of one

field in one table in mysql database ?

*converting from one lang to another using google translation .

archgames · 09-30-2008, 09:53 AM

not with google translation
but you might be with a custom script of something idk

someone100 · 09-30-2008, 09:56 AM

google has very good translation !!!

hawkal · 09-30-2008, 04:43 PM

After a little bit of testing I am 98% sure it is possible but it's a job for an advanced php coder. Luckily for you google has already thought of this and have written an AJAX language API http://code.google.com/apis/ajaxlanguage/documentation/#Examples .

someone100 · 10-01-2008, 01:29 AM

wow !!!!!!!! you are the man !!!!!

thanks
all that left is find the pull out and updateing one script in same script.

hawkal · 10-01-2008, 03:10 AM

your welcome.

someone100 · 10-01-2008, 08:06 AM

hawkal , do you have some simple script to pull out data from mysql data base and after the translation the data will be updated ?

someone100 · 10-19-2008, 07:21 PM

deleted the code .

hawkal · 10-20-2008, 05:55 PM

I don't use javascript but by the looks of it the javascript references the "translation" div as placement for the text. The problem is that because your out putting lots of games (like a category page) the text couldn't be all in the same place. I think google have over complicated the translation funtion because what I thought that you could of done was to create another field in your database for the different language then loop through the existing descriptions updating the new field with the translated text but while I am sure it is possible to do this the best way I can think of doing that would be complex and probably long winded due to my lack of javascript knowledge.

I might look at this again when I have time but I doubt I'll be able to help.

Just a side note

This is all the javascript you should need because you shouldn't need to detect the original language unless all of your descriptions are in lots of different languages that is.

HTML Code:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <meta http-equiv="content-type" content="text/html; charset=utf-8"/>
    <title>Google AJAX Language API - Basic Translation</title>
    <script type="text/javascript" src="http://www.google.com/jsapi"></script>
    <script type="text/javascript">

    google.load("language", "1");

    function initialize() {
      google.language.translate("Hello world", "en", "es", function(result) {
        if (!result.error) {
          var container = document.getElementById("translation");
          container.innerHTML = result.translation;
        }
      });
    }
    google.setOnLoadCallback(initialize);

    </script>
  </head>
  <body>
    <div id="translation"></div>
  </body>
</html>

someone100 · 10-21-2008, 04:09 AM

thanks a lot !!!!!

09-30-2008, 03:59 AM	#1 (permalink)
someone100 Contributing Member Join Date: Sep 2008 Posts: 30 iTrader: (0)	is it possable to to selective translation *is it possable to to selective translation of one** field in one table in mysql database ? *converting from one lang to another using google translation .

09-30-2008, 09:53 AM	#2 (permalink)
archgames Senior Member Join Date: Jan 2008 Posts: 904 iTrader: (0)	not with google translation but you might be with a custom script of something idk __________________ Best Ad Networks : ValueClickMedia \| Adsense Arcades : Free Flash Games Best arcade Host : HostGator \| Hostmonster 4.95$ a mo great stuff! Webmaster? : Trade 1:1 Traffic Best Arcade Script : PHParcadeScript (includes 2.7k Games) /\/\ My Recommendations....

09-30-2008, 04:43 PM	#4 (permalink)
hawkal Senior Member Join Date: May 2007 Posts: 208 iTrader: (0)	After a little bit of testing I am 98% sure it is possible but it's a job for an advanced php coder. Luckily for you google has already thought of this and have written an AJAX language API http://code.google.com/apis/ajaxlanguage/documentation/#Examples . __________________ www.ownage.us www.Allarcade.us

10-01-2008, 03:10 AM	#6 (permalink)
hawkal Senior Member Join Date: May 2007 Posts: 208 iTrader: (0)	your welcome. __________________ www.ownage.us www.Allarcade.us

10-19-2008, 07:21 PM	#8 (permalink)
someone100 Contributing Member Join Date: Sep 2008 Posts: 30 iTrader: (0)	deleted the code . Last edited by someone100 : 10-21-2008 at 04:08 AM.

09-30-2008, 09:56 AM	#3 (permalink)
someone100 Contributing Member Join Date: Sep 2008 Posts: 30 iTrader: (0)	google has very good translation !!!

10-01-2008, 01:29 AM	#5 (permalink)
someone100 Contributing Member Join Date: Sep 2008 Posts: 30 iTrader: (0)	wow !!!!!!!! you are the man !!!!! thanks all that left is find the pull out and updateing one script in same script.

10-01-2008, 08:06 AM	#7 (permalink)
someone100 Contributing Member Join Date: Sep 2008 Posts: 30 iTrader: (0)	hawkal , do you have some simple script to pull out data from mysql data base and after the translation the data will be updated ?

10-20-2008, 05:55 PM	#9 (permalink)
hawkal Senior Member Join Date: May 2007 Posts: 208 iTrader: (0)	I don't use javascript but by the looks of it the javascript references the "translation" div as placement for the text. The problem is that because your out putting lots of games (like a category page) the text couldn't be all in the same place. I think google have over complicated the translation funtion because what I thought that you could of done was to create another field in your database for the different language then loop through the existing descriptions updating the new field with the translated text but while I am sure it is possible to do this the best way I can think of doing that would be complex and probably long winded due to my lack of javascript knowledge. I might look at this again when I have time but I doubt I'll be able to help. Just a side note This is all the javascript you should need because you shouldn't need to detect the original language unless all of your descriptions are in lots of different languages that is. HTML Code: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="content-type" content="text/html; charset=utf-8"/> <title>Google AJAX Language API - Basic Translation</title> <script type="text/javascript" src="http://www.google.com/jsapi"></script> <script type="text/javascript"> google.load("language", "1"); function initialize() { google.language.translate("Hello world", "en", "es", function(result) { if (!result.error) { var container = document.getElementById("translation"); container.innerHTML = result.translation; } }); } google.setOnLoadCallback(initialize); </script> </head> <body> <div id="translation"></div> </body> </html> __________________ www.ownage.us www.Allarcade.us

10-21-2008, 04:09 AM	#10 (permalink)
someone100 Contributing Member Join Date: Sep 2008 Posts: 30 iTrader: (0)	thanks a lot !!!!!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode