Attachment Browser (v2.1 beta testing)

[CarCdr]

List/Search Attachment Files

List, filter/search, sort, etc. for attachments files. Respects forum permissions. Supports limiting search to a single forum or a list of forums. Also, a separate attachment summary page is available.

Any problems raised in this thread have been fixed. For new features in version 2, see below under Version 2 for "New" entries.

Standard page navigation is supported to go to last page, prev, next, etc.

Sorts, ascending or descending, are supported for:
two levels of sorting, for example, by user name and then by file name.
Sort, either level, on these fields:
date/time
user name
forum
file name
file extension
file size
# of downloads
the default sort is date/time (most recent first)
Searching/filtering

All criteria is entered on a collapsable form at the top of the page.
Search/filter criteria supported are: user name ('*' wildcards allowed)
file name ('*' wildcards allowed),
file extension ('*' wildcards allowed)
userid or list of userid's
forumid or list of forumid'
attached before N days ago,
attached after N days ago
Single click filtering by user name, forum name or document type.


Changes pending for version 2.1

New Added usergroup access checking.
Two configuration variables can be set to either (a) allow access to a set of usergroup or (b) disallow access for a set of usergroup id's.
New Query performance improved.
Performance for sites with many thousands of attachments is significantly improved. The single most time consuming aspect of such a script is the MySQL query for 'COUNT(*)' to get the number of attachments matching the selection criteria and access permissions. By including only those JOIN's that are required, depending on the columns being accessed, the ORDER BY, and the WHERE clauses, we improve performance of both retrievals. There is still one case where the row retrieval could be slow: when the user requests that the output be sorted by forum title.
New List attachments added since last visit.
New Added a debugging setting to display timing information.
Change Various other performance improvements that will be detailed when released.


Version 2:

New A separate attachment summary page was added.
Page provides overall summary, summary by forum, and summary by extension.
This introduces two new templates: attbro_SUMMARY and attbro_summary_categorybit.
This page is accessed from a new link at the top of the main page.


New Now uses $vbphrase for phrases.
You can AdminCP-install custom phrases to override the defaults.


New We respect forum permissions.
To have an entry listed, the user needs 'CANVIEW' and 'CANGETATTACHMENT'
access and a password if required. Also, $_FORUMOPTIONS[active] and
$_FORUMOPTIONS[cancontainthreads] must be on and the forum must not
be a link redirect.


New List forum name with each entry.


New Now supports sorting by forum name; just like any other
sort, for first- or second-level sort.


New Quick filtering for a single forum, by clicking the
'[Filter]' link next to a forum name to search only that forum, similar to
clicking the link next to the user name in our previous version.


New Allow one or more forumid's to be specified as a filter on the Display Options
form. The "Forum ID" form field may be one or more ID's separated by spaces or commas.
The "[Filter]" link next to forum names uses this as well to add a Forum ID to the
current selection criteria.


New Allow one or more userid's to be specified as a filter on the Display Options
form. The "User ID" form field may be one or more ID's separated by spaces or commas.


New Forums can be explicitly exluded via the URL parameter
"exclude_forums=LIST", where LIST is one or more forumid's separated
by spaces or commas. This will eventually be an AdminCP option.


Bug: Checks deletion log so that deleted posts are not included.


Feature/Change: The filter 'sel_userid=NNN' no longer disallows other
filter criteria. It's treated like any other filter -- combined with other selection
criteria. Only one of 'sel_userid=NNN' or 'sel_username=XXX' can be specified.
Userid takes precedence. This change also applies to 'sel_forumid=XXX'.


Change: We use MySQL "LIMIT X,N" syntax to only retrieve the records
we need to fill the requested page. This should provide some performance gain
when building pages for high page numbers.


Change: Renamed '[Downloads]' link next to user name to '[Filter]'.


Change: Renamed 'Downloads' in listing header to '$vbphrase[views]'.


Change: Renamed URL parameter 'userid=NNN' to 'sel_userid=NNN'.


Change: Since we now need forum information for every page, we
always query using all the JOINS -- user, post, thread, forum, deletionlog.


Change: Exclude attachements whose 'postid' is zero. Thanks to
Pitman for this one, who suggested: "About the private attachments: Since
they don't have a postid, wouldn't "AND postid !=0" work in the query or
whatever? If so, that should also fix the problem that some may have with
attachment names and all showing but no attachment really there yet (like when
somebody is posting a new attachment and have not yet clicked Submit New
Thread or Submit Reply)?"

Bug: Fix mismatched <td></td> in attbro_FORM template that caused
page to leak past the right margin.

Phrase changes:
New 'stars_allowed' for reminders on form.
New 'Filter' for '[Filter]' links
New 'Count' for summary page.
New 'Attachment_Summary'.
No longer use 'Select_Type'.


v 1.1:
Added .php to all attachment_browser references in template links.
Added forgotten class="tcat" to first table row for headings.

v 1.2:
Feature: Enabled display of file type icons and the ability to click
said icons to recall us to list only files of that type (extension).
We look for icons using "$stylevar/$extension.gif".
Bug: Make "Show attachment ID" on form be remembered across calls.
Bug: Make sure "userid=XXX" is passed in links for page navigation when
listing a single user's downloads.
Feature: If we are showing the attachment ID, then always force it below the
row number with '<br />'.
Performance: Performance of 'COUNT(*)' query greatly imporved for case where
we do not need to reference tables other than 'attachment'. Testing
on our server shows speed improvement around 6x better. This small
optimization controlled via "$sqlCountRequiredJoins".


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

To search in a single forum: use the single click [Filter] next to any forum name on a page or enter the forumid on the "Display Options" form.
To search only in a selected list of forums: Enter a comma-separated list of forumid's in "Display Options".

You can AdminCP-install custom templates to override our defaults ones.
You can AdminCP-install custom phrases to override the defaults -- all
references in templates are to "$vbphrase[XXX]".

If you do not want to change the default templates or phrases, then there are
no other files to install -- just put this one in the main '/forum' directory.
If you want to modify the default templates, copy them from this file and
install them as usual. We will notice when there are installed templates to
override our defaults. The same applies to phrases.

We only list forums that the user has permissions to view and get attachments,
for attachments that are visible and not from deleted posts.

We do 2 queries: (1) get the total COUNT of accessible attachments matching
the selection criteria and (2) retrieve enough rows to fill the requested page.

If you follow a link on one of our pages to download an attachment, view a
user profile, or view the original post, then the normal access checks will
apply, as these links simply invoke standard vBulletin files.

