function user_list()
{
$users = ZUser::getUsers();
foreach ($users as $k => $v) {
$users[$k]->packageName = ZPackage::getPackage($v->package)->name;
}
return json_encode($users);
}
if (ZUser::removeUser($name)) {
setmsg(t('Removed!'), 'notice');
} else {
setmsg(t('Error'));
}
}
break;
case 'list':
default:
$task = 'list';
$start = 0;
$limit = 20;
if ($role == 0) {
// user
redirect('?task=edit&name=' . $me);
//$users = array(ZUser::getUser($me));
} elseif ($role == 1) {
// admin
$users = ZUser::getUsers($start, $limit);
} else {
// reseller
$users = ZUser::getUsers($start, $limit, ZUser::getUser($me)->id);
}
foreach ($users as $k => $v) {
$users[$k]->packageName = ZPackage::getPackage($v->package)->name;
}
break;
}
if (!$norender) {
include template('user');
}
function getUserPackage($user)
{
global $pdo;
$sql = "SELECT package FROM user WHERE user='******'";
return ZPackage::getPackage($pdo->fetchOne($sql, 'package'))->name;
}
function setUserPackage($user, $package)
{
return ZPackage::setUserPackage($user, $package);
}
}
if (checktoken() && 'edit' == $op) {
$package = array();
$package['name'] = strip_tags($_REQUEST['name']);
$package['desc'] = strip_tags($_REQUEST['desc']);
$package['space'] = $_REQUEST['space'];
$package['bandwidth'] = $_REQUEST['bandwidth'];
$package['site'] = intval($_REQUEST['site']);
$package['ftp'] = intval($_REQUEST['ftp']);
$package['sql'] = intval($_REQUEST['sql']);
$package['state'] = intval($_REQUEST['state']);
$package['updated'] = date('Y-m-d H:i:s');
if (ZPackage::updatePackage($id, $package)) {
setmsg(t("Package Updated."), 'notice', 'package.php');
}
}
break;
case 'list':
default:
$task = 'list';
$packages = ZPackage::getPackages(false, 'all');
if ($_REQUEST['get'] == 'json') {
$arr = array('records' => $packages, 'total' => count($packages));
echo json_encode($arr);
$norender = true;
}
break;
}
if (!$norender) {
include template('package');
}
function checkPackage($type = '')
{
global $me, $pdo;
$usage = 0;
if (!$type) {
$type = basename($_SERVER['PHP_SELF'], '.php');
}
switch ($type) {
case 'site':
$sql = "SELECT COUNT(*) AS usage FROM site WHERE owner='{$me}'";
$usage = $pdo->fetchOne($sql, 'usage');
break;
case 'ftp':
$sql = "SELECT COUNT(*) AS usage FROM ftp WHERE owner='{$me}'";
$usage = $pdo->fetchOne($sql, 'usage');
break;
case 'space':
break;
case 'sql':
$sql = "SHOW DATABASES LIKE '{$me}\\_%'";
$result = mysql_query($sql) or die(mysql_error());
$usage = mysql_num_rows($result);
break;
case 'bandwidth':
break;
default:
return false;
}
$limit = ZPackage::getPackage(ZUser::getUser($me)->package)->{$type};
//var_dump($type, $usage, $limit, $me);exit;
return $limit == -1 || $usage < $limit;
}
