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.
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:
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:
$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 ?