vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Administrative and Maintenance Tools - Allow users to upload more than 10 attachments at once (https://vborg.vbsupport.ru/showthread.php?t=189945)

wolfstream 09-02-2008 10:00 PM

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.

Code:

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 09-03-2008 04:13 PM

Is it safe?

wolfstream 09-03-2008 04:27 PM

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 09-03-2008 05:33 PM

Wonderful, I've needed something like this as well

Thanks

nando99 09-04-2008 12:42 AM

would this work in vb 3.6.8?

wolfstream 09-04-2008 12:54 AM

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 09-04-2008 01:29 AM

Have you tried it on your forum?

wolfstream 09-04-2008 02:04 AM

Quote:

Originally Posted by Hitterman (Post 1614058)
Have you tried it on your forum?

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


All times are GMT. The time now is 10:43 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00969 seconds
  • Memory Usage 1,725KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (8)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete