vbseo_sm_downloads2.php failed to run sitemap

Fatal error: Call to a member function query() on a non-object in /home/vbseo_sitemap/addons/vbseo_sm_downloads2.php on line 19

now i tried replacing the db name as im using latest downloadsII version which has new table names but i still get the same error

before

PHP Code:

$mods = $db->query("SELECT id, name FROM " . TABLE_PREFIX . "dl_cats ORDER BY `id`");
while ($mod = $db->fetch_array($mods))
{ 
$url = $vbseo_vars['bburl'].'/downloads.php?do=cat&title='.urlencode($mod['name']).'&id='.$mod['id'];
if(VBSEO_ON)
$url = vbseo_any_url($url);
vbseo_add_url($url, 1.0, '', 'daily');
}
$mods = $db->query("SELECT ff.id as fid, ff.name as fname, fc.id as cid, fc.name as cname FROM " . TABLE_PREFIX . "dl_files ff LEFT JOIN " . TABLE_PREFIX . "dl_cats fc ON ff.category=fc.id");
while ($mod = $db->fetch_array($mods))
{ 
$url = $vbseo_vars['bburl'].'/downloads.php?do=file&title='.urlencode(vbseo_filter_text($mod['fname'])).'&cid='.$mod['cid'].'&ctitle='.urlencode(vbseo_filter_text($mod['cname'])).'&id='.$mod['fid'];
if(VBSEO_ON)
$url = vbseo_any_url($url);
vbseo_add_url($url, 1.0, '', 'daily');
}
?> 


after

PHP Code:

$mods = $db->query("SELECT id, name FROM " . TABLE_PREFIX . "dl2_categories ORDER BY `id`");
while ($mod = $db->fetch_array($mods))
{ 
$url = $vbseo_vars['bburl'].'/downloads.php?do=cat&title='.urlencode($mod['name']).'&id='.$mod['id'];
if(VBSEO_ON)
$url = vbseo_any_url($url);
vbseo_add_url($url, 1.0, '', 'daily');
}
$mods = $db->query("SELECT ff.id as fid, ff.name as fname, fc.id as cid, fc.name as cname FROM " . TABLE_PREFIX . "dl2_files ff LEFT JOIN " . TABLE_PREFIX . "dl2_categories fc ON ff.category=fc.id");
while ($mod = $db->fetch_array($mods))
{ 
$url = $vbseo_vars['bburl'].'/downloads.php?do=file&title='.urlencode(vbseo_filter_text($mod['fname'])).'&cid='.$mod['cid'].'&ctitle='.urlencode(vbseo_filter_text($mod['cname'])).'&id='.$mod['fid'];
if(VBSEO_ON)
$url = vbseo_any_url($url);
vbseo_add_url($url, 1.0, '', 'daily');
}
?> 


Are you on vb4? if so, that mod has not been ported to vb4 yet. that is vb3 code.

sigh then when can we expect an official vb4 script, it has been delayed quite long otherwise

The vb3 version was never an official release either. Perhaps some one can convert it. Its not on our plate at this time.