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

[Scott MacVicar]

Will update the code when i get back from my 2 week vacation.

[Jawelin]

Have nice holidays....

[AWS]

Finally got arround to installing this.

DB size before 234Meg
DB size after 98Meg

Great hack. Did just what I was looking for.

[Courage]

I really nned this hack :@
I'm running vb 2.2.2 and I get this nasty error when I try to run the installer (on the first step)

Database error in vBulletin Control Panel 2.2.2:

Invalid SQL: ALTER TABLE `attachment` ADD `hash` VARCHAR(32) NOT NULL
mysql error: Lost connection to MySQL server during query

mysql error number: 2013

Date: Wednesday 19th of June 2002 03:08:30 AM
Script: http://www.softnews.ro/forum/forum/a....php?s=&step=3
Referer: http://www.softnews.ro/forum/admin/a...t_install.php?

I have a lot of hacks installed...
This is the problem ?

Please HELP !!!

[eoc_Jason]

Just a thought, you might want to have some "upgrade" instructions. I accidently clicked the remove one thinking I could convert back from files to DB, but instead it just wiped out my hashes (ACK!), maybe have a confirm on what is about to happen?

But anyhow, It would be helpful if you could do a "upgrade" choice which would just re-display the code that is needed but not do any other stuff.

[Tigger9969]

Here is my problem:

We're running vb2.2.6. We have no problem uploading files smaller than 2MB, other than it takes a REALLY long time.

We are not using safe mode.

When we try to upload a file larger, after a really long time the message is posted but the file attachement is not there.

Does anyone know why? Any help will be greatly appreciated.

Tigger9969

[Boofo]

The default value for PHP is 2 meg. You can change that limit size in the php.ini file on the server. You will probably have to talk to your ISP about that.

Originally posted by Tigger9969
Here is my problem:

We're running vb2.2.6. We have no problem uploading files smaller than 2MB, other than it takes a REALLY long time.

We are not using safe mode.

When we try to upload a file larger, after a really long time the message is posted but the file attachement is not there.

Does anyone know why? Any help will be greatly appreciated.

Tigger9969

[papoo]

thanks i will try it

[Darren Evans]

If this is a dumb question... shoot me.

Why do all the files that are exported from the database into the attachments folder have long names with .files as an extension? Is there any way to get them exported as their original file names? What did I overlook?

Thanks!

[Boofo]

You didn't overlook anything, the hack is supposed to do that. If you really want to export them as the original filename, just copy it over to wherever you want it copied and rename it to its original filename.

The naming convention is more for security reasons than anything else, I think.

Originally posted by Darren Evans
If this is a dumb question... shoot me.

Why do all the files that are exported from the database into the attachments folder have long names with .files as an extension? Is there any way to get them exported as their original file names? What did I overlook?

Thanks!