VaultWiki - vBSEO Sitemap Integration (VW3)

VaultWiki - vBSEO SiteMap Integration
vBulletin 3.6.x, 3.7.x, 3.8.x, 4.0.x supported
Version: 1.0.6

IMPORTANT! This add-on is not compatible with VaultWiki 4.x series. That add-on is here: https://www.vaultwiki.org/threads/5498/

Requires:
VaultWiki - 3.0.0 - 3.0.21 (NOT compatible with VaultWiki 4.x)
vBSEO Google/Yahoo Sitemap Generator - 2.5+

*** NEWS ***
4/28/2012 - 1.0.6 released
7/1/2010 - 1.0.5 released
6/8/2010 - 1.0.4 released
4/6/2010 - 1.0.3 released
10/19/2009 - 1.0.1-1.0.2 released
10/12/2009 - 1.0.0 released

What It Does:
Includes wiki URLs in your sitemap. This corrects several injustices of default vBSEO SiteMap generation:

• Wiki pages now use "showwiki" URLs instead of "showthread"
• All pages from the comments tab are now included
• Forumdisplay listings are now added even when there is a forum main page

Products to Install: 1
Files to Upload: 1
Files to Edit: 0
Template Edits: 0

* This mod is offered for free here. Please donate if you like this mod *

Posted an update for VaultWiki 3 today. Also fixed a bug where image pages were indexed.

I get the following SQL-error when running the Sitemap-Generator (Cron and manual):

Code:

---

Datenbankfehler in vBulletin 4.0.2:

Invalid SQL:

                        SELECT thread.*, deletionlog.*
                                , art.languageid, art.languageid
                        FROM vb_3thread AS thread
                        LEFT JOIN vb_3deletionlog AS deletionlog ON (deletionlog.primaryid = thread.threadid AND type = 'thread')
                       
INNER JOIN vb_3vault_article AS art ON (art.threadid = thread.threadid)
INNER JOIN vb_3vault_article AS art ON (art.threadid = thread.threadid)
                        WHERE thread.forumid = 105
                                AND thread.visible = 1
                                AND deletionlog.primaryid IS NULL
                        LIMIT 0,12;

MySQL-Fehler  : Not unique table/alias: 'art'

---

Sorry about that. Fixed.

Thanks for the fast fix. It's running now.

3.0.0 Gold compatible version released. If you upgrade to VaultWiki 3.0.0 gold, you'll need to update or your sitemaps will break.

I do not get any results added:
[addon module] special_addon_sitemap.php [5,092.8Kb mem used] [733s (+0s)]

Or is this as expected? Should I see the number of URL's added?

Here was todays report. Not sure hot to validate the success:

Quote:

---

Summary:
============================
Forum Display: 886
Show Thread: 22476
Show Post:
Member Profiles: 5611
Poll Results: 68
Blog Entries: 23
Blog Tags: 0
Album URLs: 3692
Social Groups URLs: 7
Tag URLs: 1337
Archive: 103

Total Indexed URLs: 34493
Total Processing Time: 71,449.83 seconds

---

This addon will not work with the new version of vBSEO Sitemap Generator 3.0.

Why do you say that? Did you get an error message? I have it installed here with 3.0 and the sitemaps are coming out fine as far as I can tell and Google's not complaining.

Nevermind, I figured it out. :)

Will this still work with the most current vBSEO? I was debating purchasing it but I do not want to disrupt the forums on our site.

I haven't noticed any issues using the most recent vBulletin, vBSEO, VaultWiki, and this mod on my own. If indeed you notice something, I will do my best to fix it ASAP.

How does the sitemap generator work? I've had it installed for a little more than a year. When I look at sitemap_addon_1.xml, most of the entries show a change frequency of yearly. This is true for a lot of the stuff I created last year. Recently I have renewed my interest in my wiki and I have updated most of the pages and have loaded some new wiki pages. The new pages show an update frequency of daily, I guess because i just created them. If I google some old pages that I changed a couple months ago, I can see in the google result, information I added last year (for example, the beginning of a google result is April 1 2011 but I changed the page March 2012). So I guess my question is, is there a way to increase the frequency the sitemap generator updates the wiki entries? I can see google results from other pages on my site and I can see they have been updated, and those changes were made just a couple weeks ago. The change frequency in the sitemap generator also reflects that changes were recently made.

Am I missing a setting somewhere that will change the update frequency, or how the sitemap generator detects wiki changes, or am I misunderstanding how the sitemap generator works and how Google treats updates in general?

Maybe my confusion is due to the fact that in VBSEO sitemap settings, there are page update frequency settings for different parts of the site, such as - Page Update Frequency - Forum Display will give you options of always, hourly, daily, weekly, monthly, yearly, etc. I don't see a setting for wiki entries or for generic sitemap addons. Perhaps this is a shortcoming of the vbseo sitemap generator?

Don't want to take you away from working on VW4 for too long but any help or tips you can give me to have my wiki sitemaps updated more frequently - at least while I am still building the wiki - would be appreciated.

If I understand the Page Update Frequency correctly, it should be using the same frequency you have set for forum threads. However, it looks like if you have "Smart" frequency turned on, that there is a bug where it doesn't factor page edits into the calculation.

Fixed and updated ZIP, version 1.0.6. You can resubmit your sitemap to Google to fix the year-frequency. I think the frequency is about Google's crawl rate, so the next sitemap submission should do it.

Thanks Pegasus. I'll give it a try.

Just ran the new version and I see the update frequency changed on most entries on the report. Looks like that fixed it, thanks again!

Thanks you so much:)