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

[Abe1]

Originally Posted by Roflstilzchen

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

Can you uninstall then re-install?

[Roflstilzchen]

Originally Posted by Abe1

Can you uninstall then re-install?

that?s what i meant with deinstalling and installing the new one.

[Abe1]

Any way I can check you ACP?

[DJ XtAzY]

Awesome! Now i dont need to use the points to download attachments for our members =]

[Roflstilzchen]

Originally Posted by Abe1

Any way I can check you ACP?

you?ve got a pm

[Abe1]

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.

[Roflstilzchen]

thank you, works great now

[Virtuosofriend]

Great work mate. Is it possible, i still havent installed so i dont know, to limit it per forum?

[Abe1]

Originally Posted by Virtuosofriend

Great work mate. Is it possible, i still havent installed so i dont know, to limit it per forum?

No. It is only done on a usergroup level.

[PlymWS]

If a user reaches their limit, will they still be able to see the thumbnails of attachment images or will they not be displayed ?

This mod would suit my site fantastically but I would still need users to be able to see thumbnails when they have reached their limit.