From: Gianluca S. <gi...@us...> - 2007-07-16 17:31:37
|
Update of /cvsroot/mantisbt/mantisbt In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv26447 Modified Files: Tag: BRANCH_1_0_0 summary_page.php Log Message: Fix 8024: Longest open issue not restricted to selected project Index: summary_page.php =================================================================== RCS file: /cvsroot/mantisbt/mantisbt/summary_page.php,v retrieving revision 1.46 retrieving revision 1.46.10.1 diff -u -d -r1.46 -r1.46.10.1 --- summary_page.php 15 Aug 2005 20:55:44 -0000 1.46 +++ summary_page.php 16 Jul 2007 17:30:16 -0000 1.46.10.1 @@ -54,7 +54,7 @@ $query = "SELECT b.id, b.date_submitted, b.last_updated, MAX(h.date_modified) as hist_update, b.status FROM $t_bug_table b LEFT JOIN $t_history_table h ON b.id = h.bug_id AND h.type=0 AND h.field_name='status' AND h.new_value='$t_resolved' - WHERE b.status >='$t_resolved' + WHERE b.status >='$t_resolved' AND $specific_where GROUP BY b.id, b.status, b.date_submitted, b.last_updated ORDER BY b.id ASC"; $result = db_query( $query ); |