2 /*=====================================================================*\
3 || ###################################################################
4 || # Bugdar [#]version[#]
5 || # Copyright ©2002-[#]year[#] Blue Static
7 || # This program is free software; you can redistribute it and/or modify
8 || # it under the terms of the GNU General Public License as published by
9 || # the Free Software Foundation; version [#]gpl[#] of the License.
11 || # This program is distributed in the hope that it will be useful, but
12 || # WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
13 || # or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
16 || # You should have received a copy of the GNU General Public License along
17 || # with this program; if not, write to the Free Software Foundation, Inc.,
18 || # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA
19 || ###################################################################
20 \*=====================================================================*/
22 define('SVN', '$Id$');
24 if (empty($_REQUEST['do']))
26 $_REQUEST['do'] = 'manage
';
29 $focus[ ($_REQUEST['do'] == 'handle
' ? 'showreport
' : 'favorites
') ] = 'focus
';
31 $fetchtemplates = array(
37 require_once('./global.php
');
38 require_once('./includes
/class_sort
.php
');
40 // ###################################################################
42 if ($_REQUEST['do'] == 'handle
')
44 $bugsys->input_clean('bugid
', TYPE_UINT);
45 $bug = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "bug WHERE bugid = " . $bugsys->in['bugid
']);
46 if (!check_bug_permissions($bug))
48 $message->error_permission();
51 if (!can_perform('cansubscribe
', $bug['product
']))
53 $message->error_permission();
56 if ($db->query_first("SELECT * FROM " . TABLE_PREFIX . "favorite WHERE userid = " . $bugsys->userinfo['userid
'] . " AND bugid = " . $bugsys->in['bugid
']))
58 $db->query("DELETE FROM " . TABLE_PREFIX . "favorite WHERE userid = " . $bugsys->userinfo['userid
'] . " AND bugid = " . $bugsys->in['bugid
']);
59 $message->redirect(_('This bug has been removed from your favorites
list.'), "showreport.php?bugid=" . $bugsys->in['bugid
']);
63 $db->query("INSERT INTO " . TABLE_PREFIX . "favorite (userid, bugid) VALUES (" . $bugsys->userinfo['userid
'] . ", " . $bugsys->in['bugid
'] . ")");
64 $message->redirect(_('This bug has been added to your favorites
list.'), "showreport.php?bugid=" . $bugsys->in['bugid
']);
68 // ###################################################################
70 if ($_REQUEST['do'] == 'manage
')
72 if (!can_perform('canviewbugs
'))
74 $message->error_permission();
77 $favorites = $db->query("
78 SELECT favorite.bugid, bug.* FROM " . TABLE_PREFIX . "favorite AS favorite
79 RIGHT JOIN " . TABLE_PREFIX . "bug AS bug
80 ON (favorite.bugid = bug.bugid)
81 WHERE favorite.userid = " . $bugsys->userinfo['userid
'] . "
82 AND (!bug.hidden OR (bug.hidden AND bug.product IN (" . fetch_on_bits('canviewhidden
') . "))" . (can_perform('canviewownhidden
') ? " OR (bug.hidden AND bug.userid = " . $bugsys->userinfo['userid
'] . " AND bug.product IN (" . fetch_on_bits('canviewownhidden
') . "))" : "") . ")
85 if ($db->num_rows($favorites) < 1)
87 $message->error(_('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
.'));
90 $sort = new ListSorter('favorite
');
92 $headers = $sort->constructColumnHeaders(false);
94 while ($bug = $db->fetch_array($favorites))
96 $funct->exec_swap_bg($stylevar['alt_color
'], '');
97 ProcessBugDataForDisplay(&$bug, $funct->bgcolour);
98 $bugs .= $sort->constructRow($bug);
101 eval('$template->flush("' . $template->fetch('favorites') . '");');
104 /*=====================================================================*\
105 || ###################################################################
108 || ###################################################################
109 \*=====================================================================*/