X-Git-Url: http://andersk.mit.edu/gitweb/sql-web.git/blobdiff_plain/9835a21d68b12f5883c9508695ed8e404a1c671b:/lib/joe/dbaccess.lib.php..ca43eea9776f35a5c09331524c60b71d120fb203:/lib/joe/mysql.lib.php

diff --git a/lib/joe/dbaccess.lib.php b/lib/joe/mysql.lib.php
similarity index 51%
rename from lib/joe/dbaccess.lib.php
rename to lib/joe/mysql.lib.php
index 76a3a34..bc52148 100644
--- a/lib/joe/dbaccess.lib.php
+++ b/lib/joe/mysql.lib.php
@@ -52,42 +52,4 @@ function calcDBSize($tdb) {
    }
 }
 
-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);
-}
-
 ?>