Limit Attachment Downloads

[Abe1]

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 (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=152701)!
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]

don't work
database error when downloading of a group subjected to this hack
Can you post the error message?
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]

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

[Abe1]

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]

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]

Any way I can check you ACP?

you?ve got a pm :cool:

[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]

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.

[chapsrulez]

Installed and working.
Great work.
thanks.

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

I think it can be done, in my site i have a download subforum, and per usergoups i deny the downloads. on all other subforums downloads are enable.

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.

In my site works
I didn't enabled the plugin for "jpg, gif, png and psd files" and enabled it for .dwg, .3ds, .rar, .zip, etc.
When a user uploads a new attachment in (dwg, 3ds, rar, etc) i create a thumb so user sees what they are downloading.

[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.
This was easier than I thought. For everyone else who wants this feature :

ACP -> Products & Plugins -> Plugin Manager -> Edit attachment_display thus :
change

if ($count_download)

to read

if ($count_download && !$vbulletin->GPC['thumb'])

Save.

[Abe1]

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.


Just re-upload the product XML file.

[PlymWS]

The product download is for 1.2 yet the latest version is 1.3 ???

[Abe1]

The product download is for 1.2 yet the latest version is 1.3 ???
Sorry, forgot to change the file. Check now.

[Hornstar]

Some of my suggestions for a future update:
1. Any chance to add captcha to the attachments as an option?
2. If users go over allowed attachments, add a count down timer, that they will have to wait before they can download.

These 2 options would be mod of the month for sure!

[gforce75]

Very good concept :p

[Abe1]

1. Any chance to add captcha to the attachments as an option?Not sure what you mean. How would this help this hack.
2. If users go over allowed attachments, add a count down timer, that they will have to wait before they can download.
This is a feature already! If you try to download an attachment after you used your time already, then it tells you how much time you have left. (look at the first image in the main post)

[lasto]

this is quite good but how about if a user uploads an attachment in a specific forum then their attachment limit goes up by 1

This would encourage people to just not download attachments but also to upload stuff which is relevant to the site in question.

[Abe1]

this is quite good but how about if a user uploads an attachment in a specific forum then their attachment limit goes up by 1

This would encourage people to just not download attachments but also to upload stuff which is relevant to the site in question.
If a user uploads an attachment, then they get an extra download?

[lasto]

yep because this hack limits them to how many per day/month etc but no incentive to try boost their limit back up.
Not sure if u can pull it off but cheers for hack Abe1

[Hornstar]

Some of my suggestions for a future update:
1. Any chance to add captcha to the attachments as an option?
2. If users go over allowed attachments, add a count down timer, that they will have to wait before they can download.

These 2 options would be mod of the month for sure!

Not sure what you mean. How would this help this hack.This is a feature already! If you try to download an attachment after you used your time already, then it tells you how much time you have left. (look at the first image in the main post)


1. I have 90 00 members on my site, I had a thread created 4 days ago which had a 1.9 meg attachment in it. within 4 days, 30 000 people have downloaded it, that is almost 60GB of bandwidth! I doubt those downloads were unique!

People can login create a bot, and then have that bot keep downloading that attachment to waste bandwidth. Having a catpcha image, would make the bot useless.

Not everyone may want this, but at least having the option in the admincp to turn it on/off would be great! as I would use it for sure!

2. I mean like rapidshare, if they go over then the countdown timer starts exactly like rapidshare, with ajax, so they dont have to refresh etc.

thanks.

[iDenis]

Thanks...nice mod ...

But now I'm have a simple problem...

Group "Unregistered / Not Logged In" don't have "Limit Attachment Downloads" and "Download Attachment Limit" parameters :confused:

[Abe1]

1. I have 90 00 members on my site, I had a thread created 4 days ago which had a 1.9 meg attachment in it. within 4 days, 30 000 people have downloaded it, that is almost 60GB of bandwidth! I doubt those downloads were unique!

People can login create a bot, and then have that bot keep downloading that attachment to waste bandwidth. Having a catpcha image, would make the bot useless.

Not everyone may want this, but at least having the option in the admincp to turn it on/off would be great! as I would use it for sure!This would be a totally separate hack.

2. I mean like rapidshare, if they go over then the countdown timer starts exactly like rapidshare, with ajax, so they dont have to refresh etc.

thanks.
I dont think I'll add it.

[Hornstar]

K, but it would be really cool to have it all in one, with options to turn certain things on/off

[Abe1]

K, but it would be really cool to have it all in one, with options to turn certain things on/off
You do.

[Hornstar]

You do.

was referring to the extra features I mentioned above :) would be cool to have those built in :)

