[phpBT-dev] CVS: phpbt/inc/db mysql.php,1.19,1.20 oci8.php,1.16,1.17

[Ulf E. <ulf...@us...>]

Update of /cvsroot/phpbt/phpbt/inc/db
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv1224/inc/db

Modified Files:
	mysql.php oci8.php 
Log Message:
Patch 989398 - Sequence and assignable field fixes, by Antti Merenluoto


Index: mysql.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/mysql.php,v
retrieving revision 1.19
retrieving revision 1.20
diff -u -r1.19 -r1.20
--- mysql.php	25 Oct 2004 12:07:01 -0000	1.19
+++ mysql.php	25 May 2005 18:04:48 -0000	1.20
@@ -5,7 +5,7 @@
 		'from '.TBL_AUTH_GROUP.' ag '.
 		'left join '.TBL_USER_GROUP.' ug using (group_id) '.
 		'left join '.TBL_AUTH_USER.' using (user_id) '.
-		'group by ag.group_id, group_name, locked '.
+		'group by ag.group_id, group_name, locked, assignable '.
 		'order by %s %s',
 	'admin-list-oses' => 'select s.os_id, os_name, regex, sort_order, '.
 		'count(bug_id) as bug_count '.

Index: oci8.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/oci8.php,v
retrieving revision 1.16
retrieving revision 1.17
diff -u -r1.16 -r1.17
--- oci8.php	25 Oct 2004 12:07:01 -0000	1.16
+++ oci8.php	25 May 2005 18:04:48 -0000	1.17
@@ -2,10 +2,10 @@
 
 $QUERY = array(
 	'admin-list-groups' => 'select ag.group_id, ag.group_name, ag.locked, '.
-		'count(ug.group_id) as count, asssignable '.
+		'count(ug.group_id) as count, assignable '.
 		'from '.TBL_AUTH_GROUP.' ag, '.TBL_USER_GROUP.' ug,'.TBL_AUTH_USER.' au '.
 		'where ag.group_id = ug.group_id(+) and ug.user_id = au.user_id(+) '.
-		'group by ag.group_id, ag.group_name, ag.locked '.
+		'group by ag.group_id, ag.group_name, ag.locked, ag.assignable '.
 		'order by %s %s',
 	'admin-list-oses' => 'select s.os_id, s.os_name, s.regex, s.sort_order, '.
 		'count(b.bug_id) as bug_count '.