The templates referenced are: attbro_MAIN, attbro_FORM, attbro_ERROR,
attbro_attachbit, attbro_SUMMARY and attbro_summary_categorybit. The default
templates and phrases are defined in this file. Look for '$MyDefaultTemplates'
and '$MyDefaultPhrases'.

For example, if we had a template named 'attbro_example', it will appear in
this file as:

$MyDefaultTemplates['attbro_example'] = '
[i]LINE 1 OF TEMPLATE
LINE 2 OF TEMPLATE
';

To install a custom version, just copy the LINES
and install it under the template name attbro_example.
----------------------------
This extension is free, and will remain free.

Cheers, CarCdr

[Osterling]

it seems to be breakin the width of the broswer.. see

http://www.exasko.info/forum/attachment_browser.php?

[Merjawy]

nothing to edit??? This got to be the easy hack/mod :)


thnx I tried it looks nice but breaks the width a little and when I click on Download I get a 404 with this URL:
h##p/www.mydomain.com/forums/attachment_browser?do=list&userid=1

[MrNase]

Looks really nice and simple :)

But it doesn't use templates so I won't use it.... :(
I would have to translate it and i don't want to crawl the php-page.

[nexialys]

this hack have to be in the Beta Releases section, because is not following the vBulletin3 protocol... no lang phrases, no templates, not using the templates at all,... maybe be useful but not in the full released!

[colicab-d]

everyone go to usercp , attachments i thibk you should find an attachment browser there

[chrisvonc]

Yes but thats just for each user to see what they have uploaded. This is pretty cool in that it looks to offer a quick and easy page to call up for all attachments from everyone rather than going in through the AdminCP. I think a little more tweaking and it will be a good little add-on. :)

[CarCdr]

Looks really nice and simple :)

But it doesn't use templates so I won't use it.... :(
I would have to translate it and i don't want to crawl the php-page.

It does use templates, but the default ones are contained in the PHP file. You can override them. Simple copy them out of the PHP file and install them as you would any other template. The program will notice that you have installed a template(s).

The only caveat is that you have to replace \' with ' before saving them in AdminCP.

For example, to replace the bit used for the listing rows, copy the template lines between:

$MyDefaultTemplates['attbro_attachbit'] = '
TEMPLATE TEXT
TEMPLATE TEXT
';

[CarCdr]

it seems to be breakin the width of the broswer.. see

http://www.exasko.info/forum/attachment_browser.php?

I am not sure what you mean exasko. I have attached a gif of what I get when I run your attachment_browser. It was run under IE 5.5 using your "Exasko's Classic" style.

Note that there was a style problem fixed in the just-uploaded v1.1, whereby I forgot a 'class="tcat"' on the first line of the table heading. That is why you see a slightly odd coloration on that first table header line in the attached GIF. That should be fixed now.

If you could attach a shot of a broken display, that would be very helpful.

Cheers, CarCdr.

[CarCdr]

nothing to edit??? This got to be the easy hack/mod :)


thnx I tried it looks nice but breaks the width a little and when I click on Download I get a 404 with this URL:
h##p/www.mydomain.com/forums/attachment_browser?do=list&userid=1

Fixed in the just-uploaded v1.1

The link in question worked on my web server as it defaults extensions (i.e., HTML, PHP). I forgot the '.php' suffix in the link to list a single user's attachments. Ooops... :o

[CarCdr]

Yes but thats just for each user to see what they have uploaded. This is pretty cool in that it looks to offer a quick and easy page to call up for all attachments from everyone rather than going in through the AdminCP. I think a little more tweaking and it will be a good little add-on. :)

That's the idea. We use vB for a company project with a large number of configuration-managed documents of various types, mostly .doc, .xls, and .txt. Users needed a way of doing things like:

* List attachments whose file names begin with 'TASKING_' and sort by date.
* List attachments from user '*Admin' (i.e., ending with 'Admin') in the last month.

[CarCdr]

this hack have to be in the Beta Releases section, because is not following the vBulletin3 protocol... no lang phrases, no templates, not using the templates at all,... maybe be useful but not in the full released!

Sure. It doesn't matter to me where it goes.

I see your point, definitely. Still, I would note that the entire mod is phrased (i.e., no english in the templates), although it uses a non-standard method for additionally required phrases. All phrasing is done either through $vbphrase references or references to $attbro_PHRASES. which is defined in the PHP file. It's actually easier to contain and control the mod within a single file like this, rather than having to go through the AdminCP (imho).

It does use templates. It's just that the default versions are contained in the PHP file itself. If you install an updated template, the program will override the version contained in the PHP file. The rule is to first look for an installed template, then if none is found, to use the default.

[nexialys]

that's why i say it have togo to the Beta ... because you have the details, but not the vB3 way/protocol of things... this is a cool tool btw!

[CarCdr]

that's why i say it have togo to the Beta ... because you have the details, but not the vB3 way/protocol of things... this is a cool tool btw!

I hear ya nexialys. BTW, I thought I would give a sense of the phrasing that is used. Here is the list of phrases referenced in the templates:


vBulletin Standard
$vbphrase[ascending]
$vbphrase[days]
$vbphrase[descending]
$vbphrase[display_options]
$vbphrase[downloads]
$vbphrase[downloads]]
$vbphrase[extension]
$vbphrase[filename]
$vbphrase[filesize]
$vbphrase[months]
$vbphrase[post]
$vbphrase
$vbphrase[year]
$vbphrase[years]


[u]New Phrases
$attbro_PHRASES[attachment_browser] => Attachment Browser
$attbro_PHRASES[attachments_selected] => attachments selected
$attbro_PHRASES[Attached_date] => Attached date
$attbro_PHRASES[Change] => Change
$attbro_PHRASES[Display] => Display
$attbro_PHRASES[expand_collapse] => Expand to change/Collapse
$attbro_PHRASES[Filtering] => Filtering
$attbro_PHRASES[First_by] => First by
$attbro_PHRASES => ID
$attbro_PHRASES[List]
=> List
$attbro_PHRASES[no_matches] => No attachments match the selection criteria you have specified.
$attbro_PHRASES[not_enough_pages] => Too few attachments retrieved to list the page you requested.
$attbro_PHRASES[or_newer] => or newer
$attbro_PHRASES[or_older] => or older
$attbro_PHRASES[Profile] => Profile
$attbro_PHRASES[Results_per_page] => Results per page
$attbro_PHRASES[Select_Type] => Select Type
$attbro_PHRASES[Show_attachment_ID] => Show attachment ID
$attbro_PHRASES[Show_All] => Show All
$attbro_PHRASES[Sorting] => Sorting
$attbro_PHRASES[then_by] => then by
$attbro_PHRASES[Version] => Version
$attbro_PHRASES[D_7] => 7 [i]$vbphrase[days]
$attbro_PHRASES[D_30] => 30 $vbphrase[days]
$attbro_PHRASES[M_3] => 3 $vbphrase[months]
$attbro_PHRASES[M_6] => 6 $vbphrase[months]
$attbro_PHRASES[Y_1] => 1 $vbphrase[year]
$attbro_PHRASES[Y_2] => 2 $vbphrase[years]

