\"\" ".$L['Users'].""; $adminmain .= ""; switch($n) { case 'add': $ntitle = sed_import('ntitle','P','TXT'); $ndesc = sed_import('ndesc','P','TXT'); $ncolor = sed_import('ncolor','P','TXT'); $nicon = sed_import('nicon','P','TXT'); $nalias = sed_import('nalias','P','TXT'); $nlevel = sed_import('nlevel','P','LVL'); $nmaxsingle = sed_import('nmaxsingle','P','INT'); $nmaxtotal = sed_import('nmaxtotal','P','INT'); $ncopyrightsfrom = sed_import('ncopyrightsfrom','P','INT'); $ndisabled = sed_import('ndisabled','P','BOL'); $nhidden = sed_import('nhidden','P','BOL'); $ntitle = (empty($ntitle)) ? '???' : $ntitle; $sql = sed_sql_query("INSERT INTO $db_groups (grp_alias, grp_level, grp_disabled, grp_hidden, grp_title, grp_desc, grp_icon, grp_color, grp_pfs_maxfile, grp_pfs_maxtotal, grp_ownerid) VALUES ('".sed_sql_prep($nalias)."', ".(int)$nlevel.", ".(int)$ndisabled.", ".(int)$nhidden.", '".sed_sql_prep($ntitle)."', '".sed_sql_prep($ndesc)."', '".sed_sql_prep($nicon)."', '".sed_sql_prep($ncolor)."', ".(int)$nmaxsingle.", ".(int)$nmaxtotal.", ".(int)$usr['id'].")"); $grp_id = sed_sql_insertid(); $sql = sed_sql_query("SELECT * FROM $db_auth WHERE auth_groupid='".$ncopyrightsfrom."' order by auth_code ASC, auth_option ASC"); while ($row = sed_sql_fetchassoc($sql)) { $sql1 = sed_sql_query("INSERT into $db_auth (auth_groupid, auth_code, auth_option, auth_rights, auth_rights_lock, auth_setbyuserid) VALUES (".(int)$grp_id.", '".$row['auth_code']."', '".$row['auth_option']."', ".(int)$row['auth_rights'].", 0, ".(int)$usr['id'].")"); } sed_auth_reorder(); sed_cache_clear('sed_groups'); sed_redirect(sed_url("admin", "m=users", "", true)); exit; break; case 'edit': if ($a=='update') { $rtitle = sed_import('rtitle','P','TXT'); $rdesc = sed_import('rdesc','P','TXT'); $ricon = sed_import('ricon','P','TXT'); $rcolor = sed_import('rcolor','P','TXT'); $ralias = sed_import('ralias','P','TXT'); $rlevel = sed_import('rlevel','P','LVL'); $rmaxfile = sed_import('rmaxfile','P','INT'); $rmaxtotal = sed_import('rmaxtotal','P','INT'); $rdisabled = ($g<6) ? 0 : sed_import('rdisabled','P','BOL'); $rhidden = ($g==4) ? 0 : sed_import('rhidden','P','BOL'); $rtitle = sed_sql_prep($rtitle); $rdesc = sed_sql_prep($rdesc); $ricon = sed_sql_prep($ricon); $ralias = sed_sql_prep($ralias); $sql = sed_sql_query("UPDATE $db_groups SET grp_title='$rtitle', grp_desc='$rdesc', grp_icon='$ricon', grp_color='$rcolor', grp_alias='$ralias', grp_level='$rlevel', grp_pfs_maxfile='$rmaxfile', grp_pfs_maxtotal='$rmaxtotal', grp_disabled='$rdisabled', grp_hidden='$rhidden' WHERE grp_id='$g'"); sed_cache_clear('sed_groups'); sed_redirect(sed_url("admin", "m=users", "", true)); exit; } elseif ($a=='delete' && $g>5) { $sql = sed_sql_query("DELETE FROM $db_groups WHERE grp_id='$g'"); $sql = sed_sql_query("DELETE FROM $db_auth WHERE auth_groupid='$g'"); $sql = sed_sql_query("DELETE FROM $db_groups_users WHERE gru_groupid='$g'"); sed_auth_clear('all'); sed_cache_clear('sed_groups'); sed_redirect(sed_url("admin", "m=users", "", true)); exit; } $sql = sed_sql_query("SELECT * FROM $db_groups WHERE grp_id='$g'"); sed_die(sed_sql_numrows($sql)==0); $row = sed_sql_fetchassoc($sql); $sql1 = sed_sql_query("SELECT COUNT(*) FROM $db_groups_users WHERE gru_groupid='$g'"); $row['grp_memberscount'] = sed_sql_result($sql1, 0, "COUNT(*)"); $row['grp_title'] = sed_cc($row['grp_title']); $row['grp_desc'] = sed_cc($row['grp_desc']); $row['grp_icon'] = sed_cc($row['grp_icon']); $row['grp_alias'] = sed_cc($row['grp_alias']); $adminpath[] = array(sed_url("admin", "m=users&n=edit&g=".$g), $row['grp_title']); $adminmain .= "
"; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ($g>5 && $row['grp_memberscount']==0) ? "" : ''; $adminmain .= "
".$L['Group']." : ".$L['adm_required']."
".$L['Description']." :
".$L['Icon']." :
".$L['Alias']." :
".$L['adm_color']." :
".$L['adm_maxsizesingle']." :
".$L['adm_maxsizeallpfs']." :
".$L['Enabled']." :"; if ($g>5) { $adminmain .= (!$row['grp_disabled']) ? "".$L['Yes']." ".$L['No'] : "".$L['Yes']." ".$L['No']; } else { $adminmain .= $L['Yes']; } $adminmain .= "
".$L['Hidden']." :"; if ($g!=4) { $adminmain .= ($row['grp_hidden']) ? "".$L['Yes']." ".$L['No'] : "".$L['Yes']." ".$L['No']; } else { $adminmain .= $L['No']; } $adminmain .= "
".$L['Level']." :
".$L['Rights']." :\"\"
".$L['Delete']." :".$out['img_delete']."
"; break; default: $sql = sed_sql_query("SELECT DISTINCT(gru_groupid), COUNT(*) FROM $db_groups_users WHERE 1 GROUP BY gru_groupid"); while ($row = sed_sql_fetchassoc($sql)) { $members[$row['gru_groupid']] = $row['COUNT(*)']; } $sql = sed_sql_query("SELECT DISTINCT(user_maingrp), COUNT(*) FROM $db_users WHERE 1 GROUP BY user_maingrp"); while ($row = sed_sql_fetchassoc($sql)) { $members_main[$row['user_maingrp']] = $row['COUNT(*)']; } $sql = sed_sql_query("SELECT grp_id, grp_title, grp_disabled, grp_hidden FROM $db_groups WHERE 1 order by grp_level DESC, grp_id DESC"); $adminmain .= "
"; $adminmain .= "
"; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; if (sed_sql_numrows($sql)>0) { while ($row = sed_sql_fetchassoc($sql)) { $row['grp_hidden'] = ($row['grp_hidden']) ? '1' : '0'; $members[$row['grp_id']] = (empty($members[$row['grp_id']])) ? '0' : $members[$row['grp_id']]; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; } } $adminmain .= "
#ID".$L['Groups']."".$L['Members']."".$L['Main']."".$L['Enabled']."".$L['Hidden']."".$L['Rights']."
".$row['grp_id']."\"\" "; $adminmain .= "".sed_cc($row['grp_title'])."".$members[$row['grp_id']]."".$members_main[$row['grp_id']]."".$sed_yesno[!$row['grp_disabled']]."".$sed_yesno[$row['grp_hidden']]."\"\"
"; $adminmain .= "
"; $adminmain .= "
"; $adminmain .= "

".$L['addnewentry']." :

"; $adminmain .= "
"; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= ""; $adminmain .= "
".$L['Group']." : ".$L['adm_required']."
".$L['Description']." :
".$L['Icon']." :
".$L['Alias']." :
".$L['adm_color']." :
".$L['adm_maxsizesingle']." :
".$L['adm_maxsizeallpfs']." :
".$L['adm_copyrightsfrom']." :".sed_selectbox_groups(4, 'ncopyrightsfrom', array('5'))." ".$L['adm_required']."
".$L['Level']." :
".$L['Enabled']." :"; $adminmain .= " ".$L['Yes']; $adminmain .= " ".$L['No']; $adminmain .= "
".$L['Hidden']." :"; $adminmain .= " ".$L['Yes']; $adminmain .= " ".$L['No']; $adminmain .= "
"; $adminmain .= "
"; break; } ?>