一个程序下载的管理程序(二)

//主程序download.php源代码如下:
<?session_start();?>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>穷人网软件联盟</title>
<script language="javascript">
function popwin(parm)
{    window.open("sign.php?"+parm,"","height=400,width=300,resizable=yes,scrollbars=no,status=no,toolbar=no,menubar=no,location=no");
}
</script>
<style>

BODY {
FONT-SIZE: 9pt; LINE-HEIGHT: 12pt
}
TABLE {
FONT-SIZE: 9pt; LINE-HEIGHT: 12pt
}
A:link {
COLOR: blue; TEXT-DECORATION: none
}
A:visited {
COLOR: #663300; TEXT-DECORATION: none
}
A:active {
TEXT-DECORATION: none
}
A:hover {
COLOR: #ff0000; TEXT-DECORATION: underline
}
</style>
</head>
<body>

<table width="100%" border="0" cellspacing="0" cellpadding="0" height="19">
  <tr bgcolor="#f7f7ff">  
    <td height="24" width="88%"> <font size="2">  
      <? require ("../opendata.php") ?>
      </font> <font size="2"> 你的位置:<a href="http://poorren.yeah.net">首页</a>->> <a href="download.php?action=show">软件下载</a>->>  
      <?
          switch($type)
          {
                  case 1:echo "密码破解";break;
                  case 2:echo "远程控制";break;
                 case 3:echo "端口扫描";break;
                 case 4:echo "字典工具";break;
                case 5:echo "系统安全";break;
                case 6:echo "各种炸弹";break;
                case 7:echo "加密软件";break;
                case 8:echo "源代码";break;
                case 9:echo "其它软件";break;
                default:echo "全部软件";
          }
          ?>
      </font></td>
    <td height="24" width="12%">  
      <div align="center"><font size="2"><a href="download.php?action=publish">发布软件</a></font></div>
    </td>
  </tr>
</table>


<font size="2"> </font>
<table width="100%" border="1" cellspacing="0" cellpadding="0" height="20" bordercolor="#FFFFFF">
  <tr bgcolor="#f0f0ff" bordercolor="#FFFFFF">  
    <td width="10%" height="21">  
      <div align="center"><font size="2"><a href="download.php?action=show&page=0&type=0&sort=<?=$sort?>&isdesc=<?=$isdesc?>">全部软件</a></font></div>
    </td>
    <td width="10%" height="21">  
      <div align="center"><font size="2"><a href="download.php?action=show&page=0&type=1&sort=<?=$sort?>&isdesc=<?=$isdesc?>">密码破解</a></font></div>
    </td>
    <td width="10%" height="21">  
      <div align="center"><font size="2"><a href="download.php?action=show&page=0&type=2&sort=<?=$sort?>&isdesc=<?=$isdesc?>">远程控制</a></font></div>
    </td>
    <td width="10%" height="21">  
      <div align="center"><font size="2"><a href="download.php?action=show&page=0&type=3&sort=<?=$sort?>&isdesc=<?=$isdesc?>">端口扫描</a></font></div>
    </td>
    <td width="10%" height="21">  
      <div align="center"><font size="2"><a href="download.php?action=show&page=0&type=4&sort=<?=$sort?>&isdesc=<?=$isdesc?>">字典工具</a></font></div>
    </td>
    <td width="10%" height="21">  
      <div align="center"><font size="2"><a href="download.php?action=show&page=0&type=5&sort=<?=$sort?>&isdesc=<?=$isdesc?>">系统安全</a></font></div>
    </td>
    <td width="10%" height="21">  
      <div align="center"><font size="2"><a href="download.php?action=show&page=0&type=6&sort=<?=$sort?>&isdesc=<?=$isdesc?>">各种炸弹</a></font></div>
    </td>
    <td width="10%" height="21">  
      <div align="center"><a href="download.php?action=show&page=0&type=7&sort=<?=$sort?>&isdesc=<?=$isdesc?>"><font size="2">加密软件</font></a></div>
    </td>
    <td width="10%" height="21">  
      <div align="center"><font size="2"><a href="download.php?action=show&page=0&type=8&sort=<?=$sort?>&isdesc=<?=$isdesc?>">源代码</a></font></div>
    </td>
    <td width="10%" height="21">  
      <div align="center"><font size="2"><a href="download.php?action=show&page=0&type=9&sort=<?=$sort?>&isdesc=<?=$isdesc?>">其它软件</a></font></div>
    </td>
  </tr>