Some of the new phrases do exist somewhere in vBulletin, but loading an entire phrase group to get at the word 'List' for example, seemed like overkill.

[Osterling]

I use MyIE2 and it seems to break width at the bottom.. anyone else getting this problem

[trainer]

would it be possible to search in a certain forum only. we have a couple of specific forum and viewing the attachments from that forum only would be great!

[CarCdr]

would it be possible to search in a certain forum only. we have a couple of specific forum and viewing the attachments from that forum only would be great!

The rational thus far was guided by this:
We wanted this to be reasonably fast on large boards, so we stayed away
from dealing with forums. The attachment table is only cross-linked to
the post table and user table. These are the only ones we access. This
means that we do not do proper access checking, as that would required
that we do lookups from the post table to the thread table to the forum
table.

Now, having said that, if someone clicks a link on one of our pages to
download an attachment, view a user profile, or view the original post,
then the normal access checks will apply, as these links simply invoke
standard vBulletin files.

Still, it has been a pain for us as well not being able to search by forum. It will be added eventually. I know how to do it, that's not the problem, it's taking the time to figure out how it affects the page layout.

[CarCdr]

I use MyIE2 and it seems to break width at the bottom.. anyone else getting this problem

Got that screen shot of the width problem exasko? :)

[Osterling]

yes let me grab it

[Osterling]

see the image

[CarCdr]

Version 1.2 uploaded:
Feature: Enabled display of file type icons and the ability to click
said icons to recall us to list only files of that type (extension). We
look for icons using "$stylevar[imgdir_attach]/$extension.gif".
Bug: Make "Show attachment ID" on form be remembered across calls.
Bug: Make sure "userid=XXX" is passed in links for page navigation when
listing a single user's downloads.
Feature: If we are showing the attachment ID, then always force it
below the row number with '<br />'.
Performance: Speed of 'COUNT(*)' query greatly improved for case where
we do not need to reference tables other than 'attachment'. Testing on our
server shows speed improvement around 6x better.


Screenshot:
https://vborg.vbsupport.ru/attachment.php?attachmentid=19525

[Boofo]

Does this hack support permissions and does it show private attachments if you have the PM attachment hack installed?

[CarCdr]

Does this hack support permissions

Boofoo, permissions for accessing attachments and posts is handled. Perrmission handling for generating the listing will likely be in version 2. vBulletin does not offer any modularized way of handling permissions, so it's rather a pain in the a**.

As you no doubt are aware, this would require checking each attachment against the associated forum table, via the thread table, then for each listing entry, a call has to be made to "fetch_permissions".

Permissions in play are CANVIEW, CANGETATTACHMENT, and possibly can_moderate. If CANVIEW is off, then we would not list the post title.

Finally, there would be processing for forum passwords. I do not know how that would work nicely, as you could be interrogated multiple times for a single page.

The only tables we touch currently are attachment, user, and post. I discussed this in the initial post as I anticipated it would be a concern.

Now, if one tries to download an attachment or look at a post, or view a user's profile (in other words, follow any of the links on a listing, then the normal vBulletin permissions apply since these are standard vBulletin URLs.

does it show private attachments if you have the PM attachment hack installed?

No. I am not familiar with this hack. Is it used widely?

[Boofo]

Does this hack support permissions

Boofoo, permissions for accessing attachments and posts is handled. Perrmission handling for generating the listing will likely be in version 2. vBulletin does not offer any modularized way of handling permissions, so it's rather a pain in the a**.

As you no doubt are aware, this would require checking each attachment against the associated forum table, via the thread table, then for each listing entry, a call has to be made to "fetch_permissions".

Permissions in play are CANVIEW, CANGETATTACHMENT, and possibly can_moderate. If CANVIEW is off, then we would not list the post title.

Finally, there would be processing for forum passwords. I do not know how that would work nicely, as you could be interrogated multiple times for a single page.

The only tables we touch currently are attachment, user, and post. I discussed this in the initial post as I anticipated it would be a concern.

Now, if one tries to download an attachment or look at a post, or view a user's profile (in other words, follow any of the links on a listing, then the normal vBulletin permissions apply since these are standard vBulletin URLs.

does it show private attachments if you have the PM attachment hack installed?

No. I am not familiar with this hack. Is it used widely?
The pm attachments hack for vB3 is very widely used and an excellent hack. Kentaurus coded it.

[CarCdr]

The pm attachments hack for vB3 is very widely used and an excellent hack. Kentaurus coded it.
re: Private attachments

Boofo, the question is "How should it work?" Attachment_browser is meant to be a user utility, not an admin utility. I suppose it could display the private attachments for the logged-in user, but I *believe* the private attachment hack does that now via profile.php.

For listing other user's private attachments, I note that the private attachment hack does not have admin support, via admincp\attachment.php. Perhaps that's what you are after.

Cheers

[Natch]

The problem is that the Private attachments are not private in the dbase - they are stored as regular attachments, and are linked not to a thread, but to a PM - this is what needs to be added to determine who can view what ...

There is (btw) already a hack that displays a listing of all attahcments - take a look for the "Files List" hack ...

Nevertheless, good work! :)

[CarCdr]

The problem is that the Private attachments are not private in the dbase - they are stored as regular attachments, and are linked not to a thread, but to a PM - this is what needs to be added to determine who can view what ...

There is (btw) already a hack that displays a listing of all attahcments - take a look for the "Files List" hack ...

Nevertheless, good work! :)

Yes, I read through the private attachment code. Like i said, I suppose all one could add is the ability to view one's own attachments, not others. This is a user utility. To see other's private attachments, the private attachment hack should have admincp\attachment.php support.

Yes, I saw that FilesList was posted, but I thought I would post ours nevertheless as it has significantly more features.

[highlander_RD]

This is a very nice and easy hack. *install*
May I ask the possibility to show a thumbnail when the attachment is an image?

Thanks! ;-)

[CarCdr]

would it be possible to search in a certain forum only. we have a couple of specific forum and viewing the attachments from that forum only would be great!

