PREMIUM CONNECTION"; } include_once "../../Pages/Misc/arrUserSpecial.php"; switch ($_GET[Mode]) { case "HisRefill": $hisNama = $_GET[nama]; if (isset($hisNama)) { if ($hisNama != $sesNama) { $msg = "Illegal operation"; die (toAlert("$msg")); // echo "$msg $sesNama"; } } $historyUser = $_POST['nama']; if (!$historyUser) { $historyUser = $logUser; } $strTitle .= "History Refill"; $strMainTitle = "
history refill
";
include "hisRefill.php";
break;
case "SlowOn":
//limit upload download voucher free
$up = 131072;
$dw = 131072;
//$strMain.=show_confirm()."";
//echo "";
$attribute0 = "Cleartext-Password";
$attribute1 = "lifetime-limit";
$attribute2 = "Mikrotik-Xmit-Limit";
$attribute3 = "Mikrotik-Recv-Limit";
$attribute6 = "Mikrotik-Total-Limit";
$attribute4 = "Max-Access-Period-Time";
$attribute5 = "Mikrotik-Rate-Limit";
$op = ":=";
$newMA = $masaAktif + $masaAktif2; //period-time
$newLT = $limitUptime + $limitUptime2; //limit-uptime
$newLU = $limitUpload + $uploadLimit2;
$newLD = $limitDownload + $downloadLimit2;
$newLBw = $limitTotal + $limitTotal2;
$limitKecepatan2 = "$up/$dw";
$newLK = $limitKecepatan2;
// $upload = $ll['acctinputoctets'];
// $download = $ll['acctoutputoctets'];
// cek masa aktif
$q = "SELECT * FROM radcheck where username='$username' and attribute='$attribute6' ";
$x = mysql_query($q, $conn) or die(mysql_error());
$l = mysql_fetch_array($x);
$limitQuotaBw = $l[value];
// cek kuota bandwith
$q = "SELECT * FROM radcheck where username='$username' and attribute='$attribute4' ";
$x = mysql_query($q, $conn) or die(mysql_error());
$l = mysql_fetch_array($x);
if ($j = mysql_num_rows($x) > 0) {
$attribute4_value = $l[value];
} else {
$attribute4_value = "unlimited";
$masaAktiveHr = "unlimited";
$attribute4_value = 2592000; // 30 hari
$q = "insert into radcheck (username,attribute,value) ";
$q .= "values ('$username','$attribute4','$attribute4_value')";
$x = mysql_query($q, $conn) or die(mysql_error());
}
$masaAktiveHr = $attribute4_value / 86400 . " hari";
// menghitung bandwit yang sudah dipakai
$q = "SELECT SUM(acctinputoctets) AS 'totalUpload', SUM(acctoutputoctets) AS 'totalDownload' FROM radacct ";
$q .= "where username='$username' AND acctstoptime IS NOT NULL";
$x = mysql_query($q, $conn) or die(mysql_error());
$l = mysql_fetch_array($x);
$totalUpload = $l['totalUpload'];
$totalDownload = $l['totalDownload'];
$masaAktive = $attribute4_value; // second
$kuota = $limitQuotaBw; // byte
$pemakaianBw = $totalUpload + $totalDownload; // byte
$sisaQbw = $limitQuotaBw - $pemakaianBw; // byte
// die();
// $q = "insert into radtemp (username,totalupload,totaldownload,totalbw,tanggal,quotabw,sisaquotabw) ";
// $q .= "values ('$username','$totalUpload','$totalDownload','$pemakaianBw',CURRENT_TIMESTAMP(),'$limitQuotaBw','$sisaQbw')";
// $x = mysql_query($q, $conn) or die(mysql_error());
// membuat kuota menjadi unlimid
$q = "update radcheck set username='$username-slow' ";
$q .= "where username='$username' AND attribute='$attribute6'";
$x = mysql_query($q, $conn) or die(mysql_error());
// membuat premium jadi limited
$query = "insert into radreply (username,attribute,op,value) values ('$username','$attribute5','$op','$newLK')";
$action = mysql_query($query, $conn) or die(mysql_error());
echo "";
//creatLog
$jenis = "slow";
$deskripsi = "berikut ini adalah status voucher anda
";
include "userTraffic.php";
$strTitle .= " $username";
// $strMain .= "";
if ($habis == 'Voucher $username sudah EXPIRED
";
// region khusu untuk user special
if (in_array("$username", $arrUserSpecial)) {
$strMain .= "Apakah masih ingin melanjutkan?
";
}
// endregion khusu untuk agus bigburger
}
elseif (($limitTotal > 0) and ($pemakaianBw >= $limitTotal)) {
if (in_array("$username", $arrUserSuperSpecial)) {
$slow = "$_SERVER[PHP_SELF]?Mode=Reload&u=$username&j=1";
} else {
$slow = "$_SERVER[PHP_SELF]?Mode=SlowOn";
}
$strMain .= "";
$strMain .= "
Quota bandwith Anda sudah tercapai, lakukan refill sebelum expired.!";
// $strMain .= "";
$strMain .= "
";
//$linkDelete="Hapus";
//$strMain.="atau klik tombol ";
// tidak dipakai gantinya mode SlowOn
if (isset($_POST['submit'])) // mengaktifkan slow mode
{
$up = $_POST['upload'];
$dw = $_POST['download'];
//$strMain.=show_confirm()."";
//echo "";
$attribute0 = "Cleartext-Password";
$attribute1 = "lifetime-limit";
$attribute2 = "Mikrotik-Xmit-Limit";
$attribute3 = "Mikrotik-Recv-Limit";
$attribute6 = "Mikrotik-Total-Limit";
$attribute4 = "Max-Access-Period-Time";
$attribute5 = "Mikrotik-Rate-Limit";
$op = ":=";
$newMA = $masaAktif + $masaAktif2; //period-time
$newLT = $limitUptime + $limitUptime2; //limit-uptime
$newLU = $limitUpload + $uploadLimit2;
$newLD = $limitDownload + $downloadLimit2;
$newLBw = $limitTotal + $limitTotal2;
$limitKecepatan2 = "$up/$dw";
$newLK = $limitKecepatan2;
$query = "insert into radreply (username,attribute,op,value) values ('$username','$attribute5','$op','$newLK')";
$action = mysql_query($query, $conn) or die(mysql_error());
$q = "update radcheck set username='$username-slow' ";
$q .= "where username='$username' AND attribute='$attribute6'";
$x = mysql_query($q, $conn) or die(mysql_error());
$msg = "Slow Mode diaktifkan";
echo "";
//creatLog
$jenis = "slow";
$deskripsi = "Quota bandwith Anda sudah tercapai, lakukan refill sebelum expired.!Anda masih bisa melanjutkan access dengan
kecepatan terbatas, dengan mengeklik tombol SLOW MODE";
$strMain .= " atau klik disini untuk melakukan refill";
$strMain .= "
";
$strMain .= " Waktu online anda sudah berakhir !!!
";
}
else {
$strMain .= "Koneksi internet Anda akan otomatis terputus ketika salah satu dari masa aktif, quota bandwith, atau batas waktu online Anda telah habis
";
}
$idhot = $sesNama;
include_once "../../Pages/Radius/lastRefill.php";
$strNote .= "$lastRefill";
//creatLog
// $jenis="view";
// $deskripsi="melihat pemakaian Voucher $username sudah EXPIRED
";
}
else {
$strMain .= "Refill Box
";
$strMain .= "";
$strMain .= "";
$strMain .= "";
$strMain .= "
";
}
if (isset($_POST['submit'])) {
$username2 = $_POST['kode'];
if ($username2 == $defRef) {
$msg = "Masukan dulu kode refill";
die("");
}
$q = "select * from radrefill where username='$username2' and status='0'";
$x = mysql_query($q, $conn) or die(mysql_error());
$num = mysql_num_rows($x);
$l = mysql_fetch_array($x);
if ($num == 0) {
$msg = "Kode refill tidak valid";
$q = "update radcheck set refillProc=refillProc+1 ";
$q .= "where username='$username'";
$x = mysql_query($q, $conn) or die(mysql_error());
//creatLog
$jenis = "refill";
$deskripsi = "gagal merefill dengan kode Voucher $username sudah EXPIRED
";
}
else {
$strMain .= "Refill Box
";
$strMain .= "";
$strMain .= "";
$strMain .= "";
$strMain .= "
";
if ($refillProc > 0) {
$errorRefill = "Salah memasukan kode refill $refillProc kali";
}
$strNote .= "$errorRefill
";
//$strNote.="$kode $downloadLimit2 $uploadLimit2 $onlineLimit2 $speedDownload2 / $speedUpload2 $lifeTimeLimit2
";
//$strMain.="$masaAktif $limitUpload $limitDownload $limitUptime $limitKecepatan
";
$attribute0 = "Cleartext-Password";
$attribute1 = "lifetime-limit";
$attribute2 = "Mikrotik-Xmit-Limit";
$attribute3 = "Mikrotik-Recv-Limit";
$attribute6 = "Mikrotik-Total-Limit";
$attribute4 = "Max-Access-Period-Time";
$attribute5 = "Mikrotik-Rate-Limit";
$op = ":=";
//$newPT=
if ($limitTotalSlow > 0) {
$q = "SELECT * FROM radtemp where username='$username' order by tanggal desc limit 1";
$x = mysql_query($q, $conn) or die(mysql_error());
if (mysql_num_rows($x) > 0) {
$l = mysql_fetch_array($x);
// $totalUpload = $l['totalupload'];
// $totalDownload = $l['totaldownload'];
// $totalBw = $l['totalbw'];
// $quotabw = $l['quotabw'];
$sisaQbw = $l['sisaquotabw'];
}
//$limitTotal=$limitTotalSlow;
//$newMA=$masaAktif+$masaAktif2; //period-time
$newMA = $DT + $masaAktif2; //period-time
$newLT = $limitUptime + $limitUptime2; //limit-uptime
$newLU = $limitUpload + $uploadLimit2;
$newLD = $limitDownload + $downloadLimit2;
//$newLBw=$limitTotalSlow+$limitTotal2;
$newLBw = $sisaQbw + $limitTotal2;
//$newLBw=$sisaQbw+$limitTotal2;
$limitKecepatan2 = "$speedUpload2/$speedDownload2";
$newLK = $limitkecepatan + $limitKecepatan2;
}
else {
//$newMA=$masaAktif+$masaAktif2; //period-time
$newMA = $DT + $masaAktif2; //period-time
//$newLT=$limitUptime+$limitUptime2; //limit-uptime
$newLT = $limitUptime + $limitUptime2; //limit-uptime
$newLU = $limitUpload + $uploadLimit2;
$newLD = $limitDownload + $downloadLimit2;
//$newLBw=$limitTotal+$limitTotal2;
$newLBw = $sisaQbw + $limitTotal2;
$limitKecepatan2 = "$speedUpload2/$speedDownload2";
$newLK = $limitkecepatan + $limitKecepatan2;
}
if ($newLT <= $limitUptime) {
$q = "delete from radcheck ";
$q .= "where username='$username' AND attribute='$attribute1'";
$x = mysql_query($q, $conn) or die(mysql_error());
}
else //uptime
{
$q = "update radcheck set value='$newLT' ";
$q .= "where username='$username' AND attribute='$attribute1'";
$x = mysql_query($q, $conn) or die("");
}
if ($newMA <= $masaAktif) //periode
{
$q = "update radcheck set value='0' ";
$q .= "where username='$username' AND attribute='$attribute4'";
$x = mysql_query($q, $conn) or die("");
}
else {
$q = "update radcheck set value='$newMA' ";
$q .= "where username='$username' AND attribute='$attribute4'";
$x = mysql_query($q, $conn) or die("");
}
if ($limitTotalSlow > 0) {
$q = "delete from radreply ";
$q .= "where username='$username'";
$x = mysql_query($q, $conn) or die(mysql_error());
$q = "update radcheck set username='$username',value='$newLBw' ";
$q .= "where username='$username-slow' AND attribute='$attribute6'";
$x = mysql_query($q, $conn) or die(mysql_error());
}
else {
$q = "update radcheck set value='$newLBw' ";
$q .= "where username='$username' AND attribute='$attribute6'";
$x = mysql_query($q, $conn) or die("");
}
$q = "delete from radreply ";
$q .= "where username='$username'";
$x = mysql_query($q, $conn) or die(mysql_error());
// merername history
$q = "update radacct set username='$username-his' ";
$q .= "where username='$username'";
$x = mysql_query($q, $conn) or die("");
$q = "update radrefill set status='1',tglUsed=CURRENT_TIMESTAMP,user='$username' ";
$q .= "where username='$kode'";
$x = mysql_query($q, $conn) or die(mysql_error());
$q = "update radcheck set refill=refill+1 ";
$q .= "where username='$username'";
$x = mysql_query($q, $conn) or die(mysql_error());
// mencatat refill pada history
$vrefillGb = $limitTotal2 / 1073741824; // Gb
$comment = "refill $vrefillGb Gb ";
$q = "insert into radacct (username,acctstarttime,acctstoptime,type,comment)";
$q .= "values('$username',CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,'1','$comment' )";
$x = mysql_query($q, $conn) or die(toAlert(mysql_error() . " on " . __FUNCTION__ . " line " . __LINE__ . " file " . __FILE__));
$msg = "Refill Sukses";
echo "";
//$strMain.= "$username sudah berhasil di refil!
";
//mereset log kesalahan refill
$q = "update radcheck set refillProc='0' ";
$q .= "where username='$username'";
$x = mysql_query($q, $conn) or die(mysql_error());
//creatLog
$jenis = "refill";
//$deskripsi="$username merefill dengan kode Voucher $username sudah EXPIRED
";
}
else {
$strMain .= "Refill Box
";
$strMain .= "";
$strMain .= "";
$strMain .= "";
$strMain .= "
";
if ($refillProc > 0) {
$errorRefill = "Salah memasukan kode refill $refillProc kali";
}
$strNote .= "$errorRefill
";
//$strNote.="$kode $downloadLimit2 $uploadLimit2 $onlineLimit2 $speedDownload2 / $speedUpload2 $lifeTimeLimit2
";
//$strMain.="$masaAktif $limitUpload $limitDownload $limitUptime $limitKecepatan
";
$attribute0 = "Cleartext-Password";
$attribute1 = "lifetime-limit";
$attribute2 = "Mikrotik-Xmit-Limit";
$attribute3 = "Mikrotik-Recv-Limit";
$attribute4 = "Max-Access-Period-Time";
$attribute5 = "Mikrotik-Rate-Limit";
$attribute6 = "Mikrotik-Total-Limit";
$op = ":=";
$q = "update radcheck set value='$masaAktif2' ";
$q .= "where username='$username' AND attribute='$attribute4'";
$x = mysql_query($q, $conn) or die("");
$q = "delete from radreply ";
$q .= "where username='$username'";
$x = mysql_query($q, $conn) or die(mysql_error());
$q = "update radcheck set username='$username',value='$limitTotal2' ";
$q .= "where username='$username-slow' AND attribute='$attribute6'";
$x = mysql_query($q, $conn) or die(mysql_error());
// merername history
$q = "update radacct set username='$username-his' ";
$q .= "where username='$username'";
$x = mysql_query($q, $conn) or die("");
$q = "update radrefill set status='1',tglUsed=CURRENT_TIMESTAMP,user='$username' ";
$q .= "where username='$kode'";
$x = mysql_query($q, $conn) or die(mysql_error());
$q = "update radcheck set refill=refill+1 ";
$q .= "where username='$username'";
$x = mysql_query($q, $conn) or die(mysql_error());
// mencatat refill pada history
$vrefillGb = $limitTotal2 / 1073741824; // Gb
$comment = "refill $vrefillGb Gb ";
$q = "insert into radacct (username,acctstarttime,acctstoptime,type,comment)";
$q .= "values('$username',CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,'1','$comment' )";
$x = mysql_query($q, $conn) or die(toAlert(mysql_error() . " on " . __FUNCTION__ . " line " . __LINE__ . " file " . __FILE__));
$msg = "Refill Sukses";
echo "";
//$strMain.= "$username sudah berhasil di refil!
";
//mereset log kesalahan refill
$q = "update radcheck set refillProc='0' ";
$q .= "where username='$username'";
$x = mysql_query($q, $conn) or die(mysql_error());
//creatLog
$jenis = "refill";
//$deskripsi="$username merefill dengan kode history pemakaian anda
";
$sip = "IP Addr";
$sdw = "Download";
$sup = "Upload";
$sdu = "Durasi Online";
include "history.php";
//creatLog
$jenis = "view";
$deskripsi = "melihat history";
creatLog($logUser, $level, $jenis, $deskripsi);
$idhot = $sesNama;
include_once "../../Pages/Radius/lastRefill.php";
$strNote = "$lastRefill";
break;
case "History2":
$hisNama = $_GET[nama];
if (isset($hisNama)) {
if ($hisNama != $sesNama) {
$msg = "Illegal operation";
die (toAlert("$msg"));
// echo "$msg $sesNama";
}
}
$historyUser = $_POST['nama'];
if (!$historyUser) {
$historyUser = $logUser;
}
$strTitle .= "History Pemakaian sebelum refil";
$strMainTitle = "history pemakaian anda sebelum refill
";
include "history2.php";
$strNote .= "Untuk melakukan Shorting data, klik pada HEADER TABLE yang berwarna kuning";
//creatLog
$jenis = "view";
$deskripsi = "melihat history";
creatLog($logUser, $level, $jenis, $deskripsi);
break;
default:
$m = $_GET[Mode];
//echo "$m";
if ($m == "Refill") {
header("location:$_SERVER[PHP_SELF]?Mode=RefillV2");
}
$strTitle .= "Vito Spot";
//
$strMain .= "";
$strMain .= "
";
/*
$id=$_GET[id]>0?$_GET[id]:7;
$q="select * from pages where id='$id' order by urut,id";
$x=mysql_query($q,$conn) or die(mysql_error());
while($l=mysql_fetch_assoc($x))
{
$id=$l[id];
$judul=$l[judul];
$isi=$l[isi];
$image=$l[image];
$strMainGambar="$image";
$strMainTitle.="$judul
"; $strMain.="$isi
";
}
*/
break;
}
}
}
else {
$strTopMenu .= "gunakan ID hotspot untuk login "; $strMain .= ""; } $strTitle = "$strTitle $judul"; $tmpTemplate = "../../Assets/Templates/View.html"; $t = new clTemplate; $t->defineTheme($tmpTemplate); $t->defineTag("{appTemplate}", $appTemplate); $t->defineTag("{title}", $strTitle); $t->defineTag("{sesNama}", $strSesNama); $t->defineTag("{gbrHeader}", $strGbrHeader); $t->defineTag("{header}", $strHeader); $t->defineTag("{topMenu}", $strTopMenu); $t->defineTag("{leftMenu}", $strLeftMenu); $t->defineTag("{mainTitle}", $strMainTitle); $t->defineTag("{main}", $strMain); $t->defineTag("{note}", $strNote); $t->defineTag("{mainGambar}", $strMainGambar); $t->defineTag("{ymID}", $strymID); $t->defineTag("{ip}", $strIp); $t->parse(); $t->printTheme(); ?>