='".to_time($start)."' and newstime<='".to_time($end)."')";
$query.=$timeadd;
$query1.=$timeadd;
$onclickquery.=$timeadd;
$and=' and ';
}
//用户
if($userid)
{
$useradd=$and."userid='$userid'";
$query.=$useradd;
$query1.=$useradd;
$onclickquery.=$useradd;
$and=' and ';
}
//数据表
$htb=0;
$tbsql=$empire->query("select tbname,tname from {$dbtbpre}enewstable order by tid");
while($tbr=$empire->fetch($tbsql))
{
$select="";
if($tbr[tbname]==$tbname)
{
$htb=1;
$select=" selected";
}
$tbstr.="";
}
if($totaltype==1&&$htb==0)
{
printerror('ErrorUrl','');
}
if($classid||$tbname)
{
//审核
$checknum=$empire->gettotal($query1);
//未审核
$nochecknum=$empire->gettotal($query);
//总信息数
$allnum=$checknum+$nochecknum;
//点击率
$onclick=$empire->gettotal($onclickquery);
}
//栏目
$fcfile="../data/fc/ListEnews.php";
$class="";
if(!file_exists($fcfile))
{$class=ShowClass_AddClass("",$classid,0,"|-",0,0);}
//用户
$usersql=$empire->query("select userid,username from {$dbtbpre}enewsuser order by userid");
while($userr=$empire->fetch($usersql))
{
if($userr[userid]==$userid)
{$select=" selected";}
else
{$select="";}
$user.="";
}
db_close();
$empire=null;
?>
统计数据