inputClean('bugid', TYPE_UINT); $bug = $db->queryFirst("SELECT * FROM " . TABLE_PREFIX . "bug WHERE bugid = " . $input->in['bugid']); if (!check_bug_permissions($bug)) { $message->errorPermission(); } if (!can_perform('cansubscribe', $bug['product'])) { $message->errorPermission(); } if ($db->queryFirst("SELECT * FROM " . TABLE_PREFIX . "favorite WHERE userid = " . bugdar::$userinfo['userid'] . " AND bugid = " . $input->in['bugid'])) { $db->query("DELETE FROM " . TABLE_PREFIX . "favorite WHERE userid = " . bugdar::$userinfo['userid'] . " AND bugid = " . $input->in['bugid']); $message->redirect(T('This bug has been removed from your favorites list.'), "showreport.php?bugid=" . $input->in['bugid']); } else { $db->query("INSERT INTO " . TABLE_PREFIX . "favorite (userid, bugid) VALUES (" . bugdar::$userinfo['userid'] . ", " . $input->in['bugid'] . ")"); $message->redirect(T('This bug has been added to your favorites list.'), "showreport.php?bugid=" . $input->in['bugid']); } } // ################################################################### if ($_REQUEST['do'] == 'manage') { if (!can_perform('canviewbugs')) { $message->errorPermission(); } $favorites = $db->query(" SELECT favorite.bugid, bug.* FROM " . TABLE_PREFIX . "favorite AS favorite RIGHT JOIN " . TABLE_PREFIX . "bug AS bug ON (favorite.bugid = bug.bugid) WHERE favorite.userid = " . bugdar::$userinfo['userid'] . " AND (!bug.hidden OR (bug.hidden AND bug.product IN (" . fetch_on_bits('canviewhidden') . "))" . (can_perform('canviewownhidden') ? " OR (bug.hidden AND bug.userid = " . bugdar::$userinfo['userid'] . " AND bug.product IN (" . fetch_on_bits('canviewownhidden') . "))" : "") . ") "); if ($favorites->size() < 1) { $message->error(T('You do not have any favorites in your list. To add a bug to your list, while viewing the report, click the [Add to Favorites] link next to the bug\'s ID.')); } $sort = new ListSorter('favorite'); $headers = $sort->constructColumnHeaders(false); foreach ($favorites as $bug) { BSFunctions::swap_css_classes('altcolor', ''); $bug = ProcessBugDataForDisplay($bug, BSFunctions::$cssClass); $bugs .= $sort->constructRow($bug); } $tpl = new BSTemplate('favorites'); $tpl->vars = array( 'bugs' => $bugs, 'headers' => $headers ); $tpl->evaluate()->flush(); } ?>