[phpBT-dev] CVS: phpbt/inc functions.php,1.39,1.40

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

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

Modified Files:
	functions.php 
Log Message:
 * new database update model
    - database schema is versioned
 * new assignable-group declaration
    - each group has an assignable flag
    - configurable by admin/group.php
    - updated build_select's owner section


Index: functions.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/functions.php,v
retrieving revision 1.39
retrieving revision 1.40
diff -u -r1.39 -r1.40
--- functions.php	7 Apr 2003 18:55:38 -0000	1.39
+++ functions.php	19 Apr 2003 18:12:39 -0000	1.40
@@ -151,7 +151,7 @@
 	    }
 		break;
 	case 'owner':
-	    $rs = $db->query("select u.user_id, login from ".TBL_AUTH_USER." u, ".TBL_USER_GROUP." ug where u.active > 0 and u.user_id = ug.user_id and ug.group_id = ".GROUP_ASSIGN_TO." order by login");
+	    $rs = $db->query("select u.user_id, login from ".TBL_AUTH_USER." u, ".TBL_USER_GROUP." ug, ".TBL_AUTH_GROUP." g where u.active > 0 and u.user_id = ug.user_id and ug.group_id = g.group_id and g.assignable > 0 order by login");
 	    while ($rs->fetchInto($row)) {
 			// either singular matches, or array matches are acceptable
 		if (($selected == $row['user_id']) || in_array($row['user_id'], $selected)) {