GetUserOperations(); $adminuser = ($userops->UserInGroup($userid,1) || $userid == 1); $group_name = ''; $message = ''; include_once("header.php"); $db = $gCms->GetDb(); $smarty = $gCms->GetSmarty(); if (!$access) { die('permission denied'); } if( isset($_POST['filter']) ) { $disp_group = $_POST['groupsel']; set_preference($userid,'changegroupassign_group',$disp_group); } $disp_group = get_preference($userid,'changegroupassign_group',-1); // always display the group pull down $groupops = $gCms->GetGroupOperations(); $tmp = new stdClass(); $tmp->name = lang('all_groups'); $tmp->id=-1; $allgroups = array($tmp); $sel_groups = array($tmp); $group_list = $groupops->LoadGroups(); $sel_group_ids = array(); foreach( $group_list as $onegroup ) { if( $onegroup->id == 1 && $adminuser == false ) { continue; } $allgroups[] = $onegroup; if( $disp_group == -1 || $disp_group == $onegroup->id ) { $sel_groups[] = $onegroup; $sel_group_ids[] = $onegroup->id; } } $smarty->assign('group_list',$sel_groups); $smarty->assign('allgroups',$allgroups); if ($submitted == 1) { // we have group permissions $now = $db->DbTimeStamp(time()); $iquery = "INSERT INTO ".cms_db_prefix(). "group_perms (group_perm_id, group_id, permission_id, create_date, modified_date) VALUES (?,?,?,$now,$now)"; $groups = array(); foreach( $_POST as $key=>$value ) { if (strpos($key,"pg") == 0 && strpos($key,"pg") !== false) { $keyparts = explode('_',$key); if ($keyparts[2] != '1' && $value == '1') { if( !in_array($keyparts[2],$groups) ) { $groups[] = $keyparts[2]; } } } } $selected_groups = unserialize(base64_decode($_POST['sel_groups'])); $query = 'DELETE FROM '.cms_db_prefix().'group_perms WHERE group_id IN ('.implode(',',$selected_groups).')'; $db->Execute($query); foreach ($_POST as $key=>$value) { if (strpos($key,"pg") == 0 && strpos($key,"pg") !== false) { $keyparts = explode('_',$key); if ($keyparts[2] != '1' && $value == '1') { $new_id = $db->GenID(cms_db_prefix()."group_perms_seq"); $result = $db->Execute($iquery, array($new_id,$keyparts[2],$keyparts[1])); if( !$result ) { echo "FATAL: ".$db->ErrorMsg().'
'.$db->sql; exit(); } } } } // put mention into the admin log audit($userid, 'Permission Group ID: '.$userid, 'Changed'); $message = lang('permissionschanged'); $gCms->clear_cached_files(); } $query = "SELECT p.permission_id, p.permission_text, up.group_id FROM ". cms_db_prefix()."permissions p LEFT JOIN ".cms_db_prefix(). "group_perms up ON p.permission_id = up.permission_id ORDER BY p.permission_text"; $result = $db->Execute($query); $perm_struct = array(); while($result && $row = $result->FetchRow()) { if (isset($perm_struct[$row['permission_id']])) { $str = &$perm_struct[$row['permission_id']]; $str->group[$row['group_id']]=1; } else { $thisPerm = new stdClass(); $thisPerm->group = array(); if (!empty($row['group_id'])) { $thisPerm->group[$row['group_id']] = 1; } $thisPerm->id = $row['permission_id']; $thisPerm->name = $row['permission_text']; $perm_struct[$row['permission_id']] = $thisPerm; } } $smarty->assign_by_ref('perms',$perm_struct); $smarty->assign('cms_secure_param_name',CMS_SECURE_PARAM_NAME); $smarty->assign('cms_user_key',$_SESSION[CMS_USER_KEY]); $smarty->assign('form_start','
'); $smarty->assign('filter_action','changegroupperm.php'); $smarty->assign('form_end','
'); $smarty->assign('disp_group',$disp_group); $smarty->assign('apply',lang('apply')); $smarty->assign('title_permission',lang('permission')); $smarty->assign('selectgroup',lang('selectgroup')); $smarty->assign('hidden2',''); $smarty->assign('hidden',''); $smarty->assign('submit',''); $smarty->assign('cancel',''); # begin output if( !empty($message) ) { echo $themeObject->ShowMessage($message); } echo '
'.$themeObject->ShowHeader('grouppermissions',array($group_name)); echo $smarty->fetch('changegroupperm.tpl'); echo '
'; echo '

« '.lang('back').'

'; include_once("footer.php"); # vim:ts=4 sw=4 noet ?>