</table>

<?
$pagesize=10;
if($action=="show")
{
switch($sort)
   {
   case "1":$sortby="id";break;
   case "2":$sortby="click";break;
   case "3";$sortby="title";break;
   default:$sortby="id";
   }
if($isdesc=="1")
   $temp_isdesc="";
   else
   $temp_isdesc="desc";
if($type==""||$type==0)
   $temp="";
else
   $temp="where type=".$type;
$rs=mysql_fetch_array(mysql_query("select count(*) from download ".$temp,$cn));
$max_page=$rs[0];
if($page>=$max_page)
$page=$max_page-$pagesize;
if($page<=0)
$page=0;
$result=mysql_query("select * from download  ".$temp." order by ".$sortby." ".$temp_isdesc." limit ".$page.",".$pagesize,$cn);
}
if($action=="search")
{

   switch($select)
   {
   case "软件名称":$object="title";break;
   case "作者":$object="author";break;
   case "简介":$object="say";
   }
    if($isdesc=="1")
   $temp_isdesc="";
   else
   $temp_isdesc="desc";
   switch($sort)
   {
   case "1":$sortby="id";break;
   case "2":$sortby="click";break;
   case "3";$sortby="title";break;
   default:$sortby="id";
   }
  if($type==""||$type==0)
  $temp="";
  else
  $temp="and type=".$type;

$rs=mysql_fetch_array(mysql_query("select count(*) from download where ".$object." like('%".$content."%') ".$temp,$cn));
$max_page=$rs[0];
if($page>=$max_page)
$page=$max_page-$pagesize;
if($page<=0)
$page=0;
$sql="select * from download  where ".$object." like('%".$content."%') ".$temp." order by ".$sortby." ".$temp_isdesc." limit ".$page.",".$pagesize;
$result=mysql_query($sql,$cn);
}
?>

<table width="100%" border="0" cellspacing="0" cellpadding="0" height="28">
  <form action=download.php?action=search&page=0&sort=<?=$sort?>&isdesc=<?=$isdesc?> method="post">
    <tr>  
      <td width="37%" height="35"><font size="2"> 符合你要求的软件总数:
        <?=$max_page;?>
        </font></td>
      <td width="63%" height="35" bordercolor="#FFFFFF"> <font size="2"> 软件查找:
        <input type="text" name="content" size="20" value="<?=$content?>">
        查找对像
        <select name="select">
          <option><font size="2">软件名称</font></option>
          <option><font size="2">简介</font></option>
        </select>
        <select name="type" >
          <option value="0">全部软件</option>
          <option selected value="<?=$type?>">当前类别</option>
        </select>
        <input type="submit" name="search" value="go">
        </font> </td>
    </tr> </form>
  </table>
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="38">
  <tr>  
    <td width="66%"></td>
    <td width="34%">  
      <form action="download.php?action=show&type=<?=$type?>" method="post">
        <div align="right"><font size="2">排序按:</font>  
          <select name="sort">
            <option <?if($sort==1) echo "selected";?> value="1">上传时间</option>
            <option <?if($sort==2) echo "selected";?> value="2">下载次数</option>
            <option <?if($sort==3) echo "selected";?> value="3">软件名称</option>
          </select>
          <select name="isdesc">
            <option <?if($isdesc==2) echo "selected";?>  value="2">降序</option>
            <option <?if($isdesc==1) echo "selected";?>  value="1">升序</option>
          </select>
          <input type="submit" value="go" name="submit" >
        </div>
      </form>
    </td>
  </tr>
</table>
<?


if($max_page==0&&$action!="publish")
echo "<p align=center><font size=4 color=red>对不起,没能找到你想要的记录</font></p><br>";
else

