PDA

View Full Version : Attachment Stats Mod


mikesafl
04-13-2013, 01:47 AM
Vbulletin 4.2.0 L3
As im sure some of you know there is attachment stats in the admin panel, What im trying to do is create a sideblock that shows how many attachments are on the site, and how many downloads of those attachments there are. Im sure there is some sort of code to put somewhere. Can anyone help with this? Thanks in advance

Edit*
Im trying to get attachment stats from admincp
Unique / Total Attachments 83,938
Total Downloads 3,840,776

To show up like this guy did in this mod
https://vborg.vbsupport.ru/showt...t+stats&page=2
I found this but cant seem to get it to work but this is exactly what i would like
https://vborg.vbsupport.ru/showthread.php?t=110813

ozzy47
04-13-2013, 10:24 AM
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:

$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;

mikesafl
04-13-2013, 05:17 PM
Thank you very much worked perfectly, and did exactly what i wanted to do

ozzy47
04-13-2013, 11:32 PM
Not a problem. :D