rank.php

PHP免费网摘程序 详细说明: 安装说明： 1、把文件上穿上去以后

<? include("conn.php");?>
<? include("include/function.php");?>
<? include("include/setup.php");?>
<? include("head.php");?>
<table width="95%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="33%" valign="top"><table width="100%"  border="0" cellspacing="3">
      <tr>
        <td colspan="3" align="center" bgcolor="#F5F5F5">贡献排行</td>
      </tr>
       <?  
       $sql="select  userid,count(id) as num from zhai group by userid order by num desc,userid limit 15";
       
       $query=mysql_query($sql);
       while($rs=mysql_fetch_array($query)){
         
           echo("<tr>");
           echo("<td><span class='grayscript'>·</span><a href='userzhai.php?zhaiuser=".$rs[userid]."'>".$rs[userid]."</a> (".$rs[num].")</td>");
           echo("<td width='10' class='js'><a href='jsfeed.php?user=".$rs[userid]."' target='_blank' title='JS格式输出'>JS</a></td>");
           echo("<td width='20' class='rss'><a href='rss2feed.php?user=".$rs[userid]."' target='_blank' title='RSS格式输出'>RSS</a></td>");
           echo("</tr>");
           
         
       }
           
       ;?> 
    </table></td>
    <td valign="top"><table width="100%"  border="0" cellspacing="3">
      <tr>
        <td colspan="3" align="center" bgcolor="#F5F5F5">标签排行</td>
      </tr>
      <?
       $sql="select  tag,sum(num) as num from tags group by tag order by num desc,tag limit 15";
       
       $query=mysql_query($sql);
       while($rs=mysql_fetch_array($query)){
        
           echo("<tr>");
           echo("<td><span class='grayscript'>·</span><a href='tagzhai.php?tag=".$rs[tag]."'>".$rs[tag]."</a> (".$rs[num].")</td>");
           echo("<td width='10' class='js'><a href='jsfeed.php?tag=".$rs[tag]."' target='_blank' title='JS格式输出'>JS</a></td>");
           echo("<td width='20' class='rss'><a href='rss2feed.php?tag=".$rs[tag]."' target='_blank' title='RSS格式输出'>RSS</a></td>");
           echo("</tr>");
           
         
       }
       
       ;?>
    </table></td>
    <td width="33%" valign="top"><table width="100%"  border="0" cellspacing="3">
      <tr>
        <td colspan="2" align="center" bgcolor="#F5F5F5">一月点击排行</td>
      </tr>
     <?
	 
	   
$qr=mysql_query("select   *  from zhai      order by  id limit 15");
	 while($rszhai=mysql_fetch_array($qr)){
			echo("<tr>");		
			echo("<td><span class='grayscript'>·</span><a href='/html/".$rszhai[id].".htm' target='_blank' title='".$rszhai[intro]."'>".sub($rszhai[title],46)."</a> <a href=".$rszhai[fromurl]." target='_blank'><img src='images/icon-link.gif' border='0' title='网摘链接'></a></td>");
			 
			echo("</tr>");			
		 }
	   ;?>	 
    </table></td>
  </tr>
  <tr>
    <td valign="top"><table width="100%"  border="0" cellspacing="3">
      <tr>
        <td align="center" bgcolor="#F5F5F5">24小时点击排行</td>
      </tr>
	   <?
$qr=mysql_query("select   *  from zhai      order by id limit 15");		 
			 while($rszhai=mysql_fetch_array($qr)){
			echo("<tr>");		
			echo("<td><span class='grayscript'>·</span><a href='/html/".$rszhai[id].".htm' target='_blank' title='".$rszhai[fromurl]."'>".sub($rszhai[title],46)."</a> <a href=".$rszhai[fromurl]." target='_blank'><img src='images/icon-link.gif' border='0' title='网摘链接'></a></td>");
			 
			echo("</tr>");			
		 }
 
	   ;?>
    </table></td>
    <td valign="top"><table width="100%"  border="0" cellspacing="3">
      <tr>
        <td align="center" bgcolor="#F5F5F5">48小时点击排行</td>
      </tr>
	   <?
$qr=mysql_query("select   *  from zhai      order by  id limit 15");
		 while($rszhai=mysql_fetch_array($qr)){
			echo("<tr>");		
			echo("<td><span class='grayscript'>·</span><a href='/html/".$rszhai[id].".htm' target='_blank' title='".$rszhai[fromurl]."'>".sub($rszhai[title],46)."</a> <a href=".$rszhai[fromurl]." target='_blank'><img src='images/icon-link.gif' border='0' title='网摘链接'></a></td>");
			 
			echo("</tr>");			
		 }
	   ;?> 
    </table></td>
    <td valign="top"><table width="100%"  border="0" cellspacing="3">
      <tr>
        <td align="center" bgcolor="#F5F5F5">一周点击排行</td>
      </tr>
	   <?
		$qr=mysql_query("select   *  from zhai      order by id limit 15");
		 while($rszhai=mysql_fetch_array($qr)){
			echo("<tr>");		
			echo("<td><span class='grayscript'>·</span><a href='/html/".$rszhai[id].".htm' target='_blank' title='".$rszhai[fromurl]."'>".sub($rszhai[title],46)."</a> <a href=".$rszhai[fromurl]." target='_blank'><img src='images/icon-link.gif' border='0' title='网摘链接'></a></td>");
			 
			echo("</tr>");			
		 }
	   ;?>	  
    </table></td>
  </tr>
</table>
<? include("bottom.php");?>