trainer,

Today I tested the mod's to search only in a specific form. I'll post it later this week.

Implementation
I took the easy way here. Each list entry now contains the form name. Next to the forum name is a [Filter] link. Clicking such a link will add the corresponding forum ID to the current selection criteria.

[CarCdr]

re: thumbnails

highlander_RD ,

It's not that hard, but it would sure mess up the page display, making some entries occupy a lot of vertical space. I'm betting you don't care about that. :) Personally, I always want as much information on a page as possible -- i.e., lots of entries.

[highlander_RD]

re: thumbnails

highlander_RD ,

It's not that hard, but it would sure mess up the page display, making some entries occupy a lot of vertical space. I'm betting you don't care about that. :) Personally, I always want as much information on a page as possible -- i.e., lots of entries.
I agree, but the kind of thumbnail I'm wondering of is such as 50x50px, not so heavy not so high, but enough to better get at a glance the subject of the pic.
In my forum I have tons of pics attached, with nonsense names. So the only way to make fun should be to have a sort of preview even if very small.
Sorry for my insisting, and all my best for this great work!
;-)

[CarCdr]

I agree, but the kind of thumbnail I'm wondering of is such as 50x50px, not so heavy not so high, but enough to better get at a glance the subject of the pic.
In my forum I have tons of pics attached, with nonsense names. So the only way to make fun should be to have a sort of preview even if very small.
Sorry for my insisting, and all my best for this great work!
;-)

How about this? For graphic files, a small icon is displayed that you can pass your cursor over to get the thumbnail to display, either through image swapping or some crafty DHTML. This would be the same thumbnail displayed for any attachment (i.e., size-wise), since the source of the pic would come from the standard 'attachment.php' thumbnail code.

Easier still I think, from an implementation standpoint, would be a popup window.

Let's see if anyone else is interested.

Cheers

[highlander_RD]

How about this? For graphic files, a small icon is displayed that you can pass your cursor over to get the thumbnail to display, either through image swapping or some crafty DHTML. This would be the same thumbnail displayed for any attachment (i.e., size-wise), since the source of the pic would come from the standard 'attachment.php' thumbnail code.

Easier still I think, from an implementation standpoint, would be a popup window.

Let's see if anyone else is interested.

Cheers
It's for sure a good compromise, thanks :D

Re: permissions
I checked now that attachments in supermoderators area (hidden) are listed as well as post titles to guest and registered users... It's true they can't get into because of permissions, but they're allowed to read the listed titles and attachments names.
Any idea to allow only supermods and admins to view the listed attachments and tied infos placed in hidden forums?

Wouldn't be easier to use the "Exclude Forums" as indicated in User profile Options?

[CarCdr]

Re: permissions

As part of the code being tested now to allow selection on a single forum, I have also added persmission checking, so that only attachments from permitted forums are listed. The permissions checked are:

CANVIEW AND CANGETATTACHMENT

Both must be true.

Perhaps someone can chime in here and let us know if these user-forum permissions would be set for moderators, super-moderaters, and administrators, or does one need to call 'can_moderate(forumid)'?

[highlander_RD]

I uploaded now the attachment_browser.php, renamed as ab1.php
here you can view the listed attachments with the secret attachment set in supermod area, actually as ID nr. 7 "reputation_balance.gif"

http://forum.egcommunity.it/ab1.php

[CarCdr]

Yes, permissions will be coming this week, along with the ability to list for a selected forum.

(BTW, and you probably know, if you rename the source file, you break the links on the page, as they are coded in the template to call 'attachment_browser.php'.)

[highlander_RD]

Yes, permissions will be coming this week, along with the ability to list for a selected forum.

(BTW, and you probably know, if you rename the source file, you break the links on the page, as they are coded in the template to call 'attachment_browser.php'.)
Great news! ThankS :D
Yep, I just changed the name for this checking purposes. Later on, when permissions are fixed, I'll replace the correct name. ;)

[Natch]

Yes, permissions will be coming this week, along with the ability to list for a selected forum.

(BTW, and you probably know, if you rename the source file, you break the links on the page, as they are coded in the template to call 'attachment_browser.php'.)
Sugges insted of hard coding the filename, try using a
define(THIS_SCRIPT,'attachment_browser');
statement at the top, this way it's easy enuff then to make one filename change, and one file edit for renaming purposes ...

[CarCdr]

Sugges insted of hard coding the filename, try using a
define(THIS_SCRIPT,'attachment_browser');
statement at the top, this way it's easy enuff then to make one filename change, and one file edit for renaming purposes ...

Yes, I already use a constant for the name of the file, for things such as the 'navbar'. However, in vBulletin, the templates, and that is what is in play here, are hard-coded to call XXX.php. As an example, search the default template file, vbulletin-style.xml, for 'memberlist.php'.

Still, I suppose there is no reason one could not set $this_script to be referenced by templates. For that matter, one could set it by referencing the PHP global 'SCRIPT_FILENAME''.

[Erwin]

This is indeed a great hack and a good idea. :) Well done.

[Pitman]

About the private attachments: Since they don't have a postid, wouldn't "AND postid !=0" work in the query or whatever? If so, that should also fix the problem that some may have with attachment names and all showing but no attachment really there yet (like when somebody is posting a new attachment and have not yet clicked Submit New Thread or Submit Reply)?

[CarCdr]

About the private attachments: Since they don't have a postid, wouldn't "AND postid !=0" work in the query or whatever? If so, that should also fix the problem that some may have with attachment names and all showing but no attachment really there yet (like when somebody is posting a new attachment and have not yet clicked Submit New Thread or Submit Reply)?

Good idea. Change will be in the next upload. Thank you.

[CarCdr]

Here is a preview of the changes being tested for version 2 of attachment_browser. Comments are welcomed.


Bug: We handle forum permissions, except for forum passwords. To have an entry listed, the user needs 'CANVIEW' and 'CANGETATTACHMENT' on a forum. Also, the forum must be '$_FORUMOPTIONS[cancontainthreads]'. This introduces another query to get the list of forums.


Feature: List forum name with each entry.


Feature: Now supports sorting by forum name; just like any other sort, for first- or second-level sort.


Feature: Allow one or more forumid's to be specified as a filter on the form. The "Forum ID" form field may be one or more ID's separated by spaces or commas.


Feature: Allow one or more userid's to be specified as a filter on the form. The "User ID" form field may be one or more ID's separated by spaces or commas.


Feature: Quick filtering for a single forum, by clicking the '[Filter]' link next to a forum name to search only that forum, similar to clicking the link next to the user name in our previous version.


