Atachement Stats

[Snatch]

Hello,

i need this hack for VB 3.5.

// ++=========================================================================++
// || Attachment stats and display                                            ||
// || This file may be redistributed in whole or significant part.            ||
// || By Eric Thurber http://www.guitars101.com                               ||
// ++ ========================================================================++

https://vborg.vbsupport.ru/showthread.php?p=597679&posted=1#post597679


*======================================================================*/
Run this query:
*======================================================================*/

ALTER TABLE attachmentviews ADD (
timestamp INT (10) UNSIGNED NOT NULL DEFAULT '0'
)


########################
## File Modifications ##
########################

*======================================================================*/
Open /attachment.php
Find:
*======================================================================*/
			// or doing it once an hour
			$DB_site->shutdown_query("
				INSERT INTO " . TABLE_PREFIX . "attachmentviews (attachmentid)
				VALUES ($attachmentinfo[attachmentid])
			");
*======================================================================*/
Chang to:
*======================================================================*/
			// or doing it once an hour
			$DB_site->shutdown_query("
				INSERT INTO " . TABLE_PREFIX . "attachmentviews (attachmentid, timestamp)
				VALUES ($attachmentinfo[attachmentid], " . TIMENOW . ")
			");


*======================================================================*/
Open /index.php
Find:
*======================================================================*/

// ### ALL DONE! SPIT OUT THE HTML AND LET'S GET OUTA HERE... ###

*======================================================================*/
Add above:
*======================================================================*/
// ## Begin Attachments Display ##
// Total Attachments
$total_attach = $DB_site->query_first('
SELECT count(*) AS count 
FROM ' . TABLE_PREFIX . 'attachment 
');
$newattachments = number_format($total_attach ['count']);
// ### Total Attachments ##

//Total Space Used
$total_hits2 = $DB_site->query_first("
SELECT SUM(filesize) AS size
FROM " . TABLE_PREFIX . "attachment
");
$total_hits2_in_mb = number_format($total_hits2['size']/1048576, 2, ',', '.');
//Total Space Used

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

//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
// ## End Attachments Display ##



############################
## Template Modifications ##
############################

*======================================================================*/
Open FORUMHOME
Find:
*======================================================================*/

<if condition="$show['birthdays']">
<!-- today's birthdays -->

*======================================================================*/
Add above:
*======================================================================*/

<!-- Begin Total Attachments -->
<tbody>
	<tr>
		<td class="thead" colspan="2">
			<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('attachstats_stats')"><img id="collapseimg_attachstats_stats" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg__attachstats_stats].gif" alt="" border="0" /></a>
			<phrase 1="$vboptions[bbtitle]">$vbphrase[attach_stats]</phrase>
		</td>
	</tr>
</tbody>
<tbody id="collapseobj_attachstats_stats" style="$vbcollapse[collapseobj_attachstats_stats]">
	<tr>
		<td class="alt2"><img src="$stylevar[imgdir_misc]/stats.gif" alt="<phrase 1="$vboptions[bbtitle]">$vbphrase[x_statistics]</phrase>" border="0" /></td>
		<td class="alt1" width="100%">
		<div class="smallfont">

			<div>$vbphrase[server_attach_total]: $total_attach[count]<br />
			$vbphrase[space_used]: $total_hits2_in_mb mb<br />
			$vbphrase[total_downloads]: $total_downloads<br />
			$vbphrase[total_today]: $total_today


		</div>
		</td>
	</tr>
</tbody>
<!-- /End Total Attachments -->



*======================================================================*/
Add the following phrases:
*======================================================================*/

--------------------------
Phrase Type: Global
Varname: total_today
Text: Total Downloaded Today
--------------------------

--------------------------
Phrase Type: Global
Varname: space_used
Text: Space used by Attachments
--------------------------

--------------------------
Phrase Type: Global
Varname: total_downloads
Text: Total Downloads
--------------------------

--------------------------
Phrase Type: Global
Varname: server_attach_total
Text: Total files on the server
--------------------------


That's it, enjoy!

GreeTz
Snatch