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.

[aryshi]

after upgrading vb to 3.8.0

i got this error , need help

Fatal error: Out of memory (allocated 45613056) (tried to allocate 10223616 bytes) ***/vb/vbseo_sitemap/vbseo_sitemap_functions.php on line 1295

[bollie]

Wen i run sitemap

Database error in vBulletin 3.8.0:

Invalid SQL:

SELECT count(*)as cnt,max(dateline) as lastupdate
FROM groupmessage
WHERE groupid='3';

MySQL Error : Unknown column 'groupid' in 'where clause'
Error Number : 1054
Request Date : Wednesday, January 21st 2009 @ 05:03:59 PM
Error Date : Wednesday, January 21st 2009 @ 05:04:04 PM
Script : http://www.xxxxxxxxxx/vbseo_sitemap/vbseo_sitemap.php
Referrer : http://www.xxxxxxxxx/vbseo_sitemap/index.php
IP Address : xxxxxxxxxxx
Username : Niet geregistreerd
Classname : vB_Database

[Lizard King]

Originally Posted by jazan

after upgrading vb to 3.8.0



i got this error , need help

Fatal error: Out of memory (allocated 45613056) (tried to allocate 10223616 bytes) ***/vb/vbseo_sitemap/vbseo_sitemap_functions.php on line 1295

Try disabling yahoo format text based sitemap generator , manually delete all your existing sitemaps and then re generate sitemap files. Or you can also increase your php memory_limit

Originally Posted by bollie

Wen i run sitemap



Database error in vBulletin 3.8.0:



Invalid SQL:



SELECT count(*)as cnt,max(dateline) as lastupdate

FROM groupmessage

WHERE groupid='3';



MySQL Error : Unknown column 'groupid' in 'where clause'

Error Number : 1054

Request Date : Wednesday, January 21st 2009 @ 05:03:59 PM

Error Date : Wednesday, January 21st 2009 @ 05:04:04 PM

Script : http://www.xxxxxxxxxx/vbseo_sitemap/vbseo_sitemap.php

Referrer : http://www.xxxxxxxxx/vbseo_sitemap/index.php

IP Address : xxxxxxxxxxx

Username : Niet geregistreerd

Classname : vB_Database

find this in vbseo_sitemap_functions.php file:

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]'
             "); 


[aryshi]

thanx Lizard King

glad to see it work again

[joe1989]

This working with 3.8?

[globalmoney]

Originally Posted by joe1989

This working with 3.8?

Yes, working.

[joe1989]

I'm sorry this might be a stupid question...

In the readme file it says to only edit the settings if you "know what you're doing" because they are set to be optimized for most boards. Well, I'm not experienced at all in this area, so I left them as is. But, out of curiosity, I wanted to look and see what kinds of options there were. The first one is "VBSeo Installed?" and the default answer is yes. Do I have that installed? I have not purchased VBSeo, so would I change it to no? It seems like I should, but the description of the question talks about static CRUs and things, and I haven't the slightest idea what any of those are. All I have is this product that this thread relates to - the free one. I did not pay for VBSeo. Should I select Yes (default) or change to no???

Thanks!

[Lizard King]

If you donot have vBSEO installed , then you should choose that option set to No.

[Das UndergrounD]

I get the following error:

Invalid SQL:

SELECT t_threadid,count(*) as cnt
FROM vb_linkback
GROUP BY t_threadid;

MySQL Error : Table 'linkback' doesn't exist
Error Number : 1146

[iojam]

Das UndergrounD,

if you have vBSEO installed, make sure that you have the latest version (v3.2.0) xml product file in vB admincp.