Forum Display Enhancements - vB Enterprise Translator

2.3.15 RELEASED - TRANSLATIONS NEVER WERE SO FAST!!!

Great thanks to all who nominate vBET and allow us to win MOTM :up:

This mod translates your forum using FREE translations for over 30 languages from Yandex API. It is 100% FREE in version described here (2.x).
Note: using this mod (vBET 2.x) is free and bound by license agreement (see below)

Yandex translation gives you 1 000 000 FREE characters per DAY to translate. Please note that Yandex do not supports all language pairs, but vBET detects automatically which are supported for your forum language.

Version for vBulletin 4.0 is here: vBET 2.4.x for vBulletin 4.0

vBET 3.x released!
Please note that vBET 3.x is developed as separate product line and it is available here: vBET 3.x. Full version is paid, it supports 53 languages each to each translation, using: Google, Microsoft, Apertium, Yandex, SDL BeGlobal and DetectLanguage. It has lot of optimizations for booth performance and translations costs.

LIVE DEMO - note that demo shows functionality of full version (3.x/4.x), which has more features than 2.x
See also screen shots below, for configuration options

Features:
- Translation by Yandex (in PRO version supports 53 languages using several translation providers)
- Optimized cache, algorhitms and more performance options - PRO version only
- Translates URLs and RSS - PRO version only
- Supports multi language communities (allows to write in different languages) - PRO version only
- Links appropriate for SEO consensus (configurable) - even without any SEO mod
- Long texts are translated no matter how big those are
- Translation cache (after first translation results are cached and next page generation is much faster)
- Doesn't translate BB codes for code, php and html (must refresh post cache to see effect on existing posts Admin CP -> Maintenance -> Update Counters -> Rebuild Post Cache)
- Easy installation - just upload files and import product file
- Highly configurable and easy configuration - by Admin CP (see screenschots)
- Configurable place for flags - simply select in options where you want to have translation flags. NO MANUAL TEMPLATE MODIFICATION. Supported: Footer-Bottom, Footer-Top, Navbar-Bottom, Navbar-Top, Custom
- Possible custom place for flags - in such case just edit template which you want and add $vbenterprisetranslatorflags
- Translates also archive pages
- Reverse page direction for Arabic, Hebrew and Persian languages
- Not translated save areas - if you need something to be not translated simply edit appropriate template and put it between
<!--START vBET NOT TRANSLATED AREA--> and <!--END vBET NOT TRANSLATED AREA--> (note: you cannot use any mod which removes comments to use this functionality)

Installation:
1. Download zip package (last release - see index at the end of file name)
2. Upload to your forum directory on server everything inside upload directory
3. Import in vB Admin CP -> Plugins & Products -> Manage Products -> Add/Import Product -> Choose product file, set Allow Overwrite to yes and click Import
4. Click here: "Mark as Installed" Thanks!
5. Configure in AdminCP -> vBulletin Options -> vBulletin Options -> vB Enterprise Translator
You MUST configure at least Forum language and Yandex Translation API key. NOTE that there are some other important options - especially if your forum is in subdirectory or if you use vbSEO.

For MORE INFO and troubleshooting please read first post There is FAQ. So save your time for writing questions which are already answered and get your solution faster

Known issues:
- link for page on which you are doesn't track translation, cause it has same URL as flag for forum default language

ENJOY! :up:

And thanks for nominations

