$ip = $row4['ip'];
$ips = $row4['ips'];
$cname = $row4['cname'];
$dbname = $row4['dbname'];
$password = $row4['decryptedpassword'];
$max_queries_per_hour = $row4['max_queries_per_hour'];
$max_updates_per_hour = $row4['max_updates_per_hour'];
$max_connections_per_hour = $row4['max_connections_per_hour'];
$max_userconnections_per_hour = $row4['max_userconnections_per_hour'];
$extraData = @json_decode($row4['extraData']);
if (is_object($extraData) and $extraData->newActive == 'N') {
$password = passwordgenerate(20);
}
if ($row2['action'] == 'dl') {
$command = $gsprache->del . ' MySQLDBID: ' . $row2['affectedID'] . ' DBName: ' . $row4['dbname'];
$remotesql->DelDB($dbname);
$query5->execute(array($row2['affectedID']));
customColumns('M', $row2['affectedID'], 'del');
} else {
if ($row2['action'] == 'ad') {
$command = $gsprache->add . ' MySQLDBID: ' . $row2['affectedID'] . ' DBName: ' . $row4['dbname'];
$mailData['userId'] = $row4['uid'];
$mailData['name'] = strlen($row4['description']) > 0 ? $row4['description'] : $row4['dbname'];
$remotesql->AddDB($mailData, $dbname, $password, $ips, $max_queries_per_hour, $max_connections_per_hour, $max_updates_per_hour, $max_userconnections_per_hour);
} else {
$command = $gsprache->mod . ' MySQLDBID: ' . $row2['affectedID'] . ' DBName: ' . $row4['dbname'];
$remotesql->ModDB($dbname, $password, $ips, $max_queries_per_hour, $max_connections_per_hour, $max_updates_per_hour, $max_userconnections_per_hour);
}
}
$theOutput->printGraph($command);
}
} else {
if (($ui->st('d', 'get') == 'ri' or $ui->st('d', 'get') == 'dl') and $id) {
$query = $sql->prepare("SELECT `dbname`,`description` FROM `mysql_external_dbs` WHERE `id`=? AND `resellerid`=? LIMIT 1");
$query->execute(array($id, $resellerLockupID));
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
$dbName = $row['dbname'];
$description = $row['description'];
}
$serverFound = $query->rowCount();
if (($ui->st('action', 'post') == 'ri' or $ui->st('action', 'post') == 'dl') and count($errors) == 0 and $serverFound > 0) {
$query = $sql->prepare("SELECT e.`uid`,e.`dbname`,e.`ips`,e.`max_queries_per_hour`,e.`max_connections_per_hour`,e.`max_updates_per_hour`,e.`max_userconnections_per_hour`,AES_DECRYPT(e.`password`,?) AS `decryptedpassword`,s.`ip`,AES_DECRYPT(s.`password`,?) AS `decryptedpassword2`,s.`port`,s.`user`,CASE WHEN s.`connect_ip_only`='Y' THEN s.`external_address` ELSE s.`ip` END AS `user_connect_ip` FROM `mysql_external_dbs` e INNER JOIN `mysql_external_servers` s ON e.`sid`=s.`id` WHERE e.`id`=? AND e.`resellerid`=? LIMIT 1");
$query->execute(array($aeskey, $aeskey, $id, $resellerLockupID));
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
$remotesql = new ExternalSQL($row['ip'], $row['port'], $row['user'], $row['decryptedpassword2']);
if ($remotesql->error == 'ok') {
$remotesql->DelDB($row['dbname']);
$remotesql->DelUser($row['dbname']);
if ($ui->st('action', 'post') == 'ri') {
$mailData = array('userId' => $row['uid'], 'name' => strlen($description) > 0 ? $description : $row['dbname'], 'mailConnectInfo' => array('ip' => $row['user_connect_ip'], 'port' => $row['port']));
$remotesql->AddDB($mailData, $row['dbname'], $row['decryptedpassword'], $row['ips'], $row['max_queries_per_hour'], $row['max_connections_per_hour'], $row['max_updates_per_hour'], $row['max_userconnections_per_hour']);
$loguseraction = '%ri% MYSQL DB ' . $row['dbname'] . ' (' . $row['ip'] . ')';
$template_file = $spracheResponse->reinstall_success;
} else {
$query2 = $sql->prepare("DELETE FROM `mysql_external_dbs` WHERE `id`=? AND `resellerid`=? LIMIT 1");
$query2->execute(array($id, $resellerLockupID));
customColumns('D', $id, 'del');
$loguseraction = '%del% MySQL DB ' . $row['dbname'] . ' (' . $row['ip'] . ')';
$template_file = $spracheResponse->table_del;
}
$insertlog->execute();
} else {
