Copy Attachments in file-system

[muffel]

We have a forum, where all attachments are in the database... and they should stay in the database.

But I want to download all attachments in our forum to a special folder on the server... where I also can then see, from which user this attachment is... and the extension should also be right - for example ".jpg" ... Is there a workaround for this?

Thank you!

[Brandon Sheley]

I wouldn't suggest this but you can set your folder to a public location. All files will be in numbered folders.

[muffel]

Thank you - but I know this way. I want to keep the files in the database - just make a copy of them into the file-system.

[Dave]

As far as I know there's no automated tool for this.
You'd have to make a script for it or find someone to make a script for you to export it from the database into the filesystem with the right filename and extensions and into user folders.

[Brandon Sheley]

I wouldn't keep them in the database regardless, that's for sure.
It's smarter to have them in the file system. It's mapping like you're asking that's the not so easy part.

[TheLastSuperman]

Guys - how now brown cows!

This is so easy it hurts (lol) i.e. just move them to filesystem (so it generates the files accordingly) then copy the files so you have the "copy" of the attachments you desire. Of course the files will not have the proper names but will be viewable in an image editor. Once done downloading simply move them back into the database and done.

Super easy unless I missed something?

Edit: Ahh I see why you all thought... okay okay so basically yes it will be for example file names such as 34.attach and then the thumbnail would be 34.thumb which is clearly not 34.jpg or 34.png HOWEVER you can open these via photoshop OR a free program called Gimp 2 and they will open and display the file fine for viewing, you can then save to a proper windows style extension instead of vBulletins .thumb/.attach etc etc.