X-Git-Url: http://andersk.mit.edu/gitweb/sql-web.git/blobdiff_plain/5852fbc4ac1301741cfeca45a3fa6959261c57cb..2f91d7fe0fd4b4155a4486b653449dc0fe630c10:/main.php diff --git a/main.php b/main.php index 8fa2c3d..8d60aec 100644 --- 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();