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

[dan35]

New attachments are fine. But with old attachments there are errors:

Database error in vBulletin 3.5.1:

Invalid SQL:

SELECT userid FROM attachmentviewslog
WHERE attachmentid = '8470'
AND userid = '72';

MySQL Error :
Error Number :
Date : Sunday, December 18th 2005 @ 01:48:14 PM
Script : http://www.domain.com/forums/attachm...1&d=1131814178
Referrer : http://www.domain.com/forums/showthread.php?t=2604

IP Address : xx.xx.xx.xx
Username : xxxx
Classname : vb_database

[akanevsky]

drl2005
That is strange. Try uninstalling the product and reinstalling it again.
You should have that table in your DB after you install the XML.

dan35
Make sure you have uninstalled the old product XML before you install the new one.

[dan35]

Thank you! It works

[Rhoads]

Originally Posted by Psionic Vision

drl2005
That is strange. Try uninstalling the product and reinstalling it again.
You should have that table in your DB after you install the XML.

3 time uninstalled and installed, but it remains the same.
Can you give me the table so that I can put it in my database without the xml file.

[Rickie3]

Originally Posted by Psionic Vision

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

hmmmm not quite what i was after,i dont want to disable thread viewing for guests,only want to disable viewing of who downloaded from guests

[akanevsky]

I'll see if I add a who downloaded usergroup permission in next version.
As for MySQL error - make you delete the whodownloaded plugin located at attachment_complete hook.

[Rickie3]

Originally Posted by Psionic Vision

I'll see if I add a who downloaded usergroup permission in next version.

thankyou look forward to it,keep up the good work :up:

[Rhoads]

Originally Posted by Psionic Vision

As for MySQL error - make you delete the whodownloaded plugin located at attachment_complete hook.

Sorry, but I get not entirely what your meant

[nuxvirg]

SQL sorgusu:

ALTER TABLE attachmentviewslog ADD count INT( 10 ) UNSIGNED NOT NULL DEFAULT '1'

MySQL çıktısı: Yardım
#1146 - Table 'gerha_forum.attachmentviewslog' doesn't exist

[akanevsky]

If you have a table prefix defined, then you need to prepend "attachmentviewslog" with that table prefix before you run the query.