[phpBT-dev] CVS: phpbt/inc/db mysql.php,1.21,1.22

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

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

Modified Files:
	mysql.php 
Log Message:
Removed the hardcoded "assignable" bit from TBL_AUTH_GROUP and instead added a new entry in TBL_AUTH_PERM named "Assignable".


Index: mysql.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/mysql.php,v
retrieving revision 1.21
retrieving revision 1.22
diff -u -r1.21 -r1.22
--- mysql.php	22 Aug 2005 19:44:47 -0000	1.21
+++ mysql.php	22 Aug 2005 19:58:25 -0000	1.22
@@ -1,11 +1,11 @@
 <?php
 $QUERY = array(
 	'admin-list-groups' => 'select ag.group_id, group_name, locked, '.
-		'count(ug.group_id) as count, assignable '.
+		'count(ug.group_id) as count '.
 		'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, assignable '.
+		'group by ag.group_id, group_name, locked '.
 		'order by %s %s',
 	'admin-list-oses' => 'select s.os_id, os_name, regex, sort_order, '.
 		'count(bug_id) as bug_count '.