login page links fixed

[sql-web.git] / main.php

diff --git a/main.php b/main.php
index e69de29bb2d1d6434b8b29ae775ad8c2e48c5391..8a6ac81f5110d51e67c3cac6809bfc315d1b133b 100644 (file)
--- a/main.php
+++ b/main.php
@@ -0,0 +1,49 @@
+<?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 (!$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';
+
+?>