[phpBT-dev] CVS: phpbt/admin group.php,1.10,1.11

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

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

Modified Files:
	group.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: group.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/admin/group.php,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -r1.10 -r1.11
--- group.php	18 May 2002 03:00:00 -0000	1.10
+++ group.php	19 Apr 2003 18:12:38 -0000	1.11
@@ -51,13 +51,13 @@
 
 	if (!$groupid) {
 		$db->query("insert into ".TBL_AUTH_GROUP.
-			" (group_id, group_name, created_by, created_date, last_modified_by, last_modified_date)"
+			" (group_id, group_name, created_by, created_date, last_modified_by, last_modified_date, assignable)"
 			." values (".$db->nextId(TBL_AUTH_GROUP).", ".
-			$db->quote(stripslashes($group_name)).", $u, $now, $u, $now)");
+			$db->quote(stripslashes($group_name)).", $u, $now, $u, $now, $assignable)");
 	} else {
 		$db->query("update ".TBL_AUTH_GROUP.
 			" set group_name = ".$db->quote(stripslashes($group_name)).
-			", last_modified_by = $u, last_modified_date = $now where group_id = '$groupid'");
+			", last_modified_by = $u, last_modified_date = $now, assignable = ".($assignable?1:0)." where group_id = '$groupid'");
 	}
 	if ($use_js) {
 		$t->display('admin/edit-submit.html');
@@ -90,7 +90,7 @@
 		$order = $_gv['order']; 
 		$sort = $_gv['sort']; 
 	}
-	
+
 	$page = isset($_gv['page']) ? $_gv['page'] : 0;
 	
 	$nr = $db->getOne("select count(*) from ".TBL_AUTH_GROUP);