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.

[Lucky]

Originally posted by TWTCommish
Hmm. Sounds like you might've accidently changed or deleted a line somewhere...

No, I took out the hack and it still is doing the same. All was good before I installed this hack. Any ideas?

TIA

[bandersen]

This is a nice hack and I have installed it using vbhacker. Worked fine except I did the attachment.php manually. I got the same errors as a few others here, but managed to sort it out by reading these posts - thanx!!
Now, I get one error I hope someone can help out with. I am on 2.2.5 and get this when clicking on the link "who downloaded this?":

----
Database error in vBulletin 2.2.5:

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
---

Now, If I view my ....whodownloaded.php in the browser it looks just fine...

Any hints are appreciated!

Edited: I think the above is due to a "parse error in line 56" in the attachment.php..... because of it I do not manage to get any downloads when clicking on the attachment link. Hence, the above sql error shows because no one downloaded yet??
How do I get rid of the parse error.... I have checked the coding in the attachment.php....

[freeshares1]

I tried to install this using vbhacker and now i am getting errors.

When i try click on who downloaded this i get the following errors

Database error in vBulletin 2.2.4:

Invalid SQL: SELECT downloads FROM user WHERE userid = 1
mysql error: Unknown column 'downloads' in 'field list'

mysql error number: 1054

Date: Sunday 21st of April 2002 12:30:18 PM
Script: http://www.gamblingforums.net/vbport...php?postid=857
Referer: http://www.gamblingforums.net/vbport...hp?threadid=56


When using vbhacker everything went ok except for the attachment.php part which i did manually.

Now i cant even download the attachment

attachment link

http://www.gamblingforums.net/vbport...hp?threadid=56

[bandersen]

Yes!... I now managed to get rid of the sql error I got when clicking on the link "who downloaded this?" (see post #52).

By running the whodownloaded_query in the whodownloaded_query.txt file!!!! ofcourse.....
(I really thought vbhacker took care of everything)
I am a novice.. so I am using Firefly's hack for running a query..not myphpAdmin.

The above should apply for more than me

Now... that parse error....

[TWTCommish]

Well, I can't know what's wrong with line 56 until I see it. Liines 50-60 should help...

[bandersen]

Thank you TWTCommish!
I have attached the attachment file here.... I am never sure if I manage to spread the lines over several lines... you know.

Thanks again.

Edit: here is the error:

Parse error: parse error in ...../forums/upload/attachment.php on line 58

[freeshares1]

I have the same JS error.. I have checked my templates and it seems to be correct....

[freeshares1]

I should have read the whole thread it works great now

Thanks

[TWTCommish]

bandersen: please remove that file. I don't think you're allowed to post entire vBulletin files on here. You can only post parts of them. I'll download it so I can take a look, but I don't think it's allowed to be up there...

[bandersen]

Sorry... I didnt know. It's gone.