* * -------------------------------------------- * * This program is free software; you can redistribute it and/or modify it * * under the terms of the GNU General Public License as published by the * * Free Software Foundation; either version 2 of the License, or (at your * * option) any later version. * \**************************************************************************/ /** * delete ACL records of deleted accounts (can be called only via the URL) * * ACL records of deleted accounts have very irritating effects on the ACL (specialy calendar) * * @package admin * @author RalfBecker@outdoor-training.de * @license GPL */ $GLOBALS['phpgw_info'] = array( 'flags' => array( 'currentapp' => 'admin', )); include('../header.inc.php'); if (!$GLOBALS['phpgw_info']['user']['apps']['admin']) { echo '
'.lang('Permission denied')."
\n"; } else { $deleted = 0; if (($all_accounts = $GLOBALS['phpgw']->accounts->search(array('type'=>'both')))) { $all_accounts = array_keys($all_accounts); $GLOBALS['phpgw']->db->query("DELETE FROM phpgw_acl WHERE acl_account NOT IN (".implode(',',$all_accounts).") OR acl_appname='phpgw_group' AND acl_location NOT IN ('".implode("','",$all_accounts)."')",__LINE__,__FILE__); $deleted = $GLOBALS['phpgw']->db->affected_rows(); } echo ''.lang('%1 ACL records of not (longer) existing accounts deleted.',$deleted)."
\n"; } $GLOBALS['phpgw']->common->phpgw_footer(); $GLOBALS['phpgw']->common->phpgw_exit();