errorPermission(); } $sort = new ListSorter('index'); require_once 'includes/pagination.php'; $pagination = new Pagination(); $pagination->processIncomingData(); // ################################################################### $count = $db->queryFirst(" 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 = " . bugdar::$userinfo['userid'] . " AND product IN (" . fetch_on_bits('canviewownhidden') . "))" : "") . ") AND product IN (" . fetch_on_bits('canviewbugs') . ")" . ((bugdar::$options['hidestatuses'] OR isset(bugdar::$userinfo['hidestatuses'])) ? " AND status NOT IN (" . (bugdar::$userinfo['hidestatuses'] != '' ? bugdar::$userinfo['hidestatuses'] : bugdar::$options['hidestatuses']) . ")" : "") ); if (!$count['count']) { $message->error(T('There are no bugs to display. This could be because you do not have permission to view bugs, or there may be none in the database.')); } $pagination->setTotal($count['count']); $pagination->splitPages(); $bugs_fetch = $db->query($sort->fetchSqlQuery(null, $pagination->fetchLimit($pagination->getPage() - 1) . ", " . $pagination->getPerPage())); foreach ($bugs_fetch as $bug) { BSFunctions::swap_css_classes('altcolor', ''); $bug = ProcessBugDataForDisplay($bug, BSFunctions::$cssClass); $bugs .= $sort->constructRow($bug); } $bugs_fetch->free(); $columnHeads = $sort->constructColumnHeaders(true, 'p=' . $pagination->page . '&pp=' . $pagination->perpage); $show['pagenav'] = ($pagination->getPageCount() > 1); $tpl = new BSTemplate('trackerhome'); $tpl->vars = array( 'columnHeads' => $columnHeads, 'bugs' => $bugs, 'pagenav' => $pagination->constructPageNav($sort->fetchSortLink($sort->sortkey)) ); $tpl->evaluate()->flush(); ?>