Bug: Checks deletion log so that deleted posts are not included.


Feature: Filter 'sel_userid=NNN' no longer disallows other filter criteria. It's treated like any other filter -- it is simply combined with other selection criteria. This also applies to 'sel_forumid=XXX'. For user filtering, only one of 'sel_userid=NNN' or 'sel_username=XXX' can be specified. Userid takes precedence.


Change: Renamed '[Downloads]' link next to user name to '[Filter]'.


Change: Renamed 'Downloads' in listing header to '$vbphrase[views]'.


Change: Renamed URL parameter 'userid=NNN' to 'sel_userid=NNN'.


Change: Since we now need forum information for every page, we always query
using all the JOINS -- user, post, thread, forum, deletionlog.


Change: Exclude attachements whose 'postid' is zero. Thanks to Pitman for this one, who suggested: "About the private attachments: Since they don't have a postid, wouldn't "AND postid !=0" work in the query or whatever? If so, that should also fix the problem that some may have with attachment names and all showing but no attachment really there yet (like when somebody is posting a new attachment and have not yet clicked Submit New Thread or Submit Reply)?"

[Pitman]

I know that this hack uses templates of some sort, but is there any possibility of maybe using the regular templates in later versions? It would be much easier to modify and customize to your own taste without worrying about messing up an entire PHP file trying to modify stuff.

Thanks :)

[CarCdr]

I know that this hack uses templates of some sort, but is there any possibility of maybe using the regular templates in later versions? It would be much easier to modify and customize to your own taste without worrying about messing up an entire PHP file trying to modify stuff.

Thanks :)

Sure. But you will not mess up a PHP file. Copy them from the PHP file, leaving the file unchanged, then install them as you would any template. The program will notice that you have installed templates to override the default. See the comments in the first post for more details.

The advantage here, is that for those who have no desire to modify the templates, there is nothing to do but install the single file. For others, it's a simple matter to install overriding templates.

[Pitman]

Yeah, and that is a great idea... it would be so much easier for me to modify everything from the same place though without having to actually modify the file each time I want to change something. Thanks for the "Sure" though :D

[CarCdr]

without having to actually modify the file each time

:) BUT... you do not have to modify the file. You copy out the templates. What is the difference between copying the templates from a text file named foo.php and a text file named templates.txt?

Here is a look at the smallest template in the file:

$MyDefaultTemplates['attbro_ERROR'] = '
<html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
<head>
<title>$vboptions - $attbro_PHRASES[attachment_browser]</title>
$headinclude
</head>
<body>
$header
$navbar

<table cellpadding="0" cellspacing="0" border="0" width="100%" style="margin-bottom:3px">
$attbro_error
</table>

<br /><br /><br /><br />
$footer
</body>
</html>
';
Copy the lines of the template (not including the enclosing single quotes of course), modify it as you wish, then install the template attbro_ERROR.

The functionality I am trying to offer here is to save the effort for those who would choose not to modify the templates, while adding no effort for those who need to modify them.

If I provided a file templates.txt, all I would do is copy them out for you.

I have fun with such discussions Pitman, so do not think for a second I am trying to preach. Anyway, this is all rather academic given the low level of interest in an attachment lister/browser. The number of sites using attachments for pseudo document management, as we do on our site, is obviously very small. Now my users are asking for search capability within the attached files, for .txt, .doc, and .pdf. It never ends... :) Cheers.

ps: In the pending version 2, the templates can be copied out of the file without the need to replace the single-quote occurences of [b]\' with ' per the v1 instructions, so it is now a straight copy as it would be from any text file containing templates.

[highlander_RD]

Any news about the new release 2.0?
cheers

[CarCdr]

Any news about the new release 2.0?
cheers

I have been testing it, slowly but surely... Also added some other features not mentioned. The forum selection stuff works well.

Given the low-level of interest here, I admit that I let it slip down my list of things to do. I will get around to uploading soon.

Cheers, CarCdr

Version 2 Changes:

New A separate attachment summary page was added.
Page provides overall summary, summary by forum, and summary by extension.
This introduces two new templates: attbro_SUMMARY and attbro_summary_categorybit.
This page is accessed from a new link at the top of the main page.


New Now uses $vbphrase for phrases.
You can AdminCP-install custom phrases to override the defaults.


New We handle forum permissions.
To have an entry listed, the user needs 'CANVIEW' and 'CANGETATTACHMENT'
access. Also, $_FORUMOPTIONS[active] and $_FORUMOPTIONS[cancontainthreads]
must be on and the forum must not be a link redirect.


New List forum name with each entry.


New Now supports sorting by forum name; just like any other
sort, for first- or second-level sort.


New Quick filtering for a single forum, by clicking the
'[Filter]' link next to a forum name to search only that forum, similar to
clicking the link next to the user name in our previous version.


New Allow one or more forumid's to be specified as a filter on the Display Options
form. The "Forum ID" form field may be one or more ID's separated by spaces or commas.
The "[Filter]" link next to forum names uses this as well to add a Forum ID to the
current selection criteria.


New Allow one or more userid's to be specified as a filter on the Display Options
form. The "User ID" form field may be one or more ID's separated by spaces or commas.


New Forums can be explicitly exluded via the URL parameter
"exclude_forums=LIST", where LIST is one or more forumid's separated
by spaces or commas. This will eventually be an AdminCP option.


Bug: Checks deletion log so that deleted posts are not included.


Feature/Change: The filter 'sel_userid=NNN' no longer disallows other
filter criteria. It's treated like any other filter -- combined with other selection
criteria. Only one of 'sel_userid=NNN' or 'sel_username=XXX' can be specified.
Userid takes precedence. This change also applies to 'sel_forumid=XXX'.


Change: We use MySQL "LIMIT X,N" syntax to only retrieve the records
we need to fill the requested page. This should provide some performance gain
when building pages for high page numbers.


Change: Renamed '[Downloads]' link next to user name to '[Filter]'.


Change: Renamed 'Downloads' in listing header to '$vbphrase[views]'.


Change: Renamed URL parameter 'userid=NNN' to 'sel_userid=NNN'.


Change: Since we now need forum information for every page, we
always query using all the JOINS -- user, post, thread, forum, deletionlog.


Change: Exclude attachements whose 'postid' is zero. Thanks to
Pitman for this one, who suggested: "About the private attachments: Since
they don't have a postid, wouldn't "AND postid !=0" work in the query or
whatever? If so, that should also fix the problem that some may have with
attachment names and all showing but no attachment really there yet (like when
somebody is posting a new attachment and have not yet clicked Submit New
Thread or Submit Reply)?"


