Upload/Download Stats in Postbit [Archive]

View Full Version : Upload/Download Stats in Postbit

tnguy3n

14 Jan 2005, 02:42

Upload/Download & Total Upload/Download stats

Requested here (http://www.vbulletin.org/forum/showthread.php?t=73124)

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

14 Jan 2005, 03:26

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

14 Jan 2005, 04:00

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:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

Then DELETE IT!

FIND:

Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

BELOW IT, ADD:

Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

That's it! and it based on code of vb 3.0.5.

lasto

14 Jan 2005, 04:23

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

14 Jan 2005, 04:36

tnguy3n

14 Jan 2005, 04:44

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

14 Jan 2005, 05:00

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

14 Jan 2005, 11:28

does this hack also back date itself? Or do the stat counter only start from when you install this hack?

lasto

14 Jan 2005, 11:58

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

14 Jan 2005, 13:07

from when counter starts - well is for me anyway :)

you installed and works fine?

lasto

14 Jan 2005, 19:07

you installed and works fine?
Well downloads works but for me im having problems still as its counting up 3 for every 2 files i upload + the KB aint matching up.

So far ive uploaded 28 small rar files but it thinks ive upped 56
Download bit seems fine by what i can tell.

kudos

14 Jan 2005, 23:04

I'm having a bit of a problem, don't know if anyone can help? I can't semm to get it to work at all as I recieve the error message below when running the first query...

"An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'myforumsname.user' doesn't exist"

Any help would be appreciated:)

Lethal

15 Jan 2005, 10:45

nice forums u have there

tnguy3n

15 Jan 2005, 21:58

sorry guys, my mysql server on localhost ain't let me upload files bigger than 600 KB (get error says localhost server has been gone for any big file :rolleyes: ) and I can't test those big uploaded files now. I'll check with my *nix server and fix that upload stats problem. :)

lasto

16 Jan 2005, 01:03

Joe Pimms

16 Feb 2005, 06:29

hey nice hack i did a little moding and i made one for the memberslist area aswell the only problem im having is the data base hope u can help here is the template code for the memberslist display.

Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

then:

Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

if u can come up with the code to work in memberlist.php that would be awsome, im useing this one here:

Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

when i use the top code i get this error:

Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

well i hope u can help plus can this hack use MB and not KB ?

tnguy3n

17 Feb 2005, 06:30

sorry, i haven't had time to fix the bug in upload stats yet. I'll look into it later this weekend, hopefully, as to release new updated version of the hack. :sleep:

for your query, use this following instead:

Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

Joe Pimms

17 Feb 2005, 06:46

sweet bro it worked with my code and your database connection worked nice

i was hoping insted of useing KB cant you use MB ?

all people need to do is edit memberlist.php and look for

Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

and put under:

Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

thats it for the hole hack

PET

22 Feb 2005, 00:06

dos this hack show Total download/uploads from the start of the counter of from the begining of the forum ?

Joe Pimms

22 Feb 2005, 00:08

yes but it is a little buggie tho

PET

22 Feb 2005, 00:14

yes what ? From the begining or from the start of the counter ? :D

Twigz

24 Mar 2005, 01:51

yes what ? From the begining or from the start of the counter ? :D

I just installed this hack and have it working great so far.. to answer your ? PET, the Counter starts after the hack is installed.. TY
*clicks install*

PixelFx

17 Apr 2005, 19:35

is there a way to get it so it shows all past downloads and uploads?

eXtremeTim

21 Apr 2005, 04:22

I might look at this one later.

DeadGaze

01 May 2005, 15:03

hmm is the upload stats already fixed
ore someone can do that

thanxs

ShaDooM

25 Jun 2005, 12:42

naaahh pls fix it :<

bigdog829

27 Jul 2005, 05:21

Is there a query we could run to update from prior to install ?