Ability to Restrict amount of downloads from Attachments

[shiva]

I requested this before, but no one came up with a solution, so I am doing it again here.

I need the ability to restrict the amount of attachments for certain membergroups. The strain on my server because people are greedy is causing a lot of problems.

Either by a amount of attachments a member can download per day (like say just 5) or even the ability to have a page that comes up with a countdown of a time period, before the link will appear to be downloaded (Should not be a pop up page, just changes the page from the thread)

Please, I have no idea on scripting, and this has killed my server a few times, and one of these days, I may go over my bandwidth limit.

Help?

[Andreas]

Limiting the amount of DL/day should be fairly easy with a Plugin:
- Create a new Field in Table User for counting
- In Hook attachment_start check this field.
If we're over quota: eval(standard_error(fetch_error('dlquotareached')) );
If not: Increment the Counter
- Cronjob run at midnight to reset the counter.

Done.

[PixelFx]

......

[PixelFx]

please delete post

[Chris M]

ALTER TABLE user ADD downloadcount INT (5) DEFAULT '0' NOT NULL

attachment_start
$downloadlimit = 10;
if ($vbulletin->userinfo['downloadcount'] > $downloadlimit) {
eval(standard_error(fetch_error('dlquotareached')) );
exit;
} else {
$db->query_write("UPDATE user SET downloadcount = downloadcount + 1 WHERE userid = $vbulletin->userinfo['userid']");
}
Untested but should work - Then create a cron job to reset downloadcount = 0 ;)

dlquotareached
You have already downloaded the maximum number of attachments for today. Please try again tomorrow!

Chris

[kahloz]

Hi, this is actually similar to what I'm looking for and I tried following your instructions but erhm... I couldn't find attachment_start and I have no clue how to do a Cron Job file ;)

Though instead of downloaded attachments, I'd be more interested to know if we do a whole Bandwidth limit, but download attachments works fine too.

Can you walk me step by step for 3.5.1?

I'd greatly appreciate it.

Thanks!

[Chris M]

Goto your Admin CP
Find the "Execute SQL Query" link on the navigation
Paste the contents of the "SQL" box in my previous post into the textarea
Click Continue
Click Continue on the next page that appears
Find the "Plugin Manager" link on the navigation
Click "Add New Plugin" on the Plugin Manager Page
Select attachment_start as the hook location
Enter "Download Count Restriction" as the title
Paste the contents of the "PHP" box in my previous post into the textarea
Click the "Yes" radio button next to the question of if the Plugin is active Save it
Find the "Phrase Manager" link on the navigation
Click "Add New Phrase" on the Phrase Manager Page
Select "Error Messages" as the phrase type
Enter "dlquotareached" as the varname
Paste the contents of the "Code" box in my previous post into the textarea
Save it
Now create a cron job which resets the downloadcount field of the user table to 0 every 24 hours

It should work - I will check this thread to see if there are any problems :)

Chris

[kahloz]

Wow, you're da bomb!

You had me at hello!

Erhm, you had me up until cron job ;)

I don't know how to create a Cron Job, I can find it in the Scheduled Tasks and I can enter all the necessary fields, but don't I need a PHP file? Like, Downloadlimitreset.php?

And if so, what should I put inside it? resetdownloadcount = 0 ?

*edit: ok, now I'm getting a MySQL error too

Invalid SQL:
UPDATE user SET downloadcount = downloadcount + 1 WHERE userid = Array['userid'];


Hey, is this possible to based on usergroups? like tell it that this group has a 10 daily limit while this other group has NO limit? That'd be awesome. :tired:

[Chris M]

You'll need to make a file with the following Query:
UPDATE user SET downloadcount = 0
You should change the php code to the following:
$downloadlimit = 10;
if ($vbulletin->userinfo['downloadcount'] > $downloadlimit) {
eval(standard_error(fetch_error('dlquotareached')) );
exit;
} else {
$db->query_write("UPDATE user SET downloadcount = downloadcount + 1 WHERE userid = ' . $vbulletin->userinfo['userid'] . '");
}
:)

I'll do the usergroup thing when I get more time :)

Chris

[PixelFx]

You'll need to make a file with the following Query:
UPDATE user SET downloadcount = 0
You should change the php code to the following:
$downloadlimit = 10;
if ($vbulletin->userinfo['downloadcount'] > $downloadlimit) {
eval(standard_error(fetch_error('dlquotareached')) );
exit;
} else {
$db->query_write("UPDATE user SET downloadcount = downloadcount + 1 WHERE userid = ' . $vbulletin->userinfo['userid'] . '");
}
:)

I'll do the usergroup thing when I get more time :)

Chris

Darkwaltz kindly coded a custom system for me, thats quite advanced :D so I'm really happy .. this system above is really good as well thank you :D

[kahloz]

Hey Chris,

I did your changes, the Cron Job works fine I tested it, however I'm still getting a MySql error.

Invalid SQL:
UPDATE user SET downloadcount = downloadcount + 1 WHERE userid = ' . Array['userid'] . ';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'userid'] . '' at line 1
Error Number : 1064

Perhaps PixelFX will be kind enough to share his code? :)