vb.org Archive - Atachement Stats

Hello,

i need this hack for VB 3.5.

Code:

// ++=========================================================================++

// || 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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01178 seconds Memory Usage 1,744KB 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_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)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
Messages: