error_permission(); } $sort = new ListSorter('index'); // ################################################################### $pagination = new Pagination('p', 'pp'); $count = $db->query_first(" SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "bug WHERE (!hidden OR (hidden AND product IN (" . fetch_on_bits('canviewhidden') . "))" . (can_perform('canviewownhidden') ? " OR (hidden AND userid = " . $bugsys->userinfo['userid'] . " AND product IN (" . fetch_on_bits('canviewownhidden') . "))" : "") . ") AND product IN (" . fetch_on_bits('canviewbugs') . ")" . (($bugsys->options['hidestatuses'] OR isset($bugsys->userinfo['hidestatuses'])) ? " AND status NOT IN (" . ($bugsys->userinfo['hidestatuses'] != '' ? $bugsys->userinfo['hidestatuses'] : $bugsys->options['hidestatuses']) . ")" : "") ); $pagination->total = $count['count']; $pagination->split_pages(); $bugs_fetch = $db->query($sort->fetch_sql_query(null, $pagination->fetch_limit($pagination->page - 1) . ", " . $pagination->perpage)); while ($bug = $db->fetch_array($bugs_fetch)) { $funct->exec_swap_bg($stylevar['alt_color'], ''); ProcessBugDataForDisplay(&$bug, $funct->bgcolour); eval('$bugs .= "' . $template->fetch('trackerhome_bits') . '";'); } $db->free_result($bugs_fetch); $order = $sort->fetch_display_array('p=' . $pagination->page . '&pp=' . $pagination->perpage); $show['pagenav'] = (($pagination->pagecount > 1) ? true : false); $pagenav = $pagination->construct_page_nav($sort->fetch_sort_link($sort->sortkey)); eval('$template->flush("' . $template->fetch('trackerhome') . '");'); /*=====================================================================*\ || ################################################################### || # $HeadURL$ || # $Id$ || ################################################################### \*=====================================================================*/ ?>