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','