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.

[Slynderdale]

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.

[firas]

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?

[Bison]

03-02-03 at 08:30 AM Slynderdale said this in Post #91
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.

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:

[Bison]

Scrap Post ... [Mods Delete this please]

[partang2]

Did you change to this?

PHP Code:

<script language="JavaScript">
  <!-- START HIDE
function whodownloaded(attachmentid) {
     window.open
("whodownloaded.php?s=$session[sessionhash]&attachmentid=" + attachmentid,
 "whodownloaded", "toolbar=no,scrollbars=yes,resizable=no,width=240,height=300, top=50, left=50"); }
  -->
</script> 


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

[Bison]

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

[Boofo]

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

[Bison]

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.

[Boofo]

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.

[Slynderdale]

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