首页热门帖子For.5.x 4.x 3.x

$rawnewuser=rawurlencode($newmember);

$listnum=10;//个数
$listlength=30;//长度
$timelv="";
$query = $db->query("SELECT m.uid,m.username,md.onlinetime FROM krdo_members m LEFT JOIN krdo_memberdata md USING(uid) WHERE md.onlinetime order by md.onlinetime desc limit 0,$listnum");
while($members=$db->fetch_array($query)){
$members[onlinetime]=(int)($members[onlinetime]/3600);
$i=0;
while((5*$i*$i+15*$i)<=$members[onlinetime])
{$i++;
$C=5*$i*$i+15*$i;
$N=$i;
}
$more= $C-$members[onlinetime];
$lv= $N;
    $timelv.="<a href='profile.php?action=show&uid=$members[uid]'>$members[username]</a> <img src='$imgpath/lv/{$lv}.gif' alt='在线等级：{$lv} 级\n在线时长：{$members[onlinetime]} 小时\n升级剩余时间：{$more} 小时'><br />";
}
unset($members);

/*首页热门帖开始
*[url]www.krdo.net[/url]
*/

$listnum=10;//显示个数
$listlength=32;//标题长度
$hotmember=$newthreads=$hitthreads=$replythreads="";
$query=$db->query("SELECT m.uid,m.username,md.todaypost FROM krdo_members m LEFT JOIN krdo_memberdata md USING(uid) WHERE md.lastpost>'$tdtime' ORDER BY md.todaypost DESC limit 0,$listnum");
while($members=$db->fetch_array($query)){
  $hotmember.="<a href='profile.php?action=show&uid=$members[uid]'>$members[username]</a> ($members[todaypost])<br />";
}
unset($members);
$query = $db->query("SELECT tid,author,subject,postdate FROM krdo_threads order by postdate desc limit 0,$listnum");
while($threads=$db->fetch_array($query)){
  $threads[postdate]=date("Y-m-j g:i",$threads[postdate]);
  $threads[subject]=substrs($threads[subject],$listlength);
  $newthreads.="<a href='read.php?tid=$threads[tid]' title='作者:$threads[author] 时间:$threads[postdate]'>$threads[subject]</a><br />";
}
unset($threads);
$query = $db->query("SELECT tid,author,subject,hits FROM krdo_threads order by hits desc limit 0,$listnum");
while($threads=$db->fetch_array($query)){
  $threads[subject]=substrs($threads[subject],$listlength);
  $hitthreads.="<a href='read.php?tid=$threads[tid]' title='作者:$threads[author] 浏览:$threads[hits]'>$threads[subject]</a><br />";
}
unset($threads);
$query = $db->query("SELECT tid,author,subject,replies,lastpost FROM krdo_threads order by lastpost desc limit 0,$listnum");
while($threads=$db->fetch_array($query)){
  $threads[lastpost]=date("Y-m-j g:i",$threads[lastpost]);
  $threads[subject]=substrs($threads[subject],$listlength);
  $replythreads.="<a href='read.php?tid=$threads[tid]' title='作者:$threads[author] 回复:$threads[lastpost]'>$threads[subject]</a><br />";
}
unset($threads);

/*热门帖结束*/

共 <b>$topics</b> 篇主题 | <b>$article</b> 篇帖子 | <b>$totalmember</b> 位会员<br>
<a href='search.php?digest=1' target=_blank>精华区</a> |
<a href='search.php?sch_time=all&orderway=lastpost&asc=desc&newatc=1' target=_blank>最新帖子</a> |
<a href='job.php?action=sign'>标记已读</a> | 欢迎新会员
<a href='profile.php?action=show&username=$rawnewuser' target=_blank><font color=#ff0000> $newmember</font></a></td></tr></table>

<table width=$tablewidth border=0 cellspacing=0 cellpadding=0 align=center><tr><td>
<table cellspacing=1 cellpadding=5 width=100% border=0 $i_table>
<tr>
<td class=head height=15 align=center><span class=bold>今日发贴排行榜</span</td>
<td class=head height=25 align=center><span class=bold>最新发表主题</span></td>
<td class=head height=25 align=center><span class=bold>最新回复主题</span</td>
<td class=head height=25 align=center><span class=bold>浏览最多主题</span></td>
<td class=head height=10 align=center><span class=bold>会员在线排行榜</span</td>
</tr>
<tr>
<td class='f_one'>$hotmember</td>
<td class='f_two'>$newthreads</td>
<td class='f_one'>$replythreads</td>
<td class='f_two'>$hitthreads</td>
<td class='f_two'>$timelv</td>
</tr>
</table>
<tr><td>
</table><br>

<!--
EOT;
}if($db_ifonlinetime){print <<<EOT
-->
在线时间:$read[ontime](小时)<br>
<!--
EOT;
}print <<<EOT
-->

<!--
EOT;
}print <<<EOT
-->
<!--
EOT;
if($db_ifonlinetime){print <<<EOT
-->
<a title=您现在的在线时间等级><FONT color=#707070>∷ 在线等级: </font> <img src='$imgpath/lv/{$read[lv]}.gif' alt='在线等级：{$read[lv]} 级\n在线时长：{$read[ontime]} 小时\n升级剩余时间：{$read[more]} 小时'><br>
<!--
EOT;
}print <<<EOT
-->

$read['ontime']=(int)($read['onlinetime']/3600);

$read['ontime']=(int)($read['onlinetime']/3600);
          $read['ontimemin']=(int)($read['onlinetime']%3600/60);
          $read['ontimesec']=(int)($read['onlinetime']%60);
          //其实这个算法很简单，给大家分析一下。
          $i=0;                 //这个是等级变量的初始值。就是公式里的N
          while((5*$i*$i+15*$i)<=$read['ontime'])       //(5*$i*$i+15*$i)是用来计算每个等级所需要的时间长度。当$read['ontime']在线值，在$i所显示的输出数字范围内的时候，$i的值就是在线等级值。
          {$i++; //来设定I变量的递增。
          $C=5*$i*$i+15*$i; //目前等级所需要的时间长度。
          $N=$i; //原来这里是$i-1，那么这样就和QQ的不一样了。是从0级开始统计的。不是出来就是1级。去掉这个就万事ok了！
          }
                $read[more]= $C-$read['ontime']; // 剩余时间
                $read[lv]= $N;//目前等级