]> andersk Git - sql-web.git/blob - lib/proc.lib.php
user interaction moved to proc.lib.php
[sql-web.git] / lib / proc.lib.php
1 <?php
2
3 require_once('mitsql.lib.php');
4
5 define('MAXDBS', 20);
6
7 class proc {
8         static function newdb(&$User, $i_newdb) {
9                 $msg1 = $err1 = array();
10                 $dbname = $User->getUsername().DELIMETER.$i_newdb;
11                 if ($User->isOverQuota()) {
12                         $err1[] = 'You are over your quota. You may not add more databases.';
13                 } elseif (count($User->getDBList())>MAXDBS) {
14                         $err1[] = 'You have too many databases. You may not add more databases.';
15                 } elseif (empty($i_newdb)) {
16                         $err1[] = 'Your database name may not be empty.';
17                 } elseif (!$User->addDB($dbname)) {
18                         if (mysql_error()) {
19                                 $err1[] = mysql_error();
20                         } else {
21                                 $err1[] = 'Database already exists.';
22                         }
23                 } else {
24                         $msg1[] = 'Database `'.$dbname.'` created.';
25                 }
26                 return array($msg1, $err1);
27         }
28         static function drop(&$User, $i_drop) {
29                 $msg1 = $err1 = array();
30                 $dropdbs = array_keys($i_drop);
31                 foreach($dropdbs as $dbname) {
32                         if ($User->delDB($dbname)) {
33                                 $msg1[] = 'Database `'.$dbname.'` dropped.';
34                         } else {
35                                 $err1[] = mysql_error();
36                         }
37                 }
38                 return array($msg1, $err1);
39         }
40 }
41
42 ?>
This page took 0.031346 seconds and 5 git commands to generate.