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

**Text Removed**

[TurkeySub]

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!

[NLP-er]

Originally Posted by Dave Hybrid

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

At least for now

[racale]

Originally Posted by NLP-er

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

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

[Dave Hybrid]

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.

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;

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;

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;

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;

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;

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;

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;

OPTIMIZE TABLE wt_cache, wt_cache_medium, wt_cache_short;

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.

[NLP-er]

Originally Posted by Dave Hybrid

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:

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;

[Dave Hybrid]

My bad, thanks.

[NLP-er]

Originally Posted by racale

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

[racale]

Originally Posted by NLP-er

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

[puertoblack2003]

thanks for the update..:up:

[1Unreal]

Thank you