?>
<?if($action!="publish"){?>
<p align="right"><font size="2">
  <?if($action=="search"){?>
  <?if($page>=1){?>
  <a href=download.php?page=0&action=search&content=<?=$content?>&type=<?=$type?>&select=<?=$select?>&sort=<?=$sort?>&isdesc=<?=$isdesc?>>第一页</a>
  <?}?>
  <?if($page>=1){?>
  <a href=download.php?page=<?=$page-$pagesize;?>&action=search&content=<?=$content?>&type=<?=$type?>&select=<?=$select?>&sort=<?=$sort?>&isdesc=<?=$isdesc?>>上一页</a>
  <?}?>
  <?if($page<$max_page-$pagesize){?>
  &nbsp&nbsp<a href=download.php?page=<?=$page+$pagesize;?>&action=search&content=<?=$content?>&type=<?=$type?>&select=<?=$select?>&sort=<?=$sort?>&isdesc=<?=$isdesc?>>下一页</a>
  <?}?>
  <?if($page<$max_page-$pagesize){?>
  &nbsp&nbsp<a href=download.php?page=<?=$max_page-$pagesize;?>&action=search&content=<?=$content?>&type=<?=$type?>&select=<?=$select?>&sort=<?=$sort?>&isdesc=<?=$isdesc?>>最后页</a>
  <?}?>
  <?}?>
  <?if($action=="show"){?>
  <?if($page>=1){?>
  <a href=download.php?page=0&type=<?=$type?>&action=show&sort=<?=$sort?>&isdesc=<?=$isdesc?>>第一页</a>
  <?}?>
  <?if($page>=1){?>
  &nbsp&nbsp<a href=download.php?page=<?=$page-$pagesize;?>&type=<?=$type?>&action=show&sort=<?=$sort?>&isdesc=<?=$isdesc?>>上一页</a>
  <?}?>
  <?if($page<$max_page-$pagesize){?>
  &nbsp&nbsp<a href=download.php?page=<?=$page+$pagesize;?>&type=<?=$type?>&action=show&sort=<?=$sort?>&isdesc=<?=$isdesc?>>下一页</a>
  <?}?>
  <?if($page<$max_page-$pagesize){?>
  &nbsp&nbsp<a href=download.php?page=<?=$max_page-$pagesize;?>&type=<?=$type?>&action=show&sort=<?=$sort?>&isdesc=<?=$isdesc?>>最后页</a>
  <?}?>
  <?}?>
  </font></p>
  <?if($max_page>0){?>
<table border="1" width="100%" height="58" cellspacing="0" cellpadding="0" bordercolor="#000000">
  <tr bordercolor="#000000" bgcolor="#f0f0ff">  
    <td width="25" height="25">  
      <div align="center"><font size="2">编号</font></div>
    </td>
    <td width="41" height="25">  
      <div align="right"><font size="2">软件名</font></div>
    </td>
    <td width="539" height="25">  
      <div align="center"><font size="2">软件介绍</font></div>
    </td>
    <td width="31" height="25">  
      <div align="center"><font size="2">大小</font></div>
    </td>
    <td width="31" height="25">  
      <div align="center"><font size="2">下载次数</font></div>
    </td>
    <td width="82" height="25">  
      <div align="center"> <font size="2">上传时间</font> </div>
    </td>
  </tr>
  <?
  }
  while ($rs=@mysql_fetch_array($result))
{

?>
  <tr bordercolor="#000000">  
    <td width="25" height="25">  
      <?=$rs["id"];?>
      <br>
      <?if($session_power>=1)
      {
      ?>
      <a href="chang.php?step=1&id=<?=$rs["id"];?>">更改</a>  
      <?}?>
    </td>
    <td width="41" height="25">  
      <div align="center"><font size="2"> <a href="sign.php?url=<?=$rs["url"]?>&action=download&id=<?=$rs["id"]?>" target=_blank>  
        <?=$rs["title"];?>
        </a>  

        </font></div>
    </td>
    <td width="539" height="25">  
      <div align="left"><font size="2">  
        <?=$rs["say"];?>
        <br>
        <a href="sign.php?action=mail&id=<?=$rs["id"]?>&title=<?=$rs["title"]?>&type=<?=$rs["type"]?>">如果该链接有问题,请点这里  
        </a></font></div>
    </td>
    <td width="31" height="25">  
      <div align="center"><font size="2">
        <?=$rs["size"];?>
        </font></div>
    </td>
    <td width="31" height="25">  
      <div align="center"><font size="2">
        <?=$rs["click"];?>
        </font> </div>
    </td>
    <td width="82" height="25">  
      <div align="center"><font size="2">
        <?=$rs["ttime"];?>
        </font> </div>
    </td>
  </tr>
  <?}?>
</table>
<div align="right">
  <p><font size="2">
    <?if($action=="search"){?>
    <?if($page>=1){?>
    <a href=download.php?page=0&action=search&content=<?=$content?>&type=<?=$type?>&select=<?=$select?>&sort=<?=$sort?>&isdesc=<?=$isdesc?>>第一页</a>
    <?}?>
    <?if($page>=1){?>
    <a href=download.php?page=<?=$page-$pagesize;?>&action=search&content=<?=$content?>&type=<?=$type?>&select=<?=$select?>&sort=<?=$sort?>&isdesc=<?=$isdesc?>>上一页</a>
    <?}?>
    <?if($page<$max_page-$pagesize){?>
    &nbsp&nbsp<a href=download.php?page=<?=$page+$pagesize;?>&action=search&content=<?=$content?>&type=<?=$type?>&select=<?=$select?>&sort=<?=$sort?>&isdesc=<?=$isdesc?>>下一页</a>
    <?}?>
    <?if($page<$max_page-$pagesize){?>
    &nbsp&nbsp<a href=download.php?page=<?=$max_page-$pagesize;?>&action=search&content=<?=$content?>&type=<?=$type?>&select=<?=$select?>&sort=<?=$sort?>&isdesc=<?=$isdesc?>>最后页</a>
    <?}?>
    <?}?>
    <?if($action=="show"){?>
    <?if($page>=1){?>
    <a href=download.php?page=0&type=<?=$type?>&action=show&sort=<?=$sort?>&isdesc=<?=$isdesc?>>第一页</a>
    <?}?>
    <?if($page>=1){?>
    &nbsp&nbsp<a href=download.php?page=<?=$page-$pagesize;?>&type=<?=$type?>&action=show&sort=<?=$sort?>&isdesc=<?=$isdesc?>>上一页</a>
    <?}?>
    <?if($page<$max_page-$pagesize){?>
    &nbsp&nbsp<a href=download.php?page=<?=$page+$pagesize;?>&type=<?=$type?>&action=show&sort=<?=$sort?>&isdesc=<?=$isdesc?>>下一页</a>
    <?}?>
    <?if($page<$max_page-$pagesize){?>
    &nbsp&nbsp<a href=download.php?page=<?=$max_page-$pagesize;?>&type=<?=$type?>&action=show&sort=<?=$sort?>&isdesc=<?=$isdesc?>>最后页</a>
    <?}?>
    <?}?>
    </font></p>

</div>
<font size="2">

</font>
<?}?>
<?if($action=="publish"){?>
<form method="POST" action="sign.php?action=sign">
  <table width="100%" border="0" cellspacing="0" cellpadding="0" height="155">
    <tr>
      <td height="20" width="28%"><font size="2">发布你的软件<br>
        或你推荐软件 <br>
        </font></td>
      <td height="20" width="72%"> </td>
    </tr>
    <tr>
      <td width="28%"><font size="2">软件名称:</font></td>
      <td width="72%"> <font size="2">
        <input type="text" name="title" size="20">
        </font></td>
    </tr>
    <tr>
      <td width="28%" height="24"><font size="2">软件大小:</font></td>
      <td width="72%" height="24"><font size="2">
        <input type="text" name="size" size="20">
        </font></td>
    </tr>
    <tr>
      <td width="28%"><font size="2">软件地址(<a href="mailto:[email protected]">如果没有,请打包给版主</a>)</font></td>
      <td width="72%"><font size="2">
        <input type="text" name="url" size="50">
        </font></td>
    </tr>
    <tr>
      <td width="28%" height="21"><font size="2">软件类型</font></td>
      <td width="72%" height="21"><font size="2">
        <select name="type">
          <option value="1">密码破解</option>
          <option value="2">远程控制</option>
          <option value="3">端口扫描</option>
          <option value="4">字典工具</option>
          <option value="5">系统安全</option>
          <option value="6">各种炸弹</option>
          <option value="7">加密软件</option>
          <option value="8">源代码</option>
          <option selected value="9">其它软件</option>
        </select>
        </font></td>
    </tr>
    <tr>
      <td width="28%"><font size="2">软件简介:</font></td>
      <td width="72%" rowspan="2"> <font size="2">
        <textarea rows="8" name="say" cols="50"></textarea>
        </font></td>
    </tr>
    <tr>
      <td width="28%"> </td>
    </tr>
  </table>
  <p align="left"> <font size="2">
    <input type="submit" value="提交" name="sign">
    <input type="reset" value="重写" >
    </font>
</form>
<?}?>
<div align="right"> <font size="2">
  <br>
  </font></div>
<p align="center"><font size="2"><br>
  </font> </p>
<p align="right"> </p>
<p>  </p>


</body>
</html>