X-Git-Url: http://andersk.mit.edu/gitweb/sql-web.git/blobdiff_plain/dc478ec893c32ad501d678f9f82506de091e6b0b..9c70b48184fc9dc34b9725daa6b3b050fd49e6d0:/main.php

diff --git a/main.php b/main.php
index b0bd1da..90bf2ea 100644
--- a/main.php
+++ b/main.php
@@ -5,6 +5,35 @@ require_once('mitsql.lib.php');
 
 if (!isLoggedIn()) redirect('index');
 
+$User = new User($Login->getUserID());
+
+if (isPost()) {
+	if (isset($i_newdb)) {
+		$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';
 
 ?>