query("select count(pid) as num,authorid,author from $tablepre"."posts where dateline>=$time group by authorid order by num desc limit 0,10"); while($result=$db->fetch_array($query)){ $poststar.="".$result[author]."[".$result[num]."] "; } $star_info_sql="m.uid,m.credits,m.posts,m.digestposts ,me.avatar,m.oltime,me.avatarwidth,me.avatarheight"; $query=$db->query("select count(p.pid) as num,p.author,p.authorid,$star_info_sql from {$tablepre}posts p left join {$tablepre}members m on p.authorid=m.uid left join cdb_memberfields me on p.authorid=me.uid where p.dateline>$time group by p.authorid order by num desc limit 0,3"); while($result=$db->fetch_array($query)){ if($result['avatar']) { $star.="姓名︰".$result[author]."
UID ︰".$result[authorid]."
積分︰".$result[credits]."
精華︰".$result[digestposts]." 篇
今日發帖︰".$result[num]." 篇
總發帖量︰".$result[posts]." 篇
線上時間︰".$result[oltime]."

"; }else{ $star.="姓名︰".$result[author]."
UID ︰".$result[authorid]."
積分︰".$result[credits]."
精華︰".$result[digestposts]." 篇
今日發帖︰".$result[num]." 篇
總發帖量︰".$result[posts]." 篇
線上時間︰".$result[oltime]."