Administrative and Maintenance Tools - Allow users to upload more than 10 attachments at once

I recently ran across a need to have more than 10 attachments uploaded on a regular basis, and for the life of me couldn't figure out how to do it. This will help people with that little problem. It's a quick hack, but it works,as long as you follow the instructions.

This is an SQL qery which may be run through vB admincp, or through phpmyadmin, or your favorite SQL editor. This will turn the 'dropdown' attachment limit selection into a standard textbox which will allow you to submit your own limit. Of course, keep in mind that you don't want to allow TOO many attachments, but in some cases, allowing more than 10 attachments is necessary.

UPDATE setting SET optioncode = '' WHERE CONVERT( `setting`.`varname` USING utf8 ) = 'attachboxcount' LIMIT 1 ;

This is a small hack, but you should still backup your forum before running ANY kind of SQL query!

[Hitterman]

Is it safe?

[wolfstream]

The query itself is quite safe. I've run it at least twice now, it's not caused any issues that I've run into.

Is it safe to allow 1000s of attachments to be uploaded? Of course not, because you'll always find the clown who'll fill up your server with massive attachments.

Everything in moderation. I just ran across a legit need for more than the default dropdown 10 (legal fansite downloads of shows), and thought I'd share how I did it for someone else who might need to do the same thing.

Of course, you'll have to moderate stuff heavily with a lot of attachments, but that's a given

[SEOvB]

Wonderful, I've needed something like this as well

Thanks

[nando99]

would this work in vb 3.6.8?

[wolfstream]

I couldn't honestly answer that, but I don't see why not.
All this does is replace the vb option for this , turning it from a select option to a blank text field.

As always you'll want to backup things before you try that, especially on an untested version.

[Hitterman]

Have you tried it on your forum?

[wolfstream]

Originally Posted by Hitterman

Have you tried it on your forum?

I wouldn't post something that I DIDN'T try on my own first.