Check which attachment files are not used

[X3mE]

Is there a way for me to check which files in the attachments folder are not used as attachments?

[N3RVE]

Hello, X3mE
I couldn't find a way to remove attachments that aren't linked with posts but I will be looking more into this shortly. Currently, you can perform maintenance to remove old attachments and/or attachments larger than a specified size.
Admin CP -> Forum -> Attachments and Avatars -> File maintenance.

-[n3rve]

[X3mE]

Thank you, I hope you'll find a solution

[Rumbaar]

Well all things being equal there shouldn't be any orphan files.  As once you delete them they are deleted from the folder.

As the database holds what is in use, there is no real way to check the other way.  I know there was a post I responded too many months ago with the same question and a few ideas and limits to what was possible.  Due to the nature of attachment storage and 'encryption' of filenames.

[X3mE]

Let me explain what happened... I have switched to a new server, and uploaded everything but the attachments folder (as they take a lot of space, and my upload speed is slow), and then, while uploading them, one of the users didn't see my note about attachments not working currently, and reuploaded a few he posted earlier. So, when the upload had finished, I practically had a few "double" files, that is a few files not used as attachments. They are only a couple of MB big, nothing to worry about, I just asked if there's a sophisticated way to check which files in that folder are not used.

[Rumbaar]

Not that I'm aware of sorry, a very manual process and possibly impossible if you have filename encryption on.  Maybe guess work and date/timestamp checking.