内容统计
GetOne("select count(*) as dd from sea_data where TO_DAYS(from_unixtime(v_addtime)) = TO_DAYS(NOW()) AND v_recycled != 1");$n1=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_data where YEARWEEK(DATE_FORMAT(from_unixtime(v_addtime),'%Y-%m-%d')) = YEARWEEK(NOW()) AND v_recycled != 1");$n2=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_data where DATE_FORMAT(from_unixtime(v_addtime),'%Y%m') = DATE_FORMAT( CURDATE(),'%Y%m') AND v_recycled != 1");$n3=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_data where v_recycled=1");$n4=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_data where v_commend>0 AND v_recycled != 1");$n5=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_data where v_state>0 AND v_recycled != 1");$n6=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_data where v_isunion=1 AND v_recycled != 1");$n7=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_data where v_psd != '' AND v_recycled != 1");$n8=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_data where v_money !=0 AND v_recycled != 1");$n9=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_data");$n=$row['dd'];
?>
- 【视频数据】
- 今日
- 本周
- 本月
- 隐藏
- 推荐
- 连载
- 锁定
- 密码
- 消费
- 总计
GetOne("select count(*) as dd from sea_news where TO_DAYS(from_unixtime(n_addtime)) = TO_DAYS(NOW()) AND n_recycled != 1");$n1=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_news where YEARWEEK(DATE_FORMAT(from_unixtime(n_addtime),'%Y-%m-%d')) = YEARWEEK(NOW()) AND n_recycled != 1");$n2=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_news where DATE_FORMAT(from_unixtime(n_addtime),'%Y%m') = DATE_FORMAT( CURDATE(),'%Y%m') AND n_recycled != 1");$n3=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_news where n_recycled=1");$n4=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_news where n_commend>0 AND n_recycled != 1");$n5=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_news");$n=$row['dd'];
?>
GetOne("select count(*) as dd from sea_type where tptype=0");$n1=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_type where tptype=1");$n2=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_jqtype");$n3=$row['dd'];
?>
GetOne("select count(*) as dd from sea_topic where TO_DAYS(from_unixtime(addtime)) = TO_DAYS(NOW())");$n1=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_topic where YEARWEEK(DATE_FORMAT(from_unixtime(addtime),'%Y-%m-%d')) = YEARWEEK(NOW())");$n2=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_topic where DATE_FORMAT(from_unixtime(addtime),'%Y%m') = DATE_FORMAT( CURDATE(),'%Y%m')");$n3=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_topic");$n=$row['dd'];
?>
GetOne("select count(*) as dd from sea_member where TO_DAYS(from_unixtime(regtime)) = TO_DAYS(NOW())");$n1=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_member where YEARWEEK(DATE_FORMAT(from_unixtime(regtime),'%Y-%m-%d')) = YEARWEEK(NOW())");$n2=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_member where DATE_FORMAT(from_unixtime(regtime),'%Y%m') = DATE_FORMAT( CURDATE(),'%Y%m')");$n3=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_member");$n=$row['dd'];
?>
GetOne("select count(*) as dd from sea_guestbook where ischeck=0");$n1=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_guestbook where TO_DAYS(from_unixtime(dtime)) = TO_DAYS(NOW())");$n2=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_guestbook where YEARWEEK(DATE_FORMAT(from_unixtime(dtime),'%Y-%m-%d')) = YEARWEEK(NOW())");$n3=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_guestbook where DATE_FORMAT(from_unixtime(dtime),'%Y%m') = DATE_FORMAT( CURDATE(),'%Y%m')");$n4=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_guestbook");$n=$row['dd'];
?>
GetOne("select count(*) as dd from sea_erradd where ischeck=0");$n1=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_erradd where TO_DAYS(from_unixtime(sendtime)) = TO_DAYS(NOW())");$n2=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_erradd where YEARWEEK(DATE_FORMAT(from_unixtime(sendtime),'%Y-%m-%d')) = YEARWEEK(NOW())");$n3=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_erradd where DATE_FORMAT(from_unixtime(sendtime),'%Y%m') = DATE_FORMAT( CURDATE(),'%Y%m')");$n4=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_erradd");$n=$row['dd'];
?>
GetOne("select count(*) as dd from sea_comment where ischeck=0 AND m_type !=1 ");$n1=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_comment where TO_DAYS(from_unixtime(dtime)) = TO_DAYS(NOW()) AND m_type !=1 ");$n2=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_comment where YEARWEEK(DATE_FORMAT(from_unixtime(dtime),'%Y-%m-%d')) = YEARWEEK(NOW()) AND m_type !=1 ");$n3=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_comment where DATE_FORMAT(from_unixtime(dtime),'%Y%m') = DATE_FORMAT( CURDATE(),'%Y%m') AND m_type !=1");$n4=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_comment where m_type !=1 ");$n=$row['dd'];
?>
GetOne("select count(*) as dd from sea_comment where ischeck=0 AND m_type =1 ");$n1=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_comment where TO_DAYS(from_unixtime(dtime)) = TO_DAYS(NOW()) AND m_type =1 ");$n2=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_comment where YEARWEEK(DATE_FORMAT(from_unixtime(dtime),'%Y-%m-%d')) = YEARWEEK(NOW()) AND m_type =1 ");$n3=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_comment where DATE_FORMAT(from_unixtime(dtime),'%Y%m') = DATE_FORMAT( CURDATE(),'%Y%m') AND m_type =1");$n4=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_comment where m_type =1 ");$n=$row['dd'];
?>
GetOne("select count(*) as dd from sea_data where instr(v_pic,'#err')=0".($app_ftp=='0'?"":" and instr(v_pic,'$app_ftpurl')=0")." and instr(v_pic,'http')!=0");
$vnum=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_news where instr(n_pic,'#err')=0".($app_ftp=='0'?"":" and instr(n_pic,'$app_ftpurl')=0")." and instr(n_pic,'http')!=0");
$nnum=$row['dd'];
$tnum=$vnum+$nnum;
?>
GetOne("select count(*) as dd from sea_data where v_pic='' ");
$vnum=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_news where n_pic='' ");
$nnum=$row['dd'];
$tnum=$vnum+$nnum;
?>
GetOne("select count(*) as dd from sea_data where instr(v_pic,'#err') !=0");
$vnum=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_news where instr(n_pic,'#err') !=0");
$nnum=$row['dd'];
$tnum=$vnum+$nnum;
?>
GetOne("select count(*) as dd from sea_admin where groupid=1 ");
$anum=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_admin where groupid=2 ");
$bnum=$row['dd'];
$tnum=$anum+$bnum;
?>
GetOne("SELECT SUM(climit) AS dd FROM sea_cck where TO_DAYS(usetime) = TO_DAYS(NOW()) AND status=1");$n1=$row['dd'];
$row=$dsql->GetOne("SELECT SUM(climit) AS dd FROM sea_cck where YEARWEEK(DATE_FORMAT(usetime,'%Y-%m-%d')) = YEARWEEK(NOW()) AND status=1");$n2=$row['dd'];
$row=$dsql->GetOne("SELECT SUM(climit) AS dd FROM sea_cck where DATE_FORMAT(usetime,'%Y%m') = DATE_FORMAT( CURDATE(),'%Y%m') AND status=1");$n3=$row['dd'];
$row=$dsql->GetOne("SELECT SUM(climit) AS dd FROM sea_cck where status=1");$n4=$row['dd'];
$row=$dsql->GetOne("SELECT SUM(climit) AS dd FROM sea_cck where status=0");$n5=$row['dd'];
if($n1=="" OR empty($n1)){$n1=0;}
if($n2=="" OR empty($n2)){$n2=0;}
if($n3=="" OR empty($n3)){$n3=0;}
if($n4=="" OR empty($n4)){$n4=0;}
if($n5=="" OR empty($n5)){$n5=0;}
?>
GetOne("select count(*) as dd from sea_myad");$n1=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_zyk");$n2=$row['dd'];
$row=$dsql->GetOne("select count(*) as dd from sea_flink");$n3=$row['dd'];
?>