Go Back   vb.org Archive > vBulletin Modifications > Archive > Modification Graveyard
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
vB Global Translator - Multiply your indexed pages & put search traffic on autopilot Details »»
vB Global Translator - Multiply your indexed pages & put search traffic on autopilot
Version: 1.7, by Dave Hybrid Dave Hybrid is offline
Developer Last Online: Dec 2013 Show Printable Version Email this Page

Category: Miscellaneous Hacks - Version: 3.8.x Rating:
Released: 06-14-2009 Last Update: 06-19-2009 Installs: 35
Uses Plugins Template Edits
Additional Files  
No support by the author.

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

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #162  
Old 06-19-2009, 01:30 PM
Dave Hybrid's Avatar
Dave Hybrid Dave Hybrid is offline
 
Join Date: Mar 2007
Posts: 463
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Version 1.5 release:

More major bug fixes and speed improvements. This is a essential upgrade. Old versions will now no longer be supported and will soon cease to function.

Upgrading:

If you have not yet setup a new InnoDB type MySQL database as explained in the last update please do so now, this improves speed 100x. See main post install instructions for details.

If you have done so you now need to download the latest files and re-upload all of them to the relevant places also explained in the install instructions.

You also now need ioncube for the script to work, your host can install this, it is free.

Thanks.
Reply With Quote
  #163  
Old 06-19-2009, 01:42 PM
GamerPerfection's Avatar
GamerPerfection GamerPerfection is offline
 
Join Date: Feb 2006
Posts: 389
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Sweeks View Post
I know two other forums with this mod and the middle flag isnt there so obviously is isnt just me who removed the link. Honestly if your code was commented where the link was I wouldnt have removed it. It is pointless arguing about this.

Thank you for the modification as it works really well on the right setup
Mate just shut up and leave the thread if you're not happy with the service.

What IS that harm in having a link in the middle? To be honest I hadn't even noticed it until you came up. It doesn't stick out like a sore thumb, it's the same size as all the others. What IS the problem????

You want support yet you won't support the Coder by having the link.

YOU'RE a joke!
Reply With Quote
  #164  
Old 06-19-2009, 01:59 PM
Sweeks Sweeks is offline
 
Join Date: Jul 2008
Posts: 633
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by clarkey25 View Post
Mate just shut up and leave the thread if you're not happy with the service.

What IS that harm in having a link in the middle? To be honest I hadn't even noticed it until you came up. It doesn't stick out like a sore thumb, it's the same size as all the others. What IS the problem????

You want support yet you won't support the Coder by having the link.

YOU'RE a joke!
Sorry but no I will not shut up, I have no problem putting the link back in but most coders tend to say so within their code that they would prefer the link to be left in there and he never expressly said this at all. So I am sure like me, plenty of others would have also removed it.

I have the problem fixed now anyway so I dont require the support, so I will happily leave this thread.
Reply With Quote
  #165  
Old 06-19-2009, 02:03 PM
Dave Hybrid's Avatar
Dave Hybrid Dave Hybrid is offline
 
Join Date: Mar 2007
Posts: 463
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Keep digging buddy, you're just making yourself look like a real deal a$$hole.

Stop talking and put the link back then.

But why bother ay? You don't need me anymore and you have your free script.

Parasite.

What happens when it breaks again?

Karma is a b!tch.
Reply With Quote
  #166  
Old 06-19-2009, 02:13 PM
Sweeks Sweeks is offline
 
Join Date: Jul 2008
Posts: 633
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Dave Hybrid View Post
Keep digging buddy, you're just making yourself look like a real deal a$$hole.

Stop talking and put the link back then.

But why bother ay? You don't need me anymore and you have your free script.

Parasite.

What happens when it breaks again?

Karma is a b!tch.
Parasite? You shouldnt make modifications for free then and not expressly state you dont want the link taken out, simple.

I am sorry but I have seen many coders on here clearly express their wishes for links and copyrights not to be removed and it isnt my problem you never.

And if it breaks, then it breaks, thats what you do, you take your chances with modifications. There is no point being funny with me just because you didnt state that you never wanted the link taken out and people can argue with me all they like but it is the truth that you never mentioned the link being there or your wishes for it to be kept there.

I am gone now, save your time in replying as I am not interested.
Reply With Quote
  #167  
Old 06-19-2009, 02:45 PM
Calash's Avatar
Calash Calash is offline
 
Join Date: Jun 2006
Location: East Coast, USA
Posts: 297
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well with the database changes and the updated files/plugins I am still getting the database errors.

However the database actually has information in it now. This is better than before.

I am going to let it sit for a bit so the spiders can crawl and see if the database gets more data.
Reply With Quote
  #168  
Old 06-19-2009, 03:13 PM
Dave Hybrid's Avatar
Dave Hybrid Dave Hybrid is offline
 
Join Date: Mar 2007
Posts: 463
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Calash View Post
Well with the database changes and the updated files/plugins I am still getting the database errors.

However the database actually has information in it now. This is better than before.

I am going to let it sit for a bit so the spiders can crawl and see if the database gets more data.
The pages seem to throw an error in the browser, are you 100% you installed it perfect?
Reply With Quote
  #169  
Old 06-19-2009, 03:33 PM
Kolbi Kolbi is offline
 
Join Date: Mar 2009
Location: D - S?dbaden
Posts: 899
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Can you please make a history, what you fixed in the new version?
I mean:

*1.1
fixed xyz
*1.2
fixed abc
...

That would be nice for the future.
Reply With Quote
  #170  
Old 06-19-2009, 03:35 PM
Calash's Avatar
Calash Calash is offline
 
Join Date: Jun 2006
Location: East Coast, USA
Posts: 297
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Dave Hybrid View Post
The pages seem to throw an error in the browser, are you 100% you installed it perfect?
Yes, triple checked. The browser errors line up with MySQL errors as posted previously (Sever has gone away).

I am thinking that my shared host is doing something that kills the query.

I disabled the plugins for now because I was getting flooded with errors. When I have more time I will check everything again and see if I can work out the details.


Thanks for your effort with this mod
Reply With Quote
  #171  
Old 06-19-2009, 07:19 PM
Dave Hybrid's Avatar
Dave Hybrid Dave Hybrid is offline
 
Join Date: Mar 2007
Posts: 463
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Version 1.6 release;

* 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

All users should exchange their template code to include adsense ignore tags;

Code:
<!-- vBGT Code Start-->
<div align="center">
<!-- google_ad_section_start(weight=ignore) -->
$translateflags
<!-- google_ad_section_end -->
</div>
<!-- vBGT Code End -->
*IMPORTANT VBSEO USERS*

We have just found vBSEO adds nofollow to the flag links so if you want the search bots to crawl and index your translated pages - thats all of you right? - you must download version 1.6 and upload the new translateflags.php file.

Thanks.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 07:17 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05091 seconds
  • Memory Usage 2,332KB
  • 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
  • (7)bbcode_code
  • (5)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