vb.org Archive
Page 1 of 3 1 23
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Show Thread Enhancements - Upload/Download Stats in Postbit (https://vborg.vbsupport.ru/showthread.php?t=74335)

tnguy3n 01-13-2005 10:00 PM
Upload/Download Stats in Postbit
 
Upload/Download & Total Upload/Download stats

Requested here

Modded by tnguy3n (Thinh Nguyen)
Live Demo: http://www.all4actions.net

Description: This mod display total filesize and number of upload/download in postbit.
I've tested it in vb3.0.1, 3.0.3 and 3.0.5.

New queries: 1
File Mod: 3
Template mod: 3
Installation Time: 4-5 mins

Note: make sure to run the query in phpMyAdmin or it will get an error. :rolleyes:

Please click "INSTALL" if you use the hack. :nervous:

lasto 01-14-2005 01:26 AM
clicked install m8 - all seems fine except for me it wont reg if someone downloads

the stats only update when they upload.Downloads stay at Zero regardless

will see if anyone else has same problems

tnguy3n 01-14-2005 02:00 AM
Quote:
Originally Posted by lasto
clicked install m8 - all seems fine except for me it wont reg if someone downloads

the stats only update when they upload.Downloads stay at Zero regardless

will see if anyone else has same problems
okie, got that fixed now. :)
*update one instruction*

To fix your current download stats problem, open attachment.php,
FIND:
Code:
                        // update user download stats by tnguy3n
                        $filesize = $attachmentinfo['filesize']/1024;
                        $DB_site->shutdown_query("
                                UPDATE " . TABLE_PREFIX . "user
                                SET downloadno = downloadno + 1
                                WHERE userid = $bbuserinfo[userid]
                        ");
                        $DB_site->shutdown_query("
                                UPDATE " . TABLE_PREFIX . "user
                                SET downloadtotal = downloadtotal + $filesize
                                WHERE userid = $bbuserinfo[userid]
                        ");
Then DELETE IT!

FIND:
Code:
                else
                {
                        // or doing it once an hour
                        $DB_site->shutdown_query("
                                INSERT INTO " . TABLE_PREFIX . "attachmentviews (attachmentid)
                                VALUES ($attachmentinfo[attachmentid])
                        ");
                }
BELOW IT, ADD:
Code:
                        // update user download stats by tnguy3n
                        $filesize = $attachmentinfo['filesize']/1024;
                        $DB_site->shutdown_query("
                                UPDATE " . TABLE_PREFIX . "user
                                SET downloadno = downloadno + 1
                                WHERE userid = $bbuserinfo[userid]
                        ");
                        $DB_site->shutdown_query("
                                UPDATE " . TABLE_PREFIX . "user
                                SET downloadtotal = downloadtotal + $filesize
                                WHERE userid = $bbuserinfo[userid]
                        ");
That's it! and it based on code of vb 3.0.5.

lasto 01-14-2005 02:23 AM
works perfect now m8 :)

File Download: 2 - Total Download: 6120 KB

one slight problem but this deffo may be me

if i upload a file and a preview pic - it adds 3 to the count whereas the attachemnts should add 2 only.Noticed this after i did a few uploads of small pic rars.

lasto 01-14-2005 02:36 AM
Deffo an Error on counting up the uploaded stats - here goes

ok before i upload here is my stats
File Upload: 5 - Total Upload: 737 KB
File Download: 2 - Total Download: 6120 KB

Now i just uploaded a preview pic which was 160K and a test rar which was 5.10 meg
Now check out the stats afterwards ...................

File Upload: 8 - Total Upload: 901 KB
File Download: 2 - Total Download: 6120 KB

deffo adding an extra one somewhere and not totaling up correct

tnguy3n 01-14-2005 02:44 AM
Quote:
Originally Posted by lasto
Deffo an Error on counting up the uploaded stats - here goes

ok before i upload here is my stats
File Upload: 5 - Total Upload: 737 KB
File Download: 2 - Total Download: 6120 KB

Now i just uploaded a preview pic which was 160K and a test rar which was 5.10 meg
Now check out the stats afterwards ...................

File Upload: 8 - Total Upload: 901 KB
File Download: 2 - Total Download: 6120 KB

deffo adding an extra one somewhere and not totaling up correct
you can upload a file 5.10 MB on your server? That amazed me. Usually, ppl ai'nt set uploaded filesize > 2 MB. but if your rar file is 5.10 KB, the upload stats seems working correctly. 737 KB + 160 KB + 5.1 KB ~ 902 KB

lasto 01-14-2005 03:00 AM
dont figure - as 5.10 meg is not 5.10 kb
maybe its classing them as KB when there cleary not.

the total above in your thread is 902kb which is well below 1 meg yet in the downloads stats its doing em right - 2 files which make up 6 megs

also yep can upload files to a mx of 8 megs as set the max_upload to it.

Ok look at this :

Stats before :File Upload: 8 - Total Upload: 901 KB

Now im just about to upload a rar which is 1.35 MB

File Upload: 9 - Total Upload: 902 KB

so looking at that i think ive solved the problem its only counting the first attachement which in most cases is small preview pics of maps but this time i uploaded the rar without a pic and it never counted it at all

ChrisSy 01-14-2005 09:28 AM
does this hack also back date itself? Or do the stat counter only start from when you install this hack?

lasto 01-14-2005 09:58 AM
Quote:
Originally Posted by ChrisSy
does this hack also back date itself? Or do the stat counter only start from when you install this hack?
from when counter starts - well is for me anyway :)

ChrisSy 01-14-2005 11:07 AM
Quote:
Originally Posted by lasto
from when counter starts - well is for me anyway :)
you installed and works fine?


All times are GMT. The time now is 05:44 PM.
Page 1 of 3 1 23
Show 40 post(s) from this thread on one page

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.01004 seconds
  • Memory Usage 1,747KB
  • 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
  • (3)bbcode_code_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete