[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")."\"; ");