function ps_GetTopDownloads($NumOfRows)
{
global $mybb, $db, $templates, $theme, $lang, $parser, $ps_align;
if (!is_object($parser))
{
require_once MYBB_ROOT.'inc/class_parser.php';
$parser = new postParser;
}
$query = $db->query("
SELECT p.subject,a.pid,a.downloads,a.filename,t.tid
FROM ".TABLE_PREFIX."attachments a
LEFT JOIN ".TABLE_PREFIX."posts p ON (p.pid = a.pid)
LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid = p.tid)
WHERE t.visible='1'
".ps_GetUnviewable("t")."
AND t.closed NOT LIKE 'moved|%'
AND a.thumbnail = ''
GROUP BY p.pid
ORDER BY a.downloads DESC
LIMIT 0,".$NumOfRows);
$query_icon = $db->query("SELECT extension,icon FROM ".TABLE_PREFIX."attachtypes");
while ($result_icon = $db->fetch_array($query_icon))
{
$mimicon[$result_icon['extension']] = $result_icon['icon'];
}
while ($top_downloads = $db->fetch_array($query))
{
$subject_long = htmlspecialchars_uni($parser->parse_badwords($top_downloads['subject']));
$pid = $top_downloads['pid'];
$tid = $top_downloads['tid'];
$subject = htmlspecialchars_uni(ps_SubjectLength($parser->parse_badwords($top_downloads['subject']), NULL, true));
$downloadnum = $top_downloads['downloads'];
$attach_icon = $mimicon[get_extension($top_downloads['filename'])];
$postlink = get_post_link($pid,$tid)."#pid".$pid;
eval("\$topdownloads_row .= \"".$templates->get("prostats_topdownloads_row")."\";");
}
eval("\$column_topdownloads = \"".$templates->get("prostats_topdownloads")."\";");
return $column_topdownloads;
}