vb.org Archive

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)

45wheelgun 07-21-2009 04:59 PM

Quote:

Originally Posted by NLP-er (Post 1852638)
I wrote my own spider and translated all my pages in 40 languages. According to vbSEO sitemap generator - somesthing between 50-60K pages (don't remember exactlly) including oryginal not translated pages. DB stats:
TABLE ROWS SIZE
wt_cache 168 930 166,0 MB
wt_cache_medium 490 901 144,7 MB
wt_cache_short 812 496 66,0 MB

Would you care to share that spider? I would be interested in using it. My server has the horsepower and bandwidth and with 320,000 posts, I would like to get a leg up! Feel free to PM me.

On a related note, can you give me a short explanation of the three databases? How do they correlate with the 50-60k that the sitemap reports?

Great Mod guys, as I said before I am loving it.

Dave Hybrid 07-21-2009 05:02 PM

Quote:

Originally Posted by 45wheelgun (Post 1853019)
Would you care to share that spider? I would be interested in using it. My server has the horsepower and bandwidth and with 320,000 posts, I would like to get a leg up! Feel free to PM me.

On a related note, can you give me a short explanation of the three databases? How do they correlate with the 50-60k that the sitemap reports?

Great Mod guys, as I said before I am loving it.

You can just turn the crawl rate up in Google Webmaster Tools, that works.

pharmacist 07-21-2009 05:50 PM

Fantastic Mod
always wait for it

NLP-er 07-21-2009 07:45 PM

Quote:

Originally Posted by 45wheelgun (Post 1853019)
Would you care to share that spider? I would be interested in using it. My server has the horsepower and bandwidth and with 320,000 posts, I would like to get a leg up! Feel free to PM me.

On a related note, can you give me a short explanation of the three databases? How do they correlate with the 50-60k that the sitemap reports?

Great Mod guys, as I said before I am loving it.

Some people was already asking me - it is written in Java and uses its testing engine - without IDE you will not be able to even run it. If someone feel good in Java, is able to run tests and edit code to change some hardcoded things, then PM me :)

About cache tables - those split short, medium and long translations. Thanks that it works much faster, because short and medium data have full indexes and unique constraints which preserves data duplication. How those tables correlates with 50-60k of pages in sitemap - they have something about 50k translated pages from my forum :)

Manoel J?nior 07-21-2009 11:23 PM

I did the whole procedure, but does not appear in my navbar

Dave Hybrid 07-22-2009 11:53 AM

Quote:

Originally Posted by Manoel J?nior (Post 1853218)
I did the whole procedure, but does not appear in my navbar

Then you did something wrong, i suggest you double check everything. :up:

1Unreal 07-22-2009 01:33 PM

Quote:

Originally Posted by NLP-er (Post 1853131)
Some people was already asking me - it is written in Java and uses its testing engine - without IDE you will not be able to even run it. If someone feel good in Java, is able to run tests and edit code to change some hardcoded things, then PM me :)

About cache tables - those split short, medium and long translations. Thanks that it works much faster, because short and medium data have full indexes and unique constraints which preserves data duplication. How those tables correlates with 50-60k of pages in sitemap - they have something about 50k translated pages from my forum :)

I made a really basic spider in PHP. Heres an element of it. If you build on it you could make it work nicely :)

PHP Code:

$html file_get_contents('http://www.example.com');

$dom = new DOMDocument();
@
$dom->loadHTML($html);

// grab all the on the page
$xpath = new DOMXPath($dom);
$hrefs $xpath->evaluate("/html/body//a");



for (
$i 0$i $hrefs->length$i++) {
    
$href $hrefs->item($i);
    
$url $href->getAttribute('href');
    
    echo 
$url.'<br />';



silentcontrol 07-22-2009 01:37 PM

Code:

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/climarso/public_html/forum/translate.php on line 41
Could not connect: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

why? :(

tpearl5 07-22-2009 02:06 PM

Sounds like you didn't put in the correct database name / username / password in translate.php

turbosatan 07-22-2009 03:17 PM

i havnt asked for a while now so thought i would ask again.

Can you make this work with zoints SEO please.

Some of us dont want to spend $150 on VBSEO when there are equivalents available for free.

I would love to use this mod for several of my forums but they all run zoints for SEO urls.

I will happily make a donation if it means this gets looked t.

T


All times are GMT. The time now is 07:29 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01859 seconds
  • Memory Usage 1,751KB
  • 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
  • (1)bbcode_code_printable
  • (1)bbcode_php_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