[Zi55]

hello ,
if you can add a small feature for it make it limited by IP not by the username , because he can have other username directly and contine downloading , also if you can add speed limit feature it's will be too much nice ,
I really like you hack .
Thanks ,
Zi5

[Red Spider]

thank you SOOOO much :D

[canntoon]

Thanks...nice mod ...

But now I'm have a simple problem...

Group "Unregistered / Not Logged In" don't have "Limit Attachment Downloads" and "Download Attachment Limit" parameters :confused:

Yeah I'm having this same issue.

[xandizitxu]

Thanks a lot! I was looking forward for it ^^

[Seiyaboy]

I know this mod is said to be for 3.6.8, but I seriously don't plan on upgrading my 3.6.7PL board at this point. If there aren't much datebase and table changes between the 2 versions, this mod should still work for 3.6.7PL right?

EDITED:
Yes, it works for 3.6.7PL. Thank you very much for this wonderful mod.

[xandizitxu]

Hey! Just want to make a board free of Limit Download is it possible?

[xandizitxu]

it bugged my vbtt :/ had to uninstall

[puertoblack2003]

where in phrase can i change the wording when they reach the certain amount of downloads, i want to add few things

-pb

[Total666]

Weird , I can install this but I can't seem to find the attachment limit setting like https://vborg.vbsupport.ru/attachment.php?attachmentid=67213&d=1184847662


this will be great when I get this working ,, Total

[puertoblack2003]

Weird , I can install this but I can't seem to find the attachment limit setting like https://vborg.vbsupport.ru/attachment.php?attachmentid=67213&d=1184847662


this will be great when I get this working ,, Total

yea i had the same problem try to unistall it and install it again that helped for me

[Total666]

