Top 10 Points add-on

[mr e]

so do you have nano's top 10 installed AND erwins top 10 points hack? and is your problem still that it cuts off the 2nd digit?

[sonic3d]

i have nano's top 10 hack installed. and erwin's top 10 points code. and my problem is it gets cut off at the THIRD digit.

l8er
sonic

[mr e]

well it works fine for me, here is my top 10 code in the index.php

PHP Code:

// ############################################################################
// ################# 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.userid 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

[sonic3d]

nope the same, maybe something in the index.php is doing that.

l8er
sonic

[mr e]

try uploading a fresh index.php with this code, see if that helps

[sonic3d]

nope didn't work.

l8er
sonic

[lifesourcerec]

Mine still does it after the first number. It may be conflicting with another hack or something.

[Erwin]

3rd digit and 1st digit? Makes no sense to me. There must be something else in index.php or another hack that is conflicting. Try moving the Top 10 code around - move it to the top of index.php - see if that helps.

[sonic3d]

well mines it in the phpinclude template. i think it conflicting with another hack. oh well. i dont feel like going through all of them.
thanx for helping me out Erwin and Mr. E

l8er
sonic

[Erwin]

Don't put it in the phpinclude template - it will add a query on EVERY page of vB for no reason.