|
From: Ken T. <ke...@us...> - 2003-04-19 18:13:13
|
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)) {
|