]> andersk Git - sql-web.git/blob - lib/proc.lib.php
Use nDatabasesHard instead of MAXDBS
[sql-web.git] / lib / proc.lib.php
1 <?php
2 /*
3         (c) 2005 Joe Presbrey
4 */
5
6 require_once('mitsql.lib.php');
7
8 define('MAXDBS', 20);
9
10 class proc {
11         static function newdb(&$User, &$i_newdb) {
12                 // return through $i_newdb the full name of the created db
13                 $msg1 = $err1 = array();
14                 $uname = $User->getUsername();
15                 $uname = str_replace('.','',$uname);
16                 $dbname = $uname.DELIMETER.$i_newdb;
17                 if ($User->isOverQuota() && !isAdmin()) {
18                         $err1[] = 'You are over your quota. You may not add more databases.';
19                 } elseif (count($User->getDBList())>=$User->getDBQuotaHard() && !isAdmin()) {
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                 $i_newdb = $dbname;
33                 return array($msg1, $err1);
34         }
35         static function drop(&$User, $i_drop) {
36                 $msg1 = $err1 = array();
37                 $dropdbs = array_keys($i_drop);
38                 foreach($dropdbs as $dbname) {
39                         if ($User->delDB($dbname)) {
40                                 $msg1[] = 'Database `'.$dbname.'` dropped.';
41                         } else {
42                                 $err1[] = mysql_error();
43                         }
44                 }
45                 return array($msg1, $err1);
46         }
47 }
48
49 ?>
This page took 0.69191 seconds and 5 git commands to generate.