vBulletin SEO Forums

SEO

vBulletin Search Engine Optimization

Buy vBSEO Now! HACKER SAFE certified sites prevent over 99.9% of hacker crime.
ne nw
vBSEO Total Support Team Launches DeskPro New vBSEO Discount Level for Network Builders vBSEO 3.2.0 GOLD Has Landed Success with vBSEO = 600ore Web Visitors + $1400 in a Day! Crawlability Inc. Files for SEO Technology Patent
se sw

VBA Links Directory site map

This is a discussion on VBA Links Directory site map within the Feature Requests forums, part of the vBSEO Google/Yahoo Sitemap category; Has anyone done a site map add on for VB Advanced links directory? Thanks for any help Lee G...

Go Back   vBulletin SEO Forums > vBSEO Google/Yahoo Sitemap > Feature Requests

Enhancing 80 million pages.

Register FAQ Members List Social Groups Calendar Search Today's Posts Mark Forums Read

Reply

 

LinkBack Thread Tools
  #1  
Old 11-18-2007, 10:09 AM
Senior Member
 
Real Name: Lee
Join Date: Sep 2006
Location: Costa Blanca
Posts: 295
VBA Links Directory site map

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

Thanks for any help
Lee G
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #2  
Old 11-21-2007, 05:13 PM
Junior Member
 
Real Name: Chris Raymond
Join Date: Nov 2007
Posts: 14
I'm interested in this as well.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #3  
Old 11-30-2007, 11:34 PM
Zi5 Zi5 is offline
Member
 
Real Name: Kool
Join Date: Feb 2007
Posts: 48
I am too
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #4  
Old 12-03-2007, 01:11 PM
Member
 
Real Name: nayf
Join Date: May 2007
Posts: 35
me too
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #5  
Old 12-03-2007, 02:58 PM
Zi5 Zi5 is offline
Member
 
Real Name: Kool
Join Date: Feb 2007
Posts: 48
Anyone of vBSEO devlopers answer please ?
Thanks
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #6  
Old 12-03-2007, 04:16 PM
Oleg Ignatiuk's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
 
Real Name: Oleg Ignatiuk
Join Date: Jun 2005
Location: Belarus
Posts: 21,916
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($url1.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($url0.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.
__________________
Oleg Ignatiuk / Crawlability Inc.
Support Team Launches New DeskPro Powered Tool Enhanced Support at Your Service

vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.


Last edited by Oleg Ignatiuk; 09-04-2008 at 03:15 PM. Reason: db table names changed
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #7  
Old 12-04-2007, 05:36 AM
Senior Member
 
Real Name: Lee
Join Date: Sep 2006
Location: Costa Blanca
Posts: 295
Cheers for sorting that out Oleg. I shall try it shortly
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #8  
Old 12-04-2007, 05:53 AM
Senior Member
 
Real Name: Lee
Join Date: Sep 2006
Location: Costa Blanca
Posts: 295
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

Quote:
[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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #9  
Old 12-04-2007, 08:42 AM
Zi5 Zi5 is offline
Member
 
Real Name: Kool
Join Date: Feb 2007
Posts: 48
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #10  
Old 12-04-2007, 08:54 AM
Oleg Ignatiuk's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
 
Real Name: Oleg Ignatiuk
Join Date: Jun 2005
Location: Belarus
Posts: 21,916
What is the db error message? You should be able to see it in html source.
__________________
Oleg Ignatiuk / Crawlability Inc.
Support Team Launches New DeskPro Powered Tool Enhanced Support at Your Service

vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #11  
Old 12-04-2007, 08:54 AM
Oleg Ignatiuk's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
 
Real Name: Oleg Ignatiuk
Join Date: Jun 2005
Location: Belarus
Posts: 21,916
Quote:
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.
__________________
Oleg Ignatiuk / Crawlability Inc.
Support Team Launches New DeskPro Powered Tool Enhanced Support at Your Service

vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #12  
Old 12-05-2007, 05:41 AM
Zi5 Zi5 is offline
Member
 
Real Name: Kool
Join Date: Feb 2007
Posts: 48
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #13  
Old 12-05-2007, 10:48 AM
Oleg Ignatiuk's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
 
Real Name: Oleg Ignatiuk
Join Date: Jun 2005
Location: Belarus
Posts: 21,916
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.
__________________
Oleg Ignatiuk / Crawlability Inc.
Support Team Launches New DeskPro Powered Tool Enhanced Support at Your Service

vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #14  
Old 12-05-2007, 11:38 AM
Zi5 Zi5 is offline
Member
 
Real Name: Kool
Join Date: Feb 2007
Posts: 48
PM sent
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #15  
Old 12-05-2007, 02:26 PM
Oleg Ignatiuk's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
 
Real Name: Oleg Ignatiuk
Join Date: Jun 2005
Location: Belarus
Posts: 21,916
Update: db table names are changed in current version of vBa Links. I've updated the code above correspondingly.
__________________
Oleg Ignatiuk / Crawlability Inc.
Support Team Launches New DeskPro Powered Tool Enhanced Support at Your Service

vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads

Thread Thread Starter Forum Replies Last Post
The vBSEO LinkBacks User Guide - vBSEO 3.0 GOLD Joe Ward General Discussion 25 06-05-2008 12:04 PM


All times are GMT -4. The time now is 05:14 PM.


Powered by vBulletin Version 3.8.0 Release Candidate 2
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.5 ©2008, Crawlability, Inc.