check quotas code

[sql-web.git] / test.php

diff --git a/test.php b/test.php
index a633147b657ffc6752d40e9ebc57ea90814e99e5..6109019462b50d69985cfea536546bf39490c671 100755 (executable)
--- a/test.php
+++ b/test.php
@@ -6,8 +6,7 @@ require_once('mitsql.lib.php');
 include 'tpl/head.php';
 
 function getManagedDBs($owner=null) {
-//     $databases = array_keys(fetchRows(DBSelect('SHOW DATABASES'),'Database'));
-       $databases = array_keys(fetchRows(DBSelect('SELECT Name FROM DB'),'Name'));
+       $databases = array_keys(fetchRows(DBSelect('SELECT Name FROM DB WHERE bEnabled=1'),'Name'));
        $owners = array();
        foreach($databases as $database) {
                if (stristr($database, DELIMETER)) {
@@ -21,13 +20,28 @@ function getManagedDBs($owner=null) {
        return $owners;
 }
 
+function checkQuotas() {
+       $databases = fetchRows(DBSelect('SELECT DatabaseId,Name FROM DB WHERE bEnabled=1'),'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);
+       }
+}
+
 /*
 $g = getManagedDBs();
 print_r($g);
-*/
 
 $User = new User($Login->getUserId());
 print_r($User->getDBList());
+*/
+
+checkQuotas();
 
 include 'tpl/foot.php';
 ?>