Go to ACP / Forums & Moderators / Forum Blocks Manager and click on Add New Block, and in the next screen choose
Custom HTML/PHP then click Continue.
Set it up like The screenshot below.
In the field
Content add this code:
PHP Code:
$astats = $this->registry->db->query_first("
SELECT COUNT(*) AS count, SUM(filesize) AS totalsize, SUM(counter) AS downloads
FROM " . TABLE_PREFIX . "attachment AS a
INNER JOIN " . TABLE_PREFIX . "filedata AS fd ON (a.filedataid = fd.filedataid);
");
$fstats = $this->registry->db->query_first("
SELECT COUNT(*) AS count, SUM(filesize) AS totalsize
FROM " . TABLE_PREFIX . "filedata AS fd
");
if ($astats['count'])
{
$astats['average'] = vb_number_format(($astats['totalsize'] / $astats['count']), 1, true);
}
else
{
$astats['average'] = '0.00';
}
$stats='
<table width="100%" align="center"> <tr> <td class="" align="left"> <div class="smallfont"> <b>Unique / Total Attachments: </b> '.vb_number_format($astats['count']) . ' / ' . vb_number_format($fstats['count']).'<br /><br /> <b>Total Downloads: </b>'. vb_number_format($astats['downloads']).' </td> </tr> </table>';
//SideBar = End forum Status
//echo $stats;
return $stats;