Statistics Modifications - Who Downloaded This Attachment

I no longer support my hacks. Please feel free to update them and release new versions elsewhere as long as I get the credit for the original modification.

/*=============================================*\
|| Who Downloaded This Attachment
||
|| Author : Anton Kanevsky
|| Works on : vBulletin 3.5.x - 3.8.x
|| Released : Jun 27, 2009
||
|| Time required to install: ~30 seconds
|| Difficulty: easy
\*=============================================*/

DESCRIPTION

Allows users to see detailed information about who has downloaded attachments.

STATISTICS

File Uploads: 1
Products to Install: 1


FEATURES

General:

• Displays a list of users with information about the number of downloads and last downloaded time.
• Allows to specify which usergroups can use the feature.

VERSION HISTORY

1.1.0
[F] Fixed a bug in the product xml file.

1.1.0
[+] Officially compatible with 3.5.x - 3.8.x.
[+] Removed all file and template edits.
[+] Added usergroup permission to specify which usergroups can use the feature.
[+] The last downloaded time for each user is now displayed.

1.0.2
[F] Compatibility with 3.5.2's modified attachments.php.

1.0.1
[+] Each user now has a number of downloads displayed next to him/her.

1.0.0
First Release

The installation manual is contained within the attached file.

IF YOU LIKE MY HACK, PLEASE CLICK INSTALL

[akanevsky]

First Post Reserved.

[diamond-optic]

hmmm uploaded the xml file, installed the product.. made a new thread & attachment to test it out, but the 'attachment' section in the post looks exactly the same, doesnt have the who downloaded link like your screen shot does

[akanevsky]

It has the link once there's 1 or more downloads.

[Brandon Sheley]

thx, I added this to my site some time ago and never clicked install
so I'm now marking as installed

[high]* Brandon Sheley clicks install[/high]

[diamond-optic]

Originally Posted by Psionic Vision

It has the link once there's 1 or more downloads.

hmm i did download it.. just says 2 views

http://forums.avamods.com/21355-post1.html

[kushal]

Yes same here...

[diamond-optic]

magically the 'who downloaded' link started showing.. idk maybe it was my cache that i should have tried clearing before hand lol

[yotsume]

Not working for me on 3.7x. Not sure whats wrong??? I am sure another mod must be conflicting.

Is there supposed to be settings in the AdminCP? If so they dont so. I was thinking its not enabled?

You must have an error in your mod?

I finally got this to work by going to user groups and enabling it again for both admins and registered users. Even though it was already enabled for admins it didnt show for me until I enabled it again.

Is this a bug?

[yucklawyers]

I've had this running a while now. It appears to gather the correct data and report it correctly, but every so often, I get a database error. My forum serves 1000's of downloads a day, and this 'duplicate' error repeats itself on different downloads only once every couple of days.
Anyway, here's the error.

Database error in vBulletin 3.7.5:

Invalid SQL:

INSERT INTO attachmentviewslog (attachmentid, userid, dateline)
VALUES (543935, 4925, 1254175184);

MySQL Error : Duplicate entry '543935-4925' for key 1
Error Number : 1062
Request Date : Monday, September 28th 2009 @ 10:59:44 PM
Error Date : Monday, September 28th 2009 @ 10:59:44 PM
Script : <removed>attachment.php?attachmentid=543935&d=1253 894644
Referrer : <removed>showthread.php?t=35888
IP Address : <removed>
Username : <removed>
Classname : vB_Database
MySQL Version :