vB Global Translator - Multiply your indexed pages & put search traffic on autopilot
 

v1.x Upgrade instructions:

Delete your old translate database
Delete translate.php, translateflags.php and overloadcache.txt
Delete both translate plugins
Delete code added to header, footer or navbar template
Delete /flags/ folder

Follow the install instructions above

This version requires a fresh install.

Features coming in next version:

* Meta description and meta keywords will be translated in the output source code, better for SEO and search engine indexing

Can you add language vietnamese ?? :D

Looks great! Sending a donation over to NLP-er in a moment :) Thanks for this Dave! Blimey it is much more faster once cached than the old script, great work!

This is awesome! Thanks!

Thanks, DB speed credits to NLP-er, I'm sure he will be happy with the donation.

It honestly is a vast improvement, it may take a while on the first load but once its cached the page loads in a matter of seconds :up:

There is a problem or I may be getting this wrong, the Chinese simplified shows it all like this:

电脑，游戏和技术 （ 1查看）
青少年交谈，并获得咨询有关的游戏，电脑，技术和更多的对我们的青少年论坛。

Is that right?

Caching will always take some time, there is work to be done, the page is being translated on the fly but this version makes caching faster to, as much as possible.

What is wrong with Chinese? Looks like Chinese to me he he.

I wasnt sure if it was chinese lol just looks like a load of odd symbols with numbers on them to me :D

It is much faster once the pages have been cached. Just tested it and it only takes a few seconds to translate not 30 seconds once cached etc :)

Having so many new pages (translated pages) in your website might raise red flags for Google.

Do you think this is legit with Google TOS ?

Nevertheless, this is a brilliant idea.
Thanks for your time.

Yep, it's pretty much perfect speed wise on my forums.

I just check your forum, Chinese and all others for that matter are working fine.

Thanks.

shouldnt you have a english flag on there? there is no way to goto english if ur in another language. if someone clicks the language by accident they wouldnt know how to go back to english.

It is bad for SEO so it is best removed, I am sure they could easily click your logo or something to get back :)

It is probably a grey area, it's original content and was once created by members so is not technically automated or junk content.

There have been similar scripts before I did this for vB, the other scripts has issues but did work. A few friends and I have been using these other scripts that are out for years and never had anything bad happen.

Although this idea may be new to you and others, it's been around a long time, other coders tried using the actual Google Translate website, this was slow and buggy but did work. Goggles new Translate API service is why I thought I'd try my luck.

If you click any url is goes back to your base language anyway. Most people only view one page, so it really doesn't matter.

Dave I have a question, is this purely for the SE's or do you think foreign signed in members will find it useful too? I am considering allowing only guests to view the flags, what do you think? :)

I only show the flags to guests, this is machine translation, so, the bots will love it and send you visits, but, those visits will read and understand what they can (it's pretty good but not perfect) but are unlikely to stick around for long, unless they can speak you base language. As I have said before, if you want to add different language forums to your site do just that, make the forums, get a foreign moderator and install some language packs. This is machine translation for traffic and ad revenue pretty much. I make tons extra $$ with it and it didn't take any extra work to write the 1,000's of pages of content, that was it's goal when I designed it. Nothing else. ;P

I hope this helps.

i cant get this to work. ive installed it, done the DB stuff. when i click a flag nothing happens, its just loading and does nothing. no data is being written to the mysql DB.

Do you have CURL enabled on your site?

Could also ask you host to turn on php errors in the browser so you get an error message.

cURL support enabled
cURL Information libcurl/7.19.3 OpenSSL/0.9.8b zlib/1.2.3 libidn/0.6.5

how long does it take to start re-writting all the data? i see now see something in the wt_cache_short table but nothing else is going on.

As soon as you click a flag it should start adding data. If it's adding data it's working. 1st time translations are not instant, the words have to be sent to google and then translated, then returned and put in the DB, 2nd page load is normal speed. It will take a few weeks to cache your entire site.

What is your URL?

please check ur PM inbox.

so this doesnt automatically start indexing the new language? the flags have to be clicked on by someone when they are in a thread in order to get the new language indexing to go?

The search bots follow the flags and activate the translation, you do not need to do a thing aside from test it.

Some questions :

1. If you have a English board and someone write a Post/Reply in Chinese or Hebrew - what you do with that ?
   for example i have a Hebrew forums so what the members can do with other language, if someone from China write to them?
2. what going do happen do the data if i :
   Data Usage - 1.81 GB
   Index Usage - 963.42 MB
   Members - 117,205
   Post - 266,431
   Reply - 1,479,829

This is a translator, your members can still post in the same languages that you currently allow. No different. It doesn't change how vB works.

here is a error i am getting in the phmyadmin. when i goto reload the db to see if anything is being added to the 3 tables i see this error right now:

Error
SQL query:
SHOW CHARACTER SET;
MySQL said:
#5 - Out of memory (Needed 1677360 bytes)

It's particular to your host so send their support a message explaining that you are getting that error when running a cron. Possibly they need to up your php memory limit or something.

thank you so much

testing this on a different site on a different server i am getting this error when i click the flags:

Fatal error: Call to undefined function mysql_set_charset() in /home/SITE/public_html/forum/translate.php on line 35

You're welcome! :D

Hi, Dave. Are you remember me?

Great job! Now it's works on my site without change hosting.
1st time works very slow, 2nd, 3rd... works ok. Server is cheap ;)

I have only one problem but my admin can fix it.
THX again.

what would be causing this error on a different site and server?

Your host is being over-protective, imo, get a new host. ;P

interesting...but people will be tempted to post in their native language
i wonder how much the database will grow...

its not very easy to install this and, i think ill wait untill you make an easier install but i`ll keep my eye on this :-)

great work and great idea so far !

As soon as they hit reply the script throws them back to the vbulletin database and your base language, so i doubt it. They are also smart enough to know it's a machine translation.

I don't see why people worry so much about such trivial things, users don't do it on my sites and if they did I'd just delete the post.

Your vB databases will not grow anymore than normal as this does not interfere with vB, the translate database only holds sentences so will grow no larger than a normal vbulletin DB, if not much less!

Actually the install looks more complex than it is, give it a try, you can always revert your changes.

I hope this answers your concerns. :)

Nice idea but I couldn't get it to work. When I click on a flag I get a white screen :(

Is CURL enabled on your server?

Yes