Phrase changes:
New 'stars_allowed' for reminders on form.
New 'Filter' for '[Filter]' links
New 'Count' for summary page.
New 'Attachment_Summary'.
No longer use 'Select_Type'.

[highlander_RD]

It's perfect.
If you want me to test the "beta" 2.0 release on my forum, I'd be very glad.
Just give me a PM or an email with attached the php.
Thanks a lot!

[highlander_RD]

mmmm...
I guess you didn't read my PM...

[CarCdr]

mmmm...
I guess you didn't read my PM...
And here I thought it was you. :) I sent you the code via e-mail last week.

I'll send a followup PM to you.

[PixelFx]

is it possible for me to beta test 2.0 ? :)

[CarCdr]

Version 2 uploaded with screenshots.

https://vborg.vbsupport.ru/showthread.php?p=528801

Among other new features, it includes forum support, including searching by forum and permission support.

CarCdr

[SIINSI]

I uploaded the file but, it doesn't load :( I gave it a good 10 minutes. Any ideas?

I have about 16,000 attachments and use 804 Mb. for attachments. Is this the problem?

EDIT It finally loaded after a long, long while. Is that normal?

Miguel

[CarCdr]

16,000 attachments hey. Hmmm... the browser only makes two queries, one to get the count of attachments you have access to (i.e., MySQL "COUNT(*)) and the other to load a page worth of attachment information.

Also, it does not retrieve the actual content, so the rows retrieved are quite small.

We have about 400 attachments and it loads very quickly.

I'd like to add a debug parameter that you could use to get feedback on what is taking so long. That way, you could get back to me about where it is eating the time.

[SIINSI]

Sure, just let me know what I need to do. It looks like a very useful tool. I f I could speed it up, I'd be a happy man :)

It said I had 772 Pages of attachments. If that matters.

Thanks,
Miguel

[CarCdr]

Sure, just let me know what I need to do. It looks like a very useful tool. I f I could speed it up, I'd be a happy man :)

It said I had 772 Pages of attachments. If that matters.

Thanks,
Miguel
The 772 pages is just the count you get for 1400 attachents at the default of 20 per page. Like I said, it only retrieves the actual attachment table rows for the target page. I assume you were getting just the first page, so it would be retrieving the first 20 rows. We'll time the two queries to see which one is so slow. I expect it is the "count(*)" query.

If this is the case, one alternative is to not to the page navigation stuff, thereby obviating the need to do the "count(*)" query. One would only retrieve the target page plus one extra to see if there is a next page.

Other ideas folks?

[CarCdr]

I have made some optimizations to attachment_browser to improve the speed of the queries.
Only include a table JOIN if it is really required.
We look at a query before running it to determine which tables to join. Before, we would always include all tables in addition to attachment: user, post, thread, forum.
Do not use a forum table JOIN.
Got rid of references to 'forum.forumid' and 'forum.title'. Retrieve the forumid from the thread table join, which we likely need anyway for checking thread.forumid. Retrieve the forum titles for the page after the fact using the forum cache. The only time we need the forum table JOIN is when user request a sort by forum title.
Include forum access check only if required.
The check for "thread.forumid IN (Accessible-Forumids)" is included only if required -- only if user does not have access to all forums.
Be default, there is no sub-sort (i.e., 2nd-level sort)
As a result, the two queries do run faster for default display.

Query #1: The 'COUNT(*)' query runs anywhere from 20% faster to 5 times faster (MySQL caching must explain this huge range.) This was by far the slower of the two queries.

Query #2: The row retrieval query to get the rows for the target page runs about 9% faster, but that is not so important as it was the fast query anyway.

PM me an e-mail and I'll send you the new version. Once we agree that things still work properly and you verify the performance increase, I will post the new version here.

Cheers

[Theater]

Hello,

Long time lurker, but decided to register since this modification interests me. My community has over 15,000 attachments with over 5.5Gb of data. I converted to file storage format to save on my server load. So I was wondering if this modification would work since I've done that? Also, is there a way to limit access to the mod itself? Like say, only grant access to a paid subscription member, moderator, or administrator specific?

[CarCdr]

It doesn't matter where the attachments are stored.

Yes, you can limit access to the mod to certain user groups.

15,000 attachments... hmmm. Would you be willing to beta test the new release:
https://vborg.vbsupport.ru/showpost.php?p=539692

PM me an e-mail address and I will send you the new script.

Cheers

[CarCdr]

I would be interested to hear from folks who run with a large number of attachments (more than 2,000) to give me some feedback on timing. Please PM me if you are willing to test the new version. Thank you.

Changes queued-up for version 2.1

New Query performance improved.
Performance for sites with many attachments is significantly improved. The
single most time consuming aspect of the script is the MySQL query for
'COUNT(*)' to get the number of attachments matching the selection criteria
and access permissions. By including only those JOIN's that are required,
depending on the columns being accessed, the ORDER BY, and the WHERE clauses,
we improve performance of both retrievals. There is still one case where
the row retrieval could be slow: when the user requests that the output be
sorted by forum title.
New Added usergroup access checking.
Two variables can be used to either (a) allow access to a set of usergroup
or (b) disallow access for a set og usergroup id's. To set permissions,
find the line containing "// Usergroup permissions:" and read the detailed
instructions.
New List attachments added since last visit.
The new URL parameter "getnew=1" will list attachments added since your last
visit. Examples for links you could set up:attachment_browser.php?getnew=1
attachment_browser.php?getnew=1&sel_forumid=8,13
New Added debugging setting for timing.
Specify "debug_queries=1" in the URL to get timing information for the page.

Change The default for the second-level sort is "none".
This provides a small performance increase when the user does not want
a second-level sort. Also, we changed the sorter not to try a second-level
sort if the first-level sort is by attached time stamp.

Fix Include forums that are not active.
These are accessible if URL is know, so just make normal forum
access checks.

----------------
ps: If the 'COUNT(*)' retrieval is just too slow to support sites with many thousands of attachments, then we will need an option to skip getting the count. Note that the query to get 'COUNT(*)' is not as simple as you might think. As a minimum (not incuding special search values from the Display Options form), it must deal with forum permissions, attachment 'visible', as well as check the post table for 'visible' and post deletions.

With such an option enabled, the page would not include the number of accessible/matching attachments and would not have normal page navigation. For the page navigation, since we do not know how many there are, the best we could do is support "Next Page" when we know that there is *at least one* more attachment not on the current page.

[Smitty]

I don't know what's happening with this, but I hope it continues. I just installed and it's very nice.

Question: I want the search box to be 'Open' by default. How can I do that?

[CarCdr]

I don't know what's happening with this, but I hope it continues. I just installed and it's very nice.

Question: I want the search box to be 'Open' by default. How can I do that?
Thanks. I only noticed your post today. :o

Right, by default, the search form is displayed "collapsed" when the page is loaded. This would be a good option to have in the next release.

For now, what you can do is make two changes to the template 'attbro_FORM' (I did not test this).

Change this line:
<img id="collapseimg_attbro_disp_opts" src="$stylevar[imgdir_button]/collapse_thead_collapsed.gif" alt="" border="0" /></a>&nbsp;

to this:
<img id="collapseimg_attbro_disp_opts" src="$stylevar[imgdir_button]/collapse_thead.gif" alt="" border="0" /></a>&nbsp;

(removed the characters highlighted in red)

Then, a few lines down from that, change this line:
<tbody id="collapseobj_attbro_disp_opts" style="display:none; ">

to this:

<tbody id="collapseobj_attbro_disp_opts" style="">

[Smitty]

Thanks - I'll check it out tonight. It's not a REAL big issue, but you know how it goes. Some folks don't look so closely and miss the 'open' link (I renamed the phrase on mine to better point it out).

The biggest problem I have, actually, is checking things people upload for the file name. Many people upload stuff like 'document.doc' so the search feature has a limited function. However, I have gone in and renamed a lot of atttachments - I have to 'edit' the thread - download and rename the attachment, unattach the file in the post, and reupload the renamed file. And I watch to make sure new attachments have an appropriate name.

I rename threads a lot as well, but I do that mostly for search engines. I started doing that last December, along with some other SEO 'stuff' and my rankings, and traffic, have significantly improved.

[CarCdr]

The biggest problem I have, actually, is checking things people upload for the file name. Many people upload stuff like 'document.doc' so the search feature has a limited function. However, I have gone in and renamed a lot of atttachments - I have to 'edit' the thread - download and rename the attachment, unattach the file in the post, and reupload the renamed file. And I watch to make sure new attachments have an appropriate name.

Yeah, I have had to do that a couple of times. I wonder how difficult it would be to add a "Rename" function to the browser for administrators? The attachment name is stored only in one place, so it should be very easy.

[fiber1]

Very nice hack, but I am confused how to get the file icons to show. If someone could help It would be apreciated.

Thanks CarCdr!

fiber

[Natch]

OK - I was researching why my board and a clients board would not show the attachment icons on the attachment listing display: and eventually found it.

This modification need only be applied by those who have altered their $stylevar[imgdir_attach] to a absolute path, this modification will need to be made.

In attachment_browser.php, Find:function ICON_FILE_EXISTS($extension) {
global $stylevar;
static $attbro_icon_present;

if (empty($attbro_icon_present["$extension"]))
$attbro_icon_present["$extension"] = (file_exists("$stylevar[imgdir_attach]/$extension.gif"));

return $attbro_icon_present["$extension"];
}
Replace with:function ICON_FILE_EXISTS($extension) {
global $stylevar;
static $attbro_icon_present;

if (empty($attbro_icon_present["$extension"]))
$attbro_icon_present["$extension"] = (file_exists($_SERVER['DOCUMENT_ROOT']."$stylevar[imgdir_attach]/$extension.gif"));

return $attbro_icon_present["$extension"];
}
HTH y'all...

[CarCdr]

Thanks Natch.

So, how do you suggest I conditionalize this so that no patch need be applied (i.e., in a future version of this hack).

What does your "$stylevar[imgdir_attach]" look like?

[Natch]

/forums/images/attach for my main style - but I think you will find that this folder will exist on all installations: the difficulty is determining the location of forumroot from $_SERVER['DOCUMENT_ROOT'] on all installs...

[SpankMe]

How about this? For graphic files, a small icon is displayed that you can pass your cursor over to get the thumbnail to display, either through image swapping or some crafty DHTML. This would be the same thumbnail displayed for any attachment (i.e., size-wise), since the source of the pic would come from the standard 'attachment.php' thumbnail code.

Easier still I think, from an implementation standpoint, would be a popup window.

Let's see if anyone else is interested.

Cheers

How about a separate page display showing thumbnails in columns and rows with just basic info. Useful if you can't remember anything about where you saw the image, just what it looked like.

[SpankMe]

Also very useful when you want to keep an eye on what type of images are being posted when there is just too much posting being done to check them all. Not that I mind nudy images being posted on my sites, just to make sure nothing too extreme is being attached.

[u2page]

Could you please tell me what/how I need to input to exclude certain forums from appearing on the report?

Thanks.

[SpankMe]

For those that are interested, here is a modified version on this hack to just show rows and columns of jpg thumbnails with basic info.

[Lionel]

Can we also display the thumbs for images?

[CarCdr]

I will get back to you this week. I need to upload the latest version as it has been tested enough now I think.

I will review thread for outstanding questions and also review the mod from SpankMe for jpg thumbnails to see if it might be included in the standard upload.

Cheers

[CarCdr]

Can we also display the thumbs for images?I presume you are asking this of SpankMe Lionel?

(Hmmm... I'll bet you do not see those three words directed at you very often. :) )

[Lionel]

I presume you are asking this of SpankMe Lionel?

(Hmmm... I'll bet you do not see those three words directed at you very often. :) )

You know? I did a search for thumbs and that returned nothing. And thumbnails was just above me :speechless:

[u2page]

*bump*

Could you please tell me what/how I need to input to exclude certain forums from appearing on the report?

Thanks.

[shiva]

Hmm, very nice, pretty much what I wanted. Big thank you, but wondering about when v2.1 was available? The download is listed at 2.0.

[Smitty]

I'm curious about the status of 2.1 as well!

[shiva]

guess there is gonna be no 2.1

I'm using the thumbnail version now instead, but wondered if anyone would know how to make the file only display the images in the FIRST post of the thread, as opposed to displaying all the images within the entire thread, as it looks rather messy sometimes.

[PixelFx]

any updates on this? and where do I change usergroup access in 2.0? :) I'm using vbulletin v3.0.7

[dssart]

Hi,

This looks almost exactly like what I'm looking for, but this is what I need to do.

I allowed my members to post attachments and link these attachments from an outside source. Some members dissappear, and eventually so do the images. Meaning now I have many little red "X''s where images used to be.

I need something to look through all my attachements, and either give me a list of what attachments aren't on my server, or better yet, pull these attachments and re-insert them onto my forum.

Any chance of this doing that?

[shiva]

Hi,

This looks almost exactly like what I'm looking for, but this is what I need to do.

I allowed my members to post attachments and link these attachments from an outside source. Some members dissappear, and eventually so do the images. Meaning now I have many little red "X''s where images used to be.

I need something to look through all my attachements, and either give me a list of what attachments aren't on my server, or better yet, pull these attachments and re-insert them onto my forum.

Any chance of this doing that?

Not sure what you mean. You mean direct links using the URL bbcode? Then it won't work, as this script will only display images and attachments uploaded directly through the attachment.php script, and not any links made as part of a forum post. As far as I know, there's no hack or mod that allows a direct URL link to be displayed as a file attachment through VB (though it's one of the most requested features)

[dssart]

Yes, that sounds like what I'm looking for..I just want something that minimally will alert me to broken image links, ideally something that will search for any message which has an attachment located off-site, and upload it to my server so it is on-site.

Thanks anyways..

[PixelFx]

anyone know if there is any updates to this?

[CarCdr]

anyone know if there is any updates to this?
My apologies for the long silence. Life got seriously in the way of such pleasant pursuits as coding vB. FWIW, the silence will continue for a little while longer until I finish my current day job project in July.

Cheers, CarCdr

[paulomt1]

The author will upgrade this great hack for work with vb3.5?

Thanks

[PixelFx]

thanks for the update :) can't wait to see what you come up with next for this, good luck with work :)

any updates planned? this system had a lot of potenial :)

[Smitty]

any updates planned? this system had a lot of potenial :)

