$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); } $query6->execute(array($row2['jobID'])); } } else { if (isset($remotesql)) { $query7->execute(array($row['hostID'])); } else { $query8->execute(array($row['hostID'])); $query3->execute(array($row['hostID']));
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 { $template_file = $remotesql->error; } } }