bug: dropping database outside the interface stops interface for all users

[sql-web.git] / main.php

<?php

require_once('mitsql.cfg.php');
require_once('mitsql.lib.php');

define('MAXDBS', 20);

if (!isLoggedIn()) redirect('index');

$err1 = $msg1 = array();

$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.';
		}
	}
	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();
			}
		}
	}
	if (!count($err1))
		$User->refresh();
}

$myDBs = $User->getDBList();

include 'tpl/main.php';

?>