well it works fine for me, here is my top 10 code in the index.php
// ################################################## ##########################
// ################# STATISTICS V2 (NanoEntity)?hololith.com ##################
// ################################################## ##########################
$statusexclude = "0"; // What forums should we exclude/hide from INDEX.PHP? EXAMPLE: "1,106,78,910".
$statuslimit = "10"; // What limit should we set for INDEX.PHP?
// ################################ POSTERS ###################################
$hl_posters = $DB_site->query("SELECT userid,username,posts FROM user ORDER BY posts DESC LIMIT $statuslimit");
while ($hl_poster = $DB_site->fetch_array($hl_posters)) {
$hl_postername .= "<a href=\"member.php?s=$session[sessionhash]&action=getinfo&userid=$hl_poster[userid]\" title=\"View profile for $hl_poster[username]\">$hl_poster[username]</a><br>";
$hl_posterposts .= "$hl_poster[posts]<br>";
}
// ################################ /POSTERS ##################################
// ################################ MEMBERS ###################################
$hl_members = $DB_site->query("SELECT userid,posts,username,joindate FROM user ORDER BY joindate DESC LIMIT $statuslimit");
while ($hl_member = $DB_site->fetch_array($hl_members)) {
$hl_membername .= "<a href=\"member.php?s=$session[sessionhash]&action=getinfo&userid=$hl_member[userid]\" title=\"View profile for $hl_member[username]\">$hl_member[username]</a><br>";
$hl_memberposts .= "$hl_member[posts]<br>";
}
// ################################ /MEMBERS ##################################
// ################################ REPLIES ###################################
$hl_replies = $DB_site->query("SELECT thread.replycount,thread.threadid,thread.lastpost, thread.lastposter,thread.views,thread.title,user.u serid FROM thread LEFT JOIN user ON (user.username=thread.lastposter) WHERE forumid NOT IN($statusexclude) ORDER BY lastpost DESC LIMIT $statuslimit");
while ($hl_reply = $DB_site->fetch_array($hl_replies)) {
$hl_replytitle2=unhtmlspecialchars($hl_reply['title']);
$hl_replytitle=iif(strlen($hl_replytitle2)>22,substr($hl_replytitle2,0,17)."..".substr($hl_replytitle2,-10),$hl_replytitle2);
$hl_replythread .= "<i>[$hl_reply[replycount]]</i> <a href=\"showthread.php?s=$session[sessionhash]&threadid=$hl_reply[threadid]\" title=\"$hl_replytitle2\">$hl_replytitle</a><br>";
$hl_replyposter .= "<a href=\"member.php?s=$session[sessionhash]&action=getinfo&userid=$hl_reply[userid]\" title=\"View profile for $hl_reply[lastposter]\">$hl_reply[lastposter]</a><br>";
$hl_replyviews .= "$hl_reply[views]<br>";
}
// ################################ /REPLIES ##################################
//Top 10 Most Points - Erwin
$toppoints = $DB_site->query('
SELECT user.userid, username, field5
FROM user
LEFT JOIN userfield USING (userid)
ORDER BY field5 DESC LIMIT 10
');
while ($topb5top = mysql_fetch_array($toppoints)):
++$topb5topnbsp;
$topbname .= "<a href=member.php?s=$session[sessionhash]&action=getinfo&userid=$topb5top[userid]>$topb5top[username]</a><br>";
$topbpost .= "$topb5top[field5]<br>";
endwhile;
eval("\$hl_top10status = \"".gettemplate("hl_statistics")."\";");
// ################################################## ##########################
// ################# /STATISTICS V2 (NanoEntity)?hololith.com #################
// ################################################## ##########################
try that code out and see if it makes a difference