<?php
session_start();
	include "/var/www/q/tsclass/lib/carbon.php";
	use Carbon\Carbon;
	$carbon = new Carbon();
if (!empty($_GET["buy"])) {
	if (is_numeric($_SESSION["uzivatel"])) {
	}else{
	header("Location: /intro/voice-servery/");
	die;
	}
if (!empty($_GET["platba"]) && (is_numeric($_GET["platba"]))) {

if ($_GET["platba"] == "1") {
$platba = "1";
}
if ($_GET["platba"] == "2") {
$platba = "2";
}
if ($_GET["platba"] == "3") {
$platba = "3";
}
if ($_GET["platba"] == "4") {
$platba = "4";
}else{
header("Location: /intro/voice-servery/");
}

if (!empty($_GET["menoservera"])) {
$menoservera = $_GET["menoservera"];
$menoservera2 = addslashes("$menoservera");

if ("$menoservera" == "$menoservera2") {
}else{
setcookie("error", "1", time() + 1, "/intro/voice-servery/");
header("Location: /intro/voice-servery/");
die;
}
}else{
$menoservera = "Core-Host.cz TS3 Server";
}

}else{
header("Location: /intro/voice-servery/");
}
$buy = $_GET["buy"];
if ($buy == "1") {
$cena = "7";
$slotik = "20";

if ($platba == "2") {
$cena = "28";
}
if ($platba == "3") {
$cena = "168";
}
if ($platba == "4") {
$cena = "336";
}


}elseif ($buy == "2") {
$cena = "14";
$slotik = "60";

if ($platba == "2") {
$cena = "56";
}
if ($platba == "3") {
$cena = "336";
}
if ($platba == "4") {
$cena = "672";
}

}elseif ($buy == "3") {
$cena = "28";
$slotik = "100";

if ($platba == "2") {
$cena = "112";
}
if ($platba == "3") {
$cena = "672";
}
if ($platba == "4") {
$cena = "1344";
}

}else{
header("Location: /intro/voice-servery/");
}

include ("/var/www/q/databaze.php");
$iduzivatele = $_SESSION["uzivatel"];
$databaze = new mysqli($db_ip, $db_jmeno, $db_heslo, $db_databaze);
$sql = "SELECT * FROM auth WHERE usid='$iduzivatele'";
$odpoved = $databaze->query($sql);
$row = $odpoved->fetch_assoc();
$uzkredit = $row["kredit"];
$databaze->close();

if ("$uzkredit" > "$cena" or ("$uzkredit" == "$cena")) {

$databaze = new mysqli($db_ip, $db_jmeno, $db_heslo, $db_databaze);
$sql = "SELECT * FROM ms WHERE msid='1'";
$odpoved = $databaze->query($sql);
$row = $odpoved->fetch_assoc();
$msservers = $row["msservers"];
$msserversmax = $row["msserversmax"];
$databaze->close();

if ($msservers < $msserversmax) {

$databaze = new mysqli($db_ip, $db_jmeno, $db_heslo, $db_databaze);
$sql = "UPDATE auth SET kredit = kredit - $cena WHERE usid='$iduzivatele'";
if ($databaze->query($sql) === TRUE) {
$databaze->close();
require("/var/www/q/tsclass/lib/ts3admin.class.php");
$ts3_ip = '127.0.0.1';
$ts3_queryport = 10011;
$ts3_user = 'serveradmin';
$ts3_pass = 'XYGn5Ft';
$corehost = new ts3admin($ts3_ip, $ts3_queryport);
if($corehost->getElement('success', $corehost->connect())) {
$corehost->login($ts3_user, $ts3_pass);

$corehostarray = array();
$corehostarray['VIRTUALSERVER_NAME'] = "$menoservera";
$corehostarray['VIRTUALSERVER_MAXCLIENTS'] = "$slotik";

$corehostdata = $corehost->serverCreate($corehostarray);
$corehostdata = json_encode($corehostdata);
$corehostdata2 = explode(":", $corehostdata);
$tstoken = $corehostdata2[5];
$tstoken = str_replace('"', "", "$tstoken");
$tstoken = str_replace(',', "", "$tstoken");
$tstoken = str_replace('virtualserver_port', "", "$tstoken");
$tsport = $corehostdata2[6];
$tsport = str_replace('"', "", "$tsport");
$tsport = str_replace('}}', "", "$tsport");
$tssid = $corehostdata2[4];
$tssid = str_replace('"', "", "$tssid");
$tssid = str_replace(',', "", "$tssid");
$tssid = str_replace('token', "", "$tssid");
include "/var/www/q/databaze.php";
$uzivatel = $_SESSION["uzivatel"];
$datumik = date("Y-m-d H:i:s");

if ($platba == "1") {
$carbon = Carbon::now()->addWeeks(1);
}
if ($platba == "2") {
$carbon = Carbon::now()->addMonths(1);
}
if ($platba == "3") {
$carbon = Carbon::now()->addMonths(6);
}
if ($platba == "4") {
$carbon = Carbon::now()->addYears(1);
}
$carbon = explode(" ", "$carbon");
$datum1 = $carbon['0'];
$cas1 = $carbon['1'];
$cas1 = explode(":", "$cas1");
$cashodina = $cas1['0'];
$casminuta = $cas1['1'];
$datum1 = explode("-", "$datum1");
$datumrok = $datum1['0'];
$datummesiac = $datum1['1'];
$datumden = $datum1['2'];

$databaze = new mysqli($db_ip, $db_jmeno, $db_heslo, $db_databaze);
$sql = "INSERT INTO tsservers (menoservera, majitel, sid, port, token, sloty, registrace, exden, exmesiac, exrok, exhodina, exminuta, zaplaceno)
VALUES ('$menoservera', '$uzivatel', '$tssid', '$tsport', '$tstoken', '$slotik', '$datumik', '$datumden', '$datummesiac', '$datumrok', '$cashodina', '$casminuta', '$cena')";
if ($databaze->query($sql) === TRUE) {
$databaze->close();
sleep(2);
}else{
die;
}
$databaze = new mysqli($db_ip, $db_jmeno, $db_heslo, $db_databaze);
$sql = "UPDATE ms SET msservers = msservers + 1 WHERE msid='1'";
if ($databaze->query($sql) === TRUE) {
$databaze->close();
$databaze = new mysqli($db_ip, $db_jmeno, $db_heslo, $db_databaze);
$sql = "SELECT * FROM tsservers WHERE port='$tsport'";
$odpoved = $databaze->query($sql);
$row = $odpoved->fetch_assoc();
$idckoservera = $row["id"];
$databaze->close();
//shell_exec("sudo bash /var/www/q/shell/expirace_start.sh $idckoservera $datumrok $datummesiac $datumden $cashodina $casminuta");
//shell_exec("sudo bash /var/www/q/shell/expirace_obnova.sh");
setcookie("srvtoken", "$tstoken", time() + 1, "/intro/administrace/ts/status/$idckoservera");
setcookie("srvjmeno", "$menoservera", time() + 1, "/intro/administrace/ts/status/$idckoservera");
header("Location: /intro/administrace/ts/status/$idckoservera");
die;
header("Location: /intro/administrace/");
die;
}else{
}
}else{
die("PO-BE-HLI-CA");
}
} else {
}

}
}else{
setcookie("error", "2", time() + 1, "/intro/voice-servery/");
header("Location: /intro/voice-servery/");
die;
}
}




