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

[jluerken]

Originally Posted by drl2005

Database error in vBulletin 3.5.2:

Invalid SQL:

SELECT userid FROM attachmentviewslog
WHERE attachmentid = '21'
AND userid = '1';

MySQL Error :
Error Number :
Date : Sunday, December 18th 2005 @ 01:13:20 AM

This night I got messages from my board with the same error:

Database error in vBulletin 3.5.2:

Invalid SQL:

SELECT userid FROM vb3_attachmentviewslog
WHERE attachmentid = '817'
AND userid = '3';

MySQL Error :
Error Number :
Date : Sunday, December 18th 2005 @ 01:17:00 AM
Script : http://www.xyz.com/forum/attachment....7&d=1134864414
Referrer : http://www.xyz.com/forum/showthread.php?t=9726

There is definetly something wrong with this hack at the moment.

[Rhoads]

Originally Posted by jluerken

This night I got messages from my board with the same error:

There is definetly something wrong with this hack at the moment.

I think it also.
I have install vbulletin this week, and have no charge of other plugins.
Perhaps it is a MySQL Version problem ?
I have MySQL Version 3.23.58 stable.

[jluerken]

Originally Posted by drl2005

I think it also.
I have install vbulletin this week, and have no charge of other plugins.
Perhaps it is a MySQL Version problem ?
I have MySQL Version 3.23.58 stable.

Mine is 4.0.18 and I don't think that this is the problem

[dan35]

Mine is 4.0.26.

Database error in vBulletin 3.5.1:

Invalid SQL:

SELECT userid FROM attachmentviewslog
WHERE attachmentid = '8503'
AND userid = '1';

[akanevsky]

What is the reason for this SQL to be invalid? Does it tell you why it's invalid?

this is great,but one thing,is there anyway of only allowing admins/mods to view who downloaded,as everyone can view even guests
*installed* anyway very handy,installed on 3.5.0 no probs

If you disable "thread view" permissions for guests, then they won't be able to look. Otherwise, they will.

[Rhoads]

Originally Posted by Psionic Vision

What is the reason for this SQL to be invalid? Does it tell you why it's invalid?

This is the only warning that I gets:

Warning: mysql_query(): 7 is not a valid MySQL-Link resource in /includes/class_core.php on line 395

Warning: mysql_error(): 7 is not a valid MySQL-Link resource in /includes/class_core.php on line 837

Warning: mysql_errno(): 7 is not a valid MySQL-Link resource in /includes/class_core.php on line 855

I have vBulletin Version 3.5.2 and my class_core.php are orgineel

[akanevsky]

Do you have that problem with the product XML disabled?
And what type of attachment are you trying to download when this happens?

EDIT: Fixed. In 3.5.2, attachment.php was modified and I had to move the code to a different hook. Now it's working properly in 3.5.2

[Rhoads]

Installed again, but there happened nothing if I download my zip file.
Also it do not counted the views.
(see first screen)

When I turn off the plugin, then I see the Who Downloaded? text, but I get also a page with the Generic Smilies code's
(see second screen)

[akanevsky]

Try UNINSTALLING the hack, and the installing it again.
Or, when you install, make sure to check "ALLOW OVERWRITE".

There is NO way for it to NOT work, because I just installed it on a new vbulletin 3.5.2 board, and it works perfectly.

[Rhoads]

Originally Posted by Psionic Vision

Try UNINSTALLING the hack, and the installing it again.
Or, when you install, make sure to check "ALLOW OVERWRITE".

There is NO way for it to NOT work, because I just installed it on a new vbulletin 3.5.2 board, and it works perfectly.

Oke on my clean testboard i get now this error in the Who Downloaded popup when i push on the Who Downloaded link:

Database error in vBulletin 3.5.2:

Invalid SQL:

		SELECT attachmentviewslog.userid, attachmentviewslog.count, user.username
		FROM attachmentviewslog AS attachmentviewslog
		LEFT JOIN user AS user USING(userid)
		WHERE attachmentviewslog.attachmentid = 21
		ORDER BY username;

MySQL Error  : Table 'vbtest.attachmentviewslog' doesn't exist
Error Number : 1146
Date         : Sunday, December 18th 2005 @ 08:39:41 PM
Script       : http://www.mydomein.com/forum/misc.php?do=whodownloaded&attachmentid=21
Referrer     : 
IP Address   : xx.xxx.xx.xxx
Username     : xxxxxxxxx
Classname    : vb_database