vb.org Archive - Miscellaneous Hacks - vB Global Translator - Multiply your indexed pages & put search traffic on autopilot

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)

- - Miscellaneous Hacks - vB Global Translator - Multiply your indexed pages & put search traffic on autopilot (https://vborg.vbsupport.ru/showthread.php?t=217329)

Hi Guys,

First time using this and have run into a few different issues:

1) I am unable to get the flags to display on VBAdvanced, this is a first time I am unable to get a variable to call when on VBAdvanced, so I am not sure the issue.

I only editted the nav bits to include the flags, works on all other addons, except for VBAdvanced.

2) When you choose to translate a page, it is directing to: "www.domain.com/?hl=ar" when it should go to: "www.domain.com/index.php?hl=ar"

I am sure this issue directs right back at VBAdvanced, as I am using HTACCESS to make "portal.php" my default page instead of "index.php".

With that, I am assuming it won't work on "downloads.php, etc." for any other addons one might be running.

3) I am also using Zoints SEO, assuming item #2 can be fixed, will it then work with this?

Now for some questions:

1) Can we remove your link flag if we provide a link in our footer? I am thinking the extra flag is going to be hugely confusing.

2) Are the newly translated pages updated to the Sitemap? I am at a loss as to how this MOD will add new links to google if they are not really part of the site per say.

3) Is there a way so once you switch to a language it stays on that language, I am seeing it could be potential quite a challenge for viewers if they need to click the flag on every page.

Thanks!

Quote:

Originally Posted by Dave Hybrid (Post 1844577)

That worked much better, will test and release shortly. Are you planning any more optimization? Or are we 100%? :up:

As I wrote - some little changes could be done, but probably without significant improvement. So at least for some time I think It's done :)

So good news for everyone who is with us from the beginning and made all those weird things to update without any data lost - this it the last one :D

At least for now ;)

Quote:

Originally Posted by NLP-er (Post 1844546)

You aready have DB set. So what is the problem?

then you tell me that everything came out ok, even if error

v2.4 Official Release

* More DB optimization, fastest ever read/write cache speed :)

Upgrade Info;

Open new translate.php file, add settings as detailed in install and disable cache, so $enablecache=false

Run the following MySQL querys one by one.

Code:

Alter table wt_cache_short collate utf8_bin;

ALTER TABLE wt_cache_short CHANGE tl tl VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL;

ALTER TABLE wt_cache_short CHANGE originaltext originaltext VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL;

ALTER TABLE wt_cache_short CHANGE translated translated VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL;

Code:

Alter table wt_cache_medium collate utf8_bin;

ALTER TABLE wt_cache_medium CHANGE tl tl VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL;

ALTER TABLE wt_cache_medium CHANGE originaltext originaltext VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL;

ALTER TABLE wt_cache_medium CHANGE translated translated VARCHAR( 1000 ) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL;

Code:

Alter table wt_cache collate utf8_bin;

ALTER TABLE wt_cache CHANGE tl tl VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL;

ALTER TABLE wt_cache CHANGE translated translated TEXT CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL;

ALTER TABLE wt_cache CHANGE translated translated VARCHAR( 65000 ) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL;

Code:

CREATE TABLE saver (

id INT,

tl VARCHAR(10),

originaltext VARCHAR(65000)

) ENGINE = MYISAM, CHARACTER SET utf8 COLLATE utf8_general_ci;



CREATE TABLE cleaner (

id INT

) ENGINE = MYISAM, CHARACTER SET utf8 COLLATE utf8_general_ci;

Code:

delete from cleaner;

delete from saver;

insert into saver (SELECT min(id) as id, tl, originaltext from wt_cache group by originaltext,tl having count(*) > 1);

insert into cleaner (SELECT cache.id from saver, wt_cache cache where saver.originaltext=cache.originaltext and saver.tl=cache.tl and saver.id<>cache.id);

DELETE FROM wt_cache USING wt_cache INNER JOIN cleaner ON wt_cache.id = cleaner.id;

Code:

delete from cleaner;

delete from saver;

insert into saver (SELECT min(id) as id, tl, originaltext from wt_cache_short group by originaltext,tl having count(*) > 1);

insert into cleaner (SELECT cache.id from saver, wt_cache_short cache where saver.originaltext=cache.originaltext and saver.tl=cache.tl and saver.id<>cache.id);

DELETE FROM wt_cache_short USING wt_cache_short INNER JOIN cleaner ON wt_cache_short.id = cleaner.id;

Code:

delete from cleaner;

delete from saver;

insert into saver (SELECT min(id) as id, tl, originaltext from wt_cache_medium group by originaltext,tl having count(*) > 1);

insert into cleaner (SELECT cache.id from saver, wt_cache_medium cache where saver.originaltext=cache.originaltext and saver.tl=cache.tl and saver.id<>cache.id);

DELETE FROM wt_cache_medium USING wt_cache_medium INNER JOIN cleaner ON wt_cache_medium.id = cleaner.id;

Code:

OPTIMIZE TABLE wt_cache, wt_cache_medium, wt_cache_short;

Code:

alter table wt_cache_short drop index originaltext;

create UNIQUE INDEX originaltext on wt_cache_short (originaltext, tl);



alter table wt_cache_medium drop index originaltext;

create UNIQUE INDEX originaltext on wt_cache_medium (originaltext, tl);

Some querys may take a few minutes to run, this is normal, just let them run until finished.

The set $enablecache=true; in translate.php and upload that file one last time.

Quote:

Originally Posted by Dave Hybrid (Post 1845065)

v2.4 Official Release

* More DB optimization, fastest ever read/write cache speed :)

You gave update procedure but forgot to change installation description in one detail - wt_cache has larger index since v2.3b - you set it back the short one ;)

It should be:

Code:

CREATE TABLE wt_cache (

id INT AUTO_INCREMENT NOT NULL PRIMARY KEY,

tl VARCHAR(10),

originaltext VARCHAR(65000),

translated TEXT,

INDEX(originaltext(323), tl)

) ENGINE = MYISAM, CHARACTER SET utf8 COLLATE utf8_bin;

Quote:

Originally Posted by racale (Post 1844989)

then you tell me that everything came out ok, even if error

You are trying to set up DB wich is already set up - error is good in this case :)

Quote:

Originally Posted by NLP-er (Post 1845079)

You are trying to set up DB wich is already set up - error is good in this case :)

x ok then look for something new to me because nothing works
no more what to do

thanks

thanks for the update..:up:

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (10)bbcode_code_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01606 seconds Memory Usage 1,756KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (10)bbcode_code_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: