$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']}'");