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

[TyleR]

hmm..so is this like a more simple version of this hack by Mr Blunt?

i'll check it out in a minute

- Tyler

[akanevsky]

Uh.. I didn't know that there was already such hack. But yeah, looks like it. less buff = better

[JohnBee]

Nice little addon!

Is it possible to have it display the no. of downloads?
I would like to see a link that says: Downloaded 12 times and when you click or hover on it the list would appear

Still... this is a good and useful idea!

[TyleR]

well, installed perfectly, and much more simple than Mr Blunts..

/me clicks install

[akanevsky]

Seems like you missed the button

[akanevsky]

Originally Posted by JohnBee

Is it possible to have it display the no. of downloads?

Yes, definitely.

[akanevsky]

Ok, updated. Now the number is displayed.
If you have installed the hack, overwrite the XML and run this query:
[sql]ALTER TABLE attachmentviewslog ADD count INT( 10 ) UNSIGNED NOT NULL DEFAULT '1'[/sql]

[TyleR]

Originally Posted by Psionic Vision

Seems like you missed the button

oops :nervous:

[high]* TyleR clicks install and re-checks that he did this time [/high]

- Tyler

[Rhoads]

First of all thanks for your hack, were here for quite some time to look up.
Unfortunately I get a error when I refresh the page where the attachment is.

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

There seems to have been a problem with the Forum database.
Please try again by clicking the Refresh button in your web browser.

An E-Mail has been dispatched to our Technical Staff, whom you can also contact if the problem persists.

We apologise for any inconvenience.

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
Script       : http://www.mydomein/forum/attachment.php?attachmentid=21&d=1134864386
Referrer     : http://www.mydomein/forum/showthread.php?t=45
IP Address   : xx.xxx.xx.xxx
Username     : Xxxxxx
Classname    : vb_database