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

[Learner29]

thank you very much for your great answer

[Bison]

All I know is that this frigging hack has hosed up my whole company forum!

I have it installed and I dropped the filedata table as requested and now the admin/index.php file and serverinfo.php files are looking for that table!

Sheeze!

I don't see anywhere in the installer that mentions to comment out the calls from these files to that specific table!

BTW, i'm using vb2.2.6 ... Is there anyway to reverse the damage that this ******* hack has done? I did do a backup (vbulletin.sql) from a recent dump ... will that get my sh*t back into my database?

My frigging Boss is going to kill me!

[Learner29]

Rolodex wrote:

All I know is that this friggin hack has hosed up my whole forum!

I have it installed and I dropped the filedata table as requested abd now
the admin/index.php file and serverinfo.php files are looking for that
table!

Sheeze!

I don't see anywhere in the installer that mentions to comment out the calls
from these files to that specific table!

BTW, i'm using vb2.2.6 ... Is there anyway to reverse the damage that this
******* hack has done? I did do a backup (vbulletin.sql) from a recent dump
... will that get my sh*t back into my database?

My friggin Boss is going to kill me!

Oh my God. I have not dropped the table yet, for though I do trust Hoffin, I
just wanted to make a little test.
I uploaded a file, call it file.zip, and then checked my root vbattachments
folder and my database using phpmyadmin, and the file was updated to both !!
the file appeared both in my database AND in my vbattachments folder .....

I deleted the post and the file.zip, and the file was deleted in BOTH my
vbattachments folder AND my database....

is that normal ???

[Hoffi]

First of all nobody should delete a whole table. The filedata is only a column in the Attachment Table. If you delete the whole Table the Forum won't work anymore...
If you apllied all Changes to your Files, the access to that row is eliminatzed and the Files are used.

However, if you make changes to your Forum make Backups. Even the Database and the Files!

@Rolodex: If the Dump was before you drop the Column (Table?) it brings you the Data back. But if you won't use this great Hack, you must change your Files back to original too.

[Bison]

Did I say "Drop Table?"

Ok ... I did but I actually didn't drop the table ...
just the filedata column. I had everything installed proplerly (I think) but there were things that weren't showing up (Like Uploaded Images In threads) and all of the attachments that were uploaded after the hack couldn't be seen at all ... and i'm the Admin.

This is the only hack that didn't work for me. PPN I like your hacks but this one and the "login as user" Hack (Scews up the User.php after installing PHP 4.2.x) has compiled a few problems with me and with the Vbulletin 2.2.x Board Code.

I think you should check them again for compatibility...

Regards,
Rolodex

[Learner29]

I am sorry to hear that Rolodex......

really.

I have just dropped the filedata column in phpmyadmin and everything seems to work .....

I could download old attachments, upload new ones, and download new ones. as admin or just a modo......

[Learner29]

thank you PPN once again for this great hack.

my database is about 20 megabites less now .........

oufffff

[Scott MacVicar]

I'll post the importer sometime before the vB3 release which will translate your attachment table into a vB3 readable format.

But the easiest solution may just be to import all the attachments back into the database.

[Learner29]

thank you PPN for your continued efforts .....

to be honest with you, I DID think of this yesterday and asked myself : what when vb3 comes out ??? how do I keep those exported attachments that are not any more part of the database now...

thank you for working on an importer to prepare the attachments in a vb3 readable format.

I appreciate it.

one more thing : as soon as your hack is ready for vb3, I will be happy to test it for you and tell you how it works.

[Scott MacVicar]

Attachments as files is standard in vB3 so I'll simply attach a script to change it to that format, I'll have it pretty well tested anyway well before any sort of public release. But you probably should test it just to make sure that I dont have any problems with different OS's.