vBulletin Google Site Map

There are a few vBulletin Google Site maps around, but none as comprehensive as this that I have seen. This vBulletin Google site map is based on Kalius's work on discussed on his site and at Digitalpoint

FYI, the vBulletin Google Site Map modification contains at least one potential remote file include exploit. You are hereby notified that you should uninstall this modification, including the removal of the vBulletin Google Site Map PHP files from your server. The author of the modification has been notified, and the vBulletin Google Site Map thread has been moved to the Modification Graveyard forum.

Best,
vBorg Staff

vBulletin Google site map
with ability to add extra urls
(c) by T2DMan - Michael Brandon

8Nov05+13hrsGMT - update. Added support for Yahoo Sitemap & bug fix
7Nov05+13hrsGMT - update. Thanks for your help.

I have attached 1 version with 2 different preset configs for your convenience. vBSEO and non vBSEO configs.

Configure in the vbgsitemap-config.php file.
$base=""; // "" if in root, $base="forum/"; //if in the subdirectory forum

It now works well with forum permissions, and the vBulletin's scheduled task system. I have personally installed the reviewed vBGSiteMap on a site with over 200,000 urls. Copes with the large number of urls with no problems.

The vBGSiteMap works well with vbSEO, and it lists all the old url's to allow Google to spider the old url's and so find the 301 redirects to the new, and so delete the old url's from its index.

Compared to the previous versions

• Sitemap files now written into their own directory - means this can be safely chmod 777 - thanks Sarah King
• config and class files separated out
• new help file written
• many corrections made to the code - amazing what sitting on a piece of code can do, and amazing what you can learn from personally installing on many different servers.
• Can now work on mysql versions from 3.23.58 to 5+
  

Specifications

• works with v3.03 - 3.5
• access to this file is password protected

the same password as the database via the vBulletin includes/config.php file

• creates an index file and multiple gzipped site maps to less than the maximum permitted by Google (I have in fact restricted it to 3k url's, rather than 50k as my browser takes a while to process the file when checking it)
• creates a gzipped file containing the urls for Yahoo Sitemap

• the site map files are created in the /vbgsitemap/files directory which needs to be chmod to 777

adds

• forums - with paginations of forums (excluding redirects and password protected forums)
• threads - with pagination of threads (excluding invisible threads=soft deleted, and threads inside password protected forums)
• archive forum pages with paginations
• archive versions of threads with paginations
• members

extra

• extra urls from other program types
• add a new url per line onto file.txt, and a gzipped file will be created for it, and added to the site index file.

How to install

• unzip the files
• copy the vbgsitemap folder to your root directory
• chmod the vbgsitemap/files directory to 777
• copy vbgsitemap.php to your root directory
• copy the includes/cron/vbgsitemap-cron.php file to your vbulletin includes/cron/ directory
• look over the configuration options on the /vbgsitemap/vbgsitemap-config.php file
  • $base="" or "forum/" - if your forum is the actual root, or in the forum directory etc.
  • $addthreadarchive=false; - whether you want the archive version of the threads to be added or not.
  • the rest should not need to be changed
  • change to $xtrafile="file.txt"; if you have additional urls that you want included from another package, get a list of those url's and add them to file.txt.
• Then access the /vbgsitemap/index.php file in your browser to get things happening.
• The username/password is the username/password of your database.
• Add the resulting one index file to Google sitemaps: http://www.yourdomain.com/vbgsitemap.php
• Add the other file to Yahoo sitemaps
  http://www.yourdomain.com/vbgsitemap/files/urllist.gz
• A cron job can be setup in the vbulletin scheduled tasks
  
  
  • ./includes/cron/vbgsitemap-cron.php
  • depending on the number of posts/new threads to your forum, set to run daily or weekly etc. The cron will automatically ping Google and return success/failure into the cron log.

[Electronic Punk]

are you using the same username and password that you have in the config.php?

[Itachi0009]

I am using my mysql passwords and everything like the rest of the people and I still can't get it to work...

[eXtremeTim]

I will be setting this up soon and will see about adding more stuff for it to cover. Like ability to work the the cmps2 ect.

[libertate]

I installed it.

Here are some issues -
CHMOD root directory (as in rootwww) - BAD VERY VERY BAD idea. You have to figure out a solution other then having to do that. Maybe a subdirectory off of forum, or a temporary directory, or it's own directory.

Throwing it in the root is not clean. Why can't it go into its own folder off of forum?

I also had the double appending problem with the domain name. www.site.comwww.site.com within the XML files.

Take the db and pass from vB, and don't ask for it. This is required anyway if it's a cron job.

Just put it up on G, so will see how it goes... (crossing my fingers)

Well... it didn't work. The schema is incorrect.

Google wants an http:// after <LOC> which is not create if forgotten from the config.

so the variable $http= line needs to say
$http="http://";

Also there are some problems with the "archive" folder where it appends after the file.
Like this:
www.example.com/forum/archive/index.php/f-1.html

[Metro Man]

Incorrect username/password

in vB 3.5 RC2

[Tom1234]

Re: Incorrect username/password

I think

elseif($dbusername<>$username AND $dbpassword<>$password) entry(false);

should be

elseif($dbusername<>$username OR $dbpassword<>$password) entry(false);

[Metro Man]

Originally Posted by Tom1234

Re: Incorrect username/password

I think

elseif($dbusername<>$username AND $dbpassword<>$password) entry(false);

should be

elseif($dbusername<>$username OR $dbpassword<>$password) entry(false);

erros with this changes are the same

[Metro Man]

hy, has someone from you a file for me, already modified, with you in the 3,5 RC2 goes? Would be nice if this jeman makes available

[David_R]

Getting this error:
Fatal error: Maximum execution time of 30 seconds exceeded in /home2/gamers/public_html/vbsitemap-multi.php on line 562

also how can you include meta descriptions and keywords into sitemap ?

[Tom1234]

Originally Posted by David_R

Fatal error: Maximum execution time of 30 seconds exceeded in /home2/gamers/public_html/vbsitemap-multi.php on line 562

Increase your:

max_execution_time = 30

in /etc/php.ini (or other location depending on OS) to 60 or greater so it can finish.