?? picture.php
字號:
@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;
}
?>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -