NanoEntity stats hack gone. So question.

[snyx]

Okay installed NanoEntity (i believe it was his) stats hack. NOW its gone, and I have a problem. Here is the code. (sorry if im not suppost to post it)

PHP Code:

// Top 5 Statistics BY NanoEntity
// Top 5 Attachments
$attach5 = $DB_site->query('SELECT attachmentid,counter,filename FROM attachment ORDER BY attachmentid DESC LIMIT 5');
while ($attach5top = mysql_fetch_array($attach5)):
    ++$attach5topnbsp;
    $attach5file .= "$attach5top[filename]<br>";
    $attach5hits .= "$attach5top[counter]<br>";

endwhile;
// Top 5 Attachments
// Top 5 New Members
$user = $DB_site->query('SELECT userid,posts,username,joindate FROM user ORDER BY joindate DESC LIMIT 5');
while ($usertop = mysql_fetch_array($user)):
    ++$usertopnbsp;
    $username .= "<a href=member.php?s=$session[sessionhash]&action=getinfo&userid=$usertop[userid]>$usertop[username]</a><br>";
    $userposts .= "$usertop[posts]<br>";

endwhile;
// Top 5 New Members
// Top 5 Thread Replys
$pop = $DB_site->query('SELECT title,threadid,lastpost,lastposter,views FROM thread ORDER BY lastpost DESC LIMIT 5');
while ($poptop = mysql_fetch_array($pop)):
    ++$poptopnbsp;
    $popthread .= "<a href=showthread.php?s=$session[sessionhash]&threadid=$poptop[threadid]>$poptop[title]</a><br>";
    $poplastposter .= "$poptop[lastposter]<br>";
    $popviews .= "$poptop[views]<br>";

endwhile;
// Top 5 Thread Replys
// Top 1 Most Popular Thread
$pop1 = $DB_site->query('SELECT title,threadid,views FROM thread ORDER BY views DESC LIMIT 1');
while ($pop1top = mysql_fetch_array($pop1)):
    ++$pop1topnbsp;
    $pop1title .= "<a href=showthread.php?s=$session[sessionhash]&threadid=$pop1top[threadid]>$pop1top[title]</a>";
    $pop1views .= "$pop1top[views]";

endwhile;
// Top 1 Most Popular Thread
// Top 1 Most Rated Thread
$rated = $DB_site->query('SELECT title,threadid,votenum FROM thread ORDER BY votenum DESC LIMIT 1');
while ($ratedtop = mysql_fetch_array($rated)):
    ++$ratedtopnbsp;
    $ratedtitle .= "<a href=showthread.php?s=$session[sessionhash]&threadid=$ratedtop[threadid]>$ratedtop[title]</a>";
    $ratedrating .= "$ratedtop[votenum]";

endwhile;
// Top 1 Most Rated Thread
eval("\$top5threadstats = \"".gettemplate("g_statistics")."\";");
// Top 5 Statistics BY NanoEntity 


The hack works great! But see in my attachment, it lists 6 of the last attachments, and 5 of there hits. Could someone help fix this? It sets everything outta wack, I went though the code as best I could, and couldn't find what the problem was? Why is it showing 6 attachment names, and only 5 hits?

Thanks!
snyx