<?php
/*
[UCenter Home] (C) 2007-2008 Comsenz Inc.
$Id: admincp_album.php 12568 2009-07-08 07:38:01Z zhengqingpeng $
*/
if(!defined('IN_UCHOME') || !defined('IN_ADMINCP')) {
exit('Access Denied');
}
//ȨÏÞ
if(!$allowmanage = checkperm('managealbum')) {
$_GET['uid'] = $_SGLOBAL['supe_uid'];//Ö»ÄܲÙ×÷±¾È˵Ä
$_GET['username'] = '';
}
if(submitcheck('deletesubmit')) {
include_once(S_ROOT.'./source/function_delete.php');
if(!empty($_POST['ids']) && deletealbums($_POST['ids'])) {
cpmessage('do_success', $_POST['mpurl']);
} else {
cpmessage('at_least_one_option_to_delete_albums', $_POST['mpurl']);
}
}
$mpurl = 'admincp.php?ac=album';
//´¦ÀíËÑË÷
$intkeys = array('uid', 'friend', 'albumid');
$strkeys = array('username');
$randkeys = array(array('sstrtotime','dateline'));
$likekeys = array('albumname');
$results = getwheres($intkeys, $strkeys, $randkeys, $likekeys);
$wherearr = $results['wherearr'];
$wheresql = empty($wherearr)?'1':implode(' AND ', $wherearr);
$mpurl .= '&'.implode('&', $results['urls']);
//ÅÅÐò
$orders = getorders(array('dateline', 'updatetime', 'picnum'), 'albumid');
$ordersql = $orders['sql'];
if($orders['urls']) $mpurl .= '&'.implode('&', $orders['urls']);
$orderby = array($_GET['orderby']=>' selected');
$ordersc = array($_GET['ordersc']=>' selected');
//ÏÔʾ·ÖÒ³
$perpage = empty($_GET['perpage'])?0:intval($_GET['perpage']);
if(!in_array($perpage, array(20,50,100,1000))) $perpage = 20;
$page = empty($_GET['page'])?1:intval($_GET['page']);
if($page<1) $page = 1;
$start = ($page-1)*$perpage;
//¼ì²é¿ªÊ¼Êý
ckstart($start, $perpage);
//ÏÔʾ·ÖÒ³
if($perpage > 100) {
$count = 1;
$selectsql = 'albumid';
} else {
$count = $_SGLOBAL['db']->result($_SGLOBAL['db']->query("SELECT COUNT(*) FROM ".tname('album')." WHERE $wheresql"), 0);
$selectsql = '*';
}
$mpurl .= '&perpage='.$perpage;
$perpages = array($perpage => ' selected');
$managebatch = checkperm('managebatch');
$allowbatch = true;
$list = array();
$multi = '';
if($count) {
$query = $_SGLOBAL['db']->query("SELECT $selectsql FROM ".tname('album')." WHERE $wheresql $ordersql LIMIT $start,$perpage");
while ($value = $_SGLOBAL['db']->fetch_array($query)) {
$value['pic'] = pic_cover_get($value['pic'], $value['picflag']);
if(!$managebatch && $value['uid'] != $_SGLOBAL['supe_uid']) {
$allowbatch = false;
}
$list[] = $value;
}
$multi = multi($count, $perpage, $page, $mpurl);
}
//ÏÔʾ·ÖÒ³
if($perpage > 100) {
$count = count($list);
}
?>