The Arcive of Official vBulletin Modifications Site.

About Developer · **Released**: 06-14-2009

vB Global Translator

Note - There are 2 versions of this script depending on your setup. This script is compatible with users running standard vBulletin and vBSEO only and all vB release versions. If you cannot install this I am more than happy to answer support questions.

So what does this do?

vB Global Translator automatically translates your forum into 28 other languages via the Google translate API, stores those translations in a MYSQL database then rewrites new URLs so you end up with 28 new pages for every current page.

So, if you have 10,000 pages, this MOD will translate those pages into 28 languages making a total of 280,000 pages in 28 languages. This results in a flood of international traffic and referrals from the search engines. If you are getting 1,000 visits a day from your 10,000 pages imagine how many referrals you will get from 280,000 pages!

The current languages this MOD works with are all supported by AdSense so you can expect your income to rise accordingly. I have this running on a 20,000 page forum and after a few months I have more than doubled my search engine traffic.

How do I Install?

Note - Please make sure you have CURL enabled on your server, it will be listed in you php.ini file. If in doubt ask your host.

First download the relevant package below for your setup.

Next you need to add a new MySQL database to your domain to store the translated pages. Open the database in phpmyadmin or similar and import the db.sql file to install the database tables. Once you have done that you need to select the 'wt_cache' table on the left then 'operations' from the top menu and change the storage engine to InnoDB, then click Go.

Add your new database details to translate.php then, if your forums base language is different to English, change your country code. Otherwise ignore this step.

Find:

Code:

REMOVED

Change en to:

Code:

REMOVED

Next save translate.php and upload that, translateflags.php and overloadcache.txt to your forum root, so if your forums are in a /forums/ folder upload these files there. Upload the flags folder to your domain root, thats the domain root.

CHMOD overloadcache.txt to 777

In your vBulletin admin panel add a new plugin with the following settings.

Hook Location: global_complete
Title: vB Global Translator
Execution Order: 5
Plugin PHP Code:

Code:

REMOVED

Save the plugin and activate.

In your vBulletin admin panel add another new plugin with the following settings.

Hook Location: global_start
Title: vB Global Translator Flags
Execution Order: 5
Plugin PHP Code:

Code:

REMOVED

Save and activate.

Finally add the code below to your template so the flags to select languages appear. This is typically the header, navbar or footer so that they display on every page.

Code:

REMOVED

Load Issues:

This script is can be quite server intensive for large sites. As you are adding links to all of these new pages from all of your current pages the search engine bots will crawl these 1,000's of new pages fast. As the MySQL trys to deal with the many, many translations and querys I have seen my server load spike a bit.

To combat this we have written in a condition that if server load is more than 1.5, the cache setting will disable and pages will be read live from the Google API and no database writing will take place.

If you feel this setting too high/low you can change it by finding the variable below in translate.php and editing accordingly. The only reason to change this is if - A) You are on a slow server and it is overloaded/crashing or B) You have a very fast server and it can handle more, this will mean your site will get fully cached faster resulting in faster page load times when people re-visit the translated pages.

Code:

if(floatval(getServerLoad()) >= 1.5)

One final thing to remember is while your site is being cached and data written to the new database read access times to already cached pages may vary. Uncached pages need to be translated and this can take time when translating a fresh page. Cached pages may load fast or slow depending on whether your server is under load or not as when under load read access from the database is disabled. You just need to be patient and wait until your site is fully cached which will vary between site size, server spec and how often search bots crawl your pages.

Please rate and click install

THANK YOU!

Version History:

v1.7

* Removed ioncube encryption to bring script inline with vBulletin.org rules

v1.6

* Fixed nofollow block on flag links for users with vbseo sites
* Fixed adsense ads showing for translation services etc. by adding section targeting ignore tags

v1.5

* Fixed database speed issues by using InnoDB instead of MyISAM
* Code encrypted with ioncube

v1.0

* Script base version

Dave Hybrid · #**192** 06-20-2009, 03:08 PM

Quote:

Originally Posted by jaryx

When plugin 'vB Global Translator' is enabled Firefox shows me that:

Code:

Error coding content   

This page can not be displayed, because it uses incorrect or unsupported compression methods.

This page can not be displayed, because it uses incorrect or unsupported compression methods.

     * Please inform the site owners about this issue.

Why?

What is your URL.

WxP · #**193** 06-20-2009, 03:15 PM

What i need to do to translate in Albania Language?

jaryx · #**194** 06-20-2009, 03:26 PM

Quote:

Originally Posted by Dave Hybrid

What is your URL.

http://fifa.pes.com.pl

I have vBSEO & vBadvanced.

and I use subdomain like nascimbeni...

Dave Hybrid · #**195** 06-20-2009, 03:38 PM

Quote:

Originally Posted by jaryx

http://fifa.pes.com.pl

I have vBSEO & vBadvanced.

