vBulletin Mods

The Official vBulletin Modifications Site
https://www.vbulletin.org/forum/showthread.php?t=217272

Who Downloaded This Attachment
by akanevsky
27 Jun 2009 16:25

3 Attachment(s)
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 27 Jun 2009 16:25

First Post Reserved.

diamond-optic 29 Jun 2009 17:28

hmmm uploaded the xml file, installed the product.. made a new thread & attachment to test it out, but the 'attachment' section in the post looks exactly the same, doesnt have the who downloaded link like your screen shot does

akanevsky 29 Jun 2009 17:32

It has the link once there's 1 or more downloads. :)

Brandon Sheley 29 Jun 2009 17:36

thx, I added this to my site some time ago and never clicked install
so I'm now marking as installed :D

/me clicks install

diamond-optic 29 Jun 2009 17:43

Quote:

Originally Posted by Psionic Vision (Post 1839681)
It has the link once there's 1 or more downloads. :)


hmm i did download it.. just says 2 views

http://forums.avamods.com/21355-post1.html

kushal 05 Jul 2009 04:44

Yes same here...

diamond-optic 05 Jul 2009 06:57

magically the 'who downloaded' link started showing.. idk maybe it was my cache that i should have tried clearing before hand lol

yotsume 06 Jul 2009 07:35

Not working for me on 3.7x. Not sure whats wrong??? I am sure another mod must be conflicting. :(

Is there supposed to be settings in the AdminCP? If so they dont so. I was thinking its not enabled?

You must have an error in your mod?

I finally got this to work by going to user groups and enabling it again for both admins and registered users. Even though it was already enabled for admins it didnt show for me until I enabled it again.

Is this a bug?

yucklawyers 29 Sep 2009 13:13

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=1253894644
Referrer : <removed>showthread.php?t=35888
IP Address : <removed>
Username : <removed>
Classname : vB_Database
MySQL Version :

akanevsky 05 Oct 2009 20:27

Quote:

Originally Posted by yucklawyers (Post 1892266)
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=1253894644
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.


All times are GMT. The time now is 18:07.

Powered by vBulletin® Version 3.8.12
Copyright ©2000 - 2018, vBulletin Solutions Inc.
Copyright ©2001 - , vbulletin.org. All rights reserved.