} else {
$command = $gsprache->add . ' voiceserverID: ' . $row2['affectedID'] . '; Error: ' . $virtualserver_id;
$query3 = $sql->prepare("UPDATE `jobs` SET `status`='1' WHERE `jobID`=? AND `type`='vo' LIMIT 1");
$query3->execute(array($row2['jobID']));
}
}
} else {
if ($row2['action'] == 'md' and isid($localserverid, 30)) {
$command = $gsprache->mod . ' voiceserverID: ' . $row2['affectedID'] . ' name:' . $row2['name'];
$query3 = $sql->prepare("SELECT `active`,`slots`,`ip`,`port`,`dns` FROM `voice_server` WHERE `id`=? LIMIT 1");
$query3->execute(array($row2['affectedID']));
foreach ($query3->fetchAll(PDO::FETCH_ASSOC) as $row3) {
$oldip = $row3['ip'];
$oldport = $row3['port'];
$olddns = $row3['dns'];
$connection->StartServer($localserverid);
$serverdetails = $connection->ServerDetails($localserverid);
$name = $serverdetails['virtualserver_name'];
$welcome = $serverdetails['virtualserver_welcomemessage'];
$hostbanner_url = $serverdetails['virtualserver_hostbanner_url'];
$hostbanner_gfx_url = $serverdetails['virtualserver_hostbanner_gfx_url'];
$hostbutton_tooltip = $serverdetails['virtualserver_hostbutton_tooltip'];
$hostbutton_url = $serverdetails['virtualserver_hostbutton_url'];
$hostbutton_gfx_url = $serverdetails['virtualserver_hostbutton_gfx_url'];
$connection->ModServer($localserverid, $slots, $ip, $port, $initialpassword, $name, $welcome, $max_download_total_bandwidth, $max_upload_total_bandwidth, $hostbanner_url, $hostbanner_gfx_url, $hostbutton_url, $hostbutton_gfx_url, $hostbutton_tooltip);
if ($forcebanner == 'Y') {
$removelist[] = 'b_virtualserver_modify_hostbanner';
$removelist[] = 'i_needed_modify_power_virtualserver_modify_hostbanner';
} else {
if ($forcebanner == 'N') {
$addlist[] = 'b_virtualserver_modify_hostbanner';
} else {
if ($addedby == 1) {
$query2 = $sql->prepare("SELECT `ip` FROM `rserverdata` WHERE `id`=? AND `resellerid`=? LIMIT 1");
$query2->execute(array($row['rootid'], $reseller_id));
$queryip = $query2->fetchColumn();
}
}
$connection = new TS3($queryip, $queryport, 'serveradmin', $querypassword);
$errorcode = $connection->errorcode;
if (strpos($errorcode, 'error id=0') === false) {
$template_file = $spracheResponse->error_ts_query_connect . $errorcode;
} else {
if ($ui->smallletters('action', 2, 'get') == 're') {
$uptime = 2;
$reply = $connection->StopServer($volocalserverid);
$reply = $connection->StartServer($volocalserverid);
$loguseraction = '%start% %voserver% ' . $row['ip'] . ':' . $row['port'];
$insertlog->execute();
} else {
if ($ui->smallletters('action', 2, 'get') == 'so') {
$uptime = 1;
$reply = $connection->StopServer($volocalserverid);
$loguseraction = '%stop% %voserver% ' . $row['ip'] . ':' . $row['port'];
$insertlog->execute();
}
}
if (isset($reply)) {
$query2 = $sql->prepare("UPDATE `voice_server` SET `uptime`=? WHERE `id`=? AND `resellerid`=? LIMIT 1");
$query2->execute(array($uptime, $id, $reseller_id));
$template_file = $spracheResponse->ts_query_success . $reply[0]['msg'];
} else {
if (isset($addList)) {
$connection->AdminPermissions($localServerID, 'add', $addList);
}
if (isset($removeList)) {
$connection->AdminPermissions($localServerID, 'del', $removeList);
}
$rowCount += count($addList) + count($removeList);
$loguseraction = '%mod% %voserver% ' . $ip . ':' . $port;
}
}
if (isset($localServerID) and isid($localServerID, 255)) {
if ($active == 'N') {
$connection->StopServer($localServerID);
} else {
if ($ui->st('action', 'post') == 'md' and $active == 'Y' and $oldActive == 'N') {
$connection->StartServer($localServerID);
}
}
$serverName = $ip . ':' . $port;
$connectList = array($serverName);
if ($masterServerData['usedns'] == 'Y') {
if ($ui->st('action', 'post') == 'ad' and $dns == strtolower($username . '.' . $masterServerData['defaultdns']) or $dns == $masterServerData['defaultdns']) {
$dns = strtolower($id . '.' . $masterServerData['defaultdns']);
$serverName = $dns;
$connectList[] = $dns;
$query = $sql->prepare("UPDATE `voice_server` SET `dns`=? WHERE `id`=? LIMIT 1");
$query->execute(array($dns, $id));
$rowCount += $query->rowCount();
}
if (isid($masterServerData['tsdnsServerID'], 19)) {
$query = $sql->prepare("SELECT *,AES_DECRYPT(`ssh2port`,:aeskey) AS `decryptedssh2port`,AES_DECRYPT(`ssh2user`,:aeskey) AS `decryptedssh2user`,AES_DECRYPT(`ssh2password`,:aeskey) AS `decryptedssh2password` FROM `voice_tsdns` WHERE `active`='Y' AND `id`=:id AND `resellerid`=:reseller_id LIMIT 1");
