I can't access the file in the thread...

Is there some other way I can get to this file?

Hugh

Are there any upload instructions for this? Do we upload the htaccess folder to the root/forum directory, do we not?

Thanks

done fast question after i CHMOD 777 the 'forum-root/vbseo_sitemap/data/' folder . do i leave it this way. or i change the premissions back to 744 ?

In our forum at www.unix.com/forum_index.php forum 2 is the "Dummies" forum with over 14, 000 threads.

However, the logfile of the sitemap generating process says:

Why does the forum have so many threads but the sitemap generator says there are 355 threads??

hugh_,

try to simply replace "dl_cats" with "file_cats" and "dl_files" with "file_files".


Chris04S,

.htaccess should be created in forums folder.


chevy01xtreme,

leave it at 0777.


imported_silkroad,

you have "Default View Age" option set to "Last month", so older threads are cut out: http://www.unix.com/unix-dummies-que...rs/index9.html I'd recommend to disable this option to show ALL thread for better exposure to search engines.

I don't see any instances of dl_cats or dl_files, the values are already marked as file_cats and file_files...

Hugh

Oh, that should be reverse replacement then :) ("file_"=>"dl_").

Having applied the changes you suggested leaving me with the following I still get an error (below):

Code:

<?php

/************************************************** ****************************************
* vBSEO Google/Yahoo Sitemap Generator for vBulletin v3.x.x by Crawlability, Inc. *
*-----------------------------------------------------------------------------------------*
* *
* Copyright ? 2005-2008, 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. *
************************************************** ****************************************/

$mods = $db->query("SELECT id,name FROM " . TABLE_PREFIX . "dl_cats ORDER BY `order`");
while ($mod = $db->fetch_array($mods))
{
$url = $vbseo_vars['bburl'].'/downloads.php?do=cat&id='.$mod['id'].'&name='.urlencode($mod['name']);

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 dl_cats fc ON
ff.catid=fc.id");
while ($mod = $db->fetch_array($mods))
{
$url = $vbseo_vars['bburl'].'/downloads.php?do=file&id='.$mod['fid'].'&name='.urlencode($mod['fname']).'&cat='.urlencode($mod['cname']);

if(VBSEO_ON)
$url = vbseo_any_url($url);
vbseo_add_url($url, 1.0, '', 'daily');
}
?>

Error:

<!--
Database error in vBulletin 3.7.2:

Invalid SQL:
SELECT id,name FROM dl_cats ORDER BY `order`;

MySQL Error : Unknown column 'order' in 'order clause'
Error Number : 1054
Request Date : Saturday, July 12th 2008 @ 07:06:33 AM
Error Date : Saturday, July 12th 2008 @ 07:06:55 AM
Script : http://www.xxx.com/forum/vbseo_sitemap.php
Referrer : http://www.xxx.com/forum/index.php
IP Address : xxx
Username : Unregistered
Classname : vB_Database
MySQL Version :
-->