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.

[iojam]

Das UndergrounD,

if you don't have vBSEO installed, turn off "vBSEO URLs" option.

havard20009,

you should check the *html source*, not the on page content for exact message.

[havard20009]

<!--
Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT *
FROM blog
WHERE state = 'visible';

MySQL Error : Unknown column 'state' in 'where clause'
Error Number : 1054
Request Date : Thursday, February 19th 2009 @ 03:51:55 AM
Error Date : Thursday, February 19th 2009 @ 03:51:57 AM
Script : http://...com/forums/vbseo_sitemap/vbseo_sitemap.php
Referrer : http://.com.com/forums/vbseo_sitemap/
IP Address : 120.28.133.235
Username : not register
Classname : vB_Database
MySQL Version :
-->


also i used this code 4 resolve but i have problem with this

PHP Code:
$tcount = $db->query_first("
SELECT count(*)as cnt,max(dateline) as lastupdate
FROM " . TABLE_PREFIX . "groupmessage
WHERE groupid='$rrow[groupid]'
");
replace with

PHP Code:
$tcount = $db->query_first("
SELECT count(*)as cnt,max(dateline) as lastupdate
FROM " . TABLE_PREFIX . "groupmessage AS groupmessage
LEFT JOIN " . TABLE_PREFIX . "discussion AS discussion ON (groupmessage.discussionid = discussion.discussionid)
WHERE discussion.groupid='$rrow[groupid]'
");

[iojam]

Do you have vBulletin Blog installed? If yes, are you running the latest version?

[goxy63]

please update for 3.8.1

[carrlos]

I tested mod_rewrite and it works. The generator generates the sitemap in the .../data folder. The problem is that I get a 404 error when trying to access it. Google is saying the same thing. I have the .htaccess file in the forum root. I gave this link to Google:

http://www.mywebsite.com/forum/sitemap_index.xml.gz

Any suggestions?

[Huy Ho?ng]

Uninstall this version to switch to version 3.8
Good job

[Scalemotorcars]

Seems to be working fine. Thanks! :up:

[Ipuck]

I have been using the Sitemap Generator for months, I just upgrade to 2.5 and I have a couple of questions

Questions:

Show Sitemap Downloads Log -- Should I erase or keep them? Is there any option no to save the log?

Show SE Bots Activity Log-- How do I erase the log? if it is possible to erase, should I erase or keep them? Is there any option no to save the log?

Show Reports List -- Should I erase or keep the list? Is there any option no to save the list?

Last question: I upgraded to 2.5 but still shows 2.2 at the bottom, am I doing something wrong?

[iojam]

I'd recommend to setup "Prune log" setting in vbseo_sitemap_config.php file to automatically erase old logs:

	define('VBSEO_SM_PRUNE', 0); // logs age in days to prune

Last question: I upgraded to 2.5 but still shows 2.2 at the bottom, am I doing something wrong?

Make sure that you uploaded all new files to vbseo_sitemap/ folder and imported xml product file in vB admincp.

[rinkrat]

I just upgraded from the previous version and now when I run the script it stalls here

forumdisplay] forum_id: 15, total threads: 382, pages: 13 [6,631.5Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 20, total threads: 172, pages: 6 [6,637.4Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 43, total threads: 225, pages: 8 [6,641.0Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 45, total threads: 70, pages: 3 [6,644.2Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 46, total threads: 134, pages: 5 [6,646.5Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 44, total threads: 25, pages: 1 [6,648.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 47, total threads: 71, pages: 3 [6,649.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 18, total threads: 108, pages: 4 [6,650.5Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 11, total threads: 299, pages: 10 [6,651.9Kb mem used] [0s (+0s)]
[SECTION START] showthread [6,655.2Kb mem used] [0s (+0s)]

How can I kick start it to finish the job?