Administrative and Maintenance Tools - vBSEO Google/Yahoo Sitemap Generator

vBulletin Google Sitemaps by vBSEO v.2.5 - vBulletin 3.7.x
Download vB 3.8.x Compatible Version Here
Download vB 3.6.x Compatible Version Here
Download vB 3.5.x Compatible Version Here
Download vB 3.0.x Compatible Version Here

Note: Version 2.5 replaces all previous versions of the vBSEO Google/Yahoo Sitemap Generator, and now includes support for all the new URL types in vBulletin 3.8.x.

Overview
============================

Providing Google, Yahoo, Ask sitemaps is an essential step towards improving your forums.

The "vBSEO Google Sitemaps" plugin provides a solution that allows your forum to be indexed by the Google (and also Yahoo and Ask) search engines faster, more completely, more effectively, and with less bandwidth consumption.

The ultimate goal is to help you achieve more web traffic for your forum.

Originally Posted by Google's Description of GSM

https://services.google.com/inquiry/publishertools?hl=en_US
Google Sitemaps is an easy way for you to help improve your site?s representation in the Google index. It's a collaborative crawling system that enables you to communicate directly with Google. You get a smarter crawl because you can provide Google with specific information about all your web pages, such as when a page was last modified or how frequently it changes.

Note: This plugin is fully compliant with vBSEO 3.x version. The current version is vBSEO 3.2. However, if you are running vBSEO, please upgrade to vBSEO 3.2 or greater before installing.

Compatibility
============================


Fully compatible with:

• vBulletin 3.0.x, 3.5.x, 3.6.x, 3.7.x and 3.8.x
• vBulletin Blogs 1.0.x and 2.0.x *Optional
• vBSEO 2.x, 3.x *Optional

What does it do?
============================

• Auto-generates a Google XML sitemap for all of your specified forum URL types (including vBulletin Blog URLs).
• Auto-generates a Yahoo text sitemap for all of your specified forum URL types.
• Auto-notifies Google when a new sitemap is generated.
• Automatically sends you a summary of the sitemap generation via email each time it is created.
• Includes only publicly accessible forums and threads.
• Allows Google/Yahoo to find all of your forum URLs without having to spider the forum to find the links.
• Allows Google/Yahoo to find your forum URLs without having to account for query string and/or session ID information.
• Allows Google to give precedence to crawling your higher priority forum pages.
• Allows Google to give precedence to crawling your forum pages that change more frequently.
• Allows you to conserve bandwidth by more efficiently facilitating the crawling processes for GoogleBot and Yahoo Slurp.
• Is 100% compatible with the static CRUs (Content Relevant URLs) used by vBSEO-enabled forums.

How does it work?
============================


Whenever it is scheduled or invoked via the URL, this plugin will generate both the Google XML formatted and the Yahoo text formatted sitemaps. If you selected "Yes" to the Google auto-notification setting, Google will be notified each time the sitemap is generated. The Yahoo sitemap must be manually submitted to http://submit.search.yahoo.com/free/request/.

• Google Sitemap files are gzipped
• Forum and thread pages are listed with pagination (i.e. all pages for each forums/thread are included in the sitemap)
• Maximum Priority is set for Sticky threads.
• Optimization for sitemap generation on large forums.

Automated Reporting Tool
============================

The vBSEO Sitemap includes a report tool, allowing you to track your progress. To access your reports enter the following URL:

http://www.example.com/forums/vbseo_sitemap/

NOTE: Replace "http://www.example.com/forums/" with the full URL to your vB forum root.


You will be required to login by providing your "Sitemap Interface Access Password" from your vBSEO Sitemap settings in:

• vBulletin Admin CP (for 3.5.x/3.6.x/3.7.x/3.8.x users) OR
• vbseo_sitemap.php configuration file (for 3.0.x users) located in the vbseo_sitemap directory in your forum root.

Once you successfully login, you will be provided with a list of 'Useful Links'. Here are the 4 main links:

Show Reports List
The 'Show Reports List' link will display a report of each time your vBSEO Sitemap generator executed, including the (1) date, (2) run time, (3) total URLs included, and (4) and change in # of URLs included from the last generation.

