echo "</caption>\n</table>\n"; echo "<table align='center'><caption>{$test}</caption></table>"; group_form($groupid, $groupname); printfooter(); exit; } } elseif ($_POST) { while (list($key, $val) = each($_POST)) { if (substr($key, 0, 3) == "del") { $delarray = explode("_", $key); delete_group($db, $delarray[1]); } if (substr($key, 0, 3) == "mod") { $modarray = explode("_", $key); echo "</caption>\n</table>\n"; group_form($modarray[1], get_cell($db, "groups", "name", "id", $modarray[1])); printfooter(); exit; } } } echo "</caption>\n"; // print form needed for 'delete' buttons ?> <form name='form' method='post' action='<?php echo $PHP_SELF; ?> ?<?php echo SID; ?> '>
$data['work'] = 'Gruppe wurde angelegt!'; } } elseif ($action == 'delete') { $r_group = db_query("SELECT\n nodelete,\n name\n FROM " . $pref . "group WHERE groupid='" . $_GET['groupid'] . "'"); $group = db_result($r_group); /* WARNING: do NOT remove this check unless you know what youre doing .. */ if ($_GET['groupid'] == $config['default_groupid'] || $_GET['groupid'] == $config['guest_groupid']) { $data['work'] = 'Sorry, you cannot delete this group (Are you trying to delete the default or guest group?).'; } else { $data['work'] = 'You are going to delete "' . $group['name'] . '". Are you sure? (Group members will be removed from group)<br><br><a href="groups.php?action=drop&groupid=' . $_GET['groupid'] . '">Yes</a>'; } } elseif ($action == 'edit') { $r_group = db_query("SELECT\n groupid,\n name,\n accessmask,\n title,\n priority\n FROM " . $pref . "group WHERE groupid='" . $_GET['groupid'] . "'"); $group = db_result($r_group); $data['work'] = '<b>Edit group</b><br><br>'; $data['work'] .= group_form($group, 'update'); } elseif ($action == 'editgroupboard') { $r_group = db_query("SELECT\n groupid,\n name,\n accessmask\n FROM " . $pref . "group WHERE groupid='{$_GET['groupid']}'"); $group = db_result($r_group); $r_board = db_query("SELECT\n board_id,\n board_name\n FROM " . $pref . "board WHERE board_id='{$_GET['boardid']}'"); $board = db_result($r_board); $r_groupboard = db_query("SELECT\n groupid,\n accessmask\n FROM " . $pref . "groupboard WHERE groupid='{$_GET['groupid']}' AND boardid='{$_GET['boardid']}'"); if (db_rows($r_groupboard) > 0) { $groupboard = db_result($r_groupboard); $group['accessmask'] = $groupboard['accessmask']; $data['work'] = groupboard_form($groupboard, $board, false); } else { $data['work'] = groupboard_form($group, $board, false); } } elseif ($action == 'drop') { /* put members into the default group */
while ($user = mysql_fetch_array($r_user)) { $user['groupids'] = substr($user['groupids'], 1, strlen($user['groupids']) - 2); grouplist_remove($user['groupids'], $groupid); $user['groupids'] = ',' . $user['groupids'] . ','; query("UPDATE {$pref}" . "user SET groupids='{$user['groupids']}' WHERE userid={$user['userid']}"); } /* delete the group. */ query("DELETE FROM {$pref}" . "group WHERE groupid='{$groupid}'"); /* delete group/board*/ query("DELETE FROM {$pref}" . "groupboard WHERE groupid='{$groupid}'"); print 'Group has been deleted!'; } elseif ($action == 'edit') { $r_group = query("SELECT groupid, name, accessmask, title, titlepriority FROM {$pref}" . "group WHERE groupid='" . $groupid . "'"); $group = mysql_fetch_array($r_group); print '<b>Edit group</b><br><br>'; group_form($group, 'update'); } elseif ($action == 'editgroupboard') { $r_group = query("SELECT groupid, name, accessmask FROM {$pref}" . "group WHERE groupid='{$groupid}'"); $group = mysql_fetch_array($r_group); $r_board = query("SELECT boardid, boardname FROM {$pref}" . "board WHERE boardid='{$boardid}'"); $board = mysql_fetch_array($r_board); $r_groupboard = query("SELECT groupid, accessmask FROM {$pref}" . "groupboard WHERE groupid='{$groupid}' AND boardid='{$boardid}'"); if (mysql_num_rows($r_groupboard) > 0) { $groupboard = mysql_fetch_array($r_groupboard); $group['accessmask'] = $groupboard['accessmask']; groupboard_form($groupboard, $board, false); } else { groupboard_form($group, $board, false); } } elseif ($action == 'updategroupboard') { if ($useglobal == 'yes') {
show_group_list(); break; case 'add': if (empty($form_libelle)) { group_form($libelle = "", $id = 0); } else { show_group_list(); } break; case 'modif': if ($id) { $q = "SELECT grp_name FROM users_groups WHERE grp_id='{$id}' "; $r = mysql_query($q, $dbh); if (mysql_num_rows($r)) { $row = mysql_fetch_object($r); group_form($row->grp_name, $id); } else { show_group_list(); } } else { show_group_list(); } break; case 'del': if ($id) { $total = 0; $total = mysql_result(mysql_query("select count(1) from users where grp_num='" . $id . "' ", $dbh), 0, 0); if ($total == 0) { $q = "DELETE FROM users_groups WHERE grp_id='{$id}' "; mysql_query($q, $dbh); show_group_list();