本页主题: 今日发贴排行 最新发表主题 最新回复主题 浏览最多主题 回复最多主题 打印 | 加为IE收藏 | 复制链接 | 收藏主题 | 上一主题 | 下一主题

Yachtqi
级别: 管理员


精华: 2
发帖: 391
威望: 398 点
金钱: 3776 RMB
贡献值: 0 点
注册时间:2006-10-09
最后登录:2008-10-13

 今日发贴排行 最新发表主题 最新回复主题 浏览最多主题 回复最多主题

管理提醒:
本帖被 admin 从 PHP+Mysql+Apache 移动到本区(2008-03-31)
第一步 在index.php查找

Copy code
$rawnewuser=rawurlencode($newmember);


在下面插入以下代码

Copy code
//调用开始 seobbs.net提供
$cachefile="./data/bbscache/indexhotpost.php";
$cachetime=60;//缓存修改时间单位秒
if (($timestamp-@filemtime($cachefile)>=$cachetime)){
$listnum=10;//显示个数
$listlength=30;//标题长度
$hotmember=$newthreads=$hitthreads=$replythreads="";
$query=$db->query("SELECT m.uid,m.username,md.todaypost FROM pw_members m LEFT JOIN pw_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 pw_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 pw_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 pw_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($members);
@writeover($cachefile,"<?phpn$hotmember="$hotmember";n$newthreads="$newthreads";n$hitthreads="$hitthreads";n$replythreads="$replythreads";n$hit2threads="$hit2threads";n$hot2member="$hot2member";n$membersmoney="$membersmoney";n$membersrvrc="$membersrvrc";n$memberscredit="$memberscredit";n$membersvalue="$membersvalue";n$membersonlinetime="$membersonlinetime";n$membersdigests="$membersdigests";n?>");
}else{
@include($cachefile);
}
//调用结束


第二步 在模板目录index.htm文件中查找

Copy code
<a href='job.php?action=sign'>标记已读</a> | 欢迎新会员
<a href='profile.php?action=show&username=$rawnewuser' target=_blank><font color=#ff0000> $newmember</a></td></tr></table>


Copy code
<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=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=25 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>
</tr>
</table>
<tr><td>
</table><br>


如果想使用无缓存的话,按以下操作(会增加若干个query)

删除插入到index.php那段代码的这几行(列出来的删除,省略号代替的保留)就可以了....


Copy code
$cachefile="./data/bbscache/indexhotpost.php";
$cachetime=300;//缓存修改时间单位秒
if (($timestamp-@filemtime($cachefile)>=$cachetime)){

…………
…………

@writeover($cachefile,"<?phpn$hotmember="$hotmember";n$newthreads="$newthreads";n$hitthreads="$hitthreads";n$replythreads="$replythreads";n$hit2threads="$hit2threads";n$hot2member="$hot2member";n$membersmoney="$membersmoney";n$membersrvrc="$membersrvrc";n$memberscredit="$memberscredit";n$membersvalue="$membersvalue";n$membersonlinetime="$membersonlinetime";n$membersdigests="$membersdigests";n?>");
}else{
@include($cachefile);
}
顶端 Posted: 2007-01-31 23:00 | [楼 主]
帖子浏览记录 版块浏览记录
承德互联 » phpwind程序

Total 0.031335(s) query 5, Time now is:12-02 08:38, Gzip enabled
Powered by PHPWind v6.3.2 Certificate Code © 2003-08 PHPWind.com Corporation