modules/systemuser/include/useraccounts.php (92f133e) - webinterface.git

useraccounts.php

<?php

require_once("inc/debug.php");
require_once("inc/db_connect.php");

require_role(ROLE_CUSTOMER);

function customer_may_have_useraccounts()
{
  $customerno = (int) $_SESSION['customerinfo']['customerno'];
  $result = db_query("SELECT COUNT(*) FROM system.useraccounts WHERE kunde={$customerno}");
  return (mysql_num_rows($result) > 0);
}

function available_shells()
{
  $result = db_query("SELECT path, name FROM system.shells WHERE usable=1");
  $ret = array();
  while ($s = mysql_fetch_assoc($result))
  {
    $ret[$s['path']] = $s['name'];
  }
  DEBUG($ret);
  return $ret;
}

function get_used_quota($uid)
{
  $uid = (int) $uid;
  $result = db_query("SELECT s.hostname AS server, used, COALESCE(us.quota, u.quota) AS quota FROM system.usedquota AS uq LEFT JOIN system.useraccounts AS u USING (uid) LEFT JOIN system.servers AS s ON (s.id=uq.server) LEFT JOIN system.user_server AS us ON (us.uid=uq.uid AND us.server=uq.server) WHERE uq.uid='{$uid}'");
  $ret = array();
  while ($line = mysql_fetch_assoc($result))
    $ret[] = $line;
  DEBUG($ret);
  return $ret;
}

function set_account_details($account)
{
  $uid = (int) $account['uid'];
  $customerno = (int) $_SESSION['customerinfo']['customerno'];
  $fullname = maybe_null(mysql_real_escape_string(filter_input_general($account['name'])));
  $shell = mysql_real_escape_string(filter_input_general($account['shell']));
  $quota = (int) $account['quota'];

db_query("UPDATE system.useraccounts SET name={$fullname}, quota={$quota}, shell='{$shell}' WHERE kunde={$customerno} AND uid={$uid}");
  logger(LOG_INFO, "modules/systemuser/include/useraccounts", "systemuser", "updated details for uid {$uid}");

}

function get_customer_quota()
{
  $cid = (int) $_SESSION['customerinfo']['customerno'];
  $result = db_query("SELECT SUM(u.quota) AS assigned, cq.quota AS max FROM system.customerquota AS cq INNER JOIN system.useraccounts AS u ON (u.kunde=cq.cid) WHERE cq.cid={$cid}");
  $ret = mysql_fetch_assoc($result);
  DEBUG($ret);
  return $ret;
}

webinterface.git

Überarbeitetes Systemuser-Modul, mit dem man Quotas, Realname und Shell selbst setzen kann.