Пример #1
0
function folder_get_all_by_page($page = 1)
{
    if (!($db = db::get())) {
        return false;
    }
    if (!is_numeric($page) || $page < 1) {
        $page = 1;
    }
    $offset = calculate_page_offset($page, 10);
    if (!($table_prefix = get_table_prefix())) {
        return array();
    }
    $folder_array = array();
    $sql = "SELECT SQL_CALC_FOUND_ROWS FOLDER.FID, FOLDER.TITLE, ";
    $sql .= "FOLDER.DESCRIPTION, FOLDER.ALLOWED_TYPES, ";
    $sql .= "FOLDER.POSITION, FOLDER.PREFIX, FOLDER.PERM AS FOLDER_PERMS, ";
    $sql .= "IF (FOLDER.PERM IS NULL, 0, 1) AS FOLDER_PERM_COUNT ";
    $sql .= "FROM `{$table_prefix}FOLDER` FOLDER ";
    $sql .= "ORDER BY FOLDER.POSITION ";
    $sql .= "LIMIT {$offset}, 10";
    if (!($result = $db->query($sql))) {
        return false;
    }
    $sql = "SELECT FOUND_ROWS() AS ROW_COUNT";
    if (!($result_count = $db->query($sql))) {
        return false;
    }
    list($folder_count) = $result_count->fetch_row();
    if ($result->num_rows == 0 && $folder_count > 0 && $page > 1) {
        return folder_get_all_by_page($page - 1);
    }
    $fid_array = array();
    while (($folder_data = $result->fetch_assoc()) !== null) {
        $folder_array[$folder_data['FID']] = $folder_data;
        $fid_array[] = $folder_data['FID'];
    }
    folders_get_thread_counts($folder_array, $fid_array);
    return array('folder_array' => $folder_array, 'folder_count' => $folder_count);
}
Пример #2
0
        exit;
    }
}
if (isset($_POST['move_down']) && is_array($_POST['move_down'])) {
    list($fid) = array_keys($_POST['move_down']);
    if (folder_move_down($fid)) {
        header_redirect("admin_folders.php?webtag={$webtag}&page={$page}");
        exit;
    }
}
if (isset($_POST['move_up_disabled']) || isset($_POST['move_down_disabled'])) {
    header_redirect("admin_folders.php?webtag={$webtag}&page={$page}");
    exit;
}
html_draw_top(array('title' => gettext('Admin - Manage Folders'), 'class' => 'window_title', 'main_css' => 'admin.css'));
$folder_array = folder_get_all_by_page($page);
echo "<h1>", gettext("Admin"), html_style_image('separator'), gettext("Manage Folders"), "</h1>\n";
if (isset($error_msg_array) && sizeof($error_msg_array) > 0) {
    html_display_error_array($error_msg_array, '86%', 'center');
} else {
    if (isset($_GET['added'])) {
        html_display_success_msg(gettext("Successfully added new folder"), '86%', 'center');
    } else {
        if (isset($_GET['edited'])) {
            html_display_success_msg(gettext("Successfully edited folder"), '86%', 'center');
        } else {
            if (isset($_GET['deleted'])) {
                html_display_success_msg(gettext("Successfully removed selected folders"), '86%', 'center');
            } else {
                if (sizeof($folder_array['folder_array']) < 1) {
                    html_display_warning_msg(gettext("No existing folders found. To add a folder click the 'Add New' button below."), '86%', 'center');