and I use subdomain like nascimbeni...

Did you follow the instructions exact, the flags are not on you pages and the translate.php code is not being called at all.

Sweeks · #**196** 06-20-2009, 03:41 PM

Do you think this mod would attract foreign spammers who otherwise wouldnt be able to spam so easily on the site? I have removed quite a few of the languages because of this possibility. What does everyone else think of this?

Dave Hybrid · #**197** 06-20-2009, 03:45 PM

Quote:

Originally Posted by Sweeks

Do you think this mod would attract foreign spammers who otherwise wouldnt be able to spam so easily on the site? I have removed quite a few of the languages because of this possibility. What does everyone else think of this?

I dont see how this MOD would make any difference.

jaryx · #**198** 06-20-2009, 03:52 PM

Quote:

Originally Posted by Dave Hybrid

Did you follow the instructions exact, the flags are not on you pages and the translate.php code is not being called at all.

I know. I tried early previus version and reslts its same like now.

Now code is added and... Error coding content

I load page when plugin is disabled and I see site and flags.

If a click on flag (plugin enabled) a see results of page http://fifa.pes.com.pl/index.php?hl=de :

Code:

Warning: set_time_limit() has been disabled for security reasons in [path]/translate.php on line 27

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/tmp:/var/tmp:/var/lib/php:/var/lib/php-pkg/dev-lang/php-5.2.5/:/usr/lib64/php5:/usr/share/pear:/usr/share/php:/usr/share/php5:/usr/share/php5/Zend/:[path]) in [path]/translate.php on line 60

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/translate.php on line 148

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/tmp:/var/tmp:/var/lib/php:/var/lib/php-pkg/dev-lang/php-5.2.5/:/usr/lib64/php5:/usr/share/pear:/usr/share/php:/usr/share/php5:/usr/share/php5/Zend/:[path]) in [path]/translate.php on line 60

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/translate.php on line 148

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/tmp:/var/tmp:/var/lib/php:/var/lib/php-pkg/dev-lang/php-5.2.5/:/usr/lib64/php5:/usr/share/pear:/usr/share/php:/usr/share/php5:/usr/share/php5/Zend/:[path]) in [path]/translate.php on line 60

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/translate.php on line 148

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/tmp:/var/tmp:/var/lib/php:/var/lib/php-pkg/dev-lang/php-5.2.5/:/usr/lib64/php5:/usr/share/pear:/usr/share/php:/usr/share/php5:/usr/share/php5/Zend/:[path]) in [path]/translate.php on line 60

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/translate.php on line 148

Dave Hybrid · #**199** 06-20-2009, 03:53 PM

Quote:

Originally Posted by jaryx

I know. I tried early previus version and reslts its same like now.

Now code is added and... Error coding content

I load page when plugin is disabled and I see site and flags.

If a click on flag a see results of page http://fifa.pes.com.pl/index.php?hl=de :

Code:

Warning: set_time_limit() has been disabled for security reasons in [path]/translate.php on line 27

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/tmp:/var/tmp:/var/lib/php:/var/lib/php-pkg/dev-lang/php-5.2.5/:/usr/lib64/php5:/usr/share/pear:/usr/share/php:/usr/share/php5:/usr/share/php5/Zend/:[path]) in [path]/translate.php on line 60

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/translate.php on line 148

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/tmp:/var/tmp:/var/lib/php:/var/lib/php-pkg/dev-lang/php-5.2.5/:/usr/lib64/php5:/usr/share/pear:/usr/share/php:/usr/share/php5:/usr/share/php5/Zend/:[path]) in [path]/translate.php on line 60

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/translate.php on line 148

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/tmp:/var/tmp:/var/lib/php:/var/lib/php-pkg/dev-lang/php-5.2.5/:/usr/lib64/php5:/usr/share/pear:/usr/share/php:/usr/share/php5:/usr/share/php5/Zend/:[path]) in [path]/translate.php on line 60

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/translate.php on line 148

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/tmp:/var/tmp:/var/lib/php:/var/lib/php-pkg/dev-lang/php-5.2.5/:/usr/lib64/php5:/usr/share/pear:/usr/share/php:/usr/share/php5:/usr/share/php5/Zend/:[path]) in [path]/translate.php on line 60

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/translate.php on line 148

open_basedir restriction in effect error

you need to ask you host to fix that.

GamerPerfection · #**200** 06-20-2009, 04:06 PM

Quote:

Originally Posted by Sweeks

Do you think this mod would attract foreign spammers who otherwise wouldnt be able to spam so easily on the site? I have removed quite a few of the languages because of this possibility. What does everyone else think of this?

No.

nascimbeni · #**201** 06-20-2009, 05:35 PM

Well ... if I get it to work I think I will disable a few flags like the China one to avoid spammers from China ( they seem to like my website ) -

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05166 seconds Memory Usage 2,336KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (9)bbcode_code (7)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (4)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!