]> andersk Git - sql-web.git/blob - lib/proc.lib.php
bug fix: signup/db-create for class lockers
[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                 // return through $i_newdb the full name of the created db
10                 $msg1 = $err1 = array();
11                 $uname = $User->getUsername();
12                 $uname = str_replace('.','',$uname);
13                 $dbname = $uname.DELIMETER.$i_newdb;
14                 if ($User->isOverQuota()) {
15                         $err1[] = 'You are over your quota. You may not add more databases.';
16                 } elseif (count($User->getDBList())>MAXDBS) {
17                         $err1[] = 'You have too many databases. You may not add more databases.';
18                 } elseif (empty($i_newdb)) {
19                         $err1[] = 'Your database name may not be empty.';
20                 } elseif (!$User->addDB($dbname)) {
21                         if (mysql_error()) {
22                                 $err1[] = mysql_error();
23                         } else {
24                                 $err1[] = 'Database already exists.';
25                         }
26                 } else {
27                         $msg1[] = 'Database `'.$dbname.'` created.';
28                 }
29                 $i_newdb = $dbname;
30                 return array($msg1, $err1);
31         }
32         static function drop(&$User, $i_drop) {
33                 $msg1 = $err1 = array();
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                 return array($msg1, $err1);
43         }
44 }
45
46 ?>
This page took 0.038663 seconds and 5 git commands to generate.