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

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

i'll check it out in a minute :)

- Tyler

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

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!

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

/me clicks install

Seems like you missed the button ;)

Yes, definitely.

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]

oops :nervous:

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

- Tyler

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.

The phrase "psiwd_who_downloaded" is not created automatically :D

This is a problem with your copy of vBulletin, not with the hack.

Thanks, fixed :)

Does it show how many times a member downloaded the same attachment? Just for antileeching you know ;)

Why is this a problem of my vbulletin :ermm: , I have exactly such vbulletin as everyone other one. vB 3.5.2

I added a download to the db and downloaded it three times.

See the output (attachment).

The window is not showing the user name and a 0 instead which is definetly wrong.

Yes.

Because my hack does not go anywhere near class_core.

Can I see that on your board?

Oke, very vague
Uninstall is the best way at this moment :disappointed:

Its a problem with your vB copy. most likey a bug.

Dewd your .html installer is KICK ASS!!!! .thumbsup. [INSTALLED]

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

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.

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

Mine is 4.0.26.

Database error in vBulletin 3.5.1:

Invalid SQL:

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

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

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

This is the only warning that I gets:

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

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 :)

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 :eek:
(see second screen)

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:

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

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.

Thank you! It works ;)

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.

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

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.

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

Sorry, but I get not entirely what your meant

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

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