VBA Links Directory site map

Has anyone done a site map add on for VB Advanced links directory?

Thanks for any help
Lee G

Hello,

you can try this to include vBa Links in sitemap:

PHP Code:

<?php

 /******************************************************************************************
 * vBSEO Google/Yahoo Sitemap Generator for vBulletin v3.x.x by Crawlability, Inc.         *
 *-----------------------------------------------------------------------------------------*
 *                                                                                         *
 * Copyright й 2005-2007, Crawlability, Inc. All rights reserved.                          *
 * You may not redistribute this file or its derivatives without written permission.       *
 *                                                                                         *
 * Sales Email: sales@crawlability.com                                                     *
 *                                                                                         *
 *-------------------------------------LICENSE AGREEMENT-----------------------------------*
 * 1. You are free to download and install this plugin on any vBulletin forum for which    *
 *    you hold a valid vB license.                                                         *
 * 2. You ARE NOT allowed to REMOVE or MODIFY the copyright text within the .php files     *
 *    themselves.                                                                          *
 * 3. You ARE NOT allowed to DISTRIBUTE the contents of any of the included files.         *
 * 4. You ARE NOT allowed to COPY ANY PARTS of the code and/or use it for distribution.    *
 ******************************************************************************************/

// replace the URL below with your vBa links main folder URL
    $vba_links_url = 'http://www.domain.com/links/';

    $lnkg = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "adv_links_categories WHERE private = 0");
    while ($lnk = $db->fetch_array($lnkg))
    {
        $url = 'browselinks.php?c='.$lnk['catid'];
        if(VBSEO_ON)
            $url = vbseo_any_url($url);

        $url = $vba_links_url . $url;

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

    $lnkg = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "adv_links WHERE valid != 2 AND open > 0");
    while ($lnk = $db->fetch_array($lnkg))
    {
        $url = 'showlink.php?do=showdetails&l='.$lnk['linkid'];

        if(VBSEO_ON)
            $url = vbseo_any_url($url);

        $url = $vba_links_url . $url;

          vbseo_add_url($url, 0.5, $lnk['lastupdated'] ? $lnk['lastupdated'] : $lnk['dateline'], 'weekly');
    }

?>

Save it as vbseo_sm_vba_links.php file and put into vbseo_sitemap/addons/ folder. Then add vbseo_sm_vba_links.php in "Addon Generator Modules" option in vB admincp and regenerate sitemap.

Cheers for sorting that out Oleg. I shall try it shortly

Unfortunately, its a non runner. It caused a data base error when run in the site map generator. This is the report from the site map when run

[homepage] [0s (+0s)]
[SECTION START] forumdisplay [0s (+0s)]
[forumdisplay] forum_id: 14, total threads: 19, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 185, total threads: 12, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 146, total threads: 22, pages: 2 [0s (+0s)]
[forumdisplay] forum_id: 156, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 157, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 159, total threads: 1, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 158, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 161, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 160, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 162, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 163, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 164, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 166, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 165, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 167, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 170, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 168, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 169, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 171, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 172, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 173, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 174, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 175, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 176, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 177, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 178, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 179, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 180, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 181, total threads: 1, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 182, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 6, total threads: 218, pages: 11 [0s (+0s)]
[forumdisplay] forum_id: 188, total threads: 7778, pages: 389 [0s (+0s)]
[forumdisplay] forum_id: 140, total threads: 5, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 132, total threads: 3, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 133, total threads: 3, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 135, total threads: 3, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 40, total threads: 8, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 64, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 16, total threads: 21, pages: 2 [0s (+0s)]
[forumdisplay] forum_id: 17, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 184, total threads: 4, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 51, total threads: 66, pages: 4 [0s (+0s)]
[forumdisplay] forum_id: 7, total threads: 44, pages: 3 [0s (+0s)]
[forumdisplay] forum_id: 147, total threads: 17, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 59, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 151, total threads: 21, pages: 2 [0s (+0s)]
[forumdisplay] forum_id: 152, total threads: 13, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 154, total threads: 3, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 153, total threads: 2, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 189, total threads: 7685, pages: 385 [0s (+0s)]
[forumdisplay] forum_id: 20, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 190, total threads: 286, pages: 15 [0s (+0s)]
[forumdisplay] forum_id: 155, total threads: 4, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 80, total threads: 25, pages: 2 [0s (+0s)]
[forumdisplay] forum_id: 22, total threads: 10, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 25, total threads: 10, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 70, total threads: 1, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 38, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 192, total threads: 76, pages: 4 [0s (+0s)]
[forumdisplay] forum_id: 39, total threads: 11, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 116, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 66, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 67, total threads: 6, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 94, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 18, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 191, total threads: 315, pages: 16 [0s (+0s)]
[forumdisplay] forum_id: 37, total threads: 39, pages: 2 [0s (+0s)]
[forumdisplay] forum_id: 43, total threads: 4, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 19, total threads: 1, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 26, total threads: 0, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 27, total threads: 11, pages: 1 [0s (+0s)]
[forumdisplay] forum_id: 28, total threads: 1, pages: 1 [0s (+0s)]
[SECTION START] showthread [0s (+0s)]
[create sitemap file] filename: sitemap_1.xml.gz, number of urls: 20000 [7s (+7s)]
[create sitemap in text format] part #2 [7s (+0s)]
[SECTION START] member [12s (+5s)]
[SECTION START] blogs [12s (+0s)]
[addon module] vb_seo_photoplog.php [12s (+0s)]
[addon module] vbseo-classifieds.php [12s (+0s)]
[addon module] vbseo_sm_vba_links.php [12s (+0s)]
Database errorThe Life In Spain, Costa Blanca British Expatriates community forums database has encountered a problem.Please try the following:

• Load the page again by clicking the Refresh button in your web browser.
• Open the www.thespainforum.com home page, then try to open another page.
• Click the Back button to try another link.

The www.thespainforum.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

What is the db error message? You should be able to see it in html source.

also could you please add the .html format for the sitemap , because i convert my vBA LINKS to .html links .

Do you do that with vBSEO's Custom Rewrite Rules? If so, they should be automatically applied.

Hello,

can you provide me with temporary ftp access to check that? Looks like I have quite an old version of vBa Links in local instance.

Update: db table names are changed in current version of vBa Links. I've updated the code above correspondingly.