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

[Chris M]

Ask the author to port it to vB 3.5 :)

Satan

[Andreas]

... or port it yourself :)
But keep in mind that you can't release it then without permission.

[Snatch]

I cant port it by my self i dount know how does its works :(

Is this so easy to do ?

[Zachariah]

... or port it yourself :)
But keep in mind that you can't release it then without permission.

Oh ya ? :cross-eyed:
Are you drinking green beers again ? :p


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

[ericgtr]

I know this is old but I happened on it doing a search for stats so thought I would reply. This has been updated for 3.5.x as a product and is located here https://vborg.vbsupport.ru/showthread.php?s=&threadid=110164