Attachments as files

Well after alot of time leaving it in the beta hacks forums without any problems, I'm now moving it to the Full Releases, I'm satisfied that there isn't any bugs that need to be addressed. Thanks to Jawelin he pointed out most of the mistakes through alot of his testing.
I've attached it as an installer file here, as it needs to make changes to the database. Two new rows to settings and a new column in the attachment table.

Scott

Updated some more

Note the > is missing off the bottom of the file after the ?, add it before trying to install

[sdenvers]

Two problems encountered on 2.2.6 trying to install this hack:

1. It said I'd already installed it, but I haven't.
2. During import it gives this error for each file, and the attachments directory is left empty:

"Warning: fwrite(): supplied argument is not a valid File-Handle resource in /home/xxx.com/html/forums/admin/attachment_install.php on line 333

Imported car_wash.jpg"

Help!

[FleaBag]

Works with 2.2.8.

[ricoche]

Could anyone tell me what possibly could have gone wrong here? I saw in the previous post that this hack worked with 2.2.8. So I installed it and now all I get is a blank white screen on my computer. The hack has totally messed up my entire system and I don't know how to uninstall or fix this. I noticed a couple of people had this problem back a few posts but I didn't see a solution.

Any help would be appreciated all my hard work seems to have been destroyed.

Thanks,

Ricoche :disappointed:

[Scott MacVicar]

every page is a white screen?

It sounds like you've done something wrong within functions.hpp

[ricoche]

I agree I think there is a problem with my functions.php but I'm not sure how to correct it. I made a .bak of my original, so maybe if I delete the new one and go back to the install I can redo the cut and paste job?

Wow, this is pretty scary. I thought I had this down.

Oh, also I was able to back track and dump an attachment from the database into my attachments folder with permissions set to 777 just fine. Like I said I'm confined to my vbulletin control panel only ...at the moment.

Thanks for the reply. Right now <laugh> I'm just twiddling my thumbs and sweating bullets!!

:cross-eyed:

Ricoche

[ricoche]

Ok, I finally figured what I did wrong.

In the first edit for functions.php I failed to do the replace until the end of the function. I do understand some basic programming but for some reason I forgot that { } define beginning and ending of functions. Actually I knew this but if you look at the code it's quite confusing to identify where it ends. Kind of tricky I think.

Anyway all is well now except one thing that I think was posted earlier. The previous attachments that I had now no longer show up on the front page of my vbportal script. Have to figure that one out now.

Thanks.

[ricoche]

Finally got it. The conversion didn't work so I just deleted the only couple of attachments I had and reposted them. The script automatically did everything else and now my attachments can be viewed by admin at least.

Thanks for the script. It sure confused the heck out of me but in the end it does work.

Thank you .

Ricoche

[HappyPike]

How long does it take to import the files from the database to a directory? My forum's attachment table is 1.8 GB in size... I hope it doesn't take forever....

Also, does the script delete files from the attachments table as it imports the file, or does it only delete the files in the attachment table after all the files have been imported to a directory? If it makes a copy of all 1.8 GB files first, I don't think I have enough space on the server.

Thanks.

[Areku]

I'm sorry if I repeat questions but this support thread has grown too much...

- Are there any chances to have real file attach names instead of weirdos like 0170111c41158690b35dbd1754a54929.file?

- I'm running v2.2.0 and it seems to be working fine, but haven't tested it in full... Do i need to remove/add the visible thing u were talking about with 2.2.2?

- How do I reset the attachments table so I remove them from the DB now that I have them as files?

Thanks!

[Scott MacVicar]

I'll probably be changing it to just the attachmentid number soon it will allow for much easier vB3 upgrades. I'll actually try to do it tonight.