4 * Site Admin page for maintaining groups'databases
7 * - browse aggregate numbers of databases of specific type (active,
9 * - list all databases of given type
10 * - edit some database (by going to group's DB Admin page)
11 * - register existing database in system
13 * SourceForge: Breaking Down the Barriers to Open Source Development
14 * Copyright 1999-2001 (c) VA Linux Systems
15 * http://sourceforge.net
22 require_once('pre.php');
23 require_once('www/admin/admin_utils.php');
25 session_require(array('group'=>'1','admin_flags'=>'A'));
30 $group_id = seek_gid($groupname);
34 $group =& group_get_object($group_id);
35 exit_assert_object($group, 'Group');
37 $user =& session_get_user();
38 exit_assert_object($user, 'User');
41 INSERT INTO prdb_dbs(group_id, dbname, dbusername, dbuserpass, requestdate, dbtype, created_by, state)
42 VALUES ($group_id,'$dbname','$dbname','xxx',".time().",1,".$user->getID().",1)
45 if (!$res || db_affected_rows($res) < 1) {
46 $feedback .= 'Error adding databse: '.db_error();
48 $feedback .= "Group <i>".$group->getUnixName()."</i> added already active database";
53 $feedback .= "<b>Unable to insert already active database..</b>";
60 site_admin_header(array('title'=>"Site Admin: Groups' DB Maintanance"));
63 SELECT stateid,statename,COUNT(*)
64 FROM prdb_dbs,prdb_states
66 GROUP BY statename,stateid
69 echo '<h3>Statistics for Project Databases</h3>';
71 if (db_numrows($res_db) > 0) {
73 echo '<table width="50%"><tr><td>';
77 echo html_build_list_table_top($title);
79 while ($row_db = db_fetch_array($res_db)) {
81 print '<tr><td align="center"><a href="'.$PHP_SELF.'?displaydb=1&dbstate='.$row_db['stateid'].'">'.$row_db['statename'].'</a></td><td align="center">'.$row_db['count'].'</td></tr>';
86 echo '</td></tr></table>';
89 echo '<p>No databases defined</p>';
98 WHERE stateid=".$dbstate."
101 $row_db = db_fetch_array($res_db);
103 print '<hr><h3>Displaying Databases of Type: '.$row_db['statename'].' </h3>';
108 WHERE state=".$dbstate."
112 while ($row_db = db_fetch_array($res_db)) {
114 print '<li><a href="/project/admin/database.php?group_id='.$row_db['group_id'].'">'.$row_db['dbname']."</a>";
126 <h3>Add an already active database</h3>
128 <form name="madd" method="post" action="<?php echo $PHP_SELF; ?>">
133 <td>Group Unix Name</td>
134 <td><input type="text" name="groupname"></td>
138 <td>Database Name</td>
139 <td><input type="text" name="dbname"></td>
143 <input type="submit" name="submit" value="Add">
148 site_admin_footer(array());