echo "<table border='0' class='table1'>\n";
echo "\n <thead>\n <tr>\n <th colspan='12' align='left'>\n\n <input class='button' type='button' value='CSV Export'\n onClick=\"javascript:window.location.href='include/management/fileExport.php?reportFormat=csv'\"\n />\n <br/>\n <br/>\n ";
if ($configValues['CONFIG_IFACE_TABLES_LISTING_NUM'] == "yes") {
setupNumbering($numrows, $rowsPerPage, $pageNum, $orderBy, $orderType, "&username={$username}&startdate={$startdate}&enddate={$enddate}");
}
echo " </th></tr>\n\t\t\t</thead>\n\t";
if ($orderType == "asc") {
$orderType = "desc";
} else {
if ($orderType == "desc") {
$orderType = "asc";
}
}
echo "<thread> <tr>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=radacctid&orderType={$orderType}\">\n\t\t" . $l['all']['ID'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=hotspot&orderType={$orderType}\">\n\t\t" . $l['all']['HotSpot'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=username&orderType={$orderType}\">\n\t\t" . $l['all']['Username'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=framedipaddress&orderType={$orderType}\">\n\t\t" . $l['all']['IPAddress'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctstarttime&orderType={$orderType}\">\n\t\t" . $l['all']['StartTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctstoptime&orderType={$orderType}\">\n\t\t" . $l['all']['StopTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctsessiontime&orderType={$orderType}\">\n\t\t" . $l['all']['TotalTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctinputoctets&orderType={$orderType}\">\n\t\t" . $l['all']['Upload'] . " (" . $l['all']['Bytes'] . ")</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctoutputoctets&orderType={$orderType}\">\n\t\t" . $l['all']['Download'] . " (" . $l['all']['Bytes'] . ")</a>\n\t\t</th>\n\t\t<th scope='col'>\n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctterminatecause&orderType={$orderType}\">\n\t\t " . $l['all']['Termination'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=nasipaddress&orderType={$orderType}\">\n\t\t" . $l['all']['NASIPAddress'] . "</a>\n\t\t</th>\n </tr> </thread>";
while ($row = $res->fetchRow()) {
printqn("<tr>\n\t\t\t\t<td> {$row['0']} </td>\n\t\t <td> {$row['1']} </td>\n\t <td> {$row['2']} </td>\n\t\t\t\t<td> {$row['3']} </td>\n\t\t\t\t<td> {$row['4']} </td>\n\t\t\t\t<td> {$row['5']} </td>\n\t\t\t\t<td> " . time2str($row[6]) . " </td>\n\t\t\t\t<td> " . toxbyte($row[7]) . "</td>\n\t\t\t\t<td> " . toxbyte($row[8]) . "</td>\n\t\t\t\t<td> {$row['9']} </td>\n\t\t\t\t<td> {$row['10']} </td>\n\t\t</tr>");
}
echo "\n <tfoot>\n <tr>\n <th colspan='12' align='left'>\n ";
setupLinks($pageNum, $maxPage, $orderBy, $orderType, "&username={$username}&startdate={$startdate}&enddate={$enddate}");
echo "\n </th>\n </tr>\n </tfoot>\n ";
echo "</table>";
include 'library/closedb.php';
?>
</div>
<?php
include 'include/config/logging.php';
?>
echo "<table border='0' class='table1'>\n";
echo "\n <thead>\n <tr>\n <th colspan='12' align='left'>\n\n <input class='button' type='button' value='CSV Export'\n onClick=\"javascript:window.location.href='include/management/fileExport.php?reportFormat=csv'\"\n />\n <br/>\n <br/>\n ";
if ($configValues['CONFIG_IFACE_TABLES_LISTING_NUM'] == "yes") {
setupNumbering($numrows, $rowsPerPage, $pageNum, $orderBy, $orderType, "&username={$username}&startdate={$startdate}&enddate={$enddate}");
}
echo " </th></tr>\n\t\t\t</thead>\n\t";
if ($orderType == "asc") {
$orderTypeNextPage = "desc";
} else {
if ($orderType == "desc") {
$orderTypeNextPage = "asc";
}
}
echo "<thread> <tr>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=radacctid&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['ID'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=hotspot&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['HotSpot'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=username&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['Username'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=framedipaddress&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['IPAddress'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctstarttime&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['StartTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctstoptime&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['StopTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctsessiontime&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['TotalTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctinputoctets&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['Upload'] . " (" . $l['all']['Bytes'] . ")</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctoutputoctets&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['Download'] . " (" . $l['all']['Bytes'] . ")</a>\n\t\t</th>\n\t\t<th scope='col'>\n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctterminatecause&orderType={$orderTypeNextPage}\">\n\t\t " . $l['all']['Termination'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=nasipaddress&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['NASIPAddress'] . "</a>\n\t\t</th>\n </tr> </thread>";
while ($row = $res->fetchRow()) {
printqn("<tr>\n\t\t\t\t<td> {$row['0']} </td>\n\n <td> <a class='tablenovisit' href='javascript:return;'\n onClick='javascript:ajaxGeneric(\"include/management/retHotspotInfo.php\",\"retHotspotGeneralStat\",\"divContainerHotspotInfo\",\"hotspot={$row['1']}\");\n javascript:__displayTooltip();'\n tooltipText='\n <a class=\"toolTip\" href=\"mng-hs-edit.php?name={$row['1']}\">\n {$l['Tooltip']['HotspotEdit']}</a>\n \n <a class=\"toolTip\" href=\"acct-hotspot-compare.php?\">\n {$l['all']['Compare']}</a>\n <br/><br/>\n\n <div id=\"divContainerHotspotInfo\">\n Loading...\n </div>\n <br/>'\n >{$row['1']}</a>\n </td>\n\n <td> <a class='tablenovisit' href='javascript:return;'\n onClick='javascript:ajaxGeneric(\"include/management/retUserInfo.php\",\"retBandwidthInfo\",\"divContainerUserInfo\",\"username={$row['2']}\");\n javascript:__displayTooltip();'\n tooltipText='\n <a class=\"toolTip\" href=\"mng-edit.php?username={$row['2']}\">\n\t {$l['Tooltip']['UserEdit']}</a>\n <br/><br/>\n\n <div id=\"divContainerUserInfo\">\n Loading...\n </div>\n <br/>'\n >{$row['2']}</a>\n </td>\n\t\t\t\t<td> {$row['3']} </td>\n\t\t\t\t<td> {$row['4']} </td>\n\t\t\t\t<td> {$row['5']} </td>\n\t\t\t\t<td> " . time2str($row[6]) . " </td>\n\t\t\t\t<td> " . toxbyte($row[7]) . "</td>\n\t\t\t\t<td> " . toxbyte($row[8]) . "</td>\n\t\t\t\t<td> {$row['9']} </td>\n\t\t\t\t<td> {$row['10']} </td>\n\t\t</tr>");
}
echo "\n <tfoot>\n <tr>\n <th colspan='12' align='left'>\n ";
setupLinks($pageNum, $maxPage, $orderBy, $orderType, "&username={$username}&startdate={$startdate}&enddate={$enddate}");
echo "\n </th>\n </tr>\n </tfoot>\n ";
echo "</table>";
include 'library/closedb.php';
?>
</div>
<?php
include 'include/config/logging.php';
?>
<?php
include '../../library/checklogin.php';
include_once 'pages_common.php';
if (isset($_GET['retBandwidthInfo'])) {
$divContainer = $_GET['divContainer'];
// get target div id
$username = $_GET['username'];
include '../../library/opendb.php';
$sql = "SELECT SUM(AcctInputOctets) AS Upload, SUM(AcctOutputOctets) AS Download FROM " . $configValues['CONFIG_DB_TBL_RADACCT'] . " WHERE UserName='******'";
$res = $dbSocket->query($sql);
$row = $res->fetchRow(DB_FETCHMODE_ASSOC);
$upload = toxbyte($row['Upload']);
$download = toxbyte($row['Download']);
if ($upload <= 0) {
$upload = 0;
}
if ($download <= 0) {
$download = 0;
}
printqn("\n\t\tvar divContainer = document.getElementById('{$divContainer}');\n\t\tdivContainer.innerHTML = '<span style=\"font-weight:normal;\">Upload:</span> {$upload} <br/>" . "<span style=\"font-weight:normal;\">Download: </span> {$download}';\n\t");
}
$content .= '<br/><br/><b>' . $l['all']['NASMAC'] . ':</b> ' . $row['mac'];
$str = addToolTipBalloon(array('content' => $content, 'onClick' => '', 'value' => '<b>' . $row['hotspotname'] . '</b>', 'divId' => ''));
echo "\n\t\t\t<tr>\n\t\t\t\t<td>\n\t\t\t\t\t{$str}\n\t\t\t\t</td>\n\t\t\t\n\t\t\t\t<td>" . $row['firmware'] . "\n\t\t\t\t\t<br/>" . $row['firmware_revision'] . "\n\t\t\t\t</td>\n\t\t\t";
$content = '<b>' . $l['all']['WanIface'] . ":</b> " . $row['wan_iface'] . "<br/>" . '<b>' . $l['all']['WanMAC'] . ":</b> " . $row['wan_mac'] . "<br/>" . '<b>' . $l['all']['WanIP'] . ":</b> " . $row['wan_ip'] . "<br/>" . '<b>' . $l['all']['WanGateway'] . ":</b> " . $row['wan_ip'];
$value = '<b>' . $l['all']['WanIP'] . ":</b> " . $row['wan_ip'];
$str = addToolTipBalloon(array('content' => $content, 'onClick' => '', 'value' => $value, 'divId' => ''));
echo "<td> {$str} </td>";
$content = $l['all']['LanIface'] . ":</b> " . $row['lan_iface'] . "<br/><b>" . $l['all']['LanMAC'] . ":</b> " . $row['lan_mac'] . "<br/><b>" . $l['all']['LanIP'] . ":</b> " . $row['lan_ip'];
$value = '<b>' . $l['all']['LanIP'] . ":</b> " . $row['lan_ip'];
$str = addToolTipBalloon(array('content' => $content, 'onClick' => '', 'value' => $value, 'divId' => ''));
echo "<td> {$str} </td>";
$content = $l['all']['WifiIface'] . ":</b> " . $row['wifi_iface'] . "<br/><b>" . $l['all']['WifiMAC'] . ":</b> " . $row['wifi_mac'] . "<br/><b>" . $l['all']['WifiIP'] . ":</b> " . $row['wifi_ip'] . "<br/><b>" . $l['all']['WifiSSID'] . ":</b> " . $row['wifi_ssid'] . "<br/><b>" . $l['all']['WifiKey'] . ":</b> " . $row['wifi_key'] . "<br/><b>" . $l['all']['WifiChannel'] . ":</b> " . $row['wifi_channel'];
$value = '<b>' . $l['all']['WifiSSID'] . ":</b> " . $row['wifi_ssid'] . "<br/><b>" . $l['all']['WifiKey'] . ":</b> " . $row['wifi_key'];
$str = addToolTipBalloon(array('content' => $content, 'onClick' => '', 'value' => $value, 'divId' => ''));
echo "<td> {$str} </td>";
echo "\n\t\t\t\t<td>" . time2str($row['uptime']) . "\n\t\t\t\t</td>\n\n\t\t\t\t<td>" . $row['memfree'] . "\n\t\t\t\t</td>\n\n\t\t\t\t<td>" . toxbyte($row['wan_bup']) . "\n\t\t\t\t</td>\n\n\t\t\t\t<td>" . toxbyte($row['wan_bdown']) . "\n\t\t\t\t</td>\n\n\t\t\t\t<td>" . $row['time'] . "\n\t\t\t\t</td>\n\t\t\t\t\n\t\t\t</tr>\n\t\t";
/*
printqn("
<td> <input type='checkbox' name='username[]' value='$row[0]'>$row[2]</td>
<td>
");
if ( ($row[1] == "Reject") && ($row[4] == "Auth-Type") )
echo "<img title='user is disabled' src='images/icons/userStatusDisabled.gif' alt='[disabled]'>";
else
echo "<img title='user is enabled' src='images/icons/userStatusActive.gif' alt='[enabled]'>";
printqn("
<a class='tablenovisit' href='javascript:return;'
</span> </td>
</tr>
</table>
<?php
echo "<h3>Harddrive Information</h3>";
$hddfreespace = get_hdd_freespace();
?>
<table class='summarySection'>
<tr>
<td class='summaryKey'> Free Drive Space </td>
<td class='summaryValue'><span class='sleft'><?php
echo toxbyte($hddfreespace);
?>
</span> </td>
</tr>
</table>
<?php
echo "<h3>Network Interfaces</h3>";
$iflist = get_interface_list();
foreach ($iflist as $ifname) {
echo "\t<table class='summarySection'>\n";
echo "\t<tr>\n";
echo "\t\t<td class='summaryKey'></td>\n";
echo "\t\t<td class='stitle'>\n";
echo "\t\t\t{$ifname}\n";
$sql = "SELECT " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".name AS hotspot, count(distinct(UserName)) AS uniqueusers, count(radacctid) AS totalhits, " . " avg(AcctSessionTime) AS avgsessiontime, sum(AcctSessionTime) AS totaltime, " . " avg(AcctInputOctets) AS avgInputOctets, sum(AcctInputOctets) AS sumInputOctets, " . " avg(AcctOutputOctets) AS avgOutputOctets, sum(AcctOutputOctets) AS sumOutputOctets " . " FROM " . $configValues['CONFIG_DB_TBL_RADACCT'] . " JOIN " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . " on (" . $configValues['CONFIG_DB_TBL_RADACCT'] . ".calledstationid LIKE " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".mac) GROUP BY " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".name ORDER BY {$orderBy} {$orderType};";
$res = $dbSocket->query($sql);
$logDebugSQL = "";
$logDebugSQL .= $sql . "\n";
echo "<table border='0' class='table1'>\n";
echo "\n <thead>\n <tr>\n <th colspan='10'>" . $l['all']['Records'] . "</th>\n </tr>\n </thead>\n ";
if ($orderType == "asc") {
$orderType = "desc";
} else {
if ($orderType == "desc") {
$orderType = "asc";
}
}
echo "<thread> <tr>\n <th scope='col'> \n\t\t\t<br/>\n\t\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=hotspot&orderType={$orderType}\">\n\t\t\t" . $l['all']['HotSpot'] . "</a>\n\t\t\t</th>\n\t\t\t<th scope='col'> \n\t\t\t<br/>\n\t\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=uniqueusers&orderType={$orderType}\">\n\t\t\t" . $l['all']['UniqueUsers'] . "</a>\n\t\t\t</th>\n\t\t\t<th scope='col'> \n\t\t\t<br/>\n\t\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=totalhits&orderType={$orderType}\">\n\t\t\t" . $l['all']['TotalHits'] . "</a>\n\t\t\t</th>\n\t\t\t<th scope='col'> \n\t\t\t<br/>\n\t\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=avgsessiontime&orderType={$orderType}\">\n\t\t\t" . $l['all']['AverageTime'] . "</a>\n\t\t\t</th>\n\t\t\t<th scope='col'> \n\t\t\t<br/>\n\t\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=totaltime&orderType={$orderType}\">\n\t\t\t" . $l['all']['TotalTime'] . "</a>\n\t\t\t</th>\n\t\t\t<th scope='col'> \n\t\t\t<br/>\n\t\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=sumInputOctets&orderType={$orderType}\">\n\t\t\tTotal Uploads</a>\n\t\t\t</th>\n\t\t\t<th scope='col'> \n\t\t\t<br/>\n\t\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=sumOutputOctets&orderType={$orderType}\">\n\t\t\tTotal Downloads</a>\n\t\t\t</th>\n </tr> </thread>";
while ($row = $res->fetchRow()) {
echo "<tr>\n <td> {$row['0']} </td>\n <td> {$row['1']} </td>\n <td> {$row['2']} </td>\n <td> " . time2str($row[3]) . " </td>\n <td> " . time2str($row[4]) . " </td>\n\t\t\t<td> " . toxbyte($row[6]) . "</td>\n\t\t\t<td> " . toxbyte($row[8]) . "</td>\n </tr>";
}
echo "</table>";
include 'library/closedb.php';
?>
</div>
<div class="tabbertab" title="Graph">
<?php
echo "<br/><br/><br/><center>";
echo "<img src=\"library/graphs-hotspot-compare-unique-users.php\" /><br/><br/>";
echo "<img src=\"library/graphs-hotspot-compare-hits.php\" /><br/><br/>";
echo "<img src=\"library/graphs-hotspot-compare-time.php\" /><br/><br/>";
echo "</center>";
function userConnectionStatus($username, $drawTable)
{
$userStatus = checkUserOnline($username);
include_once 'include/management/pages_common.php';
include 'library/opendb.php';
$username = $dbSocket->escapeSimple($username);
// sanitize variable for sql statement
$sql = "SELECT AcctStartTime,AcctSessionTime,NASIPAddress,CalledStationId,FramedIPAddress,CallingStationId" . ",AcctInputOctets,AcctOutputOctets FROM " . $configValues['CONFIG_DB_TBL_RADACCT'] . " WHERE Username='******' ORDER BY RadAcctId DESC LIMIT 1";
$res = $dbSocket->query($sql);
$row = $res->fetchRow(DB_FETCHMODE_ASSOC);
$userUpload = toxbyte($row['AcctInputOctets']);
$userDownload = toxbyte($row['AcctOutputOctets']);
$userLastConnected = $row['AcctStartTime'];
$userOnlineTime = time2str($row['AcctSessionTime']);
$nasIPAddress = $row['NASIPAddress'];
$nasMacAddress = $row['CalledStationId'];
$userIPAddress = $row['FramedIPAddress'];
$userMacAddress = $row['CallingStationId'];
include 'library/closedb.php';
if ($drawTable == 1) {
echo "<table border='0' class='table1'>";
echo "\r\n \t\t<thead>\r\n \t\t\t<tr>\r\n \t <th colspan='10' align='left'> \r\n \t\t\t\t<a class=\"table\" href=\"javascript:toggleShowDiv('divConnectionStatus')\">Session Info</a>\r\n \t </th>\r\n \t </tr>\r\n \t\t</thead>\r\n \t\t</table>\r\n \t";
echo "\r\n <div id='divConnectionStatus' style='display:none;visibility:visible'>\r\n \t\t<table border='0' class='table1'>\r\n \t\t<thread>\r\n\r\n <tr> \r\n <th scope='col' align='right'>\r\n User Status\r\n </th> \r\n \r\n <th scope='col' align='left'>\r\n {$userStatus}\r\n </th>\r\n </tr>\r\n\r\n <tr>\r\n <th scope='col' align='right'>\r\n Last Connection \r\n </th> \r\n \r\n <th scope='col' align='left'>\r\n {$userLastConnected}\r\n </th>\r\n </tr>\r\n\r\n <tr>\r\n <th scope='col' align='right'>\r\n Online Time\r\n </th> \r\n \r\n <th scope='col' align='left'>\r\n {$userOnlineTime}\r\n </th>\r\n </tr>\r\n\r\n <tr>\r\n <th scope='col' align='right'>\r\n Server (NAS)\r\n </th> \r\n \r\n <th scope='col' align='left'>\r\n {$nasIPAddress} (MAC: {$nasMacAddress})\r\n </th>\r\n </tr>\r\n\r\n <tr>\r\n <th scope='col' align='right'>\r\n User Workstation\r\n </th> \r\n \r\n <th scope='col' align='left'>\r\n {$userIPAddress} (MAC: {$userMacAddress})\r\n </th>\r\n </tr>\r\n\r\n <tr>\r\n <th scope='col' align='right'>\r\n User Upload\r\n </th> \r\n \r\n <th scope='col' align='left'>\r\n {$userUpload}\r\n </th>\r\n </tr>\r\n\r\n\r\n <tr>\r\n <th scope='col' align='right'>\r\n User Download\r\n </th> \r\n \r\n <th scope='col' align='left'>\r\n {$userDownload}\r\n </th>\r\n </tr>\r\n\r\n </table>\r\n\r\n \t\t</div>\r\n \t";
}
}
$str = addToolTipBalloon(array('content' => $content, 'onClick' => '', 'value' => $value, 'divId' => ''));
echo "<td> {$str} </td>";
// calculate time delay
$currTime = time();
$checkinTime = strtotime($row['time']);
if ($currTime - $checkinTime >= 60 * $hardDelay) {
// this is hard delay
$delayColor = 'red';
} elseif ($currTime - $checkinTime >= 60 * $softDelay && $currTime - $checkinTime < 60 * $hardDelay) {
// this is soft delay
$delayColor = 'orange';
} else {
// this is no delay at all, meaning not above 5 minutes delay
$delayColor = 'green';
}
echo "\n\t\t\t\t<td>" . time2str($row['uptime']) . "\n\t\t\t\t</td>\n\n\t\t\t\t<td>" . $row['cpu'] . "\n\t\t\t\t</td>\n\t\t\t\t\n\t\t\t\t<td>" . $row['memfree'] . "\n\t\t\t\t</td>\n\n\t\t\t\t<td>" . toxbyte($row['wan_bup']) . "\n\t\t\t\t</td>\n\n\t\t\t\t<td>" . toxbyte($row['wan_bdown']) . "\n\t\t\t\t</td>\n\n\t\t\t\t<td> <font color='{$delayColor}'> " . $row['time'] . "\n\t\t\t\t\t</font>\n\t\t\t\t</td>\n\t\t\t\t\n\t\t\t</tr>\n\t\t";
}
echo "\n\t\t\t\t\t<tfoot>\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<th colspan='11' align='left'> \n\t";
setupLinks($pageNum, $maxPage, $orderBy, $curOrderType);
echo "\t\t\t\t\t\t\t</th>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t</tfoot>\n\t\t";
echo "</table>";
echo "</form>";
include 'library/closedb.php';
?>
<?php
include 'include/config/logging.php';
?>
<?php
include '../../library/checklogin.php';
include_once 'pages_common.php';
if (isset($_GET['retHotspotGeneralStat'])) {
$divContainer = $_GET['divContainer'];
// get target div id
$hotspot = $_GET['hotspot'];
include '../../library/opendb.php';
$sql = "SELECT " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".name AS hotspot, count(distinct(UserName)) AS uniqueusers, count(radacctid) AS totalhits, " . " avg(AcctSessionTime) AS avgsessiontime, sum(AcctSessionTime) AS totaltime, " . " avg(AcctInputOctets) AS avgInputOctets, sum(AcctInputOctets) AS sumInputOctets, " . " avg(AcctOutputOctets) AS avgOutputOctets, sum(AcctOutputOctets) AS sumOutputOctets " . " FROM " . $configValues['CONFIG_DB_TBL_RADACCT'] . " JOIN " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . " on (" . $configValues['CONFIG_DB_TBL_RADACCT'] . ".calledstationid LIKE " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".mac) WHERE " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".name='" . $dbSocket->escapeSimple($hotspot) . "' " . " GROUP BY " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".name ;";
$res = $dbSocket->query($sql);
$row = $res->fetchRow(DB_FETCHMODE_ASSOC);
$sumUpload = toxbyte($row['sumInputOctets']);
$sumDownload = toxbyte($row['sumOutputOctets']);
$sumHits = $row['totalhits'];
if ($sumUpload <= 0) {
$sumUpload = 0;
}
if ($sumDownload <= 0) {
$sumDownload = 0;
}
if ($sumHits <= 0) {
$sumHits = 0;
}
printqn("\n\t\tvar divContainer = document.getElementById('{$divContainer}');\n\t\tdivContainer.innerHTML = '<span style=\"font-weight:normal;\">Total Uploads:</span> {$sumUpload} <br/> " . " <span style=\"font-weight:normal;\">Total Downloads:</span> {$sumDownload} <br/> " . " <span style=\"font-weight:normal;\">Total Hits:</span> {$sumHits}'\n\t");
}
}
echo "<thread> <tr>\r\n\t\t<th scope='col'>\r\n\t\t<a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?usernameOnline={$usernameOnline}&orderBy=username&orderType={$orderTypeNextPage}\">\r\n\t\t" . $l['all']['Username'] . "</a>\r\n\t\t</th>\r\n\r\n\t\t<th scope='col'>\r\n\t\t\t" . $l['all']['Name'] . "\r\n\t\t</th>\r\n\r\n\t\t<th scope='col'>\r\n\t\t<a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?usernameOnline={$usernameOnline}&orderBy=framedipaddress&orderType={$orderTypeNextPage}\">\r\n\t\t" . $l['all']['IPAddress'] . "</a>\r\n\t\t</th>\r\n\r\n\t\t<th scope='col'>\r\n\t\t<a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?usernameOnline={$usernameOnline}&orderBy=acctstarttime&orderType={$orderTypeNextPage}\">\r\n\t\t" . $l['all']['StartTime'] . "</a>\r\n\t\t</th>\r\n\r\n\t\t<th scope='col'>\r\n\t\t<a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?usernameOnline={$usernameOnline}&orderBy=acctsessiontime&orderType={$orderTypeNextPage}\">\r\n\t\t" . $l['all']['TotalTime'] . "</a>\r\n\t\t</th>\r\n\r\n\r\n\r\n\t\t<th scope='col'>\r\n\t\t\t" . $l['all']['TotalTraffic'] . "\r\n\t\t</th>\t\t\r\n\t\t\r\n\r\n\t</tr> </thread>";
while ($row = $res->fetchRow(DB_FETCHMODE_ASSOC)) {
$username = $row['Username'];
$ip = $row['FramedIPAddress'];
$usermac = $row['CallingStationId'];
$start = $row['AcctStartTime'];
$nasip = $row['NASIPAddress'];
$nasmac = $row['CalledStationId'];
$hotspot = $row['hotspot'];
$nasshortname = $row['NASshortname'];
$acctsessionid = $row['AcctSessionId'];
$name = $row['Firstname'] . " " . $row['Lastname'];
$upload = toxbyte($row['Upload']);
$download = toxbyte($row['Download']);
$traffic = toxbyte($row['Upload'] + $row['Download']);
$totalTime = time2str($row['AcctSessionTime']);
echo "<tr>\r\n\t\t\t\t<td> <input type='checkbox' name='clearSessionsUsers[]' value='{$username}||{$start}'>\r\n\t\t\t\t\t<a class='tablenovisit' href='javascript:return;'\r\n\t\t\t\t\tonclick=\"javascript:__displayTooltip();\" \r\n\t\t\t\t\ttooltipText=\"\r\n\t\t\t\t\t\t<a class='toolTip' href='mng-edit.php?username={$username}'>" . $l['Tooltip']['UserEdit'] . "</a>\r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t<a class='toolTip' href='config-maint-disconnect-user.php?username={$username}&nasaddr={$nasip}&customattributes=Acct-Session-Id={$acctsessionid}'>" . $l['all']['Disconnect'] . "</a>\r\n\t\t\t\t\t\t<br/>\"\r\n\t\t\t\t\t>{$username}</a>\r\n\t\t\t\t\t</td>\r\n\t\t\t\t<td> {$name}</td>\r\n\t\t\t\t<td> IP: {$ip}<br/>MAC: {$usermac}</td>\r\n\t\t\t\t<td> {$start} </td>\r\n\t\t\t\t<td> {$totalTime} </td>\r\n\t\t\t\t<td> " . $l['all']['Upload'] . ": {$upload} <br/> " . $l['all']['Download'] . ": {$download} <br/> " . $l['all']['TotalTraffic'] . ": <b>{$traffic}</b> </td>\r\n\t\t</tr>";
}
echo "\r\n <tfoot>\r\n <tr>\r\n <th colspan='10' align='left'>\r\n ";
setupLinks($pageNum, $maxPage, $orderBy, $orderType, "&usernameOnline={$usernameOnline}");
echo "\r\n </th>\r\n </tr>\r\n </tfoot>\r\n ";
echo "</table>";
include 'library/closedb.php';
?>
</div>
<div class="tabbertab" title="Gráfico">
<br/>
$_SESSION['reportType'] = "TopUsers";
$res = $dbSocket->query($sql);
$logDebugSQL = "";
$logDebugSQL .= $sql . "\n";
echo "<table border='0' class='table1'>\n";
echo "\n\t\t\t\t\t\t<input class='button' type='button' value='CSV Export'\n \tonClick=\"javascript:window.location.href='include/management/fileExport.php?reportFormat=csv'\"\n \t/>\n\n\t\t\t\t\t<thead>\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<th colspan='10'>" . $l['all']['Records'] . "</th>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t</thead>\n\t\t\t";
if ($orderType == "asc") {
$orderType = "desc";
} else {
if ($orderType == "desc") {
$orderType = "asc";
}
}
echo "<thread> <tr>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?limit={$limit}&orderBy=username&orderType={$orderType}&username={$username}&startdate={$startdate}&enddate={$enddate}\">\n\t\t" . $l['all']['Username'] . " </a>\n\t\t</th>\n\t\t<th scope='col'>\n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?limit={$limit}&orderBy=framedipaddress&orderType={$orderType}&username={$username}&startdate={$startdate}&enddate={$enddate}\">\n\t\t" . $l['all']['IPAddress'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?limit={$limit}&orderBy=acctstarttime&orderType={$orderType}&username={$username}&startdate={$startdate}&enddate={$enddate}\">\n\t\t" . $l['all']['StartTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?limit={$limit}&orderBy=acctstoptime&orderType={$orderType}&username={$username}&startdate={$startdate}&enddate={$enddate}\">\n\t\t" . $l['all']['StopTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?limit={$limit}&orderBy=Time&orderType={$orderType}&username={$username}&startdate={$startdate}&enddate={$enddate}\">\n\t\t" . $l['all']['TotalTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?limit={$limit}&orderBy=Upload&orderType={$orderType}&username={$username}&startdate={$startdate}&enddate={$enddate}\">\n\t\t" . $l['all']['Upload'] . " (" . $l['all']['Bytes'] . ")</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?limit={$limit}&orderBy=Download&orderType={$orderType}&username={$username}&startdate={$startdate}&enddate={$enddate}\">\n\t\t" . $l['all']['Download'] . " (" . $l['all']['Bytes'] . ")</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?limit={$limit}&orderBy=acctterminatecause&orderType={$orderType}&username={$username}&startdate={$startdate}&enddate={$enddate}\">\n\t\t" . $l['all']['Termination'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?limit={$limit}&orderBy=nasipaddress&orderType={$orderType}&username={$username}&startdate={$startdate}&enddate={$enddate}\">\n\t\t" . $l['all']['NASIPAddress'] . "</a>\n\t\t</th>\n\t\t</tr> </thread>";
while ($row = $res->fetchRow()) {
echo "<tr>\n\t\t\t\t<td> {$row['0']} </td>\n\t\t\t\t<td> {$row['1']} </td>\n\t\t\t\t<td> {$row['2']} </td>\n\t\t\t\t<td> {$row['3']} </td>\n\t\t\t\t<td> " . time2str($row[4]) . "</td>\n\t\t\t\t<td> " . toxbyte($row[5]) . "</td>\n\t\t\t\t<td> " . toxbyte($row[6]) . "</td>\n\t\t\t\t<td> {$row['7']} </td>\n\t\t\t\t<td> {$row['8']} </td>\n\t\t</tr>";
}
echo "</table>";
include 'library/closedb.php';
?>
<?php
include 'include/config/logging.php';
?>
</div>
<div id="footer">
function userBillingPayPalSummary($startdate, $enddate, $payer_email, $payment_address_status, $payer_status, $payment_status, $vendor_type, $drawTable)
{
include_once 'include/management/pages_common.php';
include 'library/opendb.php';
$startdate = $dbSocket->escapeSimple($startdate);
$enddate = $dbSocket->escapeSimple($enddate);
$payer_email = $dbSocket->escapeSimple($payer_email);
$payment_address_status = $dbSocket->escapeSimple($payment_address_status);
$payer_status = $dbSocket->escapeSimple($payer_status);
$payment_status = $dbSocket->escapeSimple($payment_status);
$sql = "SELECT " . $configValues['CONFIG_DB_TBL_DALOBILLINGMERCHANT'] . ".Username AS Username, business_email, " . $configValues['CONFIG_DB_TBL_DALOBILLINGPLANS'] . ".planName, " . $configValues['CONFIG_DB_TBL_DALOBILLINGMERCHANT'] . ".planId, SUM(payment_total) AS total, SUM(payment_fee) " . " AS fee, SUM(payment_tax) AS tax, payment_currency, SUM(AcctSessionTime) AS AcctSessionTime, SUM(AcctInputOctets) AS AcctInputOctets, " . " SUM(AcctOutputOctets) AS AcctOutputOctets " . " FROM " . $configValues['CONFIG_DB_TBL_DALOBILLINGMERCHANT'] . " LEFT JOIN " . $configValues['CONFIG_DB_TBL_RADACCT'] . " ON " . $configValues['CONFIG_DB_TBL_DALOBILLINGMERCHANT'] . ".Username="******".Username " . " LEFT JOIN " . $configValues['CONFIG_DB_TBL_DALOBILLINGPLANS'] . " ON " . $configValues['CONFIG_DB_TBL_DALOBILLINGMERCHANT'] . ".planId=" . $configValues['CONFIG_DB_TBL_DALOBILLINGPLANS'] . ".id " . " WHERE " . " (business_email LIKE '{$payer_email}') AND " . " (payment_address_status LIKE '{$payment_address_status}') AND " . " (payer_status LIKE '{$payer_status}') AND " . " (payment_status LIKE '{$payment_status}') AND " . " (vendor_type LIKE '{$vendor_type}') AND " . " (payment_date>'{$startdate}' AND payment_date<'{$enddate}')" . " GROUP BY Username";
$res = $dbSocket->query($sql);
if ($res->numRows() == 0) {
return;
}
$row = $res->fetchRow(DB_FETCHMODE_ASSOC);
$planTotalCost = $row['total'];
$planTotalTax = $row['tax'];
$planTotalFee = $row['fee'];
$userUpload = toxbyte($row['AcctInputOctets']);
$userDownload = toxbyte($row['AcctOutputOctets']);
$userOnlineTime = time2str($row['AcctSessionTime']);
$sessionTime = $row['AcctSessionTime'];
$planCurrency = $row['payment_currency'];
$planName = $row['planName'];
$planId = $row['planId'];
$payer_email = $row['business_email'];
$username = $row['Username'];
$grossGain = $planTotalCost - ($planTotalTax + $planTotalFee);
include 'library/closedb.php';
if ($drawTable == 1) {
echo "<table border='0' class='table1'>";
echo "\n \t\t<thead>\n \t\t\t<tr>\n \t <th colspan='10' align='left'> \n \t\t\t\t<a class=\"table\" href=\"javascript:toggleShowDiv('divBillingPayPalSummary')\">Billing Summary</a>\n \t </th>\n \t </tr>\n \t\t</thead>\n \t\t</table>\n \t";
echo "\n <div id='divBillingPayPalSummary' style='display:none;visibility:visible'>\n \t\t<table border='0' class='table1'>\n \t\t<thread>\n\n <tr> \n <th scope='col' align='right'>\n Username\n </th> \n \n <th scope='col' align='left'>\n {$username} (email: {$payer_email})\n </th>\n </tr>\n\n <tr>\n <th scope='col' align='right'>\n Billing for period of\n </th> \n \n <th scope='col' align='left'>\n {$startdate} until {$enddate} (inclusive)\n </th>\n </tr>\n\n <tr>\n <th scope='col' align='right'>\n Online Time\n </th> \n \n <th scope='col' align='left'>\n {$userOnlineTime}\n </th>\n </tr>\n\n <tr>\n <th scope='col' align='right'>\n User Upload\n </th> \n \n <th scope='col' align='left'>\n {$userUpload}\n </th>\n </tr>\n\n\n <tr>\n <th scope='col' align='right'>\n User Download\n </th> \n \n <th scope='col' align='left'>\n {$userDownload}\n </th>\n </tr>\n\n\n <tr>\n <th scope='col' align='right'>\n Plan name\n </th> \n \n <th scope='col' align='left'>\n {$planName} (planId: {$planId})\n </th>\n </tr>\n\n\n <tr>\n <th scope='col' align='right'>\n Total Plans Cost <br/> Total Transaction Fees <br/> Total Transaction Taxs\n </th> \n \n <th scope='col' align='left'>\n {$planTotalCost} <br/> {$planTotalFee} <br/> {$planTotalTax}\n </th>\n </tr>\n\n\n <tr>\n <th scope='col' align='right'>\n Gross Gain\n </th> \n \n <th scope='col' align='left'>\n {$grossGain} {$planCurrency}\n </th>\n </tr>\n\n </table>\n\n \t\t</div>\n \t";
}
}
if ($orderType == "asc") {
$orderTypeNextPage = "desc";
} else {
if ($orderType == "desc") {
$orderTypeNextPage = "asc";
}
}
echo "<thread> <tr>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&planname={$planname}&orderBy=username&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['Username'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&planname={$planname}&orderBy=planname&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['PlanName'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&planname={$planname}&orderBy=sessiontime&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['UsedTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&planname={$planname}&orderBy=plantimebank&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['TotalTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t" . $l['all']['TotalTraffic'] . " (" . $l['all']['Bytes'] . ")</a>\n\t\t</th>\n </tr> </thread>";
while ($row = $res->fetchRow(DB_FETCHMODE_ASSOC)) {
$perc = number_format($row['sessiontime'] / $row['planTimeBank'] * 100, 2);
if ($perc - 100 > 0) {
$percFormatted = "<font color='red'>{$perc}</font>";
} else {
$percFormatted = "{$perc}";
}
printqn("<tr>\n <td> <a class='tablenovisit' href='javascript:return;'\n\t\t\t\t\t\tonClick='javascript:ajaxGeneric(\"include/management/retUserInfo.php\",\"retBandwidthInfo\",\"divContainerUserInfo\",\"username={$row['username']}\");\n javascript:__displayTooltip();'\n tooltipText='\n\t\t\t\t\t\t\t\t<a class=\"toolTip\" href=\"bill-pos-edit.php?username={$row['username']}\">\n\t {$l['Tooltip']['UserEdit']}</a>\n <br/><br/>\n\n <div id=\"divContainerUserInfo\">\n Loading...\n </div>\n <br/>'\n\t\t\t\t\t\t\t\t\t>{$row['username']}</a>\n </td>\n\t\t\t\t<td> {$row['planname']} </td>\n\t\t\t\t<td> \n\t\t\t\t\t" . time2str($row['sessiontime']) . "\n\t\t\t\t\t<b>({$percFormatted})%</b>\n\t\t\t\t\t</td>\n\t\t\t\t<td> " . time2str($row['planTimeBank']) . " </td>\n\t\t\t\t<td> " . toxbyte($row['upload'] + $row['download']) . "</td>\n\t\t</tr>");
}
echo "\n <tfoot>\n <tr>\n <th colspan='12' align='left'>\n ";
setupLinks($pageNum, $maxPage, $orderBy, $orderType, "&username={$username}&startdate={$startdate}&enddate={$enddate}&planname={$planname}");
echo "\n </th>\n </tr>\n </tfoot>\n ";
echo "</table>";
include 'library/closedb.php';
?>
</div>
<?php
include 'include/config/logging.php';
?>
