Try_Check_Session() || null == ($agent_name = $session->username ))
{
//没有登录
//$err_msg = "请以合法的身份重新登录本系统!";
}
else //登陆用户
{
$login = 1; //登陆标示
$name = $session->username; //登陆用户名字
$status_ph = $session->status_ph; //是否批准加入了排行榜
$status_ph2 = $session->status_ph2; //是否申请加入了排行榜
$cust_page = $session->cust_page; //是否定制页面
}
$cur = time() - 48*60*60 ;
$date = date("Y-m-d",$cur) ;
// $date = "2004-1-7" ;
$crows = array() ;
//总排行查询
if(!$web_class)
{
$sql = " SELECT C.IP AS PV,A.ID,A.SITE,A.WEB_INTRO,A.URL FROM SMS_AGENT_TABLE A,AGENT_IDENTIFY_TABLE B ,
AUDIT_TABLE C WHERE A.ID=B.USERID AND B.IDENTIFYSTRING=C.IDSTRING AND A.STATUS_PH=2 AND
C.PDATE = '$date' AND A.OPEN_STATE=1 AND A.STATUS_KILL=0 ORDER BY PV DESC " ;
// $sql = " SELECT SUM(C.IP) AS PV,A.ID,A.SITE,A.WEB_INTRO FROM SMS_AGENT_TABLE A,AGENT_IDENTIFY_TABLE B ,
// AUDIT_TABLE C WHERE A.ID=B.USERID AND B.IDENTIFYSTRING=C.IDSTRING AND
// C.PDATE = '$date' AND A.OPEN_STATE=1 AND A.STATUS_KILL=0 GROUP BY A.ID ORDER BY PV DESC " ;
}
else
{
//分类排行
$sql = " SELECT C.IP AS PV,A.ID,A.SITE,A.WEB_INTRO,A.URL FROM SMS_AGENT_TABLE A,AGENT_IDENTIFY_TABLE B ,
AUDIT_TABLE C WHERE A.ID=B.USERID AND B.IDENTIFYSTRING=C.IDSTRING AND A.STATUS_PH=2 AND
C.PDATE = '$date' AND A.WEB_CLASS='$web_class' AND A.OPEN_STATE=1 AND A.STATUS_KILL=0 ORDER BY PV DESC " ;
// $sql = " SELECT SUM(C.IP) AS PV,A.ID,A.SITE,A.WEB_INTRO FROM SMS_AGENT_TABLE A,AGENT_IDENTIFY_TABLE B ,
// AUDIT_TABLE C WHERE A.ID=B.USERID AND B.IDENTIFYSTRING=C.IDSTRING AND
// C.PDATE = '$date' AND A.OPEN_STATE=1 AND A.WEB_CLASS='$web_class' AND A.STATUS_KILL=0 GROUP BY A.ID ORDER BY PV DESC " ;
}
$session->db->query($sql);
$ci = 0 ;
while($session->db->next_record())
{
if($session->db->Record["PV"])
{
$crows[$ci]["SITE"] = $session->db->Record["SITE"] ;
$crows[$ci]["WEB_INTRO"] = $session->db->Record["WEB_INTRO"] ;
$crows[$ci]["PV"] = $session->db->Record["PV"] ;
$crows[$ci]["URL"] = $session->db->Record["URL"] ;
$ci ++ ;
}
}
$pages=ceil($ci / $pageCnt); //$pages变量现在总的页数
if($pages>0)
{
if (!$offset) {
$offset=1;
$curline = 0;
} else
$curline = ($offset - 1) * $pageCnt;
}
else
{
$offset = 0;
$curline = 0;
}
// 改变Head反白显示效果
$head_page = "search";
?>
搜索大同盟>>排行总榜
|
|
| 您查询的是 : 总排行榜 >> ".$name_web_class." | 上榜网站:$ci个 | ";
}
else
{
echo "| 您查询的是 :总排行榜 | 上榜网站:$ci个 | ";
}
?>
|
|