vBadvanced Dynamics for sitemap inclusion

If you want to ask a question to Brian i advise you to use vbadvanced.com forums.

Hi there everyone,

We have completed this as an addon to vBSEO.

What this addon does: it adds the Dynamics URLs for all categories and articles in the system to the vBSEO Sitemap [after the forums URLs].

The URLs used are preserved as the ones from Dynamics [SEO friendly].

Default weight is 1.0 for categories and 0.5 for articles. Default frequency is daily for categories and weekly for articles.

vBSEO staff - feel free to add it to your addons list.. it might help lots of other people!

Original thread post:

vBSEO Sitemap Addon - vBadvanced Forums

The vBSEO Sitemap addon for Dynamics is attached.


Cheers,
aproape

P.S. Thanks for deathemperor for the initial sharing of his code which we adapted to use the Dynamics SEO URLs.

Thanks, do you know how to use this with multiple instances?

Hi there Arkidas,

Originally Posted by Arkidas

Thanks, do you know how to use this with multiple instances?

If I am not mistaken, 2nd and 3rd [and so on] instances of Dynamics use different tables for entries/replies/etc.

All you have to do is duplicate the lines in the sitemap file [pretty much everything after vba_dyna_url = line] and change the table names from adv_dyna_categories and adv_dyna_entries to your 2nd and/or 3rd table names..

You need to duplicate again those lines for each instance of Dynamics.

Let me know if you need more help.


Cheers,
aproape

Just did that and it doesn't seem to be enough.
My sitemap is here.

PHP Code:

<?php 
/******************************/ 
//Dynamics vBSEO Sitemap Addon v1.0 
// Copyright aproape/Maribal Inc. 15 Sep 2008 
// Replace the URL below with your vBa Dynamics main folder URL 
 
    require_once('includes/vba_dyna_functions.php'); 
     
    if(VBSEO_ON) 
    { 
        $vba_options['dyna_spiderurls'] = true; 
    } 
     
    $vba_dyna_url = 'http://malesopranos.com/CDs'; 
 
     
    //adding the categories to the sitemap 
    $cats = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "adv_dyna_categories"); 
    while ($cat = $db->fetch_array($cats)) 
    { 
        $url = fetch_cat_url($cat['catid']); 
        /*if(VBSEO_ON) 
            $url = vbseo_any_url($url);*/ 
 
        $url = $vba_dyna_url . $url; 
 
          vbseo_add_url($url, 1.0, $cat['lastupdated'], 'daily'); 
    } 
 
 
    //adding the articles/entries to the sitemap 
    $entries = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "adv_dyna_entries WHERE open > 0"); 
    while ($entry = $db->fetch_array($entries)) 
    { 
        $url = fetch_entry_url($entry); 
 
        /*if(VBSEO_ON) 
            $url = vbseo_any_url($url);*/ 
 
        $url = $vba_dyna_url . $url; 
 
          vbseo_add_url($url, 0.5, $entry['lastupdated'] ? $entry['lastupdated'] : $entry['dateline'], 'weekly'); 
    }


    //adding the categories to the sitemap 
    $cats = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "article__categories"); 
    while ($cat = $db->fetch_array($cats)) 
    { 
        $url = fetch_cat_url($cat['catid']); 
        /*if(VBSEO_ON) 
            $url = vbseo_any_url($url);*/ 
 
        $url = $vba_dyna_url . $url; 
 
          vbseo_add_url($url, 1.0, $cat['lastupdated'], 'daily'); 
    } 
 
 
    //adding the articles/entries to the sitemap 
    $entries = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "article__entries WHERE open > 0"); 
    while ($entry = $db->fetch_array($entries)) 
    { 
        $url = fetch_entry_url($entry); 
 
        /*if(VBSEO_ON) 
            $url = vbseo_any_url($url);*/ 
 
        $url = $vba_dyna_url . $url; 
 
          vbseo_add_url($url, 0.5, $entry['lastupdated'] ? $entry['lastupdated'] : $entry['dateline'], 'weekly'); 
    } 
 
 
?>

Hi there Arkidas,

What exactly is that you don't see? I took a look at your sitemap and I don't see any errors in it..


Cheers,
aproape

One more detail on the modified code you posted - I see that article__categories table name has double underscore - is that correct?


Cheers,
aproape

Yes it's correct. There's no error but the second instance's URLs aren't in the sitemap. The first instance is /CDs ( which is there ) and the second is /articles and that one doesn't appear in the sitemap's URL list.

EDIT: Never mind, I see that /articles IS in http://malesopranos.com/sitemap_1.xml.gz although I didn't see it in the urlslist file.

Hi there Arkidas,

Glad it works ;-)


Cheers,
aproape

Originally Posted by Arkidas

Yes it's correct. There's no error but the second instance's URLs aren't in the sitemap. The first instance is /CDs ( which is there ) and the second is /articles and that one doesn't appear in the sitemap's URL list.

