git-svn-id: svn://presbrey.mit.edu/php/php@100 a142d4bd-2cfb-0310-9673-cb33a7e74f58

[sql-web.git] / 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 76a3a3437a735a2985fceb5589aba39125fedfa3..bc5214820b0b72c7e1aa3a1398d05017281a6ddb 100644 (file)
--- 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);
-}
-
 ?>