listnew.php

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

<? include("conn.php");?>
<? include("include/function.php");?>
<? include("include/setup.php");?>
<? include("head.php");?>
<?
 
 $sort=$_GET['sort'];
 if($sort) $se=" and  typeid='$sort' "; 
?>
<table width="770" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td width="173" valign="top" bgcolor="#FcFcFc">
	
	  <table width="100%" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td width="173" height="22" bgcolor="#DCE8F3">&nbsp;<img src="images/biaozhi.jpg" width="14" height="14">&nbsp;&nbsp;<SPAN class=style2>最佳网摘提供者</SPAN></td>
  </tr>
  <tr>
    <td bgcolor="#FcFcFc">
	<?
   $sql="select userid,count(userid) as tt from zhai where  ispub='1' $se  group by userid  order by tt desc limit 10";
     $query=mysql_query($sql);
		while($zh=mysql_fetch_array($query)){
		 ?>
		 
      ·<a href=userzhai.php?zhaiuser=<? echo $zh[userid];?> target='_blank' ><? echo $zh[userid];?></a>(<? echo $zh[tt];?>)<br>
     <?
	 }
	 ?>
    </td>
  </tr>
  <tr>
    <td height="2"></td>
  </tr>
</table>
	
        <table width="100%"  border="0" cellspacing="0">
  <tr>
    <td height="22" bgcolor="#DCE8F3">&nbsp;<img src="images/biaozhi.jpg" width="14" height="14">&nbsp;&nbsp;<SPAN class=style2>合作站点</SPAN></td>
  </tr>
  <tr>
    <td><? 
	 
   $sql="select * from site where  id>0  $se order by incount desc limit 15";
	$qr1=mysql_query($sql);
	while($data=mysql_fetch_array($qr1)){
	;?>
	<a href='out.php?user=<? echo $data[user];?>&url<? echo $data[url];?>' target='_blank'><? echo $data[web];?></a><br>
	<?
	} ;?> </td>
  </tr>
  <tr>
    <td align="right">   <a href="sitelist.php?typeid=<? echo $sort;?>">>>>更多</a></td>
  </tr>
  <tr>
    <td height="22" bgcolor="#DCE8F3" class="style2">&nbsp;<img src="images/biaozhi.jpg" width="14" height="14">&nbsp;&nbsp;<SPAN class=style2>热门标签</SPAN></td>
  </tr>
  <tr>
    <td>
	
 
	<table width="100%" >
      <tr>
       <?
 
$ii=0; 
 
	$sql="select  tag,sum(num) as n from tags     group by tag order by n desc limit 20";
	$qr3=mysql_query($sql);
	while($tag=mysql_fetch_array($qr3)){
 
?><td>·<a href="searchzhai.php?title=<? echo $tag[tag];?>&typeid=<? echo $t[id];?>"><? echo $tag[tag];?></a></td>

<?
 
$ii=$ii+1;
if($ii%2==0 && $ii!=20){
?>
</tr><tr>
<?
 
 
}
 
?>

<?
}
?>
 
      </tr>
    </table>	</td>
  </tr>
  
  <tr>
    <td align="right">   <a href="tags.php">>>>更多</a></td>
  </tr>
</table>    </td>
    <td width="2">&nbsp;</td>
    <td colspan="3" valign="top"><table width="98%" border="0" align="center" cellpadding="3" cellspacing="0"  >
      <tr>
        <td style="border-bottom: 2px solid #EE8220">
          <table border="0" width="100%" cellspacing="0" cellpadding="0" id="table93">
            <tr>
              <td width="143"><span class="title2">最新收藏 <a href="jsfeed.asp?s=07" target="_blank"> <img src="images/icon-js.gif" alt="JS格式输出" width="26" height="14" border="0"></a> <a href="rss2feed.asp?sort=07&user=" target="_blank"> <img src="images/icon-rss.gif" alt="RSS格式输出" width="26" height="14" border="0"></a></span></td>
              <td></td>
            </tr>
        </table></td>
      </tr>
      <tr>
        <td valign="top"  >
          <?
		$rcperpage=30;  
		 $page=$_GET[page];
		if(!$page){
			$page=1;
		}
 
			$sql="select * from zhai where  ispub='1' $se  order by id desc limit ".trim(($page-1)*$rcperpage).",$rcperpage";
		$tsql="select count(*) as c from zhai where   ispub='1' $se ";
 
		 
		 $pgcount=$_GET[pacount];
		 if(!$pgcount){
		 $tqr=mysql_query($tsql);
		 $total=mysql_fetch_array($tqr);
		 
		 
		 $pgcount=floor((chop($total[0])-1)/$rcperpage)+1; 
		 }
		 
		 
     $qr=mysql_query($sql);
	 $i=0;
		while($rs=mysql_fetch_array($qr)){
		  $i=$i+1;
		  if($rs[htm]=="y"){$url="/html/".$rs[id]."/index.htm";}else{$url="zhaishow.php?id=".$rs[id]."";}
		 ;?>
          <?
				echo("·<a href='$url' target='_blank' title='".$rs[intro]."' >".sub($rs[title],50)."</a> <span class='grayscript'>(<a href='userzhai.php?zhaiuser=".$rs[userid]."'>".$rs[userid]."</a> ");
				
				
				echo("收藏)</span><font color=#444444>(".date("Y-m-d h:i:s",$rs[posttime]).")</font> <a href=".$rs[fromurl]." target='_blank'><img src='images/icon-link.gif' border='0' alt='网摘链接'></a><br>");
				
				 
				$i=$i+1;
				
				if($i%5==0){
				
				echo "<hr width=100% color=#999999 noShade SIZE=1>";
				
				}
				 
			}
		 
		
		 
				 
			 
		;?>
          <br>
      第 <? echo $page;?> 页 共 <? echo $pgcount;?> 页
      <?			
			if($page>1){
				echo(" <a href='?sort=".$sort."&title=$title&page=1&pgcount=$pgcount'>第一页</a>");
				echo(" <a href='?sort=".$sort."&title=$title&pgcount=$pgcount&page=".($page-1)."'>上一页</a>");
			}else{
				echo(" 第一页");
				echo(" 上一页");
			}
			if($page < $pgcount){
				echo(" <a href='?sort=".$sort."&title=$title&pgcount=$pgcount&page=".($page+1)."'>下一页</a>");
				echo(" <a href='?sort=".$sort."&title=$title&pgcount=$pgcount&page=".$pgcount."'>最末页</a>");
			}else{

				echo(" 下一页");
				echo(" 最末面");
			}			
			;?>        </td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td height="2" colspan="5"></td>
  </tr>
</table> 
<? include("bottom.php");?>