Search/Browse Attachments Across All Forums

A little something I whipped up for one of our busier sites, which has several thousand image attachments.

Basically, it allows you to perform searches for attachments across your forums, or just a single forum, by username. You can also sort by date posted, forum it was posted in, thread title, or the attachment filename.

This is a rewrite from the initial version. Due to popular demand, it now uses the vB template system. Yes, Virginia, including your headers and footers. It also uses attachment icons now - kind of a nice touch.

To install, copy attachment_browser.php to your main forums directory. Then, you'll need to create 3 templates:

• attachment_browser_search_form
• attachment_browser_results
• attachment_browser_result_bits

A sample .SQL file is included with the distribution. To create the templates using this file, simply run it through the mysql client as follows:

/path/to/mysql -u user -ppassword db_name template < attachment_browser_templates.sql

Enjoy.

Cheers.
Scott

[xware]

It's a good hack.
but I have found some wrong with it.
The searched attachments aren't as who had Attached in name and posts.
I have a better one and if someone need I'll release it.

[incursio]

Originally posted by FireFly

http://vbulletin.com/forum/showthrea...threadid=33658

So have at it ...

[incursio]

Originally posted by xware
The searched attachments aren't as who had Attached in name and posts.

Huh? Who said what who how?

[incursio]

New version posted - see top of thread again.

[Admin]

Two nice features that will be nice to have:
a) A drop down with all attachments types (gif jpeg zip etc) (only show those that were attached), and you can select which to show
b) Option to find all files that contain a string. Look for "bul" and it'll find "vbulletin.gif" and "bulls.zip".

[incursio]

Will add those in this afternoon if I can. I'm leaving for the holiday tomorrow, so if I don't get to it, it will be a week or so.

Cheers.
Scott

[incursio]

Well, I wrote the functionality for doing extension limiting and keyword searching, and its too slow. No matter how optimized I make the query or the approach, its just too damn slow - and my system only has about 5,000 attachments.

The problem is that there is no index on attachment.filename. You could make an index for it - even one of the newer fulltext indices, but the functionality isn't worth the size of the new index, IMHO.

Cheers.
Scott

[FWC]

Originally posted by incursio
New version posted - see top of thread again.

I like this new version.