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

[NLP-er]

Originally Posted by T2x

I have updated the code in my old post for vbseo.php as well as the 301 redirects.

This should hopefully finally fix any issues people were having


https://vborg.vbsupport.ru/showpost....&postcount=181

Still same problem on my side :/

.htaccess has possibility to made internal redirect, I was trying it but without success. Maybe you will find working solution in this area. Such internal redirect should work without any vbseo.php changes, because to vbseo will come link with language param. This is idea - as I wtore it don't works for me, but maybe I miss somesthing. This is this not working rule:

RewriteCond %{REQUEST_URI} ^/(..|zh-TW|zh-CN)/(.*)
RewriteRule ^(.*)$ /%2\?language=%1

[TheLastSuperman]

Originally Posted by NLP-er

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

I had a similar error just like this: http://www.mydigitallife.info/2007/0...-a-key-length/

I used this and it worked, turned on cache yet when you navigate to another page after translation is does not stick? Long story short no DB error when cache is enabled like I used to have but it will not hold the translation.

CREATE TABLE 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(255),
translated VARCHAR(255),
UNIQUE (originaltext, tl),
INDEX(serie)
) ENGINE = MYISAM, CHARACTER SET utf8 COLLATE utf8_bin

And images? Not sure about that, it was that other mod I used err well code actually but I added in the do not translate tags and no effect.

[NLP-er]

Originally Posted by TheLastSuperman

I had a similar error just like this: http://www.mydigitallife.info/2007/0...-a-key-length/

I used this and it worked, turned on cache yet when you navigate to another page after translation is does not stick? Long story short no DB error when cache is enabled like I used to have but it will not hold the translation.

CREATE TABLE 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(255),
translated VARCHAR(255),
UNIQUE (originaltext, tl),
INDEX(serie)
) ENGINE = MYISAM, CHARACTER SET utf8 COLLATE utf8_bin

And images? Not sure about that, it was that other mod I used err well code actually but I added in the do not translate tags and no effect.

About DB - the reason is differences in mySQL versions. On my version varchar(328) is not automatically changed to blob/text - on yours it is.

Please let me know which version do you have?

You made wrong changes in SQL, please drop your table and use this one (corection will be included in next release):

CREATE TABLE 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(328), tl),
INDEX(serie)
) ENGINE = MYISAM, CHARACTER SET utf8 COLLATE utf8_bin

About holding translation - turn on tracking in options.

Not understood about images.

[T2x]

Originally Posted by NLP-er

Still same problem on my side :/

.htaccess has possibility to made internal redirect, I was trying it but without success. Maybe you will find working solution in this area. Such internal redirect should work without any vbseo.php changes, because to vbseo will come link with language param. This is idea - as I wtore it don't works for me, but maybe I miss somesthing. This is this not working rule:

RewriteCond %{REQUEST_URI} ^/(..|zh-TW|zh-CN)/(.*)
RewriteRule ^(.*)$ /%2\?language=%1

I have already tried doing it via rewrite rules in .htaccess but it will not work with vBSEO


Paste me your ENTIRE .htaccess so I can see if there is a problem with it maybe

[Aclikyano]

Originally Posted by NLP-er

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:

well i noticed i still had the old XML on DISABLED on admincp but i still uploaded the new xml and i thought i put allow overwrite but ill let u kno in a min thanks!

[Aclikyano]

lol it only was showing the Automatic Translation text and no flags
i have flags uploaded to /public html/ forums
im not newbie status i know what im doing most the time lol but something is just not working lmfaooo

[merkaz]

URL tracking trackink every link internal or exitrnal link even if it is not vb link such as gallery or adv and change the link to ?language= .

It should be tracking internal vb links only .

I hope you understand what i mean .

and thanks alot for sharing this amazing mod .

[TheLastSuperman]

Originally Posted by NLP-er

About DB - the reason is differences in mySQL versions. On my version varchar(328) is not automatically changed to blob/text - on yours it is.

Please let me know which version do you have?

You made wrong changes in SQL, please drop your table and use this one (corection will be included in next release):

CREATE TABLE 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(328), tl),
INDEX(serie)
) ENGINE = MYISAM, CHARACTER SET utf8 COLLATE utf8_bin

About holding translation - turn on tracking in options.

Not understood about images.

I think we both lost each other on images as that was never an issue just that Webdeveloper Plus mod I provided a link to in a previous post, that would translate but the DB error resulted form text in that however we know now that the table was never created so that was not the cause of the error

And MySQL version per the previously posted DB error:

MySQL Version : 4.1.22-max-log

I'll drop that table ASAP and try the new, thanks for the revision and prompt replies .

S-MAN

[NLP-er]

Originally Posted by Aclikyano

lol it only was showing the Automatic Translation text and no flags
i have flags uploaded to /public html/ forums
im not newbie status i know what im doing most the time lol but something is just not working lmfaooo

Please give me link to your forum I will look

[NLP-er]

Originally Posted by merkaz

URL tracking trackink every link internal or exitrnal link even if it is not vb link such as gallery or adv and change the link to ?language= .

It should be tracking internal vb links only .

I hope you understand what i mean .

and thanks alot for sharing this amazing mod .

Thanks for note I already realized that there is problem with tracing without vbSEO, or with some specific configuration. I have already corrected solution, but want to implement also some new features before release - hope you will forgive me

In this solution language param will be added to all links which not beginning from http (so are local)
or beginning from http ://your.forum.domain - so also local but not relative.

Mostly I'm waiting for solution to new URLs pattern working for everyone. When I got it then new release will come with some harmless bugs fixed and new features. Please be patience a while