Uninstalled -- then re-installed still not working .. :(

[puertoblack2003]

Uninstalled -- then re-installed still not working .. :(


you checked under usergroup? thats where you have to go to config and then go under attachment and chose which attachments you want to limit

[Total666]

you checked under usergroup? thats where you have to go to config and then go under attachment and chose which attachments you want to limit


I did not check under usergroup , thanks so much ... Working now , Total

[puertoblack2003]

I did not check under usergroup , thanks so much ... Working now , Total


lol no proms now waiting for my help...lmao

[Alibass]

Thanks...nice mod ...

But now I'm have a simple problem...

Group "Unregistered / Not Logged In" don't have "Limit Attachment Downloads" and "Download Attachment Limit" parameters :confused:

Yeah I'm having this same issue.

I am having same issues, but I am guessing this hack is for registered users only. Seems a little ridiculous to try and put a time limit on a guest when you have so many of them visiting your board and no way of controlling who has or has not downloaded a file from your board. :(
Might be a nice feature if this hack had a way to record IPs from guest and maybe allow limited downloads by their address.

[asforum]

I installed it, but it showing me only one option like the time beetween two attechment.

what abt attechment size and everything , can i control that too or only time.

[Abe1]

I installed it, but it showing me only one option like the time beetween two attechment.

what abt attechment size and everything , can i control that too or only time.
Did you upload the file to your ftp?

[class101]

would be nice Abe1 to integrate in to the Project Tools, I'm looking yet to integrate it to my project tools downloads cos it is working fine on the forum but I'm sure thats a small update for project tools, any idea dude?

[ocktra]

Thanks so much. /installed

[DrHUS]

Hello Abe1
is your add-one can limit / denied using of download accelerator like program? (the programs using multi-part downloading .. that open 5-10 connection to download the same file? ..)
or is there some hack can do this ?? (limit the connection during the download of file with ONE just ..)

[Sandy-XXX]

Hi,

Im looking for a hack to let me show the thumbnails to the unregistered users, but dont let they download the attachment (or limit the download) if they dont register and log in.

This hack can help me with that?

Thanks...

[puertoblack2003]

hey abe1,

i ran into a problem and received a much of pm's from my members

well basically members that never downloaded any attachments received a message that they will have to wait x amount of time and a members forwarded the message and found that the dates if off wacked.

sample message:

You have reached your download limit. You will be able to download again on 01-01-1970 at 01:00 PM. Or to avoid this error MESSAGE, and continue to download more program. You can subscribe as a premium member. Ask an admin for details.

that extra message i added,is there a fix for that issue

[Abe1]

Hello Abe1
is your add-one can limit / denied using of download accelerator like program? (the programs using multi-part downloading .. that open 5-10 connection to download the same file? ..)
or is there some hack can do this ?? (limit the connection during the download of file with ONE just ..)
It counts how many attachments a user has download.
hey abe1,

i ran into a problem and received a much of pm's from my members

well basically members that never downloaded any attachments received a message that they will have to wait x amount of time and a members forwarded the message and found that the dates if off wacked.

sample message:



that extra message i added,is there a fix for that issue
I would need to look into this user along with acp access to figure it out.

[rin]

I probably did something wrong here. Anyway, I would like to ask you.
I uploaded and imported your hack. I went to vBulletin Options "Limit Attachment Downloads" and turned that on. I changed "Download Limit Time Frame" to 30 Minutes (I think this means the user needs to wait 30 minutes until he can download again, right?)
So I went to Attachment Manager and changed the values for ZIP files, cause I only want to test it with ZIP's for now. I changed "Limit Downloads with this Attachment Type" to Yes.
Then I went to the Usergroup Manager and edited the Administrator Attachment privileges.
But no matter how often I change the value to YES, when I reload the privileges page, it changed back to No.... :-/

[rin]

Ok, I reinstalled it and its actually changed to Yes now. But anyway, I can still download as many times I want.
"Download Attachment Limit" is set to 2. So in my understanding, this should let me get 2 downloads in 30 minutes.

[rin]

It seems to be working now.
Not sure though. Is it possible to download the same file X time even with the limitation in place? Or is this because it's cached in the browser?

[Zi55]

Any updates on hack?

[ocktra]

It seems to be working now.
Not sure though. Is it possible to download the same file X time even with the limitation in place? Or is this because it's cached in the browser?

How did you fix the problem you had before? It seems to be allowing me to download endlessly.

[Abe1]

Any updates on hack?
To do what?

[ReQueM]

thanks for this great hack :)

[leroub]

fantastic hack.... thx abe1.... *installed* :D

[Zi55]

Abe1
We wanna you to add new feature for this hack like , speed limit , member change protect , and anything new , because it's really cool hack .
Thanks

[class101]

uninstalled me because it does not limit project tools attachements and blog attachement, no need of an addon doing half of its job...

[rin]

How did you fix the problem you had before? It seems to be allowing me to download endlessly.
I was logged in as administrator. It seems like admins can download as much as they want.
Try creating a regular user and see if you can still download as you please.

[linnov]

OK I tried a bunch of things and I still get this problem

i turn the hack off

empty the attachment_limit table

turn it on

when a user tries to download they get this message

You have reached your download limit. You will be able to download again on 01-01-1970 at 07:00 PM.

any ideas

using 3.6.8 pl2
PHP Version 5.2.5-pl0-gentoo
apache 2

[katan]

thanks you!!!

[Zi55]

Abe1
We hope to see in your hack MaxConnections feature to attachments

[saotome]

very good click installed and nominated for this months :D thanks

[M.Kay]

OK I tried a bunch of things and I still get this problem

i turn the hack off

empty the attachment_limit table

turn it on

when a user tries to download they get this message

You have reached your download limit. You will be able to download again on 01-01-1970 at 07:00 PM.

any ideas

using 3.6.8 pl2
PHP Version 5.2.5-pl0-gentoo
apache 2


same here :erm:
did you fix this problem ?

[linnov]

nope i just un installed it

[minky1]

I love this hack, but how can I edit the text that a user see's when they hit the limit ?

[Abe1]

I love this hack, but how can I edit the text that a user see's when they hit the limit ?
Edit the phrase.

[Cyborg86]

Anyone tried if this mod works with 3.7 ?

Thanks,

[minky1]

Edit the phrase.

Sorry for being thick, but where ?
I can edit it before installing it and it works, but can it be edited/changed after installing ?

[yahoooh]

does it work with 3.7.2?

[minky1]

Sorry for being thick, but where ?
I can edit it before installing it and it works, but can it be edited/changed after installing ?

Any answer to this ?

Thanks.

[minky1]

I found the answer myself.

[Seiyaboy]

Sorry for being thick, but where ?
I can edit it before installing it and it works, but can it be edited/changed after installing ?

Yes you can. But you'll need to customize it though the phrase manager. It's so much easier to just edit the xml and reinstall it.

[minky1]

This was working very well until I installed the 'Guests can view thumbnails/Watermark hack (https://vborg.vbsupport.ru/showthread.php?t=141883).

Now it doesn't work, it just lets anyone download any amount instead of bringin up the message, If I disable the 'Guests can view thumbnails/Watermark' hack then it works again.

Thats a pain, I really need both to work :(

[sina1808]

work whit 3.7 :)

[haytham]

Anyone has it working on 3.7.2?

[mark370]

Has anyone had this working on 3.7.3 pl1 all we are getting is the error message below.


You have reached your download limit. You will be able to download again on xx-xx-xxxx at xx:xx PM

[JamesAB]

I love the idea of this mod and I hope we can use it on 3.8.

I'm testing this out on vB 3.8.0 beta2.

It half works for me. Or maybe it's working twice as well. :rolleyes:

My problem is that every time an attachment is clicked on, it is getting counted twice.

I checked the entries in phpMyAdmin and I see that each time an attachment is clicked, two rows are being added to my attachment_limit table.

For example, I set the attachment limit to be 5.

The first time an attachment is clicked, it adds two rows to the attachment_limit table.
The second time an attachment is clicked, it adds another two rows to the attachment_limit table.
The third time an attachment is clicked, it adds a row (the fifth row) and then puts up the message: You have reached your download limit. You will be able to download again on 11-14-2008 at 11:53 PM.

Abe1 or anyone else notice this behavior while testing in 3.8 ? Or can suggest how to correct the double entries for each attachment download?

Thanks,
James

[JamesAB]

Now this is odd...

I did some more testing with another file type.

My first test was with .ZIP files and each .ZIP file download was being counted twice.

My last test was with .JPG files and each .JPG was only being counted once, as expected.

Does anyone know why the counter would add two entries for .ZIP files, but only one for .JPG files? :confused:

Thanks,
James

[Abe1]

Now this is odd...

I did some more testing with another file type.

My first test was with .ZIP files and each .ZIP file download was being counted twice.

My last test was with .JPG files and each .JPG was only being counted once, as expected.

Does anyone know why the counter would add two entries for .ZIP files, but only one for .JPG files? :confused:

Thanks,
James
I would hav to check your site out. Really wierd. Works fine in my tests.

[JamesAB]

I would hav to check your site out. Really wierd. Works fine in my tests.

I think it's some sort of bug with 3.8.0 beta2 where the attachment_display hook is called twice for files where the browser is forcing the user to download the file.

I reported the bug here (http://www.vbulletin.com/forum/project.php?issueid=26828).

I did some more tests and actually believe that the entire attachment.php script may be being called twice for some reason. :confused:

I haven't had a chance to go back and check this on my 3.7 test forum yet. For now I think I'll wait and see what happens with the bug report over at vbulletin.com

Thanks,
James

[dmknights]

Will try this later

[Karabaja]

Is there any similar mod for 3.8.x, tried searching but couldn't find.
Hope this one gets updated at least. It is very useful but I've tried it and it gives wrong date like year 1970 or 2070 and some members reported that they didn't download anything close to the limit and they were still restricted from downloading.

[Karabaja]

Actually uninstalled it and installed again, it seems to work fine now. I ran build bitfields afterward just to see if that helps, don't know if it did or not, but glad it is working fine now.

[Karabaja]

Ok, found where the bug is.
If the member has additional usergroup assigned. He is given the restriction on first download attempt and year is 1970.

Any idea for a fix please?

[z0diac]

If this mod ever works for unregistered users please let me know!

My forum is set up as a photo galleries forum with 100,000+ photos. I'd love to be able to limit guests to say 20 attachment views per day. 'Good incentive to register, without scaring them off completely.

[zevkopat]

very nice

[adamskis_sidefx]

downloaded, installed, works perfectly!

[asabiyim]

plugin work on 3.8x ?

[irantk]

not worked on 4.0.3
plz updated this hack

[irantk]

pleas upgrade this hack

[Abe1]

New version posted here: https://vborg.vbsupport.ru/showthread.php?t=241727

[asabiyim]

need limit for unregistered users on this hack.. !!

[1F42]

What does the reset do? As nothing seems to happen I thought it would reset the usergroups, but it didnt.




need limit for unregistered users on this hack.. !!

Why don't you deny them the ability unless there regged?

[LinksFreak]

nice hack