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

[Bison]

I hope you backed up your files & database. This puppy is *Dangerous* ... once you've got errors they can't be fixed properly...

[FleaBag]

There was no point me backing up my database, I installed this hack a long time ago, my database has trebbled in size since then. There must be a way of re-importing the files into the database.

[Bison]

I ead somewhere in this thread that one of the guys were going to create a file importer program for this hack. The author hasn't supported this hack in several months, and I believe that he was working on making this file importer.

I feel for you, but I would have made a backup (Of everything) before upgrading my forum... if I was successful installing this hack the first time.

It's a nice idea with a deadly bite ...

[wooolF[RM]]

nah... it works on all versions exept 2.3.x
and that's bad... otherwise it's a nice hack... I use it and have no problems

[FleaBag]

I do back up my forums, and in fact all of my site on a monthly basis - all I'm saying is that a backup from a month ago would be useless to me.

Is it possible for me to downgrade to 2.2.9?

[FleaBag]

Looks like this hack is never gonna work for me, so I think it's time to say goodbye to this thread permanantly [and to over a years worth of attachments]. Oh well...

[Bison]

Like I said before ... Nice Idea, but with no support, your playing a game of "russian roulette!"

[NoAhBoDy]

..so I guess if you have this hack installed and don't want to lose your attachment db, you're stuck at 2.2.9 ??

[FleaBag]

More or less - yes. And you won't be able to upgrade to version 3 either.

[FleaBag]

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.