<?php

/**
 * File: userpanel_voice.php.
 * Author: Ulrich Block
 * Contact: <ulrich.block@easy-wi.com>
 *
 * This file is part of Easy-WI.
 *
 * Easy-WI is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * Easy-WI is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with Easy-WI.  If not, see <http://www.gnu.org/licenses/>.
 *
 * Diese Datei ist Teil von Easy-WI.
 *
 * Easy-WI ist Freie Software: Sie koennen es unter den Bedingungen
 * der GNU General Public License, wie von der Free Software Foundation,
 * Version 3 der Lizenz oder (nach Ihrer Wahl) jeder spaeteren
 * veroeffentlichten Version, weiterverbreiten und/oder modifizieren.
 *
 * Easy-WI wird in der Hoffnung, dass es nuetzlich sein wird, aber
 * OHNE JEDE GEWAEHELEISTUNG, bereitgestellt; sogar ohne die implizite
 * Gewaehrleistung der MARKTFAEHIGKEIT oder EIGNUNG FUER EINEN BESTIMMTEN ZWECK.
 * Siehe die GNU General Public License fuer weitere Details.
 *
 * Sie sollten eine Kopie der GNU General Public License zusammen mit diesem
 * Programm erhalten haben. Wenn nicht, siehe <http://www.gnu.org/licenses/>.
 */

if ((!isset($user_id) or $main != 1) or (isset($user_id) and !$pa['voiceserver'])) {
    header('Location: userpanel.php');
    die('No Access');
}

include(EASYWIDIR . '/stuff/keyphrasefile.php');
include(EASYWIDIR . '/stuff/methods/class_ts3.php');
include(EASYWIDIR . '/stuff/methods/functions_ssh_exec.php');
include(EASYWIDIR . '/stuff/methods/functions_ts3.php');

$sprache = getlanguagefile('voice', $user_language, $reseller_id);
$loguserid = $user_id;
$logusername = getusername($user_id);
$logusertype = 'user';
$logreseller = 0;

if (isset($admin_id)) {
    $logsubuser = $admin_id;
} else if (isset($subuser_id)) {
    $logsubuser = $subuser_id;
} else {
    $logsubuser = 0;
}

