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();
