user interaction moved to proc.lib.php

[sql-web.git] / main.php

diff --git a/main.php b/main.php
index 8fa2c3da943e453e456bf31b8459e4f97c942f39..8d60aec421b523e70044a6fbdf3273941dde5622 100644 (file)
--- a/main.php
+++ b/main.php
@@ -2,8 +2,7 @@
 
 require_once('mitsql.cfg.php');
 require_once('mitsql.lib.php');
-
-define('MAXDBS', 20);
+require_once('proc.lib.php');
 
 if (!isLoggedIn()) redirect('index');
 
@@ -13,32 +12,10 @@ $User = new User($Login->getUserID());
 
 if (isPost()) {
        if (isset($i_newdb)) {
-               $dbname = $User->getUsername().DELIMETER.$i_newdb;
-               if ($User->isOverQuota()) {
-                       $err1[] = 'You are over your quota. You may not add more databases.';
-               } elseif (count($User->getDBList())>MAXDBS) {
-                       $err1[] = 'You have too many databases. You may not add more databases.';
-               } elseif (empty($i_newdb)) {
-                       $err1[] = 'Your database name may not be empty.';
-               } elseif (!$User->addDB($dbname)) {
-                       if (mysql_error()) {
-                               $err1[] = mysql_error();
-                       } else {
-                               $err1[] = 'Database already exists.';
-                       }
-               } else {
-                       $msg1[] = 'Database `'.$dbname.'` created.';
-               }
+               list($msg1, $err1) = proc::newdb($User, $i_newdb);
        }
        if (isset($i_drop)) {
-               $dropdbs = array_keys($i_drop);
-               foreach($dropdbs as $dbname) {
-                       if ($User->delDB($dbname)) {
-                               $msg1[] = 'Database `'.$dbname.'` dropped.';
-                       } else {
-                               $err1[] = mysql_error();
-                       }
-               }
+               list($msg1, $err1) = proc::drop($User, $i_drop);
        }
        if (!count($err1))
                $User->refresh();