Show Thread Enhancements - 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.

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

[lasto]

Originally Posted by ChrisSy

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]

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]

nice forums u have there

[tnguy3n]

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 ) and I can't test those big uploaded files now. I'll check with my *nix server and fix that upload stats problem.

[lasto]

Originally Posted by tnguy3n

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 ) and I can't test those big uploaded files now. I'll check with my *nix server and fix that upload stats problem.

cheers m8

[Joe Pimms]

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.

PHP Code:

Edit MEMBERLIST, look for this :

<if condition="$show['emailcol']"><td class="thead" nowrap="nowrap">$vbphrase[contact]</td></if>

and replace with :
<td class="thead">File Upload</td>
<td class="thead">Total Uploaded in (KB)</td>
<td class="thead">File Download</td>
<td class="thead">Total Download in (KB)</td>

<if condition="$show['emailcol']"><td class="thead" nowrap="nowrap">$vbphrase[contact]</td></if> 


then:

PHP Code:

Edit memberlist_resultsbit, look for this :

<td class="alt1Active" align="$stylevar[left]" id="u$userinfo[userid]">
        <a href="member.php?$session[sessionurl]u=$userinfo[userid]">$userinfo[musername]</a>
        <if condition="$show['usertitlecol']"><div class="smallfont">$userinfo[usertitle]</div></if>
    </td>


and replace with :

<td class="alt1Active" align="$stylevar[left]" id="u$userinfo[userid]">
        <a href="member.php?$session[sessionurl]u=$userinfo[userid]">$userinfo[musername]</a>
        <if condition="$show['usertitlecol']"><div class="smallfont">$userinfo[usertitle]</div></if>
    </td>
<td class="$bgclass">$numupload</td>
<td class="$bgclass">$uploadtotal</td>
<td class="$bgclass">$numdownload</td>
<td class="$bgclass">$totaltotal</td> 


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

PHP Code:

        $getuserstats = $DB_site->query("SELECT * FROM " . TABLE_PREFIX . "user WHERE userid = $post[userid]");
        while ($userstats = $DB_site->fetch_array($getuserstats)) {
            $numupload = $userstats['uploadno'];
            $uploadtotal = $userstats['uploadtotal'];
            $numdownload = $userstats['downloadno'];
            $totaltotal = $userstats['downloadtotal'];    
        } 


when i use the top code i get this error:

Database error in vBulletin 3.0.6:

Invalid SQL: SELECT * FROM user WHERE userid = 
mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

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

[tnguy3n]

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:

 $getuserstats = $DB_site->query("SELECT * FROM " . TABLE_PREFIX . "user WHERE userid = $userinfo[userid]");
        while ($userstats = $DB_site->fetch_array($getuserstats)) {
            $numupload = $userstats['uploadno'];
            $uploadtotal = $userstats['uploadtotal'];
            $numdownload = $userstats['downloadno'];
            $totaltotal = $userstats['downloadtotal'];    
        }

[Joe Pimms]

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

PHP Code:

// format posts number
$post['posts'] = vb_number_format($post['posts']); 


and put under:

PHP Code:

$getuserstats = $DB_site->query("SELECT * FROM " . TABLE_PREFIX . "user WHERE userid = $userinfo[userid]");
        while ($userstats = $DB_site->fetch_array($getuserstats)) {
            $numupload = $userstats['uploadno'];
            $uploadtotal = $userstats['uploadtotal'];
            $numdownload = $userstats['downloadno'];
            $totaltotal = $userstats['downloadtotal'];    
        } 


thats it for the hole hack

[PET]

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

[Joe Pimms]

yes but it is a little buggie tho