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

[Chris M]

Did you make sure that you converted the existing attachments?

Satan

[Bison]

I ran the converter and dumped everything into a directory I created. The original files are there .... only when I upload a image to be viewed inside the thread that this doesn't work!

[FleaBag]

Working on 2.2.7, cheers!

[NoAhBoDy]

Very nice hack...makes backup sooo much faster

Thanks!

[Learner29]

well,

I apologize if my question has been answered before, but here it is.

I installed this hack, and did all the changes, and the forum replied back saying :

Import of Files from database completed

If you are sure that the files have been imported correctly you may drop the filedata column in the attachment table

now, I went to the forum to see if "the files have been imported correctly" and all attachments are still downloadable..

I got a look at the attachments folder that I made on the root level and to which I gave the 777 chmod, and I found plenty of BINARY files with totally bizarre names such as 0b9732abf17c4032c2ef27fd562f4f70.file

1) does that mean the hack worked perfect for me now ???

2) when you say "you may drop the filedata column in the attachment table", does that mean in phpmyadmin???

3) would future attachments be automatically exported as files, or do I have to do anything every now and then???

4) if a user attaches a virus-containing zip file, can I simply delete it via FTP ? if not, how can I safely delete an attachment now??

thank you so much PPN for the great hack, I really appreciate your great help

[Learner29]

no answer ???

[Learner29]

would any kind person kindly help a bit ???

[Hoffi]

Originally posted by Learner29
well,
[snip]
1) does that mean the hack worked perfect for me now ???
yes
2) when you say "you may drop the filedata column in the attachment table", does that mean in phpmyadmin???
yes, i tried it before i dropped it, with renaming and testing if the Attachments work.
3) would future attachments be automatically exported as files, or do I have to do anything every now and then???
new Att. are saved as a file. Without the filedata they can't stored in the table.
4) if a user attaches a virus-containing zip file, can I simply delete it via FTP ? if not, how can I safely delete an attachment now??
i think it is very complicated to find out which file in the folder is the one you want to delete. Do it as always...

thank you so much PPN for the great hack, I really appreciate your great help

[Learner29]

thank you a million Hoffi

I really really appreciate your help

thank you man !!!!

new Att. are saved as a file. Without the filedata they can't stored in the table.

well, thank you a lot, but as I was not sure, after exporting the attachments to files, I did not delete the table immediately... and was waiting to be sure.

Now that I trust your answer, I could go and delete the table in phpmyadmin.

but what about the attachments that were made between the export I did a few days ago and dropping the table today?? would those be lost ???

should I delete all the attachments folder and restart the exportation and then immediately delete the table in phpmyadmin???

so you are saying in this way, as the table is missing in the database, all future attachments would be exported directly as files , right ??



Thank you a million for your help

I appreciate it man .

[Hoffi]

Immedeatly when you uploaded your hacked files, the attachments weren't stored in the DB.