Also SmartGnome, you may want the new collapse images, there on this site (vbulletin.org)...

They have no coloured background, the edges are transparent, so they will work well on your silver category title bars.

If you want them, I posted them on the vBulletin downloads section for vb3 on www.vbulletin.com/forum

Do you have a link for those?

I have a rather large amount of attachments... It'd be nice to use this, but I'm a little worried how it may effect my board...

Total Attachments: 163,632
Disk Space Used: 30,045.89 MB
Storage Type: Attachments are currently being stored in the filesystem
Average Attachment Filesize: 188.0 KB
Total Downloads: 22,612,198

Any thoughts? ;)

Here you go :cool: http://www.vbulletin.com/forum/showt...ollapse+images

Thank you, sir. At least someone in here answers requests. ;)

I have more than 180.000 attachments (around 77 GByte)....don't use this hack...

If this has a "SELECT * FROM attachment" query, it will cause MAJOR lag. You should be specific enough to SELECT all but the actual attached file, and it should be faster. Also, I haven't looked at the hack, but a "perpage" option that adds "LIMIT 30" or whatever to the query would speed it up tremendously.

There is a perpage function on this hack.

This is getting very close to what I need DWard.

Not sure if there's already a hack for this, but I'd like to see the attachments grouped by User. The attachments are 99% images of my members' work, and I'd like to be able to arrange the images into a gallery where the attachments are sorted by user. But if a user has made no attachments, then an entry for that user is skipped.

More on the above... I have Photopost, and many of my users post their images there. I'd like them to use Photopost exclusively to upload images, but the attachment feature in vb is much more convenient for some and I don't want to force them to do all extra steps necessary to upload photos into photopost, start the thread, get the url for the image they uploaded in PP, the go back to the thread post the image. So in this case, a separate 'gallery' for vb attachments is needed. Unless of course PP can grab a user's attachments from the file system and import them into photopost right when they create the post in vb.

Hey 'Ronin Six',

In response to the first paragraph, usernames are now shown in the files list, which you can see here: http://www.collegepranks.co.uk/forums/fileslist.php. This version is due to be released here some time next week. The next thing I am working on, is the ability to show thumbnails of any images attached.

In response to the second paragraph, I'm not too sure about this, you will probably need to contact somebody else to see if they can help.

Looks nice DWard.... for my forum the name is not so important, knowing in what forum the attachment belongs, should make the life of my mods easier :ermm:

Greetz

OK I have completed two objectives, however there are two left:

:: Upload files in the files list (wont be in the next version, but may in v3)

:: Sort by forum (looked at Boofos code, but it only counts the attachments in a forum, it does not list attachments by forum, because there is no forumid or field alike in the attachment table)

maybe we can add forumid just the way userid is added in the table?

Yes its possible, but then it requires more queries to slow it down and requires further hacking of attachment posting file and extension to mysql db

I will have a look in to it, but no promises that it will be in the next version, which will be released this weekend now!

FleaBag, where did you get your hits counter at the bottom of pages?

I've been looking for a counter like that for ages, but cant be arsed 2 make one myself.

get the new fileslist and tell me what you think!

I only changes the two templates and uploaded the new php file

Got this error now, the old version did work:

With the earlier version you gave me another filelist.php cause of same sort of probs.

Thanks Dan.

(edit)
Can this have something to do with my prefix vb3_ in the database ??

yer i see the problem, 2mins

OK, i updated the actual ZIP file, but there is the fileslist file:

tel me if that works plz

Great !! Works fine now with the usernames at the end :laugh:

Hope for the far future there will be also the forum title there :grins:

Tnx Dan

I'm working on it :)

SuperGnome... please do this when you have some free time, it makes sure the next button is all on one line in your fileslist page number block:

https://vborg.vbsupport.ru/showpost....3&postcount=40

DWard, I have fixed your file. You really had some things messed up in it, sorry to say. You CAN'T put table prefixes on userid variables. This:

Should be this:

And also, anytime you query more than one table in a query, ALL tables have to have the table AS table to it when someone has a table prefix in their db.

Here is the updated file.

I know its all over the place, it works, just need to get smartgnome to try out the new file to make sure it works, because the fixed file is how it was before i changed it, and supregnome had problems with that.

I promised everybody that I would get the cod out by 2night so I had to post it pretty much how it was :)

That's because he has a table prefix and you need to use the table as table in queries with more than one table.

Wasn't this version going to include Thumbnailed Images ??

It's a great hack - but this was what I was waiting for (installed today and it's not there) ... I don't wanna +++++ (by any means) but was just wondering if it might have been an oversight ...

If you read the literature, you will notice the thumbnails are shown in the IMAGES category only. And the thumbnails are only shown if you have them activated in the admin control panel.

If you look at my fileslist which is EXACTLY the same as it is on here, apart from the skin:
http://www.collegepranks.co.uk/forum...ortby=filename

Notice the thumbnails are there. You must have image attachment thumbnails turned ON in the Admin Panel or else it will just show the filename.

Then you forgot something because I have thumbnails turned on and I do not get anything but the file listing for them, too.

I have thumbnails turned on, and I thought it might be as you said (about them only being active if you look @ images only) - but last time I looked @ your site, it showed ALT text for your images only - not thumbnails - and mine (see the link) shows the default icon for images ...

I'm not trying to get stuck in mate - I'm just looking forward to a replacement for the old one for vB2 - I'm very appreciative of your efforts on this hack :) ok?

Tnx Dan ... fixed now and ok

@Dan

The same with me. Have tried several other settings, but no thumsb.

BTW: On your site I see only the placeholders and no pics

OK, ill look into it, it works fine on mine, I've attached a screenshot.

Ah now I see why, you must be logged in to view the pictures (understandable). I will fix and tidy it up for tomorrow evening if thats ok?

Still dont think you will be able to view the thumbs if you are not logged in, not unless you have allowed guests to view attachments.

If your images are displayed as thumbnails when you attach them, there is no problem.

I have thumbnails on, and my GD version is 2+

Same thing on my site. But I don't see any thumbnail code at all in the fileslist.php file that I have. How are you calling it?