Files List v3.01

Hey,

VERSION 3.01
[25/05/2004]

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

This Hack is released under an EverythingvB.com FullAttribution-LimitedDerivs-LimitedTranslation License
-----------------------------------------------

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

[Boofo]

Originally Posted by DWard

OK i will work on that soon

If you need any help, pm me.

[SmartGnome]

Database error in vBulletin 3.0.1:

Invalid SQL: 
	SELECT COUNT(*) AS count 
	FROM vb3_ attachment

mysql error: Table 'adfs_vbgold.vb3_' doesn't exist

mysql error number: 1146

Date: Wednesday 05th of May 2004 08:37:33 PM
Script: http://anita.xxxx.nl/forum/fileslist.php?
Referer: http://anita.xxxx.nl/forum/
Username: SmartGnome
IP Address:

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

Greetz

[Boofo]

Originally Posted by SmartGnome

Database error in vBulletin 3.0.1:

Invalid SQL: 
	SELECT COUNT(*) AS count 
	FROM vb3_ attachment

mysql error: Table 'adfs_vbgold.vb3_' doesn't exist

mysql error number: 1146

Date: Wednesday 05th of May 2004 08:37:33 PM
Script: http://anita.xxxx.nl/forum/fileslist.php?
Referer: http://anita.xxxx.nl/forum/
Username: SmartGnome
IP Address:

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

Greetz

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

PHP Code:

FROM ".TABLE_PREFIX." attachment 


into this for each occurrance:

PHP Code:

FROM ".TABLE_PREFIX."attachment 


[SmartGnome]

Thnx Boofo,

But now I get this one :disappointed:

Database error in vBulletin 3.0.1:

Invalid SQL: SELECT attachmentid, filename, filesize, counter, dateline, postid FROM attachment ORDER BY 'filename' 'asc' LIMIT 0, 30
mysql error: Table 'adfs_vbgold.attachment' doesn't exist

mysql error number: 1146

Date: Wednesday 05th of May 2004 09:13:57 PM
Script: http://anita.adfs.nl/forum/fileslist.php?
Referer: 
Username: SmartGnome
IP Address: 62.100.24.35

[Aurous]

Originally Posted by Boofo

I think he means the attachments by forum idea.

correct

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

[Boofo]

Originally Posted by SmartGnome

Thnx Boofo,

But now I get this one :disappointed:

Database error in vBulletin 3.0.1:

Invalid SQL: SELECT attachmentid, filename, filesize, counter, dateline, postid FROM attachment ORDER BY 'filename' 'asc' LIMIT 0, 30
mysql error: Table 'adfs_vbgold.attachment' doesn't exist

mysql error number: 1146

Date: Wednesday 05th of May 2004 09:13:57 PM
Script: http://anita.adfs.nl/forum/fileslist.php?
Referer: 
Username: SmartGnome
IP Address: 62.100.24.35

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

[SmartGnome]

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

[Pitman]

Originally Posted by DWard

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

What about arranging the files in columns?

[DWard]

Originally Posted by Pitman

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.

[DWard]

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:

<if condition="$show['last']"><td class="alt1"

after add this:

nowrap="nowrap"

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