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

[Stud_Muffin]

03-12-03 at 12:52 PM GamerForums said this in Post #290
OK I've found a solution for anyone wishing to remove this hack so that they can continue with versions 2.3.x onwards.

BY DOING THIS YOU WILL LOSE ALL OF YOUR ATTACHMENTS

Uninstall the hack using the install file.

Run this query...

DROP TABLE IF EXISTS attachment;
CREATE TABLE attachment (
   attachmentid smallint(5) unsigned NOT NULL auto_increment,
   userid int(10) unsigned NOT NULL,
   dateline int(10) unsigned NOT NULL,
   filename varchar(100) NOT NULL,
   filedata mediumtext NOT NULL,
   visible smallint(5) unsigned NOT NULL,
   counter smallint(5) unsigned NOT NULL,
   PRIMARY KEY (attachmentid)
);

You can now delete the folder with attachments as files inside.

You will lose ALL attachments in your BB, do not blame me if what I tell you to do here messes anything in your site up - MAKE A BACKUP.

Over and out.

Did that, lots of files to sieve through now :cry:

[FleaBag]

What do you mean?

[Stud_Muffin]

I still have the attachments on my server but not on the forum. Just loads of files like so. beca544936ecfacf43c7076feb61d140.file so i need to load them up to see if i need to keep or delete them, that was all.

[FleaBag]

Ah I see what you mean. I didn't go to that much effort... My site has been open for 15 months, so there was a fair few to look through... I just deleted them all.

[Bison]

IMO ... this thread and this hack needs to be removed since no one's gonna help anyone with this !

[wolfman]

Well I am glad I was able to see this before installing this hack.

[wooolF[RM]]

]or just run 2.2.9 and no problems

storing all attachments in the database is pain in the ass as for the speed of it and as for backuping

[FleaBag]

But still, your attachments won't work in version 3.x.

[Bison]

Today at 09:46 AM wooolF[RM] said this in Post #297
or just run 2.2.9 and no problems

storing all attachments in the database is pain in the ass as for the speed of it and as for backuping

I Guess you don't plan on updating to vB3! :smoke:

[wooolF[RM]]

]exactly my point, Rolodex!