$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') {
query("DELETE FROM {$pref}" . "groupboard WHERE groupid='{$groupid}' AND boardid='{$boardid}'");
print 'Settings have been saved.<br><br><a href="groups.php?action=boardpermtable&session=' . $session . '&groupid=' . $groupid . '">Back</a>';
} else {
// delete old perms, no matter whether they exist or not ..
query("DELETE FROM {$pref}" . "groupboard WHERE groupid='{$groupid}' AND boardid='{$boardid}'");
/* create accessmask */
$accessmask = str_repeat("0", count($permission));
while (list($k, $v) = each($permission)) {
$accessmask[$k] = $v == "yes" ? "1" : "0";
}
// insert new
query("INSERT INTO {$pref}" . "groupboard (groupid, boardid, accessmask) VALUES ('{$groupid}', '{$boardid}', '{$accessmask}')");
$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 */
/*query("UPDATE $pref"."user SET groupid=$config[default_groupid] WHERE groupid='$groupid'");*/
$r_user = db_query("SELECT\n user_id,\n groupids\n FROM " . $pref . "user WHERE INSTR(groupids, ',{$_GET['groupid']},')>0");
while ($user = db_result($r_user)) {
$user['groupids'] = substr($user['groupids'], 1, strlen($user['groupids']) - 2);
grouplist_remove($user['groupids'], $_GET['groupid']);
$user['groupids'] = ',' . $user['groupids'] . ',';
db_query("UPDATE " . $pref . "user SET\n groupids='{$user['groupids']}'\n WHERE userid={$user['user_id']}");
}
/* delete the group. */
db_query("DELETE FROM " . $pref . "group WHERE groupid='{$_GET['groupid']}'");
/* delete group/board*/
db_query("DELETE FROM " . $pref . "groupboard WHERE groupid='{$_GET['groupid']}'");