Also curious - Any plans to update this for 3.5?

[SpankMe]

Here's a simple version that I run in vB 3.5. It doesn't have the search functions, but it should keep most people happy until this hack is fully converted.

Templates.

IBMAIN$stylevar[htmldoctype]
<html id="moooo" dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
<head>
$headinclude
<title>$vboptions[bbtitle] - $pagetitle</title>
</head>
<body>
$header
$navbar

<if condition="$pagenav">
<table cellpadding="0" cellspacing="0" border="0" width="100%" style="margin-bottom:3px">
<tr valign="bottom">
<td align="$stylevar[right]">$pagenav</td>
</tr>
</table>
</if>

<div align="center">
<center>

<table class="tborder" cellSpacing="1" cellPadding="1" width="100%" align="center"
border="0">
<tr>
<td valign="top" align="center" class="alt1">$imagebits</td>
</tr>
</table>

</center>
</div>
<if condition="$pagenav">
<table cellpadding="0" cellspacing="0" border="0" width="100%" style="margin-bottom:3px">
<tr valign="bottom">
<td align="$stylevar[right]">$pagenav</td>
</tr>
</table>
</if>

$footer
</body>
</html>

ib_imagebit<a href="member.php?$session[sessionurl]u=$image[userid]" style="text-decoration: none">$image[username]</a>
<a class="smallfont" style="text-decoration: none" href="image_browser.php?do=view&sel_userid=$image[userid]">[Filter]</a>
<br />
<a class="plain" href="attachment.php?attachmentid=$image[attachmentid]" target="_blank">
<if condition="$image[extension] == 'wmv'">
<img src="/forums/images/attach/wmv_large.gif" alt="$image[filename]">
<else />
<if condition="$image[extension] == 'avi'">
<img src="/forums/images/attach/avi_large.gif" alt="$image[filename]">
<else />
<if condition="$image[extension] == 'mov'">
<img src="/forums/images/attach/wmv_large.gif" alt="$image[filename]">
<else />
<if condition="$image[extension] == 'mpg'">
<img src="/forums/images/attach/wmv_large.gif" alt="$image[filename]">
<else />
<img src="attachment.php?$session[sessionurl]attachmentid=$image[attachmentid]&stc=1&thumb=1" alt="$image[filename]">
</if>
</if>
</if>
</if>
</a><br />
<a title="$vbphrase[post]" class="plain" href="showthread.php?$session[sessionurl]p=$image[postid]#post$image[postid]" style="text-decoration: none">$image[post_title]</a><br />
<i><a style="text-decoration: none" href="image_browser.php?do=view&sel_forumid=$image[forumid]">$image[forum_title]</a></i>
<br /><span class="smallfont">views: $image[counter] size: $image[filesize]
<br />$image[date] $image[time]</span>