Each vBSEO Sitemap generation record will include a (1) "View details" and (2) "Remove record" link. The "View Details" link shows more detailed information about the sitemap generated. The "Remove record" will permanently delete the record from your reports.

Show Sitemap Downloads Log
The 'Show Sitemap Downloads Log' link will display a report of each time your vBSEO Sitemap was downloaded by either a search engine (GoogleBot or Yahoo) or by another user agent (i.e. Web browser, etc.).

The report includes the (1) date, (2) name of sitemap file downloaded, (3) Bot, (4) IP address of the downloader, and the (5) User-agent.

Each vBSEO Sitemap download record will include a "Remove record" link which will permanently delete the record from your reports.

Run Sitemap Generator
The 'Run Sitemap Generator' link will automatically regenerate your Google and Yahoo sitemaps.

Your Forums Homepage
The 'Your Forums Homepage' link is a quick link back to your forum homepage.

Additional Links
Additional links to various other related SEO resources are also included.


Click "Install"
============================

Please click "Install" to show your support for this script.


Installation & Configuration for vB 3.5.x, 3.6.x, 3.7.x and 3.8.x as a Plugin
============================

Follow the installation/upgrade instructions provided in the docs/readme.html file.


Google Webmaster Accounts
============================

It is NOT required for you to have a Google Webmaster account to run the vBulletin Google Sitemaps plugin. If you decide to setup an account for testing purposes you can do so here:
http://www.google.com/webmasters/sitemaps/login?sourceid=gsm&subid=us-et-about2


Copyright & Licensing

============================

• vBSEO Google Sitemaps plugin is copyright protected by Crawlability Inc.
• You are free to download and install this plugin on any vBulletin forum for which you hold a valid vB license.
• Unauthorized distribution of any code and/or documentation, whole or in part, included here is strictly prohibited.
• In addition, the following copyright notice must be maintained.

vBSEO(TM) ? 2005-2009 Crawlability, Inc.


Revision History
============================

02/22/2009 - Version 2.5 Released

NEW FEATURE: Blog tags URLs are included.
NEW FEATURE: Social Group Discussion URLs are included.
NEW FEATURE: Smart Priority applied for the following URL types

1. Show Post
2. Member Profiles
3. Forum Display
4. Poll Results
5. Blog Entries
6. Member Profile Albums
7. Social Groups
8. Social Groups Discussions
9. Social Group Pictures
10. Tags
11. Blog Tags

UPDATE: Compatible with vBulletin 3.8.x. Includes the following updated settings:

1. Priority Range - Show Post
2. Priority Range - Member Profiles
3. Priority Range - Forum Display
4. Priority Range - Poll Results
5. Priority Range - Show Thread
6. Priority Range - Blog Entries
7. Priority Range - Member Profile Albums
8. Priority Range - Social Groups
9. Priority Range - Social Group Pictures
10. Priority Range - Tags

Fix: Social Group Discussion database error is fixed.

Upgrade Instructions
============================

(1) Follow the installation/upgrade instructions provided in the docs/readme.html file.

(2) For versions of vBulletin 3.6.x only: Open "Schedule Manager" in the vBulletin Admin Control Panel (admincp); Remove existing scheduled task for Sitemap Generator if you have one.
Note: The new task will be automatically setup when you import the XML product file.

Other vBSEO Plugins

============================

• vBSEO - vBulletin Search Engine Optimization
  
• vBSEO Conditional Signatures for vBulletin

vBSEO Affiliate Program
============================

We welcome you to join the vBSEO Affiliate Program.

[hugh_]

Originally Posted by iojam

hugh_,

please try this one: http://www.vbseo.com/f67/vbseo-sitem...79/#post139829

I can't access the file in the thread...

[hugh_]

Is there some other way I can get to this file?

Hugh

[Chris04S]

Are there any upload instructions for this? Do we upload the htaccess folder to the root/forum directory, do we not?

[murrtex]

Thanks

[chevy01xtreme]

