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