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));
+ if (is_array($userId)) {
+ $sql_userId = sprintf("UserId IN ('%s')", implode("','",array_map('mysql_escape_string',$userId)));
+ } elseif (is_numeric($userId)) {
+ $sql_userId = sprintf("UserId = '%s'", mysql_escape_string($userId));
+ } else {
+ die('userId parameter error in checkQuotas');
+ }
+ $sql = sprintf("SELECT DB.DatabaseId,Name FROM DB INNER JOIN DBOwner ON DB.DatabaseId = DBOwner.DatabaseId WHERE bEnabled=1 AND %s", $sql_userId);
}
$databases = fetchRows(DBSelect($sql),'Name');
foreach($databases as $db) {
AND DB.bEnabled=1
GROUP BY UserId
), dLastCheck = NOW()";
- if (!empty($userId)) $sql .= sprintf(" WHERE UserId = '%s'", mysql_escape_string($userId));
+ if (!empty($userId)) $sql .= " WHERE $sql_userId";
DBUpdate($sql);
$sql = "UPDATE UserStat SET nDatabases = (
SELECT COUNT(*)
AND DB.bEnabled=1
GROUP BY UserId
), dLastCheck = NOW()";
- if (!empty($userId)) $sql .= sprintf(" WHERE UserId = '%s'", mysql_escape_string($userId));
+ if (!empty($userId)) $sql .= " WHERE $sql_userId";
DBUpdate($sql);
}