select count(*) FROM pw_threads WHERE postdate>1305043200-60*60*24 AND postdate<1305043200 AND fid=2
select count(*) FROM pw_posts WHERE postdate>1305043200-60*60*24 AND postdate<1305043200 AND fid=2
其中fid可以改
如果需要程序来,可以
- <?php
- require_once('global.php');
- $fid = '2';//定义版块
- $threadspost = $db->get_value("select count(*) FROM pw_threads WHERE postdate>$tdtime-60*60*24 AND postdate<$tdtime AND fid=$fid");
- $postspost = $db->get_value("select count(*) FROM pw_posts WHERE postdate>$tdtime-60*60*24 AND postdate<$tdtime AND fid=$fid");
- $countpost = $threadspost + $postspost;
- echo "昨日发主题{$threadspost},回复{$postspost},总共{$countpost}";
保存成lookypost.php放到论坛根目录下执行即可,其中$fid修改一下版块的fid