<?php
date_default_timezone_set('Asia/Jakarta');
// Script by Arief Richman

session_start();


if(!isset($_SESSION['username'])) {
header('location:../login.php'); }
else { $username = $_SESSION['username']; }
require_once("../koneksi.php");

$query = mysql_query("SELECT * FROM reseller WHERE username = '$username'");
$hasil = mysql_fetch_array($query);
?>

<?php
  require_once("../koneksi.php");
  $date = date('Y-m-d');
  $username1 = $_POST['username'];
  $password = $_POST['password'];
  $durasi = $_POST['hari'];

if ($durasi == 1) {
$harga = 2000;
$newdate = strtotime ( '+1 day' , strtotime ( $date ) ) ;
} else if ($durasi == 3) {
$harga = 8000;
$newdate = strtotime ( '+3 day' , strtotime ( $date ) ) ;
} else if ($durasi == 7) {
$harga = 30000;
$newdate = strtotime ( '+7 day' , strtotime ( $date ) ) ;
} else if ($durasi == 14) {
$harga = 50000;
$newdate = strtotime ( '+14 day' , strtotime ( $date ) ) ;
} else if($durasi == 30){
$harga = 60000;
$newdate = strtotime ( '+30 day' , strtotime ( $date ) ) ;
} else {
$tiket = a;
}

$expired = date ( 'Y-m-d' , $newdate );
  if ($hasil['saldo'] < $harga) { ?>
<div class="alert alert-danger">
Gagal : Saldo tidak mencukupi.
</div>
<? } else {
  $cekuser = mysql_query("SELECT * FROM reseller WHERE username = '$username1'");
  if(mysql_num_rows($cekuser) <> 0) { ?>
<div class="alert alert-danger">
Gagal : Username sudah terdaftar.
</div>
<? } else if(!$username1 || !$password) { ?>
<div class="alert alert-danger">
Gagal : Masih ada data yang kosong.
</div>
<? } else {
 mysql_query("INSERT INTO reseller '$username1', '$password','1000', 'member', '$date', '$expired', '$durasi'") or die(mysql_error());
 mysql_query("UPDATE reseller SET saldo=saldo-$harga WHERE username = '$username'");

 ?>
<div class="alert alert-success">
Username : <?php echo $username1;?><br>
Password : <?php echo $password;?><br>
Harga : <?php echo $harga;?><br>
Durasi : <?php echo $durasi;?> Hari<br>
Expired : <?php echo $expired;?><br>
Uplink : <?php echo $username;?><br><br>

<? }
}
?>