| | |
| | | +-----------------------------------------------------------------------+ |
| | | */ |
| | | |
| | | define('INSTALL_PATH', realpath(dirname(__FILE__) . '/..') . '/' ); |
| | | define('INSTALL_PATH', realpath(__DIR__ . '/..') . '/' ); |
| | | |
| | | require_once INSTALL_PATH . 'program/include/clisetup.php'; |
| | | |
| | |
| | | exit(1); |
| | | } |
| | | |
| | | $rcmail = rcmail::get_instance(); |
| | | $rcmail = rcube::get_instance(); |
| | | |
| | | // get arguments |
| | | $args = rcube_utils::get_opt(array('h' => 'host')); |
| | |
| | | else { |
| | | _die("Specify a host name", true); |
| | | } |
| | | |
| | | // host can be a URL like tls://192.168.12.44 |
| | | $host_url = parse_url($args['host']); |
| | | if ($host_url['host']) { |
| | | $args['host'] = $host_url['host']; |
| | | } |
| | | } |
| | | |
| | | // connect to DB |
| | | $db = $rcmail->get_dbh(); |
| | | $db->db_connect('w'); |
| | | $transaction = false; |
| | | |
| | | if (!$db->is_connected() || $db->is_error()) { |
| | | _die("No DB connection\n" . $db->is_error()); |
| | |
| | | die("User not found.\n"); |
| | | } |
| | | |
| | | // inform plugins about approaching user deletion |
| | | $plugin = $rcmail->plugins->exec_hook('user_delete_prepare', array('user' => $user, 'username' => $username, 'host' => $args['host'])); |
| | | |
| | | // let plugins cleanup their own user-related data |
| | | $plugin = $rcmail->plugins->exec_hook('user_delete', array('user' => $user, 'username' => $username, 'host' => $args['host'])); |
| | | if (!$plugin['abort']) { |
| | | $transaction = $db->startTransaction(); |
| | | $plugin = $rcmail->plugins->exec_hook('user_delete', $plugin); |
| | | } |
| | | |
| | | if ($plugin['abort']) { |
| | | if ($transaction) { |
| | | $db->rollbackTransaction(); |
| | | } |
| | | _die("User deletion aborted by plugin"); |
| | | } |
| | | |
| | | // deleting the user record should be sufficient due to ON DELETE CASCADE foreign key references |
| | | // but not all database backends actually support this so let's do it by hand |
| | | foreach (array('identities','contacts','contactgroups','dictionaries','cache','cache_index','cache_messages','cache_thread','searches','users') as $table) { |
| | | $db->query('DELETE FROM ' . $db->table_name($table) . ' WHERE user_id=?', $user->ID); |
| | | foreach (array('identities','contacts','contactgroups','dictionary','cache','cache_index','cache_messages','cache_thread','searches','users') as $table) { |
| | | $db->query('DELETE FROM ' . $db->table_name($table, true) . ' WHERE `user_id` = ?', $user->ID); |
| | | } |
| | | |
| | | if ($db->is_error()) { |
| | | $rcmail->plugins->exec_hook('user_delete_rollback', $plugin); |
| | | _die("DB error occurred: " . $db->is_error()); |
| | | } |
| | | else { |
| | | echo "Successfully deleted user $user->ID\n"; |
| | | // inform plugins about executed user deletion |
| | | $plugin = $rcmail->plugins->exec_hook('user_delete_commit', $plugin); |
| | | |
| | | if ($plugin['abort']) { |
| | | unset($plugin['abort']); |
| | | $db->rollbackTransaction(); |
| | | $rcmail->plugins->exec_hook('user_delete_rollback', $plugin); |
| | | } |
| | | else { |
| | | $db->endTransaction(); |
| | | echo "Successfully deleted user $user->ID\n"; |
| | | } |
| | | } |
| | | |