and if you add this to your SHOWTHREAD (maybe above '<if condition="$show['addpoll']">'), then users will be able to view all images in that thread. <tr>
<td class="vbmenu_option"><img class="inlineimg" src="$stylevar[imgdir_button]/image.gif"/>
<a href="image_browser.php?$session[sessionurl]do=view&sel_threadid=$threadid">View thread images</a>
</td>
</tr>

[Smitty]

Nice for images but the original did all the attachments. That's what I really need.

[snotek]

Any plans on releasing this for vB3.5?

[Smitty]

Any plans on releasing this for vB3.5?

I wish!

[dethfire]

agreed, this hack is extremely useful hopefully someone picks it up

[dethfire]

has anyone tried running this on 3.5 or tweaking it? I don't think it would take much to get to work in 3.5

[Smitty]

I got a guy to change it so it works on 3.5 for me except for one of the functions - I think it was one of the 'sort' boxes. I paid US$50 (I don't know much about php so I couldn't do it). I haven't posted it because I don't know what the 'rules' are on things like that.

I NEED it for my site and really wish someone would take it and 'fix' it for 3.5. And yes - I am sure it's a simple 'fix'. But so it goes...

EDIT ADD: I have fileslist.php working, not attachment browser. My apologies. Sorry for replying incorrectly.

YES, YES, I wish someone would pick attachment browser up and fix it because of the search function.

[dethfire]

what is fileslist?

[Smitty]

Anyone interested in updating this?

[Stromba]

Sure.. Let it come

[Alfa1]

Does this work on vb 3.7.2 ?

[Smitty]

what is fileslist? Fileslist (http://Elsmar.com/Forums/fileslist.php).

############################################## ||
|| # FILES LIST # ||
|| # ---------------------------------------------------------------- # ||
|| # PORTED TO vb3.5 by cinq # ||
|| # Copyright 2005 Arthur Heng & vbArticles.com # ||
|| # All Rights Reserved # ||
|| # http://www.vbarticles.com ( cinq@vbarticles.com ) # ||
|| ############################################### ||
\*================================================ =*/

// #################################################
// ## FILES LIST V3.01 - By Dan Ward www.collegepranks.co.uk ##