Already donated (great thanks:up:
PossumX, adwade, roymogg, zipperty, CoZmicShReddeR, RedHacker, john devost, mandingo, chris, smnoel, Audax666, Damas, TurkeySub, nectons, Scalemotorcars, TheWite, Cybershaolin, burlesque, Ransy72560, chick, jaryx, linuxututs, cormee, dai-kun x2 :up:, imported_silkroad, Megatr0n, KrisP, CareyCrew, ghisirds, vitoreis, cyc, mosz, CThiessen, actolearn, jaconi, andie215, yahoooh, bollie

LICENSE AGREEMENT - using this mod you agree for those conditions:
- you are NOT allowed to remove credit link under any conditions
- removing credit link means BREAKING LICENSE AGREEMENT and you lose your rights to use this mod
- using it after that is illegal, it is software PIRACY and it will be notified in vBulletin community and other places, including appropriate government/police units in your country
- author of this mod reserves the right to change the terms of this license agreement at any time. Failure to receive notification of a change does not make those changes invalid. A current copy of this license is and will be available here.

Please note that in full vBET version there is possibility to buy branding free license. There is no such possibility in free version included here.

Version history:
2.3.15 Changes:
- Fixed canonical link
- Fixed issue with SSL verification
2.3.14 Changes:
- Added 48 new languages pairs
- Updated link to Yandex in configuration
- When translation limit is reached now we show original text instead of empty message
2.3.13 Updated link to Yandex API key
2.3.12 Google changed to Yandex translations
2.3.11 Added "Affiliate Program" parameter
2.3.10 Footer bug corrected
2.3.9 userip added to Google translation request + small bug fixed
2.3.8 Small bug fixed - now all supported languages can be chosen as forum default language
2.3.7 Bugs fixed:
- weird redirections with vbet_lang
- double language in URL
- changing text direction for specific languages
Added support for:
- usernames not translated in who is online
- supported URL replacements for canonical URL
2.3.6 Important fix! - there was issue with sending referrer header which is necessary by Google conditions. This one was fixed + issue with # in translation links
2.3.5 Important change - According to Google conditions referrer header must be added to each translation query - otherwise you can be banned by Google. Install this version to avoid any troubles.
Changes:
- Added referrer header for Google translation queries
- Corrected bug for returning to forum main page from translated page
Also according to actual Google conditions your "Powered by Google" information should have Google logo. So please change text for flags in your vBET configuration to something like this:

Automatic Translations (Powered by <span style="vertical-align:sub;"><img src="http://www.google.com/uds/css/small-logo.png" alt="Powered by Google" border="0"/></span>):

You can customize it but "Powered by Google" should stay.
2.3.4 Important bug fixed! Corrected translation of meta keywords and description
2.3.3 Important bug fixed! And also some other bugs fixed
- Fixed bug with shifted results caching
- Fixed bug for URLs to javascript functions
- Fixed bug for not translating usernames in postbit
- Little cosmetic changes
2.3.2 Really little changes.
- Changed default value of "Links title" attribute, to be more accurate for Google conditions
- Little template changed for flags, so "Link title" font will be smaller (just like vB info in footer)
- Small bug fixed
2.3.1 Some little bug fixes. Confirmed working with vbSEO 3.3.1 and confirmed working SEO links on forums with vbSEO and subdirectory in URL
2.3.0 Great news for those without vbSEO
- Supports translation SEO links even without vbSEO
- Translate Google Maps (configurable)
- Little optimizations (i.e. included only necessary things for not translated pages)
- Supports several cache cleaning strategies (optimization for really big forums) and automatically disables cache for cleaning time to avoid read/write conflicts
2.2.1 Small bug fixed with returning to default language for main page and SEO links (happens only for specific vbSEO configuration, so you don't need to update if 2.2.0 is working for you)
2.2.0 Translation tracking is working even when redirection by some mod occures (configurable reaction time)
2.1.0 9 new translation languages added! Also:
- Redirect to user language functionality - configurable (disabled, forced, after asking user does he want to be redirected).
- Fixed bug for SEO links with forums acting like directories by id.
- Corrected several flags
Update note: if you use SEO links you must change .htaccess file according to description in first post. If you changed any vbseo.php rules ? un-change those.
2.0.3 Quick bug fixing (issue with bitfields in options panel)
2.0.2 Added option to set your forum main domain for tracking URL's in subdomains
2.0.1 Small bug fixed and added direction changing suport also for Hebrew
2.0.0 Some small or medium changes and one big - for vbSEO users now SEO consensus links available.
What's new:
- Links appropriate for SEO consensus (configurable)
- Persian support added
- Doesn't translate BB codes for code, php and html (must refresh post cache to see effect on existing posts Admin CP -> Maintenance -> Update Counters -> Rebuild Post Cache)
- Reverse page direction for Arabic and Persian languages
- Option to set forum directory if not linked to domain
- Few bugs fixed
1.1.1 Some little changes and bugs fixed
- Re-encode not translated parts, so there is no strange signs in scripts, images title etc.
- Corrected flag for Sweden
- Few harmless bug fixed in translation tracking and cache disabling
- Respecting Google conditions default flags title have link to Google (configurable)
1.1.0 Lot of new features and no longer in beta stage
- Long texts are translated no matter how big those are
- Cache is working for chosen languages (you simply select for each language does translations should be cached)
- Option to add Google Translate API key for translation requests
- Configurable cache time to live and scheduled task which automatically remove old cache.
- Option to show flags only for guests
- Option to easily remove flags border (without any style changing)
- Option to not translate usernames
- During translation changes param lang in html tag
- Option to translate messages changed by vBSEO to JavaScript (it has such functionality for SEO purposes)
1.0.5 Flags showing correctly for forums in subdirectory + corrected returning to base language
1.0.4 Bug fixed with translation of '0' string. Also added little feature - if some parts of your forum uses vbSEO and some are not then now flags will have appropriate URL's everywhere
1.0.3 Big bug fixed Mod doesn't mess in template anymore (it did in some specific cases)
1.0.2 Small bug fixed - error with array merge solved
1.0.1 Small bug fixed - now choosing supported languages in options works fine
1.0.0 Great mod released

[garyopa]

Originally Posted by Dave Hybrid

Load, page speed times and crawl page times are even worse while the cache is being built, all these stats are from a fully cached translation database, so being pulled from mysql, no writing. Broken links includes the breadcrumbs linking to pages that don exist, clone/duplicate pages being generated with bizarre query strings as urls. Similar threads disappearing and being posted in the post content instead of the actuall post text, all sorts. Also, when checking many thousands of pages in the cache of google and bing finding pages being cut off, so only being indexed upto post 5 of a 20 post thread, footers missing, all sorts. This is because the bots dont crawl like a browser and the bots generate pages with errors, the issue is if the bot is first to the page, it is translated wrong and then every user that accesses it sees the bad generation from cache. I could go on, basically for any serious SEO it is a wild goose, you have no way of controlling it, it messes with too much. I like control, without this mod my site code is 100% perfect, with it im constantly chasing bugs. IMO those that havent seen these serious SEO bugs are thos that have not properly searched for them or dont know how to spot them, no offence. They are not always obvious. Seriously uninstall for just a few days and check all your stats, you'd be amazed. I'd been running it so long i thought these high figures were normal. I tried vbo, CDN, new servers everything and all it took was to remove this to get all the metrics reporting desirable results.

Wow! -- What a list of problems.

Personally I have not had any problems with VBET, I bought the paid version, and installed it along with my licenese VBSEO and VBAdvanced and Vbulletin v3.8.6 and the only thing I had to uninstall was the sitemap, I could not get it to work.

Yes, I was a pain to edit a couple of the VBSEO files and get the .htaccess just right, in fact the included docs on VBET is not totally right, I read almost ever post on VBET own forums, and was able to piece together a couple major changes I needed, mainly because of my usage of VBSEO and VBAdvanced.

But afterwards it is running smooth, and at worse maybe 1% more cpu power, and I have a very active forum with over 10,000 users at anyone time posting new posts, and over 1million hits per day of just plain guests lurking and browsing the forums.

As for increased traffic VBET helped my overall worldwide ranking to go down, but since I already clocking in $5,000 a month in adsense, I didn't notice any increase in money from the extra traffic, but I do have some very happy new members from spain, france, germany, dutch, and even perisan that love the auto-translation figure, and my previous half million english only forum members have not had one complaint about the new posts or setup.

I am of course running a very powerful server, is it totally dedi. rack with dual 24 core servers, one for the mysql and the other for www, with alot of custom settings in the mysql and php, fast-cgi, along with eaccelator, memcache, apc (alot tho, memcache I turned off), and tons of ram 32gigs. -- RAM IS VERY IMPORTANT!

I been in the web hosting business since before it existed, and started with running Delphi and later Genie (the big dial-in mainframes) and I see nothing wrong with VBET, except it is not supported by VBSEO (because of the file edits), but hard to get around that when you have two packages wanting to re-write URL's on the fly.

Support on the other hand with VBET is not so good, they are quick to close of support threads, and not fast on repling, so unless you are 1,000% expert in editing and running a dedi. server I would not recommend jumping into the frying pan on this one.

One thing is for sure, you must enable just a few languages at first if you have a very large forum, I enabled about dozen per week, until everything got cached and converted, and be prepared to have tons of free hdd space, once a heavy forum like mine got all 52 langs. going, we had an SQL that was almost 100 gigs in size so far!

Oh'yeah, one thing I forgot is the FULL FILE CACHE for GUESTS is not perfect, I found it better to leave it off, and just use the normal database grabbing for guests.

[Diablo-Sat]

thanks for the mod

[adwade]

Originally Posted by NLP-er

- Option to show flags only for guests

Could someone explain why this option exists? I don't understand, under what circumstances one would want GUESTS to have webpages translated, but not allow registered users to have the same.

In other words, this option seems backwards to me. I would expect an option to not allow GUESTS to have automatic translations, and instead allow only registered users access to translated text.

BTW, Nice MOD.:up: Install went flawlessly and I've been impressed with it's ability to translate our webpages so well.

[der_chris]

I get this error

Fatal error: Call to undefined function: iconv() in C:\Inetpub\wwwroot\forum\includes\vbenterprisetran slator_functions.php on line 249

[Scalemotorcars]

Im still getting this error after several months. I see the table was not created. How do I do that and whats the code to create it?

Database error in vBulletin 3.8.4:

Invalid SQL:
SELECT cache.originaltext as originaltext, cache.translated as translated FROM 123test_vbenterprisetranslator_cache_short help, 123test_vbenterprisetranslator_cache_short cache WHERE help.originaltext='ScaleMotorcars' AND help.tl='ja' AND cache.serie=help.serie;

MySQL Error   : Table 'forum_scalemotorcars_com.123test_vbenterprisetranslator_cache_short' doesn't exist
Error Number  : 1146
Request Date  : Wednesday, February 16th 2011 @ 01:08:27 PM
Error Date    : Wednesday, February 16th 2011 @ 01:08:28 PM
Script        : http://www.scalemotorcars.com/forum/?language=ja
Referrer      : http://www.scalemotorcars.com/forum/
IP Address    : 166.82.146.90
Username      : <!--START vBET NOT TRANSLATED AREA-->ScaleMotorcars<!--END vBET NOT TRANSLATED AREA-->
Classname     : vB_Database
MySQL Version : 4.0.27-standard

[NLP-er]

Originally Posted by adwade

Could someone explain why this option exists? I don't understand, under what circumstances one would want GUESTS to have webpages translated, but not allow registered users to have the same.

In other words, this option seems backwards to me. I would expect an option to not allow GUESTS to have automatic translations, and instead allow only registered users access to translated text.

BTW, Nice MOD.:up: Install went flawlessly and I've been impressed with it's ability to translate our webpages so well.

This was requested by our user If you search you will find such request in 2.3.x version thread

[NLP-er]

vBET 2.3.11 RELEASED!

Hi We have next release of free version. This time we added new parameter so you can earn using vBET New parameter allows you to start in our Affiliate Program and allows to earn having vBET credit link which you must have anyway (if you didn't make donation). So if you have credit link anyway why not have a chance to earn on it?...
Details in parameter description in your Admin CP.

Enjoy vBET!

[NLP-er]

Originally Posted by Scalemotorcars

Im still getting this error after several months. I see the table was not created. How do I do that and whats the code to create it?

Database error in vBulletin 3.8.4:

Invalid SQL:
SELECT cache.originaltext as originaltext, cache.translated as translated FROM 123test_vbenterprisetranslator_cache_short help, 123test_vbenterprisetranslator_cache_short cache WHERE help.originaltext='ScaleMotorcars' AND help.tl='ja' AND cache.serie=help.serie;

MySQL Error   : Table 'forum_scalemotorcars_com.123test_vbenterprisetranslator_cache_short' doesn't exist
Error Number  : 1146
Request Date  : Wednesday, February 16th 2011 @ 01:08:27 PM
Error Date    : Wednesday, February 16th 2011 @ 01:08:28 PM
Script        : http://www.scalemotorcars.com/forum/?language=ja
Referrer      : http://www.scalemotorcars.com/forum/
IP Address    : 166.82.146.90
Username      : <!--START vBET NOT TRANSLATED AREA-->ScaleMotorcars<!--END vBET NOT TRANSLATED AREA-->
Classname     : vB_Database
MySQL Version : 4.0.27-standard

What it this '123test' inside of your table name... Did you made any code changes?... Or it is part of your table prefix? Did you change table prefix after vBET installation? Please download latest vBET version and install again.
Tables are creaded automatically during installation process. I sugest to install latest version and if any issue happens please just write - we will gladly help you

[BOSS 302]

So if I install this will it automatically translate my forum for users/guests from other countries like france? Or do they have to select the option some where first? If so where?

[vBarsiv]

working quite well. Killer really appreciated. labor and brain health. collect under a single link in a very short way to process a trick.