i would still like there to be an option to order the attactments by date or number of downloads etc , :cry: wood this b possible ? cheers

This just killed my dedicated server, unfortunately! Too bad, it had a lot of potential. :(

I guess nothing ever got done as far as fixing the load issue. I just installed it, and it loaded a few times....30+ seconds processing time for each pageload. Now my server is down. :(

This is a great idea, and I think this functionality should be part of vB. It would be great to also have the ability to see if the thread still exists, and let you delete selected attachments. Viewing size would be great too.

I tried this one as well, I had to shut down mysql because it was killing it. Perhaps it's selecting too many attachments? I have an attachment database of 400 MB so maybe that's what caused it, because when installing it locally it worked.

Good idea with the hack though. :)

Well im sure you had good intentions but i had to remowe this hack from my shared server and as ive been told all the people running this hack had to remove it.
I highly dont recommend installing this hack due to the server kill it creates. This is two emails i just recieved from my host http://www.f5hosting.com:


And after i removed the file this is the second email i recieved:




lol , not to be mean, i dont know nothing about writing hacks, but Michael totally burned you !!!! :)

No doubt ... the code is bad.

Better let someone revise this hack. It has great potential! :)

*bump* :)

Cool hack

I would link thread to the post which has the attachment, using
showthread.php?s=$session[sessionhash]&postid=$att[postid]#post$att[postid]" , and open them in new window:




for big forum with many attachments, the script takes too long :((

Well, at least he's right about my age, but you don't measure the speed of a query by the number of joins. I mean, wow! It's got three joins in it, it must be bad. Oh well, i shouldn't complain. It was my fault.

Here's the fix:
Run the following query:
ALTER TABLE `post` ADD INDEX ( `attachmentid` )

and replace attach.php with the attached file. Be sure to TEST IT.

Can someone please test it? I have only my liveboard @ the moment but i need this hack! :)

Thanks in advance
Kars

Works great! :D version 2.2.9

@ Rake, theres a Bug.

Search for:

replace it with:

Kars :)

Thank Kars. I'll update the file. :)

N/P.
I thank you for this Great Hack!

Kars:)

Hi! is it possible to sort by date, username, thread and etc. (not only by downloads)?

Thanx

Yes. Replace the attachment template with the one attached, and the re-updated attach.php file a couple of posts above and you'll get that extra functionality.

rake, thanx a million! ;)

Does this work properly without killing the server yet?

@ TheComputerGuy, yes it works like a charm. :)

Kars

Nice hack!

I am looking for a hack that will show only a certain type of files in the database (not the .jpg's). Can I use this hack then - and which one of the other hacks below do you recommend I use?

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? :)

I love the concept of the hack, but I had no idea where to place a link to it..
It's an awkward thing to place since it's only really an archive and doesn't add any kind of functionality to the forums..

I placed it below my $logincode in the welcome panel for now.. ;)

Excellent work though!


[Edit]
There still seems to be an issue with the amount of MySQL load this requires.
I'm using the latest file and ran the query, but I came to the server this morning and it was running at snails pace. Also on the Microstats, the MySQL % had shot up from around an average of 50% to a whopping 95%+. Upon removal, both the speed and MySQL load statistic returned back to normal.

Anyone wanting to remove the query can use this:
ALTER TABLE `post` DROP INDEX ( `attachmentid` )

hi rake,
nice hack. :)

however, there seems to be a small problem with the page link. if you klick on "last page" you come to e.g. page 55. the listing is blank. the previous 5 or 6 page also. any ideas?

tina

Ive followed all the instructions..

It makes me server load jump to 100%...

gota have to uninstall.. o well it looked good :S

ALTER TABLE `post` DROP INDEX ( `attachmentid` )

ERROR 1064: You have an error in your SQL syntax near '( `attachmentid` )' at line 1


;)

There's nothing wrong with the syntax.. All it's doing is reversing the original query that was run.

Did the original query run successfully?
ALTER TABLE `post` ADD INDEX ( `attachmentid` )

It's good to see it working now.

can someone tell me how I can limit this so it displays attatcments from certain forums instead of all of them

Any updates on this that wont crash my server and have the options to manage the attachments (ie. delete...prun)?