Files List v3.01
 

Hey,


This new hack gives you the function of grouping all your attachments in one single list, divided into pages and with the option of viewing files by category, eg Video Clips, Archives and Excecutables etc.

All installation instructions are provided in the install file, and modification details are in the php file included in the zip. All images used for some files are also attached.

Any problems, queries or errors, please report here or PM me so I can sort them out as soon as possible, to ensure this hack is to your standards.

Current key functions:

• Lists all attachments and spans over pages. You can specifiy the amount of attachments per page.
• Specify usergroups who you do not wish to view the attachments.
• Set out the same as attachments in posts, with icon, size and views.
• Categories, so you can quickly view one type of file.
• Display username.
• Sort by username or filename.
• If enabled, images category shows thumbnails.
• Table row colours altered to make it easier to read username.
• Shows forum name and a link to the parent thread.
• Ability to sort by forum name.
• Set the amount of files to view per page.

An example of the hack can be found here:
http://www.collegepranks.co.uk/forums/fileslist.php

Note to current users about upgrading:

• Replace your fileslist.php file with the new one.
• Replace the attachment_view and attachment_view_bits with the ones in the install file.

FOR THE BEST AND QUICKEST SUPPORT TIME, PLEASE POST HERE.

PLEASE CLICK INSTALL :)

Excellent, thanks mate. :)

is it possile to add who posted the attachment on there?

I will look into it as a new function, then I will post the next version in about 2 weeks time

Any ideas on how this will affect server load?
There was a hack similar to this on vB2 that brought the server speed down to a snail's pace, and some hosts even banned the hack from being used.

Its been fine for me, just 2 simple SQL queries operate on each page load, my web host hasnt mentioned any server load problem at all

is it possible with this hack to upload attachments with out having to use a post somewhere first, then have it goto the catitory you choose above? Also with usergroup restrictions. Download counter etc?

I've been looking for something like your hack with the above for a while now. thanks for the hard work.

Download counter is on it already where it shows how many views (downloads)...

Also the code for blocking certain usergroups is in the fileslist.php file, you just need to uncomment the code and enter in the usergroup ids you wish to deny access to.

The upload thing I will take down as another sugesstion for the next version in 2 weeks

Great mod. I'm definately installing. :)

Great work on Scrubs hack. Any chance of adding a jumpbox to view attachments from particular forums?

Looks good! I will definately install this when you get everything done. ;)

There is a way I could do it, I will consider it, however it will only work on the new attachments because it will require another field on the attacment database of the location, because at the moment, as far as I am aware, there is no entry for the forum location.

Take a look at my forumdisplay stats hack. I pull out the attachments for each forum with the query in there. ;)

I will give it some thought, just keep looking

Isn't that all you are wanting to do, list them on a per forum basis?

Aurous wants me to display attachments from different forums, so they want to be able to select the forum from the list and display the attachments in that forum

Nice Hack. Does is take care of permissions?

That should be easy to adjust the query in my hack for. ;)

Do you mean blocking out certain usergroups of seeing the list... yes.
Also, when you try to view an attachment, the standard usergroup permissions take hold.

It's EXTREMELY slow on a dedicated Dual Xeon.... :ermm:
Maybe it's because we have 180.000 attachments...

Yer thats probably why. As I say, it only calls 2 queries, works fine with my attachments.

----------------

Just a note to all, the example page for the hack may have a few errors here and there, as I am trying to add the new suggested features.

What about a way to specify what types of files to list (such as images) and putting them in a table with columns with a preview of the image?

does this work if your attachments are in the filesystem rather than the database?

Yes, no matter where your attachments are, it will work.

Image thumbnails are another function to be added to the suggesstions list for the next version.

Dward, any luck with Boofo's suggestion?

The 'who posted attachment' suggestion? not yet

I havnt yet begun on the other sugesstions.

This is what people have suggested so far:

• Sort by category, AND BY FORUM
• Show the user who posted the attachment
• Upload files in the file viewer
• Show thumbnails of images

I think he means the attachments by forum idea. ;)

OK i will work on that soon

If you need any help, pm me. ;)

The table attachment do exist in my database, so I'm stucked :disappointed:

Greetz

In the filelist.php, you need to make this:

into this for each occurrance:

Thnx Boofo,

But now I get this one :disappointed:

correct :)

Boofo, can you please look at this hack and maybe try to merge your hack with it?

Use this filelist.php. It is all fixed for you. ;)

Boofo you're the greatest.. :applaude

Now it's working fine, will have a look into the file tomorrow to see what was wrong.

Many Tnx

Ad

What about arranging the files in columns? :)

The whole idea of Files List is to keep the attachment look exactly as it is in posts, therefore looks like a standard vBulletin feature.

I noticed on a few fileslist.php pages of yours, the last link on the page is on two lines.

Just open the pagenav template under Page Navigation in the templates list and do this:

find:
after add this:
Then your done, doesnt go onto two lines then, I think its fine in IE anyway, but not in Mozilla