what do you want to restrict them to? it could easily be done.

what if I wanted to restrict the database to show only .zip files....

Under
===============
$extension = substr(strrchr($att[filename],"."),1);
Add
===============
if($extension!="zip") {
continue;
}

i know this might be a newbie question but it will help me a lot i need the following info
i run forums with a host and have 10 Gig Transfer and 1 Gig space i also have access to mysql and space with my isp i like to link my images and attachments on that server to save bandwith i would be graet full if anyone can direct me in the right direction
many thanks in Advance

Great job rake. With that added index it works great! I would love to have it show file size on the view page, but other than that it's great! :D

Nope it's kills my dedicated server.
I'm using only the updated files.
It took more than a minute to load the page

By the way my attachment database size is 2.6 GB...

Maybe attach.php don't like that fact ?

any news on this great hack?

it still has problems on my mysql server... load's too high ! :(

Attachment Usage: 210.04 MB

Are you sure you ran the queries? The index is vital and drastically reduces load.

Yes I run them. In case you need it I can give you access to my server, but I think it's because the 2,6 GB attachment table...

So if you have a large attachment amount, this will still bring everything to a crawl? :)