if ($_GET["balik"] == "1") {
$balicek2 = "1";
$balicek = "START";
$sloty = "20";
$cena = "7";
}elseif ($_GET["balik"] == "2") {
$balicek2 = "2";
$balicek = "ADVANCED";
$sloty = "60";
$cena = "14";
}elseif ($_GET["balik"] == "3") {
$balicek2 = "3";
$balicek = "EXPERT";
$sloty = "100";
$cena = "28";
}else{
header("Location: /intro/voice-servery/");
}
?>
<html>
<head>
<title>CoreHost.cz</title>
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
  <link rel="stylesheet" type="text/css" href="http://q.core-play.cz/styl.css">
  <link rel="stylesheet" type="text/css" href="styl.css">
</head>
<body>
	<?php
	if (is_numeric($_SESSION["uzivatel"])) {
	include "/var/www/q/databaze.php";
	$iduzivatele = $_SESSION["uzivatel"];
	$databaze = new mysqli($db_ip, $db_jmeno, $db_heslo, $db_databaze);
	$sql = "SELECT * FROM auth WHERE usid='$iduzivatele'";
	$odpoved = $databaze->query($sql);
	$row = $odpoved->fetch_assoc();
	$uzmeno = $row["usjmeno"];
	$uzkredit = $row["kredit"];
	$databaze->close();
	}
	?>
	</div>
