vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Attachment Stats (https://vborg.vbsupport.ru/showthread.php?t=297133)

mikesafl 04-12-2013 10:53 PM
Attachment Stats
 
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/showthrea...t+stats&page=2


This is what i have found and tried so far but it gives me database error.
PHP Code:
//attachment count
// Total Attachments
$total_attach = $db->query_first('
SELECT count(*) AS count 
FROM ' . TABLE_PREFIX . 'attachment 
');
$newattachments = number_format($total_attach ['count']);
// ### Total Attachments ##

//Total Space Used
$total_hits2 = $db->query_first("
SELECT SUM(filesize) AS size
FROM " . TABLE_PREFIX . "attachment
");
$total_hits2_in_mb =@substr($total_hits2['size']/1048576,0,4);
//Total Space Used

//Total Downloads
$total_downloads = $db->query_first('
SELECT COUNT(*),
SUM(counter) AS download
FROM ' . TABLE_PREFIX . 'attachment
');
$total_downloads = number_format($total_downloads['download']);
//Total Downloads]]> 


All times are GMT. The time now is 05:27 AM.

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.00918 seconds
  • Memory Usage 1,717KB
  • 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
  • (1)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