done fast question after i CHMOD 777 the 'forum-root/vbseo_sitemap/data/' folder . do i leave it this way. or i change the premissions back to 744 ?

[imported_silkroad]

In our forum at www.unix.com/forum_index.php forum 2 is the "Dummies" forum with over 14, 000 threads.

However, the logfile of the sitemap generating process says:

[homepage] [2,525.5Kb mem used] [0s (+0s)]
[SECTION START] forumdisplay [2,525.7Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 2, total threads: 335, pages: 9 [2,526.3Kb mem used] [0s (+0s)]

(blah blah....)

Why does the forum have so many threads but the sitemap generator says there are 355 threads??

[iojam]

hugh_,

try to simply replace "dl_cats" with "file_cats" and "dl_files" with "file_files".


Chris04S,

.htaccess should be created in forums folder.


chevy01xtreme,

leave it at 0777.


imported_silkroad,

you have "Default View Age" option set to "Last month", so older threads are cut out: http://www.unix.com/unix-dummies-que...rs/index9.html I'd recommend to disable this option to show ALL thread for better exposure to search engines.

[hugh_]

Originally Posted by iojam

hugh_,

try to simply replace "dl_cats" with "file_cats" and "dl_files" with "file_files".

I don't see any instances of dl_cats or dl_files, the values are already marked as file_cats and file_files...

Hugh

[iojam]

Oh, that should be reverse replacement then ("file_"=>"dl_").

[hugh_]

Having applied the changes you suggested leaving me with the following I still get an error (below):

Code:

<?php

/************************************************** ****************************************
* vBSEO Google/Yahoo Sitemap Generator for vBulletin v3.x.x by Crawlability, Inc. *
*-----------------------------------------------------------------------------------------*
* *
* Copyright ? 2005-2008, Crawlability, Inc. All rights reserved. *
* You may not redistribute this file or its derivatives without written permission. *
* *
* Sales Email: sales@crawlability.com *
* *
*-------------------------------------LICENSE AGREEMENT-----------------------------------*
* 1. You are free to download and install this plugin on any vBulletin forum for which *
* you hold a valid vB license. *
* 2. You ARE NOT allowed to REMOVE or MODIFY the copyright text within the .php files *
* themselves. *
* 3. You ARE NOT allowed to DISTRIBUTE the contents of any of the included files. *
* 4. You ARE NOT allowed to COPY ANY PARTS of the code and/or use it for distribution. *
************************************************** ****************************************/

$mods = $db->query("SELECT id,name FROM " . TABLE_PREFIX . "dl_cats ORDER BY `order`");
while ($mod = $db->fetch_array($mods))
{
$url = $vbseo_vars['bburl'].'/downloads.php?do=cat&id='.$mod['id'].'&name='.urlencode($mod['name']);

if(VBSEO_ON)
$url = vbseo_any_url($url);

vbseo_add_url($url, 1.0, '', 'daily');
}

$mods = $db->query("SELECT ff.id as fid, ff.name as fname, fc.id as cid, fc.name as cname FROM " . TABLE_PREFIX . "dl_files ff LEFT JOIN dl_cats fc ON
ff.catid=fc.id");
while ($mod = $db->fetch_array($mods))
{
$url = $vbseo_vars['bburl'].'/downloads.php?do=file&id='.$mod['fid'].'&name='.urlencode($mod['fname']).'&cat='.urlencode($mod['cname']);

if(VBSEO_ON)
$url = vbseo_any_url($url);
vbseo_add_url($url, 1.0, '', 'daily');
}
?>

Error:

<!--
Database error in vBulletin 3.7.2:

Invalid SQL:
SELECT id,name FROM dl_cats ORDER BY `order`;

MySQL Error : Unknown column 'order' in 'order clause'
Error Number : 1054
Request Date : Saturday, July 12th 2008 @ 07:06:33 AM
Error Date : Saturday, July 12th 2008 @ 07:06:55 AM
Script : http://www.xxx.com/forum/vbseo_sitemap.php
Referrer : http://www.xxx.com/forum/index.php
IP Address : xxx
Username : Unregistered
Classname : vB_Database
MySQL Version :
-->