[phpBT-dev] CVS: phpbt/inc/db mysql.php,1.17,1.18

[Ken T. <ke...@us...>]

Update of /cvsroot/phpbt/phpbt/inc/db
In directory sc8-pr-cvs1:/tmp/cvs-serv1772/inc/db

Modified Files:
	mysql.php 
Log Message:
Multiple statuses can now be set as 'open' or 'closed' -- no longer will 
just BUG_CLOSED show up in most-recently-closed-bugs, etc.

Admin ui allow reassigning open/closed bit to statuses. mysql DB 
touched, rolling to version 4.

Fixed install.php DB_VERSIONing problem.


Index: mysql.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/mysql.php,v
retrieving revision 1.17
retrieving revision 1.18
diff -u -r1.17 -r1.18
--- mysql.php	21 Jun 2003 13:36:30 -0000	1.17
+++ mysql.php	24 Jul 2003 04:47:13 -0000	1.18
@@ -40,7 +40,7 @@
 		TBL_BUG.' using (site_id) group by s.site_id, site_name, sort_order '.
 		'order by %s %s',
 	'admin-list-statuses' => 'select s.status_id, status_name, status_desc, '.
-		'sort_order, count(bug_id) as bug_count '.
+		'sort_order, bug_open, count(bug_id) as bug_count '.
 		'from '.TBL_STATUS.' s left join '. TBL_BUG.' using (status_id) '.
 		'group by s.status_id, status_name, status_desc, sort_order '.
 		'order by %s %s',