|
From: Ulf E. <ulf...@us...> - 2005-08-22 20:04:13
|
Update of /cvsroot/phpbt/phpbt/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv12023/admin Modified Files: group.php Log Message: Added a simple UI to edit group permissions Index: group.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/admin/group.php,v retrieving revision 1.14 retrieving revision 1.15 diff -u -r1.14 -r1.15 --- group.php 22 Aug 2005 19:58:25 -0000 1.14 +++ group.php 22 Aug 2005 20:04:05 -0000 1.15 @@ -50,10 +50,17 @@ if ($error) { show_form($groupid, $error); return; } if (!$groupid) { - $db->query("insert into ".TBL_AUTH_GROUP." (group_id, group_name, created_by, created_date, last_modified_by, last_modified_date) values (".$db->nextId(TBL_AUTH_GROUP).", ".$db->quote(stripslashes($group_name)).", $u, $now, $u, $now)"); + $groupid = $db->nextId(TBL_AUTH_GROUP); + $db->query("insert into ".TBL_AUTH_GROUP." (group_id, group_name, created_by, created_date, last_modified_by, last_modified_date) values (".$groupid.", ".$db->quote(stripslashes($group_name)).", $u, $now, $u, $now)"); } 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'"); } + + $db->query("delete from ".TBL_GROUP_PERM." where group_id = '$groupid'"); + foreach ($perms as $permid) { + $db->query("insert into ".TBL_GROUP_PERM." (group_id, perm_id) values ($groupid, $permid)"); + } + if ($use_js) { $t->render('edit-submit.html', '', 'wrap-popup.html'); } else { @@ -64,11 +71,15 @@ function show_form($groupid = 0, $error = '') { global $db, $me, $t; + $group_perms = array(); if ($groupid && !$error) { $t->assign($db->getRow("select * from ".TBL_AUTH_GROUP." where group_id = '$groupid'")); + $group_perms = $db->getCol("select distinct perm_id from ".TBL_GROUP_PERM." where group_id = $groupid"); } else { $t->assign($_POST); } + $t->assign('perms', $db->getAll("select * from ".TBL_AUTH_PERM)); + $t->assign('group_perms', $group_perms); $t->assign('error', $error); $t->render('group-edit.html', translate("Edit Group"), (!empty($_GET['use_js']) ? 'wrap-popup.html' : 'wrap.html')); } |