[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 ?