EDIT: Never mind, I see that /articles IS in http://malesopranos.com/sitemap_1.xml.gz although I didn't see it in the urlslist file.

I just noticed a very bad problem. For some reason, a part each vBDynamics URLs is missing in the sitemap ( the category name ).

Example: In site map this URL -
http://malesopranos.com/CDs/radu-mar...dellaurora-21/

Becomes:
http://malesopranos.com/CDs/tomaso-a...dellaurora-21/

And is therefore broken :(. I've disabled the addon until this has been fixed.

PHP Code:

<?php 
/******************************/ 
//Dynamics vBSEO Sitemap Addon v1.0 
// Copyright aproape/Maribal Inc. 15 Sep 2008 
// Replace the URL below with your vBa Dynamics main folder URL 
 
    require_once('includes/vba_dyna_functions.php'); 
     
    if(VBSEO_ON) 
    { 
        $vba_options['dyna_spiderurls'] = true; 
    } 
     
    $vba_dyna_url = 'http://malesopranos.com/CDs';
    $vba_article_url = 'http://malesopranos.com/articles'; 
 
     
    //adding the categories to the sitemap 
    $cats = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "adv_dyna_categories"); 
    while ($cat = $db->fetch_array($cats)) 
    { 
        $url = fetch_cat_url($cat['catid']); 
        /*if(VBSEO_ON) 
            $url = vbseo_any_url($url);*/ 
 
        $url = $vba_dyna_url . $url; 
 
          vbseo_add_url($url, 1.0, $cat['lastupdated'], 'daily'); 
    } 
 
 
    //adding the articles/entries to the sitemap 
    $entries = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "adv_dyna_entries WHERE open > 0"); 
    while ($entry = $db->fetch_array($entries)) 
    { 
        $url = fetch_entry_url($entry); 
 
        /*if(VBSEO_ON) 
            $url = vbseo_any_url($url);*/ 
 
        $url = $vba_dyna_url . $url; 
 
          vbseo_add_url($url, 0.5, $entry['lastupdated'] ? $entry['lastupdated'] : $entry['dateline'], 'weekly'); 
    }


    //adding the categories to the sitemap 
    $cats = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "article__categories"); 
    while ($cat = $db->fetch_array($cats)) 
    { 
        $url = fetch_cat_url($cat['catid']); 
        /*if(VBSEO_ON) 
            $url = vbseo_any_url($url);*/ 
 
        $url = $vba_article_url . $url; 
 
          vbseo_add_url($url, 1.0, $cat['lastupdated'], 'daily'); 
    } 
 
 
    //adding the articles/entries to the sitemap 
    $entries = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "article__entries WHERE open > 0"); 
    while ($entry = $db->fetch_array($entries)) 
    { 
        $url = fetch_entry_url($entry); 
 
        /*if(VBSEO_ON) 
            $url = vbseo_any_url($url);*/ 
 
        $url = $vba_article_url . $url; 
 
          vbseo_add_url($url, 0.5, $entry['lastupdated'] ? $entry['lastupdated'] : $entry['dateline'], 'weekly'); 
    } 
 
 
?>

Hi there Arkidas,

Are you sure your URLs are:

http://malesopranos.com/CDs/tomaso-a...dellaurora-21/

OR

http://malesopranos.com/CDs//tomaso-a...dellaurora-21/ ??

Also, are you using the CMPS module for Dynamics -> CMPS Module - New/Random Entries (updated for v1.0.0) - vBadvanced Forums

If you are - make sure it is the _latest_ version [re-download and re-install - Brian doesn't update the version numbers.. so you need to do it again even if the version numbers match].

Also, see this thread for more information:

vBSEO Sitemap Addon - vBadvanced Forums

There is a bug with one of the plugins in Dynamics - nothing much we can do except work-around it..


Cheers,
aproape

Sorry, vBulletin messed the URLs here.

No, I don't use CMPS ( although I have it installed ).

I don't have a double slash problem because as you can see, I figured myself that not having a slash after 'CDs' and 'articles' would take care of it. My problem is the following:

Correct URL format is ( obviously replace hxxp with http ):

hxxp://malesopranos.com/CDs/radu-marian-4/tomaso-albinoni-il-nascimento-dellaurora-21/

But sitemap shows URLs in the following format which is invalid because category is missing ( in this case it's /radu-marian-4/ ):

hxxp://malesopranos.com/CDs/tomaso-albinoni-il-nascimento-dellaurora-21/

I also have that problem where there are many /CDs/ in the sitemap instead of one for each category. Not sure if it's the same with the second instance URLs ( /article/ ).

How did you fix this for larina?

[addon module] vbseo_sm_dynamics.php [7,263.8Kb mem used] [0s (+0s)]

Fatal error: Call to undefined function fetch_cat_url() in /home/poreddun/public_html/forum/vbseo_sitemap/addons/vbseo_sm_dynamics.php on line 21


why..??

Do you have dynamics installed? If not remove it from your addons field in the sitemap options.