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.

[WallStreat]

1. A suggestion: to store the dowload info into a new table instead of creating a new field in the user table.

2. The new whodownloaded table could contain the following info:
- attachmentid
- userid
- dateline
- ip

3. This way, we can also find out how many a particular user downloaded the same attachment, the date & time downloaded or the ip address (if needed for control purpose)

4. Moreover this can prevent bloating the $bbuserinfo variable as the download field can get quite big

[TWTCommish]

Well, I'd thought of all that already, hence this line in my original post:

This may be expanded later into a more comprehensive, expanded "download center," but for now, it's just a small hack.

I may consider expanding this down the line, but for now it's just a small addition. I'm not worried about the $bbuserinfo variable, however. Variables can hold an awful lot of text without becoming any real kind of problem. I think it'd have to be disgustingly large to cause "bloating" to the point of difficulty.

If anyone else seconds the idea to expand this hack, say so...

[WallStreat]

anyway this is a great hack, well done

[Crazy Mofo]

hi i get a 404 error

[Jadelit]

OK I have a Mutiple Attachments hack installed... when I click on the like.. I get this error...

Invalid SQL: SELECT counter FROM attachment WHERE attachmentid = undefined
mysql error: Unknown column 'undefined' in 'where clause'

mysql error number: 1054

what does this mean..

[TWTCommish]

I don't know how you got the text "undefined" there. Did you modify any of the files?

As for the 404 error: make sure you upload the whodownloaded.php file to the main forums directory!

[squawell]

nice job!!

did u ever think add the download times numbers??

[TWTCommish]

Yeah, I thought of it, but decided to just start simple. I might expand this big time later on...if I ever finish the other 3 or so hacks I'm working on. LOL.

[TECK]

great hack.
i'll use it but a little modified. i'll make it visible only for mods and admins.

[wooolF[RM]]

]Your SQL-query has been executed successfully

SQL-query :
ALTER TABLE user ADD COLUMN downloads TEXT NOT NULL


Clicking on link (I have downloaded file to be sure it have some records)

New window pop-ups ->>>

Database error in vBulletin 2.2.4:

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

mysql error number: 1054

Date: Saturday 13th of April 2002 02:42:16 AM
Script: http://blablabla/forum/whodownloaded...ttachmentid=56
Referer:

Any help please?... I rechecked twice if I edited/added everything right...