Attachment Stats Mod

[mikesafl]

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]

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; 


[mikesafl]

Thank you very much worked perfectly, and did exactly what i wanted to do

[ozzy47]

Not a problem.