if ($ui->st('d', 'get') == 'bu' and $ui->id('id', 10, 'get') and (!isset($_SESSION['sID']) or in_array($ui->id('id', 10, 'get'), $substituteAccess['vo']))) {

    $id = $ui->id('id', 10, 'get');

    $query = $sql->prepare("SELECT v.`id`,v.`ip`,v.`port`,v.`dns`,v.`localserverid`,v.`masterserver`,m.`type`,m.`queryport`,AES_DECRYPT(m.`querypassword`,:aeskey) AS `decryptedquerypassword`,m.`rootid`,m.`addedby`,m.`ssh2ip`,m.`type`,m.`usedns`,m.`publickey`,m.`ssh2ip`,AES_DECRYPT(m.`ssh2port`,:aeskey) AS `decryptedssh2port`,AES_DECRYPT(m.`ssh2user`,:aeskey) AS `decryptedssh2user`,AES_DECRYPT(m.`ssh2password`,:aeskey) AS `decryptedssh2password`,m.`serverdir`,m.`keyname`,m.`notified` FROM `voice_server` v LEFT JOIN `voice_masterserver` m ON v.`masterserver`=m.`id` WHERE v.`active`='Y' AND m.`active`='Y' AND v.`backup`='Y' AND v.`id`=:server_id AND v.`userid`=:user_id AND v.`resellerid`=:reseller_id LIMIT 1");
    $query->execute(array(':aeskey' => $aeskey,':server_id' => $id,':user_id' => $user_id,':reseller_id' => $reseller_id));
    while ($row = $query->fetch(PDO::FETCH_ASSOC)) {

        if ($row['type'] == 'ts3') {
            $type = $sprache->ts3;
            $server=($row['usedns'] == 'N' or $row['dns'] == null or $row['dns'] == '') ? $row['ip'] . ':' . $row['port'] : $row['dns'] . ' (' . $row['ip'] . ':' . $row['port'] . ')';
        }

        $dns = $row['dns'];
        $serverdir = $row['serverdir'];
        $addedby = $row['addedby'];
        $queryport = $row['queryport'];
        $querypassword = $row['decryptedquerypassword'];
        $volocalserverid = $row['localserverid'];
        $notified = $row['notified'];
        $masterserver = $row['masterserver'];

        if ($addedby==2) {

            $queryip = $row['ssh2ip'];
            $publickey = $row['publickey'];
            $queryip = $row['ssh2ip'];
            $ssh2port = $row['decryptedssh2port'];
            $ssh2user = $row['decryptedssh2user'];
            $ssh2password = $row['decryptedssh2password'];
            $keyname = $row['keyname'];

        } else if ($addedby == 1) {
            $query = $sql->prepare("SELECT `ip` FROM `rserverdata` WHERE `id`=? AND `resellerid`=? LIMIT 1");
            $query->execute(array($row['rootid'], $reseller_id));
            $queryip = $query->fetchColumn();
        }
    }

    $query = $sql->prepare("SELECT `voice_maxbackup` FROM `settings` WHERE `resellerid`=? LIMIT 1");
    $query->execute(array($reseller_id));
    $voice_maxbackup = $query->fetchColumn();

    $query = $sql->prepare("SELECT COUNT(`id`) AS `amount` FROM `voice_server_backup` WHERE `sid`=? AND `uid`=? AND `resellerid`=?");
    $query->execute(array($id, $user_id, $reseller_id));
    $backupcount = $query->fetchColumn();

    if (isset($server) and !$ui->smallletters('action', 2, 'post') and $ui->port('po', 'get') != 1) {

        $table = array();

        $query = $sql->prepare("SELECT `id`,`name`,`date` FROM `voice_server_backup` WHERE `sid`=? AND `uid`=? AND `resellerid`=? ORDER BY `date` DESC");
        $query->execute(array($id, $user_id, $reseller_id));
        while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
            $table[] = array('id' => $row['id'], 'date' => $row['date'], 'name' => $row['name']);
        }

        $template_file = 'userpanel_voiceserver_backup_list.tpl';

    } else if (isset($server) and !$ui->smallletters('action', 2, 'post') and $ui->port('po', 'get') == 1) {

        $template_file = 'userpanel_voiceserver_backup_new.tpl';

    } else if (isset($server) and $ui->smallletters('action', 2, 'post') == 'nb') {

        $name = ($ui->names('name',50, 'post')) ? $ui->names('name',50, 'post') : 'New Backup';
        $toomuch = $backupcount + 1 - $voice_maxbackup;

        if ($toomuch > 0) {
            $query = $sql->prepare("SELECT `id` FROM `voice_server_backup` WHERE `sid`=? AND `uid`=? AND `resellerid`=? ORDER BY `id` ASC LIMIT " . $toomuch);
            $query->execute(array($id, $user_id, $reseller_id));
            while ($row = $query->fetch(PDO::FETCH_ASSOC)) {

                $delete = $sql->prepare("DELETE FROM `voice_server_backup` WHERE `id`=? AND `uid`=? AND `resellerid`=? LIMIT 1");
                $delete->execute(array($row['id'], $user_id, $reseller_id));

                tsbackup('delete', $ssh2user, $serverdir, $masterserver, $volocalserverid, $row['id']);
            }
        }

        $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 {
            $connection->StartServer($volocalserverid);
            $rawsnapshot = $connection->Snapshotcreate($volocalserverid);
            $channelSnapshot = $connection->channelList($volocalserverid);

            if (is_array($rawsnapshot) and isset($rawsnapshot[0]['msg'])) {
                $template_file = $spracheResponse->error_ts_query.$rawsnapshot[0]['msg'];

            } else if (is_array($rawsnapshot) and !isset($rawsnapshot[0]['msg'])) {
                $template_file = 'Unknown error';

            } else {

                $snapshot = gzcompress($rawsnapshot, 9);

                $query = $sql->prepare("INSERT INTO `voice_server_backup` (`sid`,`uid`,`name`,`snapshot`,`channels`,`date`,`resellerid`) VALUES(?,?,?,?,?,NOW(),?)");
                $query->execute(array($id, $user_id, $name, $snapshot, $channelSnapshot, $reseller_id));

                $return = tsbackup('create', $ssh2user, $serverdir, $masterserver, $volocalserverid, $sql->lastInsertId());

                if ($return == 'ok') {

                    $query = $sql->prepare("SELECT CONCAT(`ip`,':',`port`) AS `address` FROM `voice_server` WHERE `id`=? AND `userid`=? AND `resellerid`=? LIMIT 1");
                    $query->execute(array($id, $user_id, $reseller_id));
                    $address = $query->fetchColumn();

                    $loguseraction = '%add% %voserver% %backup% ' . $name . ' ' . $address;
                    $insertlog->execute();

                    $template_file = $spracheResponse->ts_query_success . $return;
                } else {
                    $template_file = $spracheResponse->error_ts_query . $return;
                }

            }
        }
        $connection->CloseConnection();

    } else if (isset($server) and $ui->smallletters('action', 2, 'post') == 'md' and isset($ui->post['delete']) and $ui->id('id',10, 'post') != false) {

        $query = $sql->prepare("SELECT `name`,`sid` FROM `voice_server_backup` WHERE `id`=? AND `uid`=? AND `resellerid`=? LIMIT 1");
        $query->execute(array($ui->id('id',10, 'post'), $user_id, $reseller_id));
        while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
            $name = $row['name'];
            $sid = $row['sid'];
        }

        if ($query->rowCount() > 0) {
            $query = $sql->prepare("DELETE FROM `voice_server_backup` WHERE `id`=? AND `uid`=? AND `resellerid`=? LIMIT 1");
            $query->execute(array($ui->id('id',10, 'post'), $user_id, $reseller_id));

            tsbackup('delete', $ssh2user, $serverdir, $masterserver, $volocalserverid, $ui->id('id',10, 'post'));

            $query = $sql->prepare("SELECT CONCAT(`ip`,':',`port`) AS `address` FROM `voice_server` WHERE `id`=? AND `userid`=? AND `resellerid`=? LIMIT 1");
            $query->execute(array($sid, $user_id, $reseller_id));
            $address = $query->fetchColumn();

            $loguseraction = '%del% %voserver% %backup% ' . $name . ' ' . $address;
            $insertlog->execute();

            $template_file = $spracheResponse->table_del;

        } else {
            $template_file = $spracheResponse->error_table;
        }

    } else if (isset($server) and $ui->smallletters('action', 2, 'post') == 'md' and isset($ui->post['use']) and $ui->id('id',10, 'post') != false) {

        $query = $sql->prepare("SELECT `snapshot`,`name`,`sid`,`channels` FROM `voice_server_backup` WHERE `id`=? AND `uid`=? AND `resellerid`=? LIMIT 1");
        $query->execute(array($ui->id('id',10, 'post'), $user_id, $reseller_id));
        while ($row = $query->fetch(PDO::FETCH_ASSOC)) {

            $snapshot = @gzuncompress($row['snapshot']);
            $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 {
                $connection->StartServer($volocalserverid);
                $reply = $connection->Snapshotdeploy($volocalserverid, $snapshot);
                if (isset($reply[0]['id']) and $reply[0]['id'] == '0') {

                    $move = array();

                    $channelListOld = @json_decode($row['channels']);
                    $channelListDeployed = @json_decode($connection->channelList($volocalserverid));

                    if (is_object($channelListDeployed) and is_object($channelListOld)) {
                        foreach ($channelListOld as $k => $v) {
                            if (isset($channelListDeployed->$k)) {
                                $move[$v] = $channelListDeployed->$k;
                            }
                        }
                    }

                    tsbackup('deploy', $ssh2user, $serverdir, $masterserver, $volocalserverid, $ui->id('id',10, 'post'), $move);

                    $query = $sql->prepare("SELECT CONCAT(`ip`,':',`port`) AS `address` FROM `voice_server` WHERE `id`=? AND `userid`=? AND `resellerid`=? LIMIT 1");
                    $query->execute(array($row['sid'], $user_id, $reseller_id));
                    $address = $query->fetchColumn();

                    $loguseraction = '%use% %voserver% %backup% ' . $row['name'] . ' ' . $address;
                    $insertlog->execute();

                }

                $template_file = $spracheResponse->ts_query_success . $reply[0]['msg'];
            }
            $connection->CloseConnection();
        }
    } else {
        $template_file = $spracheResponse->token;
    }

} else if ($ui->st('d', 'get') == 'pk' and $ui->id('id', 10, 'get') and (!isset($_SESSION['sID']) or in_array($ui->id('id', 10, 'get'), $substituteAccess['vo']))) {

    $id = (int) $ui->id('id', 10, 'get');

    $query = $sql->prepare("SELECT `masterserver`,`localserverid`,CONCAT(`ip`,':',`port`) AS `address` FROM `voice_server` WHERE `id`=? AND `userid`=? AND `resellerid`=? LIMIT 1");
    $query->execute(array($id, $user_id, $reseller_id));
    while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
        $masterserver = $row['masterserver'];
        $localserverid = $row['localserverid'];
        $address = $row['address'];
    }

    if (isset($masterserver)) {

        $query = $sql->prepare("SELECT *,AES_DECRYPT(`querypassword`,:aeskey) AS `decryptedquerypassword`,AES_DECRYPT(`ssh2port`,:aeskey) AS `decryptedssh2port`,AES_DECRYPT(`ssh2user`,:aeskey) AS `decryptedssh2user`,AES_DECRYPT(`ssh2password`,:aeskey) AS `decryptedssh2password` FROM `voice_masterserver` WHERE `id`=:id AND (`resellerid`=:reseller_id OR (`managedServer`='Y' AND `managedForID`=:reseller_id)) LIMIT 1");
        $query->execute(array(':aeskey' => $aeskey,':id' => $masterserver,':reseller_id' => $reseller_id));
        while ($row = $query->fetch(PDO::FETCH_ASSOC)) {

            $masteractive = $row['active'];
            $addedby = $row['addedby'];
            $queryport = $row['queryport'];
            $querypassword = $row['decryptedquerypassword'];

            if ($addedby == 2) {

                $queryip = $row['ssh2ip'];
            } else if ($addedby == 1) {
                $query2 = $sql->prepare("SELECT `ip`,`bitversion` FROM `rserverdata` WHERE `id`=? AND `resellerid`=? LIMIT 1");
                $query2->execute(array($row['rootid'], $reseller_id));
                foreach ($query2->fetchall(PDO::FETCH_ASSOC) as $row3) {
                    $queryip = $row3['ip'];
                }
            }
        }

        if (isset($masteractive) and $masteractive == 'Y') {

            $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->port('po', 'get') == 1) {

                    $servergroups = array();

                    foreach($connection->ServerGroups($localserverid) as $servergroup) {
                        if ($servergroup['type'] == 1) {
                            $servergroups[$servergroup['id']] = $servergroup['name'];
                        }
                    }

                    $template_file = 'userpanel_voiceserver_key_add.tpl';

                } else if (!$ui->smallletters('action', 2, 'post') and !$ui->port('po', 'get')) {

                    $pklist = $connection->KeyList($localserverid);

                    configureDateTables('-1', '0, "asc"');

                    $template_file = (is_array($pklist)) ? 'userpanel_voiceserver_key_list.tpl' : $spracheResponse->ts_query_success . $pklist;

                } else if ($ui->smallletters('action', 2, 'post') == 'ad') {

                    if ($ui->id('group',255, 'post')) {

                        $groupAllowed = false;

                        foreach($connection->ServerGroups($localserverid) as $servergroup) {
                            if ($servergroup['type'] == 1 and $servergroup['id'] == $ui->id('group',255, 'post')) {
                                $groupAllowed = true;
                                break;
                            }
                        }

                        if ($groupAllowed) {

                            $newkey = $connection->AddKey($localserverid, $ui->id('group',255, 'post'));

                            $template_file = $spracheResponse->ts_query_success . $newkey[0]['token'];

                            $loguseraction = '%add% %voserver% Token ' . $address;
                            $insertlog->execute();
                        }else{
                         
                            $template_file = $spracheResponse->ts_query_error;
                         
                        }
                    }else{
                     
                     $template_file = $spracheResponse->ts_query_error;
                     
                    }

                } else if ($ui->smallletters('action', 2, 'post') == 'dl') {

                    $del = $connection->DelKey($localserverid, $ui->post['token']);

                    $template_file = $spracheResponse->ts_query_success . $del[0]['msg'];

                    $loguseraction = '%del% %voserver% Token ' . $address;
                    $insertlog->execute();
                }
            }

            $connection->CloseConnection();

        } else {
            $template_file = 'userpanel_404.tpl';
        }

    } else {
        $template_file = 'userpanel_404.tpl';
    }

} else if ($ui->st('d', 'get') == 'rs' and $ui->id('id', 10, 'get') and $ui->smallletters('action', 2, 'get') == 'rs' and (!isset($_SESSION['sID']) or in_array($ui->id('id', 10, 'get'), $substituteAccess['vo']))) {

    $id = (int) $ui->id('id', 10, 'get');

    $query = $sql->prepare("SELECT v.*,m.`type`,m.`queryport`,AES_DECRYPT(m.`querypassword`,?) AS `decryptedquerypassword`,m.`rootid`,m.`addedby`,m.`ssh2ip`,m.`defaultname`,m.`defaultwelcome`,m.`defaulthostbanner_url`,m.`defaulthostbanner_gfx_url`,m.`defaulthostbutton_tooltip`,m.`defaulthostbutton_url`,m.`defaulthostbutton_gfx_url`,m.`usedns` FROM `voice_server` v LEFT JOIN `voice_masterserver` m ON v.`masterserver`=m.`id` WHERE v.`active`='Y' AND m.`active`='Y' AND v.`id`=? AND v.`userid`=? AND v.`resellerid`=? LIMIT 1");
    $query->execute(array($aeskey, $id, $user_id, $reseller_id));
    while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
        $addedby = $row['addedby'];
        $queryport = $row['queryport'];
        $querypassword = $row['decryptedquerypassword'];
        $usedns = $row['usedns'];
        $name = $row['defaultname'];
        $welcome = $row['defaultwelcome'];
        $banner_url = $row['defaulthostbanner_url'];
        $banner_gfx = $row['defaulthostbanner_gfx_url'];
        $tooltip = $row['defaulthostbutton_tooltip'];
        $button_url = $row['defaulthostbutton_url'];
        $button_gfx = $row['defaulthostbutton_gfx_url'];
        $slots = $row['slots'];
        $voip = $row['ip'];
        $voport = $row['port'];
        $password = $row['initialpassword'];
        $max_download_total_bandwidth = $row['max_download_total_bandwidth'];
        $max_upload_total_bandwidth = $row['max_upload_total_bandwidth'];
        $volocalserverid = $row['localserverid'];
        $forcebanner = $row['forcebanner'];
        $forcebutton = $row['forcebutton'];
        $forcewelcome = $row['forcewelcome'];

        if ($addedby == 2) {
            $queryip = $row['ssh2ip'];
        } else if ($addedby == 1) {
            $query = $sql->prepare("SELECT `ip` FROM `rserverdata` WHERE `id`=? AND `resellerid`=? LIMIT 1");
            $query->execute(array($vrow['rootid'], $reseller_id));
            while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
                $queryip = $row['ip'];
            }
        }
    }

    if (isset($queryip, $queryport, $querypassword)) {

        $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 {

            $connection->StartServer($volocalserverid);
            $connection->ModServer($volocalserverid, $slots, $voip, $voport, $password, $name, $welcome, $max_download_total_bandwidth, $max_upload_total_bandwidth, $banner_url, $banner_gfx, $button_url, $button_gfx, $tooltip);
            $reply = $connection->PermReset($volocalserverid);

            $loguseraction = '%reinstall% %voserver% ' . $voip . ':' . $voport;
            $insertlog->execute();

            if (isset($reply[0]['token'])) {

                $template_file = $spracheResponse->ts_query_success . $reply[0]['token'];

                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';
                    $addlist[] = 'i_needed_modify_power_virtualserver_modify_hostbanner';
                }

                if ($forcebutton == 'Y') {
                    $removelist[] = 'b_virtualserver_modify_hostbutton';
                    $removelist[] = 'i_needed_modify_power_virtualserver_modify_hostbutton';
                } else if ($forcebutton == 'N') {
                    $addlist[] = 'b_virtualserver_modify_hostbutton';
                    $addlist[] = 'i_needed_modify_power_virtualserver_modify_hostbutton';
                }

                if ($forcewelcome == 'Y') {
                    $removelist[] = 'b_virtualserver_modify_welcomemessage';
                    $removelist[] = 'i_needed_modify_power_virtualserver_modify_welcomemessage';
                } else if ($forcewelcome == 'N') {
                    $addlist[] = 'b_virtualserver_modify_welcomemessage';
                    $addlist[] = 'i_needed_modify_power_virtualserver_modify_welcomemessage';
                }

                if (isset($addlist)) {
                    $connection->AdminPermissions ($volocalserverid, 'add', $addlist);
                }

                if (isset($removelist)) {
                    $connection->AdminPermissions ($volocalserverid, 'del', $removelist);
                }

            } else {
                $template_file = $spracheResponse->error_ts_query . $connection->errorcode;
            }

            $connection->CloseConnection();
        }

    } else {
        $template_file = 'userpanel_404.tpl';
    }

} else if ($ui->st('d', 'get') == 'md' and $ui->id('id', 10, 'get') and (!isset($_SESSION['sID']) or in_array($ui->id('id', 10, 'get'), $substituteAccess['vo']))) {

    $id = (int) $ui->id('id', 10, 'get');
    $iniConfigurationMaster = array();
    $iniConfigurationServer = new stdClass();

    if (!$ui->smallletters('action', 2, 'post')) {

        $query = $sql->prepare("SELECT * FROM `voice_server` WHERE `id`=? AND `userid`=? AND `resellerid`=? LIMIT 1");
        $query->execute(array($id, $user_id, $reseller_id));
        while ($row = $query->fetch(PDO::FETCH_ASSOC)) {

            $description = $row['description'];
            $masterserver = $row['masterserver'];
            $ip = $row['ip'];
            $port = $row['port'];
            $initialpassword = $row['initialpassword'];
            $localserverid = $row['localserverid'];
            $forcebanner = $row['forcebanner'];
            $forcebutton = $row['forcebutton'];
            $forceservertag = $row['forceservertag'];
            $forcewelcome = $row['forcewelcome'];
            $dns = $row['dns'];
            $active = $row['active'];
            $password = $row['password'];
            $iniConfigurationServer = @json_decode($row['iniConfiguration']);

            if ($active == 'Y') {

                $query2 = $sql->prepare("SELECT *,AES_DECRYPT(`querypassword`,?) AS `decryptedquerypassword`  FROM `voice_masterserver` WHERE `id`=? AND (`resellerid`=? OR (`managedServer`='Y' AND `managedForID`=?)) LIMIT 1");
                $query2->execute(array($aeskey, $row['masterserver'], $reseller_id, $reseller_id));
                while ($row2 = $query2->fetch(PDO::FETCH_ASSOC)) {

                    $resellerToUse = $row2['resellerid'];
                    $masteractive = $row2['active'];
                    $usedns = $row2['usedns'];
                    $defaultdns=strtolower($id . '.' . $row2['defaultdns']);
                    $queryport = $row2['queryport'];
                    $querypassword = $row2['decryptedquerypassword'];
                    $addedby = $row2['addedby'];
                    $externalDefaultDNS = $row2['externalDefaultDNS'];
                    $tsdnsServerID = $row2['tsdnsServerID'];
                    $iniConfigurationMaster = @parse_ini_string($row2['iniConfiguration'], true, INI_SCANNER_RAW);

                    if ($addedby == 2) {
                        $queryip = $row2['ssh2ip'];
                    } else if ($addedby == 1) {
                        $query3 = $sql->prepare("SELECT `ip`,`altips` FROM `rserverdata` WHERE `id`=? AND `resellerid`=? LIMIT 1");
                        $query3->execute(array($row2['rootid'], $resellerToUse));
                        while ($row3 = $query3->fetch(PDO::FETCH_ASSOC)) {
                            $queryip = $row3['ip'];
                        }
                    }
                }

                if (isset($tsdnsServerID) and isid($tsdnsServerID,10)) {
                    $query2 = $sql->prepare("SELECT `defaultdns` FROM `voice_tsdns` WHERE `active`='Y' AND `id`=? AND `resellerid`=? LIMIT 1");
                    $query2->execute(array($tsdnsServerID, $resellerToUse));
                    while ($row2 = $query2->fetch(PDO::FETCH_ASSOC)) {
                        if ($externalDefaultDNS== 'Y') {
                            $defaultdns=strtolower($id . '.' . $row2['defaultdns']);
                        }
                    }
                }
            }
        }

        if (isset($masteractive) and $masteractive == 'Y' and $active == 'Y') {

            $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."<br />";

            } else {

                $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'];

                # Ticket https://github.com/easy-wi/developer/issues/13 "Bearbeiten von TS3 Servern im Usermodul erweitern"
                $virtualserver_antiflood_points_needed_command_block = $serverdetails['virtualserver_antiflood_points_needed_command_block'];
                $virtualserver_antiflood_points_needed_ip_block = $serverdetails['virtualserver_antiflood_points_needed_ip_block'];
                $virtualserver_antiflood_points_tick_reduce = $serverdetails['virtualserver_antiflood_points_tick_reduce'];
                $virtualserver_hostbanner_gfx_interval = $serverdetails['virtualserver_hostbanner_gfx_interval'];
                $virtualserver_hostmessage_mode = $serverdetails['virtualserver_hostmessage_mode'];
                $virtualserver_needed_identity_security_level = $serverdetails['virtualserver_needed_identity_security_level'];
                $virtualserver_reserved_slots = $serverdetails['virtualserver_reserved_slots'];
            }

            $connection->CloseConnection();

            if ($iniConfigurationMaster === false) {
                $iniConfigurationMaster = array();
            }

            $template_file = 'userpanel_voiceserver_md.tpl';

        } else {
            $template_file = 'userpanel_404.tpl';
        }

    } else if ($ui->smallletters('action', 2, 'post') == 'md' and token(true)) {

        unset ($active);
        $errors = array();

        $query = $sql->prepare("SELECT * FROM `voice_server` WHERE `id`=? AND `userid`=? AND `resellerid`=? LIMIT 1");
        $query->execute(array($id, $user_id, $reseller_id));
        while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
            $active = $row['active'];
            $ip = $row['ip'];
            $port = $row['port'];
            $oldip = $ip;
            $oldport = $port;
            $slots = $row['slots'];
            $olddns = $row['dns'];
            $forceservertag = $row['forceservertag'];
            $forcebanner = $row['forcebanner'];
            $forcebutton = $row['forcebutton'];
            $forcewelcome = $row['forcewelcome'];
            $masterserver = $row['masterserver'];
            $localserverid = $row['localserverid'];
            $max_download_total_bandwidth = $row['max_download_total_bandwidth'];
            $max_upload_total_bandwidth = $row['max_upload_total_bandwidth'];
            $iniConfigurationServer = @json_decode($row['iniConfiguration']);
        }

        if (isset($active) and $active == 'Y') {

            $query = $sql->prepare("SELECT *,AES_DECRYPT(`querypassword`,:aeskey) AS `decryptedquerypassword`,AES_DECRYPT(`ssh2port`,:aeskey) AS `decryptedssh2port`,AES_DECRYPT(`ssh2user`,:aeskey) AS `decryptedssh2user`,AES_DECRYPT(`ssh2password`,:aeskey) AS `decryptedssh2password` FROM `voice_masterserver` WHERE `id`=:id AND (`resellerid`=:reseller_id OR (`managedServer`='Y' AND `managedForID`=:reseller_id)) LIMIT 1");
            $query->execute(array(':aeskey' => $aeskey,':id' => $masterserver,':reseller_id' => $reseller_id));
            while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
                $resellerToUse = $row['resellerid'];
                $masteractive = $row['active'];
                $serverdir = $row['serverdir'];
                $addedby = $row['addedby'];
                $usedns = $row['usedns'];
                $masterDNS = $row['defaultdns'];
                $queryport = $row['queryport'];
                $querypassword = $row['decryptedquerypassword'];
                $mnotified = $row['notified'];
                $tsdnsServerID = $row['tsdnsServerID'];
                $externalDefaultDNS = $row['externalDefaultDNS'];
                $iniConfigurationMaster = @parse_ini_string($row['iniConfiguration'], true, INI_SCANNER_RAW);

                if ($addedby == 2) {

                    $publickey = $row['publickey'];
                    $queryip = $row['ssh2ip'];
                    $ssh2port = $row['decryptedssh2port'];
                    $ssh2user = $row['decryptedssh2user'];
                    $ssh2password = $row['decryptedssh2password'];
                    $keyname = $row['keyname'];
                    $bitversion = $row['bitversion'];

                } else if ($addedby == 1) {
                    $query2 = $sql->prepare("SELECT `ip`,`bitversion` FROM `rserverdata` WHERE `id`=? AND `resellerid`=? LIMIT 1");
                    $query2->execute(array($row['rootid'], $resellerToUse));
                    while ($row2 = $query2->fetch(PDO::FETCH_ASSOC)) {
                        $queryip = $row2['ip'];
                        $bitversion = $row2['bitversion'];
                    }
                }
            }

            if (!isset($masteractive) or !isset($usedns) or $masteractive == 'N') {
                $template_file = 'userpanel_404.tpl';

            } else {

                $dns = strtolower($ui->domain('dns', 'post'));
                $dnsCheck = checkDNS($dns, $id, $user_id, $type='server');

                if ($usedns == 'Y' and $dns != $olddns and $dns != '' and $dnsCheck !== false) {

                    if (isset($tsdnsServerID) and isid($tsdnsServerID, 10) and isset($resellerToUse)) {

                        $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");
                        $query->execute(array(':aeskey' => $aeskey,':id' => $tsdnsServerID,':reseller_id' => $resellerToUse));
                        while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
                            $publickey = $row['publickey'];
                            $queryip = $row['ssh2ip'];
                            $ssh2port = $row['decryptedssh2port'];
                            $ssh2user = $row['decryptedssh2user'];
                            $ssh2password = $row['decryptedssh2password'];
                            $serverdir = $row['serverdir'];
                            $keyname = $row['keyname'];
                            $bit = $row['bitversion'];
                            $bitversion = $row['bitversion'];
                        }
                    }

                    $return = tsdns('md', $queryip, $ssh2port, $ssh2user, $publickey, $keyname, $ssh2password, $mnotified, $serverdir, $bitversion, array($ip, $oldip), array($port, $oldport), array($dns, $olddns), $reseller_id);
                    $template_file = ($return == 'ok') ? $spracheResponse->ts_query_success . $return : $spracheResponse->error_ts_query . $return;

                } else if ($usedns == 'Y' and $dns != $olddns and $dns != '' and $dnsCheck === false) {
                    $errors[] = $sprache->dnsError;
                }
            }

            if (count($errors) == 0) {

                $customConfigurations = array();

                $initialpassword = $ui->password('initialpassword',50, 'post');
                $name = $ui->post['name'];

                foreach ($iniConfigurationMaster as $groupName => $array) {

                    $groupNameSelect = $ui->escaped(str_replace(' ', '', $groupName), 'post');

                    if ($groupNameSelect and isset($iniConfigurationMaster[$groupName][$groupNameSelect])) {
                        $iniConfiguration[$groupName] = $groupNameSelect;
                    } else {
                        reset($iniConfigurationMaster[$groupName]);
                        $iniConfiguration[$groupName] = key($iniConfigurationMaster[$groupName]);
                    }

                    $customConfigurations[] = $iniConfiguration[$groupName];
                }

                $iniConfiguration = @json_encode($iniConfiguration);

                $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 {

                    $serverdetails = $connection->ServerDetails($localserverid);

                    if ($forceservertag == 'Y' and isset($brandname) and $brandname != '' and strpos(strtolower($name), strtolower($brandname)) === false) {
                        $name = $serverdetails['virtualserver_name'];
                    }

                    if ($forcebanner== 'Y') {
                        $banner_url = $serverdetails['virtualserver_hostbanner_url'];
                        $banner_gfx = $serverdetails['virtualserver_hostbanner_gfx_url'];
                    } else {
                        $banner_url = $ui->url('hostbanner_url', 'post');
                        $banner_gfx = $ui->url('hostbanner_gfx_url', 'post');
                    }

                    if ($forcebutton == 'Y') {
                        $tooltip = $serverdetails['virtualserver_hostbutton_tooltip'];
                        $button_url = $serverdetails['virtualserver_hostbutton_url'];
                        $button_gfx = $serverdetails['virtualserver_hostbutton_gfx_url'];
                    } else {
                        $tooltip = $ui->description('hostbutton_tooltip', 'post');
                        $button_url = $ui->url('hostbutton_url', 'post');
                        $button_gfx = $ui->url('hostbutton_gfx_url', 'post');
                    }

                    $welcome = (isset($forcewelcome) and $forcewelcome == 'Y') ? $serverdetails['virtualserver_welcomemessage'] : $ui->description('welcome', 'post');

                    # Ticket https://github.com/easy-wi/developer/issues/13 "Bearbeiten von TS3 Servern im Usermodul erweitern"
                    $virtualserver_antiflood_points_needed_command_block = $ui->id('virtualserver_antiflood_points_needed_command_block',255, 'post');
                    $virtualserver_antiflood_points_needed_ip_block = $ui->id('virtualserver_antiflood_points_needed_ip_block',255, 'post');
                    $virtualserver_antiflood_points_tick_reduce = $ui->id('virtualserver_antiflood_points_tick_reduce',255, 'post');
                    $virtualserver_hostbanner_gfx_interval = $ui->id('virtualserver_hostbanner_gfx_interval',255, 'post');
                    $virtualserver_hostmessage_mode = $ui->id('virtualserver_hostmessage_mode',1, 'post');
                    $virtualserver_needed_identity_security_level = $ui->id('virtualserver_needed_identity_security_level',255, 'post');
                    $virtualserver_reserved_slots = ($ui->id('virtualserver_reserved_slots',4, 'post') and $ui->id('virtualserver_reserved_slots',4, 'post') < $slots) ? $ui->id('virtualserver_reserved_slots',4, 'post') : 0;

                    $mod = $connection->ModServer($localserverid, $slots, $ip, $port, $initialpassword, $name, $welcome, $max_download_total_bandwidth, $max_upload_total_bandwidth, $banner_url, $banner_gfx, $button_url, $button_gfx, $tooltip, $virtualserver_reserved_slots, $virtualserver_needed_identity_security_level, $virtualserver_hostmessage_mode, $virtualserver_hostbanner_gfx_interval, $virtualserver_antiflood_points_tick_reduce, $virtualserver_antiflood_points_needed_command_block, $virtualserver_antiflood_points_needed_ip_block, $customConfigurations);
                    $template_file = $spracheResponse->table_add . '<br />' . $spracheResponse->ts_query_success . $mod[0]['msg'];
                }

                $connection->CloseConnection();

                $query = $sql->prepare("UPDATE `voice_server` SET `description`=?,`dns`=?,`initialpassword`=?,`iniConfiguration`=? WHERE `id`=? AND `resellerid`=? LIMIT 1");
                $query->execute(array($ui->names('description', 255, 'post'), $dns, $initialpassword, $iniConfiguration, $id, $reseller_id));

                $loguseraction = '%mod% %voserver% ' . $ip . ':' . $port;
                $insertlog->execute();

            } else {
                $template_file = implode(', ', $errors);
            }

        } else {
            $template_file = 'userpanel_404.tpl';
        }
    } else {
        $template_file = $spracheResponse->token;
    }

} else if ($ui->st('d', 'get') == 'st' and $ui->id('id', 10, 'get') and $ui->smallletters('action', 2, 'get') and (!isset($_SESSION['sID']) or in_array($ui->id('id', 10, 'get'), $substituteAccess['vo']))) {

    $id = (int) $ui->id('id', 10, 'get');

    $query = $sql->prepare("SELECT v.`ip`,v.`port`,v.`localserverid`,m.`type`,m.`queryport`,AES_DECRYPT(m.`querypassword`,?) AS `decryptedquerypassword`,m.`rootid`,m.`addedby`,m.`ssh2ip` FROM `voice_server` v LEFT JOIN `voice_masterserver` m ON v.`masterserver`=m.`id` WHERE v.`active`='Y' AND m.`active`='Y' AND v.`id`=? AND v.`userid`=? AND v.`resellerid`=? LIMIT 1");
    $query->execute(array($aeskey, $id, $user_id, $reseller_id));
    while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
        $addedby = $row['addedby'];
        $queryport = $row['queryport'];
        $querypassword = $row['decryptedquerypassword'];
        $volocalserverid = $row['localserverid'];

        if ($addedby == 2) {
            $queryip = $row['ssh2ip'];
        } 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 {
                $template_file = 'Unknown Error';
            }
        }
    }

    if ($query->rowCount() == 0) {
        $template_file = 'userpanel_404.tpl';
    }

} else if ($ui->st('d', 'get') == 'bl' and $ui->id('id', 10, 'get') and (!isset($_SESSION['sID']) or in_array($ui->id('id', 10, 'get'), $substituteAccess['vo']))) {

    $id = $ui->id('id', 10, 'get');

    $query = $sql->prepare("SELECT v.`id`,v.`ip`,v.`port`,v.`dns`,v.`localserverid`,v.`masterserver`,m.`type`,m.`queryport`,AES_DECRYPT(m.`querypassword`,:aeskey) AS `decryptedquerypassword`,m.`rootid`,m.`addedby`,m.`ssh2ip`,m.`type`,m.`usedns`,m.`publickey`,m.`ssh2ip`,AES_DECRYPT(m.`ssh2port`,:aeskey) AS `decryptedssh2port`,AES_DECRYPT(m.`ssh2user`,:aeskey) AS `decryptedssh2user`,AES_DECRYPT(m.`ssh2password`,:aeskey) AS `decryptedssh2password`,m.`serverdir`,m.`keyname`,m.`notified` FROM `voice_server` v LEFT JOIN `voice_masterserver` m ON v.`masterserver`=m.`id` WHERE v.`active`='Y' AND m.`active`='Y' AND v.`backup`='Y' AND v.`id`=:server_id AND v.`userid`=:user_id AND v.`resellerid`=:reseller_id LIMIT 1");
    $query->execute(array(':aeskey' => $aeskey,':server_id' => $id,':user_id' => $user_id,':reseller_id' => $reseller_id));
    while ($row = $query->fetch(PDO::FETCH_ASSOC)) {

        if ($row['type'] == 'ts3') {
            $type = $sprache->ts3;
            $server=($row['usedns'] == 'N' or $row['dns']==null or $row['dns'] == '') ? $row['ip'] . ':' . $row['port'] : $row['dns'] . ' (' . $row['ip'] . ':' . $row['port'] . ')';
        }

        $dns = $row['dns'];
        $serverdir = $row['serverdir'];
        $addedby = $row['addedby'];
        $queryport = $row['queryport'];
        $querypassword = $row['decryptedquerypassword'];
        $volocalserverid = $row['localserverid'];
        $notified = $row['notified'];
        $masterserver = $row['masterserver'];

        if ($addedby==2) {

            $queryip = $row['ssh2ip'];
            $publickey = $row['publickey'];
            $queryip = $row['ssh2ip'];
            $ssh2port = $row['decryptedssh2port'];
            $ssh2user = $row['decryptedssh2user'];
            $ssh2password = $row['decryptedssh2password'];
            $keyname = $row['keyname'];

        } else if ($addedby == 1) {
            $query = $sql->prepare("SELECT `ip` FROM `rserverdata` WHERE `id`=? AND `resellerid`=? LIMIT 1");
            $query->execute(array($row['rootid'], $reseller_id));
            $queryip = $query->fetchColumn();
        }
    }

    if (isset($queryip, $volocalserverid)) {

        $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->st('action', 'post') == 'dl') {

                $return = $connection->banDel($volocalserverid, $ui->id('bannID', 19, 'post'));
                $template_file = ($return) ? $spracheResponse->ts_query_success . $return : $spracheResponse->error_table;

            } else if ($ui->st('action', 'post') == 'ad') {

                if ($ui->w('banType', 1 , 'post') == 'I' and $ui->ip4('ip', 'post')) {

                    $banCmd = 'banadd ip=' . $ui->ip4('ip', 'post');

                } else if ($ui->w('banType', 1 , 'post') == 'N' and strlen($ui->escaped('name', 'post')) > 0) {

                    $banCmd = 'banadd name=' . $connection->ReplaceToTS3($ui->escaped('name', 'post'));

                } else if ($ui->w('banType', 1 , 'post') == 'U' and $ui->id('clientUID', 19, 'post')) {

                    $banCmd = 'banclient clid=' . $ui->id('clientUID', 19, 'post');

                }

                if (isset($banCmd)) {

                    if ($ui->id('time', 19, 'post') > 0) {
                        $banCmd .= ' time=' . $ui->id('time', 19, 'post');
                    }

                    if (strlen($ui->escaped('name', 'post')) > 0) {

                        $banCmd .= ' banreason=' . $connection->ReplaceToTS3($ui->escaped('banReason', 'post'));
                    }

                    $return = $connection->banAdd($volocalserverid, $banCmd);
                    $template_file = ($return) ? $spracheResponse->ts_query_success . $return : $spracheResponse->error_table;

                    if ($ui->w('banType', 1 , 'post') == 'U') {
                        $connection->clientKick($volocalserverid, $ui->id('clientUID', 19, 'post'));
                    }

                } else {

                    $error = $sprache->banErrorData;
                    $template_file = 'userpanel_voiceserver_ban_ad.tpl';
                }

            } else if (!$ui->st('action', 'post') and $ui->st('e', 'get') == 'ad') {

                $userList = $connection->getClientList($volocalserverid);

                $template_file = 'userpanel_voiceserver_ban_ad.tpl';

            } else {

                $banList = $connection->banList($volocalserverid);

                $template_file = 'userpanel_voiceserver_ban_list.tpl';

                configureDateTables('-1', '0, "asc"');
            }
        }
    } else {
        $template_file = 'userpanel_404.tpl';
    }

} else {

    $table = array();
    $o = $ui->st('o', 'get');

    if ($ui->st('o', 'get') == 'aa') {
        $orderby = 'v.`ip` ASC, v.`port` ASC';
    } else if ($ui->st('o', 'get') == 'da') {
        $orderby = 'v.`ip` DESC, v.`port` DESC';
    } else if ($ui->st('o', 'get') == 'du') {
        $orderby = 'v.`usedslots` DESC';
    } else if ($ui->st('o', 'get') == 'au') {
        $orderby = 'v.`usedslots` ASC';
    } else if ($ui->st('o', 'get') == 'dt') {
        $orderby = 'v.`filetraffic` DESC';
    } else if ($ui->st('o', 'get') == 'at') {
        $orderby = 'v.`filetraffic` ASC';
    } else if ($ui->st('o', 'get') == 'dr') {
        $orderby = 'v.`uptime` DESC';
    } else if ($ui->st('o', 'get') == 'ar') {
        $orderby = 'v.`uptime` ASC';
    } else if ($ui->st('o', 'get') == 'ds') {
        $orderby = 'v.`uptime` DESC';
    } else if ($ui->st('o', 'get') == 'as') {
        $orderby = 'v.`uptime` ASC';
    } else if ($ui->st('o', 'get') == 'di') {
        $orderby = 'v.`id` DESC';
    } else{
        $o = 'ai';
        $orderby = 'v.`id` ASC';
    }

    $query = $sql->prepare("SELECT v.*,m.`type`,m.`usedns` FROM `voice_server` v INNER JOIN `voice_masterserver` m ON v.`masterserver`=m.`id` WHERE v.`active`='Y' AND m.`active`='Y' AND v.`userid`=? AND v.`resellerid`=? ORDER BY $orderby");
    $query->execute(array($user_id, $reseller_id));
    while ($row = $query->fetch(PDO::FETCH_ASSOC)) {

        if (!isset($_SESSION['sID']) or in_array($row['id'], $substituteAccess['vo'])) {

            $dns = $row['dns'];

            if ($row['type'] == 'ts3') {
                $type = $sprache->ts3;
                $usedSlots = (int) $row['usedslots'];

                $flexSlots = '';
                if ($row['flexSlots'] == 'Y' and $row['flexSlotsCurrent'] == null) {
                    $flexSlots = $row['slots'] . '/';
                } else if ($row['flexSlots'] == 'Y') {
                    $flexSlots = $row['flexSlotsCurrent'] . '/';
                }


                if ($row['uptime']==0) {
                    $imgName = '16_error';
                    $imgAlt='error';
                    $stopped='C';
                } else if ($row['uptime']>1) {
                    $imgName = '16_ok';
                    $imgAlt='online';
                    $stopped = 'N';
                } else {
                    $imgName = '16_bad';
                    $imgAlt='offline';
                    $stopped = 'Y';
                }

                $usage = $usedSlots. '/' . $flexSlots.$row['slots'];
                $days = floor($row['uptime'] / 86400);
                $hours = floor(($row['uptime'] - ($days * 86400)) / 3600);
                $minutes = floor(($row['uptime'] - ($days * 86400) - ($hours * 3600)) / 60);
                $uptime = $days . 'D/' . $hours . 'H/' . $minutes . 'M';
                $password = ($row['initialpassword'] != '' and $row['initialpassword'] != null) ? '?password='.$row['initialpassword'] : '';
                $server = ($row['usedns'] == 'N' or $dns == null or $dns == '') ? '<a href="ts3server://'.$row['ip'] . ':' . $row['port'].$password.'">'.$row['ip'] . ':' . $row['port'].'</a>' : '<a href="ts3server://'.$row['dns'].$password.'">'.$row['dns'].' ('.$row['ip'] . ':' . $row['port'].')</a>';
                $address = $row['ip'] . ':' . $row['port'];
                $filetraffic = round(($row['filetraffic'] / 1024), 2);
                $maxtraffic = ($row['maxtraffic'] >= 0) ? round($row['maxtraffic']) : $row['maxtraffic'];
            }

            $table[] = array('id' => $row['id'], 'virtual_id' => $row['localserverid'], 'description' => $row['description'], 'backup' => $row['backup'], 'filetraffic' => $filetraffic, 'maxtraffic' => $maxtraffic, 'server' => $server,'address' => $address, 'usage' => $usage, 'uptime' => $uptime, 'stopped' => $stopped, 'img' => $imgName, 'alt' => $imgAlt, 'type' => $type);
        }
    }

    $template_file = 'userpanel_voiceserver_list.tpl';

}