The bulk of the missing files will be newer ones and the left over missing files from 2019 I had no duplicate match for. The members that are going to be most affected by missing files is anyone with the user ID starting with 5* +. Members with an ID between 4024 and 4999 will also be affected, this also includes anyone 41* +. Not sure if that makes any sense but there is further explanation below. If you are not in this group it doesn't necessarily exclude you. You can determine your user ID by hovering over the username in any topic you posted in, in the following example the user ID is 1234:
Code: Select all
https://fusor.net/board/memberlist.php?mode=viewprofile&u=1234
There has been questions raised about the file naming system used by phpBB but it has a purpose which I covered in detail here. In a nutshell it's to control access and for security reasons. Tens if not hundreds of popular web applications that allow users to upload files have been exploited over the past two decades, in some cases more than once. phpBB is not among them., there is features built into this system that have stopped exploits before they were even known, some of those exploits involved file naming. In any event whether it was 30K files with .jpg extension or named the way phpBB does the result would of been the same.
If you see any inconsistencies please let me know. specifically if a thumb is displayed is it the correct file? I don't expect this to happen but for the files that were recovered using the file name and file size I have not been able to thoroughly test, one of the big issues is I have no idea if what I'm looking at is what it's supposed to be. <wink>
Thumbs have been recreated for all images where required, if there is a missing thumb that means the source file is missing. There should not be any cases where the thumb is missing but clicking the link brings up a source file. If you encounter any links like this please let me know. For documents and other files that only display a link the only way to check is to click the link. I've added a custom modification to the User Control Panel so it displays thumbs for images so you can more easily identify what if anything is missing, at least as far as the images go. You can access this panel by opening the User Control Panel and click the link for "Manage Attachments" on the left.
I've also created a two custom scripts, the first will allow someone with access to the server to upload normally named files (somefile.jpg) into a directory and to try match them to the missing phpBB named files. The second one will list by member what files are missing. Both of these will aid in restoring the missing files if the members and operators of this forum want to take the time to do it. Files will need to be named the same as what was uploaded, they will also need to be the same filesize. Any edits that were made even if it's simply editing the meta data of image will result in failed match. They can be in multiple directories.
I don't know what the edit permissions are here but if you have edit permissions posts can now be edited to first delete the missing referenced file and upload a fresh copy that is what you want to do. If the files were placed inline be sure to check if they are appearing in correct order. If not just remove the text BBcode and reapply. You may want to take note in which order they were originally uploaded.
I'm not leaving quite yet as I have some lose ends to tie up but before I go just wanted to add it was interesting being here. I have fairly good knowledge of fusion technology compared to the average Joe. Never would I have imagined with the right materials and the knowledge you could build one in your basement. It's fascinating to say the least. I'm glad I took an interest in this because something like the problems you had can kill a forum. I'm usually dealing with gaming forums or some other nonsense, this forum was certainly worth the effort.
-------------edit----------
I didn't think to mention this in the original post but if you have missing files you can zip them and upload somewhere I can download from. They need to be named with original filename used for upload and unedited since the time of upload.
They can be in any directory structure. You don't have to pick though them, they can include what you think may have been uploaded or may not be missing to begin with. Try not to go overboard either, don't zip up a thousand files where 50 of them may have been uploaded here.
It's better for me to do it because the script to attach files is a resource hog and will need to be limited on the server. I can just let it run forever on my local machine but even with any thousand of files it completes in minutes.
If you are interested send me a link to .zip, .gz or whatever archive format you prefer.