vb.org Archive - Administrative and Maintenance Tools

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)

- - Administrative and Maintenance Tools - Limit Attachment Downloads (https://vborg.vbsupport.ru/showthread.php?t=152701)

Limit Attachment Downloads

Limit Attachment Downloads 1.3

The writing of this hack was sponsored by: sama3y.net

About this hack:
This hack allows you to limit the number of attachments users can download during a given time period.

This hack is pretty flexible right now. You can choose how many attachments a user can download in a give time. That given time can be set to an hour, a day, a week, a month, 3 months, 6 months, or a year. You also set which attachment types get counted for this hack. Also, you set which usergroups get affected by this hack and how many downloads each usergoup can make.

If a user tries downloading past their limit, they will get an error message. This error message includes when they will be able to start downloading again.

Also, there is a cron job to remove from the table that this hack creates, all the rows that are past the limit date so your table doesn't grow forever and saves you space.

Files edited: 0
Templates edited: 0
Files to upload: 2 (1 via ACP, 1 via FTP)
Time to install: 1 minute

Updates:
Version 1.0 (7/19/07):

First Release of this Hack

Version 1.1 (7/19/07):

[FIXED] MAJOR BUG, the main table needed was not being installed, causing database errors.
[CHANGED] I moved over the attachment limit to the usergroup settings to give an option of different download amounts per usergroup.

Version 1.2 (7/19/07):

[FIXED] I REALLY now fixed the MAJOR BUG, the main table needed was not being installed, causing database errors.

Version 1.3 (7/29/07):

[ADDED] I added a lot more options to 'Download Limit Time Frame' option.
[CHANGED] Thumbnails are not counted as download attachments.

Please post your comments or suggestions for this hack. I read ALL posts.

MAKE SURE YOU CLICK INSTALL!
You will get an email when a new version is released.

Pictures:

The error message.
Found in the main vb settings
Found in the attachment types setting
Found in the usergroup settings

first post ... nice mod ... *installed*

cool hack, thank you :)

[edit] doesn?t work with 3.6.5 :(

This is something that heaps of people have been wanting for ever! very nice work.
Will install it on my site very soon.

I have some ideas for extra features, if your interested in expanding it, let me know.

thanks.

Hi
Great idea, i will take a look at it tonight Abe1, thanks :)
Perhaps 1 post could reset the limit?
Also, would this work with Downloads II or, could you make this work with it please Abe1?

don't work
database error when downloading of a group subjected to this hack

Quote:

Originally Posted by mhammed (Post 1295490)

don't work
database error when downloading of a group subjected to this hack

Can you post the error message?

Quote:

Originally Posted by Roflstilzchen (Post 1295347)

cool hack, thank you :)

[edit] doesn?t work with 3.6.5 :(

What doesn't work?

Version 1.1 (7/19/07):

[FIXED] MAJOR BUG, the main table needed was not being installed, causing database errors.
[CHANGED] I moved over the attachment limit to the usergroup settings to give an option of different download amounts per usergroup.

Upload BOTH files again.

install the 2 end version
member can download 1 st file
the second file give database error

Quote:

Originally Posted by Abe1 (Post 1295596)

Version 1.1 (7/19/07):

[FIXED] MAJOR BUG, the main table needed was not being installed, causing database errors.
[CHANGED] I moved over the attachment limit to the usergroup settings to give an option of different download amounts per usergroup.

Upload BOTH files again.

uploaded new files, deinstalled old hack and installed new one, controlled settings but still doesn?t work.

Code:

Invalid SQL:



                        SELECT MIN(attachment_limit_date) AS limit_date, COUNT(*) AS total

                        FROM attachment_limit AS attachment_limit

                        WHERE attachment_limit_userid = 1

                                AND attachment_limit_date > 1184772649;



MySQL-Fehler : Table 'xxx.attachment_limit' doesn't exist

Fehler-Nr.   : 1146

Datum        : Thursday, July 19th 2007 @ 05:30:50 PM

Skript       : http://www.xxx.com/board/attachment.php?attachmentid=58&d=1183771605

Referrer     : http://www.xxx.com/board/showthread.php/memory-35918.html?t=35918

IP-Adresse   : 85.8.97.180

Benutzername : xxx

Klassenname  : xxx

X vBulletin 3.8.12 by vBS Debug 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 (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02223 seconds Memory Usage 1,743KB 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 (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: