DOWNLOAD II sitemap error

hello
i install download II and vbseo make rewrite perfect by your product but i just test vbseo sitemap by adding vbseo_sm_downloads2.php to the addon option and after that if i generate report it give me error
so is there any addon which work for DOWNLOAD II in vbseo sitemap ?

Hello,

what exactly is the error you get?

i use DOWNLOAD II

it gives error of tables not exist

i try to fix the file and i make it work but still not rewrite the url

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.    *
 ******************************************************************************************/
$dyna_url = 'http://www.mysite.com/';
    $mods = $db->query("SELECT * FROM " . TABLE_PREFIX . "dl_cats");
    while ($mod = $db->fetch_array($mods))
    {    
        $url = 'downloads.php?do=cat&title='.urlencode($mod['name']).'&id='.$mod['id'];

        if(VBSEO_ON)
            $url = vbseo_any_url($url);
$url = $dyna_url . $url;
           vbseo_add_url($url, 1.0, $mods['lastupdated'], 'daily');
    }

    $mods = $db->query("SELECT ff.id as fid, ff.name as fname, fc.id as caid, fc.name as cname FROM " . TABLE_PREFIX . "dl_files ff LEFT JOIN vb5_dl_cats fc ON ff.id=fc.id");
    while ($mod = $db->fetch_array($mods))
    {
        
        $url = 'downloads.php?do=file&title='.urlencode($mod['fname']).'&cid='.$mod['caid'].'&ctitle='.urlencode($mod['cname']).'&id='.$mod['fid'];

        if(VBSEO_ON)
            $url = vbseo_any_url($url);
      $url = $dyna_url . $url;
           vbseo_add_url($url, 1.0, $mods['lastupdated'], 'daily');
    }
?>

What do you get in sitemap?

i get :
adress without rewrite roles
ex:
http://www.mysite.com/downloads.php?...orton-program&cid=&ctitle&id=87

Mm.. it should not create "downloads.php?file=norton-program.." URLs as there are only "http://www.mysite.com/downloads.php?do=file&..." and "http://www.mysite.com/downloads.php?do=cat&..." links added.

does this mean it will not rewrite the links completely?

how to fix it

Is that a *real* example URL?

Code:

http://www.mysite.com/downloads.php?...orton-program&cid=&ctitle&id=87

it is just an example !
u can test the code

thanks

I need an exact URL from your sitemap and CRRs list you have defined (you can PM it if you wish).

I will keep an eye on this thread because I am running downloads II allso.