<?php
+/*
+ (c) 2005 Joe Presbrey
+*/
-require_once('joe.lib.php');
+require_once('joe/util.lib.php');
function DBMaster($sql) {
sessTime($sql);
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) {
$DBId = $db['DatabaseId'];
$arr['dLastCheck'] = 'NOW()';
$arr['nBytes'] = calcDBSize($db['Name']);
- $sql = sprintf("UPDATE DB %s WHERE DatabaseId = '%s'",
+ $sql = sprintf("UPDATE DB SET %s WHERE DatabaseId = '%s'",
buildSQLSet($arr),
mysql_escape_string($DBId));
DBUpdate($sql);
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);
}