I tried to install it on a 6.3.2 board not using the iip. and it was harder than I thought. I never did get it right. I deleted it all and ill try again later.

getting errors myself<br /><br />SQL ERROR: Mon, Mar 01 2004 01:59:41 -0500 Unable to do_query: SELECT DL_CatOrder FROM w3t_Dlcat ORDER BY DL_CatOrder ASC <br />Unknown column 'DL_CatOrder' in 'field list'<br />Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /....../ubbthreads/mysql.inc.php on line 160<br />SQL ERROR: Mon, Mar 01 2004 01:59:41 -0500 Unable to do_query: SELECT DL_CategoryName,DL_CatOrder FROM w3t_Dlcat ORDER BY DL_CatOrder ASC <br />Unknown column 'DL_CatOrder' in 'field list'<br />Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /............/ubbthreads/mysql.inc.php on line 160

sql idiot here but it looks like <br /> <br />DL_CatOrder isn't in the w3t_Dlcat <br /> <br />I browsed the database and don't see that hiding in there. Is that right?

That's what it looks like to me. If you add that field it should get rid of that error.<br /><br />Then you can troubleshoot the next error that pops up. <img src="http://www.ubbdev.com/forum/images/graemlins/evil.gif" alt="" />

How do I add it? I am sql stupid

well the first question is what the field is? is it an INT or a VARCHAR or a.. and what length and if an INT is it autoincrement.. there is alot of questions.. before you just add a field...

its for this mod beyond that I am clueless

According to this command<br /><br />CREATE TABLE w3t_Dlcat ( DL_CategoryName varchar(30) NOT NULL, DL_CatOrder tinyint(3) Default '0' NOT NULL, KEY DL_CategoryName (DL_CategoryName));<br /><br />I used that command but it didn't work properly?

okay this mod is having you create two tables did the first one w3t_Downloads get created? Is it both that are giving you problems or just the second one w3t_Dlcat? BTW the notes say that creating the second table w3t_Dlcat with balk an error.

I ran both.. page comes up but it generates errors on the page. So far the only error I get is the one I posted above

Hrmmm really need to see what the $user is throwing out.. Generic Threw an error? Hmmm ok well thats why I have IIP... do you have phpMyAdmin loaded on your box or another front-end like CPANEL or PLESK? I would have you go in and verify that it created the table..

yup I have cpanel phpMyAdmin and IIp (but the newer version)

ok then use phpMyAdmin and see if the w3t_Dlcat was created <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" />

ok I just added this to my test board and I will have to say the instructions are wropng.. you need to sql this table not the opne in the instructions<br /><br />CREATE TABLE w3t_Dlcat (<br /> DL_CategoryName varchar(30) NOT NULL,<br /> DL_CatOrder tinyint(3) Default '0' NOT NULL,<br /> KEY DL_CategoryName (DL_CategoryName)<br />);<br /><br />secondly I would use Allen's code check<br /><br />change <br /><br /> if (!strpos($user['U_Groups'],$dlgroup)) {<br /><br />to this, in all pages:<br /><br />if (strpos($user['U_Groups'],$dlgroup) === false) {<br /><br /><br />lastly it's Beta and thus needs some work...

okay smiles here use this zip I fixed a few things that Allen had suggested on the first page in all the files. Also included the correct tables and um oh yeah when you delete the file it does delete it from the database but not off the server but I figure thats a good thing cause you don't want willy-nilly to be able to delete things off your server with this script..I would suggest using the File Atachments download on the IIP menupal and the file attachments of threads itself but this script does do a few things they don't like allow for categories...

Appreciate the help.. I gave it a whirl tonight and got the same errors hmm. <img src="http://www.ubbdev.com/forum/images/graemlins/confused.gif" alt="" />

I deleted and am going to just use the iip and private forums.