Who Downloaded This Attachment?

This hack is pretty straightforward: it tracks the attachments your members download, and therefore allows people to view which people have downloaded which attachment. This may be expanded later into a more comprehensive, expanded "download center," but for now, it's just a small hack.

Screenshot?
Surely. Attached to the next post.

Online Demo?
Here ya' go.

This is a vBHacker hack, too. I highly encourage you to install vBHacker. I'll include a vBHacker-generated installation text file in the attached archive, though, so no one will be left out. Enjoy. Let me know if you run into any problems.

[Bison]

Today at 04:50 PM Boofo said this in Post #99
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.

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!

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

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.

[Bison]

^ ^

[laycomp]

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?

[Bison]

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!

[Boofo]

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

[laycomp]

Yesterday at 06:40 PM Rolodex said this in Post #104
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!

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.

[TeEq]

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

[JeffyJoe]

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)

04-07-03 at 12:18 PM TeEq said this in Post #107
What im doing this ??
ALTER TABLE user ADD COLUMN downloads TEXT NOT NUL

[dstruct2k]

Ohhh, I like the hack, but this is great to see when I try to open an attachment....

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT downloads FROM user WHERE userid = 1
mysql error:

mysql error number: 0

Date: Tuesday 15th of April 2003 11:14:18 PM
Script: http://myhost/forums/forums/attachme...s=&postid=1247
Referer: http://myhost/forums/showthread.php?s=&postid=1247

I also get an error trying to open the "Who Downloaded" box.

Invalid SQL: SELECT u.userid, u.username FROM user u WHERE u.downloads LIKE "37%" OR u.downloads LIKE "%37%" OR u.downloads LIKE "%37" ORDER BY u.username ASC
mysql error:

mysql error number: 0

Date: Tuesday 15th of April 2003 11:15:36 PM
Script: http://myhost/forums/forums/whodownl...ttachmentid=37
Referer:

Something tells me I have to modify both my tables and my queries... Damn these older hacks! :laugh:

[dstruct2k]

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

My bad, problem solved.