index.php

是个关于网格编程的程序

<?PHP
//*****************************************
//       id: pic/index
//       EasyTalk V3.0 2008.5.6 20:50
//       by 仙踪云影
//*****************************************

define('pic', 'yes');
require_once 'config.php';
require_once '../../include/uploadpic.php';

$pic_uid=$_GET['uid']?$_GET['uid']:$user_id;
$smarty->assign("pic_uid",$pic_uid);

$page=isset($_GET['page'])?intval($_GET['page']):1;
$smarty->assign("page",$page);

$sql1 = "select username,user_pic,pic_num,backimg from ".$DBprefix."users where user_id='$pic_uid'";
$query1 = $db->query($sql1);
$data1 = $db->fetch_array($query1);
$pic_uname=$data1['username'];
$pic_pic=$data1['user_pic'];
$pic_num=$data1['pic_num'];  
$u_backimg=$data1['backimg'];
$smarty->assign("u_backimg",$u_backimg);
$smarty->assign("pic_num",$pic_num);
$smarty->assign("pic_pic",$pic_pic);
$smarty->assign("pic_uname",$pic_uname);
$smarty->assign("web_name3",$pic_uname."的相册"); 

$action = $_POST["actions"];
if ($action=="picupload") {

if ($pic_num>=$sys_picnum) {
	echo "<script>alert(\"提示：你上传的照片数已经达到了系统要求上限：$sys_picnum！\");window.location.href='$prev';</script>"; 
    exit;
}
else {

	if ($_FILES['picture']['type']!="image/jpg" && $_FILES['picture']['type']!="image/pjpeg" && $_FILES['picture']['type']!="image/jpeg" && $_FILES['picture']['type']!="image/gif" && $_FILES['picture']['type']!="image/png" && $_FILES['picture']['type']!="image/x-png" && $_FILES['picture']['type']!="image/bmp") {
		echo "<script>alert(\"提示：你上传的文件类型不正确，系统仅支持 jpg,gif,png 格式的图片,点击确认返回！\");window.location.href='$prev';</script>"; 
        exit;
	}
$f=$_FILES['picture'];
$sql3 = "SELECT pic_id FROM ".$DBprefix."pic order by pic_id desc limit 1";
$query3 = $db->query($sql3);
$data =$db->fetch_array($query3);
$pic_id=$data['pic_id'];
$pic_id=$pic_id+1;
$dest_dir=ET_ROOT.'/attachments/photo';
$dest=$dest_dir.'/'.date("ymd_hms").$f['name'];
$dest2=$dest_dir.'/'.$pic_id.'.jpg';
$r=move_uploaded_file($f['tmp_name'],$dest);
chmod($dest, 0755);
$picture=$dest;
$picture1=$dest2;
$ptemp=explode("attachments/",$dest);
$dest3=$ptemp[1];
$picture2=$webaddr."/attachments/".$dest3;
$resizeimage = new resizeimage("$picture", "115", "90", "1","$picture1"); 

$pic_name = $_POST["pic_name"];
$pic_info = $_POST["pic_info"];
$pic_time =time();
if ($pic_info=="")
	$pic_info="暂无图片说明!";
$query  = "INSERT INTO ".$DBprefix."pic (pic_id,uid,pic_path,pic_name,pic_time,pic_info) VALUES ('$pic_id','$user_id','$picture2','$pic_name','$pic_time','$pic_info')"; mysql_query($query);   

$sql3 = "SELECT pic_path FROM ".$DBprefix."pic where uid='$user_id' order by pic_id desc limit 1";
$query3 = $db->query($sql3);
$data =$db->fetch_array($query3);
$pic_path=$data['pic_path'];

$setmes="我上传的照片：".$pic_name."。|et|".$pic_path;
$query1 = "INSERT INTO ".$DBprefix."share (user_id,user_name,user_pic,content_body,share_time) VALUES ('$user_id','$user_name','$user_pic','$setmes','$pic_time')"; 
mysql_query($query1);
$pnum=$pic_num+1;
$query3 = "UPDATE ".$DBprefix."users  SET pic_num='$pnum' where user_id='$user_id'"; 
mysql_query($query3);
	if ($rewrite==1)
		header("location: $webaddr/plugins/pic/index");
	else
		header("location: $webaddr/plugins/pic/index.php"); 
} 
}

//图片调用
$p_num =20;
$start= ($page-1)*$p_num;
$t=0;
$sql3 = "SELECT * FROM ".$DBprefix."pic where uid='$pic_uid' order by pic_id desc limit $start,$p_num";
$query3 = $db->query($sql3);
while($data =$db->fetch_array($query3)) {
$t=$t+1;
$pic_id=$data['pic_id'];
$pic_time=$data['pic_time'];
$puid=$data['uid'];
$pic_time=gmdate('Y-m-d H:i:s',$pic_time+8*3600);
$pic_path=$data['pic_path'];
$pic_name=$data['pic_name'];
$pic_info=$data['pic_info'];
$array[] = array("pic_id"=>$pic_id,"pic_path"=>$pic_path,"pic_time"=>$pic_time,"pic_name"=>$pic_name,
	             "pic_info"=>$pic_info,"t"=>$t,"puid"=>$puid);
}
$smarty->assign("pic", $array);
unset($array);

//页码
$sql = "select count(pic_id) as count from ".$DBprefix."pic where uid='$pic_uid'";
$query = $db->query($sql);
$row = $db->fetch_array($query);
$total=$row['count'];
$pg_num=$total/$p_num;
$pg_num=(int) $pg_num;
$pg_num=$pg_num+1;
$smarty->assign("pg_num",$pg_num);
for ($i=1;$i<=$pg_num;$i++)
{$array[] = array("ppg"=>$i);}
$smarty->assign("ppg", $array);

//图片删除
if ($action =="picdel") {
$pid = $_POST["pid"];

$query2 = "select * from ".$DBprefix."pic where pic_id='$pid'";
$data2 = @mysql_fetch_array(mysql_query($query2)); 
$picname=$data2['pic_path'];
$picid = explode('attachments/photo/',$picname); 
$picname = $picid[1];
$picname = '..\..\attachments\photo\\'.$picname;
@unlink($picname);
@unlink('..\..\attachments\photo\\'.$pid.'.jpg');
$query = "DELETE FROM ".$DBprefix."pic WHERE pic_id='$pid'";
mysql_query($query);
$pnum=$pic_num-1;
$query3 = "UPDATE ".$DBprefix."users  SET pic_num='$pnum' where user_id='$user_id'"; 
mysql_query($query3);
if ($rewrite==1)
	header("location: $webaddr/plugins/pic/index");
else
	header("location: $webaddr/plugins/pic/index.php");
}

$smarty->assign("last_picnum",$sys_picnum-$pic_num);
$sqlnum=$db->querynum;
$smarty->assign("sqlnum",$sqlnum);
$mtime = explode(' ', microtime());
$loadtime=$mtime[1] + $mtime[0] - $starttime;
$smarty->assign("loadtime",$loadtime);
$smarty->assign("errormessage",$errormessage);
if (!file_exists($isclose))
$smarty->display("webclose.htm"); 
else
$smarty->display("pic.htm");
?>