<nav class="navbar navbar-static-top navbar-inverse">
  <div class="container-fluid">
    <div class="navbar-header">
      <a class="navbar-brand" href="/">CoreHost.cz</a>
    </div>
    <ul class="nav navbar-nav">
      <li><a href="/">ÚVOD</a></li>
      <li class="active"><a href="/intro/voice-servery">VOICE SERVERY</a></li>
      <li><a href="/intro/voice-bot">VOICE BOT</a></li>
    </ul>
    <ul class="nav navbar-nav navbar-right">
    <?php
    if (is_numeric($_SESSION["uzivatel"])) {
    ?>
      <li><a href="/intro/administrace/"><span class="glyphicon glyphicon-user"></span> ADMINISTRACE</a></li>
      <li><a href="/?odhlaseni=OK"><span class="glyphicon glyphicon-log-out"></span> ODHLÁŠENÍ</a></li>
    </ul>
    <?php
	}else{
	?>
	  <li><a href="/intro/ucet/registrace/"><span class="glyphicon glyphicon-user"></span> REGISTRACE</a></li>
      <li><a href="/intro/ucet/login/"><span class="glyphicon glyphicon-log-out"></span> PŘIHLÁŠENÍ</a></li>
    </ul>
	<?php
	}
	?>
  </div>
</nav>
<center>
<h4>OBJEDNÁVKA > VOICE-SERVER > BALÍČEK > <?php echo "$balicek"; ?></h4>

		   		<?php
		   		if (is_numeric($_SESSION["uzivatel"])) {

		   		if ("$uzkredit" > "$cena" or ("$uzkredit" == "$cena")) {
		   		?>
		   		<form action="/intro/voice-servery/objednat/" method="GET">
		   		<p>
		   		<p>Server obsahuje <b><?php echo "$sloty " ?></b> slotů</p>
		   		<p>Cena za týden: <b><?php echo "$cena"; ?></b> CZK </p>
		   		<p>Název Serveru:<input type="text" name="menoservera"><br></p>
			<p>PLATBA:
			<select name="platba">
  		<option value="1">1 týden <?php echo "$cena"; ?>Kč</option>
  		<option value="2">1 měsíc <?php $cena = $cena * 4; echo "$cena"; ?>Kč</option>
  		<option value="3">6 měsíců <?php $cena = $cena * 6; echo "$cena"; ?>Kč</option>
  		<option value="4">1 rok <?php $cena = $cena * 2; echo "$cena"; ?>Kč</option>
			</select><br></p>
					<input type="hidden" name="buy" value="<?php echo "$balicek2"; ?>">
		   			<input type="submit" name="Koupit server" class="btn btn-success">
		   		</li>
		   		</form>
		   		<?php
		   		}else{
		   		?>
		   		<p>Server obsahuje <b><?php echo "$sloty " ?></b> slotů</p>
		   		<p>Cena za týden: <b><?php echo "$cena"; ?></b> CZK </p>
		   			<a class="button2" href="/intro/voice-servery/objednat/?buy=<?php echo "$balicek2"; ?>">Nemáš dostatek kreditu na koupeni tohoto balíku!</a>
		   		</li>
		   		<?php
		   		}
		   		}else{
		   		?>
		   		<p>Server obsahuje <b><?php echo "$sloty " ?></b> slotů</p>
		   		<p>Cena za týden: <b><?php echo "$cena"; ?></b> CZK </p>
		   			<a class="button2" href="/intro/voice-servery/objednat/?buy=<?php echo "$balicek2"; ?>">Pro zakoupení serveru musíš být přihlášen!</a>
		   		</li>
		   		<?php
		   		}
		   		?>
				<div class="clearfix">
				</div>
		</ul>
	</center>

</body>
</html>