-function checkQuotas($userId=null) {
- if (empty($userId)) {
- $sql = 'SELECT DatabaseId,Name FROM DB WHERE bEnabled=1';
- } else {
- $sql = sprintf("SELECT DB.DatabaseId,Name FROM DB INNER JOIN DBOwner ON DB.DatabaseId = DBOwner.DatabaseId WHERE bEnabled=1 AND UserId = '%s'", mysql_escape_string($userId));
- }
- $databases = fetchRows(DBSelect($sql),'Name');
- foreach($databases as $db) {
- $DBId = $db['DatabaseId'];
- $arr['dLastCheck'] = 'NOW()';
- $arr['nBytes'] = calcDBSize($db['Name']);
- $sql = sprintf("UPDATE DB %s WHERE DatabaseId = '%s'",
- buildSQLSet($arr),
- mysql_escape_string($DBId));
- DBUpdate($sql);
- }
- $sql = "UPDATE UserStat SET nBytes = (
- SELECT SUM(nBytes)
- FROM DB
- INNER JOIN DBOwner ON DBOwner.DatabaseId = DB.DatabaseId
- WHERE DBOwner.UserId = UserStat.UserId
- AND DB.bEnabled=1
- GROUP BY UserId
- ), dLastCheck = NOW()";
- if (!empty($userId)) $sql .= sprintf(" WHERE UserId = '%s'", mysql_escape_string($userId));
- DBUpdate($sql);
- $sql = "UPDATE UserStat SET nDatabases = (
- SELECT COUNT(*)
- FROM DB
- INNER JOIN DBOwner ON DBOwner.DatabaseId = DB.DatabaseId
- WHERE DBOwner.UserId = UserStat.UserId
- AND DB.bEnabled=1
- GROUP BY UserId
- ), dLastCheck = NOW()";
- if (!empty($userId)) $sql .= sprintf(" WHERE UserId = '%s'", mysql_escape_string($userId));
- DBUpdate($sql);
-}
-