changed NATURAL JOINs to INNERs to avoid conflicting keys

[sql-web.git] / main.php

<?php

require_once('mitsql.cfg.php');
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->addDB($dbname)==false) {
			$err[] = mysql_error();
		} else {
			$User->refresh();
			$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';

?>