RSS Feeds listed in Sitemap

This is another quick and dirty one I made. It does not take actual permission into account for the forums, but it will only add links where the forum is visible to everyone.

This will work for feeds for:
forums
vba links directory
video directory remixed
vb albums

PHP Code:

<?php
    $vba_feed_url = $vbseo_vars['bburl'];

//pull only forum feeds that are visible to all
    $lnkg = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "forum WHERE showprivate = 0");
    while ($lnk = $db->fetch_array($lnkg))
    {
        $url = 'external.php?forumids='.$lnk['forumid'];
        if(VBSEO_ON)
        $url = vbseo_any_url($url);

          vbseo_add_url($url, 1.0, $lnk['lastupdated'], 'daily');
    }
    
//pull vba links directory feeds that are active
    $lnkg = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "adv_links_categories WHERE active = 1");
    while ($lnk = $db->fetch_array($lnkg))
    {
        $url = 'external.php?catids='.$lnk['catid'];
        if(VBSEO_ON)
        $url = vbseo_any_url($url);

          vbseo_add_url($url, 1.0, $lnk['lastupdated'], 'daily');
    }
    
//pull video directory links directory feeds that are active
    $lnkg = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "videocategory WHERE active = 1");
    while ($lnk = $db->fetch_array($lnkg))
    {
        $url = 'video.php?do=rss&categoryid='.$lnk['videocategoryid'];
        if(VBSEO_ON)
        $url = vbseo_any_url($url);

          vbseo_add_url($url, 1.0, $lnk['lastupdated'], 'daily');
    }
    
//pull public photo album feeds
    $lnkg = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "album WHERE state = public");
    while ($lnk = $db->fetch_array($lnkg))
    {
        $url = 'album.php?albumfeed='.$lnk['albumid'];
        if(VBSEO_ON)
        $url = vbseo_any_url($url);

          vbseo_add_url($url, 1.0, $lnk['lastupdated'], 'daily');
    }
            
?>

Hello Matt ,

vBSEO Sitemap Generator already only pulls data from forums that are open to guests. Additionally to that you can exclude any forum you want within vBSEO Sitemap Generator.

Yes, but I did not see any options for RSS feeds. Sure it is technically the same data that's already within the forums/videos/albums/links, but not in RSS form. Personally, I search for RSS feeds for things I'm interested in. Even if I don't go to the actual website, I still like to add good RSS feeds to my reader. The idea behind this was that I'm not the only one who searches for RSS feeds so when keywords from my site + "RSS" were put into a search engine that we would come up towards the top.