vb.org Archive - vbSpiderFriend - Search Engine Friendliness

Page 1 of 34

Last »

Show 40 post(s) from this thread on one page

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

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - vbSpiderFriend - Search Engine Friendliness (https://vborg.vbsupport.ru/showthread.php?t=15628)

Overgrow

04-29-2001 10:00 PM

I am tired of my 200,000 posts not being listed in Google. I was inspired by phpbuilder.com this morning and I wrote:

vbSpiderFriend - the search engine indexer for all of your posts

Purpose: Allow search engine spiders to crawl a linked list of all of your posts.

Project Requirements:

-Friendly URLs (no query strings)
-Good dynamic meta tags
-Never have to touch the script again.. It is Y3K compliant, simply re-submit to the engines to update your listings

Install Requirements:

-vBulletin 1.x or 2.x
-about 10 minutes

1) Download the attached Zip.

2) Open class.mysql.php and put your database login info at the top.

3) Create a new directory called archive under your forum, like /forum/archive

4) Open the included .htaccess and change the Error 404 to your new archive path.

5) Open index.php and change the self-explanatory variables at the top of the file.

6) Upload all 3 files to your archive directory.

7) Submit /forum/archive/index.php to search engines and watch em crawl

DISCLAIMER: I don't use 2.x but I checked the schema and this should work fine.

NOTES: This uses ErrorDocument and query string parsing to get the variables needed. I do not have the time or energy to troubleshoot this if it does not work on your server. Sorry!

Overgrow

04-30-2001 09:29 PM

...

VERSION 1.0

NEW VERSION, May 21 9:38 am PST

Upgrading: Unzip and copy your variables from the top of the old index.php to the new index.php.

FIXES:

v1.1b release

-That forwarding scheme added in 1.0b is considered 'cloaking' by Google so it has been turned off by default. If you wish to enable it, make $refresh=1 in the top options.

-Added a new link at the top saying that this is the text-only version, click for the real thing. Idea by robertusss.

v1.0b release:

-Added a forwarding scheme. If the archive is spidered they will see the search-friendly version of the thread. If a user clicks onto that page from a search engine, they will be automatically forwarded to the real showthread.php. This is done with the REFERER tag.

-Added the top link to the footer as well for more keyword density

-Fixed all minor bugs

v0.1a:

-Made the private forums actually hide themselves

-Made the query string parser more flexible to work on any install location

-Added $privateForums variable so they will not be shown

-Added header("Status: 200 OK"); for the really picky engines

Overgrow

04-30-2001 09:32 PM

View an online example:

http://www.overgrow.com/edge/archive

eva2000

04-30-2001 09:58 PM

woah nicely laid out output too https://vborg.vbsupport.ru/

Overgrow

04-30-2001 10:06 PM

I know you must be piling on the sarcasm.. cracking on my UI like that! :) Look how flexible it is-- you can change the spacing to however many nbsp's you want! hehe

This is never meant to be viewed by a user except when they click through the search engine to the plain-text thread. Then the point is to get them to click on one of the top links to bring them into your real forum system. Before I launch this on my site I am definitely going to "pretty it up" but I figured I'd release the raw code and let everyone else have at it as well.

p.s. my site is damn slow today, I'm sure when installed on a real system it won't be so slow as that example.

eva2000

04-30-2001 10:30 PM

strange i just installed this on my vb 2 rc2 forum and it loads with all forums but no threads are shown when i click on any of the forum links/dates ?

i'd post the url but my private forums are revealed as well

is this meant to be set to mysql

var $CONN = "";

Overgrow

04-30-2001 10:40 PM

Does it tell you "No posts, please go back" ?

Does it give you a totally blank screen?

or does it at least show what forum you are in?

This change is just for eva to troubleshoot... FIND

Code:

echo spacer(2)."Dates: $date1 to $date2<br>&nbsp;<br>";



        $query = "SELECT title,threadid,lastpost FROM thread 

WHERE lastpost > '$ts1' AND lastpost < '$ts2' 

AND forumid='$forumID' ORDER BY dateline ASC";

change to

Code:

echo spacer(2)."Dates: $date1 to $date2<br>&nbsp;<br>";



        $query = "SELECT title,threadid,lastpost FROM thread 

WHERE lastpost > '$ts1' AND lastpost < '$ts2' 

AND forumid='$forumID' ORDER BY dateline ASC";



echo $query;

Then when it spits the query out, run it in phpmyadmin and see if it is a valid query.

eva2000

04-30-2001 10:43 PM

it outputs the 'No posts, please go back' message

eva2000

04-30-2001 10:48 PM

i ran this in phpmyadmin and it got mysql query error

Code:

SELECT title,threadid,lastpost FROM thread WHERE lastpost > '1136102400' AND lastpost < '1136620800' AND forumid='2000' ORDER BY dateline ASC

must be the forumid ? i only have 94 forums

Overgrow

05-01-2001 01:36 AM

It's just parsing the query string incorrectly, using the year instead of the forum. If you're having trouble like eva, change this:

Code:

            $forumID=$urlArray[3];

        $year=$urlArray[4];

        $month=$urlArray[5];

        $week=$urlArray[6];

        $threadID=$urlArray[7];

to this

Code:

            $a=0;



        while($urlArray[$a] != "archive") {

                $a++;

        }



        $forumID=$urlArray[($a+1)];

        $year=$urlArray[($a+2)];

        $month=$urlArray[($a+3)];

        $week=$urlArray[($a+4)];

        $threadID=$urlArray[($a+5)];

All times are GMT. The time now is 04:50 PM.

Page 1 of 34

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01439 seconds Memory Usage 1,745KB 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 (5)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)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: