admin_1.do.php

一款程序源代码发布管理系统的源码

<?php 
@include("admin.inc");
@include('pclzip.lib.php');

$errstr = "";
###############################################################################
#执行删除操作
if ($id!="" && $dele=="dele")  {
	$rst = mysql_query("SELECT * FROM $table_db WHERE id='$id'");
	$row = mysql_fetch_array($rst);
	if (!$row) {
		echo "未找到文件!<br>";
	} else {
		unlink($up_filepath.$row["filename"]);
	}
	mysql_query("DELETE FROM $table_db WHERE id='$id'");
	die("删除成功!");
}
###############################################################################
#执行插入或者更新的操作
$now = date("Y-m-d H:i:s");

if ($id == ""){
	#id空,进行插入操作
	mysql_query("INSERT INTO $table_db  (prog_name,short_name,introduction,type,filename,last_update,author) VALUES  ('".$prog_name."','".$short_name."','".$introduction."','".$newtype."','".$upfile_name."','".$now."','".$author."')"); 
	#得到插入后的id
	$rst = mysql_query("SELECT * FROM $table_db WHERE prog_name='$prog_name'"); 
	$row = mysql_fetch_array($rst);
	$id = $row["id"];
	mysql_free_result($rst);
} else {
	#id非空,进行更新操作
	$ud = "";
	if ($prog_name1 == "prog_name1") {
		$ud .= "prog_name='".$prog_name."',";
	}
	if ($short_name1 == "short_name1") {
		$ud .= "short_name='".$short_name."',";
	}
	if ($introduction1 == "introduction1") {
		$ud .= "introduction='".$introduction."',";
	}
	if ($upfile1 == "upfile1") {
		$ud .= "filename='".$upfile_name."',";
		mysql_query("DELETE FROM $table_content  WHERE id='$id'");
	}
	if ($newtype1 == "newtype1") {
		$ud .= "type='".$newtype."',";
	}
	if ($author1 == "author1") {
		$ud .= "author='".$author."',";
	}
	#执行操作
	mysql_query("UPDATE $table_db SET $ud last_update='$now' WHERE  id='$id'");
}
echo "数据插入/更新成功成功!<br>";
###############################################################################
#判断是否进行上传操作
if ($upfile1=="upfile1" || $id=="") {
	#拷贝上传的文件到指定的目录
	If($upfile != "") {
		$upload_filepath = $up_filepath.$upfile_name;
		copy($upfile,$upload_filepath);  
		unlink($upfile);
		echo "文件上传成功!<br>";
	}  else {
		die("你没有上传任何文件");  
	}  

	#解压缩上传的文件到temp中的临时目录
	$archive = new PclZip($upload_filepath);
	if ($archive->extract(PCLZIP_OPT_PATH, $tmp_dir) == 0) {
		die("Error : ".$archive->errorInfo(true));
	}
	echo "文件解压缩成功!<br>";

	$ct = $archive->listContent();
	$dir_num = 0;
	#对zip压缩包中的每个文件进行分析
	for ($i=0; $i<sizeof($ct); $i++) {
		$fn = $ct[$i]['stored_filename'];
		$fpth = $tmp_dir.$fn;
		
		#跳过目录
		if (substr($fpth,-1) == "/") {
			$tempdirs[$dir_num++] = $fpth;
			continue;
		}
		
		#分析扩展名
		$extend = pathinfo($fpth);
		$extend = strtolower($extend["extension"]);
		$flag=0;
		$k=0;
		do {
			$j = strpos($myext,' ',$k);
			if (!$j) {
				$s=substr($myext,$k,strlen($myext));
				if (strcmp($extend,$s) == 0) $flag = 1;
				break;
			}
			$s = substr($myext,$k,$j-$k);
			if (strcmp($extend,$s) == 0) {
				$flag = 1;
				break;
			}
			$k = $j+1;
		} while (true);
		
		#如果扩展名不符合要求,删除文件,并且直接分析下一个文件
		if ($flag == 0) {
			unlink($fpth);
			continue;
		}

		#读取文件内容,插入表$table_content
		$tmpstr = str_replace("'","__~__",join("",file($fpth)));
		$tmpstr = str_replace("\\n","__n__",$tmpstr);
		$tmpstr = str_replace("\\t","__t__",$tmpstr);
		$length = strlen($tmpstr);
		mysql_query("INSERT INTO $table_content (id,name,content,length) VALUES ('$id','$fn','$tmpstr','$length')");
		$errstr .= " ".mysql_error();

		#删除该文件
		unlink($fpth);
	}
	echo "文件读取成功!<br>";
}

#删除临时生成的目录
for ($i=0; $i<$dir_num; $i++) {
	rmdir($tempdirs[$i]);
}

###############################################################################
#生成/更新xml文件
$rst = mysql_query("SELECT * FROM $table_db WHERE 1");
$now = date("Y-m-d H:i:s");

$str = "<?xml version=\"1.0\" encoding=\"GBK\"?><rss version=\"2.0\"><channel><pubDate>".$now."</pubDate><docs>".$urlbase."</docs><title>".$top_str."</title><link>".$urlbase."</link><description>".$top_str."</description><language>cn</language><dc_date>".$now."</dc_date><dc_language>cn</dc_language>";

while ($row = mysql_fetch_array($rst)) {
	$str .= "<item><title>".$row["prog_name"]."</title><link>".$urlbase."view.php?id=".$row["id"]."</link><comments>comments</comments><author>".$row["author"]."</author><description>".$row["introduction"]."</description><category>category</category><pubDate>".$row["last_update"]."</pubDate><guid>".$urlbase."view?id=".$row["id"]."</guid></item>";
}
$str .= "</channel></rss>";

$fp = fopen ("rss2.xml","w");
fputs($fp,$str);
fclose($fp);
echo "XML文件生成成功!<br>";
###############################################################################
echo $errstr;

?>