VBA Links Directory site map

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

Thanks for any help
Lee G

I'm interested in this as well.

I am too

me too

Anyone of vBSEO devlopers answer please ?
Thanks

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.

Hello Oleg ,
I have same Lee G error , also could you please add the .html format for the sitemap , because i convert my vBA LINKS to .html links .
Thanks ,
Zi5

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 Oleg ,
This the DB error
Database error in vBulletin 3.6.8:
Invalid SQL:
SELECT * FROM links_categories WHERE private = 0;
MySQL Error : Table 'xxxxxx_vb.links_categories' doesn't exist
Error Number : 1146
Date : Wednesday, December 5th 2007 @ 04:42:59 AM

Thanks

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.

PM sent

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