"No",1=>"Yes");
$body=new clBody;
?>LIMITED";
$ingat = "PERINGATAN!
dalam mode LIMITED ini kecepatan akses Anda terbatas ada kemungkinan halaman web yang tidak bisa dibuka. segera lakukan isi ulang untuk di sini kembali bis amenikmati akses koneksi premium";
}
else {
$mode = "premium";
}
$q = "select * from radcheck where username='$username' AND attribute='Cleartext-Password'";
$x = mysql_query($q, $conn) or die(mysql_error());
$num = mysql_num_rows($x);
$l = mysql_fetch_array($x);
$refillProc = $l[refillProc];
if ($num == 0) {
$strMain .= "Username $username tidak ditemukan
";
}
else {
//echo "$nama";
$q = "select * from radcheck where username='$username' AND attribute='Max-Access-Period-Time'";
$x = mysql_query($q, $conn) or die(mysql_error());
// $statusMasaAktif = mysql_num_rows($x);
while ($l2 = mysql_fetch_assoc($x)) {
$masaAktif = $l2['value'];
}
$masaAktifJam = $masaAktif / 3600;
$MAhari = (int)($masaAktifJam / 24);
$MAsjam = (int)($masaAktif / 3600);
$MAsmenit = (int)(($masaAktif % 3600) / 60);
$MAsdetik = ($masaAktif % 3600) % 60;
//echo "$masaAktif detik $MAjam jam $MAhari hari";
if (!$masaAktif) {
//$MAhari="0";
$masaAktifVoucher = "
| Masa aktif voucher |
: |
unlimited |
";
}
else {
//$strMain.="$username";
$q = "SELECT *,acctstarttime + INTERVAL $MAhari DAY AS 'expd',DATEDIFF(acctstarttime,now()) AS 'kurang',radacctid FROM radacct WHERE username='$username' ORDER BY radacctid ASC LIMIT 1";
$x = mysql_query($q, $conn) or die(mysql_error());
while ($l = mysql_fetch_assoc($x)) {
$no++;
$start = $l['acctstarttime'];
$y = substr($start, 0, 4);
$m = substr($start, 5, 2);
$d = substr($start, 8, 2);
$h = substr($start, 11, 2);
$me = substr($start, 14, 2);
$s = substr($start, 17, 2);
$username = $l['username'];
$kurang = $l['kurang'];
$ex = $l['expd'];
$expd = substr($ex, 0, 10);
}
$t = time();
$mktimeStart = mktime($h, $me, $s, $m, $d, $y); //acctstarttime
$mktimeEnd = $mktimeStart + $masaAktif; //end
$mktime = $mktimeEnd;
//$w = mktime(0, 0, 0, date('m'), date('d')+$kurang, date('Y'));
$endTime = date('Y F d H:m:s', $sD);
$hari = (int)(($mktime - time()) / 86400);
$JM = (int)(($mktime - time()) / 3600);
$jam = (int)((($mktime - time()) % 86400) / 3600);
$MN = (int)(($mktime - time()) / 60);
$menit = (int)(((($mktime - time()) % 86400) % 3600) / 60);
// $DT =(int)($mktime - $t);
$DT = ($mktime - $t);
$detik = (((($mktime - time()) % 86400) % 3600) % 60);
$q7 = "select * from radacct where username='$username'";
$x7 = mysql_query($q7, $conn) or die(mysql_error());
$num7 = mysql_num_rows($x7);
if ($num7 > 0) {
if ($DT >= 86400) $habis = "$hari hari";
elseif (($DT < 86400) && ($DT >= 3600)) $habis = "$JM jam";
elseif (($DT < 3600) && ($DT >= 60)) $habis = "$MN menit";
elseif (($DT < 60) && ($DT > 0)) $habis = "$DT detik";
elseif (($DT <= 0)) $habis = "EXPIRED";
}
//echo "$num7";
if ($MAhari > 0) {
$expired = "$MAhari hari";
}
elseif ($MAsjam > 0) {
$expired = "$MAsjam jam";
}
elseif ($MAsmenit > 0) {
$expired = "$MAsmenit menit";
}
elseif ($MAsmenit = 0) {
$expired = "$MAsdetik detik";
}
If (!$start) {
$masaAktifVoucher = "
| Masa aktif voucher |
: |
$expired dari pertama digunakan |
";
}
else {
$masaAktifVoucher = "
| Masa aktif voucher sampai |
: |
$expd |
";
$berakirDalam = "
| Akan berakhir dalam |
: |
$habis $habisp |
";
}
}
//echo "$expd";
//upload digunakan
$q = "SELECT sum(acctinputoctets) AS 'totalUpload',sum(acctoutputoctets) AS 'totalDownload',sum(acctsessiontime)AS 'totalUptime' FROM radacct WHERE username='$username' ORDER BY radacctid ASC ";
$x = mysql_query($q, $conn) or die(mysql_error());
while ($ll = mysql_fetch_assoc($x)) {
//upload=$l11[acctinputoctets];
$acctstarttime = $ll['acctstarttime'];
$acctstoptime = $ll['acctstoptime'];
$uptime = $ll['acctsessiontime'];
$upload = $ll['acctinputoctets'];
$download = $ll['acctoutputoctets'];
$totalUpload = $ll['totalUpload'];
$totalDownload = $ll['totalDownload'];
$totalUptime = $ll['totalUptime'];
}
$q = "select * from radcheck where username='$username' AND attribute='Mikrotik-Recv-Limit'";
$x = mysql_query($q, $conn) or die(mysql_error());
while ($l3 = mysql_fetch_assoc($x)) {
$limitUpload = $l3['value'];
}
$q = "select * from radcheck where username='$username' AND attribute='Mikrotik-Xmit-Limit'";
$x = mysql_query($q, $conn) or die(mysql_error());
while ($l4 = mysql_fetch_assoc($x)) {
$limitDownload = $l4['value'];
}
$q = "select * from radcheck where username='$username' AND attribute='Mikrotik-Total-Limit'";
$x = mysql_query($q, $conn) or die(mysql_error());
while ($l6 = mysql_fetch_assoc($x)) {
$limitTotal = $l6['value'];
}
$q = "select * from radcheck where username='$username-slow' AND attribute='Mikrotik-Total-Limit'";
$x = mysql_query($q, $conn) or die(mysql_error());
while ($l6 = mysql_fetch_assoc($x)) {
$limitTotalSlow = $l6['value'];
}
$q = "select * from radcheck where username='$username' AND attribute='lifetime-limit'";
$x = mysql_query($q, $conn) or die(mysql_error());
while ($l5 = mysql_fetch_assoc($x)) {
$limitUptime = $l5['value'];
}
$q = "select * from radreply where username='$username' AND attribute='Mikrotik-Rate-Limit'";
$x = mysql_query($q, $conn) or die(mysql_error());
while ($l5 = mysql_fetch_assoc($x)) {
$limitKecepatan = $l5['value'];
}
//-------------
//http://id.bestconverter.org/unitconverter_number.php
$LTGB = $limitTotal / 1073741824; //GB
$LTMB = $limitTotal / 1048576; //MB
$LTGBf = number_format($LTGB, 2);
$LTMBf = number_format($LTMB, 2);
if ($limitTotal >= 1073741824) {
$qBw = "$LTGBf";
$satQbw = "GB";
}
elseif ($limitTotal < 1073741824) {
$qBw = "$LTMBf";
$satQbw = "MB";
}
if (!$limitTotal) {
$quotaTotal = "unlimited | ";
}
else {
$quotaTotal = "$qBw $satQbw | ";
$sisaQbwnya = 1;
}
$LKMB = $limitKecepatan / 1048576;
$LDMB0 = $limitDownload / 1048576;
//$LDMB=number_format($LDMB0,2,',',' '); //merubah separator desimal dan ribuan
$LDMB = number_format($LDMB0, 2);
$TDMBB = number_format(($totalDownload / 1048576), 2);
$TDGB = $totalDownload / 1073741824; //GB
$TDMB = $totalDownload / 1048576; //MB
$TDGBf = number_format($TDGB, 2);
$TDMBf = number_format($TDMB, 2);
if ($totalDownload >= 1073741824) {
$tDl = "$TDGBf";
$satTdl = "GB";
}
elseif ($totalDownload < 1073741824) {
$tDl = "$TDMBf";
$satTdl = "MB";
}
$sisaDownload = $limitDownload - $totalDownload;
$SDMB = $sisaDownload / 1048576;
$SDMBB = number_format($SDMB, 2);
if (!$limitDownload) {
$quotaDownload = "unlimited | ";
}
else {
$quotaDownload = "$LDMB MB | ";
$sisaDownloadNih = "
| Sisa download |
: |
$SDMBB MB |
";
}
$LUMB0 = $limitUpload / 1048576;
$LUMB = number_format($LUMB0, 2);
$TUMBB = number_format(($totalUpload / 1048576), 2);
$TUGB = $totalUpload / 1073741824; //GB
$TUMB = $totalUpload / 1048576; //MB
$TUGBf = number_format($TUGB, 2);
$TUMBf = number_format($TUMB, 2);
if ($totalUpload >= 1073741824) {
$tUp = "$TUGBf";
$satUp = "GB";
}
elseif ($totalUpload < 1073741824) {
$tUp = "$TUMBf";
$satUp = "MB";
}
$sisaUpload = $limitUpload - $totalUpload;
$SUMB = $sisaUpload / 1048576;
$SUMBB = number_format($SUMB, 2);
if (!$limitUpload) {
$quotaUpload = "unlimited | ";
}
else {
$quotaUpload = "$LUMB MB | ";
$sisaUploadNih = "
| Sisa upload |
: |
$SUMBB MB |
";
}
$pemakaianBw = $totalUpload + $totalDownload;
$pBwMB = $pemakaianBw / 1048576; //MB
$pBwMBf = number_format($pBwMB, 2);
$pBwGB = $pBwMB / 1024; //GB
$pBwGBf = number_format($pBwGB, 2);
if ($limitTotalSlow == 0) {
$sisaQbw = $limitTotal - $pemakaianBw;
}
else {
$sisaQbw = $limitTotalSlow - $pemakaianBw;
}
if (($limitTotal > 0) and ($pemakaianBw >= $limitTotal)) $col = "color:red;";
if ($pemakaianBw == 0) {
$pBw = "----";
}
elseif ($pBwMB > 1024) {
$pBw = "$pBwGBf";
$satBw = "GB";
}
else {
$pBw = "$pBwMBf";
$satBw = "MB";
}
// kenenen
$sQbw = $limitTotal - $pemakaianBw;
$sQbwMb = ($sQbw / 1024) / 1024; // MB
$sQbwMbF = number_format($sQbwMb, 2);
$sQbwGb = $sQbwMb / 1024; // GB
$sQbwGbF = number_format($sQbwGb, 2);
//echo "$sQbwMb
$sQbwGb";
if ($sQbwMb > 1024){
$sF = $sQbwGbF;
$satQbw2 = "GB";
} else {
$sF = $sQbwMbF;
$satQbw2 = "MB";
}
if ($sisaQbwnya == 1){
$sisaBw = "
| Sisa quota bandwith |
: |
$sF $satQbw2 |
";
}
$LUjam = str_pad(((int)($limitUptime / 3600)), 2, 0, STR_PAD_LEFT);
$LUmenit = str_pad(((int)(($limitUptime % 3600) / 60)), 2, 0, STR_PAD_LEFT);
$LUdetik = str_pad((($limitUptime % 3600) % 60), 2, 0, STR_PAD_LEFT);
$TUjam = str_pad(((int)($totalUptime / 3600)), 2, 0, STR_PAD_LEFT);
$TUmenit = str_pad(((int)(($totalUptime % 3600) / 60)), 2, 0, STR_PAD_LEFT);
$TUdetik = str_pad((($totalUptime % 3600) % 60), 2, 0, STR_PAD_LEFT);
$sisaUptime = $limitUptime - $totalUptime;
$SUjam = str_pad(((int)($sisaUptime / 3600)), 2, 0, STR_PAD_LEFT);
$SUmenit = str_pad(((int)(($sisaUptime % 3600) / 60)), 2, 0, STR_PAD_LEFT);
$SUdetik = str_pad((($sisaUptime % 3600) % 60), 2, 0, STR_PAD_LEFT);
$colo = $sisaUptime <= 0 ? 'color:red;' : '';
if ($limitUptime == 0) {
$batasWaktuOnline = "Unlimited";
}
else {
$batasWaktuOnline = "$LUjam : $LUmenit : $LUdetik ";
$sisaWaktu = "
| Sisa waktu |
: |
$SUjam : $SUmenit : $SUdetik |
";
}
$strMain .= "";
$strMain .= "
";
$strMain .= "
| Status koneksi |
: |
$mode |
";
$strMain .= "$masaAktifVoucher";
$strMain .= "$berakirDalam";
$strMain .= "
| Quota bandwith |
: |
$quotaTotal
";
$strMain .= "
| Upload digunakan |
: |
$tUp $satUp |
";
$strMain .= "
| Download digunakan |
: |
$tDl $satTdl |
";
$strMain .= "
| Total Pemakaian |
: |
$pBw $satBw |
";
$strMain .= "$sisaBw";
$strMain .= "
| Batas waktu Online |
: |
$batasWaktuOnline |
";
$strMain .= "
| Digunakan |
: |
$TUjam : $TUmenit : $TUdetik |
";
$strMain .= "$sisaWaktu";
$strMain .= "
";
$strMain .= "