unset($mail_aliases);
//spamfilter // preferences = true/false, username = email address, can be *@*
//id, username, preferences
//spamfilter_preferences
//prefid, spamfilter_id, preference, value
//$client_traffic = $exdb->queryAllRecords("SELECT t.cl_id, t.date, t.http_in, t.http_out, t.ftp_in, t.ftp_out, t.smtp_in, t.smtp_out, t.pop3_imap_in, t.pop3_imap_out FROM ClientsTraffic as t");
$db_userids = array();
$db_users = $exdb->queryAllRecords("SELECT u.id, u.login, u.account_id, u.db_id, a.password, a.type as `pwtype`, d.dom_id FROM db_users as u INNER JOIN data_bases as d ON (d.id = u.db_id) LEFT JOIN accounts as a ON (a.id = u.account_id)");
foreach ($db_users as $db_user) {
// database user
$params = array('server_id' => $server_id, 'database_user' => $db_user['login'], 'database_password' => $db_user['password']);
$client_id = $plesk_ispc_ids[$domain_owners[$db_user['dom_id']]];
$check = $app->db->queryOneRecord('SELECT * FROM `web_database_user` WHERE `database_user` = \'' . $app->db->quote($db_user['login']) . '\'');
$db_user_id = 0;
if ($check) {
$ok = $importer->sites_database_user_update($session_id, $client_id, $check['database_user_id'], array_merge($check, $params));
if ($ok === false) {
$msg .= " Error: " . $importer->getFault() . "<br />";
}
$db_user_id = $check['database_user_id'];
} else {
$db_user_id = $importer->sites_database_user_add($session_id, $client_id, $params);
}
if (!isset($db_userids[$db_user['db_id']])) {
$db_userids[$db_user['db_id']] = $db_user_id;
}
$msg .= 'Created / updated database user: '******'login'] . '<br />';
}
add_command('# DATABASES');
$databases = $exdb->queryAllRecords("SELECT d.id, d.name, d.type, d.dom_id, d.db_server_id, d.default_user_id FROM `data_bases` as d");
foreach ($databases as $database) {
