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

$errstr = "";
###############################################################################
#執(zhí)行刪除操作
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("刪除成功!");
}
###############################################################################
#執(zhí)行插入或者更新的操作
$now = date("Y-m-d H:i:s");

if ($id == ""){
	#id空,進(jìn)行插入操作
	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非空,進(jìn)行更新操作
	$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."',";
	}
	#執(zhí)行操作
	mysql_query("UPDATE $table_db SET $ud last_update='$now' WHERE  id='$id'");
}
echo "數(shù)據(jù)插入/更新成功成功!<br>";
###############################################################################
#判斷是否進(jìn)行上傳操作
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壓縮包中的每個文件進(jìn)行分析
	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;
		}
		
		#分析擴(kuò)展名
		$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);
		
		#如果擴(kuò)展名不符合要求,刪除文件,并且直接分析下一個文件
		if ($flag == 0) {
			unlink($fpth);
			continue;
		}

		#讀取文件內(nèi)容,插入表$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;

?>