<?php/**  *  * Project Admin page to manage group's databases  *  * This page allows to request, change password of, and delete database.  * Group may have single database of each type that provided (e.g., mysql,  * pgsql, etc).  *  * SourceForge: Breaking Down the Barriers to Open Source Development  * Copyright 1999-2001 (c) VA Linux Systems  * http://sourceforge.net  *  * @version   $Id: database.php,v 1.11 2001/07/13 20:12:50 dbrogdon Exp $  *  */require_once('pre.php');require_once('common/include/vars.php');require_once('www/project/admin/project_admin_utils.php');session_require(array('group'=>$group_id,'admin_flags'=>'A'));$group =& group_get_object($group_id);exit_assert_object($group, 'Group');if ($createdb) {	//mysql takes issue with database names that have dashes in them - so strip the dashes, replace with ""	//e.g. free-mysql becomes freemysql (it's a workaround) 	//if there is a dash in the groupname	$dbname = str_replace("-", "", $group->getUnixName());		//check there is no name double up - if there is - add an incrementing to the number to the end	$dbname = prdb_namespace_seek($dbname);	$randompw = random_pwgen();	$sql = "INSERT INTO prdb_dbs(group_id,dbname,dbusername,dbuserpass,requestdate,dbtype,created_by,state)			VALUES($group_id,'$dbname','$dbname','$randompw','".time()."',$newdbtypeid,".$LUSER->getID().",2)	";	$res = db_query($sql);	if (!$res || db_affected_rows($res) < 1) {		$feedback .= $Language->getText('project_admin_database','cannot_add').': '.db_error();	} else {			$feedback .= $Language->getText('project_admin_database','database_created');		group_add_history('Created database '.$dbname.' type '.$row_db['dbsoftware'].' ','',$group_id);		}}if ($updatedbrec) {	if ($pw == $pwconfirm) {		//sync new password, and flag it as 'pending (an) update'		$res = db_query("			UPDATE prdb_dbs 			SET dbuserpass = '$pw', 				state = '4'			WHERE dbid = '$dbid' 			AND group_id = '$group_id'		"); 		if (!$res || db_affected_rows($res) < 1) {			$feedback .= "Update failure - ".db_error()."";		} else {			$res = db_query("				SELECT * 				FROM prdb_types 				WHERE dbtypeid='$newdbtypeid'			");			$row_db = db_fetch_array($res);			group_add_history('Updated database - (type: '.$row_db['dbsoftware'].')','',$group_id);		}	} else {		$feedback .= "Operation failed.  Password and Password Confirm are not the same";	}}if ($deletedbconfirm) {	//schedule for deletion	$res = db_query("		UPDATE prdb_dbs 		SET state=3 		WHERE dbid='$dbid'		AND group_id='$group_id'	");	if (!$res || db_affected_rows($res) < 1) {		$feedback .= 'Cannot delete database: '.db_error();	} else {		$feedback .= "Database scheduled for deletion";	}}project_admin_header(array('title'=>$Language->getText('project_admin_database','title').'','group'=>$group_id,'pagename'=>'project_admin_database','sectionvals'=>array(group_getname($group_id))));if ($deletedb == 1) {	print "<hr /><strong><div align=\"center\">".$Language->getText('project_admin_database','confirm_deletion')."[ <a href=\"".$PHP_SELF."?deletedbconfirm=1&amp;group_id=".$group_id."&amp;dbid=$dbid\">'.$Language->getText('project_admin_database','confirm_delete').'</a> ] </div></strong> <hr />";}$res_db = db_query("	SELECT * 	FROM prdb_types 	WHERE dbsoftware NOT IN (		SELECT dbsoftware 		FROM prdb_dbs,prdb_types 		WHERE dbtypeid=dbtype 		AND group_id='$group_id'		AND state IN (1,2,4)	)");if (db_numrows($res_db) > 0) {	print '		<p><strong><span style="text-decoration:underline">'.$Language->getText('project_admin_database','add_new_database').'</span></strong></p>		<p><em>'.$Language->getText('project_admin_database','add_new_database_info').'</em></p>		<p><strong>'.$Language->getText('project_admin_database','database_type').':</strong></p>		<p><form action="'.$PHP_SELF.'" method="post">		<input type="hidden" name="createdb" value="1" />		<input type="hidden" name="group_id" value="'.$group_id.'" />		<select name="newdbtypeid">	';	while ($res_row = db_fetch_array($res_db)) {		print "<option value=\"".$res_row['dbtypeid']."\">".$res_row['dbsoftware']."</option>"; 	}	print '		</select>		&nbsp; <input type="submit" name="Create" value="'.$Language->getText('project_admin_database','create').'" />		</form></p>	';	} else {?><?php echo $Language->getText('project_admin_database','maximum_databases_allocated') ?> <p><?php}$sql="	SELECT * 	FROM prdb_dbs,prdb_states,prdb_types 	WHERE group_id='$group_id' 	AND stateid=state 	AND dbtype=dbtypeid";$res_db = db_query($sql);if (db_numrows($res_db) > 0) {	$title=array();	$title[]=$Language->getText('project_admin_database','db_type');	$title[]=$Language->getText('project_admin_database','state');	$title[]=$Language->getText('project_admin_database','new_password');	$title[]=$Language->getText('project_admin_database','confirm_new');	$title[]=$Language->getText('project_admin_database','operations');	echo $GLOBALS['HTML']->listTableTop($title);	while ($row_db = db_fetch_array($res_db)) {		print '			<tr '.$GLOBALS['HTML']->boxGetAltRowStyle($i++).'>			<td>'.$row_db['dbsoftware'].'</td>			<td>'.$row_db['statename'].'</td>			';		//if database is active or pending update allow the record to be deleted or password changed				if (($row_db['state'] == 1) || ($row_db['state'] == 4) || ($row_db['state'] == 2)) {			print '<form name="dbupdate" method="post" action="'.$PHP_SELF.'?group_id='.$group_id.'">				     <input type="hidden" name="dbid" value="'.$row_db['dbid'].'" />				     <input type="hidden" name="updatedbrec" value="1" />				     <td><input type="text" name="pw" size="8" maxlength="16" /></td>				     <td><input type="text" name="pwconfirm" size="8" maxlength="16" /></td>				     <td>				       <input type="submit" name="submit" value="'.$Language->getText('project_admin_database','update').' />				     </td>				  </form> 			';		} else {			print '				<td>&nbsp;</td>				<td>&nbsp;</td>				<td>&nbsp;</td>			';		}				print '</tr>';	}	echo $GLOBALS['HTML']->listTableBottom();} else {	print '<strong><span style="text-decoration:underline">'.$Language->getText('project_admin_database','current_databases').'</span></strong><p>'.$Language->getText('project_admin_database','no_databases').'</p>';}project_admin_footer(array());?>