getPermission( session_get_user() ); if (!$perm || !is_object($perm)) { return; } $is_admin=$perm->isAdmin(); if ($is_admin) { echo ($HTML->subMenu( array( 'Admin', 'User Permissions', 'Edit Public Info', 'Project History', 'VHOSTs', 'Edit/Release Files', 'Post Jobs', 'Edit Jobs', 'Edit Multimedia Data', 'Database Admin', 'Stats'), array ( '/project/admin/?group_id='.$group_id, '/project/admin/userperms.php?group_id='.$group_id, '/project/admin/editgroupinfo.php?group_id='.$group_id, '/project/admin/history.php?group_id='.$group_id, '/project/admin/vhost.php?group_id='.$group_id, '/project/admin/editpackages.php?group_id='.$group_id, '/people/createjob.php?group_id='.$group_id, '/people/?group_id='.$group_id, '/project/admin/editimages.php?group_id='.$group_id, '/project/admin/database.php?group_id='.$group_id, '/project/stats/?group_id='.$group_id))); } else { echo ($HTML->subMenu( array( 'Admin', 'Edit/Release Files', 'Stats'), array ( '/project/admin/?group_id='.$group_id, '/project/admin/editpackages.php?group_id='.$group_id, '/project/stats/?group_id='.$group_id))); } } /* Standard footer to be used on all /project/admin/* pages */ function project_admin_footer($params) { site_project_footer($params); } /* The following functions are for the FRS (File Release System) */ /* pop-up box of supported frs statuses */ function frs_show_status_popup ($name='status_id', $checked_val="xzxz") { /* return a pop-up select box of statuses */ global $FRS_STATUS_RES; if (!isset($FRS_STATUS_RES)) { $FRS_STATUS_RES=db_query("SELECT * FROM frs_status"); } return html_build_select_box ($FRS_STATUS_RES,$name,$checked_val,false); } /* pop-up box of supported frs filetypes */ function frs_show_filetype_popup ($name='type_id', $checked_val="xzxz") { /* return a pop-up select box of the available filetypes */ global $FRS_FILETYPE_RES; if (!isset($FRS_FILETYPE_RES)) { $FRS_FILETYPE_RES=db_query("SELECT * FROM frs_filetype"); } return html_build_select_box ($FRS_FILETYPE_RES,$name,$checked_val,true,'Must Choose One'); } /* pop-up box of supported frs processor options */ function frs_show_processor_popup ($name='processor_id', $checked_val="xzxz") { /* return a pop-up select box of the available processors */ global $FRS_PROCESSOR_RES; if (!isset($FRS_PROCESSOR_RES)) { $FRS_PROCESSOR_RES=db_query("SELECT * FROM frs_processor"); } return html_build_select_box ($FRS_PROCESSOR_RES,$name,$checked_val,true,'Must Choose One'); } /* pop-up box of packages:releases for this group */ function frs_show_release_popup ($group_id, $name='release_id', $checked_val="xzxz") { /* return a pop-up select box of releases for the project */ global $FRS_RELEASE_RES; if (!$group_id) { return 'ERROR - GROUP ID REQUIRED'; } else { if (!isset($FRS_RELEASE_RES)) { $FRS_RELEASE_RES=db_query("SELECT frs_release.release_id,(frs_package.name || ' : ' || frs_release.name) ". "FROM frs_release,frs_package ". "WHERE frs_package.group_id='$group_id' ". "AND frs_release.package_id=frs_package.package_id"); echo db_error(); } return html_build_select_box ($FRS_RELEASE_RES,$name,$checked_val,false); } } /* pop-up box of packages for this group */ function frs_show_package_popup ($group_id, $name='package_id', $checked_val="xzxz") { /* return a pop-up select box of packages for this project */ global $FRS_PACKAGE_RES; if (!$group_id) { return 'ERROR - GROUP ID REQUIRED'; } else { if (!isset($FRS_PACKAGE_RES)) { $FRS_PACKAGE_RES=db_query("SELECT package_id,name FROM frs_package WHERE group_id='$group_id'"); echo db_error(); } return html_build_select_box ($FRS_PACKAGE_RES,$name,$checked_val,false); } } /* The following three functions are for group audit trail When changes like adduser/rmuser/change status are made to a group, a row is added to audit trail using group_add_history() */ function group_get_history ($group_id=false) { $sql="SELECT group_history.field_name,group_history.old_value,group_history.date,users.user_name ". "FROM group_history,users ". "WHERE group_history.mod_by=users.user_id ". "AND group_id='$group_id' ORDER BY group_history.date DESC"; return db_query($sql); } function group_add_history ($field_name,$old_value,$group_id) { $group=group_get_object($group_id); $group->addHistory($field_name,$old_value); } /* Nicely html-formatted output of this group's audit trail */ function show_grouphistory ($group_id) { /* show the group_history rows that are relevant to this group_id */ global $sys_datefmt; $result=group_get_history($group_id); $rows=db_numrows($result); if ($rows > 0) { echo '
'; $title_arr=array(); $title_arr[]='Field'; $title_arr[]='Old Value'; $title_arr[]='Date'; $title_arr[]='By'; echo $GLOBALS['HTML']->listTableTop ($title_arr); for ($i=0; $i < $rows; $i++) { $field=db_result($result, $i, 'field_name'); echo '