'1','admin_flags'=>'A')); if (getStringFromRequest('submit')) { $group_id = getIntFromRequest('group_id'); $groupname = getStringFromRequest('groupname'); $dbname = getStringFromRequest('dbname'); if ($groupname) { $group =& group_get_object_by_name($groupname); if (!$group || !is_object($group)) { exit_error('Error','Could Not Get Group'); } elseif ($group->isError()) { exit_error('Error',$group->getErrorMessage()); } $group_id = $group->getID(); $user =& session_get_user(); if (!$user || !is_object($user)) { exit_error('Error','Could Not Get User'); } elseif ($user->isError()) { exit_error('Error',$u->getErrorMessage()); } $res = db_query(" INSERT INTO prdb_dbs(group_id, dbname, dbusername, dbuserpass, requestdate, dbtype, created_by, state) VALUES ($group_id,'$dbname','$dbname','xxx',".time().",1,".$user->getID().",1) "); if (!$res || db_affected_rows($res) < 1) { $feedback .= _('Error Adding Database') .db_error(); } else { $feedback .= _('Group'). " ".$group->getUnixName()."" ._('added already active database'); } } else { $feedback .= "" ._('Unable to insert already active database.'). ""; } } site_admin_header(array('title'=>_('Site Admin: Groups\' DB Maintenance'))); $res_db = db_query(" SELECT stateid,statename,COUNT(*) AS count FROM prdb_dbs,prdb_states WHERE stateid=state GROUP BY statename,stateid "); echo '
' ._('No databases defined').'
'; } if ($displaydb) { $res_db = db_query(" SELECT statename FROM prdb_states WHERE stateid=".$dbstate." "); $row_db = db_fetch_array($res_db); print '