WHERE group_id = ' . intval($group) . '
LIMIT 1';
if (!($result = $db->sql_query($sql))) {
message_die(GENERAL_ERROR, 'Could not get Group Permissions from ' . EXTENSION_GROUPS_TABLE, '', __LINE__, __FILE__, $sql);
}
$row = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
$auth_p2 = auth_unpack(trim($row['forum_permissions']));
$auth_p = array();
// Generate array for Auth_Pack, delete the chosen ones
for ($i = 0; $i < sizeof($auth_p2); $i++) {
if (!in_array($auth_p2[$i], $delete_forums_list)) {
$auth_p[] = $auth_p2[$i];
}
}
$auth_bitstream = sizeof($auth_p) > 0 ? auth_pack($auth_p) : '';
$sql = 'UPDATE ' . EXTENSION_GROUPS_TABLE . " SET forum_permissions = '" . attach_mod_sql_escape($auth_bitstream) . "' WHERE group_id = " . (int) $group;
if (!($result = $db->sql_query($sql))) {
message_die(GENERAL_ERROR, 'Could not update Permissions', '', __LINE__, __FILE__, $sql);
}
}
// Display the Group Permissions Box for configuring it
if ($e_mode == 'perm' && $group) {
$template->set_filenames(array('perm_box' => 'admin/extension_groups_permissions.tpl'));
$sql = 'SELECT group_name, forum_permissions
FROM ' . EXTENSION_GROUPS_TABLE . '
WHERE group_id = ' . intval($group) . '
LIMIT 1';
if (!($result = $db->sql_query($sql))) {
message_die(GENERAL_ERROR, 'Could not get Group Name from ' . EXTENSION_GROUPS_TABLE, '', __LINE__, __FILE__, $sql);
}
// Delete Forums
if ($delete_forum && $e_mode == 'perm' && $group != -1) {
$delete_forums_list = isset($_POST['entries']) ? $_POST['entries'] : array();
// Get the current Forums
$sql = "SELECT forum_permissions FROM " . EXTENSION_GROUPS_TABLE . "\n\tWHERE group_id = " . intval($group) . " LIMIT 1";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$auth_p2 = auth_unpack(trim($row['forum_permissions']));
$auth_p = array();
// Generate array for Auth_Pack, delete the chosen ones
for ($i = 0; $i < count($auth_p2); $i++) {
if (!in_array($auth_p2[$i], $delete_forums_list)) {
$auth_p[] = $auth_p2[$i];
}
}
$auth_bitstream = count($auth_p) > 0 ? auth_pack($auth_p) : '';
$db->sql_query("UPDATE " . EXTENSION_GROUPS_TABLE . " SET forum_permissions = '" . $auth_bitstream . "' WHERE group_id = " . $group);
}
// Display the Group Permissions Box for configuring it
if ($e_mode == 'perm' && $group != -1) {
$template->set_filenames(array('perm_box' => 'forums/admin/extension_groups_permissions.html'));
$sql = "SELECT group_name, forum_permissions FROM " . EXTENSION_GROUPS_TABLE . "\n\tWHERE group_id = " . intval($group) . " LIMIT 1";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$group_name = $row['group_name'];
$allowed_forums = trim($row['forum_permissions']);
$forum_perm = array();
if ($allowed_forums == '') {
$forum_perm[0]['forum_id'] = 0;
$forum_perm[0]['forum_name'] = $lang['Perm_all_forums'];
} else {
