Administrative and Maintenance Tools - 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

[shadowevil]

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

[Roflstilzchen]

cool hack, thank you

[edit] doesn?t work with 3.6.5

[Hornstar]

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.

[bashy]

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?

[mhammed]

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

[Abe1]

Originally Posted by mhammed

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

Can you post the error message?

Originally Posted by Roflstilzchen

cool hack, thank you

[edit] doesn?t work with 3.6.5

What doesn't work?

[Abe1]

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.

[mhammed]

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

[Roflstilzchen]

Originally Posted by Abe1

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.

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