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

[imported_silkroad]

Originally Posted by yahoooh

it should be not javascript popup because may affect the crawler of se
it should be just text under flags as notice this page translated by google and may not be fully understood
something like that
and also optionally

That is what I thought.

Good suggestion. Cheers.

[woffie]

I found the issue with mine. You have to set a default language in the mod before it will work. Guess I missed that step. Working great, thanks!

[NLP-er]

Originally Posted by Aclikyano

// parse PHP include ##################
($hook = vBulletinHook::fetch_hook('global_complete')) ? eval($hook) : false;


AFTER # signs starts line 5737
did what you said still got the errors...

LOL I think I know what it is. Probably you uploaded new files, bud didn't importend new product file I just checked and in previous version this method has less parameters. So made full update - new files on FTP and import new product file. Good lock :up:

[woffie]

A great feature for this would be the ability for something that is posted into another language (other than the default) to be automatically translated into the default language.

[NLP-er]

Originally Posted by TheLastSuperman

sorry off on a tangent as usual lol..

Hmm let's enable db caching and copy/paste the error hold tight...

Database error in vBulletin 3.8.4:

Invalid SQL:
SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbenterprisetranslator_cache_medium help, vbenterprisetranslator_cache_medium cache WHERE help.originaltext='2142 Tournament C7: Aug 23rd, Battle #5 Map Downloads.' AND help.tl='sq' AND cache.serie=help.serie;

MySQL Error   : Table 'dbnamewashere.vbenterprisetranslator_cache_medium' doesn't exist
Error Number  : 1146
Request Date  : Monday, August 17th 2009 @ 09:15:19 PM
Error Date    : Monday, August 17th 2009 @ 09:15:20 PM
Script        : http://www.tournamentgamingworld.com/online/index.php?language=sq
Referrer      : http://www.tournamentgamingworld.com/online/index.php
IP Address    : hey hey now :p
Username      : [TGW]GA|TheLastSuperman
Classname     : vB_Database
MySQL Version : 4.1.22-max-log

Ok so I think it might be this conflicting w/ the cache:

https://vborg.vbsupport.ru/showthread.php?t=219874

As some of the originaltext in the error above is code I just added to that in the forumhome template to be one of the rotating content seen below the normal navbar location.

I'll try this in the morning, wife is home so time to get off computer

<!--START vBET NOT TRANSLATED AREA--> and <!--END vBET NOT TRANSLATED AREA-->
_____________________

The Tabs mod... I used images instead of the standard CSS but the tabs mod is here:

https://vborg.vbsupport.ru/showthread.php?t=175687

The forum I'm using this on is here:
http://www.tournamentgamingworld.com

Thanks for ANY help you can provide.

S-MAN

About error - you don't have medium cache table. Please set it manually (have no idea why it didn't create during installation - maybe some mysql version issues) - and in case of errors during creation please give me error measage.

CREATE TABLE " . TABLE_PREFIX . "vbenterprisetranslator_cache_medium (
id INT AUTO_INCREMENT NOT NULL PRIMARY KEY,
serie BIGINT(14) UNSIGNED,
dateline int(10) UNSIGNED default 0,
tl VARCHAR(5),
originaltext VARCHAR(328),
translated VARCHAR(1000),
UNIQUE (originaltext, tl),
INDEX(serie)
) ENGINE = MYISAM, CHARACTER SET utf8 COLLATE utf8_bin

Change " . TABLE_PREFIX . " to your table prefix if use any.

About translaion of images... - just go back to styles

[NLP-er]

Originally Posted by T2x

Can you tell me what version of apache you are running?

Edit: I have edited my above post with modified code for vbseo.php, this should fix any issues you have due to different server configuration :]

Still have:

/a/

Invalid Forum specified. If you followed a valid link, please notify the administrator

:/

About server - in admin CP maintenance tells me:
Server API UltraCGI/1.0 for IdeaWebServer

[NLP-er]

Originally Posted by imported_silkroad

FYI, we installed both versions of the vBSEO updated code (not the 301 code), just for testing, and neither worked for us.

We are running:

# apache2 -v
Server version: Apache/2.2.8 (Ubuntu)

Edit: Logfiles show 301 redirects (but does not redirect to the translated pages correctly...)

Example from logs:

.... /es/index.php HTTP/1.1" 301 - "-" "Opera/9.64 (Macintosh; PPC Mac OS X; U; en) Presto/2.1.1"

Note: We are still running the old "hl" code, so I changed "language" to "hl" in the vBSEO code ( _GET['language'] to _GET['hl'] )

Please reply via PM, if you like, since we are running the old "hl" code..... but I am not sure "it matters" since the logfile show the 301 redirects as above.

You can skip from hl to language - in first post you have nice and working redirect which will automatically move all hl to language

[bollie]

Originally Posted by NLP-er

My paypal account: michal.podbielski@wp.pl

Great thanks!

Done

[NLP-er]

Originally Posted by imported_silkroad

NLP-er,

Here is another TO-DO on the feature request list, regarding:



In the future, it might be good to have a simple JavaScript Popup (optional of course) that pops up when a user from a translated page referral arrives that says, in effect:

.

(or something like that)

Not sure how that would effect search engines.... maybe it would not be good in that case!

Added in TODO - will be configurable of course

[NLP-er]

Originally Posted by woffie

Installed on my test forum and worked perfectly. Installed on my real forum and I get a blank page on the index. No links or text visible, just the graphics. It is conflicting with something, just not sure what. Had to uninstall.

In Admin CP. Give me link to your forum I will help