]>
Commit | Line | Data |
---|---|---|
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 | ?> |