[转帖]PHPWind 5.0.1 首页热门帖(缓存版/无缓存) 新鲜出炉 测试通过~

心砚

首页显示内容分别是:

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


第一步 在index.php查找

1. $rawnewuser=rawurlencode($newmember);

复制代码

在下面插入以下代码

2. //调用开始 seobbs.net提供
3. $cachefile="./data/bbscache/indexhotpost.php";
4. $cachetime=60;//缓存修改时间单位秒
5. if (($timestamp-@filemtime($cachefile)>=$cachetime)){
6. $listnum=10;//显示个数
7. $listlength=30;//标题长度
8. $hotmember=$newthreads=$hitthreads=$replythreads="";
9. $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");
10. while($members=$db->fetch_array($query)){
11. $hotmember.="<a href=&#39;profile.php?action=show&uid=$members[uid]&#39;>$members[username]</a> ($members[todaypost])<br />";
12. }
13. unset($members);
14. $query = $db->query("SELECT tid,author,subject,postdate FROM pw_threads order by postdate desc limit 0,$listnum");
15. while($threads=$db->fetch_array($query)){
16. $threads[postdate]=date("Y-m-j g:i",$threads[postdate]);
17. $threads[subject]=substrs($threads[subject],$listlength);
18. $newthreads.="<a href=&#39;read.php?tid=$threads[tid]&#39; title=&#39;作者:$threads[author] 时间:$threads[postdate]&#39;>$threads[subject]</a><br />";
19. }
20. unset($threads);
21. $query = $db->query("SELECT tid,author,subject,hits FROM pw_threads order by hits desc limit 0,$listnum");
22. while($threads=$db->fetch_array($query)){
23. $threads[subject]=substrs($threads[subject],$listlength);
24. $hitthreads.="<a href=&#39;read.php?tid=$threads[tid]&#39; title=&#39;作者:$threads[author] 浏览:$threads[hits]&#39;>$threads[subject]</a><br />";
25. }
26. unset($threads);
27. $query = $db->query("SELECT tid,author,subject,replies,lastpost FROM pw_threads order by lastpost desc limit 0,$listnum");
28. while($threads=$db->fetch_array($query)){
29. $threads[lastpost]=date("Y-m-j g:i",$threads[lastpost]);
30. $threads[subject]=substrs($threads[subject],$listlength);
31. $replythreads.="<a href=&#39;read.php?tid=$threads[tid]&#39; title=&#39;作者:$threads[author] 回复:$threads[lastpost]&#39;>$threads[subject]</a><br />";
32. }
33. unset($members);
34. @writeover($cachefile,"<?php\n\$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?>");
35. }else{
36. @include($cachefile);
37. }
38. //调用结束

复制代码

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

2. <a href=&#39;job.php?action=sign&#39;>标记已读</a> | 欢迎新会员
3. <a href=&#39;profile.php?action=show&username=$rawnewuser&#39; target=_blank><font color=#ff0000> $newmember</a></td></tr></table>
4. [code]
8. 在下面插入以下代码
11. [code]
12. <table width=$tablewidth border=0 cellspacing=0 cellpadding=0 align=center><tr><td>
13. <table cellspacing=1 cellpadding=5 width=100% border=0 $i_table>
14. <tr>
15. <td class=head height=25 align=center><span class=bold>今日发贴排行</span</td>
16. <td class=head height=25 align=center><span class=bold>最新发表主题</span></td>
17. <td class=head height=25 align=center><span class=bold>最新回复主题</span</td>
18. <td class=head height=25 align=center><span class=bold>浏览最多主题</span></td>
19. </tr>
20. <tr>
21. <td class=&#39;f_one&#39;>$hotmember</td>
22. <td class=&#39;f_two&#39;>$newthreads</td>
23. <td class=&#39;f_one&#39;>$replythreads</td>
24. <td class=&#39;f_two&#39;>$hitthreads</td>
25. </tr>
26. </table>
27. <tr><td>
28. </table><br>

复制代码

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

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

1. $cachefile="./data/bbscache/indexhotpost.php";
2. $cachetime=300;//缓存修改时间单位秒
3. if (($timestamp-@filemtime($cachefile)>=$cachetime)){
5. …………
6. …………
8. @writeover($cachefile,"<?php\n\$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?>");
9. }else{
10. @include($cachefile);
11. }

复制代码

原作者：樂思蜀