thats a very nice hack, but:

wont it be a problem on large boards with lots of attachments? i imagine it would have to search 3000 users's downloads column which include lots of attachments that have long been deleted...

or am i wrong in assuming this?

Thanks TWTCommish. Job done well :).

Works great on 2.2.8 Thanks!

Thanks. I'll test it (2.2.9)

Edit: Just done one try by/for myself with a txt file on a clean board. Installed manually (no Vbhacker) and it's working on 2.2.9 without any hacks. You have to fix the CR (javascript) in headinclude.

Thanks again for this hack.

Did anyone figure out what to use so admin/mods can only use this?

Thanks

^^^^^^^bump^^^^^^^^

bump

would like to make this for admins only

Any help here, others would like to have it admins/mods

I would still like it admins only

great hack

thanks

ahhh
how would we go about doing this man?

With this addon only admins/supermods/mods can view the downloads!

Instructions in the zip-file.
Enjoy! :D

This is a great idea for a hack but it lacked a few things so I decided to make my own, Intsead of storing it in the user table and seperate them with a comma and also storing the same attachment id multiple times, i create a new table called attachment_view which keep track of the number of views and the last time a user views the attachment, Ill post a screen shot below.

First of al, thanx for this gr8 hack

I've got a slight problme:
----------------------------
Database error in vBulletin 2.3.0:

Invalid SQL: SELECT u.userid, u.username FROM user u WHERE u.downloads LIKE "1%" OR u.downloads LIKE "%1%" OR u.downloads LIKE "%1" ORDER BY u.username ASC
mysql error: Unknown column 'u.downloads' in 'where clause'

mysql error number: 1054

Date: Friday 14th of March 2003 12:02:00 PM
Script: http://localhost/vb2/vb2/whodownloaded.php?s==1
Referer:
--------------------------
I noticed that it says http://localhost/vb2/vb2/whodownloaded.php
whereas my folder is:
http://localhost/vb2/whodownloaded.php

Can anyone help?

Would you like to share your version? The one here is constantly breaking and everytime I click on the "Who Downloaded this" link, nothing pops up! :cry:

Scrap Post ... [Mods Delete this please]

Did you change to this?

The function line needs to start on it's own line.

That's *exactly* how I have it ...

It won't work on past attachments. It only saves the data for attachments made after the hack was installed. ;)

Well this hack must have broke somewhere cause it been installed a long time ago. To follow up on your theory Boofo, I just created a attachment and the script doesn't open up another window!

The worse thing about it is that i'm not getting a error message at all!

I believe after installing Bira's "contract posts" hack, it broke this one ... don't quote me on this but I can't seem to find the reason other than this.

I also have another Java Scipt in the headerinclude template for the Registered Members hack, and that one works great ... I just think that the way vb is created and how each of these pages are generated there must be a connection between these *two* hacks that involve the postbit, and showthread.

I've done the liberty of moving this script to this hack into the showthread header and still doesn't work.

Try doing an onLoad= in the body tag for multiple java scripts that might be messing with one another. I found this solution after running in to a couple of them not playing nice together. Just a thought. ;)

I believe theres a javascript conflict with biras's contract posts hack. I have the same problem.

there's no "body tag" in the "headinclude" template bro ... this problem resides in the postbit betwen Bira's Hack and this hack ... I just know it.

It might be that Bira's Cotract Post Hack is using the <DIV> tag and I don't know if this is true, but that might as well be the problem since they both are working in the same location.

If someone else have these two hacks workin together ... please reply to this! :)

I bet there is ... only I need to find out how the page is put together to see if that js script (In Bira's Hack) is using the proper method of placing javaScript code within HTML ... or maybe this hack needs to be re-written.

^ ^

Greets and great hack!

I am having a problem here in that the number displayed in "This has been downloaded x time(s). is not corresponding to the "who downloaded this" users in the pop up box.

As seen by attached file, the hack indicates 19 downloads, however, the popup box indicates only 7 members downloading the file.

Any suggestions please?

Someone may have used one of those download accelerators to download the attachment. These programs use two or more connections to download files. This maybe the reason why your numbers are off ... to test my theory, install a download program (Like Download Accelerator Plus) and download an attachment! :)

Either that or maybe the same people downloaded it more than once. :)

I did try out the theory using GetRight and in my case, I downloaded a newly placed attachment and it only counted one download. Perhaps other download managers work differently but yes, a possibility since there are no external linking in my server log files.

As Boofo suggested aybe people download it twice or also another copy for backup or forget where they put it and download again, others may just download not remembering they downloaded already.

Thanks guys and sorry, should have thought of this possibility.

What im doing this ??
ALTER TABLE user ADD COLUMN downloads TEXT NOT NUL

you must do this query or the pop up window will give your an error

it updates your database with the new string commands

(I am an extreme newbie myself so my wording may be wrong, but my point should still be taken) :)

Ohhh, I like the hack, but this is great to see when I try to open an attachment....
I also get an error trying to open the "Who Downloaded" box.
Something tells me I have to modify both my tables and my queries... Damn these older hacks! :laugh:

Ohhh.... The vBHacker file doesn't run the query itself....

My bad, problem solved. :D

Hi.. could you share your work with us?
It looks great...
If you do meybe you could think about a small change [or just tell us how to made such one]...
Instead of showing number of downloads per user, make another register for each download so that we could know when a person downloaded this [ if that was few times really or just one with a DL accelerator]...

I beg you :D [probably not only me!]

Regards

ups, i have a white popup on my 2.2.8 Version.

Can everybady help me

anyone got this working on vb2.3.0?

subu: check all the thread, there are some posts about your problem.

I am currently using vb 3.0 b5 and must keep track of downloads, is this hack going to be available for vb3?

Is it that hard to port over to the new v3.0 vb version?

Thank you.

Jelsoft has sayed, the won't would see vB 3 hacks.

Maybe someone can do it for me for a fee? If ANYONE is interested, you may contact me via pm with your email, also I would like to add other important options, this to be discussed with project. Send me your quote for hack as is and then we'll discuss mods. This open to anyone and have hack ready when vb3 comes out, I will not require exclusivity so consider that too when pricing.

Thanks.

fyi, the instructions for this hack need some repair work...any reference to "whodownloadsbits" needs to be changed to "whodownloadsbit" (in the instructions and the php files) and the javascript edit for the headinclude template needs to be changed to:

(ie, move the function line to it's own line as referenced on the 2nd or 3rd page of this thread....)

nice hack tho...just what i was looking for :)

Yes, it's very cool hack, thanks man!

Is it possible to modify this Hack so you can see the dates and times when someone has downloaded a file even if they have downloaded it more than once.