check quotas function

[sql-web.git] / main.php

diff --git a/main.php b/main.php
index 775fbda243922b8f63c481d6b170855d902bdeb9..90bf2ea91a43798cd61bc76c4fb758e1e991dacf 100644 (file)
--- a/main.php
+++ b/main.php
@@ -9,12 +9,31 @@ $User = new User($Login->getUserID());
 
 if (isPost()) {
        if (isset($i_newdb)) {
-               if ($User->addDB($User->getUsername().DELIMETER.$i_newdb)==false) {
+               $dbname = $User->getUsername().DELIMETER.$i_newdb;
+               if ($User->isOverQuota()) {
+                       $err[] = 'You are over your quota. You may not add databases.';
+               } elseif ($User->addDB($dbname)==false) {
                        $err[] = mysql_error();
+               } else {
+                       $msg[] = 'Database `'.$dbname.'` created.';
                }
        }
+       if (isset($i_drop)) {
+               $dropdbs = array_keys($i_drop);
+               foreach($dropdbs as $dbname) {
+                       if ($User->delDB($dbname)) {
+                               $msg[] = 'Database `'.$dbname.'` dropped.';
+                       } else {
+                               $err[] = mysql_error();
+                       }
+               }
+       }
+       if (!count($err))
+               $User->refresh();
 }
 
+$myDBs = $User->getDBList();
+
 include 'tpl/main.php';
 
 ?>