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

[snyx]

I dumped the whole attachment thing, and worked in the top 5 posters (a sinch) Plus I revamped the template, so everything is all linned up. (btw there wasnt 6 showing, it was just me being a idiot) If anyone wants my template (works for attachments) or my top 5 posters (simple, SIMPLE, index.php edit) PM me.

[snyx]

Here is my example, of my template editing, and top 5 posters.

[Neo]

hey, in your statistics you have top 5 posters how did you get that there? and do you know how to put up a top 5 newest threads? that would really help...

and i cant really see anything anything wrong with the attach files hmm...

[snyx]

Originally posted by snyx
btw there wasnt 6 showing, it was just me being a idiot

no problem. just me being a goof.
so you want top 5 new THREADS, not replyed threads?
yeah I can probolly work that!
the top five posters was easy, you want it?

[Neo]

[QUOTE]Originally posted by snyx

no problem. just me being a goof.
so you want top 5 new THREADS, not replyed threads?
yeah I can probolly work that!
the top five posters was easy, you want it?

[snyx]

sorry dood, it's 4am so im really not in the mood to be editing it all now. let me look into it tomrrow for ya.

[Neo]

[QUOTE]Originally posted by snyx
sorry dood, it's 4am so im really not in the mood to be editing it all now. let me look into it tomrrow for ya.

[tweak]

snyx do you think i can have this hack please?

[Neo]

[QUOTE]Originally posted by Tweak
snyx do you think i can have this hack please?