]> andersk Git - sql-web.git/blob - main.php
8fa2c3da943e453e456bf31b8459e4f97c942f39
[sql-web.git] / main.php
1 <?php
2
3 require_once('mitsql.cfg.php');
4 require_once('mitsql.lib.php');
5
6 define('MAXDBS', 20);
7
8 if (!isLoggedIn()) redirect('index');
9
10 $err1 = $msg1 = array();
11
12 $User = new User($Login->getUserID());
13
14 if (isPost()) {
15         if (isset($i_newdb)) {
16                 $dbname = $User->getUsername().DELIMETER.$i_newdb;
17                 if ($User->isOverQuota()) {
18                         $err1[] = 'You are over your quota. You may not add more databases.';
19                 } elseif (count($User->getDBList())>MAXDBS) {
20                         $err1[] = 'You have too many databases. You may not add more databases.';
21                 } elseif (empty($i_newdb)) {
22                         $err1[] = 'Your database name may not be empty.';
23                 } elseif (!$User->addDB($dbname)) {
24                         if (mysql_error()) {
25                                 $err1[] = mysql_error();
26                         } else {
27                                 $err1[] = 'Database already exists.';
28                         }
29                 } else {
30                         $msg1[] = 'Database `'.$dbname.'` created.';
31                 }
32         }
33         if (isset($i_drop)) {
34                 $dropdbs = array_keys($i_drop);
35                 foreach($dropdbs as $dbname) {
36                         if ($User->delDB($dbname)) {
37                                 $msg1[] = 'Database `'.$dbname.'` dropped.';
38                         } else {
39                                 $err1[] = mysql_error();
40                         }
41                 }
42         }
43         if (!count($err1))
44                 $User->refresh();
45 }
46
47 $myDBs = $User->getDBList();
48
49 include 'tpl/main.php';
50
51 ?>
This page took 0.025357 seconds and 3 git commands to generate.