picture.php

phpcms网站管理系统 很不错的 有需要的就下载看看八

	@extract($db->get_one("SELECT COUNT(*) AS num_0 FROM ".TABLE_PICTURE." WHERE status=0 AND username='$_username' AND recycle=1 AND channelid='$channelid'"));
	@extract($db->get_one("SELECT COUNT(*) AS num_2 FROM ".TABLE_PICTURE." WHERE status=2 AND username='$_username' AND recycle=1 AND channelid='$channelid'"));

	$referer=urlencode("?mod=picture&file=picture&action=recycle&channelid=".$channelid."&catid=".$catid."&status=".$status."&page=".$page);
	$catid=$catid ? $catid : 0;
    if(isset($status)) $status = intval($status);
	$sqlstatus = isset($status) ? " AND status=$status " : "";
	$thecatid=$catid;
	if(!$page)
	{
		$page=1;
		$offset=0;
	}
	else
	{
		$offset=($page-1)*$pagesize;
	}
	$query="SELECT COUNT(*) as num FROM ".TABLE_PICTURE." WHERE recycle=1 AND channelid='$channelid' $sqlstatus $addquery";
	$result=$db->query($query);
	$r=$db->fetch_array($result);
	$number=$r["num"];	$url="?mod=picture&file=picture&action=recycle&channelid=".$channelid."&catid=".$catid."&status=".$status."&keyword=".$keyword."&ontop=".$ontop."&elite=".$elite."&ordertype=".$ordertype."&srchtype=".$srchtype."&page=".$page."&submit=1";
	$pages=phppages($number,$page,$pagesize,$url);
	$query="SELECT * FROM ".TABLE_PICTURE." WHERE recycle=1 AND channelid='$channelid' $sqlstatus $addquery ORDER BY $dordertype LIMIT $offset,$pagesize";
	$result=$db->query($query);
	if($db->num_rows($result)>0)
	{
		while($r=$db->fetch_array($result))
		{
			$p->set_catid($r[catid]);
			$r[url] = $p->get_itemurl($r[pictureid],$r[addtime]);
			$r[caturl] = $p->get_listurl(0);
	        $r[thumb] = $r[thumb] ? (preg_match("/^http:\/\//i",$r[thumb]) ? $r[thumb] : PHPCMS_PATH.$r[thumb]) : PHPCMS_PATH."images/nopic.gif";
			$r[title] = titleformat($r[title],$r[titlefontcolor],$r[titlefonttype],'');
			$r[adddate]=date("Y-m-d",$r[addtime]);
			$r[addtime]=date("Y/md",$r[addtime]);
			$pictures[]=$r;
		}
	}
	include admintpl('picture_recycle');

break;

//浏览图片
case 'preview':
	if(!ereg('^[0-9]+$',$pictureid))
	{
		showmessage('非法参数！请返回！'); 
	}
	$result=$db->query("SELECT * FROM ".TABLE_PICTURE." WHERE pictureid=$pictureid");
	if($db->num_rows($result)==0)
	{
		showmessage('对不起，该图片不存在！请返回！'); 
	}
	$picture=$db->fetch_array($result);
	$picture[title] = titleformat($picture[title],$picture[titlefontcolor],$picture[titlefonttype],'');
	$picture[adddate] = date('Y-m-d',$picture[addtime]);
	$picture[addtime] = date('Y/md',$picture[addtime]);
	$picture[thumb] = get_imgurl($picture[thumb]);
	$picture[url] = $p->get_itemurl($picture[pictureid],$picture[addtime]);
	$p->set_catid($picture[catid]);
	$picture[catdir] = $p->get_listurl(0);
    $pictureurls = trim($picture[pictureurls]);  
	$urls = explode("\n",$pictureurls);
	$urls = array_map("trim",$urls);
	$pictureurls = array();
	foreach($urls as $k=>$v)
	{
		$pictureurl = explode("|",$v);
		$pictureurl['name'] = $pictureurl[0];
		$pictureurl['url'] = get_imgurl($pictureurl[1]);
		$pictureurls[] = $pictureurl;
	}
	include admintpl('picture_preview');
break;

case 'specialout':

	if(empty($pictureid)) showmessage('非法参数！请返回！');

	$pictureids=is_array($pictureid) ? implode(',',$pictureid) : $pictureid;
	$db->query("UPDATE ".TABLE_PICTURE." SET specialid=0 WHERE pictureid IN ($pictureids) AND channelid='$channelid'");
	if($db->affected_rows()>0)
	{
		showmessage('操作成功！',$referer);
	}
	else
	{
		showmessage('操作失败！请返回！');
	}
break;

//推举图片
case 'elite':

	if(empty($pictureid))
	{
		showmessage('非法参数！请返回！');
	}
	if(!ereg('^[0-1]+$',$value))
	{
		showmessage('非法参数！请返回！');
	}
	$pictureids=is_array($pictureid) ? implode(',',$pictureid) : $pictureid;
	$db->query("UPDATE ".TABLE_PICTURE." SET elite='$value' WHERE pictureid IN ($pictureids) AND channelid='$channelid'");
	if($db->affected_rows()>0)
	{
		showmessage('操作成功！',$referer);
	}
	else
	{
		showmessage('操作失败！请返回！');
	}
