vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)
-   -   Attachment Stats Mod (https://vborg.vbsupport.ru/showthread.php?t=297139)

mikesafl 04-13-2013 01:47 AM
Attachment Stats Mod
 
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
1 Attachment(s)
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 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


All times are GMT. The time now is 05:05 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01055 seconds
  • Memory Usage 1,728KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete