Most Downloaded Attachment

<font size="3">Most Downloaded Attachment</font>
Made by afterlab on April 30, 2002 for vB 2.0.3+
=========================================

Ever wondered what attachment on your forums was being downloaded the most? Well wonder no more! This hack will display the filename of the most downloaded attachment as well as a link to the attachment directly.

Compatibility: This hack will work with vB 2.0.3 and higher. This hack will also work with Attachment Viewer (a highly recommended hack made by FireFly). If you don't want Attachment Viewer, it'll also work with it.

Install Time: 1-2 Minutes

Download: Instructions are in attachment.

[AussieSat]

Good one, Afterlab.

A question or 3 if you dont mind:
Will this show the hottest attachment if it's in a private forum - I don't wish members that don't normally have permission to be able see/download it.
Can it be made to show, say, the 5 hottest attachments?
How would I make it display the thread subject rather than the file name?

Thanks - AussieSat.

[afterlab]

Aussiesat: To make it display 5, for instance, rather than just the most popular one, use this code instead:

//Most Popular Attachment by Downloads (by afterlab)
$hotinfo=$DB_site->query_first("SELECT * FROM attachment ORDER by counter DESC LIMIT 5");
$hotinfo2=$DB_site->query_first("SELECT postid,attachmentid FROM post WHERE attachmentid=$hotinfo[attachmentid] LIMIT 5");

eval("\$hotattachment = \"".gettemplate("forumhome_hotattachment")."\"; ");

[StealthAnime]

good work afterlab, greetz from .~SP_Nico~.

[AussieSat]

Thanks Afterlab,
I had tried that (just increasing the LIMIT), but it didn't seem to work, it still only shows the first attachment. I have this running on my vBHome page (in the forum directory though) - maybe there is a problem there. Will keep trying .

[zachb]

/me installs hack.

very nice. i like it.

[LOD-squa]

man your hacks are super good nice work dude

[afterlab]

heh.. This hack is actually nothing compared to what I normally construct.

[LOD-squa]

I know I have seen your work.

[Haakon]

Nice, finally a small well written hack that can help me get started hacking this monster.

AussieSat: If you haven`t done it allready, the text file attached contains a solution to making the hack display the 5 hottest. Probably not the best solution, but a solution

[corsacrazy]

any way to only get attachments from acertain forum id ?