break;

//至顶图片
case 'ontop':

	if(empty($pictureid))
	{
		showmessage('非法参数！请返回！');
	}
	if(!ereg('^[0-1]+$',$value))
	{
		showmessage('非法参数！请返回！');
	}
	$pictureids=is_array($pictureid) ? implode(',',$pictureid) : $pictureid;
	$db->query("UPDATE ".TABLE_PICTURE." SET ontop='$value' WHERE pictureid IN ($pictureids) AND channelid='$channelid'");
	if($db->affected_rows()>0)
	{
		showmessage('操作成功！',$referer);
	}
	else
	{
		showmessage('操作失败！请返回！');
	}
break;

//放入回收箱
case 'torecycle':

	if(empty($pictureid))
	{
		showmessage('非法参数！请返回！');
	}
	if(!ereg('^[0-1]+$',$value))
	{
		showmessage('非法参数！请返回！');
	}

	$condition= "";
	if($_grade==4) $condition = " AND username='$_username' AND status<3";
	if($_grade==5) $condition = " AND status<3";

	$pictureids=is_array($pictureid) ? implode(',',$pictureid) : $pictureid;
	$db->query("UPDATE ".TABLE_PICTURE." SET recycle='$value' WHERE pictureid IN ($pictureids) AND channelid='$channelid' $condition ");
	if($db->affected_rows()>0)
	{
		if($view==1){
			$referer="?mod=".$mod."&file=".$file."&action=check&channelid=".$channelid."&catid=".$catid."&srchtype=".$srchtype."&keywords=".$keywords."&ordertype=".$ordertype."&page=".$page;
		}
		showmessage('操作成功！',$referer);
	}
	else
	{
		showmessage('操作失败！请返回！');
	}
break;

//通过文章
case 'pass':

	if(empty($pictureid))
	{
		showmessage('非法参数！请返回！');
	}
	if(!ereg('^[0-3]+$',$pass))
	{
		showmessage('非法参数！请返回！');
	}

	$pictureids=is_array($pictureid) ? implode(',',$pictureid) : $pictureid;
	$db->query("UPDATE ".TABLE_PICTURE." SET checker='$_username',checktime='$timestamp',status='$pass' WHERE pictureid IN ($pictureids) AND channelid='$channelid'");
	if($pass==3)
	{
		tohtml("picture");
	}
	if($db->affected_rows()>0)
	{
		$referer = $PHP_REFERER;
		showmessage('操作成功！',$referer);
	}
	else
	{
		showmessage('操作失败！请返回！');
	}
break;

//彻底删除，按ID
case 'delete':

	if(empty($pictureid))
	{
		showmessage('非法参数！请返回！');
	}
	$pictureids=is_array($pictureid) ? implode(',',$pictureid) : $pictureid;
	$query="SELECT pictureid,addtime FROM ".TABLE_PICTURE." WHERE pictureid IN ($pictureids) AND channelid='$channelid'";
	$result=$db->query($query);
	while($r=$db->fetch_array($result))
	{
		$p->set_type("path");
		$filename=$p->get_itemurl($r[pictureid],$r[addtime]);
		$f->unlink($filename);
	}
	$db->query("DELETE FROM ".TABLE_PICTURE." WHERE pictureid IN ($pictureids) AND channelid='$channelid'");
	if($db->affected_rows()>0)
	{
		showmessage('操作成功！',$referer);
	}
	else
	{
		showmessage('操作失败！请返回！');
	}
break;

//从回收箱，还原所有
case 'restoreall':

	$query="UPDATE ".TABLE_PICTURE." SET recycle=0 WHERE recycle=1 AND channelid='$channelid'";
	$db->query($query);
	if($db->affected_rows()>0)
	{
		showmessage('操作成功！',$referer);
	}
	else
	{
		showmessage('操作失败！请返回！');
	}
break;

//彻底删除，删除所有
case 'deleteall':

	$query="SELECT pictureid,addtime FROM ".TABLE_PICTURE." WHERE recycle=1 AND channelid='$channelid'";
	$result=$db->query($query);
	while($r=$db->fetch_array($result))
	{
		$p->set_type("path");
		$filename=$p->get_itemurl($r[pictureid],$r[addtime]);
		$f->unlink($filename);
	}

	$result=$db->query("SELECT username FROM ".TABLE_PICTURE." WHERE recycle=1 AND channelid='$channelid'");
	while($r=$db->fetch_array($result))
	{
		picturenum($r[username]);
	}

	$query="DELETE FROM ".TABLE_PICTURE." WHERE recycle=1 AND channelid='$channelid'";
	$db->query($query);
	if($db->affected_rows()>0)
	{
		showmessage('操作成功！',$referer);
	}
	else
	{
		showmessage('操作失败！请返回！');
	}
break;

//生成图片
case 'tohtml':

	if($submit)
	{
		if(empty($pictureid))
		{
			showmessage('请选择要生成的图片！');
		}
		
		if(is_array($pictureid))
		{
			$pictureids=$pictureid;
			$i=0;
			foreach($pictureids as $pictureid)
			{
				tohtml('picture');
			}
		}
		else
		{
			tohtml('picture');
		}
		showmessage("生成图片成功！",$referer);
	}
break;

}

?>