db->Record["STATUS_PH"]) && $session->db->Record["STATUS_PH"]==0 ){ //初始状态?>
| |
db->Record["STATUS_PH"]) && $session->db->Record["STATUS_PH"]==1){ //待审核状态?>
|
db->Record["STATUS_PH"]) && $session->db->Record["STATUS_PH"]==3){ //审核拒绝
$session->db->query("select * from PH_MODI_TABLE WHERE TYPE=0 AND USERID= $userid order by id desc");
$session->db->next_record();
$audit_desc = $session->db->Record["AUDIT_DESC"];
?>
|
| |
db->Record["STATUS_PH"]) && $session->db->Record["STATUS_PH"]==4){ //强制退退榜?>
|
db->Record["STATUS_PH"]) && $session->db->Record["STATUS_PH"]==2){
$cur = time() - 24*60*60 ;
$date = date("Y-m-d",$cur) ;
// $date = "2004-1-7" ;
//总排行查询
$sql = " SELECT SUM(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 GROUP BY A.ID ORDER BY PV DESC " ;
// $sql = " SELECT SUM(C.PV) 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 " ;
$session->db->query($sql);
$i = 1 ;
$pv = 0 ;
while($session->db->next_record())
{
if($session->db->Record["PV"])
{
// $rows[]["SITE"] = $session->db->Record["SITE"] ;
// $rows[]["WEB_INTRO"] = $session->db->Record["WEB_INTRO"] ;
// $rows[]["PV"] = $session->db->Record["PV"] ;
if($userid == $session->db->Record["ID"])
{
$pv = $session->db->Record["PV"];
$order = $i ;
}
$i ++ ;
}
}
if($pv == 0)
$order = 0 ;
//分类排行
$sql = " SELECT SUM(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 GROUP BY A.ID 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 " ;
$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"] ;
if($userid == $session->db->Record["ID"])
{
$cpv = $session->db->Record["PV"];
$corder = $ci + 1;
}
$ci ++ ;
}
}
if($cpv == 0)
$corder = 0 ;
$pages=ceil($ci / $pageCnt); //$pages变量现在总的页数。
if($pages>0)
{
if (!$offset) {
$offset=1;
$curline = 0;
} else
$curline = ($offset - 1) * $pageCnt;
}
else
{
$offset = 0;
$curline = 0;
}
?>
| 您的网站： |
上榜时间： |
日独立IP数：个（） |
| 您的网站属于
类， 目前排名：第
位， 在总排行榜中的排名为：第
位 |
|
|
|
|
| 排名次序 |
网站名称 |
网址简介 |
日独立IP数 |
| |
|
|
|
count($crows))
$cnt = count($crows) ;
for($i=$curline;$i<$cnt;$i++)
{
$fb = "" ;
$fb1 = "" ;
if(isset($crows[$i]["SITE"]))
{
if($site == $crows[$i]["SITE"])
{
$fb = "" ;
$fb1 = "" ;
}
echo "
| $fb".($i+1)."$fb1 |
$fb".$crows[$i]["SITE"]."$fb1 |
$fb ".$crows[$i]["WEB_INTRO"]." $fb1 |
$fb ".$crows[$i]["PV"]."$fb1 |
" ;
}
}
?>
| 共
页 第 页 |
1)
{
$newoffset=$offset - 1;
//也面跳转条件
if(($sect)!='')
print "上页 " ;
else
print "上页 " ;
} else
{
print "上页";
print " ";
}
//显示所有的页数
$t_start = 0 ;
$t_end = 20 ;
for ($i=1; $i <= $pages; $i++) {
if($offset >= 20)
{
$t_start = (int)$offset - 10 ;
$t_end = (int)$offset + 10;
}
if($i >= $t_start && $i <= $t_end)
{
if($i == $offset)
$temps = "$i";
else
{
//也面跳转条件
if(($sect)!='')
$temps = "".$i."" ;
}
print $temps;
print " ";
}
}
//检查是否是最后一页
if ($pages!=0 && $offset!=$pages) {
$newoffset=$offset+1;
if(($sect)!='')
print "下页";
else
print "下页";
} else
print "下页";
?>
|
|
 |
网站信息 (您可以随时修改排行榜上的上榜信息，提交修改申请后，我们将对您的网站信息重新审核，审核通过后将自动更新) |
 |
|
|