Most Downloaded Attachment

[afterlab]

<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.

[EchoHype.com]

Nice little add-on there afterlab

/me enjoys it

[Velocd]

Sweet, but I already know our yatta song has been downloaded the most. j/k (never watch yatta o.O)
/me shivers

[Crazy Mofo]

Very nice m8

[DWZ]

Originally posted by Velocd
Sweet, but I already know our yatta song has been downloaded the most. j/k (never watch yatta o.O)
* DWZ shivers yatta 0wnz! :D

[afterlab]

Thanks everyone!

BTW, what the heck is a "yatta"?

[Crazy Mofo]

i dunno :cheeky:

[Corbu]

Very good hack !

Thanks !

But....I don't find this ligne : $numbersregmembers....
In index.php ????????? It's very strange....

It's on vbb 2.2.5 and I try to search on vbb 2.2.2 and it's the same...

It's not : $numbersmembers... ?????

Thank you

(sorry for my english)

[Crazy Mofo]

i didnt find it aswell so i just put it above get new posts still worked ;)

[afterlab]

Err, sorry.. I forgot $numbersregmembers was another hack. Updated instructions.

[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 ?