Helpful Information
 
 
Category: vBulletin 3.0 Beta Releases
Attachment Statistics

This modification will add a new collapsable box thingie just below your forum stats. Great if your site focuses on attachments. Most of this was by request here http://www.vbulletin.org/forum/showthread.php?t=73023

Please backup your database before installing.


Includes:
Total files on the server
Space used by Attachments
Total Downoads
Total Downloaded Today

2 Files to edit: vbroot/index.php, vbtroot/attachment.php
1 Queries: (pulled from cache)
1 Templates to edit: FORUMHOME

Update: The query for Total Downloads Today was not functioning correctly so I had to update it. If you've installed this already, go into your phpmyadmin and remove the timestamp table from attachmentviews then re-edit your attachments.php and add the updated query according to the updated readme.txt

I had this moved to beta as I am still working on the query, keep in mind that I may have to change this again. If you want to help test though, that's great.

See attached file, please click install if you find it useful :)

cheers m8 seen it to late so will install 2morow and report back.
Thanks for all your help on this as well m8

great hack

*installs*

thanks for this *install*

Simple and useful.

/me clicks install. :)

If you want to show the traffic, too.
Use this query:

//Traffic
$transfer = $DB_site->query("
SELECT SUM( counter * filesize )
FROM " . TABLE_PREFIX . "attachment
");
$transferall = @substr($transfer / 1048576, 0, 3);

The var $transferall show you all traffic (download traffic) for the attachments in the database in MB:

PcFreak

Thanks! Great addition :)

Anyway I can use that same formatting to get this query to pull the last 24 hours correctly? This is currently not working right, the timestamp is a table I added to the attachmentviews.


//Total Downloads Today
$total_today = $DB_site->query_first('
SELECT COUNT(*) AS count
FROM ' . TABLE_PREFIX . 'attachmentviews
WHERE timestamp >= "' . strtotime("-1day") . '"
');
$total_today = number_format($total_today['count']);
//Total Downloads today

The hack do not count the downloads tody. Why this ?










privacy (GDPR)