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.

[wooolF[RM]]

]just checked MySQL database under user table

maybe this screenshot will tell you something... it doesn't to me...

something telling me there's something wrong with this code:

+-------------------------------------------------------------------------------------------------+
| In attachment.php, replace this code:                                                           |
+-------------------------------------------------------------------------------------------------+
if ($noshutdownfunc) {
  $DB_site->query("UPDATE attachment SET counter=counter+1 WHERE attachmentid='$attachmentid'");
} else {
  $shutdownqueries[]="UPDATE LOW_PRIORITY attachment SET counter=counter+1 WHERE attachmentid='$attachmentid'";
}
+-------------------------------------------------------------------------------------------------+

+-------------------------------------------------------------------------------------------------+
| With this code:                                                                                 |
+-------------------------------------------------------------------------------------------------+
if ($noshutdownfunc) {
  $DB_site->query("UPDATE attachment SET counter=counter+1 WHERE attachmentid='$attachmentid'");
} else {
  $shutdownqueries[]="UPDATE LOW_PRIORITY attachment SET counter=counter+1 WHERE attachmentid='$attachmentid'";
}
$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'm not sure tho'...

[wooolF[RM]]

*cough*

[wooolF[RM]]

]*cough* again...

[wooolF[RM]]

]and again...

[TWTCommish]

Please stop bumping...it's getting out of hand.

[wooolF[RM]]

Aren't u the man who created this wonderfull hack?

[TWTCommish]

Indeedy.

[wooolF[RM]]

]well... I need some help if u have seen it... Can u please help me? As I said I rechecked everything (manual) twice...

[TWTCommish]

I've looked only very briefly at your problem. I have 100% positively no clue as to what is wrong. If I were going to guess, I'd say maybe we're running different versions of MySQL, or something of the sort.

[wooolF[RM]]

vBB 2.2.4 running on PHP v4.1.2 and MySQL v3.23.36.