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.

[TWTCommish]

Okay, on lines 53-57, you have this:

PHP Code:

$dl    = $DB_site->query_first("SELECT downloads FROM user WHERE userid = $bbuserinfo[userid]");
$comma = ($dl[downloads]) ? ',' : '';
$DB_site->query("UPDATE user SET downloads = '$dl[downloads]$comma$attachmentid' WHERE userid = $bbuserinfo[userid]");
$comma = ($dl[downloads]) ? ',' : '';
$DB_site->query("UPDATE user SET downloads = '$dl[downloads]$comma$attachmentid' WHERE userid = $bbuserinfo[userid]"); 


REPLACE that with this:

PHP Code:

$dl    = $DB_site->query_first("SELECT downloads FROM user WHERE userid = $bbuserinfo[userid]");
$comma = ($dl[downloads]) ? ',' : '';
$DB_site->query("UPDATE user SET downloads = '$dl[downloads]$comma$attachmentid' WHERE userid = $bbuserinfo[userid]"); 


I think that should work. Worth a try.

[bandersen]

I tried... sorry.. didnt do it. Maybe there are more errors right before and after these lines? same coding there....

[TWTCommish]

Right after the code I just gave you, take this part OUT:

PHP Code:

} else {
  $shutdownqueries[]="UPDATE LOW_PRIORITY attachment SET counter=counter+1 WHERE attachmentid='$attachmentid'";
} 


Looks like you duplicated a few lines of code originally.

[bandersen]

I've tried that.... Yahooooo... it works!!!
thanks a lot

Just one more thing..... :laugh: (just happy I got to see an image!).. it's not counting. If I click on the attachment; I can see it and my name shows up in the box... but the line below the link still shows 0 downloads. Admin not included in the counts... or something?

here's my test page/post if you care to take a look:
link

Thanks again!

[bandersen]

For some reason it works now! 1 download, but box says 2. It's ok. Wonderful.

[bandersen]

What if a guest downloads?

How do you prevent guests from downloading... or identify that "guests" downloaded....
(when I download without being logged in... it counts, but no new names/guest).

I was planning to have downloadable demos located in its own forum, then use this script to see who downloaded.

[Jadelit]

is there any way to make only admins and mods view this?

[machiavelli33]

When I run the query I get the following error messages:

Error

SQL-query :

ALTER TABLE user ADD COLUMN downloads TEXT NOT NULL

MySQL said:


Duplicate column name 'downloads'

Its saying i have duplicate column names. I dont really know how to check for this in mysql so I appreciate if anyone can help me out on this.

Does deleting the existing "downloads" column affect my forum in any way?

[TWTCommish]

As I told you in a PM, if you're getting that error, then the query has already been run and you can skip to the next step.

[machiavelli33]

thanks for the reply. But now when I click on any attachments in my forum, I cant download them. I'm getting a

Parse error: parse error in /home/sites/site22/web/forums/attachment.php on line 55

Also I'm getting a runtime error whenever I move anywhere in my forum.