6 require_once('joe/util.lib.php');
7 require_once('joe/mysql.lib.php');
9 function checkQuotas($userId=null) {
11 $sql = 'SELECT DatabaseId,Name FROM DB WHERE bEnabled=1';
13 if (is_array($userId)) {
14 $sql_userId = sprintf("UserId IN ('%s')", implode("','",array_map('mysql_escape_string',$userId)));
15 } elseif ((string)intval($userId)===(string)$userId) {
16 $sql_userId = sprintf("UserId = '%s'", mysql_escape_string($userId));
18 die('userId parameter error in checkQuotas');
20 $sql = sprintf("SELECT DB.DatabaseId,Name FROM DB INNER JOIN DBOwner ON DB.DatabaseId = DBOwner.DatabaseId WHERE bEnabled=1 AND %s", $sql_userId);
22 $databases = fetchRows(DBSelect($sql),'Name');
23 foreach($databases as $db) {
24 $DBId = $db['DatabaseId'];
25 $arr['dLastCheck'] = 'NOW()';
26 $arr['nBytes'] = calcDBSize($db['Name']);
27 $sql = sprintf("UPDATE DB SET %s WHERE DatabaseId = '%s'",
29 mysql_escape_string($DBId));
32 $sql = "UPDATE UserStat SET nBytes = (
35 INNER JOIN DBOwner ON DBOwner.DatabaseId = DB.DatabaseId
36 WHERE DBOwner.UserId = UserStat.UserId
39 ), dLastCheck = NOW()";
40 if (!empty($userId)) $sql .= " WHERE $sql_userId";
42 $sql = "UPDATE UserStat SET nDatabases = (
45 INNER JOIN DBOwner ON DBOwner.DatabaseId = DB.DatabaseId
46 WHERE DBOwner.UserId = UserStat.UserId
49 ), dLastCheck = NOW()";
50 if (!empty($userId)) $sql .= " WHERE $sql_userId";