fetch1("select lasttimeinfo,lastnuminfo,lastnuminfotb,todaytimeinfo,todaytimepl,todaynuminfo,yesterdaynuminfo from {$dbtbpre}enewspublic_up limit 1"); //更新昨日信息 $todaydate=date('Y-m-d'); if(date('Y-m-d',$pur['todaytimeinfo'])<>$todaydate||date('Y-m-d',$pur['todaytimepl'])<>$todaydate) { DoUpdateYesterdayAddDataNum(); $pur=$empire->fetch1("select lasttimeinfo,lastnuminfo,lastnuminfotb,todaytimeinfo,todaytimepl,todaynuminfo,yesterdaynuminfo from {$dbtbpre}enewspublic_up limit 1"); } $sql=$empire->query("select tid,tbname,tname,isdefault from {$dbtbpre}enewstable order by tid"); //签发信息 $qfinfonum=$empire->gettotal("select count(*) as total from {$dbtbpre}enewswfinfo where checktno=0 and (groupid like '%,".$lur['groupid'].",%' or userclass like '%,".$lur['classid'].",%' or username like '%,".$lur['username'].",%')"); ?> 信息
位置:信息统计

信息统计
评论统计
其他统计
     
fetch($sql)) { $i++; $bgcolor='#FFFFFF'; if($i%2==0) { $bgcolor=''; } $thistb=$tr['tid']; $infotbname='ecms_'.$tr['tbname']; $tbinfos=eGetTableRowNum($dbtbpre.$infotbname);//已审核 $checkinfotbname='ecms_'.$tr['tbname'].'_check'; $checktbinfos=eGetTableRowNum($dbtbpre.$checkinfotbname);//未审核 $qchecktbinfos=$empire->gettotal("select count(*) as total from ".$dbtbpre.$checkinfotbname." where ismember=1");//投稿数 $alltbinfos=$tbinfos+$checktbinfos;//总数 $tname=$tr['tname']; if($tr['isdefault']) { $tname=''.$tname.''; } $exp='|'.$thistb.','; $addnumr=explode($exp,$pur['lastnuminfotb']); $addnumrt=explode('|',$addnumr[1]); $addnum=(int)$addnumrt[0]; $totaltbinfos+=$tbinfos; $totalchecktbinfos+=$checktbinfos; $totalqchecktbinfos+=$qchecktbinfos; $totalalltbinfos+=$alltbinfos; ?>
信息发布统计 (今日信息数:,昨天信息数:,待我签发的信息数:)
表名
已审核
未审核
未审核投稿
总数
截止至现在的新增数量
总计:
说明:点击“已审核”、“未审核”或“未审核投稿”数可进入相应的管理。