Major Additions - vB Enterprise Translator

2.4.10 RELEASED - TRANSLATIONS NEVER WERE SO FAST!!!

This is version for vBulletin 4.x of this great mod - which wins MOM
If updating from vBET 2.3.x version - need to uninstall it first.

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.

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.4.10 Changes:
- Added missing function in 2.4.9
2.4.9 Changes:
- Removed usage of e modifier in preg_replace()
2.4.8 Changes:
- Fixed canonical links
- Fixed issue with SSL verification
2.4.7 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.4.6 Updated link to Yandex API key
2.4.5 Google changed to Yandex translations
2.4.4 Added "Affiliate Program" parameter
2.4.3 Serious bug with encoding corrected - this one was crashing some forums layouts
2.4.2 Tested with vB4.0.1 One new thing - added usercp to Google request according to changes in Google API. Few bugs corrected:
- No translation tracking for css.php
- Corrected bug for url tracking for forums in subdirectory and addresses having this subdirectory
- Resolved issue Call to undefined function vbet_getSupportedTranslations()
2.4.1 vBET integrated with vBSEO 3.5
2.4.0 vBET ready for vBulletin 4.0 Beta release - not tested with vBSEO3.5 yet.
2.3.x and earlier releases history you will find here: vBET 2.3.x for vBulletin 3.8

[NLP-er]

Originally Posted by motorola

Today I got a lot of database errors like this below. What happens ?

Database error in vBulletin 4.0.3:

Invalid SQL:
SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbenterprisetranslator_cache_short help, vbenterprisetranslator_cache_short cache WHERE help.originaltext='Old+forum%2Carchive+sections%21 ' AND help.tl='cy' AND cache.serie=help.serie;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Monday, April 12th 2010 @ 09:47:58 AM
Error Date : Monday, April 12th 2010 @ 09:55:46 AM
Script : http://www.mydomain.com/forum/forumd...ve&language=cy
Referrer :
IP Address : 67.195.115.116
Username : Unregistered
Classname : vB_Database
MySQL Version :

Google was responding slow with translations so mysql connection timed out. Just increase your timeout for mysql connection - this is official vBulletin solution for 'MySQL server has gone away' issue.

[motorola]

Originally Posted by NLP-er

Google was responding slow with translations so mysql connection timed out. Just increase your timeout for mysql connection - this is official vBulletin solution for 'MySQL server has gone away' issue.

and how can I do that ?

[Noerenberg]

Originally Posted by NLP-er

Please turn on option to nod transalte usernames. Please note that this option works in specific places - there still can be some places where usernames are translated. In such case please describe specifically where it happens. Also - you cannot use mods which are clearing HTML comments - otherwise usernames will be translated, because mark about not translating it will be removed.

I turn it ot, but the username are translate.

[mikeinjersey]

I'm interested in this.

For the people that have this installed already, Has it increased traffic for ya ? If so, how much ? And how long did it take ?

I'm visually it must be weird having people from other countries signing up. The spelling must be hard to interpret at times. (even though its still converted over for us)

thx much

[motorola]

Originally Posted by motorola

and how can I do that ?

Someone an answere .
Please !
Thanks

[mikeinjersey]

Originally Posted by motorola

Someone an answere .
Please !
Thanks

Here's the technical reference -

http://dev.mysql.com/doc/refman/5.1/en/gone-away.html

But i'm sure if you google "increase time out mysql" , you'll find a more basic solution.

[Jesh]

Originally Posted by NLP-er

Integration instructions:
You just have to edit one file: vbseo_sitemap_functions.php in vbseo_sitemap directory.

Find:

PHP Code:

vbseo_log_entry("[showthread] forum_id: $forumid, thread_id: $threadrow[threadid], total posts: $totalposts, pages: $totalpages, views: $threadrow[views] $prior"); 


And place AFTER it...

For SEO links

PHP Code:

//additional code 
$alanguages = array ('af','sq','ar','be','bg','ca','zh-CN','hr','cs','da','nl','en','pl','et','tl','fi','fr','gl','de','el','iw','hi','hu','is','id','ga','it','ja','ko','lv','lt','mk','ms','mt','no','fa','pt','ro','ru','sr','sk','sl','es','sw','sv','zh-TW','th','tr','uk','vi','cy','yi'); 
if(!$archived) { 
  $strlenhost = strlen($vbseo_vars['bburl']."/"); 
  $currentthreadurl = vbseo_url_thread($threadrow, 1, $archived);
  $currentthreadurl_before = substr($currentthreadurl,0,$strlenhost);
  $currentthreadurl_after = "/".substr($currentthreadurl,$strlenhost);
  $lastpost =& $threadrow['lastpost'];
  $vbseo_stat['t'] += sizeof($alanguages);
  foreach($alanguages as $language) { 
    vbseo_add_url($currentthreadurl_before.$language.$currentthreadurl_after, $prior, $lastpost, $freq); 
  } 
}   
//end additional code 


NOTE: REMOVE YOUR DEFAULT LANGUAGE CODE from $alanguages
Also if you disabled some languages in option panel you have to delete its codes too.

For links with language=

PHP Code:

//additional code
$alanguages = array ('af','sq','ar','be','bg','ca','zh-CN','hr','cs','da','nl','en','pl','et','tl','fi','fr','gl','de','el','iw','hi','hu','is','id','ga','it','ja','ko','lv','lt','mk','ms','mt','no','fa','pt','ro','ru','sr','sk','sl','es','sw','sv','zh-TW','th','tr','uk','vi','cy','yi');
if(!$archived) {
  $currentthreadurl = vbseo_url_thread($threadrow, 1, $archived) . '&language=';
  $vbseo_stat['t'] += sizeof($alanguages);
  $lastpost =& $threadrow['lastpost'];
  foreach($alanguages as $language) {
    vbseo_add_url($currentthreadurl.$language, $prior, $lastpost, $freq);
  } 
}  
//end additional code 


NOTE: REMOVE YOUR DEFAULT LANGUAGE CODE from $alanguages
Also if you disabled some languages in option panel you have to delete its codes too.

NOTE FOR SITEMAP INTEGRATION:
If you want to add to sitemap also links for other thread pages (if thread have several pages), then additional code must be added BEFORE:

PHP Code:

$vbseo_stat[$archived?'at':'t'] += vbseo_add_2urls( 


Also in additional code you have to change 1 to $p.


Piece of cake

Do I have to do BOTH or just one? Meaning, do I add additional code before $vbseo_stat AND also before "vbseo_log_entry..."? Or do I only do additional code 1x?

[Jesh]

Also, has anyone managed to get this implemented with photopost gallery?

[NLP-er]

Originally Posted by motorola

and how can I do that ?

Just Google MySQL manual about this issue:
http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

[NLP-er]

Originally Posted by Noerenberg

I turn it ot, but the username are translate.

Make sure that you are not using any mod which removes html comments. If you do, then this is a reason...
Also vBET do not translate usernames in specific places (as I remember those are described in parameter description), so in other place those still will be translated. You can write me in which places exactly usernames are still translated and I will work on it for future version.