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]

Originally Posted by 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 :

Please try to uninstall this hack and re-install it again, and see if the problem disappears (you will lose the stats). Alternately, you could try repairing / optimizing the database tables from vBulletin admincp - it could be that there is something wrong with the indexes.